These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

YamlToSQL: Import the YAML static data in SQL
Author
Previous Topic Next Topic
Jognu
French Kiss Singularity
#1 - 2012-05-25 14:48:13 UTC  |  Edited by: Jognu
For people like me that use a lot the MSSQL backup provides by CCP and who want to integrate the yaml files inside : this programm is for you !

How to :

  1. Import the MSSQL database backup in your SQL Server
  2. Place the yaml files (content in the zip) in the yaml folder
  3. Fill in the yamlToSQL.exe.config file with your authentication data
  4. Launch the yamlToSQL.exe
  5. Enjoy !


Quote:

Version 1.2_76477 for Inferno_1.2_76477
Version 1.0.0.0 for Inferno_1.0_70633


Sources : http://redmine.sparklin.org/projects/yamltosql

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Vessper
Dark Mason Society
#2 - 2012-05-25 21:59:13 UTC
Well done for taking on this project. I really hope that you continue to develop it as more and more tables disappear from the MSSQL database Blink
Jognu
French Kiss Singularity
#3 - 2012-05-25 22:21:05 UTC
I'll do, I need it myself !

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Korben Bada
Doomheim
#4 - 2012-05-28 09:49:03 UTC
Nice one, worked for me without issue so far. Cookie for you! Big smile
Zifrian
The Frog Pond
Ribbit.
#5 - 2012-05-28 11:32:09 UTC
Very nice. If you keep this updated, I don't think I'll have to make my own.

I'm a little concerned though about how CCP is doing this roll out. Seems like a lot of work to do when they could just transition all on one day instead of forcing us to continually do new updates every export. Oh well.

Thanks!

Maximze your Industry Potential! - Download EVE Isk per Hour!

Import CCP's SDE - EVE SDE Database Builder
Etil DeLaFuente
Aliastra
Gallente Federation
#6 - 2012-05-28 17:38:36 UTC
You really should try to make it less dependent on code compilation.

Here is an example of how you could achieve pretty much the same by using dynamic type generation and a simple mapping configuration file : http://pastebin.com/r304YTLR

The only thing you'll need to update is the configuration to handle new yaml files and let the rest being generated for you.
Desmont McCallock
#7 - 2012-08-10 20:07:05 UTC
Anti-expiration bump.
Jognu
French Kiss Singularity
#8 - 2012-08-12 10:50:54 UTC
Indeed, I'll make the update !

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803
Jognu
French Kiss Singularity
#9 - 2012-08-14 18:57:37 UTC
Update !
Quote:
Version 1.2_76477 for Inferno_1.2_76477

EveAI developper: https://forums.eveonline.com/default.aspx?g=posts&t=21803