Re: LogixNG table editor and CSV question
#logixng
@danielb987 After our entire conversation here I am left with the feeling that my initial point, namely request JMRi developpers to provide a third option, besides "Tab separated" or "comma
By
Erik84750
·
#242533
·
|
Re: LogixNG table editor and CSV question
#logixng
Right, finally I got it. I had to tick "Hard Tabs" box.
By
Erik84750
·
#242532
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, changes to that file, not to the resulting .txt file (as I had done in my previous message). Yes. In your new row, you have spaces instead of TABs between the columns. Many text editors have a
By
danielb987
·
#242531
·
|
EngineDriver Beta v2.40.199 now available from the Play Store
#enginedriver
EngineDriver users, Peter Akers has continued his tireless efforts to keep EngineDriver the best wifi throttle app, and we have released a new Beta version for your review and feedback. Thanks Peter!
By
Steve Todd
·
#242530
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, To retain the Excel data format, do a two step save. The first save is for the Excel format. The "save as" creates the text file. The final step is to quit Excel. This is important since it
By
Dave Sand
·
#242529
·
|
Re: LogixNG table editor and CSV question
#logixng
Ok, so best is to keep an original Excel file: I read you make any changes to that file, not to the resulting .txt file (as I had done in my previous message). But when "save as" in Excel then the
By
Erik84750
·
#242528
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, I recommend that you always do the changes in Excel in the original Excel document and then export that document to a TAB separated text file. As long as the text file has the same filename, it
By
danielb987
·
#242527
·
|
Re: LogixNG table editor and CSV question
#logixng
Ok Daniel, understood. How do you modify (add values) to the JMRI_Users_Erik84750_test.txt file? I tried as follows: open this .txt file, and add a new row with tab separated values (see screen shot
By
Erik84750
·
#242526
·
|
Re: Simple way to move any loco between two points (automated)?
Thanks, I forgot about throttle! -- H.O. Australia (Layout in Progress) Digikeijs DR5000 LocoNet JMRI v5.10 DecoderPro/Warrants/CPE/SML/LogixNG Java: OpenLogic jre-17.0.12.7 ? Windows 10
By
Nags
·
#242525
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, Table does not place "Row 1"? and "1,23" and "2,46 and "Hello" each in its own record cell?? ..as is the case with your example file JMRI_Users_Erik84750_test.txt? That's because that file was
By
danielb987
·
#242524
·
|
Re: LogixNG table editor and CSV question
#logixng
I am confused now Daniel. I the Table import of JMRI_Users_Erik84750_test.csv the resulting Table does not place "Row 1"? and "1,23" and "2,46 and "Hello" each in its own record cell?? ..as is the
By
Erik84750
·
#242523
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, opens as follows (second screenshot below) in LogixNG Tables, with "comma separated tabs" is not separated from "1,23" etc.. ? It is correct. Header A, Header B, Header C is in the Excel file
By
danielb987
·
#242522
·
|
Re: LogixNG table editor and CSV question
#logixng
Your file JMRI_Users_Erik84750_test.csv (see first screenshot below) opens as follows (second screenshot below) in LogixNG Tables, with "comma separated tabs" To me it does not seem a correct import
By
Erik84750
·
#242521
·
|
Re: Simple way to move any loco between two points (automated)?
Nags, The "print" statement is used for debugging to make sure the values are as expected. Once everything is working you can comment the print lines. There is no speed unit. The value is the
By
Dave Sand
·
#242520
·
|
Re: LogixNG table editor and CSV question
#logixng
Ken, recognize the EU embedded characters in the number or time fields correctly. The issue may span a couple of different stages of this process. The import of CSV files treats each cell as a string.
By
danielb987
·
#242519
·
|
Re: Simple way to move any loco between two points (automated)?
Hi Nags, As I understand it, Dave has provided a script that is adaptable to multiple scenarios, but you could hard code direction (True for Fwd or False for Rev) and Long Address (True for a long
By
Trevor Rowland
·
#242518
·
|
Re: LogixNG table editor and CSV question
#logixng
Does the input also understand tab separated files? If so, that gets around the EU character issue in seeing the right number of fields. But that would still leave the question of if the importer
By
Ken Cameron
·
#242517
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, I too have Excel 2010. And I live in Sweden in northern Europe so I have the same problem with Excel CSV files as you have. I created an Excel file, JMRI_Users_Erik84750_test.xlsx, and stored it
By
danielb987
·
#242516
·
|
Re: Simple way to move any loco between two points (automated)?
Thanks for that Dave! I can sort of understand scripts just not up on all the syntax. As this will be consistent for direction and speed and long address, I assume I could hard code those
By
Nags
·
#242515
·
|
Re: LogixNG table editor and CSV question
#logixng
Erik, Forgot this mail. I missed that you have already answered my other email. Daniel
By
danielb987
·
#242514
·
|