| Pages: 1 2 3 [4] 5 6 7 8 9 :: one page |
| Author |
Thread Statistics | Show CCP posts - 0 post(s) |
AnnaJoy
   |
Posted - 2006.01.27 01:17:00 -
[91]
I have updated the program to 13.23. In this update I have fixed certain issues like incorrect zydrine refines on jaspet, hemophite and hedbergite. I also have entered all data except the structure of all frigates and destroyers to include their T2 variants.
The biggest change is the ability to set your file location. It comes default to the automatic update address but is easily modified to a hard drive location. This change was made to ease the transition to OpenOffice as it does not have the same functionality as Excel in regard to XML files.
As far as OpenOffice is concerned, tonight I hope to get some more of the macro complete that will allow automatic updates. Keep your fingers crossed.
AJ
|
AnnaJoy
|
Posted - 2006.01.27 06:55:00 -
[92]
Edited by: AnnaJoy on 27/01/2006 06:55:53
Here is a real update on the OpenOffice port progress... Tonight I made it so the program will open, read and parse the XML file. Now the next thing to do is to make it so that it will put the data into the form in the appropriate order. After that I think its safe to say we will have a working OpenOffice port of this thing, horray! Then maybe i can use this thing at home instead of only at work 
AJ
PS please test the automatic update of the Excel version. I'm not 100% positive it works because of course my work has the stuff blocked from my access and redirects me to another page so i cannot even try to test it.
|
Roti
|
Posted - 2006.01.27 16:50:00 -
[93]
I tried using the steps outlined about 4 posts ago, and I was able to get the character sheet downloaded, but nothing would seem to import to the other spreadsheets. AKA I see the information on the "Eve-XML Data" tab, but it does not update the other pages.
Am I missing something?
|
AnnaJoy
|
Posted - 2006.01.27 17:25:00 -
[94]
Edited by: AnnaJoy on 27/01/2006 17:25:25
 Originally by: Roti
