On 30 Dec 2018, at 22:22, john Wragg <teamwragg@...> wrote:

Hi Dave

I have just uploaded the script to the files/script examples folder. It is called Table print.py
It does have the save path hard coded in at the start so you will need to edit that for your own set up.
If you haven't got a python editor then use something like notepad++. Some text editors mess up the indentations which python does not like
To run python scripts open the main screen (I use panelpro) In the pull down menu called panels there is an option to run scripts. You will need to browse to where you have stored the script and then just run it. In theory it should produce a number of csv files for blocks, turnouts, sections, sensors, signal masts and signal mast logic. (those were the ones I was interested in) Only the blocks and turnouts indicate if they are on a panel. I am still working out how to check for sensors etc

Let me know if you have any issues with it or if you need anything further in that direction

John

On Dec 30, 2018, at 1:57 PM, Ron Atherton <akskron@...> wrote:

Dave,

I could use the Excel script also. I have become the Computer Guy for a Group that did not understand JMRI (not that I fully understand it myself) or how software of any type works.

The JMRI tables have MANY unused or incorrect turnouts, blocks, etc. that so far I have been unable to delete. If I could list stuff in Excel it might help me "clean up" the mess.

They tired to get it right but their lack of programming knowledge and how to write software was a major problem.

We have over 30 of 60 signals in and working on a layout with 35 blocks and over 40 turnouts controlled by either wireless throttles and/or JMRI.

I have programmed in Fortran for many years but had worked with Excel mostly for last 15 years for Sales and Marketing data until I retired.

Writing script in Jython is a new challenge for me but so far I am winning, most of the time. Fortran used a compiler that usually let you know that you made an error on how you wrote a command. Jython just will not run with "bad" script and then the guessing starts. LOL

Thanks

Ron Atherton



Sent from my U.S.Cellular? Smartphone

-------- Original message --------
From: Dave Roberts <dccdaveroberts@...>
Date: 12/30/18 12:37 PM (GMT-06:00)
To: [email protected]
Subject: Re: [jmriusers] UNWANTED BLOCKS & TURNOUTS IN LISTING

Dave,

Thanks for the confirmation. I am pleased to report that the “CHECK” tool is reporting no errors on any panel - Master and Sub-Panels (Lovations).

I am waiting for John Wragg to get back to me with a copy of his Jython Script to permit the Table Printouts to be converted into Excel format so that they can be printed out.

Apparently, his script will identify those entries that are not used within the active xml files to make things a little easier. At least my Naming scheme has come into its own. It will be a great help in this case.

Dave

On 30 Dec 2018, at 17:59, Dave Sand <ds@...> wrote:

Dave,

I believe the two connection rule applies to other table types, including turnouts. Whenever making changes like this, save often and stop/start JMRI and look for errors in the system console.

Dave Sand

On Dec 30, 2018, at 11:40 AM, Dave Roberts <dccdaveroberts@...> wrote:

Dave,
Thanks for the confirmation regarding the Blocks. What about the Turnouts?
Dave

- Dave

On 30 Dec 2018, at 16:59, Dave Sand <ds@...> wrote:

Dave,

Blocks with only 2 connections are not active and can be deleted.

Dave Sand

On Dec 30, 2018, at 1:56 AM, Dave Roberts <dccdaveroberts@...> wrote:

Cliff,

So kind of you to reply and thank you. Like you, my layout developed over some ten years and grew alongside JMRI. As part of the learning curve that we all go through I created several Turnouts and Blocks using the INTERNAL Name. Many had mistakes in the name, usually me adding in an extra space here and there. These are very difficult to distinguish between too!

Sometimes it was when I renamed an existing block I would add number after it and then create a new second, sequentially numbered Block. The original block was still there in the listing. This was before the time when I could have just renamed it and saved it.

I was developing my Naming System and Turnouts proved a bit of a problem until I settled on my current Naming scheme which now sorts all items for a particular Location into one contiguous block of names.

However, I am left with several entries that are not used within the xml file as part of any part of the layout. I was hoping that as part of the Rename the Layout idea that JMRI could be made to just include those names that are actively used on the layout and leave the rest behind.

