[Therion] import from Auriga

Footleg drfootleg at gmail.com
Fri Sep 14 10:02:31 CEST 2012


I've done this via the Compass format. I export from Auriga to Compass
format using the conduit.
I then cut and paste my the data from the Compass file (which is plain
text) into MS Word.
An example of some data:

  FROM  TO  LENGTH  BEARING  INC  LEFT  UP  DOWN  RIGHT  FLAGS  COMMENTS

ORIG.00  ORIG.01  22.96  228.1  0.0  -999.00  -999.00  -999.00  -999.00
ORIG.01  ORIG.02  50.84  253.1  0.0  -999.00  -999.00  -999.00  -999.00
ORIG.02  ORIG.03  54.12  243.1  2.0  -999.00  -999.00  -999.00  -999.00

Use search and replace to convert all double spaces into single spaces
until every data item is separated by a single space character.
Then replace the spaces with commas and save the data as a CSV file.
Open the CSV file in Excel (or convert data to table in MS Word and
then you can copy and paste it straight into an Excel spreadsheet).

Use the attached spreadsheet to convert the compass format data (which
will have converted all lengths into feet), to survex/Therion
formatted data.
The spreadsheet was actually originally written for Survex where I put
the LRUD data as a comment on the end of the leg. But you can
rearrange the formulae in the spreadsheet to alter for format to suit
how you want it.

Finally copy and paste the data from Excel back into a plain text file
editor to generate the therion or survex files.

I am working on adding Compass reader and writers to my cave data
converter tool, but that addition is not top of my todo list right
now.
(This is the tool I am talking about if anyone did not know about it:
http://www.darkgem.com/wscc/caving-talk/index.php?title=CaveSurveyDataConverter
)

Footleg

On 14 September 2012 08:17, Martin Sluka <martinsluka at me.com> wrote:
> Has anybody tried to import data from Auriga?
>
> If yes, please may you send me a "cookbook", please.
>
> Thanks
>
> Martin s.
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> http://mailman.speleo.sk/mailman/listinfo/therion
-------------- next part --------------
A non-text attachment was scrubbed...
Name: CompassToTherion.xls
Type: application/vnd.ms-excel
Size: 52736 bytes
Desc: not available
URL: <http://mailman.speleo.sk/pipermail/therion/attachments/20120914/091c5258/attachment.xls>


More information about the Therion mailing list