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.
 

Microsuck Access
Author
Previous Topic Next Topic
Sierra Arodan
Doomheim
#1 - 2012-09-02 10:44:35 UTC
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
Center for Advanced Studies
Gallente Federation
#2 - 2012-09-02 15:49:51 UTC  |  Edited by: Vogue
oops I had trollbot mode on.

/edit: Try Google 'access xslt'.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-09-03 01:07:58 UTC
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.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Sierra Arodan
Doomheim
#4 - 2012-09-03 04:59:52 UTC
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
Doomheim
#5 - 2012-09-03 05:38:44 UTC  |  Edited by: Sierra Arodan
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). It looks like i have some learning in my future. Where can I learn about XML, XSL, Visual Basic for Applications, and Macros that is not too technical it's been almost 20 years since I have done any coding and well...ya things have changed.I'm starting to wonder if this database is really worth the trouble, so much that I don't understand that I need to learn.

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
#6 - 2012-09-06 13:01:14 UTC
maybe try openoffice base?

http://eve-corp-management.org/ 
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#7 - 2012-09-06 13:48:46 UTC
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.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Sierra Arodan
Doomheim
#8 - 2012-09-06 14:00:05 UTC  |  Edited by: Sierra Arodan
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 pick this up again.

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.