Import Tips

Perform small, practice imports before importing hundreds of records.

When you are perfecting an import file using Excel to work with an import format, be sure you save the file. If you change an Excel file, but don’t save it, the unsaved file will be the one that is imported.

When testing an import file, copy a small portion of it (a few rows) to a new file. The test file will import faster, and you will be able to locate problems faster than if you import the entire file.

As you are testing a format, don’t use “Add to List” for importing fields with drop down lists until you are certain the import format is importing that field properly. Otherwise, you may end up with a lot of bad entries in your library for that field that you will have to delete, one at a time.

The import file must be in a text format (comma or tab delimited); it cannot be an application-specific file. For example, do not import files in the traditional Excel “.xls” format. Select File-Save As, and choose “.csv” (comma delimited) or “.txt” (tab delimited) from the “Save as type” dropdown prior to importing. Choose “.txt” when importing data that already contains commas, such as a notes field containing text or a field such as “Last Name, First Name”.

All fields in the import file must also exist in Freezerworks prior to import.

Field lengths in the import file must be less than or equal to the destination field in Freezerworks.

Field types must match the destination field (alphanumeric (e.g., a b c & @ # + ) data will not import into a numeric field).

Numbers imported into the Internal Bar Code ID field must be unique.

Date and time formats must be taken into account. Your import file may contain dates and times that are formatted differently from the computer’s system date and time. Indicate these formats on the Properties tab of the Import format. Freezerworks will convert the dates and/or times into the system format.

Note: The import file cannot contain multiple date and/or time formats. Convert all dates and times to one format before importing.