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.
 

Excel Query Problem

First post
Author
Previous Topic Next Topic
Japetus
Mors et Vectigalia
#1 - 2017-01-11 04:08:23 UTC
I'm making an excel spreadsheet, in it I am referencing some of the SDE files... however I recently ran into a problem... maybe someone here can figure out what Im doing wrong


Basically Im querying the SDE File with a ADODB connection where I take the result of a query and put it into an array with getrows() in vba


Now for the problem... if I do this: "SELECT TypeID, TypeName, GroupIDFrom invTypes.csv WHERE MarketGroupID = '" & Data & "'"

I get all the rows in my getrows but only for the TypeID, and TypeName

if I do: SELECT TypeID, TypeName I get results for TypeID


If I do SELECT TypeID I get the following error: Run-time Error 1004 application defined or object defined error


Any idea at all whats going on here? Obviously I can just add an extra field after what I need which I will if I cant figure this out.... but figure if I can figure it out Id much rather get it right.


Thanks
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#2 - 2017-01-11 13:25:25 UTC
I'd highly recommend having it hooked up to a proper database, rather than going from the CSVs.

SQLite is certainly an option.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Japetus
Mors et Vectigalia
#3 - 2017-01-12 01:54:32 UTC
lol you're killin me steve, you keep gettin me to take steps further from excel and more into actual app development :p


If I finally take the last step you have any issues with php? its what I know the most in, which isn't saying a lot lol, well with the exception of vba ofc since... well... excel and all
Japetus
Mors et Vectigalia
#4 - 2017-01-12 21:50:22 UTC
so with SQL which I only have a basic knowledge of, lets take PI for instance... If I want to take a P4, and list all its P3 inputs and the quantity needed, then go beyond and take all the P3s I just found and convert it to P2 imputs so that I would have the exact amounts of P2 that I would need for that P4 I would have to generate a table for pretty much everything wouldnt I? I had been thinking of just making a variable array in excel and just manipulate that variable....
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2017-01-12 21:54:15 UTC
Eh, php works :) It's what I do most of my frontend work in. (in part because I like the feedback loop, in part because it's what I've used in the past).

For non-interactive scripts, I tend to use Python these days. But it's all doable.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter