On 22 May 2025, at 21:43, Nick Brownsberger via groups.io <nbrownsbe@...> wrote:

?

Dave,

?

To answer your question, I have an Excel spreadsheet listing about 600 cars with various information about them like type, road, number, etc. I'm using a barcode reader to identify a car ID as it rolls over a hump and send it to a Jython program. The program gets some car related information out of the spreadsheet such as car length and destination. Then it looks up the train and classification track assigned for that destination and throws turnouts to send the car to the right track.

?

Right now, using openpyxl, the program works outside of jmri to get the track I need, but it can't throw turnouts without being inside jmri.

?

It doesn't sound like openpyxl is compatible with jmri and Apache POI is way over my head.

?

I'm looking at using csv files, but manipulating a 600 record csv file sounds daunting. Or, I could instantiate a class of 600 cars in the Jython program which I was trying to avoid. I'm also rethinking my strategy as well.

?

Thanks to all,

Nick

?

I am using the POM function in LogixNG.

Currently setting a CV = to an IM value.

Works good.

Now I'd like to ADD an IM value to the CV.

In the snip I started out trying to just add a constant (50) but that didn't work.

I think I need to use the Formula tab but not sure of the syntax.?

--

Many thanks in advance!

Vinny DeRobertis ~ Apex, NC
New York & Hudson Valley RR

Windows 7 Pro / Java 11 / JMRI v5.10
Command Station: Digikeijs DR5000.
Booster: Digikeijs DR5033

(4) Samsung A7 10.4" Tablets

Fully Kiosk/Engine Driver v2.37.187

DCC/DMX Gateway: Pricom LLS.
LocoNet Input Modules: Digikeijs DR4088LN
DCC Output Modules:
Digikeijs DR4018 / Yamorc YD8116.
Sensors: Model Train Technology: DETECTOR-HO.
Turnout Motors: MTB MP1

On May 22, 2025, at 1:06?AM, Dave Sand via groups.io <ds@...> wrote:

John,

If you have any LogixNG already created, loading an additional file with LogixNG does not work.

I have created an export file which only has the LogixNG with modified system names to prevent conflicts. ?There are no other table entries or panels. ?Load this after loading your regular file.

/g/jmriusers/files/ProblemsBeingWorkedOn/dsand/3way%20LogixNG%20Export.xml

Dave Sand

----- Original message -----

From: "John Bauchiero via groups.io" <john4dhmr=[email protected]>

To:?[email protected]

Subject: [jmriusers] Trying to replicate 3-way LogixNG code

Date: Wednesday, May 21, 2025 8:14 PM

Dave Sand,

I saw a copy of your 3way LogixNG.xml code (May 6th) which looked interesting (anyway, I assume it’s yours). It operates much smoother than the Sensor/Route/Turnout conglomeration I developed to do the same thing. Up until now, I have been avoiding any Logix or LogixNG coding, at my age, I really didn’t want to learn another programming language.?

Since the code operated the 3-way turnouts just the way I liked. My plan was to add it to my layout.xml with a modification adding of two extra tracks/turnouts. I tried merging the two xml files (but it created two separate panels), not ideal. I also tried the proper way, creating the code from scratch, but (for me) LogixNG is a steep learning curve. I don’t understand the methodology of how to program by completing the dialog boxes. I got as far as the lines completing the (if-) then-else statements which I couldn’t get it to look like your code, I became so frustrated, the project got put on the back burner.?

Is there an editor to directly type-in the code, leaving the debugger to point out syntax errors? I would like an easier way to replicate your code. Thank you in advance for your expertise.?

?

John ?Bauchiero

-?NCE PH-Pro & PowerCab, Pi4, DCC-EX

- JMRI 5.11.6

- Java 17.0.12

Dave,

?

Thanks. I'd like to avoid using a cvs file because I use the spreadsheet to maintain my car fleet as well as in the Jython script.

?

Robert,

?

I tried the path.append statement but it didn't work. My file structure is:

/Applications/JMRI 5.10/openpyxl315/openpyxl.

-

"openpyxl" is just a file. There is no "openpyxl.py" script. Inside the openpyxl file is an "__init__.py" script and other files including /workbook with another "__init__.py" inside.

-

I tried these small scripts:

import os
import sys
sys.path.append("/Applications/JMRI 5.10/openpyxl315/openpyxl")

- and

import os
import sys
sys.path.append("/Applications/JMRI 5.10/openpyxl315/openpyxl/__init__.py")

-

I ran them outside of jmri in BBedit and inside jmri using the script menu. But as I said, they didn't work when I ran my script which included the lines:

import os
import sys
import time
import openpyxl - sys console says "ImportError: No module named openpyxl"

-

How should the path.amend statement read, and should I run it from the jmri script menu or from Bbedit or from the Terminal?

?

Thanks again to both of you.

Nick

Hello again. I did it, but the result is the same. I still get that prompt. That's the initial part of the code. I wonder if you see anything wrong that you could tell me about? Thank you very much.
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="/xml/XSLT/vsdecoder-config.xsl"?>
<vsdecoder-config xmlns:xsi=" xsi:noNamespaceSchemaLocation=">
<!-- SD70ACE Prime Mover -->
<!-- Used on many EMD Diesels 1975-present -->
<!-- Examples:
* SD70, SD70M, SD70ACE, SD70MAC (16-cylinder) -->
<profile name="diesel">
<!-- generic bell borrowed from the sd70ace -->
<sound-event name="BELL" label="Bell-EMD 8475495 Steel Bell 049 End.wav" buttontype="TOGGLE">
<trigger name="BELL_BUTTON_STOP" type="BUTTON">
<event-name>BUTTON</event-name>
<target-name>BELL</target-name>
<match>false</match>
<action>STOP</action>
</trigger>