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

5 replies Last reply

  1. 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 !
    ++

    Copy link
  2. 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.

    Copy link
  3. 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

    Copy link
  4. 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?

    http://nodebox.net/download/

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

    Copy link
  6. 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

    Copy link

Know something that helps?

Sign in with your email address to reply. No password needed.

Sign in to reply