nullWelcom to Dedaf's Industrial tool FAQ
Below you will find the answers, to the most common questions and issues reported by other users.
Index
1) How do I upload my own skills to the tool?
2) Which Scopes are needed for this tool?
3) When I click update, my skills are not updated?
4) My CORP Tower’s are not listed in the POS production Tool?
5) My Character or Corp Asset List, are not being updated?
6) Why do I get the error: This workbook has lost its VBA project?
7) I get this error when clicking update: Runtime Error '-2147217376 (80041020)'
8) Nothing happens when i try to update my character skills.
9) Office 2013, Run time error '1004' incorrect password.
10) Why are some material price listed as 0Isk?
FAQ
1) How do i upload my own skills to the tool?
Below you will find the answers, to the most common questions and issues reported by other users.
Index
1) How do I upload my own skills to the tool?
2) Which Scopes are needed for this tool?
3) When I click update, my skills are not updated?
4) My CORP Tower’s are not listed in the POS production Tool?
5) My Character or Corp Asset List, are not being updated?
6) Why do I get the error: This workbook has lost its VBA project?
7) I get this error when clicking update: Runtime Error '-2147217376 (80041020)'
8) Nothing happens when i try to update my character skills.
9) Office 2013, Run time error '1004' incorrect password.
10) Why are some material price listed as 0Isk?
FAQ
1) How do i upload my own skills to the tool?
Generate Client and Security ID
1st. Go to the Developer Registration portal, log in using SSO and accept the developer license.
2nd. Now you can create a new application.
a. Give this application a name.
b. A brief description.
c. Select Authentication & API Access as connection type.
d. Select scopes lists you want to tool to have access permissions.
e. Enter the https://www.getpostman.com/oauth2/callback as callback url.
f. Finally, confirm the details and create the application, then click View Application.
You will go back to this window later to copy the Client ID, Secret Key, and Scopes.
Encrypt you Client ID & Secret Key.
4th. Copy pasting in your information in this way: clientid:secretkey
Please note that the colon punctuation mark is required.
Generate TokenID with chrome app Postman
5th. Install the Chrome app Postman and launch the app.
6th. In the main app window, click the Authorization tab and select OAuth2.0
• Name - Name your access token, to easily identify which scopes you are using.
• Auth URL - https://login.eveonline.com/oauth/authorize.
• Access Token URL - https://login.eveonline.com/oauth/token.
• Client ID - Your Client ID generated by the EVE Developers app. See Step 2.
• Client Secret - Your Secret Key generated by the EVE Developers app. See Step 2.
• Scope - Copy and paste the scopes listed in the EVE Developers app. See Step 2.
• Grant Type - Authorization Code.
• Request access token locally - Make sure this box is ticked.
7th. Paste the base64 encoded Clientid:Secretkey and the Postman generated TokneID in to the tool.
6th. In the main app window, click the Authorization tab and select OAuth2.0
• Name - Name your access token, to easily identify which scopes you are using.
• Auth URL - https://login.eveonline.com/oauth/authorize.
• Access Token URL - https://login.eveonline.com/oauth/token.
• Client ID - Your Client ID generated by the EVE Developers app. See Step 2.
• Client Secret - Your Secret Key generated by the EVE Developers app. See Step 2.
• Scope - Copy and paste the scopes listed in the EVE Developers app. See Step 2.
• Grant Type - Authorization Code.
• Request access token locally - Make sure this box is ticked.
7th. Paste the base64 encoded Clientid:Secretkey and the Postman generated TokneID in to the tool.
The ESI price and skill update, are supported only in MS Office 2016, earlier versions of excel need to download and install Microsoft Power Query
Open office do not support direct ESI update, and therefore can not auto update skills and market data. you will have to enter your own prices and skills manually.
2) Which Scopes are needed for this tool?
The tool is not fulll functional yet so not alle the shopes below are in use. But plans are to incorporate them all in a foreseeable future.
Copy and past the following lines in the EVE Developers app and Postman app.
Copy and past the following lines in the EVE Developers app and Postman app.
publicData esi-skills.read_skills.v1 esi-skills.read_skillqueue.v1 esi-wallet.read_character_wallet.v1 esi-search.search_structures.v1 esi-universe.read_structures.v1 esi-assets.read_assets.v1 esi-planets.manage_planets.v1 esi-markets.structure_markets.v1 esi-corporations.read_structures.v1 esi-industry.read_character_jobs.v1 esi-markets.read_character_orders.v1 esi-characters.read_blueprints.v1 esi-location.read_online.v1 esi-contracts.read_character_contracts.v1 esi-corporations.read_divisions.v1 esi-assets.read_corporation_assets.v1 esi-corporations.read_blueprints.v1 esi-contracts.read_corporation_contracts.v1 esi-corporations.read_starbases.v1 esi-industry.read_corporation_jobs.v1 esi-markets.read_corporation_orders.v1 esi-industry.read_character_mining.v1 esi-industry.read_corporation_mining.v1 esi-planets.read_customs_offices.v1 esi-corporations.read_facilities.v1 esi-characters.read_titles.v1 esi-corporations.read_outposts.v1
3) When I click update, my skills are not updated?
You need Microsoft Office 2016 to use the ESI skill import, earlier versions need to download Microsoft Power Query
(OpenOffice does NOT support this form of VBA)
(OpenOffice does NOT support this form of VBA)
Open Office or none Pro MS office version, does not support XML import, therefore you can not do import of skills, asset or price information. But you do have the option to enter skills and price info manually.
4) My CORP Tower’s are not listed in the POS production sheet?
The tool has not been configured for corporations asset or tower import yet.
5) My Character or Corp Asset List, are not being updated?
The tool has not been configured for corporations asset or tower import yet.
6) Why do I get the error: This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.
Your Excel ActiveX security is too high. You have 2 options, either lower the security or put the sheet in to a trusted folder.
opt.1 Activex link
opt.2 Trusted folder link
7) I get this error when clicking update: Runtime Error '-2147217376 (80041020)'
It seems office 2007,2010 & 2013 can have a issue with the feature "Visual Basic for Applications" this is how you fix it.
1. Go to Control Panel -> Programs and Features -> Select "Microsoft Office" (DO NOT DOUBLE CLICK) -> right click and select "Change"
2. Select "Add or Remove features" -> Scroll down to "Office Shared Features" -> set "Visual Basic for Applications" to "Not Available -> Click Continue.
3. Once Office is finished removing "Visual Basic for Applications", follow the same instructions, this time install "Visual Basic for Applications" again.
Macro's should be enabled and the xlsm file should load without any errors.
Thanks to Commander IceQ for submitting the fix
8) Nothing happens when i try to update my character skills.
When opening the tool, you will be asked to enable the macros, when doing so, you recieve an error message like this:
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.
In some cases this is be cause the VBA "Visual Basic for Applications" was not enabled during the installation of Office itself.
Modifying the Office/Excel installation with Add/Remove Programs and enabling VBA, should make the character import work again.
Thanks to Geeyo for submitting the solution.
9) Office 2013, Run time error '1004'
"Run time error '1004': The password you spplied is not correct. Verify that the CAPS LOCK key is off and be sure to use the correct capitalization."
Office 2013 have a problem when dealing with password protected sheets.
To get around this bug, then users of Excel 2013, should avoid using the restore all funktion in the DATA sheet section. Instead, go to each tool, and restore them one by one.
10) Why are some material price listed as 0Isk?
Still unknown to me why EVE is feeding us 0isk Average & Adjusted prices on some ingame items.
when entering the https//getpostman url callback the aplication is telling me it's not valid?
ReplyDelete