At present, by using my Naming Scheme, I can break all the Table records into Named Blocks of records and attempt a deletion there. It is easier than having to plough through every entry on the various Tables Listings.

The problem is identifying those not currently used. At the moment it would appear that the unused entries only have two connections but I am not sure if this is the default when they are created? Is so, then deleting all those with only the original two connections would appear to be the way to go but having spent many hours removing all errors between the Master, (Whole Layout) file Panel and the various Location Sub-Panels using the CHECK Tool option for all four of the areas specified, I need to be sure that I can get rid of all of the unwanted entries and so slim down the file to prevent any further errors arising in the future.

That is why I put out my request for further information to check if there has been any further developments over the past five years before I embark on what could be a potential nightmare scenario for me.

May I wish you a Happy and Peaceful New Year.

Dave

On 30 Dec 2018, at 00:19, Cliff Anderson <cliffaa@...> wrote:

Dave,

On Sat, Dec 29, 2018 at 01:03 PM, Dave Roberts wrote:

I have read the last conversation from Cliff in 2014 but has there been any progress in finding a way to remove unwanted/unused list items from the tables?

Perhaps you are referring to messages #103133 & #103134 from February 2014?

If so, it took me some time to recover them and even so I have only a dim memory of that thread after almost five years. Certainly, I have no recollection of further information and normal use of search mechanisms within the JMRI and this Groups sites have not been productive. My practice with the use of adding Blocks has become more careful to define a new block, but that does not help others much.

If these are not what you are alluding too, perhaps further clarification would be in order.

In either case, someone who uses the Layout Editor a lot more than I do would be better prepared to follow up on your request.

Cliff in Baja SoCal

开云体育

---------- Original Message ----------
From: SettleDown <wgrushton@...>
Date: December 30, 2018 at 1:39 PM


Hi Guys

Just seen this topic, which is of interest as I'm hoping to look into using
Arduinos to control sound and other functions around my layout.? Is there a
way to get hold of the article that you (@JerryG) wrote other than purchasing
the NRMA mag ?

Regards

Graham - @SettleDown

On 30 Dec 2018, at 17:59, Dave Sand <ds@...> wrote:

Dave,

I believe the two connection rule applies to other table types, including turnouts. ?Whenever making changes like this, save often and stop/start JMRI and look for errors in the system console.

Dave Sand

On Dec 30, 2018, at 11:40 AM, Dave Roberts <dccdaveroberts@...> wrote:

Dave,
Thanks for the confirmation regarding the Blocks. What about the Turnouts?
Dave

- Dave

On 30 Dec 2018, at 16:59, Dave Sand <ds@...> wrote:

Dave,

Blocks with only 2 connections are not active and can be deleted.

Dave Sand

On Dec 30, 2018, at 1:56 AM, Dave Roberts <dccdaveroberts@...> wrote:

Cliff,

So kind of you to reply and thank you. Like you, my layout developed over some ten years and grew alongside JMRI. As part of the learning curve that we all go through I created several Turnouts and Blocks using the INTERNAL Name. Many had mistakes in the name, usually me adding in an extra space here and there. These are very difficult to distinguish between too!

Sometimes it was when I renamed an existing block I would add number after it and then create a new second, sequentially numbered Block. The original block was still there in the listing. This was before the time when I could have just renamed it and saved it.

I was developing my Naming System and Turnouts proved a bit of a problem until I settled on my current Naming scheme which now sorts all items for a particular Location into one contiguous block of names.

However, I am left with several entries that are not used within the xml file as part of any part of the layout. I was hoping that as part of the Rename the Layout idea that JMRI could be made to just include those names that are actively used on the layout and leave the rest behind.

At present, by using my Naming Scheme, I can break all the Table records into Named Blocks of records and attempt a deletion there. It is easier than having to plough through every entry on the various Tables Listings.

