I just tried to reproduce it:
- double-clicking the CSV in Windows explorer opens the file in Excel correctly
- starting Excel and selecting File/Open, Show all files, and selecting the CSV file opens it correctly
- starting Excel with a blank spreadsheet and selecting Data/Import/From Text and just clicking through the wizard imports the data as is without columns etc.
How did you open the CSV file in Excel? Or maybe this is just a problem of different language settings? I thought I made sure to always use English (USA) or language-neutral settings... Currently I am at a loss without further info.
EDIT: Just tried Google Docs and it has issues, too; except when explicitly stating ";" as delimiter. Is anybody else having problems with the CSV files? I could try to create XLS(X) files instead...
I found out what I was doing wrong. Open Office wants to interpret the .csv file, and it had both the Semicolon and the Space checked as default delimiters. It split data lines along columns if either occurred. So even phrases like (WORLD NAME) were split along two columns. If I uncheck "Space", then only Semicolon is used as a delimiter and the columns are aligned correctly with the headings.
I must also open and save the file so that it interprets all entries as "Text". If I leave it to Standard it will format the numbers, so hex format 0101 becomes 101 and that will cause an error if I try to load back the file.
So it works, it can all be edited and fed back to the SectorMaker display.
But here's a strange thing. If I edit (WORLD NAME) in a line to give a non-mainworld a name, it won't appear on the system orbit list if you click the name of the mainworld. Do you type in a world name with the parentheses, or without, or did you just omit having non-mainworld names print out? I'll have to test this out some more.
And if you've found more errata by developing these tools, and haven't posted them in the errata threads, drop me a note at don.mckinney@gmail.com with the details and I'll make sure they get reviewed.
Yes, I omitted all names from the system listing, but that's easy to change. Just give me some time.![]()
OK, here they are. I changed the system details display from preformatted text to table layout and inserted the world names.
And a little update: I added cargo ids to world listings to get the trading started...
You are welcome! And yes, I'm a software engineer working in the management consulting business as a freelancer.
I am planning for letting people create user accounts. Maybe it would be good to allow custom settings for the world creation process, like upper limits for pop, tech, etc.
Planetary systems are no different from NPCs in a Traveller game. A referee who is in a hurry uses some random dice rolls to generate a new system but if the stats come out oddly (hmm....Maybe High Admiral Bearington should have an Edu higher than 3....) then the referee is free to reroll or even just arbitrarily change a stat as they see fit.I may indeed want to tame those high-population rolls, but I'll try to plan my campaign sector with the "straight" T5 rules and see how it goes!
You are welcome! And yes, I'm a software engineer working in the management consulting business as a freelancer.
I am planning for letting people create user accounts. Maybe it would be good to allow custom settings for the world creation process, like upper limits for pop, tech, etc.