long track cant view and export

[m0535]

Hi Forum,

i need help, locus dosnt view or export a very long track.
The track is listed in the Tracklist in Locus and the track has following data in the sqll trackdb.

10016   2012-07-19 15:52:09   5   19h:45m:48s | 1865018m   {blob}   {blob}   {blob}   {blob}   71148098   1865018.362123   56140   1342705929571   {null}

Tracks bevor and after this entry are all ok.

How can i export this track with locus or direct over the sqll trackdb on my win7 with sqlliteman?

Thx from Germany
m0535

[tommi]

Hi, welcome in the forum!

You can export a track from Locus as (roughly) described here:
http://docs.locusmap.eu/doku.php/manual ... cks_screen 2.) Tracks List -> Export

[Menion]

Thanks Tommi for support, I'm just worried that this issue is probably this one https://getsatisfaction.com/locus/topic ... big_tracks

[m0535]

hi, thanks to tommi and menion, for the quick answers.
yes its the same problem, ..... , big tracks over xx MBytes in the Blob, locus cant open it.

Is there any way to export the affected Blob to an human readable format?
i think ...no way, like the other post.

thanks m0535

[Menion]

currently no simple method. I wanted to change way how locus store track data so there will be no such huge file, but not I discovered that there will maybe be some "hack" how to retrieve data directly in android from such huge table. May you, or anyone else, send me tracks.sqll file with track bigger then 1MB?? Thanks

[Menion]

interesting. I'm just testing it on my phone. Recorded quite long track (few circles), around 200km, 40k points! Blob data have around 1.9MB and seems to work without a problem!!! Maybe ICS have increased value for getting data from database?? Hard to test now ...

EDIT: I merged this with another track and then again with itself and seems that problem remain, limit is just increased to 2MB! So quite enough for normal usage anyway problem remain on below ICS phones and also - limit exists. So there is no need for testing track, I'll try to do something with it.

EDIT2: hmm so as I discovered, it's not simply possible in android receive just a part of blob object (so in some cycle load whole content of huge blob). So seems that original idea remain - complete rewrite SQLite schema of stored tracks in Locus (which will remove blob as is suggested not to use, on many places). This will anyway take some time

[m0535]

Hi Menion, i will send you a big track to "locus at asamm com". I have cleanup the dbtracks from my other tracks, its 21MBytes. The problemtrack is 2.9Mbytes.