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

Author Topic

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2010.12.23 09:39:00 - [211]
 

Edited by: Hel O''Ween on 23/12/2010 09:38:55
Cool. Smile

Just out of curiosity: did you try EWA's built in "Compact database" (which should be really labeled as "Compact and repair") before resorting to Access?

I presumed you did that already but to no avail.

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
Posted - 2010.12.23 10:54:00 - [212]
 

Yeah, I did - it roasted the 1.5gb of cached db calls and extra log data but didn't fix the underlying structural problem. Sorry for the false alarm, once I turned my brain back on and read the log it wasn't too hard to fix.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.03 09:50:00 - [213]
 

EWA version 2.0.18 and EWAAutoData version 1.0.13 have been released due to the fact that EVE Metrics has officially shut down (see this thread)

Fortunately, someone else tries to pick up where EM left. This service is called EVE Marketdata.com (http://www.eve-marketdata.com).

It tries to mimik EM's API, therefore this release of EWA lets you edit EWA's INI to use a different URL for EM's API (I didn't bother to remove the "EVE Metrics" references yet).

To point EWA to a different URL, add the following line to EWA's INI beneath the [EVEApi] section:

[EVEApi]
EMBaseURL=http://eve-marketdata.com

Please note though, that as of now the API of EVE Marketdata doesn't work porperly yet.

As always, see the version history for details.

bubble21
Posted - 2011.01.03 19:19:00 - [214]
 

Question: Is there any way to get the time in the wallet journal to be translated to Local time, or perhaps run it on a 24 hour clock like Eve?

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.04 10:17:00 - [215]
 

The date/time format should come from your machine's local settings. If you want 24h format, check your machine's Settings -> Regional settings.

EWA doesn't do any formatting and on my machine it shows fine in German format (dd.mm.yyyy hh:nn:ss 24h)

Vaerah Vahrokha
Minmatar
Vahrokh Consulting
Posted - 2011.01.04 10:39:00 - [216]
 

Edited by: Vaerah Vahrokha on 04/01/2011 10:43:10
I have some issues:

1) Speed: updating a client of mine API data takes 2 hours. With old EveTrader it takes 30 minutes, with Income Analyzer it takes 2-3 minutes (all fetch both wallet and journal). They are not native executables but .net.

2) Selecting all of the available options to clear a database and also manually deleting every character still leave a 272MB database after compaction.

3) Once the database has been cleared and populated with new characters, the autoupdater won't work, it says error accessing characters of characters not found.

EventID 1001
Event ApplicationError

Error loading characters from database

4) I tried Setup's repair.
Now the app won't start any more, it says "Error accessing database at \. Application will now terminate".


Edit: restoring the .ini [Database] to before repair seems to fix the 4)

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.04 11:37:00 - [217]
 

A couple of answers (not necessarily solutions):

Originally by: Vaerah Vahrokha

1) Speed: updating a client of mine API data takes 2 hours. With old EveTrader it takes 30 minutes, with Income Analyzer it takes 2-3 minutes (all fetch both wallet and journal). They are not native executables but .net.



Did you notice where it takes the longest? EWA fetches journal, trasnactions, market orders, assets. For me market orders takes by far the longest, due to the fact that the API serves you all market orders in one XML, without the paging they implemented for transactions or assets.

I admit, that the way EWA process those might add to the time - EWA always processes the whole XML (all rows).

Quote:

2) Selecting all of the available options to clear a database and also manually deleting every character still leave a 272MB database after compaction.



The "base" DB is currently ca. 140 MB in size, so - yes 272 MB seems to much. Have you also cleared the application log? That can grow quite enormous ...

Quote:

3) Once the database has been cleared and populated with new characters, the autoupdater won't work, it says error accessing characters of characters not found.



The updater fetches the accounts/chars on startup. If you left him running will doing the cleanup/adding new chars, that might be the point where it got confused. It still tries to work with the old DB IDs it fetched when starting, but the chars/accounts now don't match those IDs anymore.

I'll look into the speed thing and se if I can optimize something there.

Vaerah Vahrokha
Minmatar
Vahrokh Consulting
Posted - 2011.01.05 00:40:00 - [218]
 

Edited by: Vaerah Vahrokha on 05/01/2011 00:41:30
Originally by: Hel O'Ween

