EMS logo

Products Navigation

Data Import for MySQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Import for MySQL

On-line Documentation

Step 5 - Setting base data formats


This step of the wizard provides a number of options for setting base formats for each source data file. The specified format should match the source data representation.

 

Step 4

 

 

Separators

Decimal, Thousand, Date, Time

 

Decimal

Set a character to delimit the decimal parts of the imported numbers.

Thousand

Set a character to separate the digit groups in the imported numbers.

Date

Set a character to separate the year, month and day parts of date values.

Time

Set a character to separate the hour, minute and second parts of time values.

 

Constants

 

Boolean True

Set one or more variants of TRUE value representation in the imported table, e.g. 'Yes' or '+'. Use a new line for each additional variant.

 

Boolean False

Set one or more variants of FALSE value representation in the imported table, e.g. 'No' or '-'. Use a new line for each additional variant.

 

Null Values

Set one or more variants of NULL value representation in the imported table, e.g. 'Null'. Use a new line for each additional variant.

 

Date/Time formats

Use these edit fields to set the date and time formats: Date, Time.

 

For more information refer to the Format specifiers page.

 

 

CheckBox Skip this step

Check this option to skip the current step in the future. To edit the list of skipped steps, use the Skipped Steps group available in the General section of the Preferences dialog.

 

When you are done, press the Next button to proceed to the next step.