MapWindow 4 - Desktop Application : MapWindow Discussion Forum
How does one bring in data from a spreadsheet so that it is numeric? I can get data in with the Import function, but the only thing that shows as numeric is the MWShapeID. Apparently the numeric data all comes in as text.
excel spreadsheet data
Posted by:
spacegnome ()
Date: January 12, 2012 03:35PM
How does one bring in data from a spreadsheet so that it is numeric? I can get data in with the Import function, but the only thing that shows as numeric is the MWShapeID. Apparently the numeric data all comes in as text.
Re: excel spreadsheet data
Posted by:
bmarch ()
Date: January 13, 2012 07:48AM
Hi Spacegnome,
I'm not sure why its importing the numeric fields as text. You can always try using the field calculator in the attributes window of your data to create a new column and populate it will numeric data.
The other thing you might want to try it opening your excel file and make sure the data type for numeric columns is set to numeric and not general or text. Although I'm not even sure if that information is used by the import tools.
Brian M.
I'm not sure why its importing the numeric fields as text. You can always try using the field calculator in the attributes window of your data to create a new column and populate it will numeric data.
The other thing you might want to try it opening your excel file and make sure the data type for numeric columns is set to numeric and not general or text. Although I'm not even sure if that information is used by the import tools.
Brian M.
Re: excel spreadsheet data
Posted by:
spacegnome ()
Date: January 13, 2012 01:42PM
I have checked and reentered the spreadsheet data, and it is definately numeric in the spreadsheet.
I could make the data by hand as you say, but would much rather be able to import the spreadsheet data as it is a large data set.
Edited 1 time(s). Last edit at 01/13/2012 01:43PM by spacegnome.
I could make the data by hand as you say, but would much rather be able to import the spreadsheet data as it is a large data set.
Edited 1 time(s). Last edit at 01/13/2012 01:43PM by spacegnome.
Re: excel spreadsheet data
Posted by:
spacegnome ()
Date: January 21, 2012 10:06AM
So that's it then, it just doesn't work?
Re: excel spreadsheet data
Posted by:
paulwatson82 ()
Date: February 08, 2012 12:41PM
Hey Spacegnome I haven't had much luck importing excel data directly into Mapwindows but I have found a way around it. Using Openoffice Calc (free opensource software for spreadsheets) you can open the dbf file for the shape you want to work with. The dbf file is just a spreadsheet. I've been manually transferring data via cut and paste from my excel spreadsheets into the dbf.
The reason for using open office is that the dbf is just a csv file. But Excel 2010 doesn't let you resave the dbf in a format that will still function in MapWindow. Openoffice on the other hand doesn't have this issue.
hope this helps. Any questions about the process feel free to email me. paulwatsonnbcc@gmail.com
Paul M Watson
The reason for using open office is that the dbf is just a csv file. But Excel 2010 doesn't let you resave the dbf in a format that will still function in MapWindow. Openoffice on the other hand doesn't have this issue.
hope this helps. Any questions about the process feel free to email me. paulwatsonnbcc@gmail.com
Paul M Watson
Re: excel spreadsheet data
Posted by:
Sawlog ()
Date: February 13, 2012 10:11AM
I followed these steps and got all kinds of atributes attached to layers (stuff like plot numbers, trees per acre, basal area, volume, percent crown cover). These steps came from Paul. They steps are as follows:
1. Start a new project.
2. Go to the statusbar and click on the projection (far left). Select WGS84.
3. Now import the csv using the import option of the spatial converter.
You'll get a question what to do with the new layer.
4. Select Assign projection from project.
Now I see in the statusbar Lat: xx.xxx Long: -xx.xxx
5. Go to the toolbox and select 'Reproject shapefile'
1. Start a new project.
2. Go to the statusbar and click on the projection (far left). Select WGS84.
3. Now import the csv using the import option of the spatial converter.
You'll get a question what to do with the new layer.
4. Select Assign projection from project.
Now I see in the statusbar Lat: xx.xxx Long: -xx.xxx
5. Go to the toolbox and select 'Reproject shapefile'
Re: excel spreadsheet data
Posted by:
northboy ()
Date: March 20, 2012 04:14PM
hi Spacgnome,
I got the same problem. The source of this little annoyance was in my case a different setting in Windows for the decimal separator. Mapwindows needs a point as decimal separator, change it in Windows and it should work.
Kind regards,
Jan
I got the same problem. The source of this little annoyance was in my case a different setting in Windows for the decimal separator. Mapwindows needs a point as decimal separator, change it in Windows and it should work.
Kind regards,
Jan
Sorry, only registered users may post in this forum.
