[Qgis-user] QGis for bird surveys

[Alessandro Sarretta]

You could try saving the .xls file as .csv (Comma Separated Values) and 
then import it with the default "Add delimited text layer" plugin.
You shouldn't have any compatibility issue with it.
Ale

On 04/05/2013 08:22 AM, Lynkos wrote:
> I've just tried using the XY tools plug-in, but I get the message: 
> "There is a problem with loading a python module which is needed to 
> read/write Excel files. Please see documentation/help how to install 
> python xlw and xlrd libraries". I've tried following the instructions 
> to install the libraries, but to no avail. Once again, I come up 
> against my lack of experience and also lack of time to invest in 
> learning. I think my best bet for the moment is to adopt the simplest 
> of approaches, using a text file which given my limited amount of data 
> should work fine.
> Thanks again to you all and I hope one I'll be able to get down to 
> learning some of the basics which would undoubtedly be of great help.
>
>
> 2013/4/4 Michael Harte <mharte at ozemail.com.au 
> <mailto:mharte at ozemail.com.au>>
>
>     Sarah,
>
>     To expand on what Rudi, Goyo, and Andreas have suggested with
>     regard to converting data stored in spreadsheets and or text files
>     to shapefiles I follow a work flow like:
>
>         1. Install "XY tools" using the Plug-in Manager (in menu - Plugins... Fetch Plug-ins... type xy in filter... XyTools 0.3.2... install);
>         2. After installation XY tools is found under the "Vector" menu item - make sure it is activated with a tick under "Plug-ins... Manage Plug-ins...";
>         3. Click "Vector... XY tools... Open Excel file as attribute table or point layer";
>         4. In dialogue box designate the columns in the spreadsheet that are the X and Y coordinates (Longitude or Easting = X; Latitude or Northing = Y) and click OK;
>         5. In the table of contents you will see a new layer called "Temporary Layer (volatile)"  SAVE THIS LAYER (see below - if you don't it will disappear when you close your project);
>         6. Right click the temporary layer name and click "Save As..." (remember to set your coordinate system - CRS - easiest if it is the same as "Project CRS");
>
>             This will save your data as an ESRI format shapefile
>
>         7. Tick the "Add saved file to map box in the Save As... dialogue; and
>         8. Apply desired symbology to the new layer.
>
>     I hope I haven't insulted you with the step by step. Sometimes its
>     nice just to have a cookbook for new tasks.
>
>     The advantage of this workflow is that you can stick with using a
>     spreadsheet to organise and store your data.  The XY tools plug-in
>     works with both MS Excel and Libre Office Calc spreadsheets.  You
>     never have to worry about converting your data to a text file. 
>     You can make separate files for each year's data or just keep
>     concatenating new data onto your spreadsheet and creating an
>     updated shapefile whenever you want to display the new data.  All
>     of your attributes should be carried over into the newly created
>     shapefile.  Make sure you have a header row with column headings
>     in the first row of the spreadsheet and no blank rows in the body
>     of the spreadsheet.
>
>     Hope this helps.
>
>     cheers,
>     Mike
>
>     -- 
>
>
>
>
>
>
> -- 
> Con altri occhi - parole e immagini dalla parte della natura
> www.lynkos.net <http://www.lynkos.net>
>
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user


-- 
Alessandro Sarretta

e-mail: alessandro.sarretta at gmail.com
skype: alesarrett
Web: http://ilsarrett.wordpress.com
Twitter: https://twitter.com/alesarrett
Google scholar: http://scholar.google.it/citations?hl=it&user=IsyXargAAAAJ
ORCID: http://orcid.org/0000-0002-1475-8686
ResearchGate: https://www.researchgate.net/profile/Alessandro_Sarretta/

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