Page 1 of 1
| CSV and Excel to create timetables? 30/09/2014 at 17:43 #64789 | |
GW43125
495 posts |
Evening all, I am beginning work on a timetable and intend to use the CSV method in order to reduce the time taken. However, I am unsure how to use this so would be grateful if someone would be able to point me in the right direction to do so. Thanks in advance, Jamie Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 14:38 #64804 | |
pedroathome
887 posts |
Hi Jamie Best way I have found to create a TT when working in CSV is to first draw up a couple trains in the sim TT editor before exporting. This will give you all the relevant locations etc in the appropriate layout. After that, you can simply delete any of the trains there, and add in using lets say for example 02:00 for a departure time, or 02/00 for passing time (Someone please correct me about the slash there, may be wrong) I personally don't find working in CSV very helpful, I find it much easier to work in the built in TT editor, or for when adding rules etc to then open the TT in the XML format and edit within that (That's a whole new kettle of fish though) James Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 15:29 #64805 | |
|
GW43125
495 posts |
Any idea how I open it in XML format?
Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 15:39 #64806 | |
|
Finger
220 posts |
I just open the wtt file in Emacs. Emacs can handle the zip compression so you can easily do small changes, eg. I experimented this way with timetables going past the 100:00 mark. However, it has to be said that XML is not a parsimonious format. I find it convenient that I can use XML tools to do queries against the timetables or mechanized edits (eg. "Any pax train stopping at Sandy next stop Bigglswade must have platform 1" or "Trains shunting from Peterborough Px to Py will reverse at tiploc ABCDEF"), but direct XML editing is a bit of a pain. It entirely depends on your workflow how you can make use of these tools. Last edited: 01/10/2014 at 15:40 by Finger Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 16:39 #64808 | |
|
GW43125
495 posts |
Unfortunately I cannot get the system to work and open the XML files, so I am unsure as to what can be done. Any help would be appreciated.
Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 16:47 #64809 | |
Peter Bennet
5360 posts |
" said:Unfortunately I cannot get the system to work and open the XML filesWhat system? Peter I identify as half man half biscuit - crumbs! Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 17:35 #64811 | |
|
GW43125
495 posts |
Sorry, I meant program (I've tried Notepad, Notepad++, ConTEXT and Emacs).
Last edited: 01/10/2014 at 17:35 by GW43125 Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 18:02 #64814 | |
|
Finger
220 posts |
Just looked at it and Emacs needs the unzip program in path. Or you can just unzip the file to your disk with your favorite program.
Last edited: 01/10/2014 at 18:03 by Finger Log in to reply |
| CSV and Excel to create timetables? 01/10/2014 at 18:47 #64818 | |
|
pedroathome
887 posts |
" said:Any idea how I open it in XML format?In a loader sim change the .wtt extension to .zip Log in to reply The following user said thank you: GW43125 |
| CSV and Excel to create timetables? 01/10/2014 at 18:50 #64819 | |
headshot119
4869 posts |
" said:" said:If you use 7zip you can just right click and extract the WTT without changing the file extension.Any idea how I open it in XML format?In a loader sim change the .wtt extension to .zip "Passengers for New Lane, should be seated in the rear coach of the train " - Opinions are my own and not those of my employer Log in to reply The following user said thank you: GW43125 |