File conversion data loss
 |
 16 years
|
Whenever I’m building POI files, I usually start with a spreadsheet. I like to see the POI data in front of me in a column format because it’s easy to spot missing or incorrect data. It’s easy enough to save it as csv file and convert it to a gpx file. Recently I’ve been converted some of those files to other formats to view in Google Earth, Google MyMaps and other programs. There are plenty of online POI converters, but more often than not, some data is lost in the conversion and the line-breaks also get lost. Some file types are just limited in the number of data fields that they contain (such as .ov2).
I have been working on an Excel spreadsheet to correctly format POI data into for various file types without losing data or line-breaks. It is not a file that will automatically crank out the different file types. You save each different worksheet file type that you want as a csv file, then use Extra POI Editor to save the csv file to the file type that you want. Extra POI Editor is unique in that it lets you setup data fields for csv data. Thanks TurboCCC.
Below is a link to the Excel file. Give it a try to see if it works for you and customize it to suit your needs. The file utilizes formulas in cells that appear to be empty, and I didn’t protect the cells….so be careful not to accidently overwrite or delete them. Instructions are included in the file.
The Excel file download link is: http://www.datafilehost.com/download-c1ecb777.html
Nice work
Nice work on the spreadsheet file and a standardized format.
I use a 9 or 10 column XLS for my POI.
POI Name;Address;City;ST;Zip;phone;description;{comments};coordinates(Lon/Lat). Where {comments} is an optional field.
Using EPE I can save as a workbook in XLS format and then output the file into the different formats and all my source files are in exactly the same format. EPE allows any of the 24 supported fields to reside in any column.
Saving the input data file as an XLS workbook means more formatting options are available. Of course, for some files that are created from web sites, fewer columns are used as the data is not available.
ɐ‾nsǝɹ Just one click away from the end of the Internet
Well done!
I'll have to give it a whirl when I build my next DB. Thanks!
nüvi 3790T | Those who make peaceful revolution impossible, will make violent revolution inevitable ~ JFK
Geocoder...
Whenever I’m building POI files, I usually start with a spreadsheet. I like to see the POI data in front of me in a column format because it’s easy to spot missing or incorrect data. It’s easy enough to save it as csv file and convert it to a gpx file. Recently I’ve been converted some of those files to other formats to view in Google Earth, Google MyMaps and other programs. There are plenty of online POI converters, but more often than not, some data is lost in the conversion and the line-breaks also get lost. Some file types are just limited in the number of data fields that they contain (such as .ov2).
I have been working on an Excel spreadsheet to correctly format POI data into for various file types without losing data or line-breaks. It is not a file that will automatically crank out the different file types. You save each different worksheet file type that you want as a csv file, then use Extra POI Editor to save the csv file to the file type that you want. Extra POI Editor is unique in that it lets you setup data fields for csv data. Thanks TurboCCC.
Below is a link to the Excel file. Give it a try to see if it works for you and customize it to suit your needs. The file utilizes formulas in cells that appear to be empty, and I didn’t protect the cells….so be careful not to accidently overwrite or delete them. Instructions are included in the file.
The Excel file download link is: http://www.datafilehost.com/download-c1ecb777.html
Where is the online geocoder you have referred to in instruction 2?
geocoding websites
There are several sites listed here:
http://www.poi-factory.com/node/821
Give'em a try,
Thanks,
Jake88
Jake88
POI Builder II
Below is a link to a second version “POI Builder II” Excel spreadsheet.
http://www.datafilehost.com/download-69defcc6.html
I added a few macros that will:
1. Save csv files with a single click. (Header row doesn’t get saved)
2. Change case
3. Sort columns
4. Generate backup POI Excel file
5. Transpose data
6. Provide additional functionality
For those that use Excel to create csv files, I hope that you will find this file useful.
Jake88
Re
The communication and media essays would be hard to complete! Nevertheless, the business writing services would be able cope with that and even more difficult assignment.