120ccpm
Captain
Flight distance : 1245115 ft
United States
Online
|
crash1sttime Posted at 4-18 05:23
Ok ive got the sheet to work and it works great so just 2 more questions
1) the cell labelled CUSTOM.updateTime has this in the cells
Ok, it's a bit complicated and painful to explain, but I'll try.
1) CUSTOM.updateTime is recorded as a full timestamp, down to 1/1000 of a second. If you open the CSV with a text editor, you will see entries like "2020/03/22 01:22:05.867". If you open the CSV with Excel, it recognizes updateTime entries as date/time values, and displays them the way it thinks is more appropriate, in this case minutes:seconds.decimals, like "22:05.9" . The full timestamp is still there, so if you play with cell formatting, you can make it display whatever you want. Problem is, if you now save the file (as a CSV), Excel will not save the full timestamps, but whatever it's displaying.
Long story short, I recommend NOT editing the CSV flight records in Excel.
2) I don't own that tool, a guy by the name of ferraript does, and he has a thread on the PhantomPilots forum. Personally, I don't see the reason for what you're asking, as you're effectively losing information. Besides, CAMERA_INFO.videoRecordTime displays the time in seconds of the current video, so it cannot be used as a timestamp for the entire flight log. Now, since DashWare does not need a full timestamp, if you really want an updateTime that is easy for you to read (starting from 0), you can do the following:
- create a new CUSTOM.updateTime column next to the original one (let's say it's now column B)
- select the entire column and set cell formatting to General
- set B2 to 0 (zero)
- in B3, enter the following formula: =B2+0.1
- expand the formula to all other cells (select B3, double-click on little green square, bottom-right)
- select entire column, Ctrl-C, then Paste > Values
- delete the original updateTime column
The final result is a file that DW should properly recognize (I did a quick test, it worked) and it's easy for you to read, as the timestamps is expressed in seconds and decimals. But, quite frankly, in all the years I used DW, I never (ever) had the need for something like this!!!
|
|