Apologise for any double posting --
---------------------------- Original Message ----------------------------
Subject: Re: [GRASS-user] Import Point from *.csv Problem
From: Jón Eiríksson <jeir@hi.is>
Date: Tue, January 24, 2012 12:04 pm
To: "Johannes Radinger" <JRadinger@gmx.at>
Cc: "GRASS user list" <grass-user@lists.osgeo.org>
--------------------------------------------------------------------------
Hello,
your input file contains four (columns 2 and 3, line positions 9,13,19,23)
ascii = zero characters (show up in BBEDIT-text-view- show invisibles).
I removed these, and replaced ; with tab - ran this (using fs=tab but fs=,
also works, not fs=;):
GRASS 6.4.2svn (nc_spm_07):~ > v.in.ascii input=InputForGRASS_rev.csv
out=test skip=1 fs=tab col='x integer, y integer, z integer'
Scanning input for column types...
Maximum input row length: 23
Maximum number of columns: 3
Minimum number of columns: 3
Column: 1 type: integer
Column: 2 type: integer
Column: 3 type: integer
Importing points...
100%
Populating table...
Building topology for vector map <test>...
Registering primitives...
80 primitives registered
80 vertices registered
Building areas...
100%
0 areas built
0 isles built
Attaching islands...
Attaching centroids...
100%
Number of nodes: 80
Number of primitives: 80
Number of points: 80
Number of lines: 0
Number of boundaries: 0
Number of centroids: 0
Number of areas: 0
Number of isles: 0
v.in.ascii complete.
GRASS 6.4.2svn (nc_spm_07):~ >
I attach the revised input file.
Jon
Hello,
I try to import Points from a comma separated file in GRASS 6.4.2SVN on
my Mac OS X but somehow I fail...The original file is a 3-column Excelsheet (ID,X,Y). I saved that sheet as
a *csv in my Excel 2011 on Mac OS X and then I try to import it. I follow
the steps in this video (exept that I am working on
Mac):http://www.youtube.com/watch?v=JgQBPoJeeLY(Tue Jan 24 11:05:42 2012)
v.in.ascii input=/Users/.../InputForGRASS.csv output=Stations fs=; skip=1
x=2 y=3
Scanning input for column types...
Maximum input row length: 31
Maximum number of columns: 2
Minimum number of columns: 2
ERROR: y column number > minimum last column number
(incorrect field separator?)
(Tue Jan 24 11:05:42 2012) Command finished (0 sec)So I opened the file with textwrangler to check it. I changed the line
endings from the original mac endings(CR) to Unix style (LF) and saved the
file again, but I get the same error. I don't know what I am doing wrong.
Even if I copy and paste the coordinates from the text file into the
dialog I get the error. I also tried it with G6.5SVN (some weeks old)I attached the original *.csv file so maybe someone of you can tell me
what is wrong with my import.Thanks for your help in advance.
/johannes
--
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail
_______________________________________________
grass-user mailing list
grass-user@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/grass-user
(attachments)
InputForGRASS_rev.csv (1.93 KB)