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 !
++
The new NodeBox forum is live! Everything from support.nodebox.net moved here: sign in with the same email to pick up your old posts. Something not working? Write to forum-support@nodebox.net.
General DiscussionFrom the old forum
import csv files
-
-
NodeBox team 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.
-
Hi Frederic, Thank you for your answer, unfortunately you"closed" the
discussion...OK using UTF-8 as coding works for csv BUT, dates× 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 -
NodeBox team 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?
-
Hi Frederik,
You right ! 3.0.28 do the job perfectly ;-)
Thanks !!
(anyway to get automatic notifications for new versions of nodebox ?) -
NodeBox team 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