[Qgis-user] SOLVED -adding a CSV delimited text layer

[Marc Dupuis-Desormeaux]

fantastic, I've just downloaded OpenOffice, copied my excel values into the Open spreadsheet and created the csv and everything works just fine.  Thanks!


Marc Dupuis-Désormeaux, 

Ph.D. candidate, 
Biology (ecology and evolution)
York University
md2 at yorku.ca








On Dec 12, 2013, at 10:07 AM, Charlotte Whitham <charlotte.whitham at gmail.com> wrote:

I know, it's not the best, but I hear it's Mavericks fault? :(

Yes it's very easy - you can just write click on the excel file and go to "Open with" and then choose Openoffice.

Another friend told me the other way was to create .csv file in TextEdit but this was much more complicated, so I believe OO is the best option

Good luck and all the best,

Charlie

On 12 Dec 2013, at 15:03, Marc Dupuis-Desormeaux <marcd2 at me.com> wrote:

> Thanks Charlotte, I'll try that route.  Is it easy to import a file from excel into openoffice?  Seems like a roundabout way to create a simple .csv file!
> 
> On Dec 12, 2013, at 9:54 AM, Charlotte Whitham <charlotte.whitham at gmail.com> wrote:
> 
> Don't panic Marc! Although I completely understand as I did the same last week (using QGIS 2.0.1 and Mavericks OSX).
> 
> There appears to be issues with Microsoft Excel and Mavericks and creating csv and txt files. 
> 
> The only way I found around it was to make my .csv file in OpenOffice and it worked perfectly! 
> 
> Hope that helps!
> 
> Cheers,
> Charlie
> 
> Charlotte 夏琳 Whitham
> PhD Candidate
> Beijing Forestry University
> 
> Address: Mailbox no.159, College of Nature Conservation
> C/O Dr. SHI Kun, Director of the Wildlife Institute, Beijing Forestry University
> 35, Tsinghua-East Road,
> Beijing 100083
> China
> Website: http://wi.bjfu.edu.cn/en
> Email: charlotte.whitham at gmail.com 
> China Mobile: +86 152 0130 9411
> QQ: 1745214168
> 
> Think green: do you really need to print this email?
> 
> 
> Message: 3
> Date: Thu, 12 Dec 2013 09:32:43 -0500
> From: Randal Hale <rjhale at northrivergeographic.com>
> To: qgis-user at lists.osgeo.org
> Subject: Re: [Qgis-user] Fwd: adding a CSV delimited text layer
> Message-ID: <52A9C90B.6080107 at northrivergeographic.com>
> Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
> 
> What if you specified a custom delimiter and used comma? I'm wondering 
> if something has changed in your file....
> 
> Can you share it? or is it sensitive?
> 
> -----------------
> Randal Hale, GISP
> North River Geographic Systems, Inc
> http://www.northrivergeographic.com
> 423.653.3611 rjhale at northrivergeographic.com
> <mailto:rjhale at northrivergeographic.com>
> twitter:rjhale
> http://about.me/rjhale
> 
> On 12/12/2013 08:53 AM, Marc Dupuis-Desormeaux wrote:
>> 
>> HI!  first time question.  I am pretty comfortable with QGIS 1.8 but 
>> have just converted from 1.8 to 2.0.1 and apparently have lost my mind 
>> as I can't even upload a simple .csv file anymore.  I am using OSX 
>> (Maverick).  I have created my .csv file using excel in the usual way, 
>> by saving it from an .xlsx to a .csv as I've done many times in QGIS 1.8.
>> 
>> The file is simple, the first row has the headings 
>> (DATE,SPECIES,AGE,SEX,GPSX,GPSY,COD) the rest is data but when I'm 
>> uploading the file QGIS is not reading each line but is treating all 
>> data as one long line of headings and therefore is not finding any data.
>> 
>> Help!
>> 
>> 
>> Marc
>> 
>> 
>> 
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/qgis-user
>  
> [Qgis-user] Fwd: adding a CSV delimited text layer
> 
> On 12 Dec 2013, at 14:32, qgis-user-request at lists.osgeo.org wrote:
> 
>>  [Qgis-user] Fwd: adding a CSV delimited text layer
> 
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20131212/e7962677/attachment.html>