import csv files

gregoire.cliquet's Avatar

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

    Frederik De Bleser's Avatar

    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.

  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

    gregoire.cliquet's Avatar

    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

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

    Frederik De Bleser's Avatar

    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/

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

    gregoire.cliquet's Avatar

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

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

    Frederik De Bleser's Avatar

    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

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

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

Recent Discussions

17 Apr, 2025 09:51 PM
17 Apr, 2025 07:02 PM
16 Apr, 2025 10:59 PM
14 Apr, 2025 10:55 PM
14 Apr, 2025 10:18 PM

 

13 Apr, 2025 11:09 PM
10 Apr, 2025 11:30 PM
10 Apr, 2025 10:16 PM
10 Apr, 2025 10:02 PM
03 Apr, 2025 04:44 PM
30 Mar, 2025 02:09 AM