Celestia Forums

So i'm working for a RSG catalog for celestia, and I would want someone to make a tutorial for me on how to export simbad data (from criteria query) into an STC file. The query i'm using is: http://simbad.u-strasbg.fr/simbad/sim-sam?Criteria=%28spstring+%7E+%27M%27+%7C+spstring+%7E+%27K%27%29+%26+splum+in+%28%27Ia%27%2C+%27Ia-ab%27%2C+%27Ia%2Fab%27%2C+%27Ia-Iab%27%2C+%27Ia%2FIab%27%2C+%27Iab%27%2C+%27Iab-Ib%27%2C+%27Iab%2FIb%27%2C+%27Ib%27%2C+%27Ib-II%27%2C+%27Ib%2FII%27%2C+%27%28Ia%29%27%2C+%27%28Iab%29%27%2C+%27%28Ib%29%27%2C+%27I%27%2C+%27I-II%27%2C+%27%28I%29%27%29+%26+Vmag+%3C%3D+14&submit=submit+query&OutputMode=LIST&maxObject=10000&CriteriaFile=
I will also need a way for it to get the variable star designation if it exists, and put it as the first name of the star unless there is a Bayer/Flamsteed designation.
I also want a way to import stellar radii into the file from TIC v8, and wikipedia (which i will do manually). (1 Rsol = 696,156 km)

Added after 3 minutes 3 seconds:
btw sorry if this is not the right forum category for this

So first go to the output options page. Check the box next to "parallax", change the coordinates from sexagesimal to decimal, and under "Output format", select "separator for spreadsheet" and "file output". It should look like this:

Click "Save", then go to the criteria search and enter your query again. A file should download called "simbad.csv". The CSV file isn't correctly formatted, so you need to fix this. Select the first column, then go to "Data" -> "Text to Columns". Select "Delimited", then "Semicolon", then "Finish". Click "OK" in the dialog box asking to confirm.
To get designations other than the SIMBAD default one (e.g. HIP, TYC, variable), you have to go back to the output options page and under "Identifier", select "from catalog list" and enter the name of the catalog (for variable stars this is "V*"). You may have to clear browsing data and save again for the new output options to take effect. In each case, download the new CSV file and fix the formatting as before.
As for turning those CSVs into an STC, you can either write a script to do it, or do it entirely in Excel (Luke will have to explain how to do the latter). No idea on how to export the TIC data.