Corrupt Factory Tour POI

 

Hi,

I tried to download the Factory tours POI in both the GPX and CSV format and failed.

Downloading the CSV file I get this message:
Sorry, CSV format is not available for this file.

While attempting to convert the GPX to XLS (using POI Conversion Software)I got this message:
Correct Format is: Maximum length is 1024 characters

How do I report a corrupt POI file?

Thanks,
Art

What are you attempting to do?

I believe that a csv file is not available because it is for Rand Mcnally and there is a lot of info in the gpx file.

I successfully downloaded the gpx file and opened it in EPE (extra poi editor) and it is fine.

Why do you want to put it in XL format?
The gpx file will go right on the Garmin unless you have another unit.
What GPS brand do you have/

--
Nuvi 2460LMT.

Your first report

Your first report should be to the maintainer of the POI file, in this case, Kioolt:

http://www.poi-factory.com/user/84773/contact

If no response in, say, a week, then contact The POI Factory's "Powers That Be":

http://www.poi-factory.com/contact

I agree that the csv file appears not to exist right now. I've not tried using the gpx version with any of my Garmin devices (loaded with POI Loader) to see if it works. I agree with the earlier questioner as to why you want to convert it to an xls file. Give us more info on this, the conversion software you're using and the GPS device you're working with.

I did check some of kioolt's other POI files and see that the csv for Rand McNally download works so there seems to be a specific problem with the factory tour csv download.

Interesting

I downloaded the gpx file and opened it in EPE (Extra POI Editor) I can see from the main EPE screen (showing 4 POIs) that there is a LOT of verbiage in the Desc. field.

I can not double click on any POI and get the POI Edit dialog to appear. It is open, because I can see it in the task bar but I cannot make it appear. I have to click on the "preview" X to close it.

I looked at the file using Notebook ++ and see that the file was created using EPE V4.88.

The reason you are getting the error about the max of 1024 characters is related to the "Description" for each entry.

I am not convinced that the file is corrupt.

I do not understand why the current EPE (in my case V5.91) will not work with it.

I am not sure why the .csv link is not working.

Mis-read your subject line!

For a second there, I thought someone had created a POI of corrupt factories that, for some inexplicable reason, also provide tours to the general public to view their nefarious activities, child labor, abusive work practices, etc.

It's a POI-Factory error message

pwohlrab wrote:

I believe that a csv file is not available because it is for Rand Mcnally and there is a lot of info in the gpx file.

I successfully downloaded the gpx file and opened it in EPE (extra poi editor) and it is fine.

Why do you want to put it in XL format?
The gpx file will go right on the Garmin unless you have another unit.
What GPS brand do you have/

What the OP is reporting is an error message generated by POI-Factory when trying to use JM's converter routine. It probably is tied to the large amount of descriptive data in the description field.

So, it's not necessarily a source file being corrupt, it's a case of trying to put too much information into a single field that causes the program to error out.

As to putting it into XLS format, it's so the file can be edited and all the descriptive information can be edited out.

--
Illiterate? Write for free help.

Why not try converting it to

Why not try converting it to CSV and then oprning the CSV in Excel?

OR

Open the CSV in notepad, or some other text editor, to edit?

--
I never get lost, but I do explore new territory every now and then.

I was kind of eluding to the "to much info"

Box Car wrote:
pwohlrab wrote:

I believe that a csv file is not available because it is for Rand Mcnally and there is a lot of info in the gpx file.

I successfully downloaded the gpx file and opened it in EPE (extra poi editor) and it is fine.

Why do you want to put it in XL format?
The gpx file will go right on the Garmin unless you have another unit.
What GPS brand do you have/

What the OP is reporting is an error message generated by POI-Factory when trying to use JM's converter routine. It probably is tied to the large amount of descriptive data in the description field.

So, it's not necessarily a source file being corrupt, it's a case of trying to put too much information into a single field that causes the program to error out.

As to putting it into XLS format, it's so the file can be edited and all the descriptive information can be edited out.

Unfortunately I didn't say that. As for XLS format, only the op knows the answer to that. I suspect it is for a unit that can't use gpx format (but I only suspect).

--
Nuvi 2460LMT.

read the OP

KenSny wrote:

