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.
Previous page12
 

Invention and Manufacturing Spreadsheets v1.4 from Caltech Shipyards
Author
Previous Topic Next Topic
Haffsol
#21 - 2012-07-31 16:12:39 UTC
Quote:
A workaround might be to access the document via a shortcut specify the "start in" directory as the location where you want the eveIMMS directory to live if different from the documents location.

lol I didn't think about that

more kudos for you :)
Svica
The Inf3cted
Pathog3n
#22 - 2012-08-01 21:49:35 UTC
ok maybe im an idiot but i click on the eve central tab and i dont see any button to load prices

i downloaded opend via free winzip pulled all the excel files to a folder on desktop
Svica
The Inf3cted
Pathog3n
#23 - 2012-08-01 22:08:57 UTC
i dont see the buttons on the left as stated.. can anyone give me a hand? this is frusterating X
Lore Varan
Caltech Shipyards
#24 - 2012-08-02 08:18:57 UTC
There not excel files there Open Office files

Which Spreadsheet program are you using to open the files ?

Buttons and macro's wont work in Excel

You need to use Open Office to open them and follow instructions about granting macro permission as stated in the op.
Wolfic
Republic Military School
Minmatar Republic
#25 - 2012-08-02 20:54:38 UTC
Thanks for updating these, your spreadsheets were directly responsible for getting me to try out manufacturing.
Lore Varan
Caltech Shipyards
#26 - 2012-08-19 15:53:18 UTC
Version 1.4 released for EvE Inferno 1.2

*Changes to mineral requirements for barge construction.
Rebel WIng
Wolves in the WebWay
#27 - 2012-09-01 20:00:27 UTC  |  Edited by: Rebel WIng
Nvm. Figured it out two minutes after I posted. Lol
Deus Mallius
Deep Core Mining Inc.
Caldari State
#28 - 2012-09-06 07:20:44 UTC
Haffsol wrote:
I think the "Unable to download XML data from EVE-Central" error is due to a path issue. I moved your (uber) sheets in a my /Documents/EVE/something subdir, created the EveMMS links pressing the Purchase&Buy button but I had that error trying to fetch prices by the Eve-Central button. Now I moved the sheets in /myself/Documents (where the EveIMMS dir is located) and I have no error shown, prices are applied correctly in the "Buy" page so it looks like being fixed.....but I don't see anything in the Eve_central one. Not a major problem but having all those fields in the Eve-Central tab/page referring to the buy/sell orders filled up with data could be useful.

I don't know how hard it is fixing the path issue but I'd like to be able to move them in a different path than /myself/Documents. That dir is full of stufff you know

Anyway...... thanks for sharing the love for spreadsheets


I'm getting this error as well, but i am using OO and using version 1.4 of your spreadsheets.

I seem to be able to pull data with the ammo/module/etc files but not the template files.

I put in about 34 item IDs and it throws the above error around the 20th ID.

I get the same error when I copy the list of type IDs I want into the top of the T1 spreadsheet, but runs fine when I don't change anything.
Lore Varan
Caltech Shipyards
#29 - 2012-09-06 10:41:44 UTC  |  Edited by: Lore Varan
Deus Mallius wrote:
I'm getting this error as well, but i am using OO and using version 1.4 of your spreadsheets.

I seem to be able to pull data with the ammo/module/etc files but not the template files.

I put in about 34 item IDs and it throws the above error around the 20th ID.

I get the same error when I copy the list of type IDs I want into the top of the T1 spreadsheet, but runs fine when I don't change anything.



I have not tried doing a download with the template sheet ( This is a partially constructed sheet for accepting data from SQL dumps for custom sheets )
IF the download does work then a couple of notes.

ID's are put into a HTML request that goes to the EVE-Central server.
Make sure there are no formatting character in the number no ( , or . ) thousands seperators or deimal points.
Numbers must consist of the characters 0123456789 and nothing else.

Also check your type ID's 1 at a time to make sure they are valid id's


ID's are sent in batches of 20 If your getting back the first data set then it could be any value in the second set of 20 causing the corruption.

Make sure there is no spurious text of anykind in the rows after the typeid's finish
I would delete all rows after the last number , just to make sure there are no cells with spaces in or anything like that
Previous page12