User waypoint csv partial load

Terke

I love flying GP4!
Joined
May 23, 2016
Messages
30
Location
CYBW
I have a user waypoint csv file that only loads the first 26 waypoints. I must be missing something, but it never loads past the first 26 entries. No error messages either. The file is attached. If somebody has any suggestions, I'd be interested to hear them.

Thank you.

SkyView with the latest software
 

Attachments

  • CGTPX_WAYPOINTS_0.csv
    2.6 KB · Views: 250

Terke

I love flying GP4!
Joined
May 23, 2016
Messages
30
Location
CYBW
Did I post this question in the wrong place?

Thank you
 

Terke

I love flying GP4!
Joined
May 23, 2016
Messages
30
Location
CYBW
I agree, but 26 seems like a very low and random number.
 

swatson999

Well-Known Member
Joined
Oct 6, 2010
Messages
1,662
Maybe edit it and move a few rows around, see if it still stops at 26 or not? Might indicate if there's a special character or something hidden in the file...
 

Dynon

Dynon Staff
Staff member
Joined
Jan 14, 2013
Messages
14,232
Location
Woodinville, WA
I took a look and made some edits (commas, non-basic characters), but I'm seeing issues loading it as well. I actually couldn't get any of them to import here. I've asked our engineer to take a deeper look.
 

Dynon

Dynon Staff
Staff member
Joined
Jan 14, 2013
Messages
14,232
Location
Woodinville, WA
So an update here - it looks like the CSV file was formatted with only carriage returns ("\r"), where you really want carriage return and line feed ("\r\n"). You can see these characters if you use a text editor that has a "show all characters" or similar mode.

We ran a quick replacement and everything loaded just fine (see attached csv).

We'd imagine that most people edit CSVs using MS Excel, so we took a look through all the various CSV save options to see if any of them created this problem. Saving as "CSV (Macintosh)(*.csv)" is the only format available in MS Excel which looks to reliably cause this problem, all the other formats available structure the line breaking correctly.

So the fix is pretty easy if someone is using MS Excel, just save the csv in any format except Macintosh.. We don't know if there are issues if one is editing on a mac platform (we're mostly PCs here).

What editor/computer platform did you create your file with?
 

Attachments

  • CGTPX_WAYPOINTS_fixed.csv
    2.6 KB · Views: 272

Terke

I love flying GP4!
Joined
May 23, 2016
Messages
30
Location
CYBW
You are awesome! I have a Mac and used Excel to add to the file I had made on the SkyView. I'll use a raw text editor from now on.

Thank you very much!
 
Top