Why not try converting it to CSV and then oprning the CSV in Excel?

OR

Open the CSV in notepad, or some other text editor, to edit?

If you read the OP you would see they are attempting to do this using either the converter JM provides or another program.

CSV is short for comma separated variable and does not imply the data is written into four (or more) fields with the longitude, latitude, name and description. It just means there are different elements to the file with each element separated by a comma. Garmin uses either a 3 or four field format with lon/lat and name as the required fields in that order. Rand McNally uses 9 fields where the first 3 match the Garmin format. It's converting the fourth optional Garmin field that creates the problem for RM users. While most files have street address, city, state and zip which also matches the RM format, others don't and that's the problem. RM also evidently has a limit to the number of characters in a field along with restrictions on which characters are allowed. The Factory Tours file has a description field that can be over 1024 characters and contains carriage returns and line fields which RM can't use.

Long story short, it is why a file that may work in one unit won't work in one by another manufacturer even though the both say they use CSV files.

--
Illiterate? Write for free help.

Yes, I understand all that

Box Car wrote:
KenSny wrote:

Why not try converting it to CSV and then oprning the CSV in Excel?

OR

Open the CSV in notepad, or some other text editor, to edit?

If you read the OP you would see they are attempting to do this using either the converter JM provides or another program.

CSV is short for comma separated variable and does not imply the data is written into four (or more) fields with the longitude, latitude, name and description. It just means there are different elements to the file with each element separated by a comma. Garmin uses either a 3 or four field format with lon/lat and name as the required fields in that order. Rand McNally uses 9 fields where the first 3 match the Garmin format. It's converting the fourth optional Garmin field that creates the problem for RM users. While most files have street address, city, state and zip which also matches the RM format, others don't and that's the problem. RM also evidently has a limit to the number of characters in a field along with restrictions on which characters are allowed. The Factory Tours file has a description field that can be over 1024 characters and contains carriage returns and line fields which RM can't use.

Long story short, it is why a file that may work in one unit won't work in one by another manufacturer even though the both say they use CSV files.

Correction. I missed the part where the POI Factory CSV file is in error also. Sorry.

--
I never get lost, but I do explore new territory every now and then.

You had my interest. I was

You had my interest. I was looking for directions to corrupt factories.

--
John B - Garmin 765T

Factory Tours

Hi Everyone,

Thanks for all of your replies. Sorry I did not respond sooner.

I'm using Streets and Trips so a CSV file or a XLS file will work.

The CVS file for this POI is not available so the only option I have is to download the file in GPX format and convert it to a XLS or CSV file. However that process does not work. I am using Richard Davis POI conversion software.

Any suggestions?

Cheers,
Art

Did I miss the OP telling us

Did I miss the OP telling us what GPS brand he is using?

I downloaded the GPX file and converted it to CSV and it looks good, as far as I can tell.

EPE handled it OK as a GPX. And http://www.gps-data-team.com/convert.php converted it to CSV.

Can't do more unless we try to convert to whatever brand he has.

--
I never get lost, but I do explore new territory every now and then.

Factory Tour POI

Hi,

I am using Microsoft GPS that came with the Streets and Trips package.

Thanks for asking.

Cheers,
Art

Well, EPE will not read more

Well, EPE will not read more than the first POI in the CSV file created on http://www.gps-data-team.com/convert.php although all the POIs are present in the CSV if opened in Notepad.

Don't know how a CSV file is formatted for the Microsoft unit. Does anyone here?

--
I never get lost, but I do explore new territory every now and then.

Used the link, but

KenSny wrote:

Did I miss the OP telling us what GPS brand he is using?

I downloaded the GPX file and converted it to CSV and it looks good, as far as I can tell.

EPE handled it OK as a GPX. And http://www.gps-data-team.com/convert.php converted it to CSV.

Can't do more unless we try to convert to whatever brand he has.

I used to link to convert the file but it did not turn into a valid Garmin .csv file for me.

Since this was the first time I have used the gps-data-team conversion, were there options I should have used?

Did EPE read your converted .csv file?

EPE did read the GPX fine,

EPE did read the GPX fine, and all the info seemed to be there. Comments are very verbose and they seemed to stop properly.

EPE only read the first POI of the GPS=DATA-TEAM conversion, but did not abend. It stopped loading at line 4 or 5, I think. I used the default options for Garmin conversions. I opened the CSV in Notepad, but it's hard to tell what EPE thinks is line 4. I'm not familiar with how the special characters are read by EPE.

EPE did convert the GPX file to Garmin CSV, but of course all the comments were stripped out.

--
I never get lost, but I do explore new territory every now and then.

Now What?

KenSny wrote:

EPE did read the GPX fine, and all the info seemed to be there. Comments are very verbose and they seemed to stop properly.

EPE only read the first POI of the GPS=DATA-TEAM conversion, but did not abend. It stopped loading at line 4 or 5, I think. I used the default options for Garmin conversions. I opened the CSV in Notepad, but it's hard to tell what EPE thinks is line 4. I'm not familiar with how the special characters are read by EPE.

EPE did convert the GPX file to Garmin CSV, but of course all the comments were stripped out.

I downloaded the gpx file, opened it in EPE, then saved it as a 4-Column csv. It opens in Notepad with the full Description part of the original gpx. When I opened it in EPE, What used to be in the Description part is now gone, but is now part of the Address field--by scrolling down or hitting the down arrow. Hmmm.

now what

nats50 wrote:

I downloaded the gpx file, opened it in EPE, then saved it as a 4-Column csv. It opens in Notepad with the full Description part of the original gpx. When I opened it in EPE, What used to be in the Description part is now gone, but is now part of the Address field--by scrolling down or hitting the down arrow. Hmmm.

CSV has only four fields. They are, in order, Longitude, Latitude, POI Name and description. When converting from GPX if it isn't one of the first 3 (which are required) then it must belong in the optional 4th field as a description of the POI.

--
Illiterate? Write for free help.

What is wanted?

I opened the Factory Tours.gpx file in EPE.

I selected "Options" > "4-col CSV fields" to get the "4-Column CSV Fields Assignment" dialog where I chose to change "10 - User Profile"

I made "Col 4" read
<Address>,<City>,<State>,<Post Code>,Phone:<Phone>

Then "Close" the "4-Column CSV Fields Assignment" dialog

I then saved the file as Factory Tours.csv using the "Save As" option and choosing ""4-Column CSV (*.csv) for the "Save as type".

This file opens fine in Excel having put quatation marks around column 4 (which contained commas).

Obviously what I asked EPE to do was to discard all of the "Description" field.

Would this have satisfied the OP?

Your CSV file

Hi jgermann

I don't know if your csv file would satisfy the OP but I find that Poi Loader only loads about 136 of the over 580 POIs in the csv file created as you described.

(I know the OP is not using POI Loader, but if that does not work, what other software would?)

what version

Evert wrote:

Hi jgermann

I don't know if your csv file would satisfy the OP but I find that Poi Loader only loads about 136 of the over 580 POIs in the csv file created as you described.

of POI Loader are you using? Early versions wouldn't handle a file that had more than 256 characters in a field. That may be your problem.

--
Illiterate? Write for free help.

POI Loader version

I am using Version 2.7.3.0

I see in the orginal gpx file that several POIs have the verbose "Description" actually in the address field.

Likely that is the problem.

For example:

<-gpxx:Address->
<-gpxx:StreetAddress->The Dryden Flight Research Center is NASA's primary center for atmospheric flight research and operations. NASA Dryden is critical in carrying out the agency's missions of space exploration, space operations, scientific discovery, and aeronautical research and development (R&D).

Located at Edwards, California, in the western Mojave Desert, Dryden is uniquely situated to take advantage of the excellent year-round flying weather, remote area, and visibility to test some of the nation's most exciting air vehicles.

In support of space exploration, we are managing the launch abort systems testing and integration, in partnership with the Johnson Space Center and Lockheed Martin, for the Crew Exploration Vehicle that will replace the Space Shuttle.

In support of space operations, we are the primary alternate landing site for the Space Shuttle and orbital support for the International Space Station.

In support of scientific discovery, we are managing the Stratospheric Observatory for Infrared Astronomy (SOFIA) program - a flying telescope aboard a Boeing 747 aircraft - in partnership with the Ames Research Center and the German Aerospace Center.

