¿ªÔÆÌåÓý


Re: How do I import openpyxl?

 

Nick,

The session.log file contains the system console. ?It is at /Users/<username>/Library/Preferences/JMRI/log.

Dave Sand



----- Original message -----
From: "Nick Brownsberger via groups.io" <nbrownsbe=[email protected]>
Subject: Re: [jmriusers] How do I import openpyxl?
Date: Friday, May 23, 2025 12:55 PM

I upgraded to 5.11.6 but I still have the problem. MacBook Air 2017, Monterey. PanelPro is frozen so I can't copy the sys console, but It gave me a warning when it was saving to OperationPro backup: Only 3 files found in directory.
?


Re: How do I import openpyxl?

 

I upgraded to 5.11.6 but I still have the problem. MacBook Air 2017, Monterey. PanelPro is frozen so I can't copy the sys console, but It gave me a warning when it was saving to OperationPro backup: Only 3 files found in directory.
?


Re: How do I import openpyxl?

 

¿ªÔÆÌåÓý

Nick,

?

I¡¯m not having issues using 5.11.4. Also which operating system: Windows, Mac, Linux?

?

-Ken Cameron, Member JMRI Dev Team

?

?


Re: How do I import openpyxl?

 

Pete, Never mind. I got it. Nick


Re: How do I import openpyxl?

 

Pete,
Where is that? I don't see it in the sidebar.
?
Nick


Re: How do I import openpyxl?

 

Ken,
I'm having the same problem. Won't even allow me to select csv file before PanelPro freezes. Uploaded new csv file to files.
Nick


Re: How do I import openpyxl?

 

I moved all your files to 'Problems being worked on'.
/g/jmriusers/files/ProblemsBeingWorkedOn/Nick%20Brownsberger

--
Peter Ulvestad
Linux Mint 22.1, JMRI 5.11.6, Java 21.0.7
JMRI Users Group Moderator ( /g/jmriusers )
JMRI Developers Group Moderator ( )
Tam Valley Group Moderator ( )
Sprog-DCC Group Moderator ( )
Edmonton Model Railroad Association ( )


Re: How do I import openpyxl?

 

Thanks, Ken.


Re: How do I import openpyxl?

 

¿ªÔÆÌåÓý

Nick,

?

I gave that file a try. It stopped on the first record due to the road name didn¡¯t match existing road names. Or rather reporting marks. You have full name Pennsylvania while the reporting mark would be PRR. I don¡¯t recall which fields would trigger it auto-creating and which you have to create first.

?

Looking at the default ops, a few comments:

  1. It is case sensitive, hopper is not Hopper.
  2. Road has to match something existing already.
  3. The rest of the Fields prompt about adding if it hasn¡¯t seen the value before.
  4. But it will stop reading the file if it runs into a problem.
  5. Some fields are critical like number, road, type, and length
  6. I think others are optional.
  7. To edit things like road and car types, pick a car, edit, then you have edit buttons for each of the fields.
  8. Same deal for colors etc¡­
  9. If you want lowercase, you have to enter lowercase.

?

Hopefully this helps.

?

-Ken Cameron, Member JMRI Dev Team

?

?


Re: How do I import openpyxl?

 

it' named carFleet.csv in files.
?
Nick


Re: DCC-EX Voltage/current meter #dcc-ex

 

?
If the <c> isn't working, I doubt the <JI> will either.
But easy to check, just use the Send DCC++Command tool and send each of those messages, and paste the response(s) here.
--SteveT?

When sending <c>, I get:
?

TX: Read Track Current Cmd

RX: DIAG: Opcode=c params=0

RX: No Sensor/Turnout/Output

Reply

?

When sending <JI>, I get:
?

TX: Unknown Message: 'JI'

RX: Unknown Message: 'jI 0

0 '


Re: How do I import openpyxl?

 

¿ªÔÆÌåÓý

Nick,

?

It might be simpler to upload your file to the ¡®Problems being worked on¡¯ part of the group site. Then others can review the values and see if they can spot the issue.

?

-Ken Cameron, Member JMRI Dev Team

?

?


Re: How do I import openpyxl?

 

Ken,
?
When try to import my car file in the format described in the OperationsPro help section, PanelPro hangs up. When OperationsPro>Tools>car roster>Import from files is selected, nothing happens: no new window opens to select the file and I just get the circling wait symbol. After 15 minutes, ?I have to force quit PanelPro. I can't close the cars window until after I've executed the command, but I close it then. Nothing shows on the sys console.
?
Help,
Nick


Re: DCC-EX Voltage/current meter #dcc-ex

 

If the <c> isn't working, I doubt the <JI> will either.
But easy to check, just use the Send DCC++Command tool and send each of those messages, and paste the response(s) here.
--SteveT?


Re: DCC-EX Voltage/current meter #dcc-ex

 

> Is the use of the <JI> command between JMRI and DCC-EX (running on an uno) therefore dependant on a JMRI update before it can work?

>Yes

¡­an update yet to be released, or will updating to v5.10 do the trick? I haven¡¯t seen anything in the latest release notes regarding the current monitor and DCC-EX, though¡­


Re: How do I import openpyxl?

 

Ken,
?
I'd never delved into OperationsPro before. It already does a lot of what I need to do. I'm working with it now.
?
Thanks, Ken, and thanks to all!
Nick


Re: LogixNG POM #logixng

 

Got it working.
Thanks again Daniel!


JMRI and the decoder Panels

 

Hi,
A very long time ago (6yr or so) I was able to use JMRI and the panels to read the MACROs of? the Clubs layout to allow me to change if needed, one at a time, not having to REDO the MACRO, best thing since sliced bread.
?
WAY back then, it was just a matter of plugging in the USB Cable to the CONTROL PANEL on the layout, the other end to the computer, starting JMRI and get the PANELs and the macros to show SOMEHOW :)
?
For one reason of another the above method was FORGOTTEN about, sad to say wanting to do something again, the MEMORY is not so good.
?
More later perhaps
Graeme
?


Re: How do I import openpyxl?

 

¿ªÔÆÌåÓý

Nick,

?

Why not use the built in Operations to hold the car inventory? That would be a onetime export to CSV and import to JMRI. Then your script could query that database.

?

-Ken Cameron, Member JMRI Dev Team

?

?


Re: I think I have JMRI 5 and JAVA 11 loaded on my Win 11 computer

 

Hi Steve,
THANKS for your reply,
My computer details are showing me that the USB cable is connection to my COM 3, I go through all the DECODER PANEL settings an wait for a few section, only to have shown in RED.
I will have to wait till I get back to the CLUB and some ELECTRONIC EXPERTS there may be able to help me
?
Thanks Graeme