×

INDI Library v2.0.6 is Released (02 Feb 2024)

Bi-monthly release with minor bug fixes and improvements

How to copy horizon from one device to another?

  • Posts: 237
  • Thank you received: 33
Is there a way to copy the horizon info from one device to another? I have my horizon all mapped out on the RPI running kstars 3.6.0 and wish to copy that to my laptop running 3.6.1 on Linux Mint Vanessa.
1 year 5 months ago #87102

Please Log in or Create an account to join the conversation.

  • Posts: 268
  • Thank you received: 72
Hi Astromuni

With a bit of work it can be done easy!

Look for "DB Browser for SQLite" ( sqlitebrowser.org/ ) and - on the RPI - open the database '/home/<username>/.local/share/kstars/userdb.sqlite". It's a bit cumbersome with the hidden directory ".local", but just be sure to list the hidden files in the file browser. Go to "Browse Data" and look for table "Horizons". Depending of your regions they should be listed by name in this table. Go back to "Database Structure" and right-click on "Horizons" and all the regions to export each table to an corresponding named CSV-file one by one.

To import the data create (if necessary) the aforementioned tables on the laptop. Watch out that they have an identical structure as the original ones and that they are empty. Now go to "Browse Data", open the tables and import the corresponding CSV-files one by one. Keep an eye on possible records with headings in the regions tables: All records shall be filled only with numbers (Azimuth and Altitude). With "Write changes" the new data is saved to the database.

Like always it is recommended to work on a copy of the database! So backup "userdb.sqlite" first.

That's it and all the best!
The following user(s) said Thank You: AstroMuni
Last edit: 1 year 5 months ago by Toni Schriber.
1 year 5 months ago #87106

Please Log in or Create an account to join the conversation.

Time to create page: 0.403 seconds