Topic-icon Importing CSV with blank columns

  • Brian Murphey
  • Brian Murphey's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
26 Jul 2016 11:36 #2911

That is what I needed to know. Thanks -

-Brian

Please Log in or Create an account to join the conversation.

More
26 Jul 2016 11:29 #2910

Right now, You must have the header column. To make it work without the header column and it doesn't skip the blank columns, we'll have to make changes in the code.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Brian Murphey
  • Brian Murphey's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
26 Jul 2016 11:25 #2909

That is not a very helpful response. I already paid for vdata. I just wanted to find out if it can import blank columns without skipping them entirely.

-Brian

Please Log in or Create an account to join the conversation.

More
26 Jul 2016 11:21 #2908

Hello Brian,
We can customise the tool for you. Please contact the Sales team via Contact us form.


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Brian Murphey
  • Brian Murphey's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
26 Jul 2016 10:45 #2907

Not skip the column in the mapping during set up of the import. Currently, when I set up the import, vdata looks at the first row as the column headers. However, my client doesn't want to provide column headers, so the first row of any CSV they provide me will be an actual record. The problem is, if any of the columns of the first row are blank, vdata doesn't see them, and I am unable to map that column to a column in the database table I am importing into.

-Brian

Please Log in or Create an account to join the conversation.

More
26 Jul 2016 06:10 #2906

Hello Brian,
What do you want vData to do after recognising the blank columns?


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Brian Murphey
  • Brian Murphey's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
25 Jul 2016 20:23 #2905

I have a CSV I am trying to import as a cron. It has no column headers. Some of the columns will be blank sometimes. Is there anyway to get vdata to recognize the blank columns?

Thanks -

-Brian

Please Log in or Create an account to join the conversation.

Cron Job Starts