Eve MS SQL importer and queries program
Previous blog link at this site for this information concerning this program
Recommend reading previous blog post for dependencies information on what program's are needed to get this program adequately running. While I could create a packaging installer for all of this, because links and what not falling out of date, and because its another chore creating an updater for all of these would leave it up to the user to update all of these dependencies (e.g., MS SQL Studio 2012, Eve Fansite kit, and python MS sql driver module). Dependencies installation are very straightforward generally speaking and easy. Although I recommend going to my previous blog post linked above for setting up your Eve database. Someday, I may try to create an automation on the installation here, but for now I'd leave it up to you. Will update soon with general sql queries window for users wanting to do customized searches.
Also to add profiles tab later, which allows a user to toggle, between custom searches of item groups across region markets.
Please follow instructions also at README explains how to get going with all the dependencies. Currently looking into creating a stand alone windows executable for my script, but this is yet another task. My code is written for native python 3.2 tk packages
Update 6/25/12: Added quick profiles selection tool, which basically allows for queries of group items and regional market groups on reprocessing pricing estimated value returns (Pricing button).
Updates 6/25/12: Easy selection for computing average on itemsindex table. Added a query search window that can be toggled through menu interface. The simplest query invocation for instance, can be in the form of 'Select * from tablename' where table name is defined by one of the names
shown in the database explorer. I've also included column values in the database explorer for refined searches.
Updates 6/29/12: Working on batching index data for creating running averages (approximately). As opposed to date indexing at present in the singular as opposed to varied (multiple) batch dates computed at once. Also creating matlibplot features, that provide graphical market plot data...except ramping the scale of plots up relative the typical eve market context (in game). This would furnish say not merely one but many plots that could be viewed at once based upon a users customized choice of market watch items in group. I wanted to also furnish things like comparison data of reprocessing/manufacturing cost/minerals estimation data relative to average market valuations say in one statistical plot. Some added things to be considered here: search indexing to return say a top list of hot purchase items or sell item based upon consideration of any number of factors: this could be cost of loyalty points relative to average market valuations, or something like relative mineral's estimation return relative to consideration of regional market buy orders on hand...
Previous blog link at this site for this information concerning this program
Recommend reading previous blog post for dependencies information on what program's are needed to get this program adequately running. While I could create a packaging installer for all of this, because links and what not falling out of date, and because its another chore creating an updater for all of these would leave it up to the user to update all of these dependencies (e.g., MS SQL Studio 2012, Eve Fansite kit, and python MS sql driver module). Dependencies installation are very straightforward generally speaking and easy. Although I recommend going to my previous blog post linked above for setting up your Eve database. Someday, I may try to create an automation on the installation here, but for now I'd leave it up to you. Will update soon with general sql queries window for users wanting to do customized searches.
Also to add profiles tab later, which allows a user to toggle, between custom searches of item groups across region markets.
Please follow instructions also at README explains how to get going with all the dependencies. Currently looking into creating a stand alone windows executable for my script, but this is yet another task. My code is written for native python 3.2 tk packages
Update 6/25/12: Added quick profiles selection tool, which basically allows for queries of group items and regional market groups on reprocessing pricing estimated value returns (Pricing button).
Updates 6/25/12: Easy selection for computing average on itemsindex table. Added a query search window that can be toggled through menu interface. The simplest query invocation for instance, can be in the form of 'Select * from tablename' where table name is defined by one of the names
shown in the database explorer. I've also included column values in the database explorer for refined searches.
Updates 6/29/12: Working on batching index data for creating running averages (approximately). As opposed to date indexing at present in the singular as opposed to varied (multiple) batch dates computed at once. Also creating matlibplot features, that provide graphical market plot data...except ramping the scale of plots up relative the typical eve market context (in game). This would furnish say not merely one but many plots that could be viewed at once based upon a users customized choice of market watch items in group. I wanted to also furnish things like comparison data of reprocessing/manufacturing cost/minerals estimation data relative to average market valuations say in one statistical plot. Some added things to be considered here: search indexing to return say a top list of hot purchase items or sell item based upon consideration of any number of factors: this could be cost of loyalty points relative to average market valuations, or something like relative mineral's estimation return relative to consideration of regional market buy orders on hand...
No comments:
Post a Comment