Import csv file problems

Hi ETL-tools team, 
We are using Advanced ETL processor ENT 6.4.2.17
Used the import function to build an import action.

Source file is a csv file. After the input of related settings. The following issues are found.

Some field names cannot be detected.

The last field cannot be detected.

Used transformation function to build a transformation action with same file.

The reported issues are not found. 

Please find the csv source file, dump screens, saved import.vis and transform.ats files for reference.

Best regards,

Kenny

Hi

1. Regarding missing field please click plus to add it 
2. Fields with incorrect names F4, F5 etc right click and choose 'Set First line as filed names'

There is way to set filed names automatically, it was requested by one of our customers long time ago.
I personally do not use it because the is a chance of loosing mapping.
For example map very wide file (200+ fields) than open narrow file (5 fields) = all mapping is lost.

 

Hi Mike,

Followed your instruction and the problems are fixed. 

Just don't know why the problems are not found in transformation function.

Moreover, if the auto field name display logic of import function can be in sychronization with that of transformation function it can be more user friendly and efficiency.

Best regards,

Kenny   

>>> Regarding missing field:

There is a small issues with auto format function, we will have a look at it for you 

Regarding missing field: This issue was resolved in the latest release