... the user friendly GPS tool


Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Question about GPX to CSV
#1
I work for a home delivery company, and my problem stems from lack of integration between routing software (Microsoft Streets and Trips) and our database. I am in need of a csv file to upload into our database that contains the route points in order.

When I found the Route Converter, I thought my problem was solved. However, when I convert the exported GPX file from Streets and Trips, I don't get a csv format that is very useful.

I understand that my use of Route Converter differs that most if not all of you, but I am still hoping that I can find a way to make this work. So here is what I need:

A CSV file that has the points in order and separate columns for each of the description of points. Specifically, the description of points lists the name, address, city, state, zip separated by commas in one column. I need the name in it's own column.

I checked all possible CSV formats and did not see one that did this, but I am hoping that there is a format or setting that would solve this.

Any help from this forum would be greatly appreciated. Please let me know if I can clarify what I am hoping to accomplish.
Reply
#2
(26.05.2010, 17:41)Michelle Wrote: I understand that my use of Route Converter differs that most if not all of you, but I am still hoping that I can find a way to make this work.

Take the source and write a CSV format (something that is on my todo list since a while).

(26.05.2010, 17:41)Michelle Wrote: A CSV file that has the points in order and separate columns for each of the description of points. Specifically, the description of points lists the name, address, city, state, zip separated by commas in one column. I need the name in it's own column.

Unfortunately, RouteConverter currently has just one field, the comment, for all the structured data that you need: name, address, city, state, zip

I have ideas to extend RouteConverter but limited time and a growing list of problems to solve before implementing more features.
--
Christian
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)