CSV converters

[Garry Petrie]

In anticipation of a new BRIC needing the latest version of Topodroid, I sync'ed up to the latest version of Topodroid -- which of course has fewer survey export flavors. That's fine, the exporters may have left you wanting for the complete set of data. Is there a way for the CSV to expand the repeated leg shots to enable our own analyses?

I wrote a simple Perl script to convert CSV to WinKarst and it covers most of the cases I use. I didn't test using backsights since that only represents 5% of my surveys. It's attached and uses Strawberry Perl in Windows.

To that end, it would be nice to have a prototype CSV file that contained all the perturbations of Topodroid features to help validate any conversion  tools?

Garry 

[Balambér Hakapesz]

TopoDroid Settings - import/export - ENABLE:

all export format enable/disable

B.

--
You received this message because you are subscribed to the Google Groups "TopoDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topodroid+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topodroid/CANbKGSN_D2FuPPQdwf3SGA_ZnHLARKE6Q%3DMdVEi-9%2Bd9E%2BOt0w%40mail.gmail.com.

[Garry Petrie]

Just looked at, "complete" CSV export and kind of wished I had started with this type. A chance to recover my scripting skills since retiring from tech.

For the time number, what is the implied format? It doesn't appear to cover seconds as some shots contain the same time value.

Garry

To view this discussion on the web visit https://groups.google.com/d/msgid/topodroid/CAPq666NPi2LOcn2cJm4HgmuJJdowfFbZuSpsOmxizFTcFNzC2A%40mail.gmail.com.

[Balambér Hakapesz]

On Tue, Jul 9, 2024 at 7:39 PM Garry Petrie <dynam...@gmail.com> wrote:

Just looked at, "complete" CSV export and kind of wished I had started with this type. A chance to recover my scripting skills since retiring from tech.

For the time number, what is the implied format? It doesn't appear to cover seconds as some shots contain the same time value.

the download time, not the measurement time because it is not recorded

 

Garry

On Tue, Jul 9, 2024 at 10:08 AM Balambér Hakapesz <holl.b...@gmail.com> wrote:

TopoDroid Settings - import/export - ENABLE:

all export format enable/disable

B.

On Tue, Jul 9, 2024 at 6:59 PM Garry Petrie <dynam...@gmail.com> wrote:

In anticipation of a new BRIC needing the latest version of Topodroid, I sync'ed up to the latest version of Topodroid -- which of course has fewer survey export flavors. That's fine, the exporters may have left you wanting for the complete set of data. Is there a way for the CSV to expand the repeated leg shots to enable our own analyses?

I wrote a simple Perl script to convert CSV to WinKarst and it covers most of the cases I use. I didn't test using backsights since that only represents 5% of my surveys. It's attached and uses Strawberry Perl in Windows.

To that end, it would be nice to have a prototype CSV file that contained all the perturbations of Topodroid features to help validate any conversion  tools?

Garry 

--
You received this message because you are subscribed to the Google Groups "TopoDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topodroid+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topodroid/CANbKGSN_D2FuPPQdwf3SGA_ZnHLARKE6Q%3DMdVEi-9%2Bd9E%2BOt0w%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "TopoDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topodroid+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/topodroid/CAPq666NPi2LOcn2cJm4HgmuJJdowfFbZuSpsOmxizFTcFNzC2A%40mail.gmail.com.

--
You received this message because you are subscribed to the Google Groups "TopoDroid" group.
To unsubscribe from this group and stop receiving emails from it, send an email to topodroid+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/topodroid/CANbKGSMesUF9_oD2-EUqEeXQ43MorJiFLaBhvFOF8PQSj0svDA%40mail.gmail.com.

[Garry Petrie]

That is not the case, the time value varies in the export and is increasing from 1716570955 to 1717955760

To view this discussion on the web visit https://groups.google.com/d/msgid/topodroid/CAPq666OEwZww0EJWfhq40tMtunY%3DKo1QeCL6H15Qmgu1%2BJU4Tw%40mail.gmail.com.

[Garry Petrie]

Here's a version to read the complete CSV format. Getting better at remembering perl :-) 

[Garry Petrie]

Spent some more time on the script and yes indeed the item #10 in the complete CSV is the time the shot was taken. I added a switch to print the splays in the output or not.

I notice the "stat" field, item #16, is sometimes non-zero. I assume this is extra garbage in the data because it does not show up when all of the fields are checked in the Display Mode. Looking carefully, the CSV file has an #ID for the stat = 1, but that ID number is missing in the data display, essentially hidden in Topodroid. I am sure I am missing other corner cases, lol.

Garry