Pages: 1 2 3 4 5 6 7 8 [9] 10 11 12 13 14 15 .. 15 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.01 11:15:00 -
[241]
Originally by: Companion Qube I know you love hearing from me [...]
Always, CQ, always.
Quote:
I have a hunch that +7b in the corp wallet is accurate, the +19b in the personal wallet is probably noise.
Any thoughts?
Any idea which of the figures is wrong? The suspects seem to be the "big three": Corporation Account Withdrawl, Market Escrow, Market Transaction.
It might have something to do with the recent change to the Wallet Journal API. My adaption might be flawed, but I'm not sure where to look at. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2011.02.01 17:48:00 -
[242]
Edited by: Companion Qube on 01/02/2011 18:10:42
Originally by: Hel O'Ween
Any idea which of the figures is wrong? The suspects seem to be the "big three": Corporation Account Withdrawl, Market Escrow, Market Transaction.
It might have something to do with the recent change to the Wallet Journal API. My adaption might be flawed, but I'm not sure where to look at.
I think it missed a player donation to the corp wallet for ~30b. Player donations between the two journals (corp & personal) should zero sum, but they don't.
It looks like something has gone wrong between one character and the corp wallet - I'm going to try grabbing the last 30 days of data for corp/char with an empty database and see what I get.
|
teppo3345345
|
Posted - 2011.02.01 19:10:00 -
[243]
Original question in post 225:
Originally by: Hel O'Ween
Originally by: teppo3345345 Of course the new account API will be inserted, but is there something that should be done before such change?
That depends upon your desire to keep the old data still visible. If so, you need to do an export (File -> Export/import EWA data) of that char's data prior to updating the API key/user ID for that char. After you set up the char with you new API data, import it back to this char.
If you don't care about your old data, just go ahead and change its API key/user ID. You'll still keep personal data that way, as EWA identifies personal data by characterID (which should't change, I assume). But corp data is identified by userID (=account).
I seem to have messed up big time. I wanted the old data visible, so I followed the instruvtions (File -> Export/import EWA data) and updated API after that. This was done on 15.1.2011. Now all wallet transactions before 15.1. are only shown in wallet transactions if "personal data" is selected from first page. The transaction rows which were transactions for corp are colored light blue and marked as "for : corporation". The problem is that no such transactions are visible when looking wallet transactions when "corporation data" is selected from first page.
Is there a way out to victory, or am I doomed to put the data into eg. excel and combine the transactions one by one to get correct numbers?
I have the original export file still, which was created before api change. If I remember correctly, total wipe and new import won't work since I can query new data only for one week (don't remember correctly)...
|
Companion Qube
|
Posted - 2011.02.01 21:37:00 -
[244]
Edited by: Companion Qube on 01/02/2011 21:40:20
Originally by: teppo3345345 ...
It might be too late to suggest this, but an easy way to handle your situation would have been to add the new api info then setup a virtual character that encompassed both the old and new data. That's what I ended up doing to get a cashflow statement for all of my accounts and corps.
Hel- I backed up and moved my EWA database and polled data from the API again, this time the corp donations showed up as expected. Something is still weird through, the totals in EWA don't match up with what I see in game. I'm going to get a notepad and balance my in-game wallet and see if I can figure out where transactions are missing in EWA.
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.02 17:27:00 -
[245]
@Teppo:
Originally by: teppo3345345
Is there a way out to victory, or am I doomed to put the data into eg. excel and combine the transactions one by one to get correct numbers?
I have the original export file still, which was created before api change.
Please send me an email to [email protected]. I'm pretty sure we can figure out a way to make your data visible again.
@CQ:
I have the suspicion that this might again be a case where two entries share the same refID/transaction number and therefore one of them gets discarded by EWA as a dupe. Any chance that you could mail me the two XML files? Also the refIDs of the missing entries would be helpful. If you can find them in the corp journal, but not in the personal journal, double-click the row in question in the corp journal. A new window should open with the "raw" database record. the value of the column "refID" is what I'm after. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2011.02.02 21:00:00 -
[246]
How do I dump the raw xml for the corp & personal journal? If it's easier I'm happy to send you the full api key for the character in question.
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.03 12:13:00 -
[247]
Edited by: Hel O''Ween on 03/02/2011 12:15:54
Originally by: Companion Qube How do I dump the raw xml for the corp & personal journal? If it's easier I'm happy to send you the full api key for the character in question.
Extras -> Cached XML files. Click on the entry in question. That window has its own menu called "XML files". Select "Export to file" from there.
You may want to use the menu entry "Clear cache" first. That removes all XML files from the cache, where the cache timer has already expired, so that its easier to spot the XML in question. -- EVEWalletAware - an offline wallet manager |
Clandestine Dargon
|
Posted - 2011.02.04 03:30:00 -
[248]
Hi,
I'm also getting the error "Error accessing database at C:\ProgramData\EVEWalletAware\DATA\. application will now terminate."
I have vista as well.
As your post 221 suggested i searched on the .mdb file but only found one copy. Deleted it but it still gets the same message.
This program would be perfect for my corp wallet managing needs. So I'd love to get it working. I am very much an end user of programs and if a program doesn't work I'm like a cat trying to open a can of food. clueless. Were you able to solve this problem yet?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.06 23:00:00 -
[249]
1) I guess it's best to set XP compatibility for EWA
2) Make sure EVEWalletAware.mdb is located in "C:\USERS\ALL USERS\APPLICATION DATA\EVEWALLETAWARE\DATA\".
3) Locate the INI file and make sure the above path matches the path (Data Source= ...) noted under [Database] [Database] Connection=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\EVEWALLETAWARE\DATA\evewalletaware.mdb;User Id=admin;Password=;
As I said before, I'm still not familiar enough with Vista/Win 7 to know to stop them from messing around with those folders. If I search my hard drive for the database, I regularly end up with 4-5 copies, some of them "real", some of them SymLinks/Junctions (or whatever those are called ...) -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2011.02.07 00:47:00 -
[250]
Just thought I'd report back - some days after I reported the missing journal data then API decided to cough it up. Everything balances again, but I'm not sure what changed :p
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.07 13:21:00 -
[251]
Edited by: Hel O''Ween on 07/02/2011 13:21:28 Thanks for the feedback, CQ, much appretiated, although it of course leaves me wondering if there's something wrong with EWA or if the wallet journal API change caused some hicup on CCP's side ... -- EVEWalletAware - an offline wallet manager |
Companion Qube
Minmatar Electron Conservation Inc
|
Posted - 2011.02.07 21:01:00 -
[252]
I'm honestly not sure either. About 3 days after I noticed the problem it magically resolved itself. I kind of wonder if they broke the api after the most recent patch, then pushed out a fix without saying anything.
... drunkpoasting best poasting yo |
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.11 13:17:00 -
[253]
Originally by: teppo3345345 Original question in post 225:
Originally by: Hel O'Ween
Originally by: teppo3345345 Of course the new account API will be inserted, but is there something that should be done before such change?
That depends upon your desire to keep the old data still visible. If so, you need to do an export (File -> Export/import EWA data) of that char's data prior to updating the API key/user ID for that char. After you set up the char with you new API data, import it back to this char.
If you don't care about your old data, just go ahead and change its API key/user ID. You'll still keep personal data that way, as EWA identifies personal data by characterID (which should't change, I assume). But corp data is identified by userID (=account).
I seem to have messed up big time. I wanted the old data visible, so I followed the instruvtions (File -> Export/import EWA data) and updated API after that. This was done on 15.1.2011. Now all wallet transactions before 15.1. are only shown in wallet transactions if "personal data" is selected from first page. The transaction rows which were transactions for corp are colored light blue and marked as "for : corporation". The problem is that no such transactions are visible when looking wallet transactions when "corporation data" is selected from first page.
Is there a way out to victory, or am I doomed to put the data into eg. excel and combine the transactions one by one to get correct numbers?
I have the original export file still, which was created before api change. If I remember correctly, total wipe and new import won't work since I can query new data only for one week (don't remember correctly)...
Now that we resolved this issue, I should mention that my original suggestion, which teppo followed, doesn't work in case a character gets moved from one EVE account to another.
To handle the situation that you move a character to a different account, one can either do it the way Companion Qube suggested above or contact me via email. It takes two SQL statements issued in EWA's build in DB manager, which I'm happy to guide you through, to resolve the problem. -- EVEWalletAware - an offline wallet manager |
Michaellh
|
Posted - 2011.02.15 02:56:00 -
[254]
Hey, I am unable to get the install to work for some reason. I download it and it gives me an error message something about a file missing and I have tried downloading it multiple times.
I have windows vista 32bit, not sure if that has anything to do with it. Any suggestions would be helpful, thanks.
Mike
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.15 13:11:00 -
[255]
Originally by: Michaellh Hey, I am unable to get the install to work for some reason. I download it and it gives me an error message something about a file missing and I have tried downloading it multiple times.
Could you be a bit more specific, please? "something about a file missing" isn't exactly a detailed error report. I bet the error message sounds different.
Also, does the install fail or does the program itself fail to start after the installation? -- EVEWalletAware - an offline wallet manager |
Michaellh
|
Posted - 2011.02.15 14:40:00 -
[256]
I would say that you are correct. The full error message is in a box That says Initialisation Failed followed by the message "Error accessing database at C:\ProgramData\EVEWalletAware\DATA\. Application will now terminate. Hope that is a little bit better.
Mike
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.15 16:02:00 -
[257]
Then let me refer you to a post of mine a few postings above. -- EVEWalletAware - an offline wallet manager |
Michaellh
|
Posted - 2011.02.16 00:42:00 -
[258]
Alright, I set the compatibility to windows xp and still it did not work. I checked the location of the EVEWalletaware.mdb and it was in the correct location. I am unsure of how exactly to do step 3. If you wouldn't mind spelling it out a little bit more for me. Thanks,
Mike
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.16 10:16:00 -
[259]
Originally by: Michaellh I am unsure of how exactly to do step 3. If you wouldn't mind spelling it out a little bit more for me. Thanks,
- Open the file C:\USERS\ALL USERS\APPLICATION DATA\EVEWALLETAWARE\EVEWalletAware.ini with a text editor.
- Search for [Database]. Beneath that section, there's an entry "Connection=..."
- Within "Connection", make sure the location pointed to in "Data source=..." points to the right location. Pasting and overwrting the complete "Connection=..." line from my above posting should do the trick.
|
Michaellh
|
Posted - 2011.02.17 06:50:00 -
[260]
I did what you suggested and removed the old "Connection=..." with the one from your previous post. When I try to save the changes notepad gives me an error "Cannot create the C:\Users\all Users\ApplicationData\EVEWALLETAWARE\EVEWalleteAware.ini file. Make sure that the path and file name are correct."
Did I do something wrong?
Mike
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.17 11:27:00 -
[261]
EWA version 2.0.21 and EWAAutoData version 1.0.16 have been released.
This reintroduces eve-marketdata.com as a price source, though in its current form it's limited compared to EVE Central.
There's also a new option to enable/disable automatic (sub)totals in the wallet transaction, wallet journal and market order windows. This was requested in regards to Excel exports so that one doesn't have to manually remove those rows in Excel.
The configuration (EVEWalletAware.ini) can now be passed by command line. If you use this option, a) make sure you update both apps and b) use the commenad line switch with both apps.
As always, see the version history for details. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.17 11:37:00 -
[262]
Originally by: Michaellh Did I do something wrong?
Not at first glance. Make sure you got sufficent rights to edit the file in that location (might need to do that as an admin) and/or no AV software intercepts your editing. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.02.17 13:49:00 -
[263]
Is it possible to add a "ZAP!" option somewhere? IE I press it and the DB is completely cleared of everything except the default > 100M of stuff I never understood what's doing in there to begin with. - Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|
Amaroq Dricaldari
Amarr Universal Deathdealing Militia Fusion Alliance
|
Posted - 2011.02.17 14:47:00 -
[264]
EWA is just one letter short of EWAR -- As an Amarr Defector, I chose to become a Mercenary and Industrialist. I also have one goal in mind: Create a new age of peace and prosperity for all four empires. |
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.17 18:08:00 -
[265]
Edited by: Hel O''Ween on 17/02/2011 18:09:09
Originally by: Vaerah Vahrokha Is it possible to add a "ZAP!" option somewhere?
Unfortunately, no. Although I've thought of that myself a couple of times.
The closest you can get is go and grab the empty database from EWA's website and overwrite your current DB. But you'll lose everything (including accounts & chars) that way.
Quote:
[...] the default > 100M of stuff I never understood what's doing in there to begin with.
Those are the parts of CCP's static datadump used by EWA, the biggest table (mapDenormalize) being the one needed to get a system/station name from an asset's locationID. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.02.17 18:28:00 -
[266]
Stupid question: why isn't the database holding the CCP dump kept separate from the character's API data? It's kind of painful to keep a zillion copies @157MB each when a 10MB database per group of accounts would be enough. - Auditing & consulting
When looking for investors, please read http://tinyurl.com/n5ys4h + http://tinyurl.com/lrg4oz
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.18 10:00:00 -
[267]
Because queries across two physical files in Access are a PITA and do not perform really well. -- EVEWalletAware - an offline wallet manager |
Noisette Noir
|
Posted - 2011.02.18 11:56:00 -
[268]
Just started using EWA, looking very nice! Thanks! |
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.18 13:26:00 -
[269]
Originally by: Vaerah Vahrokha Is it possible to add a "ZAP!" option somewhere?
After rereading your question, I realized that I misread it as "Is there a ZAP option?". To which the answer is "No", as I stated above.
Now, adding such an option is of course possible, something I just did and which will be available with the next release. -- EVEWalletAware - an offline wallet manager |
Noisette Noir
|
Posted - 2011.02.19 13:43:00 -
[270]
Hi again! I have a question:
Ingame I have corptransactions from the 20th of januari-today, but EWA only shows transactions from the 25th, even though I've set the date earlier. Why is that? It was the same when I first tried the program a couple of days ago.
I also wonder if EWA saves the data, so that it will eventually go back a lot longer than ingame? (this is actually why I tried EWA in the first place, before I knew all the nice features)
/Noisette Noir |
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 [9] 10 11 12 13 14 15 .. 15 :: one page |
First page | Previous page | Next page | Last page |