[Therion] import from Auriga

Martin Sluka martinsluka at me.com
Fri Sep 14 12:28:01 CEST 2012


Sorry for not necessary mails. The problem was uncorrected import of cvs file to spreadsheet. Only tabs as delimiters could be used.

m.s.

On Sep 14, 2012, at 10:53 AM, Martin Sluka wrote:

> There is an uncommented feature to export data directly to cvs. But I don't understand what the headers of several columns means.
> 
> End, (Azimuth), Direct and (Slope)
> 
> m.
> 
> <Screen shot 2012-09-14 at 8.11.24 AM.png>
> 
> 
> On Sep 14, 2012, at 10:02 AM, Footleg wrote:
> 
>> 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
>> <CompassToTherion.xls>_______________________________________________
>> Therion mailing list
>> Therion at speleo.sk
>> http://mailman.speleo.sk/mailman/listinfo/therion
> 
> _______________________________________________
> Therion mailing list
> Therion at speleo.sk
> http://mailman.speleo.sk/mailman/listinfo/therion




More information about the Therion mailing list