Pages: [1] :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Sierra Arodan
Republic Military School Minmatar Republic
0
|
Posted - 2012.09.02 10:44:00 -
[1] - Quote
I'm trying to import API data into MS Access but it appears Access hates XML. Is this going to be a non-starter or is there a 'trick' to getting Access to accept CCP API data. I am total new to this and trying to learn everything on the fly, so please use small simple words that my dirt dumb self will understand. Thanks for any help provided. This is NOT an NPC corp forum alt, this is my main. I will join a corp in a few months after I have more skill points. |
Vogue
RAND Punch and Judy Show
1
|
Posted - 2012.09.02 15:49:00 -
[2] - Quote
A prerequisite for importing the Eve static data dump in this way needs it to be imported first into a SQL Server Express database using SQL Server Management Studio.
Control Panel --> ODBC User DNS-->Add: "SQL Server" Name: Descriptive name like "Eve Inferno Static Data Dump" Server (local)\SQLEXPRESS Next: 'With Windows NT authentication using the network login ID" Next: Change the default databse to 'Name of imported SQL EXPRESS Eve Static Data Dump" Next: 'Test Data Source' - if all is working 'TEST COMPLETED SUCCESSFULLY'
Access New Database External Data: ODBC Database (may be under a 'More' button Import the source data into a new table in the current database Machine Data Source: 'Name of Eve Static Data Dump ODBC link you created above' Import Objects: Select some tables or all of them
It will take a few minutes to import all the tables into Access
|
Steve Ronuken
Fuzzwork Enterprises
616
|
Posted - 2012.09.03 01:07:00 -
[3] - Quote
http://technet.microsoft.com/en-us/library/ee692914.aspx http://office.microsoft.com/en-us/access-help/using-xml-and-access-HA001034560.aspx
Should cover you.
Although you may have trouble with it importing the same data twice, if it's something like the transaction data. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Sierra Arodan
Republic Military School Minmatar Republic
0
|
Posted - 2012.09.03 04:59:00 -
[4] - Quote
Thank you both for not trolling. I have Googled the crap out of this topic, and read moth of those articles many times. The problem I am encountering is that Access will not correctly import a file unless its is "well formatted" which apparently the Eve API data is not. I am currently away from home. When I get back I will have to try some other data base program.
Do you have any suggestions to what I should use? I would also like to be able to open the MSSQL .bak file I downloaded from the tools page. This is NOT an NPC corp forum alt, this is my main. I will join a corp in a few months after I have more skill points. |
Sierra Arodan
Republic Military School Minmatar Republic
0
|
Posted - 2012.09.03 05:38:00 -
[5] - Quote
Ok I think I found my problem and it is, for the moment above my head.
It appears that Eve API data is attribute-centric XML. Microsoft Access only supports element-centric XML. I would need to convert the attribute-centric data to element-centric data (I feel some extremely long files in my future) in order for Access to accept it with out throwing up. any Idea where I may find a library of these already typed up to save some time?
And thank you Vogue for putting me on the right track (I think) I have some learning in my future. Where can I learn about XML, XSL that is not too technical it's been almost 20 years since I have done any coding and well...ya things have changed. This is NOT an NPC corp forum alt, this is my main. I will join a corp in a few months after I have more skill points. |
Ajurna Jakar
Jian Products Engineering Group Nulli Secunda
8
|
Posted - 2012.09.06 13:01:00 -
[6] - Quote
maybe try openoffice base? http://eve-corp-management.org/-á |
Steve Ronuken
Fuzzwork Enterprises
619
|
Posted - 2012.09.06 13:48:00 -
[7] - Quote
http://support.microsoft.com/kb/285329
might be of use to you.
It covers how to, in a macro, convert from attribute centric xml to element centric xml, then import it.
Probably can ignore the export bit (as you'll be pulling it from the api)
It's using an XLST to convert an attribute centric doc, into a element centric one. FuzzWork Enterprises http://www.fuzzwork.co.uk/ Blueprint calculator, invention chance calculator, isk/m3 Ore chart-á and other 'useful' utilities. |
Sierra Arodan
Republic Military School Minmatar Republic
2
|
Posted - 2012.09.06 14:00:00 -
[8] - Quote
Thanks guys. I am putting the project on hold for a little bit until I see where CCP is going with moon mining and ring mining. after that is hammered down I will This is NOT an NPC corp forum alt, this is my main. I will join a corp in a few months after I have more skill points. |
|
|
|
Pages: [1] :: one page |
First page | Previous page | Next page | Last page |