Data can be loaded from ASCII and Unicode files in UTf8, UTF16BE and UTF16LE formats with BOM marker and without
Unicode is a computing industry standard allowing computers to consistently represent and manipulate text expressed in most of the world’s writing systems.
To perform data mapping:
Click Data Target Options button
Dialog box will appear
Select appropriate target type
Click Get tables list
Select Table you would like to import data into from the Drop Down List
Click Transformation tab
Select Add Records
Click OK
Click Data Source Option Button
Dialog box will Appear
Set Delimiter and Quota to appropriate values
Note: If you want to load data from several files specify a mask.
Click OK. Click and select the file you would like to import data from.
Select Fist field in the Data Target fields list and drag and drop it above [F1] field.
You may change field mapping by using the mapping panel at any time.
How to perform Auto mapping
If the Data Source and Data Target have got the same fields’ names you may use the Automap feature.
Click
, Fill in all necessary data and click map.
/
Now we are ready to import data. Let’s check the script first. (Click to check the script)
Here is an example of the error, the date format is missing.
Click to load data into the database
Once loading is finished you may check the Log file or the Rejected records file.