Importing CSV with blank columns
- Brian Murphey
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 18
26 Jul 2016 11:36 #2911
by Brian Murphey
Replied by Brian Murphey on topic Importing CSV with blank columns
That is what I needed to know. Thanks -
-Brian
-Brian
Please Log in to join the conversation.
- Daniel
- Offline
- Administrator
-
26 Jul 2016 11:29 #2910
by Daniel
Thanks
Daniel
Replied by Daniel on topic Importing CSV with blank columns
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 to join the conversation.
- Brian Murphey
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 18
26 Jul 2016 11:25 #2909
by Brian Murphey
Replied by Brian Murphey on topic Importing CSV with blank columns
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
-Brian
Please Log in to join the conversation.
- Daniel
- Offline
- Administrator
-
26 Jul 2016 11:21 #2908
by Daniel
Thanks
Daniel
Replied by Daniel on topic Importing CSV with blank columns
Hello Brian,
We can customise the tool for you. Please contact the Sales team via Contact us form.
We can customise the tool for you. Please contact the Sales team via Contact us form.
Thanks
Daniel
Please Log in to join the conversation.
- Brian Murphey
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 18
26 Jul 2016 10:45 #2907
by Brian Murphey
Replied by Brian Murphey on topic Importing CSV with blank columns
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
-Brian
Please Log in to join the conversation.
- Daniel
- Offline
- Administrator
-
26 Jul 2016 06:10 #2906
by Daniel
Thanks
Daniel
Replied by Daniel on topic Importing CSV with blank columns
Hello Brian,
What do you want vData to do after recognising the blank columns?
What do you want vData to do after recognising the blank columns?
Thanks
Daniel
Please Log in to join the conversation.
- Brian Murphey
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 18
25 Jul 2016 20:23 #2905
by Brian Murphey
Importing CSV with blank columns was created by Brian Murphey
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
Thanks -
-Brian
Please Log in to join the conversation.