Home → General Discussion →

import csv files

• Edit

gregoire.cliquet

09 Dec, 2012 09:46 PM

I just discovered NodeBox and find it VERY very exciting^{^,} congratulations for the work done !
These questions about importing .csv files :
1/ Do you plan that your import filter would support UTF file format ?
2/ More generally, could it be possible also to define type of data, for instance, text format seems requiring "" that aren't always used in .csv... and I also noticed that time was strangely interpret.
Or maybe, as I'm just starting using NodeBox, I didn't find out how to make it !
++

1. Support Staff 1 Posted by Frederik De Ble... on 21 Dec, 2012 10:24 PM

   

   For the format: We expect the CSV to always be in UTF-8.

   You cannot define the column type. Instead, NodeBox assumes it's all text, unless all of the cells for a certain column contain numbers. Then, the column is treated as a (floating-point) number.

   Dates are regarded as strings, so whatever Excel / Google Docs saves in that column, that's how NodeBox picks it up. We're working on adding date parsing as well.

   • Edit

2. Frederik De Bleser closed this discussion on 21 Dec, 2012 10:24 PM.

3. gregoire.cliquet re-opened this discussion on 22 Dec, 2012 02:46 PM

4. 2 Posted by gregoire.clique... on 22 Dec, 2012 02:46 PM

   

   Hi Frederic, Thank you for your answer, unfortunately you"closed" the
   discussion...

   OK using UTF-8 as coding works for csv BUT, dates&times are still very very
   strange :
   For instance :
   02/08/2011 is translated as "2.0" !!
   and
   11:30:02 is imported as "11.0"
   Regards

   • Edit

5. Support Staff 3 Posted by Frederik De Ble... on 22 Dec, 2012 03:24 PM

   

   This was a problem in 3.0.28, where NodeBox would just look at the first "number-like" thing. This is corrected in the latest version (3.0.29) – could you try again in that version?

   http://nodebox.net/download/

   • Edit

6. 4 Posted by gregoire.clique... on 22 Dec, 2012 03:39 PM

   

   Hi Frederik,
   You right ! 3.0.28 do the job perfectly ;-)
   Thanks !!
   (anyway to get automatic notifications for new versions of nodebox ?)

   • Edit

7. Support Staff 5 Posted by Frederik De Ble... on 22 Dec, 2012 03:54 PM

   

   Starting from 3.0.29 you will get update notifications again.

   There was a bug in the update mechanism which means that all versions before 3.0.29 do not report any new versions (although they check for it). From now, you'll be warned, though.

   F

   • Edit

8. Frederik De Bleser closed this discussion on 22 Dec, 2012 03:54 PM.