Hi

Sorry but I don't speak German... so here is my issue in English(ish).

I have an issue with CRP completely losing the plot with XYZ's and think it could be related to export-reimport data to/from Excel phase.
When I first create the cave and enter the coordinates and altitude and import my raw data, everything works nicely: the cave in the right position in G-maps... multi cave project staggers the caves as they should in 3D mode, etc. But after some time editing data via Excel (using CRP routine), it looks like CRP looses track of the orgin of one or several of the cave(s) and the calculation of XYZ become wrong: caves are located in a "ramdom" places and altitude seems wrong. the cave is still there but just not correctely located.
Although I haven't been able yet to narrow down the issue to a specific operation I have encounter this issue with single cave or multi-caves projects.
I wonder if it could be related to changes between geographic vs UTM projections as well as sea level ref and cave ref.
Most worrying, I haven't succeed in correcting the issue by editing coordinates and altitude...
Is this a known issue? Did I do something wrong at some point? Any clues on how to force CRP to recalculate correct XYZ's without starting from scratch?
Cheers

Hi Jochen,
Files sent with PM.
Cheers
Thomas

Thanks for that.

Just for the sake of documenting the issue and fix.

Your instructions received by PM.

"you have to delete the coordinates at all reference points." (ie. in Daten/Data/Donnée > X 0,0 Y 0,0 Z 0,0)
"Because the coordinates are located in cave data" (i.e. Holendaten/Cave data/Donnée de la cavité)

It did the trick for the 2 first caves just by changing the XYZ to 0,0 0,0 ,0 directly in the CRP table but it didn't work for the third cave and I had to do these extra steps:
1 - set the GPS coordinates and altitude back to 0,00
2 - click Edit in Excel
3 - Remove all RefX/RefY/RefZ/X/Y/Z values in Excel files and Save
4 - Load the data from Excel
5 - Calculate
6 - Re-enter the coordinates and altitude.

And it worked

Cheers

Hi Jochen,

Further on this issue... it doesn't seems to be related to the projection or altitude reference being change, unless once a new cave data is imported this is written "forever" to the *.xml file, which could explain why I still have issues. However, as it stands, it seems to be related to the export data to excel (edit) and reload data to CRP flow. Maybe there is something to investigate here to stabilise the process. The correction flow I gave earlier works but would be good not to have do this every time I work on the data... I personaly prefer editing the data in Excel than in CRP.

Best regards
Thomas

Hi Jochen,

I have reloaded the original file to try to narrow down the issue(s).

I reproduced the issue on how I got the negative E/N value. Export to Excel with Geographic North and reloaded the data with UTM Grid selected... this gave me negative E/N. I won't do that ever again...

But I had some issues getting the third cave right: in this file, there are 3 caves: 15/1, 15/31 and 15/32 and when I look at the RefXYZ and XYZ, they are all with high negative E/N value caused by the issue described above.

For 15/1 and 15/31
when I change the X/Y/Z to 0/0/0 and hit Calculate, all XYZ get fixed... easy fix, no need to remove the Lat, Long, Altitude data.

For 15/32
it's a different story when I set X/Y/Z to 0/0/0
> For the first line, it's back to negative E/N values, no change to the rest of the X/Y/Z.
> For the reference point (line given when I hit "Reference" button), which is the second line, and hit calculate, all the X/Y/Z for the lines below become good but not the first line just above, which remains with negative E/N like values.
In both case, removing the Lat, Long, Altitude doesn't help.

However I think I might have found the issue playing some more with the data: The reference point is not the first line! This is because I added an extra point to better 3D shaped the entrance of the cave. The original Ref is 200101/1 but I added 200100/0 and I believe this is why CRP struggles because it cannot recompute the coordinates of this extra point.
I had:
RefPassage Ref Station Passage Station
200100/0 200101/0
200101/0 200101/0 (Original Ref)

But if I change to
200100/0 200100/0 (New Ref)
200100/0 200101/0

Then the reference point become the first line and setting XYZ to 0/0/0 and hit calculate sort all the mess...

This seems to explain why I struggled so much to get things back in order

I hope this clarify this issue(s)


Cheers
Thomas