Skip to main content

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

Hi John,
I think you can add the column name using the # at the beginning of the row, but I am not so sure...
Regarding the second error, do you have an empty line at the end of the file? try to delete this. Do the wizard recognize the different columns where you can select the column for x and y and the name of the others attributes?

Silvia


On 06/05/2012 06:57 PM, John Brisbin wrote:
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


_______________________________________________
udig-users mailing list
udig-users@xxxxxxxxxxxxxxxxxxxxx
http://lists.refractions.net/mailman/listinfo/udig-users

Back to the top