These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Science & Industry

 
  • Topic is locked indefinitely.
 

Dedaf's industrial tool
Author
Previous Topic Next Topic
Alvomara
A Tribe Called Galaxy Quest.
Job's Done.
#261 - 2013-06-28 18:29:58 UTC  |  Edited by: Alvomara
I get a XML error message when I update the sheet. Here is the link to what page I get when clicking on "Help" on the error message:

http://msdn.microsoft.com/query/dev11.query?appId=Dev11IDEF1&l=en-US&k=k(xlmain11.chm1000440);k(TargetFrameworkMoniker-Office.Version=v15)&rd=true

The error message itself is as follows:
Run-time error '-2147217376 (80041020)': XML Parse Error

Hope this helps. Cool tool btw :-)
Dedaf
United Brothers Of Eve
#262 - 2013-06-29 23:12:39 UTC
I found a way to avoid the error from the API and have uploaded a new version, that you can download now.

The problem seems to be that if you have a fail API key or none at all, then before you would just get an empty character list and skill list. but now CCP API simply reject your request, which makes excel fail.

I will try to improve the fix i made to the newly uploaded version, but at least this version, shouldn't give you the errors.

Enjoy.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Save Sex
The Released Hearts
#263 - 2013-07-07 13:32:02 UTC
Does not work, in the character selection screen is empty. Which key should be entered?
Dedaf
United Brothers Of Eve
#264 - 2013-07-08 07:47:55 UTC
Save Sex wrote:
Does not work, in the character selection screen is empty. Which key should be entered?

I'm unsure what it is, that are not working for you?

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Save Sex
The Released Hearts
#265 - 2013-07-08 12:56:30 UTC
Dedaf wrote:
Save Sex wrote:
Does not work, in the character selection screen is empty. Which key should be entered?

I'm unsure what it is, that are not working for you?

I enter the keys are different, complete and not complete, click refresh - and I do not have a choice of characters, blank window does not work. Show the picture where you want to enter any key, because I do not understand.
Dedaf
United Brothers Of Eve
#266 - 2013-07-10 17:37:39 UTC
I just uploaded a new version, with some corrections and new features and new texture in some of the tools.

New version

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Save Sex
The Released Hearts
#267 - 2013-07-11 07:25:46 UTC  |  Edited by: Save Sex
Still does not work, nothing works. The key does not accept, because of this all wrong!

jpg
Dedaf
United Brothers Of Eve
#268 - 2013-07-11 07:32:44 UTC
Save Sex wrote:
Still does not work, nothing works. The key does not accept, because of this all wrong!

jpg

Its difficult to investigate based on the little info that you give, so please contact me in game, and lets see what we can find.
My guess is that your API key is faulty, try to make a new one based on the descriptions in the FAQ.
I have seen that the API key's can fail and you will never make them work again, only option is to make a completely new key.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Save Sex
The Released Hearts
#269 - 2013-07-11 08:28:36 UTC
I'm telling you, I made new, all sorts, different configuration, nothing is perfect, the table does not accept any keys.
How did it should work?
Dedaf
United Brothers Of Eve
#270 - 2013-07-18 10:10:41 UTC
New version is up, here

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Spymate
Wildfire Industries
#271 - 2013-07-19 09:57:25 UTC
I think there is a bug in the Ice mining tab.
I can't select the mining character.

Using office 2010
Dedaf
United Brothers Of Eve
#272 - 2013-07-20 18:15:34 UTC
Spymate wrote:
I think there is a bug in the Ice mining tab.
I can't select the mining character.

Using office 2010

Hi Spymate
It seems that after the texture change, some cells has been locked accidentally. I will make sure to have them unlocked in the next version.
Thanks for letting me know.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Geeyo
Sentinel Event
Hatakani Trade Winds Combine
#273 - 2013-07-21 20:22:30 UTC
Hello Dedaf,

I just started using your program today and it seems like I'm getting the same problem Save Sex is having. I enter my API info and nothing shows up on the character name box.

I've tried many new API keys and still doesn't work.
Dedaf
United Brothers Of Eve
#274 - 2013-07-21 20:33:23 UTC
Geeyo wrote:
Hello Dedaf,

