Using a CSV file to import data do not work.

Posted by Rollbase User on 27-Jul-2012 17:06

Hello, Using a csv file to import data do not work. Rollbase do not separate colums. It thinks there is one big column only. You see that when you do the mapping. If you have this file : A;B;C 1;2;3 Rollbase sees only one column named "A;B;C". Thank you. Matthieu

Rollbase - Forum

All Replies

Posted by Admin on 27-Jul-2012 17:13

Hi Matthieu,



Rollbase assumes separator in CSV files is a comma (,) so semicolon (;) will not be interpreted as a column separator



Hope this helps,

Matt

Posted by Admin on 30-Jul-2012 06:32

Hello Matt,



The problem is that on American Windows version the comma is set as default for the “List Separator” but on European Windows versions this character is reserved as the Decimal Symbol and the “List Separator” is set by default to the semicolon (Excel generates CSV files with semicolon in Europe)



All the CSV files generated by softwares in Europe use semicolon. And we use Rollbase to automate the creation of computer interfaces from CSV files. If we had to import data just once, it would not matter but this is not the case.



Sorry for this European exception ...



Matthieu

Posted by Admin on 30-Jul-2012 22:15

Thanks for the clarification Matthieu. We are going to evaluate handling this as an enhancement and will get back to you shortly.

This thread is closed