Importing Data Using Import Sets - sys_import.do

[#1]

I am trying to populate an import set that I have created using the sysparm_import_set_tablename parameter. However I am finding that new import sets are created when the script is run - the new import set has the same name as the existing import set but with an Upper case initial letter. I've also noticed that underscores are replaced with spaces. The new import set is populated with values but I can't then assign a transform map to that import set.

Could someone let me know where I'm going wrong? Are there any rules or guidelines available that I should know about?

many thanks
john naughton

[rilinda_lamllar]

Hi Johnny,

Yes, that's what I did. My data source name is "test.csv.zip (Uploaded)", my file name is "test.csv.zip" and I am putting in the File name field "test.csv.zip". Still duplication

Thanks in advance,

Linda

[johnnyjava]

I would goto your List View on the Data Sources and add all of the columns to your view. (use the gear icon)

Then filter for the data source you are interested in and compare each field to see what the newly created one lacks from the one you want it to use.

Feel free to post an image.

[rilinda_lamllar]

Many thanks Johnny,

I found the issue, I had a space in the import set table name, plus I had to add 'csv' to my zip file name so that the file format was recognized properly.

Best regards

[johnnyjava]

I believe the url parameter that enables this is: 'sysparm_transform_after_load' and the value of 'true'.

Transform Maps are tied directly to the import table, so make sure your map is listed for that table. If you have more than one, you should make certain to set their order.