import csv files
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 !
++
Comments are currently closed for this discussion. You can start a new one.
Keyboard shortcuts
Generic
? | Show this help |
---|---|
ESC | Blurs the current field |
Comment Form
r | Focus the comment reply box |
---|---|
^ + ↩ | Submit the comment |
You can use Command ⌘
instead of Control ^
on Mac
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.
Frederik De Bleser closed this discussion on 21 Dec, 2012 10:24 PM.
gregoire.cliquet re-opened this discussion on 22 Dec, 2012 02:46 PM
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× 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
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/
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 ?)
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
Frederik De Bleser closed this discussion on 22 Dec, 2012 03:54 PM.