Import from a CSV or Excel file
|FIRST TOPIC BACK PREVIOUS TOPIC NEXT TOPIC|
MENU: TOOLS > IMPORT / EXPORT DATA > IMPORT FROM CSV FILE
MENU: TOOLS > IMPORT / EXPORT DATA > IMPORT FROM EXCEL FILE
eForms Standard & Enterprise Only (Other eForms versions can import the first three records of a CSV or Excel file for evaluation)
NOTE: Microsoft Excel must be installed on your computer for eForms to use the Import form Excel File function but is not required when importing from CSV
1. When importing using eForms Standard, each CSV file or sheet in an Excel spreadsheet must contain data for one company and one slip type only. When importing using eForms Enterprise, each CSV file or sheet in an Excel spreadsheet can contain multiple companies by entering the company name(s) under COMPANY.NAME1 column (and, optionally, a company tag under COMPANY.COMPANYTAG column) to distinguish between the companies that each slip will be imported into. Each CSV file or Excel sheet will be imported separately.
2. Enter the appropriate key in cell A1 to designate the type of data being imported (use of the same key in the other cells in column A is not required). Refer to the appropriate section under Headings for Import Files for the keys for each type of form.
3. Complete the first row by adding the headings that eForms expects for the type of data being imported. See the section Headings for Import Files for the headings for each slip type. There is no need to include columns for every heading (nor, other than cell A1, need they be in any specific order); only include columns for which data exists that will be imported. Additionally, if you have a column or row of data in your spreadsheet that you do not wish to import, you can force eForms to ignore it by entering "NULL" in the top cell of a column (to ignore the column) or in the first cell of a row (to ignore the row).
4. Make sure that the data in each column matches the headings. For example, if the city and province were exported to a single column in the source data, you will need to move the province to the PROV column and the city to the CITY column. A typical import file should look something like this:
Sample data in a CSV import file
Sample data in an Excel import file
A common problem when creating an Excel import file is the presence of empty cells beyond the data cells; this will cause the import process to report an error condition. To correct this problem, simply copy and paste your data cells into a new sheet and import from the new sheet.
COMPANY.NAME1 (eForms Enterprise Only)
The COMPANY.NAME1 is used exclusively by eForms Enterprise to enable importing data for multiple payers/employers/companies. To use this field simply enter the name of a company already existing in the eForms database for each slip to be imported to that company and the data will be saved to the appropriate company during import. COMPANY.NAME1 is a text field that can contain up to 30 characters.
COMPANY.COMPANYTAG (eForms Enterprise Only)
The COMPANY.COMPANYTAG heading is used to exclusively by eForms Enterprise to enable importing data for multiple payers/employer/companies with the same name. To use this field simply enter the tag you wish to use to distinguish one company from another with the same name. The COMPANY.COMPANYTAG heading MUST be used in conjunction with the COMPANY.NAME1 heading, otherwise data will not be imported. COMPANY.COMPANYTAG is a text field that can contain up to 30 characters.
5. Save and close the import file. NOTE: All instances of the import file must be closed before continuing to the next step.
6. Start eForms. From the Tools menu, choose Import and then Import from CSV or Import from Excel File, as appropriate
7. Browse to the location of the import file you just created.
8. If you're importing from Excel, you must indicate the sheet from which you wish to import data. The Type of data records in this sheet field should indicate the correct data type automatically.
9. eForms Enterprise Only - Indicate whether you wish to Import into current company, Import into a new company or Import into companies in the Company.Name1 column. If you select Import into a new company, you will be prompted for a new company name. You will need to edit the company profile at a later time to complete the data entry for the company information. If you select Import into companies in the Company.Name1 column, the data for each slip will be imported into the company indicated in the Company.Name1 column.
10. Click Import. eForms will add the slip data to the indicated company. If there are already slips of the selected type in the company, the imported data will be appended as additional slips. A summary for the return will be created or updated as required. If you have a company with 10 T4 slips and you import 15 more T4 slips, eForms updates the T4 summary with the totals of all 25 slips.
Add/Update Options (eForms Enterprise Only)
eForms Enterprise enables a far more granular data import than other versions. Using eForms Enterprise it is possible to import data into an existing company without overwriting data already existing within that company.
Add new slips to the database
Data for the slip in question will be added to the data existing in eForms Enterprise as a new slip. If the slip already exists in the eForms database it will be overwritten
Update existing slips based on linking field (eForms Enterprise Only)
This option will update existing data in the eForms Enterprise by use of the linking field. The linking field can be any field that is unique to each recipient; such as SIN. During the import existing data for the recipients indicated by the linking field will be updated with the data appearing in the import file. If no existing recipient is found matching the linking field you can use the When linking field is missing or not found option to either stop processing the import data or skip the record for which no linking field is found.