I just started using your program today and it seems like I'm getting the same problem Save Sex is having. I enter my API info and nothing shows up on the character name box.

I've tried many new API keys and still doesn't work.

I have no idea why it wouldnt work for you. But i have noted ones, that when copying the APIkey, it added a " " space in front of the key. So please check if that is happening to you. Make sure you are 100% sure you only mark the ApiKey.

Otherwise, like i told Save Sex, contact me in game, and lets 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/
Geeyo
Sentinel Event
Hatakani Trade Winds Combine
#275 - 2013-07-21 21:26:21 UTC
So my API problem has been solved.

this is for anyone who tries to enable macros and receives a message...

The visual basic for applications (VBA) macros for this workbook are corrupted and has been deleted. The macros corruption most likely exists in the current file. To recover the macros, open up a backup copy of this file if you have one.

The problem turned out to be that VBA was not enabled during the original installation of Office/Excel. Afer modifying the Office/Excel installation with Add/Remove Programs and enabling VBA, it worked great.
Dedaf
United Brothers Of Eve
#276 - 2013-07-21 21:32:22 UTC
thanks a lot for the update Geeyo, im glad you got it working.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
Skoalar
The Scope
Gallente Federation
#277 - 2013-07-23 09:14:30 UTC
I've been using this tool since I began my Eve career several years ago and I give it two thumbs up. Excellent tool, powerful, and well made.
Miney McMineson
The Cayman Islands
#278 - 2013-07-25 01:44:42 UTC  |  Edited by: Miney McMineson
Hi Dedaf. I seem to be getting the following message whenever I try do a VBA call by hitting "Update Everything" or "Check Server"

Quote:
Run-time error '-2147217376 (80041020)':

XML parse Error


Running Microsoft Office Professional Plus 2013

Tried disabling/re-enabling the VBA option in Add/Remove programs as suggested above however that didn't solve the issue. A fresh installation of Office hasn't helped either. Version 15.3.8 of the spreadsheet =)

Thanks!
Dedaf
United Brothers Of Eve
#279 - 2013-07-25 11:20:08 UTC
I'm Afraid i can't help you much here, as i do not have Office 2013. But i would find it strange if MS changed the VBA so much from 2010 to 2013 that older applications couldn't run.

When ever this XML Phase error have been posted, it has always turned out to be a problem with Excel.
The error have been seen if VBA is not installed during the installation of Excel, or when macros has been disabled in Excel, or if the file is stored in a place like C:\ where there are restrictions to macros.
However, i have not had any feedback from anyone using Office 2013, saying that it works.
So i simply have no idea if this tool runs under Office 2013.

New version has just been uploaded, together with an updated manual.

Want to know what is best to mine or build at which cost? then try out Dedaf's Industrial Tool http://dedafsindustrialtool.blogspot.dk/
huang lee
KarmaFleet
Goonswarm Federation
#280 - 2013-07-28 02:48:39 UTC  |  Edited by: huang lee
Hi DeDaf,

I first would like to say "AMAZING TOOL!" I have been using this spreadsheet with great success to build capitals and I am very impressed with it.

I would like to request an additional feature for ships, such as capitals, which require components. It would be very handy if there was some way that I could input the number of blue prints I had for a specific component, and then the spreadsheet did the math for me.

for example:

Say I need to build 100 capital armor plates

I own two capital armor plate BPOs

i put in that i own 2 of these BPOs

the spreadsheet tells me I need to build 50 capital armor plates on each BPO


or in the case of an odd number

Say I need to build 99 capital armor plates

I own two capital armor plate BPOs

I put that in that i own 2 of these BPOs

The spreadsheet tells me I need to build 55 on the first BPO and 54 on the second BPO


This is for those situations where utilizing multiple BPOs can help decrease the overall time needed for components to be built and thus finish faster and have ready for final assembly.


This could also be incorporated to be useful for other things such as T2 and Starbase assembly.

I hope you will incorporate this functionality into a near future build of the DeDaf Industrial tool.


Thank you again for all the hard work you have put in to making this tool the ultimate tool for us industrialists, Once my finances stabilize a bit more I intend to send you a nice thank you :)