The problem is identifying those not currently used. At the moment it would appear that the unused entries only have two connections but I am not sure if this is the default when they are created? Is so, then deleting all those with only the original two connections would appear to be the way to go but having spent many hours removing all errors between the Master, (Whole Layout) file Panel and the various Location Sub-Panels using the CHECK Tool option for all four of the areas specified, I need to be sure that I can get rid of all of the unwanted entries and so slim down the file to prevent any further errors arising in the future.

That is why I put out my request for further information to check if there has been any further developments over the past five years before I embark on what could be a potential nightmare scenario for me.

May I wish you a Happy and Peaceful New Year.

Dave

On 30 Dec 2018, at 00:19, Cliff Anderson <cliffaa@...> wrote:

Dave,

On Sat, Dec 29, 2018 at 01:03 PM, Dave Roberts wrote:

I have read ?the last conversation from Cliff in 2014 but has there been any progress in finding a way to remove unwanted/unused list items from the tables?

Perhaps you are referring to messages #103133 & #103134 from February 2014?

If so, it took me some time to recover them and even so I have only a dim memory of that thread after almost five years. Certainly, I have no recollection of further information and normal use of search mechanisms within the JMRI and this Groups sites have not been productive. My practice with the use of adding Blocks has become more careful to define a new block, but that does not help others much.

If these are not what you are alluding too, perhaps further clarification would be in order.

In either case, someone who uses the Layout Editor a lot more than I do would be better prepared to follow up on your request.

Cliff in Baja SoCal

On Dec 30, 2018, at 11:40 AM, Dave Roberts <dccdaveroberts@...> wrote:

Dave,
Thanks for the confirmation regarding the Blocks. What about the Turnouts?
Dave

Sent from my iPhone - Dave

On 30 Dec 2018, at 16:59, Dave Sand <ds@...> wrote:

Dave,

Blocks with only 2 connections are not active and can be deleted.

Dave Sand

On Dec 30, 2018, at 1:56 AM, Dave Roberts <dccdaveroberts@...> wrote:

Cliff,

So kind of you to reply and thank you. Like you, my layout developed over some ten years and grew alongside JMRI. As part of the learning curve that we all go through I created several Turnouts and Blocks using the INTERNAL Name. Many had mistakes in the name, usually me adding in an extra space here and there. These are very difficult to distinguish between too!

Sometimes it was when I renamed an existing block I would add number after it and then create a new second, sequentially numbered Block. The original block was still there in the listing. This was before the time when I could have just renamed it and saved it.

I was developing my Naming System and Turnouts proved a bit of a problem until I settled on my current Naming scheme which now sorts all items for a particular Location into one contiguous block of names.

However, I am left with several entries that are not used within the xml file as part of any part of the layout. I was hoping that as part of the Rename the Layout idea that JMRI could be made to just include those names that are actively used on the layout and leave the rest behind.

At present, by using my Naming Scheme, I can break all the Table records into Named Blocks of records and attempt a deletion there. It is easier than having to plough through every entry on the various Tables Listings.

The problem is identifying those not currently used. At the moment it would appear that the unused entries only have two connections but I am not sure if this is the default when they are created? Is so, then deleting all those with only the original two connections would appear to be the way to go but having spent many hours removing all errors between the Master, (Whole Layout) file Panel and the various Location Sub-Panels using the CHECK Tool option for all four of the areas specified, I need to be sure that I can get rid of all of the unwanted entries and so slim down the file to prevent any further errors arising in the future.

That is why I put out my request for further information to check if there has been any further developments over the past five years before I embark on what could be a potential nightmare scenario for me.

May I wish you a Happy and Peaceful New Year.

Dave

On 30 Dec 2018, at 00:19, Cliff Anderson <cliffaa@...> wrote:

Dave,

On Sat, Dec 29, 2018 at 01:03 PM, Dave Roberts wrote:

I have read the last conversation from Cliff in 2014 but has there been any progress in finding a way to remove unwanted/unused list items from the tables?

Perhaps you are referring to messages #103133 & #103134 from February 2014?

If so, it took me some time to recover them and even so I have only a dim memory of that thread after almost five years. Certainly, I have no recollection of further information and normal use of search mechanisms within the JMRI and this Groups sites have not been productive. My practice with the use of adding Blocks has become more careful to define a new block, but that does not help others much.

