Pages: 1 2 3 4 5 6 7 8 9 10 11 12 [13] 14 15 16 17 18 19 .. 19 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Azz T
Revenge Served Cold 9th Company
3
|
Posted - 2013.12.26 19:58:00 -
[361] - Quote
Dedaf wrote:Azz T wrote:Hey, Awesome Tool. Is it possible to run a query to list all the T1 BPO's I own and compare with Eve so I can see what BPO's I am missing?
I would assume this would use API to get my assets.
Would it also be possible to automatically enter the ME/PE levels of the BPO's I own in manufacturing sections?
Hi Azz I could be possible to list, but the API cant see the difference of a original or copy blueprint and it does not contain the ME nor PE information either. So it is not a list, that would be of much use.
Any Idea how I could just export a list of BPO's from eve to compare with what I own?
Just need to easily see what ones I am missing from my collection.
Regards Azz |
SCORPIO KIRK
Agamemnon Holdings
0
|
Posted - 2013.12.28 01:40:00 -
[362] - Quote
So I like the concept of the shopping list, this something I painfully always add to new version of the spreadsheet, is there a way that you can add additional sheets that can get counted in this function. For example, for T2 Items, i have 7 pages (3 items per page) in my copy of the spreadsheet. When I tested duplicating the default page, it did not get reflected in the shopping list. Is there a more appropriate way of adding pages?
Scorpio |
Mandj
hirr RAZOR Alliance
0
|
Posted - 2013.12.28 22:36:00 -
[363] - Quote
This looks like an excellent tool, however, having some trouble setting up the API and was wondering if I could get some help (note - excel n00b). I go to the API page on the CCP site and generate new API. Following the FAQ on the OP's webpage, it says exclude CharacterInfo, CharacterSheet, Locations & AssetList and I do so. Press generate for API. I then start the tool, go to the data page, input the Apikey, KeyID, from the API I just made, and then manually type in my character name (Mandj, just like it says here). Press update skills, result: Popup window comes up saying microsoft visual basic, says Run-time error '13': Type mismatch.
So I think I'm doing something wrong but can't tell what it is, could someone help me out please? It seems to pull market data correctly so idk what I'm doing. |
Dedaf
Tactical Tea Baggers N.O.M.A.D.S.
294
|
Posted - 2013.12.29 10:06:00 -
[364] - Quote
Azz T wrote:Any Idea how I could just export a list of BPO's from eve to compare with what I own?
Just need to easily see what ones I am missing from my collection.
Regards Azz Hi Azz No i cant see any easy way to export that, as you dont get any names from the API. You get just typeID's and then you have to convert it to names. So it will be pretty intense work, and still you need to do a lot of manual work.
SCORPIO KIRK wrote:So I like the concept of the shopping list, this something I painfully always add to new version of the spreadsheet, is there a way that you can add additional sheets that can get counted in this function. For example, for T2 Items, i have 7 pages (3 items per page) in my copy of the spreadsheet. When I tested duplicating the default page, it did not get reflected in the shopping list. Is there a more appropriate way of adding pages?
Scorpio I'm afraid it is not so easy as just copy paste. But im happy you think so, as this is how i want my tool to be and look. Even if the shopping list look simple it is pretty complicated calculations behind it. So to add more sheets to the list, would mean to reconfigure the tool to include that sheet as well. Id suggest you make a file for each of the 7pages T2 item tool, including the shopping list and Data sheet, then you should get some fairly good lists.
Mandj wrote:This looks like an excellent tool, however, having some trouble setting up the API and was wondering if I could get some help (note - excel n00b). I go to the API page on the CCP site and generate new API. Following the FAQ on the OP's webpage, it says exclude CharacterInfo, CharacterSheet, Locations & AssetList and I do so. Press generate for API. I then start the tool, go to the data page, input the Apikey, KeyID, from the API I just made, and then manually type in my character name (Mandj, just like it says here). Press update skills, result: Popup window comes up saying Microsoft visual basic, says Run-time error '13': Type mismatch.
So I think I'm doing something wrong but can't tell what it is, could someone help me out please? It seems to pull market data correctly so idk what I'm doing. Hi Mandj I dont believe i have seen that specific runtime error before. To try and help you, I would need some more info, like version of Excel and so on. It would also be good if I could get a copy of the file with the API and runtime error, so i could try it out myself. You could also try to read FAQ 6, 7 & 8 here, to see if that solves the problem for you? If not, then please contact me in game, then we can try to see what we can find.
Thanks to all of you for your feedback Dedaf
Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
SJ Astralana
Syncore
22
|
Posted - 2013.12.29 12:26:00 -
[365] - Quote
Dedaf wrote: Hi Azz I could be possible to list, but the API cant see the difference of a original or copy blueprint and it does not contain the ME nor PE information either. So it is not a list, that would be of much use.
The ME/PE/runs of a blueprint can be found if it has ever been used in production. In that case it is in the Industry Jobs API, and you can see the Asset ID to tie it directly to a specific blueprint.
SJ Astralana = Danari = Alak D'bor. I don't fuss about which account/toon is logged in, nor do I hide behind alts. |
Giltorias ve'Elteroth
Titan Innovations
3
|
Posted - 2013.12.30 05:44:00 -
[366] - Quote
Hey Dedaf,
Thanks for this amazing tool. I might be think though but I can't find an option to do the following.
I want to invent and build a t2 ship. I build all of the t2 components for the ship. However, when I enter the ME for the component BPOs and go to my shopping cart it lists both the actual components and the moon materials that are used to produce said components. Any way I can change that so it just lists the moon materials?
Edit: Also, can you choose what materials you manufacture (as in buy or build)?
Cheers! |
Dedaf
Tactical Tea Baggers N.O.M.A.D.S.
294
|
Posted - 2013.12.30 13:30:00 -
[367] - Quote
Giltorias ve'Elteroth wrote:Hey Dedaf,
Thanks for this amazing tool. I might be think though but I can't find an option to do the following.
I want to invent and build a t2 ship. I build all of the t2 components for the ship. However, when I enter the ME for the component BPOs and go to my shopping cart it lists both the actual components and the moon materials that are used to produce said components. Any way I can change that so it just lists the moon materials?
Edit: Also, can you choose what materials you manufacture (as in buy or build)?
Cheers! Hi Giltorias as of right now, it is not possible to prevent items from being listed in the shopping list. The tool has only just been build, so there are plenty of room for improvement. And what you are asking is a nice improvement i think. I will see if i can find a nice way to give you the option to choose which items are listed in the shopping list.
Thank you for helping making the tool better.
Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
Thermopylaee
State War Academy Caldari State
2
|
Posted - 2013.12.30 15:11:00 -
[368] - Quote
Hi Dedaf,
Thank you so much for developing this tool! I'm a first time user, and I'm having trouble with the API/character import. I followed the instructions in the PDF and the FAQ, but it still won't recognize my character. I have tried manually entering the character name and updating, and I have also tried just using the API and KeyID, but the drop-down box is blank.
I'm using Excel for Mac 2010 Pro on a Macbook Air. I don't think that has anything to do with it... but the only thing I have tried to do is set up the Data page. I have not modified the backup or restore locations.
Any help you can offer is appreciated, thanks! |
Giltorias ve'Elteroth
Titan Innovations
4
|
Posted - 2013.12.30 21:01:00 -
[369] - Quote
Dedaf wrote:Giltorias ve'Elteroth wrote:
Edit: Also, can you choose what materials you manufacture (as in buy or build)?
Cheers!
Hi Giltorias as of right now, it is not possible to prevent items from being listed in the shopping list. The tool has only just been build, so there are plenty of room for improvement. And what you are asking is a nice improvement i think. I will see if i can find a nice way to give you the option to choose which items are listed in the shopping list. Thank you for helping making the tool better.
Thanks for the reply mate. I look forward to further developments!
Can you choose what materials you manufacture and what materials you buy when constructing t2 items/ships? For example if I build fusion reactors (so need raw mats and usually lower production costs) whilst buying R.A.M (more expensive but takes a while to make)? |
Dedaf
Tactical Tea Baggers N.O.M.A.D.S.
294
|
Posted - 2013.12.31 11:35:00 -
[370] - Quote
Thermopylaee wrote:Hi Dedaf,
Thank you so much for developing this tool! I'm a first time user, and I'm having trouble with the API/character import. I followed the instructions in the PDF and the FAQ, but it still won't recognize my character. I have tried manually entering the character name and updating, and I have also tried just using the API and KeyID, but the drop-down box is blank.
I'm using Excel for Mac 2010 Pro on a Macbook Air. I don't think that has anything to do with it... but the only thing I have tried to do is set up the Data page. I have not modified the backup or restore locations.
Any help you can offer is appreciated, thanks! Im afraid it is the Mac, i have not had anyone using a mac, saying that it works. There seem to be some difference in the way the Microsoft VBA works on a Mac and PC. I do not have any Mac products myself so i can not try it out.
Giltorias ve'Elteroth wrote: Thanks for the reply mate. I look forward to further developments!
Can you choose what materials you manufacture and what materials you buy when constructing t2 items/ships? For example if I build fusion reactors (so need raw mats and usually lower production costs) whilst buying R.A.M (more expensive but takes a while to make)?
No, as it is now, there are no way to select if you buy or produce the components yourself. The sheet expect that when doing T2 ship production, then you also build all the components yourself.
Happy New Year Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
|
Thermopylaee
Executive Decision 666
2
|
Posted - 2013.12.31 13:49:00 -
[371] - Quote
Dedaf wrote:Thermopylaee wrote:Hi Dedaf,
Thank you so much for developing this tool! I'm a first time user, and I'm having trouble with the API/character import. I followed the instructions in the PDF and the FAQ, but it still won't recognize my character. I have tried manually entering the character name and updating, and I have also tried just using the API and KeyID, but the drop-down box is blank.
I'm using Excel for Mac 2010 Pro on a Macbook Air. I don't think that has anything to do with it... but the only thing I have tried to do is set up the Data page. I have not modified the backup or restore locations.
Any help you can offer is appreciated, thanks! Im afraid it is the Mac, i have not had anyone using a mac, saying that it works. There seem to be some difference in the way the Microsoft VBA works on a Mac and PC. I do not have any Mac products myself so i can not try it out. Giltorias ve'Elteroth wrote: Thanks for the reply mate. I look forward to further developments!
Can you choose what materials you manufacture and what materials you buy when constructing t2 items/ships? For example if I build fusion reactors (so need raw mats and usually lower production costs) whilst buying R.A.M (more expensive but takes a while to make)?
No, as it is now, there are no way to select if you buy or produce the components yourself. The sheet expect that when doing T2 ship production, then you also build all the components yourself. Happy New Year
I'll try it on my PC, thanks! |
Maffia Thug
3dge of D4rkness SoulWing Alliance
2
|
Posted - 2014.01.02 18:14:00 -
[372] - Quote
Awesome tool sir! Very well done.
I just wanted to say thank you. |
Jim Hammond
Federal Navy Academy Gallente Federation
1
|
Posted - 2014.01.04 18:27:00 -
[373] - Quote
First, thank you for making this awesome tool. I'm having issues trying to use Dodixie and the system to update from. I get "Run-time error '13': Type mismatch" and the same when I try to use the Sinq Laison region. It works for Jita and Oursulaert just fine. Going through the list it gives the error for other systems too. Any help will be appreciated. |
Emeki
Aliastra Gallente Federation
0
|
Posted - 2014.01.04 22:06:00 -
[374] - Quote
Hey Dedaf I cannot seem to get the API lookup to work. I have run through the FAQ I am using the following:
Win 7 Pro X64 Office 2007 (fully updated ) Macro's enabled ActiveX allowed
I keep getting the following:
Run time error '-2147217376(80041020)': XML Parse Error
I have tried the options listed in FAQ 7 but that did not work.
if I leave it blank I get :
Run time error 13 type mismatch
I am not sure what else I can do...any thoughts?
|
Len Ross
The Scope Gallente Federation
17
|
Posted - 2014.01.05 02:01:00 -
[375] - Quote
Found a slight problem . to avoid confusion this is my forum alt. Anyhow. been using the tool for ages now. awesome job mate. How do I get round this? I'm a ceo in corp. I want the corp assets in our office to be shown for my manufacturing. hangar 2 for example. It only shows our pos hangars. Other thing If I try to manufacture from personal stocks. I click on character and look down the list of stations. The one where my actual stock is doesn't show, others do. I'm having to use the old version at the moment as I cannot get any needed minerals and components on my listing.
I set up my API key as shown for corp and personal.
cheers mate |
Dedaf
Tactical Tea Baggers N.O.M.A.D.S.
294
|
Posted - 2014.01.05 09:25:00 -
[376] - Quote
Jim Hammond wrote:First, thank you for making this awesome tool. I'm having issues trying to use Dodixie and the system to update from. I get "Run-time error '13': Type mismatch" and the same when I try to use the Sinq Laison region. It works for Jita and Oursulaert just fine. Going through the list it gives the error for other systems too. Any help will be appreciated. HI Jim That is strange why you get the error on some systems and not others to me it would be more logic if it didnt work at all. I have tried the system and regions you mention on 2 different machines and office versions, but i dont have any problems updating from any systems or regions. You might have some bug in that file, maybe try to download it again?
Emeki wrote:Hey Dedaf I cannot seem to get the API lookup to work. I have run through the FAQ I am using the following: Win 7 Pro X64 Office 2007 (fully updated ) Macro's enabled ActiveX allowed
I keep getting the following: Run time error '-2147217376(80041020)': XML Parse Error
I have tried the options listed in FAQ 7 but that did not work.
if I leave it blank I get : Run time error 13 type mismatch
I am not sure what else I can do...any thoughts?
Hi Emeki Only thing i can think of is that your version of Office2007 is not a Pro? or you are saving the file in a folder with restrictions. Make sure you save it in you document folder or follow FAQ6 to insure your macro security isn't blocking the macros from running.
Len Ross wrote:Found a slight problem . to avoid confusion this is my forum alt. Anyhow. been using the tool for ages now. awesome job mate. How do I get round this? I'm a ceo in corp. I want the corp assets in our office to be shown for my manufacturing. hangar 2 for example. It only shows our pos hangars. Other thing If I try to manufacture from personal stocks. I click on character and look down the list of stations. The one where my actual stock is doesn't show, others do. I'm having to use the old version at the moment as I cannot get any needed minerals and components on my listing.
I set up my API key as shown for corp and personal.
cheers mate Hi Len Ross At the moment there is a limit of 50 personal & 50corp hangars (Office & POS), so if you have asset allover in space in more than 50 stations, then you should think about cleaning up a bit.
But the problem about the Office and POS hangars is a bit strange to me, unless, you again have more than 50? But it would be strange if the first 50 hangars was all POS hangars. So here i believe there is a bug in the tool. I have only tested API keys with 2 Office hangars and another key with 2 POS hangars +1 Office hangar, in those two cases the Office hangars showed up just fine. But for me to really investigate this problem, then i would need a copy of your tool with the API? but im sure a lot of people would advice you against that. But feel free to contact me in game, then we can try to find a solution to this problem.
Sorry about the problem you guys have with the office and macros, and sorry i dont have much help to offer you. You are all very welcome to contact me ingame, then we can try to see if we can find a solution. It could be some way you are using the tool that i never thought of. So finding the bugs could help out alot of your other fellow eve pilots.
Thanks again everyone for the feedback.
Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
Len Ross
The Scope Gallente Federation
18
|
Posted - 2014.01.05 16:13:00 -
[377] - Quote
Dedaf me ol mate. Don't apologise. This tool of yours is awesome. Always has been. Yeah I'm a messy bugger stuff is all over the show. Ill have a clean up and I'm sure it'll work fine.
Thanks for that. |
Len Ross
The Scope Gallente Federation
18
|
Posted - 2014.01.10 00:03:00 -
[378] - Quote
Double post. That did the trick mate. Works great. No more stocktaking. Can't thank you enough |
Amely Miles
Lone Star Warriors Yulai Federation
6
|
Posted - 2014.01.10 01:59:00 -
[379] - Quote
please please please make this in to Open Office format..... it allows Macros so you can pull eve central data ...not sure why its not in this format yet? |
Dedaf
Tactical Tea Baggers Sorry We're In Your Space Eh
294
|
Posted - 2014.01.10 12:39:00 -
[380] - Quote
Len Ross wrote:Double post. That did the trick mate. Works great. No more stocktaking. Can't thank you enough Im happy to hear that you got it working. One thing i realized is, that i haven't tested if personal hangars and Drug labs hangars are listed, so if anyone could confirm that those hangars are also working, then it would be great!
Amely Miles wrote:please please please make this in to Open Office format..... it allows Macros so you can pull eve central data ...not sure why its not in this format yet?
i would convert it myself but my old laptop times out and cant handle it :/ If only it was so easy, but the calculations used in this tool are so specialized to Excel, that I doubt it can just be converted. I think it needs to be made specifically for Open Office and i have no plans of maintaining 2 different tools. Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
|
Amely Miles
Lone Star Warriors Yulai Federation
6
|
Posted - 2014.01.10 15:48:00 -
[381] - Quote
i would personaly pay you to upload one version of open office ...no need to update it i will pay someone on my end to do that
issue is this is a game and gamers alot of times are broke so cant afford fancy programs like excell |
Dedaf
Tactical Tea Baggers Sorry We're In Your Space Eh
294
|
Posted - 2014.01.13 17:29:00 -
[382] - Quote
Just uploaded a version 16.0.5 with some changes to the Asset import system. Should be easier to find the correct POS array and for corps with alot of towers, all hangars & office hangars should be showing now. Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
Sir Gankal0t
Fortuna Heavy Industries Viral Society
14
|
Posted - 2014.01.14 18:51:00 -
[383] - Quote
He Dedaf, Since the last 3 versions im having Visual basic runtime errors 1004 when i hit the Update button in any of the tabs. Suggestions?
cheers mate keep\up the good work |
Dedaf
Tactical Tea Baggers Sorry We're In Your Space Eh
295
|
Posted - 2014.01.16 10:24:00 -
[384] - Quote
Sir Gankal0t wrote:He Dedaf, Since the last 3 versions im having Visual basic runtime errors 1004 when i hit the Update button in any of the tabs. Suggestions? cheers mate keep\up the good work This error 1004, is it the password error? do not get this error myself, so i cant say what could be to blame, maybe you are using Office 2013? Also could you try to open one of your old files (if you have them still) just to check if infact it does work in those version.
othere than this i can relly assist with anything. but contact me ingame, then we can try som more specific tests, to see what we can find. Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
Sir Gankal0t
Fortuna Heavy Industries Viral Society
14
|
Posted - 2014.01.16 11:26:00 -
[385] - Quote
Dedaf wrote:Sir Gankal0t wrote:He Dedaf, Since the last 3 versions im having Visual basic runtime errors 1004 when i hit the Update button in any of the tabs. Suggestions? cheers mate keep\up the good work This error 1004, is it the password error? do not get this error myself, so i cant say what could be to blame, maybe you are using Office 2013? Also could you try to open one of your old files (if you have them still) just to check if infact it does work in those version. othere than this i can relly assist with anything. but contact me ingame, then we can try som more specific tests, to see what we can find.
I'm using office 2013 are there some compability issues with it? |
Dedaf
Tactical Tea Baggers Sorry We're In Your Space Eh
295
|
Posted - 2014.01.16 11:36:00 -
[386] - Quote
Sir Gankal0t wrote: I'm using office 2013 are there some compability issues with it?
Yes, Office 2013 have a bug, when it comes to password protected sheets.
i do not have 2013 myself, but from what I have been reading on different forums, then it is a clear bug in 2013. I tried to make a correction to my tool, to try a get around this bug, but i guess it didnt have any effect?
From what I undestand, then if you are using 2013, then avoid using the Restore All funktion in the Data sheet, go to each tool and restore them one by one. Not sure if it will help, but try it out and let me know if it changes anything. Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
Sir Gankal0t
Fortuna Heavy Industries Viral Society
14
|
Posted - 2014.01.17 17:20:00 -
[387] - Quote
Well thks that's clear thks for the reply, as you said before you don't have office 2013 wel there is a full working trial available so can test it yourself if you heve the time. Otherwise somewhere in the future.
|
Dedaf
Tactical Tea Baggers Sorry We're In Your Space Eh
295
|
Posted - 2014.01.18 09:33:00 -
[388] - Quote
Dedaf wrote:Sir Gankal0t wrote:He Dedaf, Since the last 3 versions im having Visual basic runtime errors 1004 when i hit the Update button in any of the tabs. Suggestions? cheers mate keep\up the good work This error 1004, is it the password error? do not get this error myself, so i cant say what could be to blame, maybe you are using Office 2013? Also could you try to open one of your old files (if you have them still) just to check if infact it does work in those version. othere than this i can relly assist with anything. but contact me ingame, then we can try som more specific tests, to see what we can find. Hi Sir Gankal I have looked in to this a bit more, and done some tests of the update functions. I have found 3 examples where even i would get the runtime error in office 2010. i found the error in the Station, T3 and Capital production tool. Those should now be corrected in the newly uploaded version 16.0.7
Try it out Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
|
Sir Gankal0t
Fortuna Heavy Industries Viral Society
14
|
Posted - 2014.01.19 20:06:00 -
[389] - Quote
As far i can see in version 16.1 No runtime errors yet thanks again for the efford |
Amely Miles
The Lone Runners
6
|
Posted - 2014.01.23 22:16:00 -
[390] - Quote
i have been asked to take this post down by dedaf and am doing so |
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 [13] 14 15 16 17 18 19 .. 19 :: one page |
First page | Previous page | Next page | Last page |