Open Office in lieu of Excel

If you're new to Rail Simulator, this is the place to start. Ask anything you like, no question to simple or stupid - we were all here once!

Moderator: Moderators

Locked
User avatar
ARG706
Well Established Forum Member
Posts: 523
Joined: Mon Dec 25, 2006 7:16 am
Contact:

Open Office in lieu of Excel

Post 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
AndyUK
Very Active Forum Member
Posts: 3135
Joined: Thu Aug 15, 2002 7:57 pm

Re: Open Office in lieu of Excel

Post 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
User avatar
ARG706
Well Established Forum Member
Posts: 523
Joined: Mon Dec 25, 2006 7:16 am
Contact:

Re: Open Office in lieu of Excel

Post 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?
AndyUK
Very Active Forum Member
Posts: 3135
Joined: Thu Aug 15, 2002 7:57 pm

Re: Open Office in lieu of Excel

Post 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
User avatar
ARG706
Well Established Forum Member
Posts: 523
Joined: Mon Dec 25, 2006 7:16 am
Contact:

Re: Open Office in lieu of Excel

Post 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 :)
Basherz
Very Active Forum Member
Posts: 1394
Joined: Tue Jan 08, 2008 7:14 pm
Location: Cimla, Neath
Contact:

Re: Open Office in lieu of Excel

Post 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.
Chris
Locked

Return to “[RS] Help for Beginners”