File: import_export.html

package info (click to toggle)
eqonomize 1.5.1-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 16,956 kB
  • sloc: cpp: 49,180; xml: 495; makefile: 10; sh: 6
file content (16 lines) | stat: -rw-r--r-- 6,966 bytes parent folder | download | duplicates (4)
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Chapter 8. Import &amp; Export of Transactions</title><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot"><meta name="keywords" content="Qt, Eqonomize, Money, Finances, Bookkeeping, Budget"><link rel="home" href="index.html" title="Eqonomize! Manual v1.0.0"><link rel="up" href="index.html" title="Eqonomize! Manual v1.0.0"><link rel="prev" href="statistics.html" title="Chapter 7. Statistics"><link rel="next" href="credits.html" title="Chapter 9. Credits and License"></head><body style="color:black" bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Chapter 8. Import &amp; Export of Transactions</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="statistics.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="credits.html">Next</a></td></tr></table><hr></div><div class="chapter"><div class="titlepage"><div><div><h1 class="title"><a name="import_export"></a>Chapter 8. Import &amp; Export of Transactions</h1></div></div></div><div class="toc"><p><b>Table of Contents</b></p><dl class="toc"><dt><span class="sect1"><a href="import_export.html#qif_import_export">QIF Files</a></span></dt><dd><dl><dt><span class="sect2"><a href="import_export.html#qif_import">QIF Import</a></span></dt><dt><span class="sect2"><a href="import_export.html#qif_export">QIF Export</a></span></dt></dl></dd><dt><span class="sect1"><a href="import_export.html#csv_import">CSV Import</a></span></dt><dt><span class="sect1"><a href="import_export.html#csv_html_export">CSV or HTML Export</a></span></dt><dt><span class="sect1"><a href="import_export.html#eqz-merge">Merge Eqonomize! File</a></span></dt></dl></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="qif_import_export"></a>QIF Files</h2></div></div></div>
		Files using the Quicken Interchange Format can be read by most personal money management software. The format is however old and has limitations, which means that data might be lost during import and export.
		<div class="sect2"><div class="titlepage"><div><div><h3 class="title"><a name="qif_import"></a>QIF Import</h3></div></div></div><p>
			Select <span class="guimenu">File</span> → <span class="guisubmenu">Import</span> → <span class="guimenuitem">Import QIF File</span> and follow the instructions. QIF is a file format that might differ much depending on the software that saved the file. How much details you will need to provide about the file depends on ambiguity of the date format, how localised the file is, and how well accounts are defined. Securities, investment transactions, memorised transactions, budgets, and classes are not imported.
			</p></div><div class="sect2"><div class="titlepage"><div><div><h3 class="title"><a name="qif_export"></a>QIF Export</h3></div></div></div><p>
			</p><div class="mediaobject"><img src="figures/exportqif.png"></div><p>
			Activate <span class="guimenu">File</span> → <span class="guimenuitem">Export QIF File</span> and select account to export, format for dates and numbers, and filename. It is possible to export transactions from all accounts, but multi-account QIF files are not always supported by other software. Not all transaction properties are exported.
			</p></div></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="csv_import"></a>CSV Import</h2></div></div></div><p>
			This function imports data files with clear text values in columns separated by a character (comma, space, tab, etc.), with a new transaction on each row. Select <span class="guimenu">File</span> → <span class="guisubmenu">Import</span> → <span class="guimenuitem">Import CSV File</span> and enter details about the structure of the file you want to import. Transaction parameters can either be imported from a column in the file or a set to a specified value.
			</p><div class="mediaobject"><img src="figures/csvcolumns.png"></div><p>
		</p></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="csv_html_export"></a>CSV or HTML Export</h2></div></div></div><p>
		Every account and transaction list in Eqonomize! can be saved to a HTML or CSV file. HTML files are suitable for display in a web browser and CSV (comma separated values) files can be opened in most spreadsheet programs. Use <span class="guimenu">File</span> → <span class="guimenuitem">Export View</span> or the corresponding toolbar button to save a list of accounts, expenses, incomes, transfers, securities or scheduled transactions. The displayed values will be exported (for accounts and securities the current time period is used and for transactions the current filter and sort order is adhered to). The ledger can be exported using the <span class="guibutton">Export</span> button in the upper left corner of the ledger window.
		</p></div><div class="sect1"><div class="titlepage"><div><div><h2 class="title" style="clear: both"><a name="eqz-merge"></a>Merge Eqonomize! File</h2></div></div></div><p>
		Accounts and transactions from another Eqonomize! file can be imported to the current file using <span class="guimenu">File</span> → <span class="guisubmenu">Import</span> → <span class="guimenuitem">Import Eqonomize! File</span>. All accounts and transactions from the file will be copied. When the file has been selected you will be presented with alternatives for handling of duplicate transactions, accounts, categories and securities. If you select the rename options <span class="quote">“<span class="quote">("imported")</span>”</span> will be appended to the name, otherwise the transactions will be added to the already present accounts with the same name. This makes it easier to distinguish and manipulate imported transactions. (For information on how to modify/move mmultiple transactions at the same time see <a class="xref" href="transactions.html#edit-multiple" title="Edit Multiple Transaction Simultaneously">the section called “Edit Multiple Transaction Simultaneously”</a>.)
		</p><div class="mediaobject"><img src="figures/importeqz.png"></div><p>
		</p></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="statistics.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="credits.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top">Chapter 7. Statistics </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Chapter 9. Credits and License</td></tr></table></div></body></html>