Blank column headers were found on import set
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎06-26-2013 11:05 AM
Hi all,
I'm scheduling an importing set from a FTP, regarding the tests I did works perfectly, but the acid test is when I try to upload a the file provided by the client, aparently the xls file to import is generated automatically by a system and adds an extra header blank column, I mean no one person is editing the file, so when the Scheduled Import trys to pull the file into the source table it can't; I tried to do it manually and I got the error message "Blank column headers were found", so editing the xls file and deletting the extra blank column works fine, so I was wondering if possible to avoid that column since the Transform Map with a script or something.
I already tried creating into the source table a new field with no labels and mapping it but doesn't work, is there another way to get it? any advance is very welcome.
Thanks in advance.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-08-2013 12:44 AM
The transform map will kick in in a later step, so this won't be of any help. I am not 100% sure if the import of the data fails with this error or if this is 'just' a warning. Is it a XSL file that you recieve or some kind of CSV?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-08-2013 05:47 AM
I'm receving the file as XLS, and something happens while is created on the system that at the end of all the created coulms adds a new blank colum, strange hu?, so I requested to the customer to provide the same file but as CSV, and with this format I have no issues.
I know the transform map only takes the non blank columns, but the column I'm talking about contains something, I don't know what, fortunately the customer is able to provide the file on csv format.
Thanks for asking Daniel.