Did you notice where it takes the longest? EWA fetches journal, trasnactions, market orders, assets. For me market orders takes by far the longest, due to the fact that the API serves you all market orders in one XML, without the paging they implemented for transactions or assets.



The longest is when showing those count up operations.
Little records people stop at around 1000 (why? Some have like 300 but it always seem to go to 1000) but once you go to 20000 the stuff really slows down to a crawl. Corp records seems slower than non corp, don't know why.


Quote:

The "base" DB is currently ca. 140 MB in size, so - yes 272 MB seems to much. Have you also cleared the application log? That can grow quite enormous ...



I opened the menu where the DB operations are located and have done all of the purges and then compact. Did I miss some other options elsewhere?

Edit: the deletions were made by setting an old date, in fact the program would prompt about confirming the operation would affect all of the data.

Quote:

The updater fetches the accounts/chars on startup. If you left him running will doing the cleanup/adding new chars, that might be the point where it got confused. It still tries to work with the old DB IDs it fetched when starting, but the chars/accounts now don't match those IDs anymore.



It was closed and not minimized.
In any case even rebooting it still won't start.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.05 10:55:00 - [219]
 

VV, would you mind contacting me at Hel.OWeen@eve-biotronics.de?

I've got a couple of questions/suggestions and in order to preserve your and your client's privacy, I think an email conversation is better suited.

laksmi2
Posted - 2011.01.12 03:19:00 - [220]
 

when starting i get the error message: error accessing database at c:\programdata\evewalletaware\data\, application will now terminate.
the folder exists and has .mdb file in it.

installation was full download. op = windows 7
mdac and msxml are installed.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.12 10:09:00 - [221]
 

Originally by: laksmi2
when starting i get the error message: error accessing database at c:\programdata\evewalletaware\data\, application will now terminate.
the folder exists and has .mdb file in it.

installation was full download. op = windows 7
mdac and msxml are installed.


Oh, the joy of Win 7 virtualisation ...

Search for EVEWalletAware.mdb on your hard drive. You might find three copies, if I remember correctly. Delete all but the one located in C:\Documents and Settings\ ... (which really is C:\Users, but there's a copy too, which needs to be deleted first).

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
Posted - 2011.01.13 06:48:00 - [222]
 

One more quick win7 thing - on shutdown EWA auto updater doesn't seem to be closing itself down properly unless it's already paused. I've seen this trying to close down manually too, the program needs to be paused before it will exit cleanly. If the shutdown signal is sent without pausing first then the program switches into paused state but doesn't close.

You might be able to hack around it by just running the code in the shutdown event handler twice.

Lauren Hellfury
Full Pocket Aggro
Posted - 2011.01.13 13:41:00 - [223]
 

First up, awesome app. Just started with it a couple of days ago - very impressed.

Just a quick querey/suggestion:


In the wallet transaction window each item group contains qty, price, total. However the price uses an unweighted average of the transaction entry prices. Not a massive problem since you can get a weighted average by dividing the total by qty but it means that the three columns are not internally consistent.

Example:
Item 1: Qty (6408) Price (217,325.56) Total (1,389,309,054.45)

Qty * Price = 1,392,622,188.48
Total / Qty = 216808.53
Total / Price = 6395.75

No esitmation of sales tax or brokers fees are being calculated (turned off) since for both of those I just pull the totals from the wallet journal instead.

To verify this I ran a manual calulation of an item with a smaller number of individual transactions and adding each price paid (regardless of qty) and dividing by the number of entries did indeed give the value shown in the Price column.

Theoretical example:

Item 1: 30@ 100,000 + 20@ 150,000
Reality. average price = 120,000 (6,000,000 / 50)
EWA. average price = 125,000 ( (100,000 + 150,000) / 2 )


Working as intended or oops? Twisted Evil

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.14 11:21:00 - [224]
 

Edited by: Hel O''Ween on 14/01/2011 11:23:20
@CQ:
Yeah, I know. Embarassed
Due to VB's lack of multithreading, this is e real PITA. I'm already doing various (ridiculous) things to catch the termination event - alas, it doesn't work always. So, yes, your safest bet ist to pause first, then exit the app.

@Lauren Hellfury:
Quote:

Working as intended or oops?



Short answer: working as intented.

Long answer: This average was introduced upon request for a producer buying minerals. He always buys, never sells and wanted a quick and dirty average at first glance (for calculation purposes). It's mentioned in the version history of that release.

What you're after is currently provided in the "Item details" (right click a row of the item in the transactions window -> Item details). In EWA's next release, the balance sheet by transactions will also include that information.

teppo3345345
Posted - 2011.01.17 21:02:00 - [225]
 

Will EWA handle ok the situation where character is transfered into new account. Of course the new account API will be inserted, but is there something that should be done before such change?
The character in question is running both personal and corporation trades.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.19 17:58:00 - [226]
 

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).

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.20 10:29:00 - [227]
 

