open All Channels
seplocked Market Discussions
blankseplocked EVEWalletAware (EWA) 2 - an offline wallet manager
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 5 6 7 8 [9] 10 11 12 13 ... : last (15)

Author Topic

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.02.01 11:15:00 - [241]
 

Originally by: Companion Qube
I know you love hearing from me [...]


Always, CQ, always. Very Happy

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.

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
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
Minmatar
Electron Conservation Inc
SRS.
Posted - 2011.02.01 21:37:00 - [244]
 

Edited by: Companion Qube on 01/02/2011 23:09:33
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 with a fresh database, this time the corp donations showed up as expected in the corp wallet. Something is still weird with the personal wallet through, corp withdrawals and donations aren't all there. The other transaction types seem to be accounted for - I estimated broker's fees by hand and that figure checks out. I assume taxes and buy/sell are correct as well, but I don't really want to check them by hand.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
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 Hel.OWeen@eve-biotronics.de. 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.

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
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
EVE Trade Consortium
Posted - 2011.02.03 12:13:00 - [247]
 

Edited by: Hel O''Ween on 03/02/2011 12:48:23
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.

[Added]
Not sure if this is just coincidence or a problem that's caused by the API, but other developers seem to also experience strange things with the wallet journal: http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1456779

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
EVE Trade Consortium
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 ...)

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
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
EVE Trade Consortium
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 ...

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
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.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
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.

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
EVE Trade Consortium
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?

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
EVE Trade Consortium
Posted - 2011.02.15 16:02:00 - [257]
 

Then let me refer you to a post of mine a few postings above.

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
EVE Trade Consortium
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
EVE Trade Consortium
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.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
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.

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.

Amaroq Dricaldari
Amarr
Vengeance Industrial Militia
Posted - 2011.02.17 14:47:00 - [264]
 

EWA is just one letter short of EWAR

Hel O'Ween
Men On A Mission
EVE Trade Consortium
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.

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.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
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.

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
EVE Trade Consortium
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.

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: first : previous : ... 5 6 7 8 [9] 10 11 12 13 ... : last (15)

This thread is older than 90 days and has been locked due to inactivity.


 


The new forums are live

Please adjust your bookmarks to https://forums.eveonline.com

These forums are archived and read-only