I tried using the steps outlined about 4 posts ago, and I was able to get the character sheet downloaded, but nothing would seem to import to the other spreadsheets. AKA I see the information on the "Eve-XML Data" tab, but it does not update the other pages.
Am I missing something?
At this point, now you need to hit Ctrl-G. That will actually run the macro that will populate the rest of the Excel sheets with your data.
|
Roti
|
Posted - 2006.01.27 17:31:00 -
[95]
I did re-run the macro, but to no avail. I found the easiest thing to do was save the xml file to my hard drive and repoint the location of the file to be on my local hard drive. I will just manually grab the file from here on out.
|
AnnaJoy
|
Posted - 2006.01.27 17:50:00 -
[96]
Originally by: Roti
I did re-run the macro, but to no avail. I found the easiest thing to do was save the xml file to my hard drive and repoint the location of the file to be on my local hard drive. I will just manually grab the file from here on out.
Ok likely that means that i botched the updater, i'll try to take a look at it when i'm at work, but i can't do much about the web update. only the hard drive version for the time being
|
AnnaJoy
|
Posted - 2006.01.28 18:08:00 -
[97]
Ok, i didn't see anything that had changed with the updater to cause it to stop working, has anyone else run into this problem?
|
DeMiNe0
|
Posted - 2006.01.29 00:34:00 -
[98]
I've run into this problem with the newest version.
|
AnnaJoy
|
Posted - 2006.01.29 05:36:00 -
[99]
Originally by: DeMiNe0
I've run into this problem with the newest version.
Ok, I may have to revert to the older version and try and different solution. If you could please try this for me:
After running the macro, Right click in cell I10 or I11 and hit update query. and try getting to it from there. I really need to see about finding a machine with Excel on it. Maybe then i could do a better job of this mess.
AJ
|
DeMiNe0
|
Posted - 2006.01.29 18:15:00 -
[100]
I could get you excell if you don't mind using it for personal use and or a backup of your original version that you have allready bought.
Send me a message on IRC irc.digitaltoxicity.net #digitaltoxicity
MSN: [email protected] or
AIM: DeMiNe0
I'll hook you up.
I'm going to try that fix you mentioned now.
|
DeMiNe0
|
Posted - 2006.01.29 18:30:00 -
[101]
Edited by: DeMiNe0 on 29/01/2006 18:31:00
The right click menu has
"edit query"
and
"refresh data"
The refresh data does nothing... BUT
When i click edit query, select the table that has the login, password inputs and the submit button on the webpage, then log in like i normally would on the website, I can go back into the script, run the macro, and BAM! Theres the imported XML data...
Althought i'm not very good with Excel, I'm a web developer, so this may go a little above your head...
What you could do is this...
It seems to me like the XML file is protected by user authentication. If that page that i talked about above (the one i get when i edit the query). allows external POST and/or GET methods. You could have a place in the excel sheet that asks for the username and password of the account. Then you can have the excel sheet send the username, password and submit query to the website either via GET or POST method. This would inturn log you in on the website, and place what ever cookies you need where ever they have to go for excel to pull that XML.
|
DeMiNe0
|
Posted - 2006.01.29 19:31:00 -
[102]
Ok. I just had a friend download this script:
(Thanks to bunker of D2A for helping me out with it)
This is the step by step process of what bunker did to get this script working:
1. Downloaded the excel sheet.
2. Opened the excel sheet.
3. Went to (tools > macro > security) And set his macro security down to Medium.
4. Closed excel, and reopened the eve spreadsheet.
5. Clicked on the "Enable Macros" box that poped up as soon as the xls file loaded.
6. Went to the eve online website via the "log onto eve character information link" in the skills tab.
7. Loged in.
8. Clicked the "My Character" link on the left side of the page.
9. Clicked the Charactor he wanted stats for.
10. Clicked the XML DATA link.
11. Took note of the Character ID in the XML URL (The Bold part in the URL here: http://myeve.eve-online.com/character/skilltree.asp?characterID=810716805)
12. Go back to excel spread sheet.
13. Goto "EVE-XML Data" tab.
14. In the YELLOW field next to the Character # feild, put YOUR character id that i outlined above.
15. Now... Hit CTRL+G.
16. 2 Things might happen.... After the Macro is done running. Goto your skills tab. Look at the Name. Is your name there? If yes. Then your done. Congrats. If not then read on.
17. THe name spot in this case will most likely have N/A in it. Thats ok. That just means we have a few more steps to do...
18. Goto the "EVE-XML Data" tab again.
19. Right click on the I-10 grid. And click Edit Query. Either a Webpage with a login screen should show up, or a bunch of Code (the XML file). If its a login screen. Go head and log in. You should now see this XML code. Click the import button once you see the XML code.
20. Right click on I-10 again and click refresh data. Then hit CTRL+G.
21. Repeat step 20 until your character name shows up in grid D-5 of the skills tab..
The above steps are to help annajoy debug the script, and to help new people use this script while it is bugged.
|
AnnaJoy
|
Posted - 2006.01.29 19:37:00 -
[103]
Ok, it seems then, that i have pointed the sheet to the wrong webaddress. Normally what happens is you have to log in through your web browser like normal. After you log in, use the browser to go to my character, then select the character you want. Then what would happen is you would open excel, put in your character id like you mentioned and run the macro. It would appear that when i wrote down the address, i messed it up. i will play with the website and try to get to the data and update the sheet with the address that i find. Thank you for your help in this matter.
AJ
|
DeMiNe0
|
Posted - 2006.01.29 19:55:00 -
[104]
Edited by: DeMiNe0 on 29/01/2006 20:01:01
OK ya... Im really getting into this excel stuff. I created a Jump time Calculater. It's really crude, but if you want to improve on it and put it into your sheet, i think it would be a really good feature.
http://eve.digitaltoxicity.net/jumpcalc.zip
|
DeMiNe0
|
Posted - 2006.01.29 20:03:00 -
[105]
I just had another thought.. Is there a program that will convert an xls file to an exe? That would solve the problem of cross platform compatability.
|
DeMiNe0
|
Posted - 2006.01.30 03:41:00 -
[106]
so whats the status on that script?
|
MegabitOne
|
Posted - 2006.01.30 07:09:00 -
[107]
I think I discovered a slight problem in EMD13v10.
I am training for Missile Launcher Operation lvl4 and I have currently 11673 SP in MLO. I still have 17h36m10s to go according to Eve (My Character XML). However, if I update the EMD with the XML (CTRL-G), I see the correct number of SP for MLO, but when I fill in 4 in the Goal Level field for MLO, it says I need 1d11h06m !?!!! Is this by design or is it a bug? IMHO, it should say 0d17h36m, just as Eve does...
---
I'm not as bad-ass as some of my corp mates, but I'll pwn you anyway!
-= In God we trust, all the others pay cash =- |
Sharcy
|
Posted - 2006.01.30 07:44:00 -
[108]
Edited by: Sharcy on 30/01/2006 07:44:37
Originally by: MegabitOne
I think I discovered a slight problem in EMD13v10.
I am training for Missile Launcher Operation lvl4 and I have currently 11673 SP in MLO. I still have 17h36m10s to go according to Eve (My Character XML). However, if I update the EMD with the XML (CTRL-G), I see the correct number of SP for MLO, but when I fill in 4 in the Goal Level field for MLO, it says I need 1d11h06m !?!!! Is this by design or is it a bug? IMHO, it should say 0d17h36m, just as Eve does...
If you are still training that skill while you refresh, the number of SP will not update to the level you are currently at including the points already trained in this session. Only after the skill has finished training, or if you have stopped the training to temporarily switch to another, will it reflect the accurate total SP for that skill and thus the time left to train for goals.
--
|
Necronous
|
Posted - 2006.01.30 19:27:00 -
[109]
Indeed, the XML file in no way stores current training process. Apparently thats something EVE keeps track of on its own. If you want an accurate estimate, you can do one of the following:
1. (Fast Method) Manually enter your SP total in the sheet, but the downside is if you ever hit CTRL-G it will revert to the old stored data.
2. (Clunky Method) Login to EVE, stop training momentarily, then resume training. It may take up to 5 minutes, but eventually the XML sheet online will update. (seems to be updated periodically). Proceed to download file if necessary and hit Ctrl+G.
3. (Reccomended Method) This method only works if you update your sheet via a downloaded XML file, as opposed to directly off the web (Frankly I only use this method). Simply open the XML file with Notepad and scroll your way down to the skill in question. Simply change the skillpoint value (which is usually the skillpoints needed for the previous level, if you didn't change training skills mid level) to the new value and save the file. Ctrl+G will now upload the new value without the downsides of method 1.
|
Brutas Brutai
|
Posted - 2006.01.31 10:49:00 -
[110]
I appear to have an use with 13.23 :(
The ships tab now seems to have stacks of data missing - since you added the extra ships. 13.10 appears ok with the ship data it has but now iteron for example just has no data for hi/lo/mid slots etc
Additionally for all the ships with missing data it says I can fly regardless of race although this is probably a knock on effect of the missing data.
|
Griam
|
Posted - 2006.01.31 11:15:00 -
[111]
Hi, i tried to import xml Data, both with local and website, but all i get is a VB Runtime Error when i hit ctrl+g ...
perhaps cause i use a german Excel? Dont know ... any hints?
|
Griam
|
Posted - 2006.01.31 13:35:00 -
[112]
I installed newestVersion of Excel, and now it works fine ;)
Very nice Tool imho! 
|
AnnaJoy
|
Posted - 2006.01.31 14:11:00 -
[113]
Originally by: Brutas Brutai
I appear to have an use with 13.23 :(
The ships tab now seems to have stacks of data missing - since you added the extra ships. 13.10 appears ok with the ship data it has but now iteron for example just has no data for hi/lo/mid slots etc
Additionally for all the ships with missing data it says I can fly regardless of race although this is probably a knock on effect of the missing data.
Yes, when RMR came out, much of the stats of ships and drones were modified. As such i removed all that data and I am working to fill it all back in. The biggest problem is that my work has denied access to the eve website so I have to copy the data down while I am at home and then modify the sheet while I am at work. It makes it very inconvienent.
|
DeMiNe0
|
Posted - 2006.01.31 19:59:00 -
[114]
You know, i can set up a web based easty to use proxy on my website, that will allow you to access eve's website from work.
I'll get one up as soon as my ISP fixes there routing problem to my server.
|
ingerul9
|
Posted - 2006.01.31 21:49:00 -
[115]
Originally by: Necronous
Indeed, the XML file in no way stores current training process. Apparently thats something EVE keeps track of on its own. If you want an accurate estimate, you can do one of the following:
1. (Fast Method) Manually enter your SP total in the sheet, but the downside is if you ever hit CTRL-G it will revert to the old stored data.
2. (Clunky Method) Login to EVE, stop training momentarily, then resume training. It may take up to 5 minutes, but eventually the XML sheet online will update. (seems to be updated periodically). Proceed to download file if necessary and hit Ctrl+G.
3. (Reccomended Method) This method only works if you update your sheet via a downloaded XML file, as opposed to directly off the web (Frankly I only use this method). Simply open the XML file with Notepad and scroll your way down to the skill in question. Simply change the skillpoint value (which is usually the skillpoints needed for the previous level, if you didn't change training skills mid level) to the new value and save the file. Ctrl+G will now upload the new value without the downsides of method 1.
How do i enter my SP total from the fast method? I don't understand what should i modify. I mean i change the current skill points that i have?
|
AnnaJoy
|
Posted - 2006.02.01 02:05:00 -
[116]
Originally by: ingerul9
How do i enter my SP total from the fast method? I don't understand what should i modify. I mean i change the current skill points that i have?
Yes, the fast method is to go to the skills tab and modify the current SP of the skill to what you have it trained to.
AJ
|
AnnaJoy
|
Posted - 2006.02.01 02:08:00 -
[117]
Originally by: DeMiNe0
You know, i can set up a web based easty to use proxy on my website, that will allow you to access eve's website from work.
I'll get one up as soon as my ISP fixes there routing problem to my server.
Haha, I'd be able to use it for about a week and then i'd be sunk as they would block your IP/DN. Trouble with working with the government is that they try to "help" you by making your job harder than it needs be.
AJ
|
AnnaJoy
|
Posted - 2006.02.03 00:05:00 -
[118]
Today brings more updates to ships. In version 13.24 I have added the Industrials, Transports and T1 cruisers. Please enjoy. I am still working with the updater.
AJ
|
Any1
|
Posted - 2006.02.03 15:25:00 -
[119]
For me xml import doesn't work connecting on evew site and downloading it in local and midifiing the link to the xml file.
Btw it never worked.
cheers
Anymal
|
Josh Wink
|
Posted - 2006.02.04 05:43:00 -
[120]
Annajoy, this isa wonderful tool. Well done. I have one small query. After a reading the posts and doing a bit of trial and error, i managed to run the XML data through the sheet. But it doesn't pick up my base attributes, it leaves them all at zero. Can you - or anyone else - give me some advice on this?
|
| |
|
| Pages: 1 2 3 [4] 5 6 7 8 9 :: one page |
| First page | Previous page | Next page | Last page |