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.
 

Look for a tool to: Track corporation's industry jobs
Author
Previous Topic Next Topic
Nireen
Conficio
#1 - 2013-01-03 11:47:46 UTC
I am running a corporation with several people. These people (and alts) fill certain roles in the T2 production chain.
To keep track of peoples contribution to this process their efforts are tracked (manually, ugh)in a spreadsheet. Results of this process are added up at the end of the month and then payment follows.

I am finding this manual stuff killing the fun of everything.

Is there a tool out there that can tell me this data (copyjobs done, inventions done, manufacturing done) per member.
Just this alone would be greatly beneficial as i then only have to copy this into a spreadsheet to do the last part.

Your input will be greatly appreciated.
Acid Kanshi
AIFAM
#2 - 2013-01-03 12:13:23 UTC
I have some basic Jobs fetching, but it still needs a lot of work. Don't know if it's any use.

http://www.eve-cost.eu/

EVE-Cost is a manufacturing tool for EVE players. http://www.eve-cost.eu
TheSkeptic
Federal Navy Academy
Gallente Federation
#3 - 2013-01-03 12:25:59 UTC
1. build site/page to pull corp indy jobs from api and dump into db regularly
2. build page to aggregate data from #1 to xml feed
3. import feed from #2 into google spreadsheets
4. profit

Depending on what infrastructure you have available to you it probably wouldn't be that difficult.

...

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#4 - 2013-01-03 12:37:02 UTC
Do you have excel?

If you do, and you don't might some copy/pasting,

http://wiki.eveonline.com/en/wiki/EVE_API_Corporation_Industry_Jobs

might be of use to you. You'll need to put in a bunch of lookups, but it's still handy for keeping on top of the data. (and it's all automatable.)

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Influenca Pandemik
Anubis Logistics and Services
#5 - 2013-01-03 13:11:40 UTC
to expand on what steve said (works in google docs, might need some tweaking for excel)

get yourself the correct api key, fill in the right bits in the link and put it in a cell (B1)

--> https://api.eveonline.com/corp/IndustryJobs.xml.aspx?keyID=1234567890&vCode=manyrandomchars&characterID=1234567890

use the importxml function to get interesting fields:

job installed (eve time)
=importxml($B$1;"//row[@completed=0]/@installtime")

time the job will be finished (eve time)
=importxml($B$1;"//row[@completed=0]/@endproductiontime")

whats the output:
=importxml($B$1;"//row[@completed=0]/@outputtypeid")

how many runs:
importxml($B$1;"//row[@completed=0]/@runs")

As I'm only interested in ongoing jobs, I'm using "completed=0". For your project you might need to tweak this.
Nireen
Conficio
#6 - 2013-01-03 13:26:57 UTC
Acid Kanshi wrote:
I have some basic Jobs fetching, but it still needs a lot of work. Don't know if it's any use.

http://www.eve-cost.eu/


I've seen the site and tried it out. It does not give the data in the way that i'm looking for.

TheSkeptic wrote:
1. build site/page to pull corp indy jobs from api and dump into db regularly
2. build page to aggregate data from #1 to xml feed
3. import feed from #2 into google spreadsheets
4. profit

Depending on what infrastructure you have available to you it probably wouldn't be that difficult.


Its something like this that i'm more interesteed in. I have a network attached storage that should be able to run 'the thing'. The actual setup and code and whatnots is what i'd like some help with or read up on. And then be happy with point 4.

I'll have to look into the automatic pull from the API directly into google docs. I wonder though if it will work concerning the lookups to avoid getting jobs listed multiple times.
TheSkeptic
Federal Navy Academy
Gallente Federation
#7 - 2013-01-03 14:19:07 UTC
The real issue with the direct api to spreadsheet solutions is I don't think you can get the api to give you a full month+ worth of corp jobs (please correct me if wrong) in order to do the monthly aggregation to calculate contributions and pay*.

* technically you probably could do daily totals in another sheet using JS in google docs with a scheduler but it'd probably be a pita.

I already have a prototype to pull completed jobs into mysql that I use for various other projects.

Cleaning it up and building an xml feed on top of that probably wouldn't be that difficult.

Too many projects... too time poor :(

...

Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#8 - 2013-01-03 15:16:10 UTC
TheSkeptic wrote:
The real issue with the direct api to spreadsheet solutions is I don't think you can get the api to give you a full month+ worth of corp jobs (please correct me if wrong) in order to do the monthly aggregation to calculate contributions and pay*.

* technically you probably could do daily totals in another sheet using JS in google docs with a scheduler but it'd probably be a pita.

I already have a prototype to pull completed jobs into mysql that I use for various other projects.

Cleaning it up and building an xml feed on top of that probably wouldn't be that difficult.

Too many projects... too time poor :(




I'm getting around 390 jobs out of it. Which is around 4 days (yay! Invention [;(] My carpal tunnel thanks you.)


You, if you're comfortable with it, could use YaPeal to grab the corporate jobs into a mysql database and work from there. Not how I'd do it personally, but I like inventing round things which make travelling easier.


Once in mysql, use a reporting package (jasperserver?) to get your reports out of it, if you need web access, or excel with odbc to query the database directly. exporting data to excel to then play with it isn't the world's best idea.


http://www.fuzzwork.co.uk/resources/xamppyapealInstall.txt /might/ be useful for a yapeal install. But it's given entirely without warranty.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
TheSkeptic
Federal Navy Academy
Gallente Federation
#9 - 2013-01-03 15:38:49 UTC
Steve Ronuken wrote:

You, if you're comfortable with it, could use YaPeal to grab the corporate jobs into a mysql database and work from there. Not how I'd do it personally, but I like inventing round things which make travelling easier.


yeah nor I... can't say I like YaPeal. And for this it'd probably be overkill.
Given all you need to do is download corp jobs xml from api.
Then foreach completed job row, insert record. (already have cronjobs of my own doing this tbh)

Steve Ronuken wrote:

Once in mysql, use a reporting package (jasperserver?) to get your reports out of it, if you need web access, or excel with odbc to query the database directly. exporting data to excel to then play with it isn't the world's best idea.


Reporting package could once again be overkill unless you want or need pretty reports. Given he is already using spreadsheets to coordinate payouts. All he really needs is an automated way of getting the contribution data into the spreadsheet.

Creating an xml feed with each character and their copy/invent/build totals that the spreadsheet can load and then do any of it's additional calculations off seems easier.

...