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

[Jón Eiríksson]

Apologise for any double posting --
---------------------------- Original Message ----------------------------
Subject: Re: [GRASS-user] Import Point from *.csv Problem
From:    Jón Eiríksson <jeir at hi.is>
Date:    Tue, January 24, 2012 12:04 pm
To:      "Johannes Radinger" <JRadinger at gmx.at>
Cc:      "GRASS user list" <grass-user at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/grass-user
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: InputForGRASS_rev.csv
Type: text/csv
Size: 1898 bytes
Desc: not available
Url : http://lists.osgeo.org/pipermail/grass-user/attachments/20120124/f923632d/InputForGRASS_rev.bin