Re: [nbos] Importing .csv files
Daniel Williamson
Mon Feb 5th, 2007
OK, then I will work on a script to do that. It'll go slower because it'll have to be in AS not perl, so I can only work on it at home.... As for the script to detect duplicates, its a perl script that I would have to change. The script I wrote added randomly generated stars to an existing data set and eliminated those that were too close to an already existing star. It would have been easy to modify it to do what you needed it to do.

On to learn AS.

Dan
___________________________________________________
"Umm..."


----- Original Message ----
From: Mike Oliver <mike-oliver-at-blueyonder.co.uk>
To: nbossoftware-at-nbos.com
Sent: Monday, February 5, 2007 6:07:07 AM
Subject: Re: [nbos] Importing .csv files


Hi Dan:

You will have seen that I have overcome the immediate problem of
duplication, so I don't need to trouble you with sorting that out. My
need is now really in case I confront a similar difficulty and want to
repeat the process - my way is long-winded.

The Search facility I am seeking is exactly as you described. If one
enters "K0", for example, into the current Search facility, no results
are produced because the search facility only looks in Names and Notes.
If you can come up with that, I'd find it highly useful - and I suspect
a number of other users would too. If one has a survey ship out looking
for Earth-type planets, G2V systems would be a good place to start and
the nearer the better.

Cheers,

Mike

-----Original Message-----
From: nbossoftware-bounces-at-nbos.com
[mailto:nbossoftware-bounces-at-nbos.com] On Behalf Of Daniel Williamson
Sent: 5 February 2007 03:04
To: nbossoftware-at-nbos.com
Subject: Re: [nbos] Importing .csv files

Hi Mike,

If you send me both csv (or AS, I can export to csv) files off list I
can return a file to import into AS.

I can probably write the second script you ask for, but I'm really best
in perl and would struggle with writing it in AstroScript. I realize
that a perl script will be useless to you, so I could work on the AS
version. You want to be able to enter a free text spectral type and a
distance from the selected star and have it provide a list of all stars
that satisfy that criteria? Entering "K" would match everything from
K0V to K9V and K0III for example?

Dan.

___________________________________________________
"Umm..."

----- Original Message ----
From: Mike Oliver <mike-oliver-at-blueyonder.co.uk>
To: nbossoftware-at-nbos.com
Sent: Sunday, February 4, 2007 6:44:18 AM
Subject: Re: [nbos] Importing .csv files

Dan:

That would be highly useful. The map into which I want to import has
star names based on the Bayer/Flamsteed systems, with quite a few "GJ"
references and the odd HIP and HD numbers. The .csv file for importation
has all HIP and/or HD names with some "BD+...." and the like.

This is why the standard AS method for eliminating duplications won't
work. The work-around involves deleting all the Bayer/Flamsteed and
other references from the .csv file on the basis of their distance from
Sol. All the stars in the map lie within 100 lt yrs of Sol, whilst the
.csv file goes out to 1000 lt yrs.

If your script can identify the spectral types, could it be adjusted to
allow searching to identify all systems of a user-defined spectral type
(from "G type" to "G2III" type) and include the ability to do so within
user-specified distances from any other star?

Cheers,

Mike

-----Original Message-----
From: nbossoftware-bounces-at-nbos.com
[mailto:nbossoftware-bounces-at-nbos.com] On Behalf Of Daniel Williamson
Sent: 2 February 2007 14:02
To: nbossoftware-at-nbos.com
Subject: Re: [nbos] Importing .csv files

I already have a script written that will detect stars that are too
close to one another. I could tweak it to take into account other
factors like spectral type or other factor that is in the data file.

Dan.

___________________________________________________
"Umm..."


----- Original Message ----
From: Nyrath the nearly wise <nyrath-at-projectrho.com>
To: nbossoftware-at-nbos.com
Sent: Thursday, February 1, 2007 10:22:27 AM
Subject: Re: [nbos] Importing .csv files


Mike Oliver wrote:
> Yes, that's more or less why I asked the question. That was the method
I
> believed should work. The actual duplicates were definitely not
skipped
> and I got multiple duplications. I can sort of see the reason why it
> happened. The programme is looking for a duplicated name and if, as I
> have done, systems have been re-named from the original, there is no
> duplication perceived.
>
> I wish I'd realised this was the case before doing all the work I've
> done. It looks like I'll have to go through and manually delete each
> duplication. Heaven knows how many there are or how I'll identify
them.

I believe that AstroSynthesis can export *.csv files.
In theory one could export the existing star list,
merge the two *.csv files, and write a quick and dirty
program to parse through it and make a list of
stars that are suspiciously too close to each other.
Or even to weed them out.
_______________________________________________
Nbossoftware mailing list





________________________________________________________________________
____________
Now that's room service! Choose from over 150,000 hotels
in 45,000 destinations on Yahoo! Travel to find your fit.
http://farechase.yahoo.com/promo-generic-14795097
_______________________________________________
Nbossoftware mailing list





_______________________________________________
Nbossoftware mailing list








________________________________________________________________________
____________
Do you Yahoo!?
Everyone is raving about the all-new Yahoo! Mail beta.
http://new.mail.yahoo.com
_______________________________________________
Nbossoftware mailing list





_______________________________________________
Nbossoftware mailing list





____________________________________________________________________________________
Expecting? Get great news right away with email Auto-Check.
Try the Yahoo! Mail Beta.
http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html
_______________________________________________
Nbossoftware mailing list


Copyright © 2003-2007, NBOS Software. All rights reserved. 'Fractal Mapper', 'ScreenMonkey', 'Character Sketcher', 'Inspiration Pad', 'Fractal World Explorer', 'Goblin API', 'AstroSynthesis' are trademarks of NBOS Software. 'Dwarven Beserker' art by V. Shane.
Member contributed resources