Skip to main content

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
[udig-users] Help with CSV import

Howdy all,
Very excited to have a go at the CSV import wizard, but cam adrift in the first effort.
My X,Y values look like this:
LAT LONG UID GardenName GardenType
-34.5655198 150.8555854 CG.0001 Barrack Heights Community Garden Community Garden
-34.36721 150.9166853 CG.0002 Bellambi Community Garden Community Garden


And on import I get this:
java.lang.NumberFormatException: For input string: ""LONG""
    at sun.misc.FloatingDecimal.readJavaFormatString(FloatingDecimal.java:1224)
    at java.lang.Double.parseDouble(Double.java:510)
    at eu.udig.tools.jgrass.csv.CsvImportWizard.csvFileToFeatureCollection(CsvImportWizard.java:217)

Hmmm, so obviously the problem is that the import wizard can't deal with the col names in the first row. This is not good as I have 50+ columns and really need to get those col headings into the import. But, nonetheless, I delete this row and proceed.

The next error looks like this:
java.lang.ArrayIndexOutOfBoundsException: 53
    at eu.udig.tools.jgrass.csv.CsvImportWizard.csvFileToFeatureCollection(CsvImportWizard.java:229)
    at eu.udig.tools.jgrass.csv.CsvImportWizard$1.run(CsvImportWizard.java:116)

So this one I'm not sure about...the lat/long values all look reasonable... I've chosen WG84 for CRS...any clues for what to do next?
Thanks heaps in advance!
JB
-- 
John Brisbin
Managing Director, BoaB interactive Pty Ltd
POB 802 Townsville, QLD 4810

M: 0407 471 565 | P: 07 3103 0574
Skype: boabjohn | Twitter: @boabjohn

Back to the top