开云体育

Is it possible to export the contents of the roster pane to an Excel spreadsheet? Thanks.

Jim K

Yes, but I think you have to use PanelPro. If you use Panel Pro you can also export Cars, Locations, and Trains to .csv files. You can then open them in Excel. You can then either save them as .xlsx files or keep them as .csv. I have all of them then linked into one master Excel file. The one thing I haven’t been able to do is find a script that works to automate the process. The ones I’ve found don’t work.
--
Mike Heintzman
Modeling the P&PU since 1953

Jim,

Try running RosterCsvExport.py and import the resulting file into Excel.

In DecodePro, select Actions >> Run Script…. In PanelPro, select Panels >> Run Script…


Dave Sand

That will probably work for Jim. I was looking for one that emulates the .csv file produced through the Export to file function in Operations>Locomotives>Tools with the Location listed. I know Dan Boudreau did some work on them earlier. I get a ‘Syntax error: no viable alternative at input ‘jmri’ at Line 1’ error .
--
Mike Heintzman
Modeling the P&PU since 1953