[nbos] Exporting AstroSynthesis data.

[David Loman]

Mainly that i felt portability and compatability where key, hence the csv
AND sql options.  Coding for a direct db connection can get proprietary and
complex pretty quick and can leave the end user with their head spinning.
I am sure its possible to have an astroscript link directly to db... i just
fon't have the time anymore to code such a script :)

On 8/15/07, Kevin Grimm <grimm.kevin at gmail.com> wrote:

>

>              I really liked David Loman's Idea of the Sql Importer. I've

> made some improvements using stored procedures and a nested tree format for

> body data. David, is there any reason you don't write directly to the

> database instead of creating sql files?

>

>

>  ------------------------------

>

> *From:* nbossoftware-bounces at nbos.com [mailto:

> nbossoftware-bounces at nbos.com] *On Behalf Of *David Loman

> *Sent:* Wednesday, August 15, 2007 7:51 AM

> *To:* nbossoftware at nbos.com

> *Subject:* Re: [nbos] Exporting AstroSynthesis data.

>

>

>

> There have been one or two people who have not had success with my csv/sql

> exporter.  Unfortuentately, the exact bug/failure they ran into was never

> forwarded to me, so I couldn't fix whatever was wrong.  Hopefully all will

> work fine for you!

>

>

>

> I, too, am using the Astro2 data in a game.  Since the quantity of data I

> was looking for was quite massive, I took the liberty to write the SQL

> portion of the exporter.  This allowed me to move data in this fashion:

>

>

>

> Astro2 -> SQL files

>

> SQL Files -> MySQL database.

>

>

>

> Since my computer game is a client/server setup, having all the universe

> info in a database allows for quick access & searching as well as allowing

> the content to be accessed by a variety of sources other than the game. The

> specific use I am using the MySQL data for is a website that players of the

> game can use as a reference.

>

>

>

> Just some ideas.  If you have any troubles with the exporter just drop me

> a line at dloman77 at gmail.com or here on the mailing list.

>

>

>

> -Dave

>

>

>

> On 8/15/07, *Daniel Williamson* <enki_29205 at yahoo.com> wrote:

>

> Actually, I recommend the CSV exporter.  I tried using the XML exporter

> and was going to use a Perl script to process the output, but the lack of

> line feeds made it not worth the trouble.

>

> If you don't need to bring it back into AS, it will work fine.

>

> Dan

>

> ___________________________________________________

> "Umm..."

>

> ----- Original Message ----

> From: NBOS Support < support2 at nbos.com>

> To: nbossoftware at nbos.com

> Sent: Tuesday, August 14, 2007 1:44:24 AM

> Subject: Re: [nbos] Exporting AstroSynthesis data.

>

>

> The XML exporter.  Of course, you'll need to write a corresponding

> importer

> for your game.

>

>

> At 09:39 PM 8/13/2007, you wrote:

> >I would like to export the system and trade route information to another

> >program for use in working on a computer game.

> >

> >What is the best / easiest way to do this?

> >

> >Shain

>

>

> _______________________________________________

> Nbossoftware mailing list

> Nbossoftware at nbos.com

> http://www.pairlist.net/mailman/listinfo/nbossoftware

>

>

>

>

>

>

>

> ____________________________________________________________________________________

> Yahoo! oneSearch: Finally, mobile search

> that gives answers, not web links.

> http://mobile.yahoo.com/mobileweb/onesearch?refer=1ONXIC

> _______________________________________________

> Nbossoftware mailing list

> Nbossoftware at nbos.com

> http://www.pairlist.net/mailman/listinfo/nbossoftware

>

>

>

> _______________________________________________

> Nbossoftware mailing list

> Nbossoftware at nbos.com

> http://www.pairlist.net/mailman/listinfo/nbossoftware

>

>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pairlist.net/pipermail/nbossoftware/attachments/20070816/8f37cd58/attachment.html>