Just a quick note to let you know that with Incursion 1.1 the Wallet Journal API changed and therefore the current EWA version might not retrieve your journal data.

I'm working on a patch and release it as soon as I can.

Vaerah Vahrokha
Minmatar
Vahrokh Consulting
Posted - 2011.01.20 10:42:00 - [228]
 

One neat feature of JEveAssets and EveTrader is how easy is to segregate data on a per-"customer basis".

IE if I want to process data for a guy with 3 accounts I have managed (or manual in EvETrader) easy ways to keep that data in one file and totally separated to anyone else.

This seems to be peregrine but it's not, expecially because of the AutoUpdater.

First of all, as of now I have to give an Auditee his data I gathered for him but I have no idea at how to grab his 4 accounts data. Due to having to use the autoupdater to not get crazy with 30-40 manual account updates per day, his data are with other people and so how to I separate his 4 accounts (10 characters) to only give him his stuff?

Second, I did not find a way to selectively enable accounts to be updated by the autoupdater. This makes data gathering a 3 hours long cycle plus I am not authorized to gather data off people who are not authorizing me for a given period. IE an auditee wants one audit today, one in his new bond 3 months later and so on. I would not want to lose his accrued data but I cannot keep it without it being harvested with everyone else's and this could constitute auditee API infringement of access.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.20 16:19:00 - [229]
 

Originally by: Vaerah Vahrokha
One neat feature of JEveAssets and EveTrader is how easy is to segregate data on a per-"customer basis".

IE if I want to process data for a guy with 3 accounts I have managed (or manual in EvETrader) easy ways to keep that data in one file and totally separated to anyone else.

This seems to be peregrine but it's not, expecially because of the AutoUpdater.



It can be done and it's not terribly complicated, even with the AutoUpdater: Both apps always work on the EVEWalletAware.mdb, which holds both the API keys/chars and data for those.

In theory you could just rename EVEWalletAware.mdb to MyCustomerA.mdb and back when working on customer A, rename EVEWalletAware.mdb to MyCustomerB.mdb when working on customer B and so forth. Granted, if you're working on multiple customers at the same time, this doesn't help much except keeping the data in separate databases.

But wait, there's more ...

Quote:

Second, I did not find a way to selectively enable accounts to be updated by the autoupdater.



... and this, Ma'am, will be possible with the next release of the AutoUpdater. OK, so it's not accounts but characters. Plus you get the option to select which data to download for a char (personal, corporation or both). Smile

I already had that i mind for quite some time and - believe me or not - finished it just a couple of minutes ago. I'll do a bit of testing and release it in the next couple of days along with the API wallet journal update for both EWA and the AutoUpdater.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.21 15:00:00 - [230]
 

Edited by: Hel O''Ween on 21/01/2011 15:00:01
EWA version 2.0.19 and EWAAutoData version 1.0.14 have been released.

Both versions now handle the changed wallet journal API.

The updates for both applications also include functional updates (EWA: more infro from balance sheet by transactions, EWAAutoData: character selection for API download).

As always, see the version history for details.

Julian Koll
The Kollektive
Posted - 2011.01.21 15:13:00 - [231]
 

Discovered a possible Issue today:

When filling one's own buyorder, the purchase of the item is not taken into the item details, where as the sale is listed.

So for example i fill my own order of 5 trit, in item details it will read that i sold 5 trit but have baught none, so i made a 5 x trit price profit.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.21 16:09:00 - [232]
 

Shocked

If that's the case, then the buy transaction should also be missing from the wallet transactions window. Can you confirm that?

That would mean that buy and sell transactions share the same transaction number ... Rolling Eyes

Julian Koll
The Kollektive
Posted - 2011.01.21 17:06:00 - [233]
 

