EVE Search - POS Fuel Offline Monitor

Check My IP Information

All Channels

EVE Technology Lab

POS Fuel Offline Monitor

» Click here to find additional results for this topic using Google

Monitor this thread via RSS [?]

Pages: 1 :: [one page]

Author	Thread Statistics \| Show CCP posts - 0 post(s)
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.25 15:15:00 - [1] I searched around and couldn't find anything that could help me monitor the Corporations POS offline and make my life easier. So I took the opportunity to create a tool (spreadsheet) in Excel by myself. (Don't expect too much cause I'm no programmer) It has EVE API requirements as it uses data from the EVE API Server. It only works if you are the CEO or you have Director rights in your Corporation. It's desinged to: - Access all your Characters in your account. - Access up to 6 POS. (it currently works fine with one as I couldn't test it with more) - Show the location of your POS. (due to limit DB only the Solar System is shown, if anyone has a DB with MoonID feel free to contact me) - Calculate the remaining time your POS has fuel to run. - Inform you when the next Fuel Update is available. POS Fuel Offline Monitor v1.0 Give it a try and let me know what you think. (Plz post here if you find any bug or like to suggest new features)
Fubar Eagle Eye Inc.	Posted - 2009.04.25 16:30:00 - [2] The moons are in table mapDenormalize in the datadump. The moons are groupID 8.
Dragonaire Caldari Corax. Sex Drugs And Rock'N'Roll	Posted - 2009.04.25 19:40:00 - [3] You might look at POS-tracker think it has all the functions you need and has been around for a few years now -- Finds camping stations from the inside much easier. Designer of Yapeal for Eve API.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.25 20:00:00 - [4] Edited by: Desmont McCallock on 25/04/2009 20:03:32 Well, I've seen POS-tracker. The thing with it, is that you have to set up a PHP & SQL. I admit that my version doesn't give you the opportunity to track more then one at a time but you can create multiple files for all the POS you have. It's just a simple tool for simple use.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.25 20:01:00 - [5] Originally by: Fubar The moons are in table mapDenormalize in the datadump. The moons are groupID 8. Stupid question.... but how can I get my hands on "mapDenormalize in the datadump"?????
Raser Moonstrider Legend's	Posted - 2009.04.25 20:43:00 - [6] Go here and download one of the versions of the dump that you can use, and look for that file.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.25 21:27:00 - [7] Originally by: Raser Moonstrider Go here and download one of the versions of the dump that you can use, and look for that file. If I got this right, the file you propose has to be imported to a SQL DB. This is something that can't do (tried ones with no luck, always got a message that the file I was trying to import was too big or something like that). Can anyone provide me with a list of moonID and the name of the moon the ID response to (would be great if it was in a speadsheet).
Fubar Eagle Eye Inc.	Posted - 2009.04.26 00:03:00 - [8] Here is a zipped csv file containing the info.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.26 07:39:00 - [9] Originally by: Fubar Here is a zipped csv file containing the info. Fubar, thanx a lot for helping out, man, but your version has to be an old one as it contains Uncharted Planets. I found an Apocrypha version of mapDenormalize and sorting moons out as we speak. Thanx again.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.27 00:16:00 - [10] Edited by: Desmont McCallock on 27/04/2009 00:20:11 As you might have figured out, I've spend my whole day learning how to: - Install !!!SUCCESSFULLY!!! MS SQL Server 2008 Express (believe me it wasn't easy). - Importing the EVE Apocrypha datadump. - Query the DB for the results I was looking for. As you see, I made it and released a new version that contains the MoonID DB. Well as some say "Knowledge is Power".

Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.04.30 12:45:00 - [11] Well, the fact that I don't have any feedback from you is troubling me. These means that either my tool sucks or it's working perfectly (which isn't cause I myself found a lot of bugs). The ppl who have already download it, why don't you drop me a line. (I'm open to negative opinions too, you know).
lillitheve Lupus Draconis	Posted - 2009.04.30 16:44:00 - [12] links appear to be broken, would like to try it out, links keep redirecting back to the board Lupus Draconis Home
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.05.02 20:48:00 - [13] New version is out (v3.0). I hope this time I got it right. If you like to propose some new features, feel free to post here.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.05.06 06:28:00 - [14] New version v3.1 is out. It will probably be the last cause I've a new project on the way.
Zeno Jr	Posted - 2009.06.21 10:37:00 - [15] I've been trying to get the latest 3.1 version to work with Excel 2007, but I'm getting an error after re-updating after selecting a POS 1 - 6 (any POS generates the error - I have at total of 7 associated with my Director account). The error is "Subscript out of range". Reading the comments is also difficult since it appears the worksheet is recalculating every second. Can't seem to view any of the VBA code or formulas to troubleshoot either. I'm looking for a simple Excel POS Fuel interface, but this is too complicated at this point. I've successfully used the Excel 2007 XML Data Mapping to manually map my 7 POS and will pursue my own lookups I guess. Any suggestions would be appreciated. Thanks! Zeno-
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.06.21 10:43:00 - [16] Originally by: Zeno Jr I've been trying to get the latest 3.1 version to work with Excel 2007, but I'm getting an error after re-updating after selecting a POS 1 - 6 (any POS generates the error - I have at total of 7 associated with my Director account). The error is "Subscript out of range". Reading the comments is also difficult since it appears the worksheet is recalculating every second. Can't seem to view any of the VBA code or formulas to troubleshoot either. I'm looking for a simple Excel POS Fuel interface, but this is too complicated at this point. I've successfully used the Excel 2007 XML Data Mapping to manually map my 7 POS and will pursue my own lookups I guess. Any suggestions would be appreciated. Thanks! Zeno- I was expecting something like this to happen if anyone tried to monitor more then 6 POS. I will rewrite the code to give the ability to monitor the POS's no matter how many you have. I expect this to be ready in a couple of days. Thanks for the feedback Zeno.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.06.21 21:58:00 - [17] New version (v3.2) is out.
Zeno Jr	Posted - 2009.06.24 05:34:00 - [18] Excellent! Thanks for version 3.2 The only suggestion right off would be to only recalculate EVE Time once a minute since it makes reading the comments and trying to copy/paste difficult. I personally don't care about seconds resolution in this application. Lastly, on my sheet view the "Next POS Fuel Update Available In:" field is filled with ######## because the cell width is too small for the value. Other than that it's a Hit Take care, Zeno
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.06.24 14:38:00 - [19] Originally by: Zeno Jr The only suggestion right off would be to only recalculate EVE Time once a minute since it makes reading the comments and trying to copy/paste difficult. You can see the comments (if you use Excel 2007) by going to the Tab "Review" and click on the "Show/Hide Comment" selection or even better the "Show All Comments" selection. I looked into the copy/paste issue. The only thing I can imagine you would like to copy/paste would be the "CPU - PowerGrid" values. I could fix it for you but then you would mess the color format of the cells. So I deliberately leave the sheet as is. But not to leave you disappointed here is a little trick on how you could copy/paste what you want. Double click on the cell you want to copy, once the cursor is inside the cell select what you want to copy (just double click if you want to select everything in the cell) and press Ctrl-C. Head to the destination cell and double click on the cell, once the cursor is inside the cell press Ctrl-V. This way you can copy/paste any value without messing with the background. Originally by: Zeno Jr Lastly, on my sheet view the "Next POS Fuel Update Available In:" field is filled with ######## because the cell width is too small for the value. Fixed that in version 3.3 Thanks again for your valuable info.
Sidrat Flush Caldari Life is Experience New Eden Hardware Emporium	Posted - 2009.06.30 16:30:00 - [20] I haven't downloaded this tool although I would like to see it - the only thing holding me back is Rapidshare. Not only is there a delay but it's bloody slow. I use MediaFire to host the spreadsheet/application I've designed, and so far I haven't heard anything negative about it. As far as I know there's no delay, no premium content and the speed (I know because I've downloaded one or two files myself) is adequate, much faster than rapidshare anyway. The account is free to set up and really easy to do although the max file size for free is I've just checked 100MB. Go on get on mediafire You know you want to. EXP-L Eve Industrial Organiser

Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.07.11 12:56:00 - [21] Originally by: Sidrat Flush I haven't downloaded this tool although I would like to see it - the only thing holding me back is Rapidshare. Not only is there a delay but it's bloody slow. I use MediaFire to host the spreadsheet/application I've designed, and so far I haven't heard anything negative about it. As far as I know there's no delay, no premium content and the speed (I know because I've downloaded one or two files myself) is adequate, much faster than rapidshare anyway. The account is free to set up and really easy to do although the max file size for free is I've just checked 100MB. Go on get on mediafire You know you want to. Delayed to respond due to RL issues. Thanks for the info. Added mirror link to MediaFire.
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.07.20 13:41:00 - [22] New version is out (v3.4)
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.08.26 06:56:00 - [23] New version is out (v3.5) In progress Been working into embed an "Account Manager" in to the utility.
Jovoich Kleinrock Heavy Industries The Kadeshi	Posted - 2009.08.26 22:00:00 - [24] I would like to use this. But I only download stuffz from EVE-Files. I'd suggest putting another mirror up www.eve-files.com I call 'Bull****' CCP. Isn't it great that the alchemy process was introduced & can 'take up the slack?'
Anthonius1972 Centurion Undertakers Mass Mayhem Syndicate	Posted - 2009.08.27 20:55:00 - [25] Hi Desmont, Nice programm. Only few comments from my side. I don't get the info where our POS is placed. Secondly I can't see how much cpu and powergrid is in use. Last thing i don't get is the fuel last for liquid ozone and heavy water (also the hours are not calculated, assume this will start when the fuel is coming below one day). For the rest great programm, thx. Ton
Desmont McCallock Phoenix Interstellar Corp	Posted - 2009.08.28 10:12:00 - [26] Originally by: Anthonius1972 Hi Desmont, Nice programm. Only few comments from my side. I don't get the info where our POS is placed. Secondly I can't see how much cpu and powergrid is in use. Last thing i don't get is the fuel last for liquid ozone and heavy water (also the hours are not calculated, assume this will start when the fuel is coming below one day). For the rest great programm, thx. Ton Cpu and PowerGrid has to be set manually. The consumption of HW and LO is not a fixed number but calculated as a percentage of the CPU and PowerGrid used by the POS. That's why I added the 14 sets slots. As long as you fill in the data (you can get it by opening the "manage" window of the POS ingame) you have to select that set from the cell left to the "CPU" indication of the slots (top of the "Set##" column). Once done that the HW and LO consumption will be calculated and you will get the remaining time till shutdown. As for not getting the info of where your POS is, the only reasonable explanation is that it's not in the moon database of the program. Is the POS anchored in Hisec or Lowsec? Empire or null sec? Drop me an Eve mail with where your POS is anchored to cross-reference the location with the database.
Jamrous	Posted - 2009.11.19 20:13:00 - [27] does not seem to work in office 2010 excel goes into combatibly mode and then displays a large whit window when you scroll down you see some cells of color but nothing seem to work.
Desmont McCallock	Posted - 2009.11.20 08:31:00 - [28] Till I get my hands on Office 2010 (not beta) and find out what have changed, stick to office 2007.


Pages: 1 :: [one page]

COPYRIGHT NOTICE
EVE Online, the EVE logo, EVE and all associated logos and designs are the intellectual property of CCP hf. All artwork, screenshots, characters, vehicles, storylines, world facts or other recognizable features of the intellectual property relating to these trademarks are likewise the intellectual property of CCP hf. EVE Online and the EVE logo are the registered trademarks of CCP hf. All rights are reserved worldwide. All other trademarks are the property of their respective owners. CCP hf. has granted permission to EVE-Search.com to use EVE Online and all associated logos and designs for promotional and information purposes on its website but does not endorse, and is not in any way affiliated with, EVE-Search.com. CCP is in no way responsible for the content on or functioning of this website, nor can it be liable for any damage arising from the use of this website.