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 - 2010.02.04 11:43:00 -
[1]
I'm announcing the release of EWA v2.0. This release adds (basic) charting to EWA.
EWA was first released to the public in March 2008 (although not in this forum) and has continously been updated and enhanced since then. Version 2.0 requires additional components to be installed, therefore a separate/new setup has been created. An update installer for version 1 users is available, helping them to update their installation of EWA to version 2 while preserving their existing data.
EWA is a tool designed to help traders manage the following aspects of their business: - Wallet transactions - Wallet journal - Market orders - Assets
Current program version: 2.0.0 Current database version: 13 (Dominion 1.1.1)
Links: EWA website EWA download Manual Version history
Note: This is the only legit distribution site for EWA.
EWA is provided free of charge for the benefit of the EVE community.
Related: EO forum thread for version 1.x -- EVEWalletAware - an offline wallet manager |
Schwarzlicht
|
Posted - 2010.02.04 12:35:00 -
[2]
I just installed the v2.0 to a fresh Vista 64 installation and upon first start of EWA i get a popup that reads:
Run-time error '380':
Invalid property value |
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.04 14:02:00 -
[3]
Originally by: Schwarzlicht
Run-time error '380':
Invalid property value
Make sure you have the latest MS XML and MDAC installed. -- EVEWalletAware - an offline wallet manager |
Onyx Mdooku
|
Posted - 2010.02.04 14:12:00 -
[4]
Thanks Hel O'Ween, updating now. Also the link 'EWA Download' is broken atm and needs a fix.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.04 17:15:00 -
[5]
Originally by: Onyx Mdooku Also the link 'EWA Download' is broken atm and needs a fix.
Thanks for pointing that out. Fixed. -- EVEWalletAware - an offline wallet manager |
Iskker
|
Posted - 2010.02.04 19:05:00 -
[6]
Originally by: Hel O'Ween
Originally by: Schwarzlicht
Run-time error '380':
Invalid property value
Make sure you have the latest MS XML and MDAC installed.
I have the same problem. Using win7 32bit. Did install those additions mentioned from the links on EveWalletAware website. Still no go :(
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.04 20:18:00 -
[7]
Yepp, it seems that I've managed to add a bug in this release. I'm sorry for the inconvenience. Will let you know when I fixed it. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.05 08:37:00 -
[8]
OK, the above reported problems only plagued new users and/or fresh installs of EWA. It occurred with a blank database where no EWA account was created yet.
The problem has been fixed. If you've experienced this bug, you don't need to do a new install. Just download the new EXE from EWA's website and drop it into EWA's program folder on your machine.
Note to self: always test new releases with an empty database, too. |
arjun1
|
Posted - 2010.02.05 10:05:00 -
[9]
Edited by: arjun1 on 05/02/2010 10:06:54 error 380 invalid property value installed for the first time with a fresh full install system: win xp downloaded the exe, put in folder, still the same result.
|
Caldari's Revenge
|
Posted - 2010.02.05 11:20:00 -
[10]
Following error popped up when I tried retrieving data from EVE API on secondary account. The primary account retrieved information fine.
Run-time error '380'
Invalid property value
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.05 11:41:00 -
[11]
Edited by: Hel O''Ween on 05/02/2010 11:42:35 I'm terribly sorry, folks.
Try downloading the EXE again, make sure it shows version 2.0.1 (so that your browser's cache doesn't fool you).
I can't reproduce the problem here, but added nontheless some error trapping where I think the error might occur.
I do know the source of the problem: the account/character selection now tries to remember what account/char you have selected. But as I said, not sure where in there the error happens, if it still there. -- EVEWalletAware - an offline wallet manager |
arjun1
|
Posted - 2010.02.05 13:14:00 -
[12]
Edited by: arjun1 on 05/02/2010 13:16:31 replaced the exe. works now. after setting up char and pressing the retrieve data button it now loads the data.
the line at the bottom reads: processed personal wallet transaction #xxx for wallet 1000
this repeats itself over and over. counting from 1 to 1000 about 50 times already.
i have couple thousand transactions per day but i thought the api provides only the last 1000?
should i expect the loading to stop or do i need to terminaqte the prog?
|
arjun1
|
Posted - 2010.02.05 14:10:00 -
[13]
i terminated. is there a way to toggle the cells like when i want only to see the totals? after every filter change the full list beciomes visible not only the totals.
|
Riethe
|
Posted - 2010.02.05 14:18:00 -
[14]
You're amazing and I love it.
|
Chick'n Nugget
|
Posted - 2010.02.05 14:37:00 -
[15]
I love this program, BTW. Will download the new version tonight and give it a go.
I do have some suggestions, but I am a programmer so I might just "steal" your source code and try to do it myself. However, I don't have a license for the program (library maybe?) you were talking about so I don't know if I will actually be able to work with it.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.05 15:35:00 -
[16]
Originally by: arjun1 Edited by: arjun1 on 05/02/2010 13:16:31 replaced the exe. works now. after setting up char and pressing the retrieve data button it now loads the data.
the line at the bottom reads: processed personal wallet transaction #xxx for wallet 1000
this repeats itself over and over. counting from 1 to 1000 about 50 times already.
i have couple thousand transactions per day but i thought the api provides only the last 1000?
I have the suspicion that you're machine has a caching problem. That would explain that the download of the first bugfix EXE didn't work as intended and it would also explain that endless loop. Are you using a proxy or something the like? -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.05 15:42:00 -
[17]
Originally by: arjun1 i terminated. is there a way to toggle the cells like when i want only to see the totals? after every filter change the full list beciomes visible not only the totals.
Yeah, this behaviour is "by design" (as an (in)famous software company phrased it). But there's an easy way out: right click on the grid -> select "Collapse all" -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.05 15:51:00 -
[18]
Originally by: Chick'n Nugget
However, I don't have a license for the program (library maybe?) you were talking about so I don't know if I will actually be able to work with it.
If I remember correctly, the two components (VSFlexGrid and Olectra chart) will just throw a nag screen at you, without a license. So, in theory, you should be able to work with it. (Although it's annoying, ofc)
If you wan't to contribute to EWA (which I would welcome), drop me an (oog) email. -- EVEWalletAware - an offline wallet manager |
arjun1
|
Posted - 2010.02.08 18:04:00 -
[19]
it seems correct that the prog takes couuple of minutes to retrieve the data from my apo. in the first 8 days of february i had 54300 transactions. ewa takes some time to pupulate the grid but its doing it. is there a limit to the number of transactions ewa can handle? looks like ill have 200k+ transactions this month alone.
is there a way to remove transactions from the database permanently? when i delete, they return with the next dataretrieval. is there a way to group items like i want like all ship equipment in one group?
|
Faith Marr
|
Posted - 2010.02.09 08:32:00 -
[20]
This program is amazing - A few clicks and I immediately knew which of my products were my most profitable.
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.09 11:34:00 -
[21]
Edited by: Hel O''Ween on 09/02/2010 11:34:06
Originally by: arjun1 is there a limit to the number of transactions ewa can handle? looks like ill have 200k+ transactions this month alone.
No, there is no limit other than what (and how fast) your machine can handle. Depending on the amount of data, it may of course take some time for things to be calculated/displayed/filtered.
Quote:
is there a way to remove transactions from the database permanently? when i delete, they return with the next dataretrieval. is there a way to group items like i want like all ship equipment in one group?
You already pointed out the issue yourself: as long as the records are still part of what you get from the API, a deletion is only temporarily. EWA handles duplicates fine, but doesn't keep track of deleted records. Wait until the API has moved "beyond" those records before deleting them. This will delete them permamently then. -- EVEWalletAware - an offline wallet manager |
Catari Taga
Centre Of Attention Rough Necks
|
Posted - 2010.02.10 16:06:00 -
[22]
Nice update, always loved this tool.
|
Tehg Rhind
|
Posted - 2010.02.11 02:19:00 -
[23]
Edited by: Tehg Rhind on 11/02/2010 02:22:06 Edit: Resolved this issue. From the options tab I was not able to find my character, but in the main window using the account select/char select I was. Anyways, awesome app man, and thank you VERY much for making the db access compatible.
Having a couple of issues
Getting the following error when it tries to access my API "error: -2147221303, EVE API Error: 201 Character does not belong to account."
From what I can tell it can't find my account through the API. When I go to the Character screen I get no options to choose from, when I try to load characters from that screen it throws the above error.
It was set as the default account, and I did use the proper API, and UserID, did it like 3 times and no go.
I was wondering if it was the MDAC thing, went to the link you suggested and it told me that was locked out for windows 7 when I tried, looked into it some more and I already have access on this system so I am ass-u-me-ing I already have that....
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.11 10:21:00 -
[24]
Originally by: Tehg Rhind
Getting the following error when it tries to access my API "error: -2147221303, EVE API Error: 201 Character does not belong to account."
From what I can tell it can't find my account through the API. When I go to the Character screen I get no options to choose from, when I try to load characters from that screen it throws the above error.
Yeah, EWA sometimes goes "rogue" when fiddling with accounts/chars in the options screen. The reason for this is that I try to update the main account/char selection screen while your switching options. If you're using multiple accounts and have selected a different account than the current default one, the chars on the chars tab still reflect the old account. Trying to refresh the main screen with the newly selected account than results in this message. Just ignore it. It basically says: Hel is too stupid to properly do account switching.
If you switched the account in the option screen to download new char data, make sure you set that account as "default" (as you did) and save it. Then switch to the char selection and download the chars for that account.
As for the MDAC: yes, Vista and Win 7 sould come with the required version. Windows 2000 and XP came with an earlier version. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2010.02.13 01:14:00 -
[25]
Hmmm, having another issue. I also installed this on my desktop. Vista 64. Got it to recognize my char/api, updates wallet/isk amount, but throws an error when I try and retrieve data:
"Wallet exhausted, retry after xxxxxxx" and "market orders already downloaded, retry after xxxxxx"
The date is more than 24 hours from now, which surprises me. The only thing I can comment on is that I also had wallet aware open on my laptop at the same time. Closed that but still throw the same error.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.13 10:23:00 -
[26]
Edited by: Hel O''Ween on 13/02/2010 10:23:55
Originally by: Tehg Rhind Edited by: Tehg Rhind on 13/02/2010 01:45:24 Edit: Restarted wallet aware and this went away. Is there a better place for minor bug reports like this? Don't want to pollute your thread (although I guess I am bumping it.
This thread is perfect. This way, my answers might help others with similar issues (yes, sometimes people DO read threads before asking).
Quote:
"Wallet exhausted, retry after xxxxxxx" and "market orders already downloaded, retry after xxxxxx"
The date is more than 24 hours from now, which surprises me.
These messages are taken directly from the API, without modifying them. You're sure it was 24h hours? That's the caching time for assets, not journal or transactions. Also, if you fetched data from the API once for a character with application A, application B querying the same API data from the same IP address gets the "exhausted" message, too. That's how CCP implemented their API caching. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2010.02.14 04:51:00 -
[27]
Getting the "wallet exhausted" message again, also been getting a "character doesn't belong to account" message. The exhausted message gives a delay of 7 hours. Now that I am looking at it though is this a timezone issue? The time I recieve for the error is local time, and the time I recieve for the API caching time is CCP time, is that correct? That could be what's messing me up. New to the world of API calls.
I'm still learning how this thing works, and I really like it. There's a couple things I think could be helpful in a future version if it's not already there :
1) Total Revenue/Expenses vs Time graph. Nothing fancy, just charting those 2 things.
2) The way I view an individual items transaction data could use some other more spreadsheety options. From what I can tell they are automatically put into subgroups based on the purchaser, but if I want to get a feel of volume as a function of date I can't sort it to see that. Not sure how easy that would be to implement. To be honest an option to completely remove the subgrouping and allow people to do tiered sorting (by x then y) would be fantastic.
A seriously I absolutely love this thing, not knocking it, just some thoughts.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.14 10:57:00 -
[28]
Originally by: Tehg Rhind Getting the "wallet exhausted" message again, also been getting a "character doesn't belong to account" message. The exhausted message gives a delay of 7 hours. Now that I am looking at it though is this a timezone issue? The time I recieve for the error is local time, and the time I recieve for the API caching time is CCP time, is that correct? That could be what's messing me up. New to the world of API calls.
In general: <x> exhausted is nothing to worry about. It's a standard API message. I just record it for sake of documentation. Exception: two different programs trying to query the same API data.
As for the TZ "issue". The message shown in the status bar, is directly copy 1:1 from the API and therefore is of course EVE time. However, EWA is fully aware of time zones. When downloading an API file, it takes the cache date/time from it, looks up your local settings, adjusts the date/time and stores that time. Just have a look at Extras -> Cached XML files. The column "Cached until" reflects your local time. Export that XML file, open it in a browser and look for the cachedUntil field in there. Unless you live in EVE's time zone, they will differ.
Quote:
1) Total Revenue/Expenses vs Time graph. Nothing fancy, just charting those 2 things.
More charting is planned. I basically pushed out version 2, to distribute the charting component on which I will build further charting.
Quote:
2) The way I view an individual items transaction data could use some other more spreadsheety options. From what I can tell they are automatically put into subgroups based on the purchaser, but if I want to get a feel of volume as a function of date I can't sort it to see that. Not sure how easy that would be to implement. To be honest an option to completely remove the subgrouping and allow people to do tiered sorting (by x then y) would be fantastic.
Sorting was long a problem, due to the grid's "inner working", but just last week, I figured out a way to allow sorting. Not exactly like you suggested, but it's a start.
Oh, and I don't perceive it as "knocking". Like I've mentioned a couple of times elsewhere: you'd be surprised how many of EWA's features are due to user requests/suggestions. There's a lot of stuff in there I don't even use myself. -- EVEWalletAware - an offline wallet manager |
laksmi2
|
Posted - 2010.02.17 01:17:00 -
[29]
i did 4 times corporation acount withdrawal of the same amount. in the personal journal balance it shows only 1 quarter of the actual sum of those withdrawals. whats up there?
can i somehow make ewa to show the transactions sheet in collapsed mode when i open it? takes longer and longer to populate the grid at 100k + transactions this month already.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.17 10:10:00 -
[30]
Originally by: laksmi2 Edited by: laksmi2 on 17/02/2010 01:28:53 can i somehow make ewa to show the transactions sheet in collapsed mode when i open it? takes longer and longer to populate the grid at 100k + transactions this month already.
No, you can't. And if you could, it wouldn't help you with your issue, because collapsed/expand is only a "virtual" mode. The data (and the filling of it), is there nonetheless.
Quote:
would i need to update the data more often to catch all data?
This is nothing I can tell. Depends on the amount of journal data you produce.
Quote:
can this be automated?
I'm working on it - it's not that I never mentioned it ... *sigh* -- EVEWalletAware - an offline wallet manager |
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.19 11:50:00 -
[31]
Edited by: Hel O''Ween on 19/02/2010 11:50:25 Version 2.0.2 has been released.
This version adds some nice enhancements.
Assets, market orders, wallet journal and transactions may now be sorted in various ways.
A new (seperate) tool is available: Auto data downloader (EWAAutoData). This is an API data grabber, which you may run in the background. It downloads new API data for all your EWA characters. This is a zero installation/configuration tool. Just download the EXE to your EWA installation folder and run it. It shares it's configuration with EWA. EWA itself doesn't need to run, for this tool to work properly.
Version information Download -- EVEWalletAware - an offline wallet manager |
Companion Trollin
|
Posted - 2010.02.19 15:44:00 -
[32]
Quote: Wallet transactions. An additional filter ISK has been added, allowing for filtering on item prices. Please not that the initial filter condition, which is <> 0 (not equal to zero), doesn't actaully filter something, but disables filtering on item prices.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.19 16:17:00 -
[33]
Just to please you, Ma'am. -- EVEWalletAware - an offline wallet manager |
Wiglaf Bane
|
Posted - 2010.02.24 09:01:00 -
[34]
Hello!
I love your program! I mainly use it for asset valuation, but I've run into an odd problem. Asset imports only work about 1/4 of the time, mostly before I've run EVE since booting the machine. Most of the time I'll hit "Import Assets" and it'll just sit there.
I'm running Windows 7 64bit as an admin.
Any thoughts on this?
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.24 10:32:00 -
[35]
Originally by: Wiglaf Bane
I mainly use it for asset valuation, but I've run into an odd problem. Asset imports only work about 1/4 of the time, mostly before I've run EVE since booting the machine. Most of the time I'll hit "Import Assets" and it'll just sit there.
Hmm, not enough information to really tell what's going on.
- Have you checked Extras -> Application log if there are some errors in there related to assets? If you're unsure, export the suspect entries to a text file and send me an email.
- Have you checked Extras -> Cached XML files if there's an asset entry?
- If so, are assets in there (lot's of stuff you can't make sense of) of if it says something like "Expired, Try again at ..."?
An explanation for the last two questions (Hint, it's also explained in the manual): the asset API can only be fetched once every 24 hours. By *one* application (from the same IP address for the same account).
Quote:
I'm running Windows 7 64bit as an admin.
AFAIK, it shouldn't be necessary to run EWA as an admin. XP comp. mode eventually. But other than the installation itself, EWA should not required admin rights, as it doesn't write to any protected folder but keeps everything to "Documents and settings" (W2K/XP) or "User" (Vista/Win7)
As an alternative: if you're just looking for asset management, have also a look at jEveAssets by Golden Gnu. It's specialized on assets and I frankly admit that it does a better job in managing assets than EWA does. -- EVEWalletAware - an offline wallet manager |
clixoras
|
Posted - 2010.02.24 15:28:00 -
[36]
Thx for releasing v2. It installs fine on my w7 x64 and seems to work very smooth. The only thing i'm really missing is a 'pure' profit overview. Correct me if i'm wrong but i can only see a total spent and sold overview. But not total profit for only sold items.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.24 17:13:00 -
[37]
Originally by: clixoras
The only thing i'm really missing is a 'pure' profit overview. Correct me if i'm wrong but i can only see a total spent and sold overview. But not total profit for only sold items.
Sorry, could you rephrase that, as I'm not sure that I understand what exactly you're looking for?
That said, see if "Wallet transactions" -> filter "Transaction type" = "Sell" does what you want. I think you're looking for something like this ... -- EVEWalletAware - an offline wallet manager |
Magnu Stormhawk
Stormhawk Enterprises
|
Posted - 2010.02.24 17:34:00 -
[38]
Originally by: clixoras Thx for releasing v2. It installs fine on my w7 x64 and seems to work very smooth. The only thing i'm really missing is a 'pure' profit overview. Correct me if i'm wrong but i can only see a total spent and sold overview. But not total profit for only sold items.
I don't believe this information is available within the program. You can look at particular items and see total sales and total purchases, but it does not take into account unsold items, so it is only useful if you have sold out of them and have not bought any more.
I would love to know if i'm wrong, or if there is a program that actually has a go at calculating this. The problem with it is that you can only work it out if you have a cost value for each item, and the average cost value for each item changes every time you buy another one.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.25 12:25:00 -
[39]
Originally by: Magnu Stormhawk
I don't believe this information is available within the program. You can look at particular items and see total sales and total purchases, but it does not take into account unsold items, so it is only useful if you have sold out of them and have not bought any more.
I would love to know if i'm wrong, or if there is a program that actually has a go at calculating this. The problem with it is that you can only work it out if you have a cost value for each item, and the average cost value for each item changes every time you buy another one.
Ah, now I understand (I think). You (OP) want to know the profit of items you bought and then sold, disregarding those that you bought but are still listed as a sell order/sit in your hangar.
No, EWA doesn't do that. I know that EMMA tries to estimate this. But there's no real way to tell, as the API doesn't track items/match purchases to sales.
Say, you bought 100x Item A for 100,000 ISK and 50x Item A for 105,000 ISK. You than sell 50x Item A for 150,000 ISK. Were those 50 sales from the batch of 100 you bought at 100,000 or from that 50 batch at 105,000 ISK? Or 34 from the 105,000 ISK pile and 16 from the 100,000 ISK stock. Or .... <lots of combinations>.
I *think* EMMA does this on a FIFO basis. But it's only a guess. -- EVEWalletAware - an offline wallet manager |
Beauty III
|
Posted - 2010.02.25 19:26:00 -
[40]
Any chance I can set this up on a portable device? (Put ini in application folder?)
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.02.25 20:00:00 -
[41]
Short answer: somewhat ...
Long answer: you could set it up to run from a portable device, given you register the necessary components the first time you run it on a new PC. But as of now, EWA will nonetheless expect the INI to be in All users\AppData and will alway write some text logs to there.
The easiest way to make EWA "portable" is to install it on each machine, than copy the database to the portable device and edit the INI to reflect its location. -- EVEWalletAware - an offline wallet manager |
William Warestrader
|
Posted - 2010.03.01 11:42:00 -
[42]
Edited by: William Warestrader on 01/03/2010 11:42:23 Posted this on the other thread before I realized you had rolled out 2.x I updated and still am getting the same results so I'm posting the message here.... --------------------
Hey, can we get the math fixed on this thing? I absolutely love this program but It sure would be a lot more useful if it returned accurate calculations. I checked the wallet in game and it's got the right answer so I'm left assuming it's a calculation mistake in the program. See what you think.
1,714,285 * 379.24 = 650,125,443.40 NOT 637,122,934.53 2,721,944 * 377.70 = 1,028,078,248.80 NOT 1,007,516,683.82
I'll let you check the math on the rest. This was very frustrating to find since I do double entry accounting in GnuCash on my corp in order to keep track of profit loss information. I thought the mistakes were mine... Teach me to trust other apps :)
Great program though mate, thanks for providing it, but really would like to see a quick fix roll out for this.
Thanks.
|
Magnu Stormhawk
Stormhawk Enterprises
|
Posted - 2010.03.01 11:50:00 -
[43]
Have you got tax and broker fee estimations checked in the options? Looks like the values it is calculating for the total reciept is around 2% less than the price x volume, which would equate to the costs of a sale for a char with no trade sills trained.
|
William Warestrader
|
Posted - 2010.03.01 12:56:00 -
[44]
Edited by: William Warestrader on 01/03/2010 12:58:13
Originally by: Magnu Stormhawk Have you got tax and broker fee estimations checked in the options? Looks like the values it is calculating for the total reciept is around 2% less than the price x volume, which would equate to the costs of a sale for a char with no trade sills trained.
Problem solved and I feel like an idiot.
Thank you very much for the pointer... I'd think that option would be better left unchecked by default, but developer choice. :)
Again great app... Thanks for your help Magnu
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.01 15:06:00 -
[45]
Originally by: William Warestrader
I'd think that option would be better left unchecked by default, but developer choice. :)
It is unchecked by default. You maybe tinkered with that before and forgot to reset it later? -- EVEWalletAware - an offline wallet manager |
Wendelgard
Gallente The Scope
|
Posted - 2010.03.02 18:35:00 -
[46]
I hope you do not mind if I post my ideas here:
Generally spoken, EWA is a great tool although the interface may look dowdy. Anyway, in the assets window I am missing the following topics: - the group filter could be changed so that the user is able to filter by blueprints in general, ore, minerals ammo etc. in general. - It is correct of you including assets that have a value of ISK 0.00. By doing so you should be honest to all items. In my assets list I am misising the listing of them. Apropos: Is there any way to determine the worth a charakter? I am not thinking of the time required to train the know skills. I am basically thinking of the spent amount to buy the skill books and the the currently used implants. - I noticed the captions of the colums are clickable but without any effect. Is it planned when the user clicks on one caption that assets are sorted by that column?
I appreciate that EWA has the capability to export the assets to Excel. Generally, I think there is no need to reproduce the Excel dump in the exact way it looks as in EWA. When using Excel, please be aware that people want to work with the figures. Or, in other words, for them it is important that the spreadsheet is clearly readable.
In the Excel dump, may I hint you using an extra column summing up the subtotals ? This would make it easilier to use formulas.
As far I heard, you, the author, as well as the later user may not worry about the localized versions of Excel regarding the name of functions.
I hope I gave you some input to think about
Best regards,
Wendelgard
|
William Warestrader
|
Posted - 2010.03.03 16:13:00 -
[47]
Originally by: Hel O'Ween
Originally by: William Warestrader
I'd think that option would be better left unchecked by default, but developer choice. :)
It is unchecked by default. You maybe tinkered with that before and forgot to reset it later?
I didn't think so, but with my lack of sleep and overactive life it's highly likely I tinkered with something and don't remember it. Either way, all fixed up and thanks for the app and the support. :)
|
William Warestrader
|
Posted - 2010.03.03 16:18:00 -
[48]
Originally by: Wendelgard I hope you do not mind if I post my ideas here:
Generally spoken, EWA is a great tool although the interface may look dowdy. Anyway, in the assets window I am missing the following topics: - the group filter could be changed so that the user is able to filter by blueprints in general, ore, minerals ammo etc. in general. - It is correct of you including assets that have a value of ISK 0.00. By doing so you should be honest to all items. In my assets list I am misising the listing of them. Apropos: Is there any way to determine the worth a charakter? I am not thinking of the time required to train the know skills. I am basically thinking of the spent amount to buy the skill books and the the currently used implants. - I noticed the captions of the colums are clickable but without any effect. Is it planned when the user clicks on one caption that assets are sorted by that column?
I appreciate that EWA has the capability to export the assets to Excel. Generally, I think there is no need to reproduce the Excel dump in the exact way it looks as in EWA. When using Excel, please be aware that people want to work with the figures. Or, in other words, for them it is important that the spreadsheet is clearly readable.
In the Excel dump, may I hint you using an extra column summing up the subtotals ? This would make it easilier to use formulas.
As far I heard, you, the author, as well as the later user may not worry about the localized versions of Excel regarding the name of functions.
I hope I gave you some input to think about
Best regards,
Wendelgard
I'll add to this group of suggestions:
I have a small little application I wrote that I use for manual inventory purposes. in it I included the ability to call the api and calculate out how many hours each user spent using slots in the pos or for the corporation. I'd love to see EWA add that functionality in. Your current setup would allow you to easily do more with the data than I'm able to atm. I pay all my corp members by the hour for any invention/copy/manufacturing/ml work they do on the corporations behalf. If EWA could add in the ability to return the hours for each persons work for each type of work for a given period that would be sweet. If we could assign a dolor value to those hours based on the type of work that would be even better!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.05 12:17:00 -
[49]
I'm afraid I need to disappoint you, guys.
Before answering in detail, let me try to explain EWA's philosophy:
- EWA is a trading tool. I leave character management (and evaluation) to EVEMon and the like. I leave production management to EveHQ and the like. I leave POS management to MyPOS and the like. EWA is no corp management tool. I leave that to <don't know an app>. Besides that: I have no personal experience in the above realms.
- No manual input! EWA was built with the goal in mind, that no user should ever manually add data (except your API key(s)), because it's a nightmare to manage.
Now on to your suggestions.
Quote:
- the group filter could be changed so that the user is able to filter by blueprints in general, ore, minerals ammo etc. in general.
These groups are CCP's groups (invGroups) taken from the data dump. I might add market groups (which are a different beast than those groups) as a filter sometime.
Quote:
- It is correct of you including assets that have a value of ISK 0.00. By doing so you should be honest to all items. In my assets list I am misising the listing of them.
I'm still struggling with assets. The problem is the location of assets. Items in POS' and in space might still be missing.
Quote:
- I noticed the captions of the colums are clickable but without any effect. Is it planned when the user clicks on one caption that assets are sorted by that column?
They do (most of them), since the last release (2.0.2). RTFM! http://eve.basicaware.de/EVEWalletAware/version.html. It's also in the manual.
Quote:
Excel stuff
The Excel stuff is a option of the grid, nothing I coded. Therefore I can't influence anything there. Sorry, mate.
@William: I'm not going to turn EWA into a POS/corp management tool. Have you had a look at EveHQ? You/someone might be able to write a plugin for EveHQ. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.10 12:22:00 -
[50]
Version 2.0.3 has been released.
This version adds a new feature called "Quick briefing" (in lack of a better term ) to EWA
Version information Download -- EVEWalletAware - an offline wallet manager |
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.11 17:46:00 -
[51]
I've just uploaded a new version (1.0.2) of the Auto data downloader, which fixes an ugly bug with the downloader. Wallet journal & transaction would not correctly be assigned to the right character(s).
I strongly recomment that you don't use prior versions anymore. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2010.03.18 02:36:00 -
[52]
could you be more specific?
In my case I just use EWA to grab the database files and link them to my own database. This is only for a single character. Would this be affecting me? If so how? Also, if I do update will it change/maintain the way the historical data in the EWA database?
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.18 11:54:00 -
[53]
Edited by: Hel O''Ween on 18/03/2010 11:56:40
Originally by: Tehg Rhind
In my case I just use EWA to grab the database files and link them to my own database. This is only for a single character. Would this be affecting me?
No, you're not affected then. The bug only appeared in the Auto downloader. If you never used it, all's fine.
Long story short: The Auto downloader didn't switch accounts/chars properly, when iterating through the database. Therefore it sometimes marked entries with a characterID of 0 and therefore unassociated to any present account/character (=didn't show up anywhere in EWA although present in the DB).
Originally by: Tehg Rhind
Also, if I do update will it change/maintain the way the historical data in the EWA database?
EWA always maintained historical data with any of its updates since its invention. Luckily I had this in mind ever since the first version and took care for that right from the beginning.
If you're going to upgrade from v1 to v2, make sure your'e using the updater on the download page, not the full v2 install and not the EXE only. The updater adds the necessary new components and patches the database accordingly. -- EVEWalletAware - an offline wallet manager |
Ben Siegel
|
Posted - 2010.03.29 01:58:00 -
[54]
First of all, absolutely love the program. Thanks for all your hard work.
I'm sure this is something I'm screwing up, but it looks like not all the corporation wallet journal entries are loading. I set the filter to Corporation Account Withdrawal, Date from 1/1/2010 to 3/28/2010 and it pulls up 15 journal entires (of which there are many more). It has 13 entries in the last 10 days (back to 3/18) and then nothing until 1/17 and 1/22.
Thanks in advance for any help you can provide, Ben Siegel
|
arjarj
|
Posted - 2010.03.29 08:54:00 -
[55]
auto data keeps updating even when i tell it to pause. can the number of times update happens be limited. once every minute or two seems excessive
|
Companion Trollin
You are going too fast
|
Posted - 2010.03.29 11:08:00 -
[56]
Originally by: Ben Siegel First of all, absolutely love the program. Thanks for all your hard work.
I'm sure this is something I'm screwing up, but it looks like not all the corporation wallet journal entries are loading. I set the filter to Corporation Account Withdrawal, Date from 1/1/2010 to 3/28/2010 and it pulls up 15 journal entires (of which there are many more). It has 13 entries in the last 10 days (back to 3/18) and then nothing until 1/17 and 1/22.
Thanks in advance for any help you can provide, Ben Siegel
We're sorry to report that the majority of your withdrawals over the last couple of months were for "13 year-old choir boys" and "vulnerable 12 year old girls." As such, law requires us to contact the parents of said minors before we're able to wipe these public records. If we can be of further assistance please let us know.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.29 14:37:00 -
[57]
@Ben: Try Extras -> Database maintenance -> Compact database. If that doesn't help, please send me an email to [email protected]. I might need some logs to find out where the problem is.
@arjarj: It doesn't actually update that often. It just checks if an update is necessary. In an ideal world, it would know when to update what, but to get an updater out fast, I took this lazy approach. But reducing the number of checks is on my list.
@Companion: -- EVEWalletAware - an offline wallet manager |
arjarj
|
Posted - 2010.03.30 08:24:00 -
[58]
under wallet/quick briefing the graph of the sales is 2 days behind the graph of the purchases. so i see 2 days with only the purchases graph.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.30 11:27:00 -
[59]
Originally by: arjarj
under wallet/quick briefing the graph of the sales is 2 days behind the graph of the purchases. so i see 2 days with only the purchases graph.
We have two issues here. Not sure which one applies to you:
The currently released version has a bug where the graph could actually "march backwards". Hard to describe for me, if it happened to you, you'll know what I mean. I've fixed that already internally, but haven't published a new version, as I'm in the middle of adding other things (teaser: a bit more graphing in the Quick briefing), which I would like to include in the next update.
You might also experience a behaviour that's by design. The graph shows the last <x> days. If you haven't got any buys within the last two days, well, no graph for this. Whereas the sales will be plotted for those two days.
Quote:
mhe autoupdater should stop checking for new data when i hit the pause button right? it doesnt
Sorry, forgot to answer to that part. Of course, it should stop. I'll look into it. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.30 13:53:00 -
[60]
A new version (1.0.3) of the auto updater has been release.
This one does now pause if you tell it to do so.
I've also extended the pause between update checks to 15 minutes (default). If you wish to change that period, open EWA's INI (see ? -> Show locations to find where your INI is).
Edit/add the following part of/to the INI:
[EWAAutoData] ; Auto updater options ; Pause at least for <x> minutes before checking for expired caches/API updates QueryPause=15
-- EVEWalletAware - an offline wallet manager |
|
arjarj
|
Posted - 2010.03.30 15:02:00 -
[61]
i think i know i found why the graphic behaves as it does in my case.
there were buys on all days from 23.03 til 30.03 but on 23. and 24. there werre no sales. looks like the graph doesnt recognise that the sales volume should be zero but instead procedes to fill in the first data with sales (25th in this case) for the 23th
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.03.31 14:09:00 -
[62]
A new version (2.0.4) has been released.
This version expands the Quick briefing functionality. I've also added the possibility to mark grid cell(s) and copy their contents to the clipboard.
As always, see the version history for a complete list of changes. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.01 08:44:00 -
[63]
I received your mail with the logs, Ben. Thanks for sending.
Originally by: Ben Siegel
I'm sure this is something I'm screwing up, but it looks like not all the corporation wallet journal entries are loading. [...]
Thanks in advance for any help you can provide
I'm afraid I only can provide an explanation, not a real solution. The logs show ("invalid beforeRefID provided") that you're hit by a bug CCP introduced in wallet journal API with Dominion. While they fixed this one for personal wallet journals, corporation API still is bugged.
See this thread over in the Tech Lab forum, where this is discussed. Quote from there:
Quote:
I haven't hear anything back on my bug report but in their reply they did say they were aware and mine was being added to the existing one so probably not going to help at this point making another one. They didn't say when it would be fixed in the reply either but at this point since it's existed through a couple minor bug fix releases I hate to say it but looks like we're not get a fix until next major release
-- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.01 14:00:00 -
[64]
Bugfix released: v2.0.5
v2.0.4 containes an error which makes it impossible to edit an existing EWA account. This new version also corrects the behavior of the "Top buy/sell" charts if there are no records present.
I apologize for the inconvenience. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.16 10:34:00 -
[65]
Version 2.0.6 has been released, along with a database update (15).
This version adds a new feature I called "Virtual Character" (VC) to EWA. You combine two or more of your existing (real) charaters into a virtual character. This VC will then act as an "on-the-fly-total" of the combined chars.
In order for this to work, you need to apply both the appliaction and the database update.
Virtual characters can be created/edited via menu Extras -> Virtual character.
As always, see the version history for the changes in this version. -- EVEWalletAware - an offline wallet manager |
wexslak
|
Posted - 2010.04.17 23:25:00 -
[66]
hi, can't add char >> Error: -2147220988, EVE API Error: 516, Failed getting user information. i have win 7 64bit
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.18 08:47:00 -
[67]
Edited by: Hel O''Ween on 18/04/2010 08:46:52
Originally by: wexslak hi, can't add char >> Error: -2147220988, EVE API Error: 516, Failed getting user information. i have win 7 64bit
This an error reported by the EVE API server. So, EWA is able to connect to the server (=no technical connection problems there), but the API server can't serve the characters for your account, for reasons only CCP knows.
Is your account by any chance a pretty new account? I seem to remember that you can't immediately use the API with a new character.
Also, make sure you're creating an (EWA) account first, entering your Full API key for that account, save it and mark the account you want to retrieve the characters for as the default account. -- EVEWalletAware - an offline wallet manager |
Killapodicus
|
Posted - 2010.04.18 09:24:00 -
[68]
Edited by: Killapodicus on 18/04/2010 09:28:35 what is the issue when EWA says I have no wallet transactions? I've entered the strong API etc.
It shows char info and wallet total ISK no problems.
I switched my trade char to an old account last night. Initially it didn't work on that account's API but after a few hours the API pulls info to EVEMON for example including completed orders.
It just doesn't seem to pull transactions into EWA.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.18 09:47:00 -
[69]
Did you download your wallet data with another application (from the same location/IP address)? If so, you've got bitten by CCP's API caching.
If not, have a look at Extras -> Application log, if there's an error. -- EVEWalletAware - an offline wallet manager |
Lim Lim
|
Posted - 2010.04.18 10:21:00 -
[70]
Edited by: Lim Lim on 18/04/2010 10:21:25
Originally by: Hel O'Ween Did you download your wallet data with another application (from the same location/IP address)? If so, you've got bitten by CCP's API caching.
If not, have a look at Extras -> Application log, if there's an error.
Hey, I think that might be it. EVEMON tracks my trades and I tested a few other trade apps yesterday -- none of them pulled any transactions -_-
How do I resolve this caching issue? The logs show no errors apart from the usual noob corp trade roles.
PS - meh wrong character...
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.18 13:22:00 -
[71]
Either use an EVE API proxy (hop over to the Tech Lab forum, there you'll find those advertised) or use one application for one task.
if you're able to change your external IP address, the caching is per account and IP address.
Other than that, there's no way around CCP's caching. -- EVEWalletAware - an offline wallet manager |
Flitterby
|
Posted - 2010.04.21 15:34:00 -
[72]
Hello,
First, you should probably update your thread link on your contact page, as it points to an old thread
I just downloaded and installed EveWalletAware for the first time. I believe that I have followed the instructions for inputting my API and marking a default account. However, when I go to the character tab and push the "Retrieve characters from EVE API" button, I get an error. According to the Application Log, the error is:
"Error: -2147012889, EVE API Error: 0, The server name or address could not be resolved, "
EveWalletAware cannot retrieve my characters.
EveHQ works just fine on the same system.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.21 16:15:00 -
[73]
Originally by: Flitterby
First, you should probably update your thread link on your contact page, as it points to an old thread
Thanks a lot for pointing that out. Already fixed.
Quote:
"Error: -2147012889, EVE API Error: 0, The server name or address could not be resolved, "
EveHQ works just fine on the same system.
Hmm, strange. Are you connecting through a proxy? If so, you need to configure EWA for using a proxy (menu Extras -> Options, tab "Proxy server").
If not, is perhaps your firewall or virus scanner (or something like that) blocking EWA from accessing CCP's API server? -- EVEWalletAware - an offline wallet manager |
Flitterby
|
Posted - 2010.04.21 17:34:00 -
[74]
I'm not trying to use a proxy, but there may be one here at work. However, EveHQ works on the default settings without having to enter any proxy information.
If you don't have any more suggestions, I'll try the software from my home computer this evening.
|
Companion Qube
|
Posted - 2010.04.22 01:52:00 -
[75]
Originally by: Hel O'Ween Version 2.0.6 has been released, along with a database update (15).
This version adds a new feature I called "Virtual Character" (VC) to EWA. You combine two or more of your existing (real) charaters into a virtual character. This VC will then act as an "on-the-fly-total" of the combined chars.
In order for this to work, you need to apply both the appliaction and the database update.
Virtual characters can be created/edited via menu Extras -> Virtual character.
As always, see the version history for the changes in this version.
This is kind of ridiculous, I was going to post and ask for the functional equivalent of this today. Get out of my head
Also, thanks
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.22 10:15:00 -
[76]
Originally by: Flitterby I'm not trying to use a proxy, but there may be one here at work. However, EveHQ works on the default settings without having to enter any proxy information.
I haven't looked at EveHQ in a long time. Not sure if it does use calls to the EVE API ... but I guess it has, at least for getting character information.
Quote:
If you don't have any more suggestions, I'll try the software from my home computer this evening.
Well, we could make sure that your config hasn't become corrupted. Go to ? -> Show locations. There's an entry "Configuration file used" (points to EWA's INI file). Open that file in a text editor. Search for "EVEApiBaseURL=", located in the section [EVEApi]. The value for "EVEApiBaseURL" should be http://api.eve-online.com.
I can only guess that perhaps EveHQ automagically uses IE's proxy settings and therefore does work, whereas EWA needs to be configured for using a proxy. I mean, it's pretty easy: open your browser and check if it's configured to use a proxy. If so, configure EWA to use the same. The queries EWA makes are standard HTTP calls on port 80 using MS' MSXML library, nothing fancy there. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.22 10:21:00 -
[77]
Originally by: Companion Qube
This is kind of ridiculous, I was going to post and ask for the functional equivalent of this today. Get out of my head
I've mentioned this before, perhaps that's how I made it into your head:
Quote:
Again, I wouldn't do that, but have a new feature in mind, which would must likely solve your problem: letting the user create a "virtual character". You than assign existing chars to that virtual character, making him the "sum" of those characters.
Quote:
edit: one question, do virtual characters show personal as well as corp transactions in one place?
No. They exactly behave like a real char. A VC either refers to the (sum of) the personal wallets of all related chars or the (sum of) corp wallets of all related chars. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.04.23 19:20:00 -
[78]
Edited by: Companion Qube on 23/04/2010 19:26:35 Just found a simple bug with the quick briefing's chart - if you have a day with no buy/sell activity (none at all) instead of charting a zero the chart component ignores the point entirely and shifts later data-points one day to the left.
http://img406.imageshack.us/img406/2949/chart01.jpg
Note the empty sales value on 4-18 - this causes the sell graph to ignore that day and shift all futher points one to the left.
http://img153.imageshack.us/img153/509/chart02.jpg
This is more obvious, it's kind of funny once you figure out what you're looking at.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.23 20:51:00 -
[79]
Uups, good catch!
Thanks for reporting. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2010.04.23 21:59:00 -
[80]
I just wanted to say how good your app is and how much I appreciate it. I started using it just as a way to update my personal database, but as time goes on and you expand your functionality I am starting to use my own database less and less. After the tyrannis changes I may completely retire my database.
A thought. Some items are bought, not to be resold, but either to melt down or to value add through industry. Do you have any intentions to add functionality to work better with those features? I'm not sure how hard it would be, but here's my thoughts on how it could work (without making a full fledged industrial app). Items could be identified by the user as being either input or output, and after subtracting out any surplus that might be resold you could group them as such in a balance sheet.
You could have the user define subgroups as well. Like say minerals vs ships/modules and salvage goods vs rigs. Leave the worrying about blueprint quantities to the user. They could theorhetically get very fine details based on their subgroups (like armor rigs) but that would be up to them.
Or just what i said at first, 2 large groups (input and output). I know some of the industrial apps do this better, but their financial tools are simply terrible.
|
|
Companion Qube
|
Posted - 2010.04.23 22:24:00 -
[81]
Originally by: Tehg Rhind I just wanted to say how good your app is and how much I appreciate it. I started using it just as a way to update my personal database, but as time goes on and you expand your functionality I am starting to use my own database less and less. After the tyrannis changes I may completely retire my database.
A thought. Some items are bought, not to be resold, but either to melt down or to value add through industry. Do you have any intentions to add functionality to work better with those features? I'm not sure how hard it would be, but here's my thoughts on how it could work (without making a full fledged industrial app). Items could be identified by the user as being either input or output, and after subtracting out any surplus that might be resold you could group them as such in a balance sheet.
You could have the user define subgroups as well. Like say minerals vs ships/modules and salvage goods vs rigs. Leave the worrying about blueprint quantities to the user. They could theorhetically get very fine details based on their subgroups (like armor rigs) but that would be up to them.
Or just what i said at first, 2 large groups (input and output). I know some of the industrial apps do this better, but their financial tools are simply terrible.
|
Companion Qube
|
Posted - 2010.04.24 02:36:00 -
[82]
Hmm, I have a feature request, I'd like to see a third option in addition to "Corp Data" and "Personal Data." Something along the lines of "All Data" - a combination of corp and personal. I'm willing to start a bounty pool if the feature interests you, I've been using EWA long enough that I should probably send you some isk anyway.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.24 09:04:00 -
[83]
Edited by: Hel O''Ween on 24/04/2010 09:05:06 @Tehg:
Let me start with saying thank you very much for your kind words. Although my main philosophy with EWA is "no user input", letting a user create "input/output groups" (in lack of a better name) wouldn't interfere with the API data. I can see where you're coming from, as a producer and I can also see the added value of such a user grouping for other business purposes, if that grouping would be flexible enough. I won't promise to add something like this at this point. But I can promise you that I will at least have a look.
@Companion:
My first impression is: this sounds like it could easily be done. But the devil is in the details (does this make sense in English? It's a German proverb ...), so let me have a look at it first. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.04.24 10:45:00 -
[84]
Originally by: Hel O'Ween @Companion:
My first impression is: this sounds like it could easily be done. But the devil is in the details (does this make sense in English? It's a German proverb ...), so let me have a look at it first.
Totally reasonable, I've done enough software development and technical work to know this too well.
Originally by: Hel O'Ween Oh, and no "bounty" required. I do accept donations, of course. But I never added something because someone paid for it and I don't intend to do so. This keeps me independent to take EWA the way I want, without the need to carry that paid for feature around although it might be outdated or just a PITA to maintain.
You can't blame me for trying to bribe you
|
C Melindy
Canucks Hockey Stick Research and Development
|
Posted - 2010.04.26 04:30:00 -
[85]
first off, i would like to say that I really enjoy using this program. It shows me alot of info, as well as easy to use. But one question is, in the quick briefing, what is the difference between Wallet Transaction and Wallet Journal.
|
Companion Qube
|
Posted - 2010.04.26 07:59:00 -
[86]
Originally by: C Melindy first off, i would like to say that I really enjoy using this program. It shows me alot of info, as well as easy to use. But one question is, in the quick briefing, what is the difference between Wallet Transaction and Wallet Journal.
Transactions show you what you've bought and sold, at face value - they don't show losses due to taxes and fees.
The journal shows all wallet in/out data, but in no greater detail than "market escrow authorized" or "xxx bought from yyy."
tl;dr- the journal shows all in/out data including taxes, fees, insurance, bounties, rent, etc. while the wallet only shows buy and sell data.
|
Enthalpica
|
Posted - 2010.04.26 20:38:00 -
[87]
Hi, I would like to send a big Thanks your way. Your program is great! I have one question, how long does it typically take to update my Wallet Transactions?
I am using Wallet Aware for example to track certain transactions that I make for another account of mine, but sometimes the recent orders wont show up in the program. Is there a set time delay between the actual in-game transaction until it shows up, or does it depend on other things. Can I manually update/fetch the data to speed up the process?
again, thanks for your effort, its a great app!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.04.26 21:52:00 -
[88]
Edited by: Hel O''Ween on 26/04/2010 21:52:28 There are two factors which play a role here:
1) API cache. Each API type (wallet transactions, market orders etc.) has it's own caching timer. You query it. CCP sets a timer. You won't get new data from the API server until that cache has expired. The expiration time is delivered along with the data and EWA recognizes those and won't query for new data until then. Under Extras -> Cached XML files you'll see a column "Cached until". That's how long you can't make a call to that API type for that account.
2) Delay between TQ and API server. I've never measured myself nor did I read how long it takes before data is "moved" from TQ to the API server. I know there is a delay but don't know how long it is and if it's identical for all API calls. -- EVEWalletAware - an offline wallet manager |
Enthalpica
|
Posted - 2010.04.26 22:00:00 -
[89]
That explains it. Thanks! :D
|
DocSniper
|
Posted - 2010.05.26 19:36:00 -
[90]
First off, great tool and thank you for taking the time in providing us with something like this.
Now on to my question. I've downloaded, installed, and added a character just fine with WalletAware. But, for some reason I can't seem to find the Corporate Wallet JOURNAL anywhere?
It's nice being able to see transactions and all, but having recently seen a decrease in our corporate funds, I'm trying to use Excel to check all the divisions/tabs such as the Master tab and see who is taking funds and who is replenishing funds. Since EVE doesn't provide an easy way to view that information, I thought WalletAware had that capability, but... I can't seem to find a Corporate Wallet Journal anywhere?
I basically just want to take ALL the journal info and do a simple SUMIF function and see who has a negative or positive balance.
Is the corporate journal a feature that's not available with WalletAware? Is it something CCP does not allow? Bug? |
|
Vultirnus
Amarr T.C.R.I
|
Posted - 2010.05.26 20:47:00 -
[91]
I'm having problems getting the character profile to load. I'm not getting any errors, it just doesn't pull up any characters with the API information I've entered (and I've triple checked them!).
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.05.26 23:55:00 -
[92]
Edited by: Hel O''Ween on 27/05/2010 00:01:58 Confirmed.
Not sure what the cause is yet, as I'm not at my development machine now. The API does return a character sheet (you can verify that by looking at Extras -> Cached XML files. Search for an entry called "Other/Unknown").
Perhaps CCP changed the layout of the XML.
Will look into it tomorrow.
[Added] I found an old char XML. They look identical. So I obviously managed to introduce a bug there somehow. -- EVEWalletAware - an offline wallet manager |
DocSniper
|
Posted - 2010.05.27 03:01:00 -
[93]
Any suggestions to my post on the 3rd page, last reply?
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.05.27 10:00:00 -
[94]
Originally by: DocSniper Any suggestions to my post on the 3rd page, last reply?
I'm sorry, missed that one.
This is/was a bug in the API, introduced with Dominion. It affected the personal wallet journal, too. But CCP fixed that shortly after. Unfortunately they did let the corp wallet journal sit buggy 'til Tyrannis, which should fix this one, too.
See http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1254492 -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.05.27 12:12:00 -
[95]
EWA's database update (version 16) for Tyrannis has been released.
I've also released a new version of the appliaction itself (version 2.0.7), which fixes two small bugs.
See the version history for details. -- EVEWalletAware - an offline wallet manager |
Grr Vandeminax
|
Posted - 2010.05.30 17:00:00 -
[96]
I have to retrieve data for 8-10 different chars - 1 including the corp data.
Doing this manually is a bit of a pain. Is there any way to automate this? I read about it somewhere, but can't find the info again.
btw. getting the data needed without EWA would be a much, much bigger pain. Thx a lot for this great program!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.05.31 09:00:00 -
[97]
You could try the Autdownloader, linked from the Downloads page.
But I have the suspicion it's not working correctly. I haven't had much time lately to look into it.
I'm afraid the safest way for now is doing it in the traditional way. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.06.19 09:21:00 -
[98]
Version 2.0.8 has been released.
This minor release fixes a small bug and adds a few small enhancements.
See the version history for details. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.03 19:22:00 -
[99]
Just a quick note to let you know that I'm (or my hosting service, to be precises) currently having difficulties with the web server where I host EWA.
This also affects EWA's built in update check, as the updates are hosted on the same server/subdomain. Which isn't much of a problem, as there's currently no new version available
I'll let you know, as soon as the server is up and running again. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.04 11:06:00 -
[100]
Issue resolved, website is up and running again. -- EVEWalletAware - an offline wallet manager |
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.12 09:50:00 -
[101]
Version 2.0.9 has been released.
It fixes a bug (export to Excel didn't work anymore) and adds two small enhancments.
See the version history for details. -- EVEWalletAware - an offline wallet manager |
Mythrantar
Caldari Darkwave Technologies Blade.
|
Posted - 2010.07.20 01:32:00 -
[102]
Hello!
I have been using this fantastic program for a long time now, however after upgrading to version 2 the show "wallet transactions" functionality causes the program to crash. I have tried upgrading and reinstalling it (after backing up my database) and the problem persists. The error message is the following:
"Run-time error '5': Invalid procedure call or argument"
Any ideas? Thanks!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.20 09:45:00 -
[103]
Originally by: Mythrantar
"Run-time error '5': Invalid procedure call or argument"
Any ideas? Thanks!
I'm pretty sure that some fields are missing in the table. May I ask how you upgraded? Did you use the upgrade installer I provide? Or did you just download the new EXE?
Please send me an email to [email protected] with the answers, if you don't mind. We may need to discuss some further steps in order to get you up to the current version, which is better suited for a private conversation. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.21 16:05:00 -
[104]
Originally by: Mythrantar
"Run-time error '5': Invalid procedure call or argument"
As this might affect other users, I'll post the cause/solution here, too. The problem was caused by huge number entered in the Options, tab "Wallet/Assets" under "Show transactions/journals for last number of days".
A bad design decision (small text box which only showed four of the actual eight figures in there) on my part made that one a bit difficult to spot for both the user and me. Add to this that I haven't done any sanity check on the amount of days put in there = Mayhem!
I'll add a fix for this in the next release. Until then, just make sure you put a sane number of days in there. Roughly 240k years was a bit overkill. -- EVEWalletAware - an offline wallet manager |
Mythrantar
Caldari Darkwave Technologies Blade.
|
Posted - 2010.07.21 17:04:00 -
[105]
Originally by: Hel O'Ween Roughly 240k years was a bit overkill.
What? I thought EVE was for eternity!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.23 11:45:00 -
[106]
Version 2.0.10 has been released.
It fixes two bugs (the one mentioned above and another one with the Quick briefing) and adds a few small enhancements.
I've also updated the online manual to reflect the recent additions/changes (i.e. Virtual Characters). The manual is also available as a separate download.
See the version history for details. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.07.23 21:21:00 -
[107]
Hey Hel,
I remember you mentioned something about the auto-downloader having issues - is it usable again? If it's not I have a feature request, a "download all" button or something similar so we can one-click grab data from all of our accounts.
CQ
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.26 09:47:00 -
[108]
Hi CQ,
after a long time not doing so, I just had fresh look at EWAAutoData and I think I've spotted (all of) the problem(s).
It never ceases to amaze me, what an off time does to bug hunting. I've spent days figuring out what's going one, the last time, but didn't see anything. You know, that forest -> tree syndrome.
I haven't uploaded a new version yet, let me do some testing first. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.07.27 10:45:00 -
[109]
I've uploaded the new version (1.0.4) of the auto downloader. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.07.29 23:49:00 -
[110]
Great news, thanks a lot
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.04 10:16:00 -
[111]
While I was at it, I enhanced the autodownloader a bit further.
- Added basic wallet information for each character, so that you can see the totals of each wallet.
- It now also updates item prices from EVE Central and EVE Metrics for asset evaluation. It does so once per hour.
Version 1.0.5 has been uploaded. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.06 10:18:00 -
[112]
Well, it's update time again. Version 2.0.11 has been released.
This is mainly a small enhancement/maintenance release to bring the released EWA version in line with the EWAAutoData, as they share the same code basis.
There's a small feature addition, which can be found in the Item details window.
As always, see the version history for details. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.13 11:58:00 -
[113]
I've just uploaded a new database update (database version 17).
There have been changes between Tyrannis 1.0 and Tyrannis 1.0.1 in CCP's database dump that I wasn't aware of. From the description I assumed that the 1.0.1 changes wouldn't affect EWA. Obviously I was wrong.
I found this out, because a user reported the problem of PI products not showing up in his transactions.
Please use EWA's update option (? -> Check for update) to update your installation to the latest database release. -- EVEWalletAware - an offline wallet manager |
Wendelgard
Gallente Herrscher der Zeit United Front Alliance
|
Posted - 2010.08.15 11:16:00 -
[114]
Hel O'Ween, I am having a problem: I have set up a spreadsheet to have an overview how much minerals I need to farm for productional purposes. The extraction of the amounts is running quite well.
The problem I am facing is dealing with price of the items. As far as I have understood, each item has a summerization followed by the single locations. I want to calculate the expenses for the highend minerals but I can not work with the SVERWEIS()-function as it expects only one entry per item in a matrix. I have to apologize myself, but I do not know the english name of the function.
It would be nice if you could add the price to the totals.
The spreadsheet and its source can be mailed on request.
Thanks in Advance
Wendelgard
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.16 00:33:00 -
[115]
Wendelgard,
I suggest that you send me an email to [email protected], perhaps along with the spreadsheet and a (german) explanation of what you're after exactly.
I doubt that I might be able change EWA the way you suggest without screwing things up. But I'm sure we can work out something which will help you. -- EVEWalletAware - an offline wallet manager |
Negustor Cinstit
|
Posted - 2010.08.17 13:11:00 -
[116]
Hello, I don't know if this is the place to ask this but I'll take my chance anyway. In the "Wallet->Balance sheet->By wallet transaction" section, the Buy and Sell amounts take in account the fees? It appears this is the case, but i have so many transactions with highly variable volumes that I cannot be fully sure.
Thanks!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.17 14:20:00 -
[117]
This place is perfect for asking.
Let me quote from the version history, version 2.0.0
Quote:
Enhancement
- Balance sheet (transactions). If activated in EWA's settings, broker fees and sales tax will now be taken into account in this window, too. The columns Buy and Sell are left untouched and will still show the plain (sum of the) selected item's/item group's price, but the Total column is calculated by taking broker fees and sales taxes into account.
Keep in mind that the fees are estimated. EWA calculates with the "worst case" fees resulting from your skills only and currently doesn't take your standing towards the NPC corp into account. So, your real fees can only be less than what EWA estimates. -- EVEWalletAware - an offline wallet manager |
Shin Chogan
Gallente
|
Posted - 2010.08.23 09:32:00 -
[118]
OK so I'm working well outside the box on this one à
I've installed this in wine :) but when I run the application I get :
Initialisation failed:
Error accessing database at C:\BA\EWA-DATA\. Application will now terminate
Any ideas ? |
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.23 15:52:00 -
[119]
Nice conversation you have with yourself there.
Unfortunately I can't help you with Wine. Although I do know what Wine is, I've got zero experience with Wine. If you're still having problems, you need to do a bit research yourself, I'm afraid. What you need to figure out is how to get MSXML (version 6) running on/in Wine. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.25 10:21:00 -
[120]
Edited by: Hel O''Ween on 25/08/2010 10:21:46 Version 2.0.12 has been released.
This minor release fixes a small bug and adds a few small enhancements. Wendelgard will be pleased
Also, EWAAutoData has been updated to 1.0.6. It removes the irritating desktop flickering introduced with the last version.
See the version history for details. -- EVEWalletAware - an offline wallet manager |
|
Mhel Shaiten
|
Posted - 2010.08.26 08:21:00 -
[121]
Hi! I'm curious about something :In the quick briefing, I have negative values for 2 days in the "Buy" row, and the graphic drops to -200 000 How is it possible? I've made a screen cap, ask me if you want it.
Except that, it's a great tool, thanks!
|
Yoget
Gallente weaxan
|
Posted - 2010.08.26 08:55:00 -
[122]
Originally by: Mhel Shaiten Hi! I'm curious about something :In the quick briefing, I have negative values for 2 days in the "Buy" row, and the graphic drops to -200 000 How is it possible? I've made a screen cap, ask me if you want it.
Except that, it's a great tool, thanks!
We have run into the same thing, all buys retrieved after we updated are negative values. This is giving incorrect figures in the Total and profit columns on the balance sheet for transactions.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.26 13:18:00 -
[123]
Bah, me stupid!
A new version (2.0.13) has been uploaded, which fixes that bug. Users of the auto downloader should also update it, as it shares the same bug.
For those of you seeing negative values, please do the following to correct your downloaded data:
- Open Extras -> Database maintenance -> Direct database query (I knew this would come in useful at soem time) - Paste the following line in the query window:
UPDATE banav_tWalletTransactions SET price = ABS(price)
- Click "Execute query" - You're done. (There's no indicator, it just executes in the background) - Check your Quick briefing to see if it worked.
If you do not know if you need to apply the above manual fix: just do it. It either does nothing or fixes your already downloaded data. -- EVEWalletAware - an offline wallet manager |
Yoget
Gallente weaxan
|
Posted - 2010.08.26 13:47:00 -
[124]
Sweet, all fixed.
Thank you
|
Companion Qube
|
Posted - 2010.08.26 17:27:00 -
[125]
Hey Hel,
Is it possible that you could make asset updates via the autodownloader optional? I use jeveassets frequently and I'm often finding that the autodownloader has blown my download for the day.
CQ
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.26 18:20:00 -
[126]
Sounds like a doable task, CQ.
I guess, while I'm at it, I'll make any download optional and finally grant EWAAutoData its own option dialog ... something I long refrained from doing. -- EVEWalletAware - an offline wallet manager |
Esculia
Gallente Deep Space Corporation
|
Posted - 2010.08.26 22:05:00 -
[127]
Hello, i just recently installed this application, and i have this little problem. Not sure if it is a problem or me just not knowing how to use the program.
When i try to see my personal wallet transactions with the apllication i can only see last 3 weeks. Is there any way to actually see all the transactions that i can see in the ingame wallet transactions page (those are several months of transactions).
Thanks a lot for any kind of answer. |
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.26 22:33:00 -
[128]
Unfortunately not. That's the way the API's designed. You can't retrieve data past a certain point (max 1000 entries or 1 week worth of data).
This is also the reason, why EWA (and other apps of that type) try to preserve your existing data from version to version, because once you lost your old data, there's no way to collect it from the EVE API again. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.08.26 23:51:00 -
[129]
And therein lies the beauty of leaving the autodownloader running 23/7 - you can easily keep track of all of your historical trade data.
|
Mhel Shaiten
|
Posted - 2010.08.27 21:20:00 -
[130]
Originally by: Companion Qube And therein lies the beauty of leaving the autodownloader running 23/7 - you can easily keep track of all of your historical trade data.
Good point! I'll use the auto downloader from nom on.
Thanks for the fix Hel. I'd like to suggest a new feature for he quick briefing. What about a "top sell" chart based on the margin?
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.28 08:33:00 -
[131]
Edited by: Hel O''Ween on 28/08/2010 08:35:31 Well, "margin" is a ***** (for charting). (Added: obviously "female dog" even when referring to "margin", is a no no word ...)
This might require mutliple queries (sales, purchases) and another calculation run (margin) through the results. I'm not sure if that will fullfill th promise of the feature's name: Quick briefing.
Anyhow, I'll have a look at it. But don't expect something anytime soon. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.28 11:05:00 -
[132]
Originally by: Companion Qube
Is it possible that you could make asset updates via the autodownloader optional?
You might want to have a look at the new version (1.0.8) ... -- EVEWalletAware - an offline wallet manager |
Esculia
Gallente Deep Space Corporation
|
Posted - 2010.08.29 04:24:00 -
[133]
Is there any way to include the faction items when calculating the assets ? I dont think Eve Central has any kind of price for items only bought on contracts.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.29 13:58:00 -
[134]
Currently not, as I'm not aware of any reliable data source for items sold via contracts. This is mainly obviously due to the missing contracts API.
However, EWA allows you to set the prices for those items manually: right-click the item in question -> Set item price. of course, this is a PITA, if you have plenty of faction items. -- EVEWalletAware - an offline wallet manager |
Mhel Shaiten
|
Posted - 2010.08.31 16:05:00 -
[135]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 28/08/2010 08:35:31 Well, "margin" is a ***** (for charting). (Added: obviously "female dog" even when referring to "margin", is a no no word ...)
This might require mutliple queries (sales, purchases) and another calculation run (margin) through the results. I'm not sure if that will fullfill th promise of the feature's name: Quick briefing.
Anyhow, I'll have a look at it. But don't expect something anytime soon.
Thanks for your reply. Of course, it doesn't have to be on the quick briefing, it's just that I think these figures might be interesting. To be honest, it would be even better to have the top sells by margin, but also margins weighted by the item volum. But I thought it was asking a bit too much . Anyway, as I said before, it's already a great help the way it is.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.08.31 16:41:00 -
[136]
Originally by: Mhel Shaiten
Thanks for your reply. Of course, it doesn't have to be on the quick briefing, it's just that I think these figures might be interesting.
Ah, this is a different animal.
Something similar (most likely a new option) is already vaguely in my internal "let's see how this can be done and what can be put in there and how should the results be presented" list.
But to be honest, I can't promise anything for this year. I'd even say it's more likely to happen next year than this year. We're in the middle of a major project in our company and I will personally move to another flat in a few months. Lots of RL stuff that takes precedence. That leaves not much time. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.08.31 20:49:00 -
[137]
Originally by: Hel O'Ween
Originally by: Companion Qube
Is it possible that you could make asset updates via the autodownloader optional?
You might want to have a look at the new version (1.0.8) ...
Awesome, thanks!
|
Xenuria
Gallente Crossfire Incorporated
|
Posted - 2010.09.01 00:13:00 -
[138]
Originally by: Hel O'Ween
Originally by: Schwarzlicht
Run-time error '380':
Invalid property value
Make sure you have the latest MS XML and MDAC installed.
Yeah... Also "reset your ui and delete any third party addons"
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.09.01 09:45:00 -
[139]
Erhm ... is this a question or a comment on that matter?
And if it's a comment, what is supposed to say ...? -- EVEWalletAware - an offline wallet manager |
Mhel Shaiten
|
Posted - 2010.09.01 20:34:00 -
[140]
Originally by: Hel O'Ween
Ah, this is a different animal.
Something similar (most likely a new option) is already vaguely in my internal "let's see how this can be done and what can be put in there and how should the results be presented" list.
But to be honest, I can't promise anything for this year. I'd even say it's more likely to happen next year than this year. We're in the middle of a major project in our company and I will personally move to another flat in a few months. Lots of RL stuff that takes precedence. That leaves not much time.
It's OK, there's no rush. I could have tried and done it mysself, but VB6 is not part of the languages I work with, and I'm not really keen on learning it
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.09.01 21:37:00 -
[141]
Originally by: Mhel Shaiten
I could have tried and done it mysself, but VB6 is not part of the languages I work with, and I'm not really keen on learning it
And to be honest: you shouldn't. It's a dead language (which shows my age, I guess). Unfortunately it is still the language I'm must fluent in.
I'm struggling with .NET, but I'm still fighting with the most basic tasks for hours. That might be because I try to code everything myself and not use wizards and " just plug" databound controls to a database. But from my experience, that's the best way to do it. -- EVEWalletAware - an offline wallet manager |
SC13NC3
|
Posted - 2010.09.15 05:08:00 -
[142]
Hi,
I would like to try this tool out but I keep getting 0 transactions found. In the log, the error comes up as Error 101: Wallet exhausted or something.
My characters are there, the wallet totals are correct and it is my full API key.
What am I doing wrong?
|
Ramingo
Caldari Payable on Death
|
Posted - 2010.09.15 08:24:00 -
[143]
Awesome tool by the way, I got to play around with it while doing some auditing and have to say it made things a lot easier!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.09.15 11:51:00 -
[144]
Originally by: SC13NC3 What am I doing wrong?
You most likely didn't bother to read any of the available resources for EWA, be it this thread or EWA's manual. -- EVEWalletAware - an offline wallet manager |
SC13NC3
|
Posted - 2010.09.15 21:50:00 -
[145]
I read both in their entirety actually, including what you linked.
I guess I'll just use EVE Meep.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.09.16 12:34:00 -
[146]
Edited by: Hel O''Ween on 16/09/2010 12:34:52 You should have noticed then that two applications can't query the same API. The second app will always receive "xxxx exhausted", because of CCP's caching. In order for this to work, you need to either wait until the caching timer has expired before trying to pull data with the second app or use an API proxy.
Here's what I wrote in the linked posting:
Quote:
Also, if you fetched data from the API once for a character with application A, application B querying the same API data from the same IP address gets the "exhausted" message, too. That's how CCP implemented their API caching.
-- EVEWalletAware - an offline wallet manager |
Machete Visor
|
Posted - 2010.09.16 12:48:00 -
[147]
great tool, just started using it.
two enhancements I can see, not sure how difficult to code:
1 - on the balance sheet by item report, include 4 other columns: Avg buy price, avg sale price, margin & margin %. I believe all of these can be found on the items details for each individual item. Putting them next to the totals though would be very helpful. A lot of products are in the 'red' just b/c they haven't sold.
2 - Allow customization of the tables in terms of ordering the columns, column sizes, removing columns, sorting columns. I know you can currently resize and sort - but the settings don't save and i have to do it each time. It'd be very helpful to have it start up on the report format i like to use.
great program. asset valuation using the aware prices is very helpful b/c eve-central/metrics prices can be so off.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.09.16 16:43:00 -
[148]
Originally by: Machete Visor
1 - on the balance sheet by item report, include 4 other columns: Avg buy price, avg sale price, margin & margin %. I believe all of these can be found on the items details for each individual item. Putting them next to the totals though would be very helpful. A lot of products are in the 'red' just b/c they haven't sold.
This sounds doable ...
Quote:
2 - Allow customization of the tables in terms of ordering the columns, column sizes, removing columns, sorting columns. I know you can currently resize and sort - but the settings don't save and i have to do it each time. It'd be very helpful to have it start up on the report format i like to use.
... while this sounds - if not completely undoable - at least like a major PITA.
OK, column sizes, removing & columns sorting (and persisting those states) might work in theory. But that would require some heavy coding.
Ordering columns wouldn't work on many grids, as it would break the grid's logic. The outcome would be funny, as calculating totals, counts, averages is done by the grid, based on changes in the cells contents from left to right. So, if you move "Location" to the first column, the total would be calculated on the column Price, not Total.
Anyhow - let's see if I experience one of those rare "genius moments" and figure out how to implement a bit of the above. -- EVEWalletAware - an offline wallet manager |
Machete Visor
|
Posted - 2010.09.16 18:31:00 -
[149]
Originally by: Hel O'Ween
Originally by: Machete Visor
1 - on the balance sheet by item report, include 4 other columns: Avg buy price, avg sale price, margin & margin %. I believe all of these can be found on the items details for each individual item. Putting them next to the totals though would be very helpful. A lot of products are in the 'red' just b/c they haven't sold.
This sounds doable ...
Quote:
2 - Allow customization of the tables in terms of ordering the columns, column sizes, removing columns, sorting columns. I know you can currently resize and sort - but the settings don't save and i have to do it each time. It'd be very helpful to have it start up on the report format i like to use.
... while this sounds - if not completely undoable - at least like a major PITA.
OK, column sizes, removing & columns sorting (and persisting those states) might work in theory. But that would require some heavy coding.
Ordering columns wouldn't work on many grids, as it would break the grid's logic. The outcome would be funny, as calculating totals, counts, averages is done by the grid, based on changes in the cells contents from left to right. So, if you move "Location" to the first column, the total would be calculated on the column Price, not Total.
Anyhow - let's see if I experience one of those rare "genius moments" and figure out how to implement a bit of the above.
thanks. #1 is the biggest value add. puts you on par w/ other reporting tools.
#2 it kind of a nice to have... i'd focus on more value add type features if those items were going to take awhile.
for example, ability to drill down on the top 10 lists would be good (kinda like you can w/ pivots in excel). That'd be far more valuable than #2.
|
Companion Qube
|
Posted - 2010.09.17 20:32:00 -
[150]
Originally by: Hel O'Ween
Quote:
2 - Allow customization of the tables in terms of ordering the columns, column sizes, removing columns, sorting columns. I know you can currently resize and sort - but the settings don't save and i have to do it each time. It'd be very helpful to have it start up on the report format i like to use.
... while this sounds - if not completely undoable - at least like a major PITA.
OK, column sizes, removing & columns sorting (and persisting those states) might work in theory. But that would require some heavy coding.
Ordering columns wouldn't work on many grids, as it would break the grid's logic. The outcome would be funny, as calculating totals, counts, averages is done by the grid, based on changes in the cells contents from left to right. So, if you move "Location" to the first column, the total would be calculated on the column Price, not Total.
Anyhow - let's see if I experience one of those rare "genius moments" and figure out how to implement a bit of the above.
Most, if not all, of these features are implemented in the default grid components that .net uses. I know you were thinking (long term) of trying to move more in that direction, I'd just let that hang until you do.
Speaking of .net, would you mind putting up the current source for the autodownloader? I'm interested in porting it to .net.
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.09.18 10:31:00 -
[151]
Originally by: Companion Qube
Speaking of .net, would you mind putting up the current source for the autodownloader? I'm interested in porting it to .net.
The downloader is part of the source code package. It's located in the zTOOLS\EWAAutoData folder. Everything in there is unique to the downloader (=not part of EWA), whereas the other sources of the downloader are taken from EWA's parent folder. In those, you'll find a couple of conditional compilation statements ...
#If APP_TYPE = ...
... which either disable some visual feedback from EWA for the downloader or make the downloader more responsive while downloading data.
I'll make sure the most recent version is uploaded on Monday. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.07 10:34:00 -
[152]
Thankfully this time around CCP announced data type changes in the API ahead of its implementation. (For those interested, here's the dev blog).
I just uploaded a new version of EWA, the database and the auto downloader. Although the above mentioned API change will be implemented with the release of Tyrannis 1.2, you can already apply the updates to EWA right now.
This update solely adds Tyrannis 1.2 compatibility to EWA and its DB. No new features this time, as I'm terribly busy in RL at the moment.
If you're using the auto downloader along with EWA, you must update both apps. -- EVEWalletAware - an offline wallet manager |
Deamonx32
|
Posted - 2010.10.19 00:30:00 -
[153]
Edited by: Deamonx32 on 19/10/2010 00:32:55 Just want to say, awesome application been very happy with it.
The other day I transfered some ISK from one character to another, both characters are in EveWalletWare.
On one of the characters I can see the transaction in the journal, but on the other character I can not see the transaction in the journal. Any idea what I can do to fix/resolve this issue?
I have been using your app for a little over a month, monitoring my sales pretty much every day, this is the first time I have noticed something like this. I also figured maybe its just an API caching delay, but it has not resolved itself in over 3 days, also I am using the latest version of the application. I am not using the auto downloader.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.19 09:11:00 -
[154]
Originally by: Deamonx32
The other day I transfered some ISK from one character to another, both characters are in EveWalletWare.
On one of the characters I can see the transaction in the journal, but on the other character I can not see the transaction in the journal. Any idea what I can do to fix/resolve this issue?
Good catch. I think I know the reason why this happened, but need to verify that ingame sometime. At the moment I'm busy in RL and just log in to change skill.
If you're "life depends on it", send me an email to Hel.OWeen[at]eve-biotronics.de and we'll figure out how to add the missing record to that char. -- EVEWalletAware - an offline wallet manager |
Deamonx32
|
Posted - 2010.10.19 21:08:00 -
[155]
Originally by: Hel O'Ween
Originally by: Deamonx32
The other day I transfered some ISK from one character to another, both characters are in EveWalletWare.
On one of the characters I can see the transaction in the journal, but on the other character I can not see the transaction in the journal. Any idea what I can do to fix/resolve this issue?
Good catch. I think I know the reason why this happened, but need to verify that ingame sometime. At the moment I'm busy in RL and just log in to change skill.
If you're "life depends on it", send me an email to Hel.OWeen[at]eve-biotronics.de and we'll figure out how to add the missing record to that char.
No worries, its not that important. Thanks for the help and awesome application.
|
Warren Chest
|
Posted - 2010.10.19 22:02:00 -
[156]
Thanks for this great app, I use it fo two years and it is very useful.
Last week, when retreiving datas from the API, I found something strange : the transactions for my corp did not appeared. The datas are correct in the journal or the personal ones but not the transactions for the corp ! Nothing was added since 10th october in the corporation wallet transaction table ...
Does anybody has this problem ?
|
Companion Qube
|
Posted - 2010.10.20 07:35:00 -
[157]
Originally by: Warren Chest Thanks for this great app, I use it fo two years and it is very useful.
Last week, when retreiving datas from the API, I found something strange : the transactions for my corp did not appeared. The datas are correct in the journal or the personal ones but not the transactions for the corp ! Nothing was added since 10th october in the corporation wallet transaction table ...
Does anybody has this problem ?
Under extras > maintenance try compacting the database. I've had weird problems like this before, usually from something leaving the DB in a strange state (power outage while running EWAAutoData, etc) - for whatever reason compacting has always fixed things.
|
Shadow First
|
Posted - 2010.10.22 20:23:00 -
[158]
ty for the suggestion of compacting the database but that didn't change anything for me
The problem first occured after having imported datas from another computer because I had erased some datas by error in the Corporation transaction table.
I just do that for the moment : downloading data from another PC then export data from it to import to my main computer. It works like that but I would prefer to update directly like I used to...
|
Warren Chest
|
Posted - 2010.10.23 06:53:00 -
[159]
Originally by: Companion Qube
Under extras > maintenance try compacting the database. I've had weird problems like this before, usually from something leaving the DB in a strange state (power outage while running EWAAutoData, etc) - for whatever reason compacting has always fixed things.
ty for the suggestion of compacting the database but that didn't change anything for me
The problem first occured after importing datas from another computer because I had deleted some datas by error in the Corporation transaction table.
I just do that for the moment : downloading data from another PC then export data from it to import to my main computer. It works like that but I would prefer to update directly like I used to...
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.25 20:31:00 -
[160]
Edited by: Hel O''Ween on 25/10/2010 20:34:23
Originally by: Warren Chest
I just do that for the moment : downloading data from another PC then export data from it to import to my main computer. It works like that but I would prefer to update directly like I used to...
A couple of questions:
Is your version up to date (incl. the database)?
Any abnormal entries in the log (Extras -> Application log)? Try "Log -> Empty log" right before you try to download your corp transactions. Then check the log.
Also, check Extras -> Cached XML files. There should be six entries "Wallet transaction (corporation)". Click on them. Is there actually data in there?
One last point: You're using the same char to retrieve corp data on that second machine that does work? If not, has the char the necessary rights to retrieve API data? -- EVEWalletAware - an offline wallet manager |
|
Warren Chest
|
Posted - 2010.10.26 17:29:00 -
[161]
My version is up to date (2.0.14 and Db ver 18). The transaction table works very well for personal datas on this machine; only corp transactions are concerned. Even the journal is OK and I can see the transactions in this one but without the details we get in the transactions report...
I found these entries in the log on start :
Error: -2147220988, EVE API Error: 516, Failed getting user information.
cEVEChars:GetEVEChars->457, EVEWalletAware, Cette clT est dTja associTe a un TlTment de cette collection
after dowload of corp transactions :
Error: -2147221403, EVE API Error: 101, Wallet exhausted: retry after 2010-10-26 17:55:25. (5 of this type)
Error: -2147221387, EVE API Error: 117, Market orders already downloaded: retry after 2010-10-26 17:43:09.
regarding the cached xml files now : there are five entries for corp wallet transactions : some with datas, some without (the empty ones are the inactive corp wallets). It looks like the one I need is missing here !
I use same character on the 2 machines, I also tried some alts but with no results.
ty for your help as I would like to keep my 2 years old database working ^^
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.27 00:13:00 -
[162]
Originally by: Warren Chest
I found these entries in the log on start :
Error: -2147220988, EVE API Error: 516, Failed getting user information.
cEVEChars:GetEVEChars->457, EVEWalletAware, Cette clT est dTja associTe a un TlTment de cette collection
Those two errors shouldn't occur. Did you by any chance change the corp with that character? That would explain that personal wallet transactions work just fine, but corporate not. If you did so, try retrieving the characters for that EWA account again. I suggest also to mark one EWA account as your default account, if you haven't already done so.
Quote:
after dowload of corp transactions :
Error: -2147221403, EVE API Error: 101, Wallet exhausted: retry after 2010-10-26 17:55:25. (5 of this type)
This is an informational entry. EWA queried all data available for that wallet division.
Quote:
regarding the cached xml files now : there are six entries for corp wallet transactions : some with datas, some without (the empty ones are the inactive corp wallets).
Again, that's the expected behavior. Data is downloaded (and stored) by EWA, no data is lost. There only seems to be a problem with displaying the data.
If my above suggestion doesn't work/is not applicable, send me an email at Hel.OWeen[at]eve-biotronics.de. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.10.27 05:39:00 -
[163]
How do I go about emptying the log with a direct database query? I have something like 1 and a half years of heavy trading and I've never cleared the log - loading the log causes EWA to try and load everything into memory, which does bad things.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.27 11:43:00 -
[164]
Originally by: Companion Qube How do I go about emptying the log with a direct database query?
DELETE * FROM tApplicationLog
You can also switch to text file logging instead writing the log to the DB. To do so, open EVEWalletAware.ini and enter the following line beneath the [General] section:
LogType=1
Deleting that line or changing the value to 0 will resume database logging again. Logging to a text file has the advantage that EWA autopurges log files older than 14 days. It has two disadvantages, though: a) can't view them from within EWA and b) logging is a bit slower. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.10.28 00:16:00 -
[165]
Thanks, that cleaned things up nicely. You might appreciate this.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.28 07:33:00 -
[166]
2 GB? That's a lot of log entries. I guess, I'll implement some kind of auto-purging for DB logging, too. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.10.28 11:47:00 -
[167]
The DB was actually one of the single largest files on my SSD so I'd been monitoring it for a while - I'm pretty surprised that was all log entries though. I expected more was data.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.10.30 11:35:00 -
[168]
Edited by: Hel O''Ween on 30/10/2010 11:44:25
Originally by: Warren Chest
EWA problem report
Just a quick note, Warren: I received your emails, but my mail server currently has problems sending out emails.
In the meantime, see if the explanation under "Import wallet transactions/journals for" helps to clarify EWA's behavior.
Make that a "dumb user problem", not a mail server problem. Email sent. -- EVEWalletAware - an offline wallet manager |
Dmitri Kreig
|
Posted - 2010.11.06 05:38:00 -
[169]
Hello!
I've been using this app for monitoring my assets for some time, great tool. But since the last patch, it displays only a minor part of my stuff. Cached XML file for Asset list query contains only several hundreds of rows, and if i'm guessing correctly, 1 row = 1 item (stack), in wich case there should be several thousands of them. App log entry for updating assets from API says: "Application Error: cEVEAssets:ParseXML->6, EVEWalletAware, Overflow". My OS is XP.
Anyone has the same problem? Any tips? |
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.06 14:52:00 -
[170]
There seem to be two problems here. One I can solve (an oversight on my part when updating the app to be Tyrannis 1.2 ready). The other problem seems to be a problem with the API itself (on your side).
Originally by: Dmitri Kreig Hello! Cached XML file for Asset list query contains only several hundreds of rows, and if i'm guessing correctly, 1 row = 1 item (stack), in wich case there should be several thousands of them.
You're right. 1 row should translate to 1 item (stack). If the XML itself is intact (=has a closing </eveapi> tag), that's all what the API returned. EWA downloads a XML file from the API, stores it first and then proceeds to process it. EWA never manipulates the XML file itself in any way. Please note though, that EWA's preview window of the cached XML files might shorten the file. To really see if the XML is complete and intact, export the cached asset API to a XML file and open it in a browser.
Quote:
App log entry for updating assets from API says: "Application Error: cEVEAssets:ParseXML->6, EVEWalletAware, Overflow". My OS is XP.
This is an oversight on my part. When updating EWA to by Tyrannis 1.2 ready, I missed to update one method, which causes the above error. This will be fixed in the next version. Not sure when I'll be able to release it, as I've just moved to a new flat and still have lots of stuff to do.
EWAAutoData suffers from this bug, too.
If you can't live without proper assets, try jEveAssets for asset management. -- EVEWalletAware - an offline wallet manager |
|
Dmitri Kreig
|
Posted - 2010.11.06 19:08:00 -
[171]
I exported XML file, and opened it in Excel - and here they are, all 5+thousands entries with a proper /smthn closing.. you were right about it.
Since you are having RL issues, nevermind then, it is not a pressing matter. Hope it'll get working again eventually.. a very usefull tool, thank you for creating it
|
Ulf Raben
Gallente
|
Posted - 2010.11.08 13:06:00 -
[172]
Hello there Hel O'Ween I have for some time enjoyed Your Tool .. which has been GREAT ! Now .. it doesnt show very much ..really a nuiscance What can i .. who am a programing idiot do in order to get back into Your indispensable tool ... Could You please explain .. in the meticulous and thorough way which has been the hallmark of Your tool What I can do ?
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.08 19:52:00 -
[173]
Sorry, Ulf, I don't get it. Could you please try rephrase your question "for dummies"?
I'm unsure if you meant to say that EWA did work for you, but not doesn't work anymore or if you want to get it working for you in the first place.
IF the first is the case, have you updated EWA and the database to the current version (menu "? -> Check for updates")? You need to do so in order for EWA to work with Tyrannis 1.2. Also there's a bug in the asset management (see the messages above yours), which I need to release a fix for. -- EVEWalletAware - an offline wallet manager |
Ulf Raben
Gallente
|
Posted - 2010.11.09 07:01:00 -
[174]
Well the Basic Screen seems to work normally ..n as far as i know ive installed all there is to install ..BUT : as said above ...when i try to update my assets in order to see changes ..the manager only came up with some few items ..n incomplete as well as erratic ..so it is of no use . I very much would like to get back to normal as Your tool .. BY FAR ..is the BEST TOOL FOR TRADERS available in EVE .. its German thoroughness .. at its best ! Could U please give some directions what I must do
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.09 08:37:00 -
[175]
Originally by: Ulf Raben BUT : as said above ...when i try to update my assets in order to see changes ..the manager only came up with some few items ..n incomplete as well as erratic ..so it is of no use . Could U please give some directions what I must do
I already mentioned in my last message (and as discussed in the posts right above your post) that currently there's a bug in EWA which prevents it from displaying assets correctly. You need to wait until I have time to release the fix. -- EVEWalletAware - an offline wallet manager |
alex9066
|
Posted - 2010.11.09 22:12:00 -
[176]
Hi there, i love this tool for eve, its helping me understand how to make a profit and keep tabs on everything market related on eve, but recently i have been having problems with it....
I've uninstalled the EWA and then tried to reinstall it but am getting an error message when trying to install it, the error message is as follows:error accessing database at C:\ProgramData\EVEWalletAware\Data\.
Any help would be appreciated as im feeling a little lost without my stats lol.
P.S. Im running windows 7 64 bit.
Alex
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.10 09:04:00 -
[177]
Originally by: alex9066
I've uninstalled the EWA and then tried to reinstall it but am getting an error message when trying to install it, the error message is as follows:error accessing database at C:\ProgramData\EVEWalletAware\Data\.
Any help would be appreciated as im feeling a little lost without my stats lol.
P.S. Im running windows 7 64 bit.
Good that you mentioned it. Windows 7 (and I guess Vista as well, but I skipped it) does some strange things with folders (junctions). I'm still not too familiar with Windows 7, so I'm not 100% sure if the following is the right solution:
- Locate EWA's config file EVEWalletAware.ini. It should be located under "C:\USERS\ALL USERS\EVEWALLETAWARE\evewalletaware.ini". Please note that you might find 3 copies of the file, of which two or "pointers" to this location. Make sure you find the right one.
Open the file with a text editor. Locate a section called [Database]. Beneath that there should be two lines: 1) Connection=<stuff> 2) DatabasePath=<stuff>
Those lines should look like this (I intentionally word-wrapped the first line here to not break the forum's layout, make sure that you have it in one line):
[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=; DatabasePath=C:\DOCUMENTS AND SETTINGS\ALL USERS\APPLICATION DATA\EVEWALLETAWARE\DATA\
I'm not sure why Windows 7 causes this havoc, as I follow Window's guidelines as to how to retrieve system folders (storage path for application data).
Perhaps more versatile Windows 7 users can point out an easier/better way of making EWA behave right. -- EVEWalletAware - an offline wallet manager |
MailDeadDrop
The Collective
|
Posted - 2010.11.10 17:59:00 -
[178]
Perhaps you can use something like %AppData% and then run the value through something like wshShell.ExpandEnvironmentStrings() ?
MDD
|
MagnatDragon
|
Posted - 2010.11.10 19:13:00 -
[179]
I have dont work this program!What me do?
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.10 21:08:00 -
[180]
Originally by: MailDeadDrop Perhaps you can use something like %AppData% and then run the value through something like wshShell.ExpandEnvironmentStrings() ?
As I wrote, I'm using an official API (SHGetFolderPath() with CSIDL_COMMON_APPDATA). Initially the path is written to the INI by the installer, which predates Vista. So, perhaps the installer has problems of figuring out the right path and/or updating the INI with the proper value.
EWA itself seems to run fine, once the path is correct in the INI.
Originally by: MagnatDragon
I have dont work this program!What me do?
Well, a good start is always to try to describe your problem and anything that happens (or not) as good and detailed as you can. From what you've wrtoe, I can't even tell if you can't get EWA to run at all or simply have no idea on how to use it, once you installed it ... -- EVEWalletAware - an offline wallet manager |
|
MagnatDragon
|
Posted - 2010.11.11 13:10:00 -
[181]
Originally by: MagnatDragon
I have dont work this program!What me do?
Well, a good start is always to try to describe your problem and anything that happens (or not) as good and detailed as you can. From what you've wrtoe, I can't even tell if you can't get EWA to run at all or simply have no idea on how to use it, once you installed it ...
1.Run EVEWalletAware 2.Click button Retrieve data from EVE API (Choise Personal data(Wallet and Journal)) 3.Switch account/Characters: - Select account MagnatDragon - Select character Nothing (The Field of this string I have EMPTY)
Then I do too most with Corporation Data (Wallet and Journal) but the same result - in EVEWalletAware changes nothing!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.11 15:04:00 -
[182]
Originally by: MagnatDragon
3.Switch account/Characters: - Select account MagnatDragon - Select character Nothing (The Field of this string I have EMPTY)
Try retrieving the chars for this EWA account again (Extras -> Options).
If that doesn't help, does the application log (located under Extras) show any errors? -- EVEWalletAware - an offline wallet manager |
MagnatDragon
|
Posted - 2010.11.11 15:36:00 -
[183]
Originally by: Hel O'Ween
Originally by: MagnatDragon
3.Switch account/Characters: - Select account MagnatDragon - Select character Nothing (The Field of this string I have EMPTY)
Try retrieving the chars for this EWA account again (Extras -> Options).
If that doesn't help, does the application log (located under Extras) show any errors?
Error: -2147220988, EVE API Error: 516, Failed getting user information.
What me do?
|
MailDeadDrop
The Collective
|
Posted - 2010.11.11 16:39:00 -
[184]
Originally by: Hel O'Ween As I wrote, I'm using an official API (SHGetFolderPath() with CSIDL_COMMON_APPDATA). Initially the path is written to the INI by the installer, which predates Vista. So, perhaps the installer has problems of figuring out the right path and/or updating the INI with the proper value.
Sorry, I haven't read the entire thread, and apologize for my willful ignorance on the official API call you're using. Based on what you wrote, I find it completely believable that the installer is at fault. Whenever you'd like to test a new install package, I've got a Win7 64-bit system ready.
MDD
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.11 21:56:00 -
[185]
No need to apologize.
And thanks for the offer, but I got Win 7 64 bit myself (though I don't think it's related to 32 vs. 64 bit). But I'm still new to Win7 and need to figure out how Vista/Win 7 virtualizes all the pre-Vista stuff (Documents and Settings -> User i.e.). -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.13 11:14:00 -
[186]
EWA version 2.0.15 and EWAAutoData version 1.0.10 have been released. This should fix the assets bug along with the bug that a money transfer between two chars only shows up in the first char's wallet journal.
See the version history for details. -- EVEWalletAware - an offline wallet manager |
Aiden Connley
Caldari
|
Posted - 2010.11.13 23:25:00 -
[187]
Okay, so here's a problem: This morning my Evemon client (which I leave running pretty much 24/7) started crashing saying out of disk space. My C: drive is fairly full, so I shuffled some data around and cleared out about 22GB of space. So far so good.
A few hours later, it started crashing again, and I found me C: drive was back down to 54MB or so....what the...??
So I have a look, and the culprit is the WalletAware LOG file, which has grown to over 79GB!!! And the DB file is over 805MB...holy cow! And I've only been playing for 6 months and only running the app for a couple of weeks, one character, one account.
So I figure...time to find DB tools...AH! Compact DB..that should help....that is unless it errors out which is precisely what it did.
So...firstly, how do I go about fixing this? Secondly, a feature suggestion: Add the ability to schedule regular DB maintenance?
Also...Access sucks as a DB engine compared to SQL, I suggest revisiting the back end and consider SQL Express as a possibility. While I agree that lots of people know how to poke around in an Access DB, I challenge that most of those also know how to poke around in an SQL db too.
Finally, on a happier note...love the app, great tool. I look forward to seeing it refined and developed more.
|
RnDr Brain
|
Posted - 2010.11.13 23:46:00 -
[188]
Edited by: RnDr Brain on 13/11/2010 23:47:43 can't update my assets, in log is this Error: -2147221401, EVE API Error: 103, Already returned one week of data: retry after 2010-11-14 00:37:24. It worked with no problems until last weekend, now I am trying it everyday with no result.
I have version 2.0.15
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.14 11:50:00 -
[189]
Originally by: Aiden Connley
So I have a look, and the culprit is the WalletAware LOG file, which has grown to over 79GB!!! And the DB file is over 805MB...holy cow! And I've only been playing for 6 months and only running the app for a couple of weeks, one character, one account.
So...firstly, how do I go about fixing this? Secondly, a feature suggestion: Add the ability to schedule regular DB maintenance?
First, could you please name the log file, because EWA doesn't write *one* (text) log file, but a separate log file each time you start EWA. EWA uses text logging until it was able to initialize the DB, then starts logging to the DB instead (at least if you haven't edited the INI and forced EWA to sole text file logging). It also auto-purges log files older than 14 days.
Second, see this post and page back (and my following answer) on how to empty EWA's logging table. Try compacting afterwards.
Scheduling is something I'll think about.
Quote:
Also...Access sucks as a DB engine compared to SQL, I suggest revisiting the back end and consider SQL Express as a possibility. While I agree that lots of people know how to poke around in an Access DB, I challenge that most of those also know how to poke around in an SQL db too.
I don't think I will start forcing people into installing SQL Server. Although EWA would of course benefit from SQL Server, I consider this to be too intrusive as an requirement to run some gaming utility.
Originally by: Aiden Connley
can't update my assets, in log is this Error: -2147221401, EVE API Error: 103, Already returned one week of data: retry after 2010-11-14 00:37:24. It worked with no problems until last weekend, now I am trying it everyday with no result.
Well, look at the time stamp you posted your message and at the time provided by the EVE API server. You only can query your assets once every 24 hours.
This is how the assets API (and EWA) has always worked.
Also, keep in mind that the API caching is per API call type (assets, wallet journals etc.) and per IP address & account. In other words, using two different applications for the same data (assets, i.e.), leaves the second application without data, unless you're using an (API) proxy server. EWA can be configured to work with proxy servers. -- EVEWalletAware - an offline wallet manager |
Aiden Connley
Caldari
|
Posted - 2010.11.14 18:44:00 -
[190]
Thanks for the quick response, Hel.
Originally by: Hel O'Ween
Originally by: Aiden Connley
So I have a look, and the culprit is the WalletAware LOG file, which has grown to over 79GB!!! And the DB file is over 805MB...holy cow! And I've only been playing for 6 months and only running the app for a couple of weeks, one character, one account.
So...firstly, how do I go about fixing this? Secondly, a feature suggestion: Add the ability to schedule regular DB maintenance?
First, could you please name the log file, because EWA doesn't write *one* (text) log file, but a separate log file each time you start EWA. EWA uses text logging until it was able to initialize the DB, then starts logging to the DB instead (at least if you haven't edited the INI and forced EWA to sole text file logging). It also auto-purges log files older than 14 days.
The log file name is EWAAD20101112003549.txt So I apologize for not being clear, obviously from the name the file is from EWAAD not EWA itself. Also, i think I somehow managed to have 2 copies of EWAAD running at once (no that was not intentional).
Originally by: Hel O'Ween
Second, see this post and page back (and my following answer) on how to empty EWA's logging table. Try compacting afterwards.
I tried your suggestion and it didn't do anything to the EWAAD logs (there's two, the other is around 4MB) and DB compacting still throws an error.
Originally by: Hel O'Ween
Scheduling is something I'll think about.
Cool. Thanks. :)
Originally by: Hel O'Ween
I don't think I will start forcing people into installing SQL Server. Although EWA would of course benefit from SQL Server, I consider this to be too intrusive as an requirement to run some gaming utility.
Fair Enough. Sorry if I came off a little harsh expressing my opinion..didn't mean to be a jerk about it.
Originally by: Hel O'Ween
Originally by: RnDr Brain
can't update my assets, ***edited for brevity*** with no result. *Hel's response*
The above was posted by RnDr Brain, not me. Just saying. :)
So is there a way to clear the EWAAD log or can I just delete it w/o ill effect? Is there a way to find out what the error is when trying to compact the EWA DB so we can troubleshoot this further?
|
|
Aiden Connley
Caldari
|
Posted - 2010.11.14 19:03:00 -
[191]
Originally by: Aiden Connley
Is there a way to find out what the error is when trying to compact the EWA DB so we can troubleshoot this further?
Update: Got the DB compacting error fixed: 1) Discovered the previous version of EWAAD was still running (thought I had killed it yesterday, apparently not) 2) Renamed the 1.0.0.10 version to the correct name (had a (2) at the end) for future use, but did NOT run it. 3) I modified the .ini to use the API cache at Eve-dev.com 4) Ran a manual data retrieval from EWA. 5) Compacted the database, no problem.
So now I just need to know what to do about this massive EWAAD log.
|
Dmitri Kreig
|
Posted - 2010.11.15 02:18:00 -
[192]
Edited by: Dmitri Kreig on 15/11/2010 02:22:14 I tried to look at my assets in EWA 2.0.15, by doing full reinstall. When pressing "Update assets from API" button i had the following result:
1. EWA downloaded 5800+ assets from API, seems like all of them. 2. Lower bars info message says "Done loading 5260 assets, now populating the grid". 3. Grid stays completely empty.
An .xml file for assets looks ok (5800+rows, proper /eveapi closing), and i can see all assets under drop-down filter boxes (items, stations, etc) in assets managing window, but grid stays empty no matter what i do. App log for the time of downloading assets contains alot (500+) entries, all saying: "cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, <number>", where <number> is one of 10 or so different values for each entry. It looks like this:
003: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 414293034 004: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 414293034 005: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 414293034 .................................................................... 110: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 973720116 111: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 973720116 112: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 973720116 .................................................................... 559: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 1859544617 560: cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, 1859544617
It seems to me, EWA downloads data from API, but somehow is unable to display said data correctly.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.15 11:58:00 -
[193]
Originally by: Aiden Connley
Update: Got the DB compacting error fixed: 1) Discovered the previous version of EWAAD was still running (thought I had killed it yesterday, apparently not) 2) Renamed the 1.0.0.10 version to the correct name (had a (2) at the end) for future use, but did NOT run it. 3) I modified the .ini to use the API cache at Eve-dev.com 4) Ran a manual data retrieval from EWA. 5) Compacted the database, no problem.
I'm glad you got that sorted out. Yes, compacting the DB requires both EWAAutoData to beclosed. Didn't think about that.
Quote:
So now I just need to know what to do about this massive EWAAD log.
Just as EWA auto-purges old (older than 14 days)text logs, EWAAutoData purges its, too ... on application startup. If you keep that beast running 24/7, well no cleanup takes place. And the massive size of the logs is something which stems from the assets bug, I think, causing a lenghty error entry for each item.
Once that one is (finally) fixed, the log's size should shrink again.
I think I also add some "warch for date change, if so start new log and do cleanup" for those fanatics like you, who run EWAAutoData 24/7.
Originally by: Dmitri Kreig
"cEVEAssets:ParseXMLRow->6, EVEWalletAware, Overflow, <number>", where <number> is one of 10 or so different values for each entry.
Damn it, I thought that I fixed this one finally. My problem is, I haven't acquired any new items lately, therefore my item IDs are still within the old range. So, for me EWA throws no errors. I'll look at it again.
And the different numbers are the item IDs, so thanks a lot for posting the log entries, this is helpful. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.11.15 20:53:00 -
[194]
EWA version 2.0.16 and EWAAutoData version 1.0.11 have been released. This hopefully finally fixes the assets problem.
I've also implemented a log file rollover for EWAAutoData. If it detects a date change (you leave it running while midnight passes), it closes the current text log file, starts logging to a new file and does a clean up (delete logs older than 14 days), just at it does at application start up.
I haven't updated the version history on EWA's website yet, will do so tomorrow. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.01 11:37:00 -
[195]
Just a quick note to let you know that if you're missing the Noctis (+BPO) in EWA, it's due to the fact that CCP hasn't published the Incursion database dump yet.
If you bought or sold Noctis' (and/or its BPO) already - don't worry, your transactions are not lost, they just don't show up in EWA at the moment. As soon as the DB is updated, all your Noctis related transactions will appear in EWA. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.08 10:46:00 -
[196]
Edited by: Hel O''Ween on 08/12/2010 10:51:45 EWA version 2.0.17 and EWAAutoData version 1.0.12 have been released, along with the database update to Incursion (DB version 19).
I've added one small addition to EWA's Quick briefing: the revenue chart may now optionally show a graph for profit/loss, too.
See the version history for details.
[Added] In case you haven't noticed yet: Ix Forres announced that EVE Metrics will close its doors in January at latest. As of now, it seems that Ix is not willing to hand the project over to someone else. If that's the case, I'll need to remove EVE Metrics as a data source for market stats in the next release. -- EVEWalletAware - an offline wallet manager |
Tria' Va
|
Posted - 2010.12.16 23:46:00 -
[197]
so, i'm running win7 and can't seem to get it to work.
installed it normaly, not changing the placement of the install or anything. couldn't start, got that "error accessing database at C:\ProgramData\EVEWalletAware\Data" that someone els has too.
tryed to fix it too by going into the .ini file and copy pasted your correction as you said, didn't fix it.
i then deleted and reinstalled it to a new locations.
C:\Users\Peter\Desktop\Eve-online\EVEWalletAware C:\Users\Peter\Desktop\Eve-online\DATA
and I can start it up now, tho now i can't get my char information from the FULL API. getting this error in the log. EVE API Error: 516, Failed getting user information
i have triple checked the API.
tho i installed it EWA to a new location. i still got some files and folders under: C:\ProgramData\EVEWalletAware GFX folder, LOGS folder and EVEWalletAware.ini file
the code in the EVEWalletAware.ini, under database looks like this.
[Database] Connection=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Peter\Desktop\ Eve-online\DATA\EVEWalletAware.mdb;User Id=admin;Password=; DatabasePath=C:\Users\Peter\Desktop\Eve-online\DATA\ Version=18
hopes this helps you in fixing your win7 problems.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.17 00:16:00 -
[198]
Edited by: Hel O''Ween on 17/12/2010 00:17:01 Yes, Windows 7 does weird things.
Originally by: Tria' Va
and I can start it up now, tho now i can't get my char information from the FULL API. getting this error in the log. EVE API Error: 516, Failed getting user information
You should have stopped here. With the emergency reboot of TQ tonight, the API server was also disabled. From the time you posted, that could have happened at the time you tried to get your chars from the API.
Try it again later on/tomorrow and see if it works then.
Quote:
tho i installed it EWA to a new location. i still got some files and folders under: C:\ProgramData\EVEWalletAware GFX folder, LOGS folder and EVEWalletAware.ini file
Those files/folders will always be there, regardless of where you install EWA itself. -- EVEWalletAware - an offline wallet manager |
Tria' Va
|
Posted - 2010.12.17 02:30:00 -
[199]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 17/12/2010 00:17:01 Yes, Windows 7 does weird things.
Originally by: Tria' Va
and I can start it up now, tho now i can't get my char information from the FULL API. getting this error in the log. EVE API Error: 516, Failed getting user information
You should have stopped here. With the emergency reboot of TQ tonight, the API server was also disabled. From the time you posted, that could have happened at the time you tried to get your chars from the API.
Try it again later on/tomorrow and see if it works then.
i took a look at EMMA too,like an hour befour i started with EWA and didn't seem that the API server was offline then, but i guess it still can be the case.. i will check tomorrow then. thanks
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.17 09:39:00 -
[200]
One last suggestion: if it still doesn't work, try setting it to XP compatibility mode and see if that helps. -- EVEWalletAware - an offline wallet manager |
|
Tria' Va
|
Posted - 2010.12.17 14:26:00 -
[201]
Originally by: Hel O'Ween One last suggestion: if it still doesn't work, try setting it to XP compatibility mode and see if that helps.
don't know if API server is down now or not.
but it didn't work, also tryed it by setting the .exe to XP compatibility.
anyone with win7 that got EWA to work? could be i'm doing something completely wrong.
|
Corcyrus Endymion
Caldari Excessum Corporation Excessum Gaming
|
Posted - 2010.12.17 16:09:00 -
[202]
Just jumping to say that I really like WalletAware, ever since I started using a year or so ago. So , thanks!
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.17 21:47:00 -
[203]
Originally by: Tria' Va
anyone with win7 that got EWA to work? could be i'm doing something completely wrong.
@Tria: I suggest that you send me an email to [email protected] so that we can find a solution for you. I myself and others have EWA running on Windows 7, so its not a general problem. But I know that the first time I tried to install EWA on my Win7 machine, I ended up with the database being at three different locations.
@Corcyrus: Thank you for the kind words. Much appreciated. -- EVEWalletAware - an offline wallet manager |
Colgir
|
Posted - 2010.12.18 22:08:00 -
[204]
Hello,
i want to run EWA with an Eve_API_Proxy-Tool. Well, on first sight it is working, but i found a little problem. EWA is requesting the server status with 'Server/ServerStatus.xml.aspx'. But the correct request is 'server/ServerStatus.xml.aspx' (with a small 's' at the beginning); this is documented in http://wiki.eve-id.net/APIv2_Page_Index with a small 's', too. The eve-api has no problem with it, but the api-tool has. This is of course no major problem, only a typo.
Regards
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.19 09:48:00 -
[205]
Originally by: Colgir
EWA is requesting the server status with 'Server/ServerStatus.xml.aspx'. But the correct request is 'server/ServerStatus.xml.aspx' (with a small 's' at the beginning); this is documented in http://wiki.eve-id.net/APIv2_Page_Index with a small 's', too.
Noted, Colgir. Thanks for letting me know. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.12.21 07:57:00 -
[206]
Edited by: Companion Qube on 21/12/2010 07:57:22 I'm seeing a lot of this in the logs - spammed even, to the tune of hundreds of megabytes or gigabytes worth of log output over a day or so. Halp :(
Date/Time: 12/20/2010 8:18:56 AM EventID : 1001 Event : ApplicationError ----- cXMLCacheFile:Save->-2147467259, Microsoft JET Database Engine, Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. ==================================================================================================== Date/Time: 12/20/2010 8:18:56 AM EventID : 105 Event : DBError ----- Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. ====================================================================================================
edit: RIP. forum formatting.
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.21 10:57:00 -
[207]
Hi CQ,
uhh, that looks pretty ugly (adn I'm not talking about the forum formatting).
Try to close down all running instances of EWA and EWAAutoData (check taskmanager to make sure there are no orphans still runnning).
I know you keep EWAAutoData running 24/7 and therefore your machine as well. Have you tried a reboot? -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.12.21 11:14:00 -
[208]
Yeah, honestly I'm lazy enough that I've been avoiding this for two or three months. I'm willing to blow away anything except the 18 months of EWA database that I've got stored, any suggestions?
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.22 15:04:00 -
[209]
Originally by: Companion Qube I'm willing to blow away anything except the 18 months of EWA database that I've got stored, any suggestions?
You could try the following:
- First of all, make a backup of your current DB! - Do an export of your current database (menu File -> Export/Import EWA data) - Close EWA, rename/move your existing DB to something else/different location - Grab a copy of EWA's palin empty DB: http://eve.basicaware.de/EVEWalletAware/download.html#downloaddb. Place it in EWA's database folder (you need to rename the file in the archive from EVEWalletWareDB.mdb to EVEWalletAware.mdb) - Start EWA and set up all accounts/characters - Import your previously exported EWA data into this new "installation"
If in doubt, contact me at [email protected] -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2010.12.23 05:05:00 -
[210]
Just a quick update, I think I fixed the problem. I guessed that something crashed the machine while wallet aware was writing to the database (good old lack of atomic commits) - so I googled for info re: repairing JET databases. Installing access off my office disk and running compact/repair on the database fixed things right up, no need to export/import.
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2010.12.23 09:39:00 -
[211]
Edited by: Hel O''Ween on 23/12/2010 09:38:55 Cool.
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. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
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
|
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. -- EVEWalletAware - an offline wallet manager |
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
|
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) -- EVEWalletAware - an offline wallet manager |
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) - 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.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. -- EVEWalletAware - an offline wallet manager |
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.
- 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.01.05 10:55:00 -
[219]
VV, would you mind contacting me at [email protected]?
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. -- EVEWalletAware - an offline wallet manager |
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
|
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). -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
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?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.01.14 11:21:00 -
[224]
Edited by: Hel O''Ween on 14/01/2011 11:23:20 @CQ: Yeah, I know. 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. -- EVEWalletAware - an offline wallet manager |
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
|
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). -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
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. -- EVEWalletAware - an offline wallet manager |
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. - 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.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).
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. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
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. -- EVEWalletAware - an offline wallet manager |
|
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
|
Posted - 2011.01.21 16:09:00 -
[232]
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 ... -- EVEWalletAware - an offline wallet manager |
Julian Koll
The Kollektive
|
Posted - 2011.01.21 17:06:00 -
[233]
Mailed u ingame with screenshot :)
|
Hel O'Ween
Men On A Mission
|
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. 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. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
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
|
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. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
Posted - 2011.01.22 10:40:00 -
[237]
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.
|
Hel O'Ween
Men On A Mission
|
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. -- EVEWalletAware - an offline wallet manager |
Companion Qube
|
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'
|
|
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 |
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.19 15:12:00 -
[271]
Originally by: Noisette Noir
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.
As already mentioned a few postings above, the wallet journal API, especially the corp API, seems to have some problems lately. Until now, it's not clear why and how, but you're not the only person experiencing this problem, nor is EWA the only application with which that happens.
Quote:
I also wonder if EWA saves the data, so that it will eventually go back a lot longer than ingame?
Yes, of course. That's the whole point of apps like EWA. More data = more reliable stats. -- EVEWalletAware - an offline wallet manager |
Andi Friend
|
Posted - 2011.02.21 08:45:00 -
[272]
Edited by: Andi Friend on 21/02/2011 08:45:41 Hi
in beginning: I did read nearly all this thread. But I did not find an answer on my question. I also did read manual and I think I did correct steps in configuration.
question/problem: I've entered Full API to the tool, and if I go to wallet statistics e.g. I do get some information which is relevant to my character, also I do get good list of assets (takes time though). But, I can't see neither wallet transaction nor wallet journal. :( All I get is "0 transactions found" (No error messages or I don't know where to look for them) And window like you have here doesn't opens at all. Do I do something wrong? Did I miss configure the tool?
I had on other PC EVEMon running, and then I thought what if it is that caching problem that was mentioned in manual. So I did close EVEMon, waited 8 hours but still getting "0 transactions found". And there are transactions :)
Please help me, Tool seems great - I wanna use it.
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.21 12:19:00 -
[273]
Originally by: Andi Friend
I also did read manual and I think I did correct steps in configuration. [...]
(No error messages or I don't know where to look for them)
So much for reading the manual, eh?
The application log is located under Extras -> Application log. There's where erros would be listed. Also, check Extras -> Cached XML files for current files with data.
And yes, the API is unforgiving with cached data. Do you by chance run another program that might have grabed the financial data from the API?
Also, you did click that "Retrieve data from EVE API" button again, right? EWA itself won't fetch any data automatically. If you wish to do so, try the auto downloader. -- EVEWalletAware - an offline wallet manager |
Andi Friend
|
Posted - 2011.02.21 16:48:00 -
[274]
Originally by: Hel O'Ween
Originally by: Andi Friend
I also did read manual and I think I did correct steps in configuration. [...]
(No error messages or I don't know where to look for them)
So much for reading the manual, eh?
The application log is located under Extras -> Application log. There's where erros would be listed. Also, check Extras -> Cached XML files for current files with data.
And yes, the API is unforgiving with cached data. Do you by chance run another program that might have grabed the financial data from the API?
Also, you did click that "Retrieve data from EVE API" button again, right? EWA itself won't fetch any data automatically. If you wish to do so, try the auto downloader.
Ah ah, my bad. Application log was very visible :) Admited. But other then that I still in doubts. On your question: No chance that any other program would grab data from API except EVE client itself. Does EVE client with same character loaded in it makes those cache problems?
Now after quite long time I'm trying it again. Opening tool, clicking "Retrieve data from EVE API" in log: "0 log entries deleted (auto purge)" in program status bar: "Done retriving data"
Then of course I go to menu/Wallet/Wallet transaction and: in log: "0 log entries deleted (auto purge)" in program: "0 wallet transactions found"
In cached XML API files I see relevant for current time cache record with query type "RefType".
But what is wrong? (well except the user :) )
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.21 17:15:00 -
[275]
Originally by: Andi Friend
But what is wrong? (well except the user :) )
The API server has some issues, it seems. -- EVEWalletAware - an offline wallet manager |
Michaellh
|
Posted - 2011.02.21 22:32:00 -
[276]
I duble checked everything an even reinstalled it but still no luck preventing the "Initialisation Failed
Error accessing database at the C:\ProgramData\EVEWalletAware\DATA. Application will now terminate"
Copied and pasted your suggestion to replace the "Connection=..." and still that does not work. I was able to actually edit it this time but even after changing it still I receive the same error. I made sure it as run in XP compatibility mode as well. Any other suggestions?
Mike
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.02.22 12:09:00 -
[277]
Ah, please, I'm not your personal IT consultant.
Try this setup (created with another installer package) and see if it doesn't mess things up on Vista/Win 7. -- EVEWalletAware - an offline wallet manager |
Michaellh
|
Posted - 2011.02.24 05:39:00 -
[278]
I never thought you were but since you seem to be the person that is head of the program I don't really have anyone else to turn too. I do apologize for bothering you but no the alternate setup you offered did not work. Never mind, I just won't worry about it.Thank you for trying.
Mike
|
Cpt Spooky
|
Posted - 2011.03.09 18:11:00 -
[279]
Hallo Hel O'Ween,
please make note on your page that the people have start with administrator-rights under xp and W7 otherwise they get the error:"Error accessing database at C:\ProgramData\EVEWalletAware\DATA\. Application will now terminate."
See Michaelh
greetings
|
You What
Smokers' Heaven
|
Posted - 2011.03.09 19:48:00 -
[280]
Originally by: Cpt Spooky Hallo Hel O'Ween,
please make note on your page that the people have start with administrator-rights under xp and W7 otherwise they get the error:"Error accessing database at C:\ProgramData\EVEWalletAware\DATA\. Application will now terminate."
See Michaelh
greetings
I agree.
Other than that, Great work and thank you for all your work you've put into it and for releasing it to the public for free. Thanks
|
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.10 08:41:00 -
[281]
Originally by: Cpt Spooky
please make note on your page that the people have start with administrator-rights under xp and W7 otherwise they get the error:"Error accessing database at C:\ProgramData\EVEWalletAware\DATA\. Application will now terminate."
Well, I know for sure that you don't need admin rights (besides from installing and updating the app itself) in XP, as I designed EWA to work without requiring admin rights. Data is stored where MS wants apps to store data: \All Users\Application Data\<your app>.
As for Vista/Win 7: Due to MS' approach to "redirect" folders ("Documents and Settings" became "Users" etc.), it seems that the OS "fools" the installer, when it queries for those folders from the OS. That's why the data ends app in folders it shouldn't and consequently admin rights seems to be needed. My installer predates Vista (which I skipped altogether) and I'm still not familiar enough with Win 7 to finally fix that behaviour. -- EVEWalletAware - an offline wallet manager |
Chick'n Nugget
|
Posted - 2011.03.16 14:54:00 -
[282]
Hel o'ween,
Thanks for the program. I have used it extensively and I really like some of the features, however, I am having a couple of problems.
The main problem seems to be that I cannot view "active" orders only. I think I am seeing all of my orders (since I started the database). I know this because the number only goes up and does not match the number in game. I see the filter for this but it is set to Active (which I assume is the default).
Also, if I try to change that filter to anything but active, the "end date" gets forced to 12/30/1899 and I cannot change it unless i set it back to active.
I would really like to *only* see active buy and sell orders and am not sure how to extract that data.
Thanks
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.16 17:28:00 -
[283]
Edited by: Hel O''Ween on 16/03/2011 17:28:57 If you're only interested in active orders, try the following:
- Go to Extras -> Options -> Tab "Wallet / Assets". Check the option "Import active market orders only"
- Next, go to Extras -> Database maintenace -> Compact database. There, choose "Delete market orders" and click OK.
- Pull your data from the API
This should get you rid off all old orders and from then on only import active market orders from the API. -- EVEWalletAware - an offline wallet manager |
Chick'n Nugget
|
Posted - 2011.03.16 17:47:00 -
[284]
I tend to use the functionality that shows how much profit I make per item, the high/low/average of buys/sells for an item and stuff like that.
I am not sure how it is programmed, but will doing what you suggested destroy this data?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.17 08:32:00 -
[285]
Edited by: Hel O''Ween on 17/03/2011 08:32:50 Hmm, not sure if I understand you. And in retrospective, my previous answer might not be the solution to your request.
Anything "balance-related" always is calculated on EWA's complete data set of that account/char. With the exception of market orders and assets, where the API always returns a complete set of *all* data, EWA doesn't delete any old data. That means all your wallet transactions and journal entries are kept. From those, EWA calculates the numbers in Item details, Balance sheet, Item chart etc.
From your last reply, it seems you're only interested in the numbers from your current/last successfully completed transactions.
If that's the case, well - EWA doesn't work that way. As discussed a number of times in this forum, CCP doesn't provide a way to track items in your assets, therefore you can't identify that item <x> was bought for amount <x> and sold for amount <y> and hence no dedicated profit calculation can be done for a distinct item.
EWA takes the approach of "no matter how many items you bought for <x> ISK, in the end, if you sold them for <y>, in order to be profitable, amount bought * <x> should be lesser than amount sold * <y>". And with that assumption, all numbers are calculated. -- EVEWalletAware - an offline wallet manager |
Chick'n Nugget
|
Posted - 2011.03.17 14:28:00 -
[286]
I will try to be as clear as possible so we are on the same page.
When I go to my buy or sell order page, the total listed at the top always increases each time I update the data, despite the fact that my active buy/sell order amount goes up and down all the time (as they expire, as they are bought out, etc...).
This leads me to believe that it is showing all orders from all time, not just the total of the active orders. The latter is what I want, but not all that I want.
I am fearful of compacting the db and deleting all of the orders because I do also use some other functionality that appears to look at past transactions to see how much profit you are making. Like I sort by the items that have made me the most total profit, most percentage profit, etc. . .
Does that make any more sense?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.17 17:50:00 -
[287]
Edited by: Hel O''Ween on 17/03/2011 17:50:36 Yes, makes perfect sense now.
That said, my first reply should solve your issue.
And don't worry. This will [i]only[/i ] delete all of your market orders (given that you checked "Delete market orders" and not one of the other options ). All other data (transactions, journals) will be kept in order to provide you with meaningful historic information. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.19 10:40:00 -
[288]
EWA version 2.0.22 has been released.
This update includes some administrative features, mainly
- Let you purge all data from within EWA, resetting EWA to a "fresh-installed" state (data-wise).
- If EWA can't find its database where it assumes it to be, EWA now lets you point it to the right DB location.
As always, see the version history for details. -- EVEWalletAware - an offline wallet manager |
Dawn Black
|
Posted - 2011.03.20 11:32:00 -
[289]
Minor thing... installer doesn't appear to create any shortcuts on win7... trying to look for the app now but it is a minor inconvenience
|
Companion Qube
Minmatar Electron Conservation Inc
|
Posted - 2011.03.20 11:39:00 -
[290]
Originally by: Hel O'Ween EWA version 2.0.22 has been released.
This update includes some administrative features, mainly
- Let you purge all data from within EWA, resetting EWA to a "fresh-installed" state (data-wise).
- If EWA can't find its database where it assumes it to be, EWA now lets you point it to the right DB location.
As always, see the version history for details.
Have I told you recently how much I appreciate the work you put in to this?
drunkpoasting best poasting |
|
Zeta Zhul
Caldari Preemptive Paranoia
|
Posted - 2011.03.20 17:11:00 -
[291]
Nice application.
Now could someone please explain to me why this is in MD and not in the technology forum?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.20 22:56:00 -
[292]
@CQ:
@Zeta Zhul: If you browse around this forum a bit, you will notice that the majority of the available trading tools are presented here. This makes sense as the targeted audience most likely will read this forum. If I'm not mistaken, the same is true for industrial tools, which are announced in S&I.
The Tech Lab to us 3rd party devs is more about questions/exchange around the API, not so much for presenting our tools. If I'm not mistaken, the Tech Lab forum is also one of the forums the average EVE player doesn't visit very often. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.27 12:33:00 -
[293]
This is a bit of an offtopic post, but I thought I'd share this with you nonetheless.
I attended FanFest this year for the first time and coincidentally this year was the first time that CCP devoted some sessions to the EVE API, some of which I of course attended. The perhaps most important info from these sessions is that 3rd party devs are now allowed to charge real cash for their applications. You need to apply as a 3rd party dev, fill out an agreement with CCP and pay $99/year. You're then free to charge whatever and however (one time fee, subscription etc.) you like for your tool(s).
According to CCP, the motivation for this decision is that they love all the 3rd party apps out there. The problem these days: as soon as the developer(s) stop playing EVE (for whatever reason), development on those tools also stops as there's no incentive for the dev to at least maintaining it although he doesn't play anymore. Not even talking about the impossibility of being able to test one's app without an active sub and therefore no access to the API.
I'm not sure how this step will influence the scene of 3rd party apps, but I suspect that some of the now free tools will be converted to payware. And of course, the more users a tool currently has (think: EVEMon, EFT, for example), the more tempting that idea may be.
That said, I personally have no interest in going commercial with EWA. It will remain a tool provided for free. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2011.03.30 22:08:00 -
[294]
Continuing a bit on your semi off topic remark I have to say I seriously support this. If this option had been around before we would still have EvE metrics, which may be one of the most important tools the market community has lost.
Glad to hear you aren't considering monetizing, but I want to add that if it comes down to monetizing or stopping supporting it I hope you choose the former, the free market will determine the value.
As forthe existing/old stuff there will be a lot of difficulties monetizing any app that had open source periods, or any app that borrowed from an existing open source app. Because of that I would seriously question whether older projects should monetize. Also, frankly, many of the existing apps have serious flaws (EMMAs horrible installation) that are acceptable on a free app, but definitely not on a Real Money app. Your project is one of the few that (I believe) has been closed source and had only one developer since the beginning, plus it is (for the most part) bug free.
Anyways. This has definitely got me thinkng about building something.
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.30 23:44:00 -
[295]
Originally by: Tehg Rhind
Your project is one of the few that (I believe) has been closed source and had only one developer since the beginning, plus it is (for the most part) bug free.
The source code for EWA has long been available from the download page, although I admit that I not always keep the published source code up to date with EWA's current published version. Out of laziness, obviously, not out of meanness. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2011.03.31 15:32:00 -
[296]
Originally by: Hel O'Ween
Originally by: Tehg Rhind
Your project is one of the few that (I believe) has been closed source and had only one developer since the beginning, plus it is (for the most part) bug free.
The source code for EWA has long been available from the download page, although I admit that I not always keep the published source code up to date with EWA's current published version. Out of laziness, obviously, not out of meanness.
well kiss my grits and call me a liar...my bad. Going to have to take a look at that (not to plagiarize, just curious).
Also, quick question on updates. I haven't updated in a long time as I use your app primarily for API calls. My version is pretty old, think I last updated in November. Have there been any DB breaking updates? What I mean is that if I update will I need to start with a fresh database, and/or loose all my old data?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.03.31 20:59:00 -
[297]
Originally by: Tehg Rhind
Going to have to take a look at that (not to plagiarize, just curious).
Wait a few days. Now that you mentioned it, I noticed I should upload an updated source package. Will need to do some cleaning (experimental stuff out) before I do so.
Quote:
What I mean is that if I update will I need to start with a fresh database, and/or loose all my old data?
It should be safe to update to the current version. If there's a database update, EWA always makes a backup of the old database first. In case the (automatic) update doesn't work, send me an email to [email protected] and I'll give you instructions on how to copy your old data over to the new database. -- EVEWalletAware - an offline wallet manager |
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.04.10 08:07:00 -
[298]
Edited by: Kethas Protagonist on 10/04/2011 08:07:58 I apologize for drudging up an old issue, but I'm experiencing the same "looping" problem posted about back in early 2010:
http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1263311&page=1#12
When I click "Retrieve data from EVE API," the status text at the bottom of the application reports "Processed personal wallet transaction #XXX for wallet 1000", progressing from 1 to 1000. When it reaches 1000 it pauses for a couple seconds and then starts again at 1.
While this is going on, the EWA application is unresponsive (the window doesn't respond to keypresses or mouse clicks and and cursor switches to a swirling "thinking" icon).
This is after a fresh install and running EWA as Adminstrator on Windows 7. You did reply to the original post on this issue, suspecting it was some sort of caching problem and asking if the poster was using a proxy (I'm not).
I also apologize for posting a bug report right as we're in between EVE forum versions - I'll repost on the new ones if CCP gets them working and we switch.
Edit: link linkified
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.04.10 16:07:00 -
[299]
Edited by: Hel O''Ween on 10/04/2011 16:08:21 No need to apologize. It's neither your nor my fault that we're "in between forums".
I think I know what's going on: with the new patch the wallet transactions API changed to behave like the (new) wallet journal API. I've updated EWA already - alas - the forums were down, so I decided to not publish a "silent update", but rather wait until I could also announce the new update in the (new) forum. This decision was also based on the fact that the change to the wallet transactions API would be backwards compatible. Well, from your report, it seems that's not the case.
So I beg your pardon and ask for your patience. I'll upload the new version tomorrow (Monday). In case the forums are in "maintenance mode" again, simply try EWA's update function an see if it reports a new version. The auto updater is new, too. If you're using it, make sure you update both EWA and the EWAAutoData. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.04.10 16:23:00 -
[300]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 10/04/2011 16:08:21 No need to apologize. It's neither your nor my fault that we're "in between forums".
I think I know what's going on: with the new patch the wallet transactions API changed to behave like the (new) wallet journal API. I've updated EWA already - alas - the forums were down, so I decided to not publish a "silent update", but rather wait until I could also announce the new update in the (new) forum. This decision was also based on the fact that the change to the wallet transactions API would be backwards compatible. Well, from your report, it seems that's not the case.
So I beg your pardon and ask for your patience. I'll upload the new version tomorrow (Monday). In case the forums are in "maintenance mode" again, simply try EWA's update function an see if it reports a new version. The auto updater is new, too. If you're using it, make sure you update both EWA and the EWAAutoData.
The same perma-loop issue struck EvE Income Analyzer, that unlike EWA, is not supported any longer. I patched EIA and posted a very long thread about how to get and install it. Of course right before CCP took the new forum offline.
If anyone wants to get a functioning version of EIA please read this page on Vahrokh.com and get it there.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.04.10 20:31:00 -
[301]
Ha! EVE Income Analyzer. That was the tool I used until I developed EWA. And I only did that, because EIA didn't support corporations. If it had done so, EWA mostly likely were never developed.
Good to hear that you gave some love to it. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.04.11 00:30:00 -
[302]
Originally by: Hel O'Ween Ha! EVE Income Analyzer. That was the tool I used until I developed EWA. And I only did that, because EIA didn't support corporations. If it had done so, EWA mostly likely were never developed.
Good to hear that you gave some love to it.
The fun part is that EIA supports corp wallets, it's only "just" impossible to tell it to use that because the UI never got finished. And considering it's 2.29am here and I am still far from done, I fear it won't be me to ever find the time to add new features.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.04.11 01:23:00 -
[303]
Originally by: Hel O'Ween <snip>
Thanks for the reply. I'll sit tight for the moment (clutching myself tightly and crying to sleep in the absence of a working wallet program, of course), update on Monday, and post here re: how it goes.
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.04.11 09:01:00 -
[304]
EWA version 2.0.23 has been released.
This update fixes the problem introduced with the wallet transaction API change in Incursion 1.4.1.
EWAAutoData also has been updated. If you're using the auto downloader, make sure to update both.
There's another tiny addition that sneaked it, as always, see the version history for details. -- EVEWalletAware - an offline wallet manager |
Osgilliath
|
Posted - 2011.04.23 09:20:00 -
[305]
Great program Hel O'Ween! You my friend have the makings of an awesome programmer! The scripting for this must have taken you quite a while! Keep up the great work! ^^
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.04.23 13:22:00 -
[306]
Thank you very much for the kind words.
Originally by: Osgilliath Edited by: Osgilliath on 23/04/2011 10:28:47 After some digging, your software is not calculating the first 5 transactions listed within my master wallet. The date of the transactions not included are from 3/14/2011 and 3/21/2011. The earliest transaction noted within the software is on 3/25/2011. Any reason why this might happen? An incorrect balance of 479,291 is not a big deal seeing as how I know where it isfrom. Just thought you might want to know! ^_^
Data from the API can only be retrieved max 1 month back. Unfortunately there's no way to get hold of older data from the API.
Quote:
After reloading my API key, I no longer can view wallets 4, 5, or 6 under the filters option when viewing the wallet journal. Did I inadvertently change something when reloading my api key?
The filters are populated with the available items only. If those wallet divisions are missing from the wallet journal filter, there isn't any journal entry for those wallets available form the API for that character/corporation. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission
|
Posted - 2011.05.04 09:43:00 -
[307]
It just was brought to my attention that I forgot to publish the new database, which includes the new items introduced with the Incursion expansion.
The DB update has been published now. EWA did not show trades with those items (Hardwirings, for example which can be puchased from the LP shop), but those trades aren't lost. As soon as you update to the new DB via EWA's built in update function, those transactions will show up in EWA.
I'm sorry for the inconvenience this might have caused. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.04 16:25:00 -
[308]
I have a problem.
Latest version, latest database, latest auto data downloader (got it manually today):
the counter runs till I read:
Processed personal wallet transaction #2560 for wallet 1000
then the status bar gets blank like it's about to go ahead but it restarts on the same wallet again and again and again (checked for 10 runs), "Update attempts" stays stuck at 0.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
Hel O'Ween
Men On A Mission
|
Posted - 2011.05.04 19:59:00 -
[309]
Hmm, this is strange as both apps share the exact same source code for handling the download/caching/storing to DB.
Can you please have a look at Documents and Settings\All Users\Application data\EVEWalletAware\LOGS ("Documents and settings" and "Application data" are localized if you're using a non-english Windows version).
That's the place where the log files are written. File names starting with "ewaad" are produced by the auto downloader. One file per run. Anything unusual in there except API warnings such as "Character must have Account ... roles"? -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.04 21:01:00 -
[310]
The TXT logs don't show anything that looks like an error.
The EWA Extras|Application log facility reports the following repeated errors:
Event ID Event Description 201 XMLError Error -2147220988 EvE API Error: 516, failed getting user information
201 XMLError Error -2147220988 EvE API Error: 516, failed getting user information
1001 ApplicationError frmMainHelper:MainWalletInfoFill->13,EvEWalletAware, Type mismatch
Notice that the other 3 applications I am using are loading everything just fine, API keys are copied off a TXT file.
Also, transactions and journal seem to appear (I don't know if they are all) in EWA.
It's just the standalone app that hangs (no crash, just repeats the same wallet API fetch forever).
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.05.05 10:03:00 -
[311]
Originally by: Vaerah Vahrokha
The EWA Extras|Application log facility reports the following repeated errors: [...]
This is nothing to worry about and not related to the issue you're experiencing. The above happens if you open EWA's Options dialog and switch fom one account/char to another. You will notice that the account dropdown box in the main window will become empty at some point (pointing to no specific account), but a change of the dropbox' value triggers the AccountBalance API download ... which subsequently fails, because currently no account is selected.
But back to the issue ...
Quote:
It's just the standalone app that hangs (no crash, just repeats the same wallet API fetch forever).
I'm still buffled as to what the cause could be. I've uploaded a new version of EWAAutoData, which plots some additional information to the log file. When downloading/processing wallet transactions, it adds one of the following two lines to the log, depending on which transactions it currently retrieves:
"Character - LastTransID: <number>, TransCount: <number>" - or - "Corporation - LastTransID: <number>, TransCount: <number>"
Within the same "turn", obviously LastTransID should be different at each try.
Could you give it a try? If you prefer to perhaps continue this conversation via email, feel free to contact me at [email protected] -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.05 15:39:00 -
[312]
Since I have to run 5 API apps per high frequency auditee a day, I have to wait till tomorrow before I am able to try it again. I will tell you how it goes directly on the forum.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.05.06 07:47:00 -
[313]
Ok I gave the new app a run and it worked!
It takes about 55 minutes to process 1 character in one account but it does not hang any more.
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
Hel O'Ween
Men On A Mission
|
Posted - 2011.05.06 10:27:00 -
[314]
Edited by: Hel O''Ween on 06/05/2011 10:28:22 OK, here's what I think might have happened: I didn't change anything in the way the download is handled, just inserted two lines to print to the log.
But the transaction API changed recently so that you now can retrieve data back one month (where it previously was one week max). And you could get the data in chunks of max 2560 entries per query.
So, if you have a char with lots of transactions, this could take quite some time (and tries) until all data is pulled. -- EVEWalletAware - an offline wallet manager |
Gormr
|
Posted - 2011.05.06 15:44:00 -
[315]
Hello,
I'm not sure if I'm doing something wrong but I allways get an error witch is the following,
Error accessing database at C:\ProgramData}EVEWalletAware\DATA\. Application will now terminate.
I'm runing 64 bit windows 7, thing is I got it to start when I downloaded the exe file but then it wont retreve api data and give me some other error. some thing you can help me do to fix this?
|
Hel O'Ween
Men On A Mission
|
Posted - 2011.05.06 20:25:00 -
[316]
Yeah, in this regard Win7 (and Vista) is a real PITA.
- Close EWA
- Search your harddrive for the file EVEWalletAware.mdb. If you find multiple files. You might find more than one file. The one in question should be located under C:\Users ...
- Open EVEWalletAware.ini with a text editor. Make sure the file location to the database under the section [Database] at the line starting with "Connection= ..." matches the file you found above.
- Start EWA
Also setting the compatibility for EWA to "Windows XP SP3" might help. -- EVEWalletAware - an offline wallet manager |
Humble Epidemic
Hyper-Nova
|
Posted - 2011.05.09 14:02:00 -
[317]
this could be really nice for mobile devices?? *hinthint*
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.09 23:55:00 -
[318]
Well, grab your Netbook and you're good to go.
On a more serious note: I don't do programming for mobile devices. -- EVEWalletAware - an offline wallet manager |
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.05.11 11:41:00 -
[319]
Edited by: Kethas Protagonist on 11/05/2011 11:44:55 Mrgh. Okay, I've tried to set up EWA again in preparation for reporting on a bond that's starting up, and I'm having similar problems as before:
1) The EWA client hangs when I click "Retrieve data from EVE API". As with VV, the client doesn't actually freeze, it just becomes unresponsive and loops "Processed personal wallet transaction #<1 through 2560> for wallet 1000" repeatedly.
2) Unlike before, when I force-quit EWA and restart the client, the most recent data that EWA should have just downloaded (repeatedly, apparently) is not reflected in EWA's data. I'm currently unable to view anything prior to edit: later than May 1st.
3) Having the .manifest file in the EWA installation directory doesn't prevent the UAC prompt.
4) If I run the EWA client in neither compatibility mode nor as an administrator, I get an "Error accessing database at C:\ProgramData\EVEWalletAware\DATA\. Application will now terminate" error. Running it either in WinXP SP3 compatibility mode or as an administrator results in a UAC prompt but lets the program start correctly.
5) The EWA autodownloader app exhibits similar looping behavior - it repeatedly processes transactions #1 through 2560. I'm not sure if this is actual erroneous redownloading of the same wallet transaction history, or just poorly-worded reporting of correct downloading of personal wallet transaction history THEN personal wallet journal history THEN corp wallet transaction history THEN etc. etc.
This is after updating to 2.0.23. I've verified that the .ini file at C:\ProgramData\EVEWalletAware has the correct path for EWA's .mdb file, specifically:
Quote: [Database] Connection=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\ProgramData\EVEWalletAware\DATA\EVEWalletAware.mdb;User Id=<snip>;Password=<snip>; Version=19 DatabasePath=C:\ProgramData\EVEWalletAware\DATA\
I'd like to troubleshoot this, and I suspect the first step is uninstalling 2.0.23 (and any possible remnants of 2.0.22) and making sure I have a clean install. EWA seems to (need to) put files in a lot of scattered directories - could you point out the places I need to clean up?
Thanks.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.12 10:47:00 -
[320]
OK, let's see:
- The long download for transactions is most likely a) correct and not an endless loop and b) caused by the recent changes to the Wallet Transaction API which lets you walk back one month (whreas previously you either got 1000 transactions or one week's worth of data, whatever happened first). The API seems to also "spit out" the data in a weird order (see tech lab for details). This never cuased trouble for EWA, as it always donwloads every available data and just ignores transactions already present in the DB. Other developers relied on the API to deliver "newest-to-oldest" by the API and suffered from this change.
- The database/INI thing with Vista and Windows 7 I have no idea how to prevent that. Both files (EVEWalletAware.mdb and EVEWalletAware.ini) or supposed to be in C:\users\All Users\Application Data\EVEWalletAware (the DB in a subfolder). This is where EWA looks after the INI and that's the place you should edit the connection string.
BTW, the connection string's UserID and PW are no secrect. The Db is unprotected and "admin" and <blank> are Access' default settings. You could as well delete both. -- EVEWalletAware - an offline wallet manager |
|
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.05.12 17:31:00 -
[321]
You're absolutely right. After letting EWA sit for longer it becomes responsive again and, as far as I can tell, has successfully downloaded wallet API information.
I apologize for taking up your time with a non-issue.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.12 21:21:00 -
[322]
No need to apologize, Kethas. That way other might read your question and my answer (which is full of typos, if I didn't know better, I'd say I was drunk when posting that ) and spare themselves the trouble. -- EVEWalletAware - an offline wallet manager |
SabotNoob
Sabot Industries
|
Posted - 2011.05.13 04:33:00 -
[323]
Not sure what my issue is, but my data isn't being imported.
My Account Name, User ID, and API Key fields are populated. Default account is checked off. It also retrieves my characters on the next tab over. I save my main as the default.
Going back to the Current Character window, I select my account and character, but nothing gets imported. It just shows 0.00 ISK.
What am I doin wrong? ____________________
Chuck Norris can win a game of Connect Four in three moves. |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.13 09:33:00 -
[324]
Edited by: Hel O''Ween on 13/05/2011 09:33:53 Just to make sure: you clicked that big button labeled "Retrieve data from EVE API"?
If so and nothing happens, are you running other apps (EVEMon, for example) which uses the API? If so, there might be a caching conflict. The API serves to one IP address. If one app grabs data, all other apps from the same IP (and for the same account) don't get (that API) data until the cache timer has expired. If EVEMon grabs your market orders, no other app will get them. If EWA grabs your transactions, no other app will get them. EVEMon fetching skill sheet and EWA going for transactions on the other hand is fine.
If you need to run multiple apps using the same API calls, check the EVE Tech Lab. There are some EVE API proxies available.
Also, check the application log (Extras -> Application log) for possible errors.
And last but not least sometimes the API servers are down (patch deployment for example) sometimes. Their outage is not necessarily the same as TQ's online status. -- EVEWalletAware - an offline wallet manager |
SabotNoob
Sabot Industries
|
Posted - 2011.05.13 15:43:00 -
[325]
Yes, I repeatedly hit the big button labeled "Retrieve data from EVE API".
I'm currently not running any other EVE apps.
Checking the log revealed some XML "Current security level not high enough" errors (about three of them in each instance I hit the button). I used your link to download the appropriate XML file, installed it, but it still yielded the same error.
I'm guessing it has to do with some XML setting?
____________________
Chuck Norris can win a game of Connect Four in three moves. |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.13 22:46:00 -
[326]
Originally by: SabotNoob
Checking the log revealed some XML "Current security level not high enough" errors (about three of them in each instance I hit the button).
Ermh, you're using your Full API key, right? Because only with the full API key, you're able to retrieve all trading relevant APIs (wallet journal & transaction, market orders). The Limited API unfortunately doesn't work with those APIs. There's has been a dev blog that this will change in the future, but until that happens the full API key is the way to go for trading apps. Well, anything beyond basic character info and skill sheet. -- EVEWalletAware - an offline wallet manager |
Holdas
|
Posted - 2011.05.13 23:02:00 -
[327]
How do I use this to see my profit? I tried setting up a virtual character but the information displayed is plainly wrong. It states I have lost a ridiculous amount of money, when in reality my money has gone up in the period. It also does not seem to remember the skills set for accounting and broker relations, and to always default to a character on the account other than the default one, leading me to delete all other characters in the account.
Is there an easy way to see a straight profit number instead of the graph in the quick view? I just can't figure this program out and the manual does not seem to be particularly helpful either.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.14 09:08:00 -
[328]
Edited by: Hel O''Ween on 14/05/2011 09:09:05 The quick view might "fool" you, just like the wallet transactions window, if you don't keep in mind that wallet transactions are plain sold/purchase information. It doesn't take your Margin Trading skill into account. Remember, the (first part) of your purchases will be sold using the escrow. Only after the escrow is spent, the remaining items will be sold using ISKs from your wallet.
So, if you're buying items, the transaction part of the quick view shows those as a negative numer (just like the ingame transaction view), whereas in reality no ISK were taken (yet) from your wallet, as the ISk have been payed upfront into escrow. This may result in a "loss" being displayed, although you're wallet has gone up in reality.
Your real wealth development is better reflected in the wallet journal, as any escrow payed when putting up a buy order is refelcted there.
Think of the transactions as a way to keep track of your margins (do you sell higher than you bought?).
I'm not sure if your "information displayed is plainly wrong" is also referring to the quick view, but that may explain it. The graphs shown are the transactions, not the journal. -- EVEWalletAware - an offline wallet manager |
Holdas
|
Posted - 2011.05.14 18:32:00 -
[329]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 14/05/2011 09:09:05 The quick view might "fool" you, just like the wallet transactions window, if you don't keep in mind that wallet transactions are plain sold/purchase information. It doesn't take your Margin Trading skill into account. Remember, the (first part) of your purchases will be sold using the escrow. Only after the escrow is spent, the remaining items will be sold using ISKs from your wallet.
So, if you're buying items, the transaction part of the quick view shows those as a negative numer (just like the ingame transaction view), whereas in reality no ISK were taken (yet) from your wallet, as the ISk have been payed upfront into escrow. This may result in a "loss" being displayed, although you're wallet has gone up in reality.
Your real wealth development is better reflected in the wallet journal, as any escrow payed when putting up a buy order is refelcted there.
Think of the transactions as a way to keep track of your margins (do you sell higher than you bought?).
I'm not sure if your "information displayed is plainly wrong" is also referring to the quick view, but that may explain it. The graphs shown are the transactions, not the journal.
You are correct, that was what I meant. Okay, things make more sense now.
What is the best way to easily see my profit for a given time period?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.15 10:05:00 -
[330]
Originally by: Holdas
What is the best way to easily see my profit for a given time period?
If you're after "real number", i.e. escrow and fees/taxes included, try Wallet -> Balance sheet -> By journal. You might want to tick "Market related only" to filter out non-trade related journal entries like agent mission rewards, bounties etc. However, just like the ingame journal, these are raw numbers. You don't see what's selling good this way.
If you're looking for profit on trades (did you make more oney selling an item than you payed for it), try Wallet -> Balance sheet -> By transactions. All items are listed there. For a breakdown of a specific item, try Wallet -> Item details.
But with EWA there are a couple of ways to skin the cat. Play around with it and see which of its options works best for you. I myself work mainly with the Wallet Transactions and Wallet Journal windows, for example. -- EVEWalletAware - an offline wallet manager |
|
Holdas
|
Posted - 2011.05.15 13:41:00 -
[331]
Originally by: Hel O'Ween
Originally by: Holdas
What is the best way to easily see my profit for a given time period?
If you're after "real number", i.e. escrow and fees/taxes included, try Wallet -> Balance sheet -> By journal. You might want to tick "Market related only" to filter out non-trade related journal entries like agent mission rewards, bounties etc. However, just like the ingame journal, these are raw numbers. You don't see what's selling good this way.
If you're looking for profit on trades (did you make more oney selling an item than you payed for it), try Wallet -> Balance sheet -> By transactions. All items are listed there. For a breakdown of a specific item, try Wallet -> Item details.
But with EWA there are a couple of ways to skin the cat. Play around with it and see which of its options works best for you. I myself work mainly with the Wallet Transactions and Wallet Journal windows, for example.
Yeah, I think that's what I was looking for. One of the views, journal balance, says that I have lost 80 billion since today last month (which is interesting as I have never had that amount of money, to my knowledge).
The other, says that I have made 3 billion. I think the discrepancy between this and other profit measuring sites like Eve profit probably comes from this program registering items when they are bought, not when they are sold, which means any number will always have the load of all the unsold inventory in it.
Is there a way to report that only takes into consideration items sold VS their purchase price, completely omitting items held, or used, but not sold?
Example: I buy a plex to consume, this is regustered in the program and will lower my profit stats on every other plex, if this is my only plex itll say profit is -100%, but this is ludicrous, for all intents and purposes this plex does not exist!
With the suggested reporting, I buy two plex, one to sell, one to consume, using isk. one of the two gets checked against the sale price, and the number for profit I get, is what remains of sell price - broker and whatever other relevant fees.
Plainly put, I don't know if I'm using the program wrong, but I know that I have neither lost 80 billion, nor only made 3. And the program lists inventory and items i used for consumption as loses when they have nothing to do with my trading activity. Is there a way to do what I ask that I haven't found? if not, I'd like to solicit it as a feature. I can't be the only person that would find utility in this.
|
Mikal Tash
|
Posted - 2011.05.15 21:07:00 -
[332]
Database Errors - My Story
I downloaded this tool to help me keep track of my trades, and to hopefully be able to review it later for analysis on profit and losses.
First thing, I downloaded full package installer and when I went to run the application I got "Database Errors" about not being able to connect.
So, I read over the 12 pages of comments so far... and was a little confused. I tried a buncha things following along as best I could above but I either kept screwing it up, or the information was outdated. Being half smart about these things I really didn't want to be beat by it so I kept at it and three hours later I have a process that works for the layman.
Uninstall whatever you got so far. Reinstall BUT change the location of the database DURING INSTALL When running the application select 'Run as Admin'
After everything else I tried, that's what worked for me.
I run Vista Ultimate.
I suspect the problem is Vista trying to get cute and hiding files under the offered folders for security reasons.
Now that I got the application working: I appreciate the effort that went into it, but I was a little disapointed with the accounting mechanisms. Profit/Loss calculations are really just running totals of purchases and sales so more like net cash flow. If this was offset with OnHand inventory figures it would make more sense.
My suggestion: After the user imports the data, allow for 'Blank all transactions' and allow the user to assign a starting inventory value for whatever they have, then every item that is purchased is added to inventory at that value and sold will generate a profit of selling price - average purchase price.
Anyway, I like what's there, but the profit figures are a bit off, but I'll allow the system to accumulate data for a longer period of time and hopefully it will be more useful to me over time.
4 stars from me to the developer.
(oh, annother suggestion - since it is somewhat unclear how to actually get it up and running once started, you might want to move the items that need to be setup to a setup page with Step1, Step2, Step3 ect where they get API, then update account API, then character, ect).
|
RaTTuS
BIG Gentlemen's Agreement
|
Posted - 2011.05.23 16:03:00 -
[333]
Originally by: Mikal Tash Stuff
All worked for me on Windows Vista 64... except that I get frmMainHelper:MainGetAPI->53, EWAAutoData, File not found: SNSCRC32.DLL when I run the Auto Updater
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.24 14:16:00 -
[334]
Edited by: Hel O''Ween on 24/05/2011 14:16:39
Originally by: RaTTuS
frmMainHelper:MainGetAPI->53, EWAAutoData, File not found: SNSCRC32.DLL when I run the Auto Updater
Make sure that this file is
a) present in EWA's installation folder b) you either run EWAAutoData from that folder or copy/move SNSCRC32.DLL to a folder within your PATH
If this file is missing from your machine, download it from http://eve.basicaware.de/DOWNLOAD/EVEWalletAware/snscrc32.dll -- EVEWalletAware - an offline wallet manager |
RaTTuS
BIG Gentlemen's Agreement
|
Posted - 2011.05.25 12:56:00 -
[335]
sorted - it was the running of the app from the same EWA install fold er that did it, the other options did not work
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.25 13:03:00 -
[336]
EWA version 2.0.24 along with a database update (version 21) has been released. You need to apply both updates in order for the new feature to work.
This new version lets you ignore wallet transactions, meaning those won't be shown anywhere nor used for calculations.
EWAAutoData hasen't been updated, as this is purely a change in how EWA handles existing data.
As always, see the version history for details. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.25 18:48:00 -
[337]
I just recognized that I uploaded the new version with the old version number(2.0.23 instead of 2.0.24). While it has the new functionality, checking for an update will always result in a notice about a newer version being available.
I'll fix that tomorrow. -- EVEWalletAware - an offline wallet manager |
Liberty Eternal
|
Posted - 2011.05.25 20:31:00 -
[338]
Thanks for a great program and the continued updates - EWA has been really useful to me and my trading. I've sent a small donation as a token of my gratitude, and I'm looking forward to seeing your future plans for the system.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.05.26 08:38:00 -
[339]
I've uploaded the new EXE with the right version information now. Please go ahead and (re)download the update.
@Liberty: Small donation, eh? You must be British, considering this blatant understatement.
Thanks a lot, much appretiated. -- EVEWalletAware - an offline wallet manager |
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.05 00:55:00 -
[340]
Heya Hel
I have another feature request - would it be possible to have the application throw an error message (both the auto-downloader) and the main client when there's a problem accessing the database? I've had a few instances where my machine crashed (yay overclocking) and left the db in an unusable state until I repaired with access. This is the situation I've encountered a couple times:
==================================================================================================== Date/Time: 6/4/2011 5:45:57 PM EventID : 105 Event : DBError ----- Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt. ==================================================================================================== Date/Time: 6/4/2011 5:45:57 PM EventID : 1001 Event : ApplicationError ----- cEVEWalletTransaction:Save->-2147467259, Microsoft JET Database Engine, Cannot open database ''. It may not be a database that your application recognizes, or the file may be corrupt.
It would be nice to have a notification when that occurs without having to go to the log - I often will just leave the auto-downloader running for weeks at a time without really doing any analysis only to find that I've been doing nothing but generating error messages for 2 weeks.
cheers!
...they see me trollin', they hatin' ♥
|
|
Izaac Newton
Caldari
|
Posted - 2011.06.05 13:01:00 -
[341]
Sorry but for the life of me I cant find where to hide the plex purchases?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.05 14:01:00 -
[342]
Edited by: Hel O''Ween on 05/06/2011 14:02:18 Hey CQ, long time no hear.
Originally by: Companion Qube
I have another feature request - would it be possible to have the application throw an error message (both the auto-downloader) and the main client when there's a problem accessing the database?
Yeah, I guess that sounds appropriate. Until then, fly ... erhm ... overclock safe.
Originally by: Izaac Newton Sorry but for the life of me I cant find where to hide the plex purchases?
- Make sure your version of EWA is the most current one as the "Ignore transactions" option (I guess that's what you're after) was added in the last release.
- Open the wallet transactions window. - Find your PLEX purchase in there. The easiest way to do so is to set the "Item" filter to "PLEX". (If you also sell PLEX set the "Transaction type" filter to "Buy") - Rightclick on the grid row with your PLEX purchase and select "Mark as ignored". -- EVEWalletAware - an offline wallet manager |
Izaac Newton
Caldari
|
Posted - 2011.06.05 14:32:00 -
[343]
Edited by: Izaac Newton on 05/06/2011 14:35:28 I have latest working version but the option is not in the menu there..
|
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.05 15:52:00 -
[344]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 05/06/2011 14:02:18 Hey CQ, long time no hear.
You know the rule, you never hear from satisfied customers
...they see me trollin', they hatin' ♥
|
Yutaka Kaikei
Caldari Pack Mule Courier Service
|
Posted - 2011.06.06 08:01:00 -
[345]
Edited by: Yutaka Kaikei on 06/06/2011 08:05:39 Hi Hel,
I've only just started using EWA recently, and I'm trying to use it to arrange some accountancy for my corporation. Nothing too flash, but I really need accurate totals for expense and revenue streams.
The issue I'm having is that large chunks of data are missing, and the totals for a couple of things are incorrect. The rental expenses were about 60% short of the actual figure, having missed some of the offices entirely. Wallet withdrawals, donations/deposits and sales taxes are not being listed at all. I've checked all these against the EVE ledger to get the accurate data, but I'm still about 890k short of actual income... and I'm concerned that the error may be in the totals for bounties and mission rewards/bonuses. Due to the massive number of entries in the journal for those income streams, I'm not inclined to trawl through them one by one to check them out - so I can't confirm that theory. I've looked everywhere else though.
Anyway, I'm just looking for a way to get reliable data, and EWA has all the functionality I want, excepting I'm experiencing incredible innaccuracy. I realise that these symptoms are very generic, but any help at all would be greatly appreciated.
Your program is obviously the best, and I would dearly love to be able to make use of it.
Thank Hel.
EDIT: The data for contract deposits is also being ignored, contract brokers fees are being missed in part also. If the agent mission rewards/bonuses/bounties are being captured correctly... they would actually be the ONLY data which is correct.
Great program, but I really need to fix this issue or accountancy goes right out the window. |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.06 10:44:00 -
[346]
Originally by: Izaac Newton Edited by: Izaac Newton on 05/06/2011 14:35:28 I have latest working version but the option is not in the menu there..
Just to make sure. - Your EWA version is 2.0.24? - Your DB version is 21? - We're both talking about the wallet transaction window? - Your popup menu looks different from this one, if you right click a row in the grid?
[Fake edit] Yes, I just updated that part of the manual -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.06 10:49:00 -
[347]
Originally by: Companion Qube You know the rule, you never hear from satisfied customers
Hmm, I thought this would be an easy fix. But as I was to about to add it, I realized that - due to the way the record adding/error logging stuff works in EWA - I would trigger a message box each single error (=each single record) = MASSIVE MESSAG BOX SPAM without you being able to stop it (except by killing the task).
This obviously needs some thinking ... -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.06 11:01:00 -
[348]
Originally by: Yutaka Kaikei
The issue I'm having is that large chunks of data are missing, and the totals for a couple of things are incorrect. The rental expenses were about 60% short of the actual figure, having missed some of the offices entirely. Wallet withdrawals, donations/deposits and sales taxes are not being listed at all. I've checked all these against the EVE ledger to get the accurate data, but I'm still about 890k short of actual income... and I'm concerned that the error may be in the totals for bounties and mission rewards/bonuses. Due to the massive number of entries in the journal for those income streams, I'm not inclined to trawl through them one by one to check them out - so I can't confirm that theory. I've looked everywhere else though.
Well, "missing" is quite a broad term with which I hardly can figure out your problem. There are some general points you need to know about the API which I might mention (again): - The API doesn't go as far back in time as your ingame wallet. Both wallet transactions and journals are restriced to 1 month worth of data - With the recent changes to the journal and transactions API, it seems that the API even then doesn't provide all available data with one fetch, but "catches up" if you query the same data again. So, I'd suggest you grab the auto downloader and let it run in the background a couple of hours and check your data again.
Also, it would be good to know which of EWA's options (wallet journal window, balance sheet ...) you're exactly using. Otherwise I'm a bit lost as to where to look at. -- EVEWalletAware - an offline wallet manager |
Yutaka Kaikei
Caldari Pack Mule Courier Service
|
Posted - 2011.06.06 12:15:00 -
[349]
Originally by: Hel O'Ween Well, "missing" is quite a broad term with which I hardly can figure out your problem. There are some general points you need to know about the API which I might mention (again): - The API doesn't go as far back in time as your ingame wallet. Both wallet transactions and journals are restriced to 1 month worth of data - With the recent changes to the journal and transactions API, it seems that the API even then doesn't provide all available data with one fetch, but "catches up" if you query the same data again. So, I'd suggest you grab the auto downloader and let it run in the background a couple of hours and check your data again.
Also, it would be good to know which of EWA's options (wallet journal window, balance sheet ...) you're exactly using. Otherwise I'm a bit lost as to where to look at.
Yeah, I know I'm giving you very little to work with here, but in all honesty I've got only very general symptoms with no obvious pattern. Your replies regarding the API month timeframe would seem to be the most likely culprit, which would theoretically have clipped the first 2 days of may's data.
I'm talking exclusively about the journal. I haven't paid attention, but I assume the wallet transaction list would be subject to the same timeframe, and therefore may have missing (outdated?) data also. A one ISK donation/corp acct withdrawal was done as a test in june, and that data comes up nicely, giving credence to your suggestion about the month timeframe.
Anyway, enough said, nothing to fix, the data is only good for 30 days and I understand that now. I'll just do my accounting fortnightly :)
Thanks Hel for your help, and the awesome program. |
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.07 06:34:00 -
[350]
Originally by: Hel O'Ween
Originally by: Companion Qube You know the rule, you never hear from satisfied customers
Hmm, I thought this would be an easy fix. But as I was to about to add it, I realized that - due to the way the record adding/error logging stuff works in EWA - I would trigger a message box each single error (=each single record) = MASSIVE MESSAG BOX SPAM without you being able to stop it (except by killing the task).
This obviously needs some thinking ...
Ahh, I haven't looked at the internals - sorry to cause a bunch of work :(
Total non-sequitur, do you happen to code with python as well? I'm going to be doing some work over the summer with it that you might find interesting. I'll share when I'm in progress and the program isn't just talk
...they see me trollin', they hatin' ♥
|
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.07 09:19:00 -
[351]
Originally by: Companion Qube
Total non-sequitur, do you happen to code with python as well? I'm going to be doing some work over the summer with it that you might find interesting. I'll share when I'm in progress and the program isn't just talk
No, I don't. A had a very brief look at Python a couple of weeks ago (spent a couple of hours reading about it and playing around with Entitiy's API wrapper), but haven't done some actual coding. And I most likely never will. -- EVEWalletAware - an offline wallet manager |
Companion Qube
Minmatar Electron Conservation Inc SRS.
|
Posted - 2011.06.16 22:45:00 -
[352]
Edited by: Companion Qube on 16/06/2011 22:48:52 Edited by: Companion Qube on 16/06/2011 22:46:51
Originally by: Hel O'Ween
Originally by: Companion Qube You know the rule, you never hear from satisfied customers
Hmm, I thought this would be an easy fix. But as I was to about to add it, I realized that - due to the way the record adding/error logging stuff works in EWA - I would trigger a message box each single error (=each single record) = MASSIVE MESSAG BOX SPAM without you being able to stop it (except by killing the task).
This obviously needs some thinking ...
Hmm, here's a one quick way to solve that (bad pseudocode follows)
global bool hackMsgBoxShown = false void resetFlag() { hackMsgBoxShown = false } void hackShowBox(string msg) { if hackMsgBoxShown return
hackMsgBoxShown = true msgbox.show(msg) ; bind resetFlag to the OK button }
Clearly not a "good" way to solve the problem, but a time effective one
This assumes that the box doesn't pause execution until the user presses OK, if it does .. then just reset the flag after the batch of DB work has been done and the boxes will be suppressed until then.
TBH I wish I could just patch this in and submit a diff to you, but VB6.... If I'm going to learn another language I'd rather not board the time machine to 1997
...they see me trollin', they hatin' ♥
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.18 00:38:00 -
[353]
Originally by: Companion Qube
Hmm, here's a one quick way to solve that (bad pseudocode follows)
global bool hackMsgBoxShown = false void resetFlag() { hackMsgBoxShown = false } void hackShowBox(string msg) { if hackMsgBoxShown return
hackMsgBoxShown = true msgbox.show(msg) ; bind resetFlag to the OK button }
Clearly not a "good" way to solve the problem, but a time effective one
Yeah, I was thinking of doing it exactly the same way. And while it might not be "good" (globals never are, right?), it's perhaps the only way to integrate it at this stage.
Quote:
[...] but VB6.... If I'm going to learn another language I'd rather not board the time machine to 1997
Haha. And rightly so! -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.18 08:55:00 -
[354]
Ahhh, boy, do I hate it.
This new dev blog migh be of interest to you guys, too.
TL;DR Market Order API will only return active market orders.
Which is terribly annoying as I've just finally gotten around to implement an order alert feature which would let you see which orders changed their state between two API data queries. Basically the most common state would be a change from "Active" to "Expired/Fullfilled". That way you would have an easier way to figure out when and what to restock.
If the API change in the above linked dev blog goes through as it is, I can completely scrap anything I coded. -- EVEWalletAware - an offline wallet manager |
damnjita
|
Posted - 2011.06.23 01:46:00 -
[355]
Is there any way to download previous versions? 2.0.21 is still working fine for me but 2.0.24 is not retrieving my data since the patch, however the change log of 2.0.23 looks like something I should update to.
|
Nikki Sanderson
|
Posted - 2011.06.23 07:42:00 -
[356]
Same here, it attempts to download and just stops after 99 market orders I think. The application log states
"cEVEWalletTransactionUtil:GetWalletTransactionCharXML->6, EVEWalletAware, _berlauf" (= overflow)
EWA Version 2.0.24, DB Version 21
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.23 17:00:00 -
[357]
Incarna introduced a change to the API (basically making more room for upcoming IDs).
I had to change both the application and the database for this. I haven't published the new version yet, as I hoped CCP would publish the new database dump for Incarna pretty close to the Incarna release itself and I could just publish *one* database update with both included (changes to the API and new Incarna items), but - hey - CCP had better things to do, like coming up with a way of slapping long established 3rd party devs right in the face. -- EVEWalletAware - an offline wallet manager |
Lauren Hellfury
Full Pocket Aggro
|
Posted - 2011.06.23 19:29:00 -
[358]
Hel, are you boycotting development over this or are we just waiting on CCP to release the Incarna DB?
|
Dethmourne Silvermane
Gallente Saiph Industries SRS.
|
Posted - 2011.06.23 20:06:00 -
[359]
I support Hel's right to boycott CCP through development stoppage, if he so chooses.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.24 09:01:00 -
[360]
I'm not currently boycotting CCP as things are still the way as they were in the past.
My thoughts are that I give CCP a grace period for publishing the new DB dump 'til next week (1 week after Incarna release). If there's still no new DB dump up, I'll release my new version and issue another DB update after CCP published Incarna data.
That said, the whole situation / state of the game / behavior of CCP within the last months is not exactly what I sense as "motivating". And this not just because of the 3rd party license stuff. For me it started with the security debacle of the new forums. It continued through the Incursion patchfest, the 3rd party licensing and finally peaked into the whole MT and CQ stuff.
My machine goes crazy while I'm docked. And I'm someone who doesn't care about shiny GFX. Since I started playing EVE more than 5 years ago, I have always turn my GFX settings to "low" and disabled all effects. Still my machine vents like an old steamboat.
<rant off /> -- EVEWalletAware - an offline wallet manager |
|
Smarcus Smokus
|
Posted - 2011.06.24 15:14:00 -
[361]
I am eagerly awaiting the next release.
Thank you very much for all your hard work in making such a great application!
|
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.06.26 23:53:00 -
[362]
Originally by: Hel O'Ween My machine goes crazy while I'm docked. And I'm someone who doesn't care about shiny GFX.
This isn't entirely on-topic, but you might not know that you can disable Captain's Quarters and just be presented with a static background image when docked. It's in your options under Display & Graphics -> Graphic Content Settings (the right column) -> Load Station Environment (the last checkbox of the four).
It's my understanding that, as currently planned, CQ will not be optional/toggleable in this fashion, but that's another discussion. For now, you can disable it.
More on topic: just to be clear, the reason EWA isn't currently downloading market information is because of Incarna's API change that you mention in this post, and the next EWA version, which you're waiting to release until CCP releases their DB dump, will fix it, correct? I totally understand the rationale behind waiting, I just want to be sure I understand why EWA isn't currently working for me.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.27 15:31:00 -
[363]
Originally by: Kethas Protagonist
More on topic: just to be clear, the reason EWA isn't currently downloading market information is because of Incarna's API change that you mention in this post, and the next EWA version, which you're waiting to release until CCP releases their DB dump, will fix it, correct? I totally understand the rationale behind waiting, I just want to be sure I understand why EWA isn't currently working for me.
Exactly. As with the wallet journal in a previous expansion, CCP extended the data type for the ID fields in both wallet transactions and market orders with the release of Incarna.
Unfortunately, this requires a change for EWA in both the app and the DB, otherwise I would have published the update last week already.
If CCP hasn't published a DB dump by tomorrow's DT (which I don't think will be the case), I'll go ahead and release the new update.
tl;dr: You'll get a new release tomorrow, most likely followed by another database update within some days, which then includes the new Incarna items. -- EVEWalletAware - an offline wallet manager |
Liberty Eternal
|
Posted - 2011.06.27 15:41:00 -
[364]
Thank-you Hel O'Ween - it will be great to have EWA back online and functioning again.
|
Solstice Project
|
Posted - 2011.06.27 17:28:00 -
[365]
Hi. :)
Downloaded your program today and wanted to give it a try.
Don't know if it's posted already, but it seems there's an issue with Admin-rights when trying to access the mdb-file.
Anyway, i moved the whole directory somewhere else and applied compatibility-mode (XP SP3) to it, then it worked without any problem.
Well ... unless i want to do anything, because CCP broke your program. ^^
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.28 09:57:00 -
[366]
Edited by: Hel O''Ween on 28/06/2011 10:00:32 EWA version 2.0.25, EWAAutoData 1.0.19, DB 22 have been released.
This update implements the API changes introduced with Incarna.
In case you're not aware of it: with Incarna, the Market Order API was changed to only return active orders.
This is very bad in two ways. In general, you can't get any information about expired (read: needs to be restocked) orders any more. Specifically for EWA: I already had a new feature implemented, which would notify you of expired orders. The logic had been implemented, just the screens had to be finished. A couple of days woth of work for the trash bin ...
If you want to raise your concerns re. only active market orders from the API, use this thread and make yourself heard.
As always, see the version history for details.
[Added] CCP has not published the official Incarna database dump, yet. This means two things:
1) Another EWA database update is due in the hopefully not so far future. 2) Any NEx items you already traded will not show up until that DB update has arrived. However, those records are not lost, they simply don't show up until they can be properly referenced in the database. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.06.28 11:56:00 -
[367]
Does it mean that if I need to audit the last 30 days of a trader, I won't be able to see his closed orders any more?
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.28 15:16:00 -
[368]
Edited by: Hel O''Ween on 28/06/2011 15:18:27 Exactly.
Previously the API returned market orders with the following flags:
0 - Active 1 - Closed 2 - Expired/Fulfilled 3 - Cancelled 4 - Pending 5 - Character deleted
(Note: I've personally never have seen other states than Active and Expired/Fulfilled)
Due to "heavy API load", CCP - in all of its wisdom - decided to remove any market order from the API data with a state other than 0 - Active. Go figure ...
You still see the journal/transaction entries for the fulfilled past orders. But building up a market order history out of those is a bit clumsy. -- EVEWalletAware - an offline wallet manager |
Vaerah Vahrokha
Minmatar Vahrokh Consulting
|
Posted - 2011.06.28 17:29:00 -
[369]
Originally by: Hel O'Ween Edited by: Hel O''Ween on 28/06/2011 15:18:27 Exactly.
Previously the API returned market orders with the following flags:
0 - Active 1 - Closed 2 - Expired/Fulfilled 3 - Cancelled 4 - Pending 5 - Character deleted
(Note: I've personally never have seen other states than Active and Expired/Fulfilled)
Due to "heavy API load", CCP - in all of its wisdom - decided to remove any market order from the API data with a state other than 0 - Active. Go figure ...
You still see the journal/transaction entries for the fulfilled past orders. But building up a market order history out of those is a bit clumsy.
Ok, so far I have called idiots 3-4 CCP departments, I'll add a fifth. How can they be so inconceivably bad
Auditing | Research | 3rd Party | Collateral Holding | EvE RL Charity |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.28 19:25:00 -
[370]
Originally by: Vaerah Vahrokha
Ok, so far I have called idiots 3-4 CCP departments, I'll add a fifth. How can they be so inconceivably bad
Well, there's hope. From the above linked thread:
Originally by: CCP Elerhino
Edited by: CCP Elerhino on 27/06/2011 10:03:04 We've been looking into the MarketOrder issue but finding a solution that is both simple and optimal has proven difficult. The reason is the nature of market orders, specifically how dates are stored and how they change and how the data can be retrieved in a cost-effective way. Basically us API people are arguing for simple but the DB team understandably wants optimal. Right now it looks like we'll do paging, something like the wallet transaction API, we hope that will solve the problem even though it might cost you guys some extra work. I was hoping for something simpler, e.g. include a week or a month of expired orders in the list but, like I wrote, that solution is not optimal from a DB standpoint. We'll get a solution ready as soon as possible, hopefully within the next few weeks.
-- EVEWalletAware - an offline wallet manager |
|
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.06.28 22:23:00 -
[371]
Unfortunately I'm still unable to retrieve data more recent than June 18th.
I downloaded the new .exe and replaced the old .exe with it. I didn't update anything else.
? -> About says that my EWA version is 2.0.25 and my DB version is 21.
When I select an account and character and click "Retrieve data from EVE API", it cycles from "Processing wallet transaction #<1 through 2650> on wallet 1000" or something similar, pauses, cycles #2651 through 5120, pauses, cycles 5121 through 7900-something, and then finishes.
However, when I then open my Wallet Transactions or Wallet Journal pages, I'm not shown any transactions more recent than June 18th, the last date I had transaction information for prior to the Incarna patch and subsequent EWA-breakage. Additionally, opening up the Application Log shows a stream of pairs of INSERT INTO (commands? errors?) and Microsoft JET Database Engine overflow errors:
Link 1 Link 2
Finally, EWA does appear to be successfully modifying the .mdb file where my wallet information is stored (namely, C:\ProgramData\EVEWalletAware\DATA\EVEWalletAware.mdb), based on the Last Modified timestamp in Windows Explorer.
If you need more information to troubleshoot or if I can help in any way, please let me know. Your services in providing and updating EWA are greatly appreciated - CCP should be offering to pay you, not requiring the opposite.
(Obviously I'm making so much money that a mere 64-bit OS can't handle it.)
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.06.29 08:23:00 -
[372]
You must also update the DB.
And those errors happen because of an old database, where EWA tries to store bigger values (byte-wise) than that column in the DB can hold. -- EVEWalletAware - an offline wallet manager |
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.06.29 09:41:00 -
[373]
Sigh. Duh.
? -> "Check for update" even handles downloading the new DB for you. I assumed it only handled .exe updates. Well, I feel sheepish.
Thanks, it's working perfectly now.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.02 09:30:00 -
[374]
CCP has finally released the Incarna database dump, so I had a chance to update EWA's DB.
Use EWA's update function to retrieve the new DB (version 23, Incarna).
This is only a database update. -- EVEWalletAware - an offline wallet manager |
Commander Disarray
|
Posted - 2011.07.13 15:12:00 -
[375]
I don't know if this issue came up earlier but I'm not able to retrieve my wallet journal. I can, however, retrieve wallet transactions. I'm trying to look into my profits and I think journal is where to look, correct? I provided my full API key when I installed it this morning but haven't had enough time to play around with it yet.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.13 21:34:00 -
[376]
There seem to be some issued with the wallet journal API lately. Over in the Tech Lab, a few player mentioned that they can't retrieve journal data correctly. I also had a case these days were instead of getting journal data, an error was returned by the API, with error number 0 (doesn't exist according to the docs ...) and some error message along the lines of me harassing Scotty ...
See Extras -> Cached XML files if there's a wallet journal entry present and if it holds any meaningful data.
That said, wallet journal is what your ingame wallet journal shows you, just like wallet transactions. So for pure trade profits, I'd say the transactions are more appropriate. For a broad overview of profits, Balance sheet -> Wallet transactions seems to a good start. -- EVEWalletAware - an offline wallet manager |
damnjita
|
Posted - 2011.07.14 07:26:00 -
[377]
Edited by: damnjita on 14/07/2011 07:26:44
Originally by: Hel O'Ween There seem to be some issued with the wallet journal API lately. Over in the Tech Lab, a few player mentioned that they can't retrieve journal data correctly. I also had a case these days were instead of getting journal data, an error was returned by the API, with error number 0 (doesn't exist according to the docs ...) and some error message along the lines of me harassing Scotty ...
<?xml version="1.0"?>, <eveapi version="2">, <currentTime>2011-07-14 07:24:23</currentTime>, <error code="0">General Error: Scotty the docking manager heard you were talking **** about him behind his back and refuses to service your request.</error>, <cachedUntil>2011-07-14 08:24:23</cachedUntil>, </eveapi>,
edit: so the forums censor **** but its ok in the API?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.14 09:48:00 -
[378]
Originally by: damnjita Edited by: damnjita on 14/07/2011 07:26:44
Originally by: Hel O'Ween There seem to be some issued with the wallet journal API lately. Over in the Tech Lab, a few player mentioned that they can't retrieve journal data correctly. I also had a case these days were instead of getting journal data, an error was returned by the API, with error number 0 (doesn't exist according to the docs ...) and some error message along the lines of me harassing Scotty ...
<?xml version="1.0"?>, <eveapi version="2">, <currentTime>2011-07-14 07:24:23</currentTime>, <error code="0">General Error: Scotty the docking manager heard you were talking **** about him behind his back and refuses to service your request.</error>, <cachedUntil>2011-07-14 08:24:23</cachedUntil>, </eveapi>,
edit: so the forums censor **** but its ok in the API?
Yepp, that's the one I mentioned above. Another try a day later downloaded the journal just fine for me.
And please note the <error code="0">. Compare that the the error list that the API is supposed to report: http://wiki.eve-id.net/APIv2_Eve_ErrorList_XML. -- EVEWalletAware - an offline wallet manager |
Valemora
|
Posted - 2011.07.15 16:07:00 -
[379]
Having an issue here. "error accessing database"...Do you wish to browse for EWA's database?" I click yes, and select the database, but it continues to "lose" it or whatever. This is off a new install, windows 7, I saw a mention of it earlier, and tried to fix with no luck. |
Valemora
|
Posted - 2011.07.15 16:14:00 -
[380]
Originally by: Valemora Having an issue here. "error accessing database"...Do you wish to browse for EWA's database?" I click yes, and select the database, but it continues to "lose" it or whatever. This is off a new install, windows 7, I saw a mention of it earlier, and tried to fix with no luck.
Would still like a fix, but I installed it on a flash drive and it seems receptive to the idea..go figure >< |
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.16 06:33:00 -
[381]
Originally by: Valemora Having an issue here. "error accessing database"...Do you wish to browse for EWA's database?" I click yes, and select the database, but it continues to "lose" it or whatever. This is off a new install, windows 7, I saw a mention of it earlier, and tried to fix with no luck.
Well, this report at least shows me that my intended fix works. Before that, EWA would just crash.
Now, as for the problem: as mentioned a couple of times, Win 7 does some weird things with paths. If you search your hard drive for EVEWalletAware.mdb, you will find at least two locations. One in ProgramData. That's probably the one you choose. But there should be another one located in Users\AppData. That's the one to use. -- EVEWalletAware - an offline wallet manager |
damnjita
|
Posted - 2011.07.22 19:45:00 -
[382]
Customizable API keys coming Aug 30th after which anyone who changes their API will no longer be able to use the old system.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.22 21:57:00 -
[383]
Care to share your source? I don't see a new dev blog. -- EVEWalletAware - an offline wallet manager |
Lauren Hellfury
Full Pocket Aggro
|
Posted - 2011.07.22 22:31:00 -
[384]
Linkage
Note that they will be running both for a while so it won't be such an issue.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.23 10:54:00 -
[385]
Ah, thanks, Lauren. This escaped me somehow. -- EVEWalletAware - an offline wallet manager |
Shadow First
|
Posted - 2011.07.24 07:00:00 -
[386]
Originally by: Hel O'Ween There seem to be some issued with the wallet journal API lately. Over in the Tech Lab, a few player mentioned that they can't retrieve journal data correctly. I also had a case these days were instead of getting journal data, an error was returned by the API, with error number 0 (doesn't exist according to the docs ...) and some error message along the lines of me harassing Scotty ...
See Extras -> Cached XML files if there's a wallet journal entry present and if it holds any meaningful data.
That said, wallet journal is what your ingame wallet journal shows you, just like wallet transactions. So for pure trade profits, I'd say the transactions are more appropriate. For a broad overview of profits, Balance sheet -> Wallet transactions seems to a good start.
Same problem here with Scotty since 10/06/2011 but only with my personal data, the corporation one is fine ! The journal is interesting if you have other income like contracts trading wich are not in the transaction report... Is this API bug to be adressed ?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.25 08:59:00 -
[387]
Originally by: Shadow First Is this API bug to be adressed ?
You need to ask CCP about this. Numerous forum and bug reports have gone unanswered so far. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.07.26 10:17:00 -
[388]
Oh boy, I just took a closer look at the new API key system and realized that it breaks EWA in so many places.
While I was one of the first guys to lobby for customizable API keys, the way it's implemented, or rather the way the old system with Limited/Full keys was implemented, hurts me badly. Don't take me wrong, I'm not blaming CCP for this. But from a first glance at it, the amount of work needed to implement this change isn't funny. |
Frater Patroabo
Gallente Offworld Miners and Fabricators Guild
|
Posted - 2011.08.01 22:38:00 -
[389]
I'm also having the .mdb file issue as noted above, but was unable to find the file under Users. Reading that there is a major API change in the very near future, I will wait until you have had time to redo EWA and try again. I hope you do, because I'm very keen to use EWA. Thank you for all your work. [Resolved: That any further use of the term "YARR!" will result in loss of 100 million skill points and confinement to a newbie ship for one year.] |
Quakar
|
Posted - 2011.08.02 02:49:00 -
[390]
Originally by: Frater Patroabo I'm also having the .mdb file issue as noted above, but was unable to find the file under Users. Reading that there is a major API change in the very near future, I will wait until you have had time to redo EWA and try again. I hope you do, because I'm very keen to use EWA. Thank you for all your work.
Also unable to find the .mdb file any ware under C:\users\[username]\appdata (checking in Local, roaming, ext as well)
|
|
MegabitOne
Caldari The Black Ops
|
Posted - 2011.08.02 21:53:00 -
[391]
Originally by: Quakar
Originally by: Frater Patroabo I'm also having the .mdb file issue as noted above, but was unable to find the file under Users. Reading that there is a major API change in the very near future, I will wait until you have had time to redo EWA and try again. I hope you do, because I'm very keen to use EWA. Thank you for all your work.
Also unable to find the .mdb file any ware under C:\users\[username]\appdata (checking in Local, roaming, ext as well)
I have two copies on my machine: one in C:\ProgramData\EVEWalletAware\DATA and another one in C:\Users\All Users\EVEWalletAware\DATA. Neither of 'm seems to work. I always get the 'Do you wish to browse...' message at startup, always mentioning the first of the paths above. I can choose the second one, but then it asks me to restart EWA (it really shouldn't since no database has been opened yet, right?!??), but in vain: it stubbornly keeps asking me to identify the path on start-up
Can you please write a decent installation routine? --- 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 =- |
Dirk Decibel
|
Posted - 2011.08.04 15:08:00 -
[392]
Edited by: Dirk Decibel on 04/08/2011 15:16:31
Originally by: MegabitOne
Originally by: Quakar
Originally by: Frater Patroabo I'm also having the .mdb file issue as noted above, but was unable to find the file under Users. Reading that there is a major API change in the very near future, I will wait until you have had time to redo EWA and try again. I hope you do, because I'm very keen to use EWA. Thank you for all your work.
Also unable to find the .mdb file any ware under C:\users\[username]\appdata (checking in Local, roaming, ext as well)
I have two copies on my machine: one in C:\ProgramData\EVEWalletAware\DATA and another one in C:\Users\All Users\EVEWalletAware\DATA. Neither of 'm seems to work. I always get the 'Do you wish to browse...' message at startup, always mentioning the first of the paths above. I can choose the second one, but then it asks me to restart EWA (it really shouldn't since no database has been opened yet, right?!??), but in vain: it stubbornly keeps asking me to identify the path on start-up
Can you please write a decent installation routine?
Same problem here, running windows 7, tried the 2 different database locations, neither of them works :(
Too bad. Looked like a great program.
Edit: are there any ppl here that managed to get it running on Win7 at all btw?
|
Dirk Decibel
|
Posted - 2011.08.05 09:38:00 -
[393]
My incredible tiny brain took 3 days to think of switching to windows XP mode for EWA. It seems to do the trick though. Program just launched.
|
Commander Disarray
|
Posted - 2011.08.09 02:14:00 -
[394]
Edited by: Commander Disarray on 09/08/2011 02:14:42 Possibly stupid question, but I'm trying to figure out what two columns represent in the wallet transactions window. I'm looking at the Price and Total columns.
Say I have a Cap Recharger II that shows like this under their respective columns:
Price -473,088.15
Total -477,109.40
Now, does this mean that my buy order was -473,088.15, and the total that I paid for it, which includes tax, broker fees, and change orders was -477,109.40 ???? Is that what it means?
Let's say I have a sell order that shows like this:
Price 542,984.95
Total 534,568.68
I think that may mean that I sold the item for the amount listed under price, but my total cost is the amount that's listed under Total?
That's confusing because I don't think my margin was THAT bad...
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.09 08:51:00 -
[395]
Originally by: Commander Disarray
Say I have a Cap Recharger II that shows like this under their respective columns:
Price -473,088.15
Total -477,109.40
Now, does this mean that my buy order was -473,088.15, and the total that I paid for it, which includes tax, broker fees, and change orders was -477,109.40 ???? Is that what it means?
Yes, but without fees for changing orders. There's currently no way of linking those to a specific transaction.
Quote:
Price 542,984.95
Total 534,568.68
I think that may mean that I sold the item for the amount listed under price, but my total cost is the amount that's listed under Total?
Right again.
Quote:
That's confusing because I don't think my margin was THAT bad...
Keep two things in mind:
1) make sure you have set the skill levels for Broker Relation etc. right for that character (see Extras -> Options)
2) EWA estimates fees & taxes. While EWA gets the bare percentages right for the skills involved, it doesn't take your standing towards the NPC corp at the station where the transaction took place into account. It therefore assumes a standing of 0. You're real margin is most likely better than the one calculated by EWA. -- EVEWalletAware - an offline wallet manager |
Commander Disarray
|
Posted - 2011.08.09 15:03:00 -
[396]
Originally by: Hel O'Ween
Keep two things in mind:
1) make sure you have set the skill levels for Broker Relation etc. right for that character (see Extras -> Options)
2) EWA estimates fees & taxes. While EWA gets the bare percentages right for the skills involved, it doesn't take your standing towards the NPC corp at the station where the transaction took place into account. It therefore assumes a standing of 0. You're real margin is most likely better than the one calculated by EWA.
That was my guess. Is there any way to add in a feature that will allow you to input your tax and broker rates? I'm guessing that would be kind of a huge undertaking because one would have to enter it in for every station he/she buys/sells at. Plus on your end too.
Ok assuming you can't do that, I guess this will involve some math, and another app called EVE Mentat. My goal is to figure out net profits and I'm having a hell of a time doing that.
I can't use the app right now, but is there a way to have the Total column just report what the Buy price was (without fees/taxes) for items for a given period of time? Like for a Cap Recharger II, I'd just like it to say that the Price was 520,000 and the Total without fees and taxes was 500,000. I think if it can do that, then I can get a gross profit for each item during a given period of time. EVE Mentat does not do that for each item; it is not able to calculate a sold item's buy price.
I can, however, use EVE Mentat to sum up all of my change orders, taxes, and fees for that same period of time and deduct that from my gross sales which I derive from WalletAware.
Does that sound right? Could I potentially come up with an accurate net profit number with that process? I guess it would depend on WalletAware's ability to be able to exclude fees/taxes out of the Total column and just have the item's buy price. If it doesn't do that already, would it be a great hassle to add that in?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.09 15:58:00 -
[397]
Edited by: Hel O''Ween on 09/08/2011 15:59:39 I guess you should spent some time digging through the options and filters.
Originally by: Commander Disarray
I can't use the app right now, but is there a way to have the Total column just report what the Buy price was (without fees/taxes) for items for a given period of time? Like for a Cap Recharger II, I'd just like it to say that the Price was 520,000 and the Total without fees and taxes was 500,000.
Yes. Disable broker fees and sales tax estimation in the options (Extras -> Options -> tab "Wallet / Assets") and in the wallet transaction window set the filter "Transaction Type" to "Buy" and "Item" to "Cap Recharger II".
Quote:
I can, however, use EVE Mentat to sum up all of my change orders, taxes, and fees for that same period of time and deduct that from my gross sales which I derive from WalletAware.
You can do the same filtering in the wallet journal window. There's also the two Balance sheets.
I admit the EWA menawhile is a "beast" in the sense that there are a couple of ways to skin the cat. You just need to find out which way is the best for you. -- EVEWalletAware - an offline wallet manager |
Commander Disarray
|
Posted - 2011.08.09 16:26:00 -
[398]
Just one slight issue, the Wallet Journal isn't opening for me. I tried it last night and nothing happens. I think it was mentioned here before, not too many posts ago, and you had said there's an issue with it. I may have missed an update, or is it still experiencing issues?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.09 21:18:00 -
[399]
The issue still persists. Sometimes the (wallet journal) API returns results, sometimes an error. Just try downloading it again. It often doesn't work for the first try for me, querying it a second time works. But that might just be coincidence ... -- EVEWalletAware - an offline wallet manager |
Commander Disarray
|
Posted - 2011.08.10 01:27:00 -
[400]
Ok, I'm trying what you suggested above.
I went and disabled tax and fee estimation. What this did is it makes the Total column match the Price column. My guess is that the estimates (when activated in Options) reduce the Total column based on the skill levels you input, to kind of give you a rough net profit if you subtract Total from Price.
What I was looking for is a way to link each item sold to its own buy price, side-by-side. Disabling the tax/fee estimates doesn't do this. I was hoping that by disabling them, all I would be left with is the price at which the item was bought to appear in the Total column, next to the price it was sold, in the Price column.
This way I can subtract the price at which an item was bought, from the price that it was sold, to get a gross profit.
Changing the transaction type filter to Buy displays all the items that were bought, but still shows identical figures in Price/Total columns.
Do you see where I'm going? I think the core issue here is how do you link an items buy price to its sell price. That's the only true way you can derive net from, that I know of...
|
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.10 08:49:00 -
[401]
Originally by: Commander Disarray
My guess is that the estimates (when activated in Options) reduce the Total column based on the skill levels you input, to kind of give you a rough net profit if you subtract Total from Price.
Why guess? I linked the relevant manual part where this is explained.
Quote:
Do you see where I'm going? I think the core issue here is how do you link an items buy price to its sell price. That's the only true way you can derive net from, that I know of...
Yeah, I see where you're going: you haven't read this thread as this has been asked and explained numerous times: there is currently no way of proper linking a) transactions vs. journal entries (transactions + fess/taxes) and b) identifying unique items so that you could link the purchase (price) of an item to it's sale (price).
A couple of the trader apps do some guesswork there, working with a FIFO approach, and try to link buy vs. sale. But for my taste that's too vague. -- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.10 14:34:00 -
[402]
Originally by: Hel O'Ween
Originally by: damnjita Edited by: damnjita on 14/07/2011 07:26:44
Originally by: Hel O'Ween There seem to be some issued with the wallet journal API lately. Over in the Tech Lab, a few player mentioned that they can't retrieve journal data correctly. I also had a case these days were instead of getting journal data, an error was returned by the API, with error number 0 (doesn't exist according to the docs ...) and some error message along the lines of me harassing Scotty ...
<?xml version="1.0"?>, <eveapi version="2">, <currentTime>2011-07-14 07:24:23</currentTime>, <error code="0">General Error: Scotty the docking manager heard you were talking **** about him behind his back and refuses to service your request.</error>, <cachedUntil>2011-07-14 08:24:23</cachedUntil>, </eveapi>,
edit: so the forums censor **** but its ok in the API?
Yepp, that's the one I mentioned above. Another try a day later downloaded the journal just fine for me.
And please note the <error code="0">. Compare that the the error list that the API is supposed to report: http://wiki.eve-id.net/APIv2_Eve_ErrorList_XML.
Good news: CCP finally found out what the problem was. Bad news: it won't be fixed until end of August. It seems they roll it out with the customizable API key(s) (meanwhile coined "CAK" by the 3rd party dev community) change.
See http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1563792 -- EVEWalletAware - an offline wallet manager |
MegabitOne
Caldari The Black Ops
|
Posted - 2011.08.13 09:49:00 -
[403]
Originally by: Dirk Decibel My incredible tiny brain took 3 days to think of switching to windows XP mode for EWA. It seems to do the trick though. Program just launched.
Well, actually I installed it on a W7 64bit machine and all I had to do was the following: 1. right-click the EveWalletAware icon and pick the 'properties' option. This will show the properties dialog. 2. click the 'compatibility' tab. 3. tick the 'execute this program in compatibility mode for:' checkbox (the default is WinXP SP3, which is what you want) 4. click 'ok' to close the properties dialog. 5. start up EWA as you would any other application and enjoy!
The above should really be mentioned in the EWA release notes! Hello Ween? :-) --- 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 =- |
MegabitOne
Caldari The Black Ops
|
Posted - 2011.08.13 09:54:00 -
[404]
I have EWA crashing on me several times with an error like 'cannot resize or move form if the application is minimized or maximized'. I was running EWA maximized at those times. If the correct error message seems to be produced, I guess some error handling can be added to prevent the application crashing because of it, no? --- 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 =- |
Inanna NiKunni
|
Posted - 2011.08.13 16:28:00 -
[405]
Hel O'Ween
excellent app - i have 1 question i hope you can help me with
i would like for my corp members to be able to easily calculate their own corp tax contributions.
ewa does that if you have access to corp wallet (jr accountant). then you can see everybodys corp tax contribution.
but there is no way to get your own tax contribution if you only look at your own wallet as far a i can tell.
any help with this matter will be greatly appreciated
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.13 22:46:00 -
[406]
Originally by: MegabitOne If the correct error message seems to be produced, I guess some error handling can be added to prevent the application crashing because of it, no?
Even better than that: I shouldn't try moving things around when min/maxed ... but if I only knew what moves.
I know I had a couple of those errors in the early days, but thought that I since have got rid of those. Have you EWA set up to minimize to the system tray?
Originally by: Inanna NiKunni
but there is no way to get your own tax contribution if you only look at your own wallet as far a i can tell.
any help with this matter will be greatly appreciated
Yes, that's because the personal API doesn't give those numbers away. However, with a bit of estimation, that should be roughly reproducable: save the output of the (personal) journal balance sheet to Excel format (or pull your personal wallet journal data into the spreadsheet of your choice) and apply the corp's tax rate to Agent Mission Reward, Agent Mission Time Reward, Bount Prices. Substract your best guess of non-taxable amounts (< 200k ISK, but I'm not sure about that) from it and you're done. -- EVEWalletAware - an offline wallet manager |
Alenya Laethon
|
Posted - 2011.08.18 23:27:00 -
[407]
Originally by: Hel O'Ween
Originally by: Hel O'Ween
Originally by: damnjita Edited by: damnjita on 14/07/2011 07:26:44
Originally by: Hel O'Ween There seem to be some issued with the wallet journal API lately. Over in the Tech Lab, a few player mentioned that they can't retrieve journal data correctly. I also had a case these days were instead of getting journal data, an error was returned by the API, with error number 0 (doesn't exist according to the docs ...) and some error message along the lines of me harassing Scotty ...
<?xml version="1.0"?>, <eveapi version="2">, <currentTime>2011-07-14 07:24:23</currentTime>, <error code="0">General Error: Scotty the docking manager heard you were talking **** about him behind his back and refuses to service your request.</error>, <cachedUntil>2011-07-14 08:24:23</cachedUntil>, </eveapi>,
edit: so the forums censor **** but its ok in the API?
Yepp, that's the one I mentioned above. Another try a day later downloaded the journal just fine for me.
And please note the <error code="0">. Compare that the the error list that the API is supposed to report: http://wiki.eve-id.net/APIv2_Eve_ErrorList_XML.
Good news: CCP finally found out what the problem was. Bad news: it won't be fixed until end of August. It seems they roll it out with the customizable API key(s) (meanwhile coined "CAK" by the 3rd party dev community) change.
See http://www.eveonline.com/ingameboard.asp?a=topic&threadID=1563792
Hi I can't get any journal entries from after 1st Aug even though I've reinstalled, compacted database, etc - all the suggested stuff. Is this because of the above? EveWallet is great btw, just this recent glitch
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.19 16:09:00 -
[408]
Originally by: Alenya Laethon
Hi I can't get any journal entries from after 1st Aug even though I've reinstalled, compacted database, etc - all the suggested stuff. Is this because of the above? EveWallet is great btw, just this recent glitch
Most likely. Read the above messages and look at your cached XML files. If the wallet journal file has that infamous "Scotty is angry" in it, it's due to that problem. -- EVEWalletAware - an offline wallet manager |
Tehg Rhind
|
Posted - 2011.08.20 22:54:00 -
[409]
So is the software working right now or is it still messed up by the API?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.21 11:35:00 -
[410]
EWA does work, if the API does work. The wallet journal API has problems atm, which will be resolved at the end of August. It's not a consistant error, though. Sometimes it does return journal data and sometimes not ... -- EVEWalletAware - an offline wallet manager |
|
Fleshfiend
|
Posted - 2011.08.21 16:11:00 -
[411]
|
Stein Novak
|
Posted - 2011.08.22 21:36:00 -
[412]
Q: When CCP fix this and you update EWA, will retrieval retrospectively get missing journal entries?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.23 09:38:00 -
[413]
EWA will add anything that a) is delivered by the API and b) is missing from EWA's database. The limitation is the time frame for which the API delivers data. -- EVEWalletAware - an offline wallet manager |
Aaron Sarukake
|
Posted - 2011.08.23 23:47:00 -
[414]
After install (Windows 7 x64), on every start I get:
Error accessing database: C:\ProgramData\EVEWalletAware\DATA\EVEWalletAware.mdb. Do you wish to browse for EWA's database?
I say yes, I get a file-choose prompt, I pick the correct file, and it tells me to restart. And then it gives me the above, over and over.
|
Stein Novak
|
Posted - 2011.08.26 21:07:00 -
[415]
Originally by: Hel O'Ween The limitation is the time frame for which the API delivers data.
Is this a fixed number of days, or number of transactions?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.08.27 08:51:00 -
[416]
Fixed number of days. To quote CCP Stillman:
Quote:
Walker should now always allow for a full month of data and will just display the "first page" in the history if it receives weird input.
-- EVEWalletAware - an offline wallet manager |
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.09.02 10:52:00 -
[417]
EWA version 2.0.26, EWAAutoData 1.0.20, DB 24 (Incarna 1.1) have been released.
This update implements the new Customisable API Key ("CAK") system. Please note that the old API key system will still work for the time being. However, if you decide to download and use this EWA version, you need to go to https://support.eveonline.com/api and create a new API key.
As always, see the version history for details.
This is also the last release of EWA.
I won't develop EWA anymore. The $99 dev license/Incarna/MT thing has completely destroyed my joy for this game and company. Since Incarna has been released, I've only logged in to change skills. And I don't even miss the game. My initial plan after $99 dev license/Incarna was to stop development right away, but the new API key system made me rethink my decision. It would have left you with a broken tool too soon. As CCP's shortcomings are not your fault, I decided to issue a last release of EWA which hopefully gives you enough time to find a new trading tool to which you can migrate.
My sbscription runs out in December and I will try to fix bugs related to the new API key system in that time. After that ... well, time will tell. I'm not saying I'll never come back, EVE - the concept - is still unique and appealing. It's just that the actual implemetation of this idea in the last years leaves a lot to be desired. At least to me.
Farewell my friends and thank you for your support throughout the years. Have fun and fly safe! -- EVEWalletAware - an offline wallet manager |
Kethas Protagonist
Protagonist Ventures
|
Posted - 2011.09.02 11:35:00 -
[418]
It'll be a shame to see a cornerstone of the "what the hell is my wallet doing" app niche retire, but I can understand and respect your decision. Thank you for the time and energy that's gone into EWA versions past and present.
I'm usually fond of verbose posts, but:
seems like it pretty much covers it.
|
Esan Vartesa
East Khanid Trading Khanid Trade Syndicate
|
Posted - 2011.09.02 18:57:00 -
[419]
Originally by: Kethas Protagonist
seems like it pretty much covers it.
QFT
|
Wendelgard
Gallente Herrscher der Zeit Smacked Alliance
|
Posted - 2011.09.03 12:39:00 -
[420]
Originally by: Hel O'Ween
This is also the last release of EWA.
[...]
Farewell my friends and thank you for your support throughout the years. Have fun and fly safe! [...]
Well, generally sad to hear. The part of EWA I still like most is the fact one has a course idea how much ISK the assests are worth. not only the estimation of the assets worth is a big advantage of EWA, it also sums up the the items.
Hel O'Ween, many thanks for that great tool. Please me one kwestion: For a single player setup (i. e. for me) do I really need to enter the verification code and keyID for my corp or is that part not required?
Kindest regards,
Wendelgard
|
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.09.03 15:42:00 -
[421]
Originally by: Wendelgard
Well, generally sad to hear. The part of EWA I still like most is the fact one has a course idea how much ISK the assests are worth. not only the estimation of the assets worth is a big advantage of EWA, it also sums up the the items.
As for asset evaluation, you should also give jEveAssets a try.
Quote:
For a single player setup (i. e. for me) do I really need to enter the verification code and keyID for my corp or is that part not required?
If you never switch to "Corporation Data", a personal key should be enough. I haven't thoroughly tested that, but it should work. If not, just let me know. -- EVEWalletAware - an offline wallet manager |
Wendelgard
Gallente Herrscher der Zeit Smacked Alliance
|
Posted - 2011.09.03 20:07:00 -
[422]
Well, the very big advantage of EWA is the capability to export directly in to Excel.
Anyway, the problem I am battleing with is the fact that in the options menu in the "Keys" tab no new account is created. I did enter everything that is required but there is no result when hitting "Save".
Kind regards,
Wendelgard
|
Belteyn Mithra
|
Posted - 2011.09.04 13:42:00 -
[423]
Can someone please explain what data goes where in the account setup for the latest version?
1. The new fields don't match the field names for new API key system 2. I can't see what fields to use to just enter the old API key
Whatever combinations I try, every time I click Save nothing happens.
Note: I've been using Wallet for 8 months and latest version wiped my existing account details. Was that supposed to happen? I assumed it might be the case to accommodate new keys, but having read here old keys accepted maybe error has occurred?
|
Zeta Zhul
Caldari Preemptive Paranoia
|
Posted - 2011.09.04 20:44:00 -
[424]
Originally by: Belteyn Mithra Can someone please explain what data goes where in the account setup for the latest version?
1. The new fields don't match the field names for new API key system 2. I can't see what fields to use to just enter the old API key
Whatever combinations I try, every time I click Save nothing happens.
Note: I've been using Wallet for 8 months and latest version wiped my existing account details. Was that supposed to happen? I assumed it might be the case to accommodate new keys, but having read here old keys accepted maybe error has occurred?
Same here.
I went and deleted the old API keys.
I went and created a new custom API key (full).
But I cannot save the information and frankly some of the fields don't make any sense to me. I checked the manual but the manual hasn't been updated for the current version.
so.
Account Name?
EVE API User Id?
Verification Code (Char)?
Key ID (Char)?
Verification Code (Corp)?
|
Endorphinchen
|
Posted - 2011.09.04 22:40:00 -
[425]
same problem here
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.09.05 11:15:00 -
[426]
Well, there are two new entries: keyID and vCode.
"Account name" is something you come up with yourself to identify that EWA account (you can create more than one EWA account, letting you switch betwenn different accounts/chars.
User ID ist still your User ID. Hover over your portrait in this forum and note the number after "cid". That's your User ID (which basically is your account ID with CCP). Before you ask - EWA uses the User ID basically as a "corp ID". This way (older) corporation data is still available for that character, even if he changes corps.
As for keyID and vCode - after you have created at least one new API key, you'll be presented with a table of your API keys on the new API key generation page. Just copy the contents of the accordingly labeled columns of that table to EWA. -- EVEWalletAware - an offline wallet manager |
Endorphinchen
|
Posted - 2011.09.05 11:35:00 -
[427]
helped me a lot thx, but I still can't save the information, filled everything accordingly but if I hit the save button nothing happens. Am I dumb?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.09.05 14:28:00 -
[428]
Edited by: Hel O''Ween on 05/09/2011 14:30:21
Originally by: Endorphinchen helped me a lot thx, but I still can't save the information, filled everything accordingly but if I hit the save button nothing happens. Am I dumb?
My bad, I published the database with the wrong columns. To fix this, go to Extras -> Database maintenance -> Direct dabase query. Past each of the following lines as a single line separately in the "Your query" field and hit the "Execute query" button after each line.
alter table banav_tEVEAPIKeys add column vCodeChar varchar(255) NULL; alter table banav_tEVEAPIKeys add column vCodeCorp varchar(255) NULL; alter table banav_tEVEAPIKeys add column keyIDChar int; alter table banav_tEVEAPIKeys add column keyIDCorp int; alter table banav_tEVEAPIKeys drop column vCode; alter table banav_tEVEAPIKeys drop column keyID;
To verify success after you've done so, click on "banav_tEVEAPIKeys" in the "Available tables" list. The fields vCodeChar, vCodeCorp, keyIDChar, keyIDCorp should now appear in the "Available fields" list. Columns named vCode and keyID should not be present anymore.
Restart EWA and try storing your API credentials again.
-- EVEWalletAware - an offline wallet manager |
Endorphinchen
|
Posted - 2011.09.05 19:57:00 -
[429]
Can't execute the last line, it says something like "keyID" is already used. Deinstalled EWA and reinstalled it, tried again and got the same message. I tried to save my information nontheless and at least the save button worked.
1. My Custom Key has only 1 ID and 1 veryfication Code for my char, can I paste them in the vCode(Corp) and Corp ID ? 2. tried to import characters but It didn't work 3. I already gave my custom API Key full permission on everything I could.
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.09.06 09:06:00 -
[430]
Edited by: Hel O''Ween on 06/09/2011 09:06:21
Originally by: Endorphinchen
1. My Custom Key has only 1 ID and 1 veryfication Code for my char, can I paste them in the vCode(Corp) and Corp ID ?
If you're not using EWA's corp part, you should be able to leave those fields blank.
Quote:
2. tried to import characters but It didn't work
Is there any error message(s) in the application log?
Quote:
3. I already gave my custom API Key full permission on everything I could.
Full access isn't necessary. I'll update the manual when time permits as to what APIs you really need. Off the top of my head you for sure don't need:
(Char) NotificationTexts Notifications MailMessages MailingLists MailBodies ContactNotifications ContactList UpcomingCalendarEvents SkillQueue SkillInTraining CalendarEventAttendees Standings Medals KillLog FacWarStats ResearchIndustryJobs
(Corp) Shareholders ContactList Titles MemberTracking MemberSecurityLog MemberSecurity MemberMedals StarbaseList StarbaseDetail OutpostServiceDetail OutpostList Contracts ContainerLog Standings Medals KillLog FacWarStats IndustryJobs -- EVEWalletAware - an offline wallet manager |
|
dayone nuub
|
Posted - 2011.09.07 01:06:00 -
[431]
Edited by: dayone nuub on 07/09/2011 01:12:52 Also having the "can't save" problem to add a key.
It doesn't work if I only put in a character API or both character plus corp. API access is full with everything checked. Characters: all.
I have been using EveWalletAware for at least a year.
Application log:
cEVEAPIKey:Load->3265, ADODB.Fields, Item cannot be found in the collection corresponding to the requested name or ordinal. Error: -2147221283, EVE API Error: 221, Illegal page request! Please verify the access granted by the key you are using! Error: -2147221283, EVE API Error: 221, Illegal page request! Please verify the access granted by the key you are using! frmMainHelper:MainWalletInfoFill->13, EVEWalletAware, Type mismatch cEVEAPIKey:Load->3265, ADODB.Fields, Item cannot be found in the collection corresponding to the requested name or ordinal.
Making SQL alter queries did not help. I also got
frmSQLQuery:cmdOK_Click->-2147467259, Microsoft JET Database Engine, Cannot delete a field that is part of an index or is needed by the system.
Is there a way to download v2.0.25?
|
Hel O'Ween
Men On A Mission EVE Trade Consortium
|
Posted - 2011.09.07 09:46:00 -
[432]
Edited by: Hel O''Ween on 07/09/2011 09:47:10 Guys, could you please check Extras -> Options -> tab "API/Proxy server" and make sure that under "EVE API server base URL" the value is https://api.eveonline.com? -- EVEWalletAware - an offline wallet manager |
Junky Juke
Gallente
|
Posted - 2011.09.08 15:21:00 -
[433]
Run-time error '339'
Component 'MSComCtl.ocx' or one ofits dependencies not correctly registered: a file is missing or invalid!
I have windows XP Professional SP3, the required stuff you linked on the download page wont install on my pc
|
|
|
|
Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 .. 15 :: [one page] |