Re: [nbos] Exporting AstroSynthesis data.
Kevin Grimm
Wed Aug 15th, 2007
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: []
On Behalf Of David Loman
Sent: Wednesday, August 15, 2007 7:51 AM
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 or here on the mailing list.


On 8/15/07, Daniel Williamson <> 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.



----- Original Message ----
From: NBOS Support <>
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?

Nbossoftware mailing list

Yahoo! oneSearch: Finally, mobile search
that gives answers, not web links.
Nbossoftware mailing list

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