Really this cant be right ...can it? "Basecamp issue"

Sonder · Jul 3, 2022

in Basecamp I can export points into a CSV file lol but I cant import back into Basecamp a CSV file? Surely I am missing something! I am doing some stuff that probably most ppl don't I get it, but this should not be an issue.

Nuvi-Nebie · Jul 3, 2022

If you really have to import CSV files you could try converting them from CSV to GDB format using something like GPSBABEL see Link HERE, however I think the reason that Basecamp will not import CSV files is because there are dozens of different CSV file formats for Waypoints so you will have to spend some time experimenting with them all

Where would you be getting the CSV files you want to import from ?, can you get the same Waypoints in a different format ?, if you are generating your own CSV files so that you can transport data from one Basecamp to another then the answer is simple, don't save the files as CSV save them as GPX or GDB instead

Sonder · Jul 3, 2022

Well I'm a surveyor and deal with txt files and csv files all day long. So that's why I have no idea why this is an issue.

Sonder · Jul 3, 2022

I'm making a new revised csv file and trying to figure out what works.

Nuvi-Nebie · Jul 3, 2022

Sonder said:
Well I'm a surveyor and deal with txt files and csv files all day long. So that's why I have no idea why this is an issue.

You didn't answer the question, have you been supplied with CSV files that contain Waypoints ?, if so what generated them ?, will it generate a different file format, or if you generated them in Basecamp why not just use another file format ?

Sonder · Jul 4, 2022

Well I'm generating them from here actually. Lol

Sonder · Jul 4, 2022

When I'm saying here it's through Basecamp

Nuvi-Nebie · Jul 4, 2022

Sonder said:
I'm making a new revised csv file and trying to figure out what works.

If you edit a CSV file generated by Basecamp from this :-

Code:

metadata
ID,name,desc,time,keywords,minlat,minlon,maxlat,maxlon,
1,,,2022-07-04T16:18:37Z,,51.466916240751743,-0.159076200798154,51.532942336052656,-0.079747773706913,

author
ID,name,email,

copyright
year,license,author,

link
metadataID,authorID,wptID,rteptID,trkptID,rteID,trkID,text,type,href,
1,,,,,,,"Garmin International",,http://www.garmin.com,

rte
ID,name,cmt,desc,src,number,type,IsAutoNamed,DisplayColor,TransportationMode,TripName,Date,DayNumber,

rtept
ID,rteID,lat,lon,ele,time,magvar,geoidheight,name,cmt,desc,src,sym,type,fix,sat,hdop,vdop,pdop,ageofdgpsdata,dgpsid,DepartureTime,StopDuration,ArrivalTime,CalculationMode,ElevationMode,NamedRoad_Name,NamedRoad_Id,NamedRoad_ProductId,TransportationMode,

wpt
ID,lat,lon,ele,time,magvar,geoidheight,name,cmt,desc,src,sym,type,fix,sat,hdop,vdop,pdop,ageofdgpsdata,dgpsid,Proximity,Temperature,Depth,DisplayMode,Samples,Expiration,CreationTime,
1,51.531190685927868,-0.156458029523492,,,,,"001","WPT001","WPT001",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,
2,51.532942336052656,-0.079747773706913,,,,,"002","WPT002","WPT002",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,
3,51.466916240751743,-0.081913657486439,,,,,"003","WPT003","WPT003",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,
4,51.47176718339324,-0.159076200798154,,,,,"004","WPT004","WPT004",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,

Address
wptID,StreetAddress1,StreetAddress2,City,State,Country,PostalCode,

PhoneNumber
wptID,Category,value,

Categories
wptID,Category,

trk
ID,name,cmt,desc,src,number,type,DisplayColor,


trkseg
ID,trkID,

trkpt
ID,trksegID,lat,lon,ele,time,magvar,geoidheight,name,cmt,desc,src,sym,type,fix,sat,hdop,vdop,pdop,ageofdgpsdata,dgpsid,Temperature,Depth,wtemp,hr,cad,

to this :-

Code:

ID,lat,lon,ele,time,magvar,geoidheight,name,cmt,desc,src,sym,type,fix,sat,hdop,vdop,pdop,ageofdgpsdata,dgpsid,Proximity,Temperature,Depth,DisplayMode,Samples,Expiration,CreationTime,
1,51.531190685927868,-0.156458029523492,,,,,"001","WPT001","WPT001",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,
2,51.532942336052656,-0.079747773706913,,,,,"002","WPT002","WPT002",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,
3,51.466916240751743,-0.081913657486439,,,,,"003","WPT003","WPT003",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,
4,51.47176718339324,-0.159076200798154,,,,,"004","WPT004","WPT004",,"Waypoint","user",,,,,,,,,,,SymbolAndName,,,

The new edited CSV file can be converted using GPSbabel from input format :-
Universal csv with field structure in first line
to Ouput format :-
Garmin Mapsourse gdb

This GPSbabel converted gdb file will then import into Garmin Basecamp, although I really can't see why anyone would go to so much trouble, It's a lot easier to use a different file format in the first place

Sonder · Jul 4, 2022

Hmm well I have been using and editing CSV and txt files between survey machine control and real time kinematic survey equipment for almost 30 years. I wanted to ask the question to see how and if it was possible to do, because we all here work with different levels of data in work and fun. The bottom line is yes I can export a CSV file and cannot import that same file basecamp exported. As you can see its not an option to re-import the exact file basecamp exported. lol So, I will use a work around that does not start with a CSV file. Thank you for your time my friend and be well.

Sonder · Jul 4, 2022

JaVaWa said:
A regular CSV file contains data from one table, with or without record headers.
The CSV file that BaseCamp produces is actually a collection of several tables with a different layout, for waypoints, routes and tracks (even if your export doesn't contain all types). Also the data for waypoints is split into several tables...
You can open the CSV in a spreadsheet program, but it is unusable as a way to transfer data. Use GPX instead.

I see that the program has limitations, but still puzzling cause the program its self will export a CSV file..lol...