Travellermap and CSV?

[ShawnDriscoll]

Is Travellermap and CSV a thing? Can CSV be imported/exported with it?

 

[Nathan Brazil]

inexorabletash is the master cartogrphapher, so he is the man with the plan. I have compiled the Rebellion and 1248 data.

So, not as directly downloadable .CSV file but you can get the data three ways.

You get the sector data from the menu on the lefthanded side search menu. Type in the name of the sector and click on the selection "Raw Data"

You can use the Poster Maker - The Traveller Map to retreive a sector. Once selected, you copy and paste the data. It is column delimited.

Check the section API - The Traveller Map for other ways to retreive data.

The things to note are "canonicity" status, credited data source, and original UWP data format. Many in 1105 are not "official" as they have not gone thru the rigorous examination, reformat to T5, and approval by the powers that be. All outside the 1105 are in this status for lack of approval, if for no other reason. You can see the status at the bottom of a sector when highlighted.

 

[tjoneslo]

Is Travellermap and CSV a thing? Can CSV be imported/exported with it?

What exactly are you interested in doing with the CSV data?

Probably the closest you will get is a Tab Delimited format:

https://travellermap.com/doc/api#sec-retrieve-uwp-data-for-a-sector

https://travellermap.com/doc/fileformats#t5tab

Excel will, for example, be more than happy to read and correctly layout a tab separated file.

 

[ShawnDriscoll]

I've used the TABbed SEC format forever. Just recently started doing CSV on my own for all my traveller files. More versatile, does not introduce more bugs to code when reading/writing an CSV, and doesn't need its files to look pretty for human reading. I have apps that can read them and display them in whatever fashion I need.

I use CSVs to save my characters and worlds in. Have some videos about it, while I'm trying things out.

 

[inexorabletash]

Tab delimited is as close as there is. Should be easy to convert back and forth with Excel or Google Sheets, etc. They can import tab-delimited and output CSV.

 

[coliver988]

Tab delimited is as close as there is. Should be easy to convert back and forth with Excel or Google Sheets, etc. They can import tab-delimited and output CSV.

Or depending on how you import them and which language, just substitute tabs for commas. All the languages I've ever dealt with (including all scripting languages) have replace/substitute/pattern matching built in.

I'm not a fan of CSV particularly, but then I've had to import address, patient, phone switch and all sorts of data that may have commas in there. But then I am also old school and used fixed width and implied decimal files (may COBOL never die ) HL7 uses the vertical bar, then the carrot (|, ^) to mark fields, and repetitions within fields.

Currently I am using the TravellerMap API in a UWP program. Took the JSON, auto-generated a class, and the import works like magic. Gotta love a good serializer! (I was, and still vaguely am, sort of hoping to get this at least attempted to the Windows store before end of year. I have serious doubts about that actually happening, but hey, its still fun to play. Of course, it is also a remake of a program I wrote almost 10 years ago, but that used XML as the back end storage, and now I'm using SqlLite just because it seemed more interesting. And I actually sort of like XAML)