[GRASS-user] Import Point from *.csv Problem

[Johannes Radinger]

Thank you for your help!

it seems that excel somehow doesn't manage to produce universal and platform independent csv's (at least not excel 2011 on Mac). Anyway I just imported the execel into R and exported it to csv. The import worked now perfectly useing fs=",".

/johannes



-------- Original-Nachricht --------
> Datum: Tue, 24 Jan 2012 12:04:05 -0000 (GMT)
> Von: "Jón Eiríksson" <jeir at hi.is>
> An: "Johannes Radinger" <JRadinger at gmx.at>
> CC: "GRASS user list" <grass-user at lists.osgeo.org>
> Betreff: Re: [GRASS-user] Import Point from *.csv Problem

> 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 at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/grass-user
> >

-- 
"Feel free" - 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail