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.
 

Help reading from the Static Data.

First post
Author
Previous Topic Next Topic
Rune Mangeiri
Soltech Armada
Minmatar Fleet Alliance
#1 - 2015-08-07 15:28:15 UTC
Hello all,

Like it says in the title I need help reading from the static data using Visual Studio 2013. I am completely new to SQL and the YAML format that static data is currently in and can't seem to find a way to read the data. I have been working on this for a few days and can't seem to figure how a good way to actually read from the Yaml file. I am coding using C# in Visual studio and was able to find one Yaml library(http://yaml-net-parser.sourceforge.net/). The problem I am having with the library is that the sample code provided only reads the first like of the file and the documentation is mostly empty.

So if someone actually knows the correct way to use that library or some other clever way to manipulate the static data please help me out.
Hel O'Ween
Men On A Mission
#2 - 2015-08-07 16:06:23 UTC
If you insist on using the YAML files yourself, I can't help you at all.

But if you're OK with having the data/tables in the YAMLs (and also the stuff in the SQLITE db) back in the (MS SQL) SDE, like in the good old days, I highly recommend to have a look at Desmont's (of EVEMon) SDEExternalsToSQL tool.

EVEWalletAware - an offline wallet manager.
Rune Mangeiri
Soltech Armada
Minmatar Fleet Alliance
#3 - 2015-08-07 17:06:13 UTC
Thanks for the reply!

I will take a look at this. I have a feeling this is exactly what I need to get my app moving.
Rune Mangeiri
Soltech Armada
Minmatar Fleet Alliance
#4 - 2015-08-07 18:25:48 UTC
Starting to feel like an idiot....

- I downloaded the file.
- Placed the YAMLs in the YAML's folder and the universe data in the SQLiteFiles folder.
- Ran the exe ( with my fire wall off to make sure it didn't have a problem.

But the program seems to have trouble connecting to the SQL server.

"Reason was: A network-related or instance-specific error occurred while establishing a connection to SQL Server."

Any ideas what I am doing wrong?
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2015-08-07 19:39:31 UTC
if you're at all comfortable with python, https://github.com/fuzzysteve/SDE-loaders may be of interest, for an alternate method to load the yaml into sql server. you need an odbc connection (called ebs), and a few python modules



if all you want is a database to work with, then I do have converted versions, in mysql, postgres and sqlite:
https://forums.eveonline.com/default.aspx?g=posts&t=433747&find=unread

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Desmont McCallock
#6 - 2015-08-07 19:53:57 UTC  |  Edited by: Desmont McCallock
Rune Mangeiri wrote:
Starting to feel like an idiot....

- I downloaded the file.
- Placed the YAMLs in the YAML's folder and the universe data in the SQLiteFiles folder.
- Ran the exe ( with my fire wall off to make sure it didn't have a problem.

But the program seems to have trouble connecting to the SQL server.

"Reason was: A network-related or instance-specific error occurred while establishing a connection to SQL Server."

Any ideas what I am doing wrong?
Open up the config file of the tool and at the connection string with name "EVEStaticData" point it to your data source (sqlserver) and initial catalog (database). Do not change the connection string's name.
Rune Mangeiri
Soltech Armada
Minmatar Fleet Alliance
#7 - 2015-08-07 23:04:21 UTC
Sorry if I seem hopeless, I am trying to self teach myself all of this

If I understand you correctly I think you told me to go to this line in the config file:

add name="EveStaticData" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=EveStaticData;Integrated Security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient"


and you want me to change the Data source and catalog attributes to look like this:

Data Source= (path of server)
catalog = (path of database file)

Please let me know if I am doing this correctly since this is completely new to me.

Some sample code really helps me understand thing quicker if it is at all possible.
Thanks for all the help so far guys glad to see this community helps aspiring developers.
Desmont McCallock
#8 - 2015-08-08 06:55:25 UTC
Rune Mangeiri wrote:
Sorry if I seem hopeless, I am trying to self teach myself all of this

If I understand you correctly I think you told me to go to this line in the config file:

add name="EveStaticData" connectionString="Data Source=.\SQLEXPRESS;Initial Catalog=EveStaticData;Integrated Security=True;MultipleActiveResultSets=True;" providerName="System.Data.SqlClient"


and you want me to change the Data source and catalog attributes to look like this:

Data Source= (path of server)
catalog = (path of database file)

Please let me know if I am doing this correctly since this is completely new to me.

Some sample code really helps me understand thing quicker if it is at all possible.
Thanks for all the help so far guys glad to see this community helps aspiring developers.
Exactly. Open your SQL Management Studio. In the window were you connect to the SQL server, the name in the 'Server name' is the 'Data Source' and 'Initial Catalog' is the name of the DB you want to connect to.