New Version of Cmdr's Log Available!
- Thread starter ArchV1
- Start date
Not from within the app itself, but see page 15 of this thread - OldLost provided handy scripts and it is now possible.
I was thinking that the scripts to import EliteOCR CSV would be nice to add this into the CMDR Log as a option to "show/not show (and insert the {path})" for a button that executes the import from {path of CSV}
Has anyone made the CSV import command as a batch file? To limit the typing at every station?
Has anyone made the CSV import command as a batch file? To limit the typing at every station?
Last edited:
Here's a bat file: https://www.dropbox.com/s/o6vuu0jjwl1cd2o/CmdrsLogCSVImport.bat?dl=0
You will need to right-click it and select "Edit" and replace the three <stuff> tags with the appropriate paths.
The script still seems to get things wrong. I have Reactive Armour as Low Demand in my CSV file, but it ends up as Medium Supply in Cmdrs Log.
I also have Non-lethal weapons in there which are ignored.
- - - - - Additional Content Posted / Auto Merge - - - - -
Also, suggestion for Cmrds Log:
Have the "Anywhere" option be a checkbox next to the dropdown menus instead of among the systems/stations in the Trade window.
I also have Non-lethal weapons in there which are ignored.
- - - - - Additional Content Posted / Auto Merge - - - - -
Also, suggestion for Cmrds Log:
Have the "Anywhere" option be a checkbox next to the dropdown menus instead of among the systems/stations in the Trade window.
I'm not very good at programming but I have had some work experience with MS Excel so here is Version 1 of my attempt to semi-automate importing data into Cmdr's Log.
1. Use EliteOCR to grab data from the Commodities Market.
2. Save your data as Excel Workbook (.xlsx). Saving as CSV-File (.csv) will also work but you will have to "fix" the data by using the "Text to Columns" function.
3. Open the .xlsx file and copy Columns A-J.
4. Open the CMDRs Log Intergration Excel file and under the Station Commodities EliteOCR tab, paste your data in Columns A-J. The appropriate data is pulled automatically.
5. Under Column V, there are 5 cells that are colored black. Select the appropriate data from the drop-down list.
6. On the system_data Output tab, copy the shaded area A1-F767.
7. Open your system_data.txt file, preferrably in Notepad++, and paste the information in an appropriate space --- meaning after any other data but before the last "}". You do not have to add tab spaces, it should be done automatically. Pasting can be done in ordinary Notepad/Wordpad as well but I prefer Notepad++.
8. Save your system_data.txt file and the next time you open Cmdr's Log, the info should be entered completely.
Obviously, the Cmdr's log should **NOT** be open when you work with the system_data.txt file.
I hope it is okay with ArchV1 if problems with the Excel file would be posted here. If there are a lot of issues, I may start a thread just for it but I think the file should work fine for the meantime. Thanks and enjoy!
[This is done using v2.0c of Cmdr's Log info]
1. Use EliteOCR to grab data from the Commodities Market.
2. Save your data as Excel Workbook (.xlsx). Saving as CSV-File (.csv) will also work but you will have to "fix" the data by using the "Text to Columns" function.
3. Open the .xlsx file and copy Columns A-J.
4. Open the CMDRs Log Intergration Excel file and under the Station Commodities EliteOCR tab, paste your data in Columns A-J. The appropriate data is pulled automatically.
5. Under Column V, there are 5 cells that are colored black. Select the appropriate data from the drop-down list.
6. On the system_data Output tab, copy the shaded area A1-F767.
7. Open your system_data.txt file, preferrably in Notepad++, and paste the information in an appropriate space --- meaning after any other data but before the last "}". You do not have to add tab spaces, it should be done automatically. Pasting can be done in ordinary Notepad/Wordpad as well but I prefer Notepad++.
8. Save your system_data.txt file and the next time you open Cmdr's Log, the info should be entered completely.
Obviously, the Cmdr's log should **NOT** be open when you work with the system_data.txt file.
I hope it is okay with ArchV1 if problems with the Excel file would be posted here. If there are a lot of issues, I may start a thread just for it but I think the file should work fine for the meantime. Thanks and enjoy!
[This is done using v2.0c of Cmdr's Log info]
Last edited:
Here you go. https://www.dropbox.com/s/hmf7zlbj0fjek4c/LHS%203595.Chaudhary%20Hub.2015-01-19T21.33.35.csv?dl=0
Note that some people have mentioned that there needs to be some corrections done to the commodities spelling in the CSV to match those in Cmdr's Log.
Last edited:
This would be great.
hehehe, that *IS* our fault
Many things are. Come to think of it, the convert F to C feature is my fault
Lol, was wondering why in the world that was in there!Many things are. Come to think of it, the convert F to C feature is my fault
Well on the plus side I didn't do a damn thing tonight
We HAVE to quote, no other way to refer to a post
You need to change Non-lethal to Non-Lethal in default_commodity_data file.
Awesome! Thank you!Well on the plus side I didn't do a damn thing tonight
It might be better to do what I did actually and correct the spelling in the default_commodities_data.txt file. Then the imported data works. It's a simple thing to do.
Don't forget to do a find & replace on your system_data.txt to update those names or the ones you've already entered with the "wrong" names will not be displayed.
- - - - - Additional Content Posted / Auto Merge - - - - -
Ah.
Misspelled commodities so far (From EliteOCR's perspective):
Hydrogen Fuels -> Hydrogen Fuel
Consumer Tech -> Consumer Technology
Fruit and Vegetables -> Fruit And Vegetables
HE Suits -> H.E. Suits
Non-lethal Weapons -> Non-Lethal Weapons