File formats for importing and exporting

Before importing information, you need to export the data from its current software and save it in a format compatible with your company file. For example, if you use a spreadsheet program to track your data, you will need to export to a file format that your software can read.

Tab-delimited and comma-separated files

▪

Tab-delimited files contain fields that are separated by tab characters. For example, if a tab character appears between Brewster and Roundhill in a file of customer information, the file counts Brewster and Roundhill as two separate fields in a record. Tab-delimited files are a common export format in spreadsheet programs.

▪

Comma-separated files contain records that are separated by commas. For example, if a comma appears between Brewster and Roundhill in a file of customer information, the file counts Brewster and Roundhill as two separate fields in a record. Comma-separated files are often used by popular database programs.

If you’re exporting data from your software for use in another software program, use the format that is accepted by that program. (If you’re not sure which format is accepted, check the documentation that came with the software program.)

If you’re exporting data for use in another software company file, you can choose either format, since software accepts both. To make the process easy, comma-separated is automatically selected. Comma-separated is also automatically selected during the import process.

Header and Data records

Before you begin the process to import, you’ll choose whether the first record in the import file is a header record or a data record.

▪	Header records are usually used as titles in import files; for example, some header records of customers might be titled “Customer Name”, “Address” and “Telephone Number”. Header records don’t contain actual data.

If you choose Header Record, it is assumed that the first record in the import file doesn’t contain any valid data, and won’t attempt to import this information.

▪	Data records are actual information that you want to include in your company file.

If you choose Data Record, it is assumed that the first record in the import file contains valid data (regardless of whether it does or doesn't), and will attempt to import this information.

Identifying the records you want to import

When you import Cards, Sales, Purchases, Activity Slips, Timesheets, Disbursements and Receipts, you can identify the records you want to import by using the Identify xxx by field. You have three choices; you can select by Card Co./Last Name, Card ID or Record ID.

▪	If you choose Identify xxx by Card Co./Last Name, every record must have a customer card with a Co./Last Name assigned to it in order for you to begin the import process.

▪	If you choose Identify xxx by Card ID, every record must have a customer card with a Card ID assigned to it in order for you to begin the import process.

▪	If you choose Identify xxx by Record ID, every record must have a Record ID assigned to it.

When you import Reminder Logs, you have two choices: by Card or by Reminder Log Record ID.

Use blank lines between records when importing

A record is an organised collection of information about an individual piece of accounting data. For example, information about a single sale or purchase is stored as one record.

When importing sales, purchases, inventory adjustments and journal entries, a blank line must be entered between each record; that is, there must be a line between each sale, purchase, inventory adjustment or journal entry. The blank line marks the end of the record when it is imported into an company file.

If no blank line is entered to separate each record, all of your records could be imported as one long record instead of as individual records.

Importing from an AccountEdge company file

If you’re importing information that was exported from another software company file, a blank line was entered between records in the file during the export process.

Importing from other software

If you’re importing information that was exported from other software, be sure the file has a blank line between each type of record. If the file you want to import doesn’t have a blank line between each record, you may want to open the file using a text editor (such as Textor Microsoft Word ) or a word processing or spreadsheet program and insert the blank line. You can create a blank line by pressing Return between each record’s data.

An example

The following illustration shows an import file with no blank lines between the records. In this case, all of the sales will be imported as only one sale.


Co./Last Name	Inv. No.	Date	Item Number	Qty	Total

Boffo Products	83	4/5/16	200-101A5	10	405.00
Boffo Products	83	4/5/16	700-101U7	80	8,424.00
Boffo Products	97	6/7/16	800-101R9	10	1,197.00
Acme Sales	109	9/10/16	800-101R9	100	11,704.00
West Industries	245	11/12/16	200-101A5	100	2,500.00
West Industries	245	11/12/16	200-101A7	100	2,250.00

The following illustration shows the same import file with blank lines inserted between the records. Each sale will be viewed separately and four sales will be imported.


Co./Last Name	Inv. No.	Date	Item Number	Qty	Total

Boffo Products	83	4/5/16	200-101A5	10	405.00
Boffo Products	83	4/5/16	700-101U7	80	8,424.00

Boffo Products	97	6/7/16	800-101R9	10	1,197.00

Acme Sales	109	9/10/16	800-101R9	100	11,704.00

West Industries	245	11/12/16	200-101A5	100	2,500.00
West Industries	245	11/12/16	200-101A7	100	2,250.00