You are here: Help Topics > Setting up your file > Importing data to set up your file > Import Wizard - Advanced Specifications

Import Wizard - Advanced Specifications

The Advanced Specifications are options you can specify for regional settings, client/group and staff numbering, work code numbers and the date range. This wizard screen is not applicable for all imports. Use the definitions below to make your selections.

Continue to the Complete Import wizard screen after making your selections.

Regional Settings

This area enables you to override the default decimal symbol and digit grouping symbol. Regional Settings are machine-specific and configurable from Control Panel. This setting is applicable when preparing reports for foreign companies and organizations.

Use currency format in Regional Settings (uncheck to overwrite the default symbols)

This option if deselected enables you to modify the Decimal Symbol and Digit Grouping Symbol.

Decimal Symbol

This option defines the character that separates whole numbers and decimals. Select period (.) or comma (,).

Digit Group Symbol

This option defines the delimiter that separates digit groupings. Select period (.) or comma (,).

Client/Group and Staff Number

Specify the numbering method to be used when importing client, group, and staff lists.

Select the option Use Text File Number to get a unique number from the import text file and select the option Auto Increment number to generate a unique number automatically based on the entry for Start No.

Work Code Number

This area enables you to specify work code numbers when importing components WIP Opening Balances and WIP Details.

Note: If any transactions in the import file are assigned inactive work codes, the log will record an import error and Time will not import those transactions.

Use Text File Number

This option defines the work code number based on the data from your import file. If you did not map a work code number column, return to the Field Details screen and specify a Work Code Number column.

Assign to Default Work Code

This option enables you to specify a default work code number for imported values. Use the Default No field to type a default work code number.

Date Range

This area enables you to specify a date range when importing WIP Details.

All transactions

This option imports all transactions and converts dates to the current year.

Only transactions within the current year

This option imports only transactions that occur within the year set in the Company Profile.

Only within period number

This option imports only transactions that occur within the defined period. The period date is set in the Company Profile.

Only From / To

This option imports only transaction that occur within the specified period.