Mailed u ingame with screenshot :)

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.21 22:06:00 - [234]
 

Got it, thanks.

From what I can tell, I believe was right with my guess. Sell & buy transactions share the same transaction ID.

Lesson(s) learned:

1) Don't buy from yourself. Wink
2) Don't trust IDs to be unique.

It's easy to fix, but annoying that it a) happened and b) went unnoticed for two years. Embarassed

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
Posted - 2011.01.22 08:47:00 - [235]
 

Hey Hel- I noticed a possible problem, I'm only showing one character in the wallet stats grid of the auto updater after grabbing the new version. I checked under options, all of my characters are listed and set to pull data.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.22 10:00:00 - [236]
 

CQ, does the text log show any entries with Event: ApplicationError?

The logs are located under %ALLUSERSPROFILE%\Application Data\EVEWalletAware\LOGS\ and are named EWAAD<year><month><day><hour><minute><second>.txt

Also I noticed that EWAAutoData might throw an error if you launch this version for the first time, because no chars are selected. I thought that I did take care of that, but obviously I didn't.

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
Posted - 2011.01.22 10:40:00 - [237]
 

Edited by: Companion Qube on 22/01/2011 10:50:24
Edited by: Companion Qube on 22/01/2011 10:44:37
Ahhh, I figured it out. If there are any deleted characters still in EWA's database it'll cause the auto-downloader to choke and stop pulling records when it hits their entry. The second character polled was a deleted alt. Seems to be working fine now.

One more question - have you thought about putting in a setting to control how often the downloader polls the api? I can see how constant updates would be good for some people but I'm really only running it to catch the day's transactions - I don't need to poll 14 characters every 5 minutes.

Hel O'Ween
Men On A Mission
EVE Trade Consortium
Posted - 2011.01.24 13:45:00 - [238]
 

Edited by: Hel O''Ween on 24/01/2011 13:56:27
Originally by: Companion Qube

Ahhh, I figured it out. If there are any deleted characters still in EWA's database it'll cause the auto-downloader to choke and stop pulling records when it hits their entry. The second character polled was a deleted alt. Seems to be working fine now.



Good catch, CQ. That one also cause the problem I mentioned.

Quote:

One more question - have you thought about putting in a setting to control how often the downloader polls the api? I can see how constant updates would be good for some people but I'm really only running it to catch the day's transactions - I don't need to poll 14 characters every 5 minutes.


There has always been a setting for this, just not via an Option window, as EWA's initial incarnation was meant as a "zero-config" tool.

As always, you'll find the "goodies" in EWA's INI file:

[EWAAutoData]
QueryInterval=60
QueryPause=30


QueryPause is what you're looking for. This is the value in minutes EWA pauses between two download attemps.

QueryInterval is the interval (in seconds) for how often EWAAutoData checks to see if QueryPause has passed.

So, in the example above EWAAutoData checks every minute (60 seconds) if at least half an hour (30 minutes) has passed since its last download attempt.

Additionaly the cache timers of each XML is checked and only if they're expired, an actual download will be tried. Otherwise EWAAutoData just skips over that API.

[Added]
I've just uploaded EWA v2.0.20 and EWAAutoData v1.0.15 which
- Both: fix Julian's finding about missing transactions when selling to yourself
- EWAAutodata: check for chars without an associated account to prevent the error mentioned by CQ.

I'll update the version history later on.

Companion Qube
Minmatar
Electron Conservation Inc
SRS.
Posted - 2011.02.01 05:30:00 - [239]
 

I know you love hearing from me, but uh, I've broken something again.

Check this out: http://img441.imageshack.us/img441/7641/notreally19b.jpg

I definitely didn't make 28b over 10 days, if I had to guess it was more like 5-7b. Some context, I have a virtual character setup to give me an overview of all personal and corp transactions, basically a single master cashflow statement. Somehow something isn't accounted for and I'm over-reporting profit. I'm a bit confused to be honest, everything I've done across my accounts should be summarized there.

I have a hunch that +7b in the corp wallet is accurate, the +19b in the personal wallet is probably noise.

Any thoughts?

Lotus Green
Posted - 2011.02.01 10:41:00 - [240]
 

Can't get this to work on windows 7. Keeps saying 'Error accessing database'


Pages: first : previous : ... 4 5 6 7 [8] 9 10 11 12 ... : 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