![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
This section discusses how to use CSV (comma-separated value) or SSV (semicolon-separated value) format as input. For information on how to produce CSV output, go here. QIF Wizard can convert investment, banking, or credit card transactions from CSV/SSV to QIF. To perform the conversion, you must first define the format of your data. Even though QIF Wizard knows how to break CSV/SSV files into fields, it does not know what each field contains. QIF Wizard can process CSV/SSV that:
It is a good idea to have the first line of the CSV/SSV file contain text that uniquely identifies the format of this CSV/SSV file, as opposed to a transaction itself. Click here for more information on defining the format of CSV/SSV transactions. Click here for more information on extracting QIF from a CSV/SSV file once its format has been defined. Click here for information on how to edit a format once you have defined it. |
|
To be able to extract transactions a CSV/SSV file, you must teach QIF Wizard about the format of the transactions.
To define a format:
Here is an example Control dialog after a CSV format name has been entered.
When you hit return, the following dialog appears.
This dialog contains example CSV text. It is a good idea to have the first line of the file contain text that uniquely identifies the format of this CSV file. You specify four items in this dialog. The first is the type of transactions, in this case Investment. Second, you specify some text from the input that uniquely identifies this text format. In the example above the header line was selected. QIF Wizard will use this text to guess which format applies to the text in the input. This guess does not have to be perfect because you always have the opportunity to select the proper format. The third item you specify is whether the first line of the input contains a transaction. In this case you leave it unchecked, but if the CSV did not contain the header line, you would check this box. The fourth item you specify is the date in the first transaction. When you press OK in this dialog, the following one appears.
In this example you are processing CSV, so you need to click the CSV method, as has already been done above. When you click OK, you will be asked a series of questions. If you are processing SSV you would check the SSV method instead of the CSV method. The specific questions asked depends on whether this is an investment or bank/credit card format. For more information, see Defining Formats For Investment Transactions or Defining Formats For Bank/Credit Card Transactions.
Once your CSV/SSV formats is defined, QIF Wizard will allow you to confirm each transaction before it is placed in the output file. For more information, see Confirming Investment Transactions or Confirming Bank/Credit Card Transactions. When you are processing CSV/SSV format, you cannot avoid confirming each extracted transaction, because it is possible that an erroneous transaction could be extracted if there was an error in the CSV/SSV.