If these are not what you are alluding too, perhaps further clarification would be in order.

In either case, someone who uses the Layout Editor a lot more than I do would be better prepared to follow up on your request.

Cliff in Baja SoCal

?

I do also have Digitrax's SoundLoader software and that works just fine.? When I attempt to load a working; but, new loco to the JMRI Decoder Pro, I go through all the pages of information and change what I want to change.? Take the loco to my layout and nothing happens, no lights, no movement.? Bring the loco back to the programming track and look at the parameters and I can see that changes have been made, correct address and everything.? I have Uninstalled the software, thinking that I might have screwed it up by opening the program without the programming track and PR-4 being connected, via the USB and power cord hooked up.? Then re-loaded JMRI Decoder Pro software and it did not fix anything.? I go to the SoundLoader program, do a factory reset and change the address to the Loco's number and can get everything to work again.

Mark? Oh, by the way, I live in Central Minnesota.? I have no idea if there are even other model Railroaders around, let alone whether anyone uses JMRI Decoder Pro.?

Hi Klaus
I did get some time this afternoon to take a look at your suggestions.? Here's the feedback..
Problem 1. There were no other instances of VSDecoderPreferences.xml anywhere else, so?I did as you said and VSD did create two new Preferences files:
-rw-r--r-- 1 graham graham? ? ?496 Dec 30 15:47 VSDecoderPreferences.xml
-rw-r--r-- 1 graham graham? ? ?496 Dec 30 15:46 VSDecoderPreferences.xml.bak
But it showed the same error below both at startup and when doing an XML Validation:
2018-12-30 14:22:48,815 configurexml.ErrorHandler? ? ? ? ? ? ?ERROR - Parse error while parsing file /media/graham/MRUSB/JMRI/Settle_Sidings/vsdecoder/VSDecoderPreferences.xml Exception: org.jdom2.input.JDOMParseException: Error on line 2: cvc-elt.1.a: Cannot find the declaration of element 'vsdecoder-preferences'.
See for possibly more information. [AWT-EventQueue-0]
org.jdom2.input.JDOMParseException: Error on line 2: cvc-elt.1.a: Cannot find the declaration of element 'vsdecoder-preferences'.
Is this important ? since the VSD Manager itself seems to work OK.
Problem 2.? I bought the Pi specifically to run my new Settle Sidings layout I'm building and it will mostly be running without an attached Monitor/Keyboard, so yes I agree that a 'VSDecoder faceless' would be a good idea, though it would also be good to be able to see a web ui like the Panels and Turnout Tables as this could then be used to generate random audio for each loco using a remote device (iPhone, iPad etc).? I haven't yet been able to look at the articles you suggested in this section. Is the plan to extend the roster tables to include the VSD file allocated to each loco/decoder and also make the VSD Manager persistent?
Problem 3. I guess I just assumed that sound would work on the Pi3 (Ubuntu Mate) without having to configure anything and hadn't tried playing any other audio, so I tested it with one of the .wav files (JMRI/sounds/Bell.wav) and heard nothing on the test headphones, so Google found this for me:
The following command, entered in the command line, will switch the audio output to HDMI:
amixer cset numid=3 2
Here the output is being set to?2 , which is HDMI. Setting the output to?1 switches to analogue (headphone jack). The default setting is?0?which is automatic.
I had my headphones plugged into the audio output of the HDMI>VGA converter that I was using for my antique VGA monitor, but no sound, but when I changed the config to
amixer cset numid=3 1
and plugged the headphones directly into the Composite outlet of the Pi I heard the Bell ringing !!
After that I set up a VSD file in the VSD Manager and could hear all the Bells and Whistles !!!? So that problem is now solved, at least for now until I decide what speaker/amp setup I might want to use going forward.
I think I've still got lots to learn about the configuration and utilisation of VSDecoder, so I;m sure I'll be back asking more questions.? In the meantime if you have any further thoughts on problems 1 and 2 I;d be gald to hear them.
Many thanks
Graham - SettleDown