Solved Automating the processing of some flight-logs, how?

September 7, 2020 at 02:51:12
Specs: Windows 7
Hello.
I did post this question, with complete details, elsewhere and the post was pulled for being too unfocused.
I will try here but take it one step at a time, it that is the wrong approach I will give full details.
I want to process over 1000 DJI drone .txt flight-logs. In their raw form these logs are not human readable so the programs CsvView.4.0.4 or TXTlogToCSVtool_general are used to translate them.

First question, under windows how do I get either of the above programs to automatically and sequentially read/work-through all the flight logs in a given folder?

The manual process is
a) start the program,
b) choose and upload the desired flight-log to it,
c) wait for the program to process the flight-+log then
d) choose to output the results as a csv file,
e) choose a location and name for that csv file,
f) next flight-log

Thanks for any answers

message edited by seanmckinney


See More: Automating the processing of some flight-logs, how?


✔ Best Answer
September 8, 2020 at 14:31:21
Ahhhh ha I found the start of the solution, on the command line
C:\tempx>TXTlogToCSVtool C:\tempx\DJIFlightRecord_2020-09-08_[19-12-21].txt C:\temp\DJIFlightRecord_2020-09-08_[19-12-21].csv

That's with the program TXTlogToCSVtool and the relevant flight log (DJIFlightRecord_2020-09-08_[19-12-21].txt) in the folder C:\tempx

based on the above FORFILES /m *.txt /C "TXTlogToCSVtool /c @file @fname.csv" on the command line processes all the files, perhaps not the most elegant of solutions but it works

message edited by seanmckinney



#1
September 7, 2020 at 09:11:27
Do you know if the program CsvView.4.0.4 has Command Line options?

With out them I don't see how a script can process the files, as most of the action
occurs within the program.

But, others here may have ideas on how it might work.

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
September 7, 2020 at 22:52:22
mmcon has it spot on. If you don't have command-line option for retrieval of the output, (ie: stuck with GUI crap) then you might be SOL. If the gui interface accepts key-sequences as alternative to "clicks", then you might have a chance to use sendkeys: alt-this, ctrl-that. etc. to achieve your goal. To test that, put your mouse aside, and try to use only the keyboard to get a result. If you can do that, then sendkeys should be able to do it as well. But it's a last resort, and subject to lots of "tweaking", usually. In this case, it would be like: alt-F (file open), type name of the flight-log, wait, then alt-A (save as) "CSV", and type name of output file. If you can do all this WITHOUT using the mouse, then maybe...I can help with sendkeys, which sends all the keystrokes, including typing, to an open window.

message edited by nbrane


Reply ↓  Report •

#3
September 8, 2020 at 03:50:26
Thanks for the replies I will have a play later today and see what I can 'see'.

message edited by seanmckinney


Reply ↓  Report •

Related Solutions

#4
September 8, 2020 at 14:31:21
✔ Best Answer
Ahhhh ha I found the start of the solution, on the command line
C:\tempx>TXTlogToCSVtool C:\tempx\DJIFlightRecord_2020-09-08_[19-12-21].txt C:\temp\DJIFlightRecord_2020-09-08_[19-12-21].csv

That's with the program TXTlogToCSVtool and the relevant flight log (DJIFlightRecord_2020-09-08_[19-12-21].txt) in the folder C:\tempx

based on the above FORFILES /m *.txt /C "TXTlogToCSVtool /c @file @fname.csv" on the command line processes all the files, perhaps not the most elegant of solutions but it works

message edited by seanmckinney


Reply ↓  Report •

Ask Question