Changes between Initial Version and Version 1 of Ticket #4654


Ignore:
Timestamp:
May 4, 2012, 7:02:54 AM (12 years ago)
Author:
andrewxhill
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #4654 – Description

    initial v1  
    11Data exported from R (and others I'm sure), will often contain a null column name over an ID column. Something like,
    22
    3 "", "Name","Species", "Geom"
    4 1, "Boxelder", "Acer negundo", "some geom"
    5 2, "Juneberry", "Amelanchier arborea", "some geom"
     3"", "Name","Species", "Geom"[[BR]]
     41, "Boxelder", "Acer negundo", "some geom"[[BR]]
     52, "Juneberry", "Amelanchier arborea", "some geom"[[BR]]
    66
    77These files are imported to PostgreSQL (via -f "PostgreSQL") incorrectly. The data are shifted over one column, and one column is dropped. Alternatively, in the quoted example above, even a space will make the file work correctly,
    88
    9 " ", "Name","Species", "Geom"
    10 1, "Boxelder", "Acer negundo", "some geom"
    11 2, "Juneberry", "Amelanchier arborea", "some geom"
     9" ", "Name","Species", "Geom"[[BR]]
     101, "Boxelder", "Acer negundo", "some geom"[[BR]]
     112, "Juneberry", "Amelanchier arborea", "some geom"[[BR]]
     12