In support of aeronautical R&D, we are involved many aspects of the Fundamental Aeronautics and Aviation Safety programs, including the X-48 Blended Wing body and Ikhana (Predator B) in support of subsonics; the F-15B Quiet Spike in support of supersonics and Adaptive Flight Controls in support of the Aviation Safety Program.

For 60 years, Projects at Dryden have led to major advancements in the design and capabilities of many state-of-the-art civilian and military aircraft. The newest, the fastest, the highest - all have made their debut in the vast, clear desert skies over Dryden.

Dryden Flight Research Center plays a vital role in advancing technology and science through flight. Here, we demonstrate America's leadership in aeronautics and space technology as we continue to push the envelope to revolutionize aviation and pioneer aerospace technology.

The group tours begin with a film about our facility and then a walking tour of historical aircraft and displays, as well as current research aircraft. The Lakebed and Shuttle areas may be seen from a distance.

A regularly-scheduled public tour for individuals, or a group smaller than 15, is available. NASA Dryden Flight Research Center, in partnership with Edwards Air Force Base, provides public tours twice a month. These tours begin at 10:00 a.m. and end at approximately 2:30 p.m.

During your visit, you will attend the 90-minute walking tour at NASA and a 90-minute bus tour of the Edwards Air Force Base flight line. You will also be given time to have lunch at the NASA cafeteria, as well as visit the NASA gift shop and the Air Force Flight Test Center Museum.

The walking portion of the tour is within a controlled-access area, where photography may be permitted. However, there is no flight line photography, so please follow the rules provided by your tour escort and put your cameras away when leaving NASA.

For security reasons, the tour group must remain together at all times and bags are not allowed. The term "bags" refers to purses, backpacks, hip packs, diaper bags, etc. Restrooms are available prior to tour sign-in in building 4825.

If you have questions or would like to schedule an organized group tour, please call 661-276-5247 or 661-276-3449 .
<-/gpxx:StreetAddress

original Factory tours gpx file and jgermann's csv file

I went through the entire gpx file and found that the only one having the verbose description entered in the address field was the Dryden Research Center Poi.

I deleted the Dryden Poi from jgermann's csv file (the one he created with EPE while omitting the Description field). Poi Loader then successfully loaded all the other Pois.

as if

Evert wrote:

I am using Version 2.7.3.0

I see in the orginal gpx file that several POIs have the verbose "Description" actually in the address field.

Likely that is the problem.

For example:

<-gpxx:Address->
<-gpxx:StreetAddress->The Dryden Flight Research Center is NASA's primary center for atmospheric flight research and operations. NASA Dryden is critical in carrying out the agency's missions of space exploration, space operations, scientific discovery, and aeronautical research and development (R&D).

People are going to actually read all the verbiage when driving. Hey, it's a location file, not a tour guide.

--
Illiterate? Write for free help.

Verbiage could be useful

Box Car wrote:

People are going to actually read all the verbiage when driving. Hey, it's a location file, not a tour guide.

Well, I did not create the Factory Tours gpx file so it is not my fault all that verbiage is in it - I was just pointing out what may be causing the problems encountered when trying to use it.

But it seems to me that the verbiage would be useful for purposes of planning a trip and one could read the details while pulled over near the site.

Also, it seems to me that most gpx files are more than just "simple location" files.

Streets and Trips

adsaxs wrote:

Hi Everyone,

Thanks for all of your replies. Sorry I did not respond sooner.

I'm using Streets and Trips so a CSV file or a XLS file will work.

The CVS file for this POI is not available so the only option I have is to download the file in GPX format and convert it to a XLS or CSV file. However that process does not work. I am using Richard Davis POI conversion software.

Any suggestions?

Cheers,
Art

What version of Streets and Trips are you using? Looks like versions 2010 and later can directly import gpx files.

http://www.laptopgpsworld.com/4205-review-microsoft-streets-...

Right you are

Evert wrote:

I went through the entire gpx file and found that the only one having the verbose description entered in the address field was the Dryden Research Center Poi.

I deleted the Dryden Poi from jgermann's csv file (the one he created with EPE while omitting the Description field). Poi Loader then successfully loaded all the other Pois.

My fault for not actually trying POI Loader.