Page 1 of 1
Open Office in lieu of Excel
Posted: Wed Feb 04, 2009 8:10 am
by ARG706
Just wondering, can Open Office be used in place of Excel for creating marker lists if one doesn't have the latter?
Thanks in advance
Re: Open Office in lieu of Excel
Posted: Wed Feb 04, 2009 9:40 am
by AndyUK
Yes, no problem. If you're careful about getting the format right you could use any text editor to create a .csv marker file but a spreadsheet is easier.
Andy L
Re: Open Office in lieu of Excel
Posted: Wed Feb 04, 2009 9:43 am
by ARG706
Hmm, would an MSTS mkr file do the trick here with a bit of modifying? How does one save an RTF file as a CSV?
Re: Open Office in lieu of Excel
Posted: Wed Feb 04, 2009 1:04 pm
by AndyUK
Mike Simpson's RS_Tools, downloadable from the file library here, can convert .mkr files to .csv files for you. But in essence all you need to do to convert the .rtf to .csv is to make sure there are no additional commas and save the file as plain text but give it a .csv file extension. As an example here's a few lines of a named marker.csv file I created for RailSim:
-0.9642435420070825,51.15354255381826,Alton_End_Of_Line
-0.9659502041465943,51.15268626992863,Alton_N_End_Of_Platform
-0.9669158471050849,51.15199198726765,Alton_MHR_End_of_Footbridge
-0.9674928657865537,51.15144709033477,Alton_S_End_Of_Platform
Note that the order is longitude, latitiude, name.
Andy L
Re: Open Office in lieu of Excel
Posted: Thu Feb 05, 2009 5:30 am
by ARG706
Well, I went through that process right up to pressing export. Now I am getting an error at the bottom of the page
File not found C:\Program Files\Rail Simulator\Source\Developer\Rail sim Test Route\NamedMarkers_Rail_Sim_Test_Route.csv
The name at the end is the exact name of the csv file in the very same location it says it can't find it in, and it is properly formatted by RStools. I get this error every time I make an attempt to export the Blueprint.
I have followed the manual as well as various posts on here directing how to do it to no avail. Been trying for 3 days to get the marker into the sim, but this is becoming intensely frustrating!
Edit: finally got them to show after finding out about the separate folder requirement in source, and the blue box drop down list in the world editor. Thanks for the very sketchy information on this requirement Kuju. Anyhow thanks Andy

Re: Open Office in lieu of Excel
Posted: Thu Feb 05, 2009 10:54 am
by Basherz
If you are trying to export a marker file from the Source directory, then you have to have both the .xml and the .csv present in the same directory.