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

TXT


Set correspondence between the source text file columns and the target MySQL table fields:

  • select a field of the target MySQL table in the Fields list;
  • double-click in the text viewer area to add vertical separators delimiting the source column bounds;
  • click the area between the separators to assign the column to the selected target table field - the selected source column gets black highlight;
  • repeat the operation for all the fields you need to be included in the import process.

 

The Fields list also allows you to view the following values:

P represents the starting point of your selection;

S displays the width of the selected area.

You can change these parameters manually or by moving the slider in the grid.

 

If necessary, you can choose to skip a defined number of the source file lines using the Skip lines spin-edit.

If the source text file and the destination MySQL table have the same order of columns, you can use the btnAutoFillColumns Autofill Columns button to set correspondence between them automatically.

 

The source file character set can be defined at the Encoding field.

 

CheckBox Autoscroll

This option scrolls the document automatically when you switch to the next field for mapping.

 

When you import data to a newly created table, the Analyze button appears. Use this button for automatic field creation.

 

Step 3 - TXT

 

 

To remove all correspondences, press the btnClearAllRanges Clear All Ranges button.

 

If you choose to import data to the newly created table, at this step you need to create necessary fields. Use the corresponded context menu item to manage fields.

 

menuEditField

 

Note: If table was properly created or already exist, it will be marked with a tick Tick. If an error occur during table creation, this table will be marked with a cross .

 

Click the Next button to proceed to the Setting base data formats step of the wizard.