Adding objects by CSV

[Brett Laniosh]

I want to add binary/multiple star targets as a custom database. I've add this this as a feature request but for now, I can add them from an existing database. 

The problem is that the RA is listed in hh mm.s format (EG Almach in And is given as 

RA 02 03.9 and DEC +42 20

So DEC is ok to import but RA needs to be in hh:mm:dd format for SkEye

Any idea what the Excel formula is to convert my RA ?

[Harshad RJ]

Hi Brett,

It seems like splitting the text into columns and then recombining them might be the easiest option. You could try splitting the text as described here using this pattern (without quotes): "* *."

That is, star space star dot. It worked in Libre Calc.

(The linked page has other ways of splitting, but they look messy).

After that, you need to combine them back again, but that should be easy.

If that doesn't work out, let me know, I will write a script which will convert it automatically.

best,

Harshad

--
You received this message because you are subscribed to the Google Groups "SkEye Discussions + Announcements" group.
To unsubscribe from this group and stop receiving emails from it, send an email to skeye+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/skeye/e5bc9bd9-5c88-48a2-982b-63b4019950a8n%40googlegroups.com.

--

Harshad RJ

[Brett Laniosh]

I prefer to avoid plugins and VBA.

I used this formula which seemed to work

=LEFT(C2,2)&":"&INT(RIGHT(C2,LEN(C2)-SEARCH(" ",C2)))&":"&(RIGHT(C2,LEN(C2)-SEARCH(".",C2)))/10*60

Hopefully, this format will work?

H:M:S
23:9:30
23:7:54
23:7:36
23:7:30
23:7:12
23:6:48
23:6:48
23:6:48
23:59:30
23:59:0
23:59:0
23:58:42
23:58:12
23:58:12
23:54:24
23:54:24
23:53:6
23:53:48
23:51:48
23:5:6  

[Brett Laniosh]

Is it possible to search for double or binary stars instead of having to manually enter them? It would be great to have binaries listed on the "what's in view now" list. Perhaps a separate tab for significant doubles?

DSOs are visible in map view, please could we have the same for doubles so that we can distinguish them from other stars?

Brett

[Harshad RJ]

Hi Brett,

DSOs are visible in map view, please could we have the same for doubles so that we can distinguish them from other stars?

Let me answer that first. Yes, I am planning to support this soon.

You are the first person whom I have heard using the Custom Catalogs feature. Until now I was not sure if I should spend more time on it. But now I will.

Is it possible to search for double or binary stars instead of having to manually enter them?

Yes, I want to add support for that eventually. I saw your idea posted on UserVoice. For others' benefit, it's here:

https://skeye.uservoice.com/forums/93533-ideas/suggestions/42511510-add-a-binary-star-tab

It would be great to have binaries listed on the "what's in view now" list. Perhaps a separate tab for significant doubles?

I am worried about there being too many tabs. I will perhaps have to split the tabs into two levels:

On the first level would be "Solar System Objects" and "Deep Sky Objects".

Under these top-levels would be "Planets, Comets, Meteor Showers, Satellites" and "Stars, Messiers, NGC, IC" respectively.

Stars could have a third level underneath them "Solitary, Binaries, Doubles", etc.

But splitting the UIi like this requires some effort. I am prioritizing some other things right now, but will come back to this soon.

Just sharing some context behind the choices.

best,

Harshad

[Travis Swaim]

Harshad RJ wrote on 01/25/2021 9:03 AM:

Under these top-levels would be "Planets, Comets, Meteor Showers, Satellites" and "Stars, Messiers, NGC, IC" respectively.

Stars could have a third level underneath them "Solitary, Binaries, Doubles", etc.

Thanks for the effort. On the stars tab, could you add checkboxes to filter each category instead of having to split them out to their own tab? You could then uncheck Solitary, and then have Doubles and Binaries still showing? Just a thought, didn't know if it would make implementing the list easier (or harder).

[Harshad RJ]

On Mon, Jan 25, 2021 at 8:45 PM Travis Swaim <cheet...@gmail.com> wrote:

Thanks for the effort. On the stars tab, could you add checkboxes to filter each category instead of having to split them out to their own tab? You could then uncheck Solitary, and then have Doubles and Binaries still showing? Just a thought, didn't know if it would make implementing the list easier (or harder).

Good idea! Will try that and if that becomes too much effort / clutter, will try to club the "Double and Binaries" into a single tab.

--

Harshad RJ