Originally by: Cabernetter

---

I like it a lot! Didn't do to much with it yet, just ran a basic Income Statement, which made me quite sad by the way... Is there anyway to limit the statement to Sales and the Cost associated with those sales, I don't want to see player donations and such, makes my numbers all red lol!

Sorry if that's covered in the manual, probably just have not played around with it enough yet

---

Originally by: Shuan Jedai

---

You said in the manual you haven't tested it in Vista.

Just confirming that it doesn't seem to work in Vista Ultimate x64. Getting 'input string in incorrect format' for all update transactions/journal/dividends functions.

---

Quote:

---

I really wish downloading MS SQL Express wasn't a requirment to try out this program. I'm going to give it a miss.

Thanks.

Edit: I read that back and it may sound like I'm being a snob or anti MS espouser - which Im not. :)

Explanation: I have tried to install that Express SQL thingy before for another program just a few months back. I ran into a string of problems and errors and it never installed. I spent a few hours taking one step forwards and two steps backwards, downloading patches for things and following help advice on tech forums. In the end I gave up - it just wasn't worth it really. A shame, because the description sounds very promising.

---

Quote:

---

I get the following, with snips indicated by "...":

Quote:

---

************** Exception Text **************
...

---

I've enabled TCP/IP, named pipe, VIA, and shared memory access to the SQL server under "SQL Server 2005 Network Configuration". Both processes are running (witness this image), and there are no firewalls enabled on this machine. I am an administrative user. This is Windows XP SP2 and a fresh install of the SQL server linked from the PDF.

What instance name is it trying to connect to? Do I need to set up an alias? I'm know MySQL like the back of my hand and am a developer and systems administrator, but I must admit, I'm lost amidst the MS terminology and cutesy graphical interfaces.

MP

---

Originally by: Mr Horizontal

---

For the record, Emma and Vista (32bit) works fine.

---

Originally by: Motivated Prophet

---

Originally by: Ambo

---

I have uploaded a new zip containing a fix for an issue when adding transactions involving 0.0 player outposts.

To install, just copy the new exe over the existing one.

---

I updated, and also reinstalled SQL Express, and it now works. However, when I fetched transactions, it told me that I had an unknown station in the transactions list (pretty likely, as I do most of my business in 0.0 outposts), and that I should input the information for that station. I do not, however, see any way to input that data, and I'm now locked out of retrieving my transaction data for another hour. Any suggestions? I've probably got a half-dozen outposts about which I'll need to tell the program.

MP

---

Originally by: Motivated Prophet

---

Tried it again, and documented the errors this time:
One
Two
Three

As you can see, I'm in Corp mode; other than that, I haven't really messed with anything.

MP

---

Originally by: Ambo

---

Originally by: Motivated Prophet

---

Tried it again, and documented the errors this time:
One
Two
Three

As you can see, I'm in Corp mode; other than that, I haven't really messed with anything.

MP

---

Thanks, I've nailed it down, it's a multi-threading issue. I think I've fixed it but I want to be sure before releaseing it this time and it's pretty late here so I'll do some more tests and put a patch up tomorrow.

---

Originally by: Brother Mainard

---

Like it so far.

I'm really interested in a total-asset value count day by day. Based on previous values for items sold, the total inventory, what I have in buy orders and sell orders, it would be great to see how much I am currently 'worth'.

Other than that.. cool stuff. I'll toss you some isk if I it becomes part of my 'work day'.

---

Originally by: Brother Mainard

---

On downloading transactions...

"Getting transactions (etc)
Processing batch 1
Error
Column 'ID, Wallet ID' is constrained to be unique, Value '485768391, 1000' is already present"

Ideas?

---

Originally by: Wong Sun

---

no, i have enough transactions for each item, but they do not want to add using the auto add feature.

---

Originally by: Brother Mainard

---

On downloading transactions...

"Getting transactions (etc)
Processing batch 1
Error
Column 'ID, Wallet ID' is constrained to be unique, Value '485768391, 1000' is already present"

Ideas?

---

Originally by: Brother Mainard

---

I'm really interested in a total-asset value count day by day. Based on previous values for items sold, the total inventory, what I have in buy orders and sell orders, it would be great to see how much I am currently 'worth'.

---

Originally by: Jin Steele

---

Ambo, it seems my problem is not a bug but a feature. I am trading many different items and only buying/selling 1-2 units per transaction, and these will not load with auto add. only the ones with 3 or more bought/sold at a time will add, which is the problem i am having.

---

Originally by: Brother Mainard

---

Nope, installing the larger 54mb version didn't make a difference to my startup error - which broadly resembles the previous listed one - ie. I'm not sure they're different or not...

---

Originally by: Brother Mainard

---

Edited by: Brother Mainard on 07/12/2007 10:07:21
"7/12/2007 10:13:54 p.m. Warning - Supplied character ID (248149079) is not in the EMMA database."

..is something I am getting a lot of. Character ID changes in the log file often.

Oh, as for the original error, once I've 'continued' the error in the .net stuff I can't get it to appear again until after I reboot. More as it comes to hand....

---

Originally by: Mr Horizontal

---

Hey Ambo,

I downloaded the CVS of EMMA and have to commend you on your work. That's some properly done programming ftw! I'm especially liking the inherited and abstracted data and API layers you have.

While I know it's PITA, but because peeps really don't like installing SQL Server Express (and it is bloaty, you have to agree), you might want to consider SQLite.NET as an alternative. A more basic database, but still seriously fast and the engine is just packaged as a DLL in your project so no 'prerequisite' software.

---

Quote:

---

<add name="EveMarketMonitorApp.Properties.Settings.EMMA_DatabaseConnectionString"
connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="|DataDirectory|\Data\EMMA Database.mdf";Integrated Security=True;User Instance=True"
providerName="System.Data.SqlClient" />

---

Quote:

---

<add name="EveMarketMonitorApp.Properties.Settings.EMMA_DatabaseConnectionString"
connectionString="Data Source=<servername>;Initial Catalog=<databasename>;Persist Security Info=True;User ID=<logonname>;Password=<password>"
providerName="System.Data.SqlClient" />

---

Originally by: Galgorth

---

I tried using this in Vista and it doesn't work at all. It looks cool, I hope a Vista-stable version is released sometime in the near future.

---

Originally by: Todo Akamura

---

On downloading transactions...

"Getting transactions (etc)
Processing batch 1
Error
Object reference not set to an instance of an object"

Ideas?

---

Originally by: Argenton Sayvers

---

Edited by: Argenton Sayvers on 08/12/2007 19:46:27
Im interested in the following:

*No outside software, DB should be embedded somehow

Quote:

---

Embedded DB is a possibility in the future.

Quote:

---

*Keeps to one folder i specify, saves all data there
no "mydocuments\
private_pictures,diaries,lovestories,plans_for_world_domination\
programs\aps\software\AHSDSALQA84EALSW\EMMA"
nonsense

---

This is possible but it would be a pain in the arse and, tbh, I see no good reason to go to the effort of doing it.

Quote:

---

*manual data import via .csv if i wish to not let it connect to the net

---

Again, possible but why bother?

Quote:

---

*starts when i click the .exe, ends when i close the program. Nothing running in the background when i dont need it

---

I'm guessing you mean the SQL server express process. If an embedded DB was used then it should meet this criteria.

Quote:

---

*Only connects to API server. Nothing else.

---

It currently only connects to the API, though I do have thoughts to use the data export from eve-central in the future.

Originally by: Midir Fulton

---

Originally by: Brother Mainard

---

On downloading transactions...

"Getting transactions (etc)
Processing batch 1
Error
Column 'ID, Wallet ID' is constrained to be unique, Value '485768391, 1000' is already present"

Ideas?

---

Nice work!

I will get this fixed for the next patch.

I believe this has something to do with selling an item to yourself. I had the same error 75% threw, i figured it might be selling an item to yourself, so I sold one to myself and now it gives me the error right of the bat (one hour later only tested once since i sold to myself).

---

Originally by: Argenton Sayvers

---

- manual import:
1. Old files no longer accessible via .api

2. Actually more important: how easy it is to import/export/merge the database?
I would value the possibility of creating a DB on one computer, then transfering it to another one without problems or hassle.

---

Quote:

---

This isnt as important though, the embedded DB is the most important part for me, followed by clean, oldschool installation.

- Self-contained installation
1b ISK good enough reason? (if the embedded DB works and everything still has opensource licence)

Note: I havent tested the program at all yet, so i obviously am talking about what i want, not about the quality of what is there. Sounds very promising though.

---

Originally by: Jerppu

---

I don't get it to work :( Net 2.0 / SQL server installed... using 0.9.0.13 version (win xp 32-bit).

Got following error to ExceptionLog.txt...
10.12.2007 13:04:36 Error - Problem migrating settings from previous version
Inner Exception: Object reference not set to an instance of an object.
Stack Trace: at EveMarketMonitorApp.DatabaseClasses.Updater.MigrateSettings()

... when I try to update Journal or Transactions. Also Pop-up window "Add Trasaction", gives error: Input string was not in a correct format.

Sry, cant ad screenshots at the moment.

If I try to view those, new window opens without any data.

---

Originally by: Jerppu

---

I don't get it to work :( Net 2.0 / SQL server installed... using 0.9.0.13 version (win xp 32-bit).

Got following error to ExceptionLog.txt...
10.12.2007 13:04:36 Error - Problem migrating settings from previous version
Inner Exception: Object reference not set to an instance of an object.
Stack Trace: at EveMarketMonitorApp.DatabaseClasses.Updater.MigrateSettings()

... when I try to update Journal or Transactions. Also Pop-up window "Add Trasaction", gives error: Input string was not in a correct format.

Sry, cant ad screenshots at the moment.

If I try to view those, new window opens without any data.

---

Originally by: Frenzei

---

Finally it started working. Danged commas.

Not a 100% fit for the job tool over here, but it atleast sums up my sales very well.
I do part mining and manufacture, and as such i don't buy everything i use, and i don't buy what i sell :p

As such some of those reports have crazy numbers,

However, i'll keep on using EMMA for the sales report, as it works nicely for that :D

---

Originally by: Phoebios

---

Edited by: Phoebios on 20/12/2007 00:04:13
Great patch. Thanks you

Now i can say it: It's a great soft. The best i know to get the big picture of income, tax, and everything else in a corporation.

About your link above: The ".zip" is missing in the first link and in the second too

---

Originally by: Taraw

---

I try to update corp transactions but there's an error:
Screenshot
The english translation would be something like "An entry with the same key is already there"
No transactions are being stored. There's no problem with the journal.

---

Originally by: Ophia

---

Ambo,

You might just consider rewriting it to use an .mdb access database file. I skimmed 2 or 3 pages and saw the database trouble mentions. If you're using standard .NET (C# or whatever) then converting to a .mdb would be pretty easy. Off the top of my head its a matter of changing the database host strings and changing the ADO.NET options to connect to a file vs. a database.. Once everything is in place all of the SQL queries should work the same afaik.. Its been a long time since I've interfaced .NET to MSAccess but for the most part you have to change the database interfaces to OLE DB Jet...

Good luck none the less...

Oph

---

Originally by: Ophia

---

writing a bunch of code to switch database types is generally a pain in the ass. He writes it out of his spare time and generally in MY spare time I like to write code that's... enjoyable... Writing database code, to me, is anything but enjoyable. It's a lot of queries and testing and double checking and rewriting. It's far more QA testing than coding.

Oph

---

Originally by: Tobin Shalim

---

Originally by: Ophia

---

You're not going to get it to run under SQLite by just... messing with it... Not unless SQLite could run in an emulated MS Sql server mode. It's hard coded into the software to use MSSQL. I have an MSSQL database on my computer but I haven't installed the EMMA software because I'm a drop worried it might mess with the databases/tables I'm already using for various projects. =)

---

well, the issue comes from me trying to install SQLite and having errors in that. i meet the requirements for it, but yet it still refuses an install.

---

Originally by: untmare sai

---

I keep getting the same error and I've typed it in, pasted it in, retyped it in, repasted it in, changed full access API key, pasted/repasted, typed/retyped, ad nauseum.
All to no avail.

---

Originally by: Templar Vox

---

Edited by: Templar Vox on 19/01/2008 17:10:59
I am a little bit confused by the income statement of Emma... I.E. when I want to see income and expenses of today, it says I have had the following income*:
3.047.000.000,- in market transaction,
476.000,- in agent missions,
7.700.000,- in contract rewards.

It states that I have had the following in expenses*:
3.469.000.000,- in expenses
1.900.000,- in unspecified expenses
13.000.000,- in donations
6.600.000,- in unspecified expenses
5.000,- in CSPA
3.144.000.000,- in unspecified expenses
30.000.000,- in taxes
273.000.000,- in unspecified expenses
(*The numbers are rounded)

As a fact, I have 380mill in my wallet and 144m in sell orders. I havent done missions for many days, I havent done any contracts, nor have I given any donations.
Could someone explain the above report for me so I know what's what? Thanks :)

---

Originally by: Galfrey

---

I have managed to get EMMA working but I had to manually edit the settings.xml file in the /data folder for the character(s) and corp I was using. There does seem to be a problem somewhere - at least on my system.

---

Originally by: shags

---

excuse me for not reading the whole thread, i don't konw if this is mentioned at all.

Is it possible to merge the data from multiple characters into one database so that i can see the stats of all my characters across all my accounts in the same place?

---

Originally by: Cyno Sid

---

Thankyou for that, it works great now.

A quick suggestion, come request, come plea. Would it be possible to add to the autocontracts 'results page' (the page which comes up immediately after its done its asset sweep of the stations) a column giving the volume of that particular contract / Station (current headings are station, collateral, reward and expected profit) .

---

Quote:

---

furthermore... and sorry for pushing it, is it also possible on the settings of the autocontractor to have minimum volume as well as max volume.

My logic for the above is.

1. Often I need to see the volume of the contract in anticipation of the type of ship which is to carry the assets. (I like to try and keep them below a certain figure so new guys are more likley to do them as they fly low level haulers)

2. Having a minimum amount as well means I could set it for say 5k, thus filtering out everything below that. This is useful for regional buy orders which slowly 'fill up stations'. This way you will know when the station has reached a certain volume and needs 'emptying'

Anyway... if you can't do the above, not a problem, great tool and greatly appreciated

---

Originally by: Orchid Ix

---

Originally by: Brother Mainard

---

Like it so far.

I'm really interested in a total-asset value count day by day. Based on previous values for items sold, the total inventory, what I have in buy orders and sell orders, it would be great to see how much I am currently 'worth'.

---

Couldn't this be done by somehow importing the Orders export from the wallet interface?

---

Originally by: Xparky

---

EMMA 0.9.0.23 log

*diagnostics*


What am I missing?

---

• Added a volume column to the auto-contractor
• Fixed a problem where EMMA automatically retrieved asset information from the API after a transaction update.
• When in corp mode, wallet IDs will now show the name of the wallet division rather than the ID
• A fix for a potential issue with the new asset update from the API.

Originally by: TWiZT3DCaRNaG3

---

my scanners detect 3 different types of keyloggers and one trojan.

is that normal ?

---

Originally by: Quarentine

---

Oi Ambo,

first of all: props to making such a great tool!

---

Quote:

---

I had a couple of questions:

1 is it possible that you chance the autosort on the transaction table? (i think) because as it stands now the first entry is shown and i would like to have it show the last entries

---

Quote:

---

2 In the future will it be possible to write your own SQL code so you can get from the database the things that you want? I sometimes want to check how much stuff i bought from 1 type and that would make it easier

---

Quote:

---

3 There is a dropdown box in one of the screens (i'll check when i'm at home) where you can see how much you bought at 1 station. Only you have listed all the stations. I think if you make the dropdownbox have a select on the current table you don't have a huge amount of stations to go through.

---

Quote:

---

My proffesion is software testing so i think i can help you al long way!

---

Originally by: Healer Axim

---

awesome application, thank you very much for all your effort! makes reporting income MUCH easier.

however, would it be possible to add "costs" for manufacturing items from the ground up? I mine my minerals more than purchase them, and I also make a lot of the components used in manufacturing. example case is expanded cargohold 1's. I mine the ore for them, refine it then make the holds, then sell them off. to EMMA it shows as 100% profit (nothing spent), but in reality there's a "cost" to the materials i used to make the thing. for cargo holds i base my profit off the average unit price of the materials.

the same goes for things like particle accelerator units. I buy the things to make them and resell the final product. Excel tracks this for me now but if it could be wrapped into EMMA that would be cool :P

---

Originally by: Szmaragd

---

Hi !

I've downloaded your application and I tried to load my wallet and journal information. But I get following error during importing:

error code=100 Expected before ref/trans ID = 0: wallet not previously loaded.

And then I got message : no new record found or similar.

Any idea what is going wrong ?

Thanks for answer

---

Originally by: Frenzei

---

My current liabilities with emma:
Report color.
Income statement, the white background and black color is ok. Grey background with white is HARD to read.

---

Quote:

---

"internal transactions"
The Income statement lists internal transfers from one wallet to the other, blowing up numbers tremendously.

---

Originally by: Orchid Ix

---

I also found this in some API documentation...

/char/MarketOrders.xml.aspx for market orders

---

Originally by: Fay Fatale

---

Ok, I read a few pages back about a guy who was having this problem. I am getting the error code 521, where it says that the api info is wrong. I've tried making a new one and entering it a few times. Still doesn't work.

My limited api key works for evemon, but my full access key doesn't work for this program. I opened a petition with the powers that be and they told me to ask here. Has this problem been resolved?

---

Quote:

---

Also, when I download the wallet journal/market transactions info from the my character page, I get an aspx file, which the program doesn't seem to like. I'm outta luck right now. Too bad, it looks like a cool program.

---

Originally by: Quarentine

---

Originally by: Ambo

---

Originally by: Quarentine

---

3 There is a dropdown box in one of the screens (i'll check when i'm at home) where you can see how much you bought at 1 station. Only you have listed all the stations. I think if you make the dropdownbox have a select on the current table you don't have a huge amount of stations to go through.

---

There are a lot of station dropdown boxes around, some of them could be restricted a little and some of them could not. If you can tell me which one(s) specifically then I can get a better idea of the possibilities.

---

Point 3 is about the view transactions.
maybe you can do the same with the item dropdownbox.

Sorry about the late reply... have been busy with some other stuff.

Q

---

Originally by: flexd

---

Edited by: flexd on 04/02/2008 13:13:10
After trying to get this to work for about an hour, under Wine, Mono AND a normal windows installation i have only one thing to say.

The .net dependencies for this program sucks.

You should seriously consider ditching C# and using something proper, or atleast get rid of the SQL Express dependencies. :/

Wish i could try your program, but i'm not gonna spend countless hours fighting errors and microsoft.

---

Originally by: Shar Tegral

---

I have a few errors that come up. Only on load. The application allows me to continue inspite of the load errors and it works fine.

---

Originally by: Sophie Daigneau

---

I'm very interested in using your app to get an accurate asset valuation of my corp, but a few things are missing right now.

1. The current reports do not work well with untraded goods, ie, T2 components that are manufactured and included with another larger item that is sold. These goods are never sold, but I still want to assign them a value for tracking their worth.
2. Similar to above, the tool isn't tracking manufacturing jobs.
3. The tool has no way of assigning a value to assets bought prior to when someone started using the app or bought via contracts.

The obvious solution to all these problems would be to allow users to manually assign a value to their goods.

The other thing that I would love is a stripped down excel export of all the reports so I can do further manipulations with them.

---

Originally by: flexd

---

Generally unhandled exceptions are bad no matter what way you put it, dont lean on MS being great, .Net being awsome etc etc.

It's a unhandled exception about the database being missing, as i said Error checking is key.

I may sound angry about it but im not, i'm just annoyed one of the most basic ground rules of programming is so blatantly being ignored.

*CHECK FOR ERRORS*

---

Originally by: Shadarle

---

Edited by: Shadarle on 04/02/2008 20:06:46
Had problems setting this up on my 32bit Vista machine... but frankly a lot of things have problems running on it, so I just installed this on my XP machine.

Installed extremely fast and easy. I was expecting some problems based on some of the posts here.

It was almost too easy, lol.

Pretty damn cool program. I would like to see some of the functionality from Eve-Income (though most of the important stuff is here already). The graphs in EVE-Income were nifty though.

Best feature is the share tracking info. I think there is room for improvement on the reporting of shares but I will need to look at it more closely and determine what exactly it is I'd like to see.

Overall very nicely done. I'll look through it a bit more over the next few days and perhaps have some suggestions for ya.


EDIT> The ability to import data from EVE-Income would be amazing. Though I may have to find a way to do this myself as you probably don't even know what EVE-Income uses for a database if you even know what Eve-Income is (It's on sourceforge if you're interested in looking it up).

---

Originally by: Business Ethics

---

Anyone know the cause of or a fix for the error:


2/4/2008 6:23:02 PM Error - Eve API error.
Code: 100
Description: Expected before ref/trans ID = 0: wallet not previously loaded.



I have tried a character on 3 different accounts and only once was able to get Transactions updated on one of them.

---

Quote:

---

Would like to be able to maintain multiple datasets across several accounts' characters which doesn't seem to be a built-in feature here. Do I really have to dig up my API key each time just to switch between characters on 2 accounts with this?

---

Quote:

---

Also there is a newer version of SQL Server Express 2005 available than is linked in the documentation. Microsoft wanted to update as soon as I got it installed.

---

Originally by: MrGhol

---

Very, very nice software. The reports really deserve credit. Thanks for this

btw. How's it going with seeing the current orders? I'd like very much to see them too (f.e. to see if my buy order was fulfilled, since the in game tools don't offer nice way to check that)

---

Originally by: Shar Tegral

---

Originally by: Ambo

---

Sadly, there is currently no way to combine data from multiple accounts. This is somthing a lot of people want though and I am working on it, it's just taking a little while.

---

As a quick turnaround on making this process feasible, make the csv exporting/importing possible. You could then export the details of all the relevent characters, append them all together, and import them back in under a "gestalt" profile. Or some of us could just do it in Excel(or OpenOffice, etc.) as well if that isn't going to be easy to do.

---

Originally by: Aldelphius

---

Edited by: Aldelphius on 06/02/2008 03:31:39
Edited by: Aldelphius on 06/02/2008 02:25:37

Originally by: Szmaragd

---

Hi !

I've downloaded your application and I tried to load my wallet and journal information. But I get following error during importing:

error code=100 Expected before ref/trans ID = 0: wallet not previously loaded.

And then I got message : no new record found or similar.

Any idea what is going wrong ?

Thanks for answer

---

Yep, getting the same problem when I tried to update wallet and transactions. Now I get to wait for an hour. This time I'll save it from the web and attempt to import it first.

update. I guess you cant save the api data from the chearacter sheet and import it, returns the error "Data at the root level is invalid. Line 1, position 1."

Update 2. Well, tried it again, worked fine on both assets and transactions. not sure why, but glad its working!

---

• Can now exclude selected reference types from the report. These settings are saved per character/corp, not per user.


• Found and fixed a bug with the income statement where it was only including journal entries that were between -2.1 billion and 2.1 billion. The limits have been upped to 100 trilion each way.


• Made some optimsations so report should now be a little faster.

Originally by: Shadarle

---

I'm having a problem with income statement reports.

It doesn't seem to correctly generate reports before Feb of this year.

If, for example, I tell it to generate 7 columns of reports starting today and to have each period as 1 month. It creates 7 columns, the last 6 are blank, the column for 08 Jan 08 - 08 Feb 08 is filled out. The column for 08 Dec 07 - 08 Jan 08 is blank and so are all the ones after that.

I have data in all those months, so that isn't the problem.

If I do a weekly report I get:
Week Beg Fri 08 Feb - Data is listed
Week Beg Fri 01 Feb - Data is lited
Week Beg Fri 25 Jan - No data is listed
Previous to this - No data is listed

If I add up Week Beg Fri 08 + Fri 01 I get the same data as Month Jan 08 - Feb 08.

It seems all data before feb is not calculated.

---

Originally by: Sha NaeNae

---

Ambo,

Love the program!

I just updated to the most recent patch and I am getting an error. Can you help? The error is as follows:


************** Exception Text **************
EveMarketMonitorApp.Common.EMMADataException: Unable to update item database ---> EveMarketMonitorApp.Common.EMMADataException: Unable to read item data from the specified XML file - D:\EVE STUFF\EMMA\Data\items_data_update.xml ---> System.IO.FileNotFoundException: Could not find file 'D:\EVE STUFF\EMMA\Data\items_data_update.xml'.
File name: 'D:\EVE STUFF\EMMA\Data\items_data_update.xml'

---

Originally by: Vested Interest

---

feature requests:

1) minimize to systray, re-open on a single click of the tray icon.

---

Quote:

---

2) support for multiple active characters on multiple accounts, either independently, or treating some (or all) as a single trade entity. Perhaps I could put my API info in a text file, and the app would come up with a list of characters on those accounts, and check boxes to select/deselect and group/ungroup them.

---

Quote:

---

3) automatic scheduled polling of the API for all/some/none of the characters loaded.

---

Quote:

---

This export feature is nice though, it's working sufficiently to at least switch between characters.

I would like a way to merge these export files into a single log so I could sort of simulate item 2 above...or am I missing something obvious?

---

Quote:

---

Auto-adding "items traded" never works for me, even with the threshold set to just 1 unit. It always finds like 1 or 2 items and then stops, although I am actively trading several dozen items that are in my transactions log.

---

Originally by: Vanilla Prime

---

First I have to say "Great App!"
It changed my life as a trader.

Now I have found some places where the UI could be improved:
- group all the Update transactions in one "super update" (so the user doesn't have to do them one by one)
- the confirmation dialog at the end of the update process ("xxxx transactions have been added to the database") could be removed in case of success.
- add a refresh button on the reports (no need to reselect all the reports settings each time you want an update)

Those features requests have been added to the Sourceforce feature tracker.

Anyways, wonderful application.

---

Originally by: Sahier

---

How about untethering EMMA from SQL Server and using ODBC instead? It would allow those of us who already have other databases to use EMMA with them instead of having to start running multiple databases.

I really would like to use this software but I refuse to load even more Microsoft bloatware on this laptop, it's bad enough I'm having to use Vista instead of XP. I refuse even more so regarding MS SQL Server, especially since I already have a perfectly good install of MySQL on this system and have an ODBC wrapper on it already so I can more easily access it in MS Office apps. Yes, Vista, yes MS Office, and yes MySQL.I'm not a Microsoft hater or an open source freak -- I just use the right tool for the right job, and SQL Server ain't the right tool compared to Oracle or MySQL.

As one programmer to another -- unhandled exceptions are bad as someone mentioned, sure, but tethering someone of necessity to another product just to use yours is even worse.

ODBC support is not difficult in .Net, roughly equivalent to SQL Server in most regards. I simply have no time to fiddle with this as a project, so implore you to consider making this transition. For that matter, if not ODBC, then at least use .Net to interface with an Access MDB instead, since the data need not be persistantly available, and the MDB model is better suited than is SQL Server for nonpersistance scenarios. (See, I recommended Access... I'm NOT a MS hater. )

---

Originally by: Valator Uel

---

Originally by: Vested Interest

---

might i suggest mentioning the requirement for, and linking to the current SQL Server Express package in your OP?

---

Yeah I didn't know that even after scanning the 10 pages of this thread... thanks, downloading it now.

---

Originally by: Shadarle

---

I am running into a somewhat amusing error.

The entire application is crashing through windows when I try to run an 'Item Report' of any serious length. If I run it for just Feb or Jan & Feb it is fine. If I try extending it back to Nov (with the data I pulled from Eve-Income) it crashes out with a windows error message of:

"EveMarketMonitorApp has encountered a problem and needs to close. We are sorry for the inconvenience.

If you were in the middle of something, the information you were working on might be lost.

>CLOSE<"

I am assuming there is just too much data and it's causing a memory overflow error or some such? Any ideas what could be done?

---

Originally by: Cyno Sid

---

Out of interest, what is the time delay between being permitted to download assets ie, you donwload it now and the download option greys out for a set period of time not allowing further downloads - and is there a way of getting a round this other than resetting the date on the computer

---

Originally by: Sha NaeNae

---

Ambo, I have tried to update to the most recent patch. However, I get a Microsoft .NET Framework error that says it is Unable to update the item database. Any ideas?

---

Originally by: Sha NaeNae

---

Ok Ambo, I did as you advised. Now, however, I get the error of "Timeout Expired." I do have the express sql server running, unless there is something I am failing to add the sql itself. Any ideas on how to fix this error now?

Much thanks.

---

Originally by: Shadarle

---

I am running into a somewhat amusing error.

The entire application is crashing through windows when I try to run an 'Item Report' of any serious length. If I run it for just Feb or Jan & Feb it is fine. If I try extending it back to Nov (with the data I pulled from Eve-Income) it crashes out with a windows error message of:

"EveMarketMonitorApp has encountered a problem and needs to close. We are sorry for the inconvenience.

If you were in the middle of something, the information you were working on might be lost.

>CLOSE<"

I am assuming there is just too much data and it's causing a memory overflow error or some such? Any ideas what could be done?

---

Originally by: Sha NaeNae

---

I am running it on the following system:

Windows XP SP 2
1 gig RAM
2.40 GHz CPU

What else do you need?

I can run the 0.9.0.18 fine. Its just patching that seems to give me problems.

---

Originally by: Vested Interest

---

You know when you're updating your API data, that window that pops up with "updating your data xxxx transactons received"?


Think you could make that just a pane with a rolling log of that data right on the main window and skip the 2 pop-ups? Just make the main window about 2.5x as tall and display those entries right in there.

---

Originally by: Non Such

---

I love this application. The items reports have easily been the most powerful tools I've come across for evaluating which goods are performing and which aren't. It's absolutely changed how I trade and how I measure success.


I just have a couple questions that I can't quite figure out. First of all, is there an easy way to export the reports into a re-postable format? I'm not terribly savvy with different export formats; all I really want is a way to have, say, my Items report for the weekend in either an image form, excel form, or formatted document form--some kind of format where I can share with others w/o them having to query my API themselves or have any special application (think forum-simple). There may already be an easy way to do that and I'm just stupid!

---

• Press the print screen key with the report showing on the screen then go into your favorite paint program and paste, probably with ctrl + v.


• Right click the report, choose export to CSV then open the report in Excel. From there you can reformat it however you like, put it in a document, produce HTML, etc.

Quote:

---

Secondly, for the Assets calculation. I have my EMMA in 'Corp Mode' as I do all my trading via my 1-person corp, and I actually pull the API through the CEO, not through this toon (which does most of the trading). I trade in a different place than I have hangar space, and so I move items from the 'Delivery' tab into the trader's personal hangar before relisting them. So my question is, is the Assets data pulling only from things on corporate sell orders or corporate hangars? I assume it's also counting assets that are still in 'Delivery' status, but if I move an item out of Delivery and into personal hangar, does EMMA (in corp mode) cease to count that item as part of my assets?

Thanks a lot!

---

Originally by: Vested Interest

---

In lieu of full multi-character support is it possible to run multiple instances of Emma with a character loaded in each instance? I'd be content to keep a separate Emma base folder for each character and launch a copy for each.

I'm afraid to try this for fear of it killing my database.

---

Originally by: Sojii Ren

---

Hi, I have some suggestions to make EMMA better:

- When you create a Item Report and you bought the items before the starting date of the report it doens't have a buy price so the reports give very high margins. Maybe you could make it search back untill it finds the last buy price. Or add an option to add default buy price like in the Items Traded window.

---

Quote:

---

- In Item reports, fee's aren't deducted from the profit. It would be nice if you could somewhere set your % broker fee and % transaction fee, maybe even add the broker fee bonus per stations from standing.

---

Quote:

---

- Everytime you create a report you have to select the settings (like start date). If it would remember the last settings used that would be great.

---

Quote:

---

- Don't know if this is possible but maybe add the function to load your current market orders and make a item-report-style report for all the orders. That way you can see how much all orders are worth.

---

Quote:

---

- Also maybe create 5 buttons for the 5 different reports so you don't have to go into the dropdown menu's.

Thanks for the app it's super

---

Originally by: Deez Onit

---

BUG REPORT: When I go to Add Item I have configured it to update even if I sold 1 item but some items just dont show up... or they show up with no prices even though I've sold them... I have to manually add a zealot everytime i do an item report to see my profits even though I know for a fact that I've sold it. If I add it then auto add it also deletes it... Quite annoying.

---

Originally by: Shinzu

---

I stated earlier that i have vista 64 ultimate and have the program working no bugs no problems if you have questions on how i did it contact me in game or reply here i will see if i can help out.

---

Originally by: Quarios Cha

---

The Download is down as it appears :-(

---

Originally by: Shadarle

---

Not sure exactly what is going on, but whenever I update my transactions EMMA freezes on me now. It completes all steps of the process, gives me the "Updated X Transactions" "OK" button, then if I try to do anything my cursor turns into an hourglass.

I have to generally crash EMMA then restart it, update the other 3 things, then it works. So the updates all work... it's just the first one crashes the program when complete, rather odd and a bit scary.

I really think it may be because I have such a large database though I can't be sure.

---

Originally by: Nap ViRii

---

hi all,

Excited to use this app, and it looks like it's running for some people in Vista 64, but I'm continually getting the exception message below. Any ideas?

ps. i've checked and have the 64 bit .net app and installed SQL express without trouble too.


Exception Text **************
System.Data.SqlClient.SqlException: An attempt to attach an auto-named database for file D:\Utility Apps\EMMA_v0.9.1.21\Data\EMMA Database.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

---

Originally by: Vested Interest

---

Edited by: Vested Interest on 20/02/2008 03:28:30
What I'd like to do is get some profit reports for my small fleet of unaffiliated traders.

To do this I'd envisioned exporting transaction logs from all 4 traders to CSV, mashing those into 1 file, and then re-importing them into a dummy (keyless) character to run reports.

Can you make it possible to import a CSV back into the database under a dummy character for reporting?

Otherwise I'll hold out for the multi-char support I've heard mentioned.


Edit: the "bug" with "traded items" not auto-populating seems to have cleared. I wonder if it was because I hadn't updated my assets before attempting that.

---

Originally by: Blazing Fire

---

Hey Ambo,

I've got a few suggestions about things that realy annoy me.

When I update transacations and journal I have to click the Ok button, then Ok button once more. Can you just show the progress while updating and the amount of items updated at the status bar, so the Import window auto-closes?

Also when I start a new report, there is a message that says "Report complete". Why is this? Just display the report.

---

Originally by: Rahnesch

---

Originally by: Ambo

---

Which version are you running?

---

latest version

---

Originally by: Ginpour

---

I have tried and tried to get this program running.

And every time on both my home machine and my work machine. I get .net errors when starting the program, and trying to load a character.

I dont know if I am installing the wrong versions of .net and SQL. I followed the links in the original post.

Do you think you could create an installer for EMMA that would check to see that the proper versions of .net and SQL are installed.

---

Originally by: Raskor

---

If I run an Item or Item Detail report and it says I made X profit; does that factor in broker fees and sales taxes?

If not, could you consider a future enhancement to add a "Market Income Report". This would basically be the same thing as the Income Report, but only including market specific items. That or allow us to pick and choose what categories are included when building the Income Report.

---

Originally by: Vested Interest

---

Originally by: darkst0rm

---

Edited by: darkst0rm on 26/02/2008 08:37:45
I get this error when trying to load my journal
error message

<?xml version="1.0" encoding="UTF-8"?>
<eveapi version="2">
<currentTime>2008-02-26 08:37:16</currentTime>
<error code="100">Expected before ref/trans ID = 0: wallet not previously loaded.</error>
<cachedUntil>2008-02-26 08:42:16</cachedUntil>
</eveapi>

---

Have you ever loaded the transactions/journal XML data previously on the affected character? I had that on one of my new guys awhile back and it cleared up after a couple days--like it was something on CCP's side.

---

Originally by: Jon Sanng

---

I imagine this is a silly question, but I don't see it having been asked yet so my apologies if it has.

Is there a way to save reports? Is there a folder where they're being dropped that I'm just not seeing?

---

Originally by: Cpt's Accountant

---

The item report only shows a handful of all the items i've traded during that peroid, most of the items don't show "hours traded" and the incomestatement is also way off-

---

Originally by: Relaris

---

Great tool you created here, Ambo!

Just a quick question, recently i changed to corp mode without exporting my info (silly me), and found my information lost when I went back into character mode. Is there a way to get this information back?

I've tried deleting the databases and reinstalling EMMA, but when i update transactions/journal it only downloads the recent transactions, and not the old ones that I lost.

---

Originally by: alma111

---

hi i love your app but i have a big problem it doesnt calculate the expected sale price for all my items and pretty lot of them dont understand why so f you could help it would be nice thks

---

Originally by: Davkas Oneiros

---

What's up with the negative asset counts? Are those representing buy/sell orders?

---

Originally by: Vested Interest

---

200m donation sent, get yourself something nice :)

feature suggestion: show cash on hand in the title bar for whichever character is loaded, based on the last journal details.

---

Originally by: Mike Christiansen

---

Edited by: Mike Christiansen on 18/03/2008 23:07:34
I'm getting a bunch of errors. 1st time user so hopefully I'm not doing something extra stupid.

Can I log the errors and send them to you by some means?

---

Originally by: Shadarle

---

Just wondering if that error is a known error and what can be done about it... because currently I can't update anymore until it stops giving me that message.

---

Originally by: Shadarle

---

EVE API error Code: 100 Description: Expected before ref/trans ID = 0 wallet not prev


I get this error message trying to update my transactions/journal.


Also, people should make sure they export their data before updating, the update will clear your current data from the program.

---

Originally by: Shadarle

---

Edited by: Shadarle on 21/03/2008 17:12:51
Damn, this sucks. More and more days of data are slipping away because of this stupid bug. I guess I should download my data and keep it as a file... but it really seems to me as though all of my old data is corrupted, which is what is causing the error. Because I can update to a blank data set just fine, I just can't update my data.

Any suggestions on what I could do?



EDIT> I tried downloading the two files and then importing them but that yields issues as well. I get:

Getting journal entries from file
Error
Data at the root level is invalid. Line 1, position 1.

---

Originally by: Ms Vanity

---

On the assets report, i get no data in the value and sale price columns, just the data on units. How do u get teh data in?

---

Originally by: Shakuul

---

Originally by: Sir Ibex

---

Please don't jump on me for saying this, (I might be wrong) but I wonder how such "automation" of trade will affect the game in the long run.... Since it's easier for people who use EMMA to make money, they will be more likely to blow their capitals on things they want, and will be able to make much higher offers on things than people who don't make as much money. All this extra money in the world of EVE might create inflation. This might raise prices on time cards, and just about everything else in the game. Inflation always destroys online games, and kills all the fun.

Again, please understand that I am not saying that I am right about this. I'm merely expressing my concern.

---

Easier trade will actually reduce the amount of ISK in the game. Every time a transaction is made broker fees and sales taxes suck a bit of ISK out of the game. All player to player trading does is shift around ISK (and reduce the size of the bid-ask spread, and provide liquidity to people selling).

With wealth concentrated in the hands of the few, this just drives up the prices of luxury items, while regular ships and so forth remain at easily affordable prices.

---

Quote:

---

Also, EMMA related Q: Does anyone know if this works for Vista 64 bit? I know it isn't tested or developed for that...just wondering.

---

Originally by: Shadarle

---

I am getting all sorts of errors now :( Program crashed trying to view transactions.


I really think it has to do with the massive size of my database, although I know it "should" handle it, should and does are different things. I can start out fresh just fine... but trying to use my old data kills me.

Is it possible to import old data from EMMA instead of just loading it? It seems like it should be but I haven't really fooled around with that yet. I've just been downloading my api files every week or two to hopefully not lose too much data.

---

Originally by: Vested Interest

---

hotlinks to v.023 and v.024 both seem to be busted, sending me to a 5kb file on evefiles

---

Originally by: Shirrath

---

I downloaded and unzipped 0.9.0.18, 0.9.1.21 and 0.9.1.24 in order to the same folder to do a "clean" install, but I get the following error message when I select Data/Update Assets:

Problem updating assets from the Eve API.: Could not find stored procedure 'dbo.SetAssetProcFlag'.

Is there a separate version of the database files available somewhere that includes thet stored procedure?

And is there a single package I could download to install the latest version from scratch?

---

Originally by: Shirrath

---

Edited by: Shirrath on 14/04/2008 05:10:59
Edited by: Shirrath on 13/04/2008 20:43:54
Database issue is fixed now, thanks.

However, I'm getting hangs on the courier contract calculator when I type in the start location. For example, Chidah VIII - Moon 17 - CONCORD Assembly Planet to Jita IV - Moon 4 - Caldari Navy Assembly Plant seems to cause a hang.

I realize that Jita is where All Things That Are eventually end up, but calculating routes to Jita is a waste of CPU if you're making contracts on the other side of the galaxy. Leaving it empty by default would be better.

SQL Server Express process' CPU usage seems to have spiked to around 40%, so it's doing something.

Edit: I left it running through the night, and EMMA was responsive in the morning. What is EMMA doing there in the background? Verifying the route via web services? Attempting to solve the Traveling Salesman problem? While the obvious solution would be to optimize whatever algorithm you're using, you should also do the calculation asynchronously so that the UI thread keeps running and thus EMMA stays responsive.

---

Originally by: Tanmoe

---

Quote:

---

Or to simply add a new option to just update the API-Key but not allow you to change user data in this option...

---

Working on it ... as you said it should'nt be too hard.

---

Originally by: Calgorac

---

Is it possible to pull up a report about a specific wallet when in corp mode? As far as I can see the reports include all wallets

---

Originally by: Dingi223

---

I am having issues with the corporate mode. The import / export works great, items update, however when I attempt to run a report two things happen:

1. It gets confused that it is in corp mode, and doesn't allow me to select a wallet.
2. I switch to User mode, back to Corp mode, and wallet selection is available.
3. I run the report once without issue
4. I click to run reports, and I get the following error message:

"Column 'ID' is constrained to be unique. Value '0' is already present.

Any ideas?

---

Originally by: Snasty

---

Originally by: Ambo

---

I'm afraid the print option does not actually work at the moment (thought I'd removed it from the available options actually).

To get around it, you can export to CSV then import the file into excell or somthing and print it.

---

Thats ok, print screen and a quick edit in photosop is my friend in this instance.

Another quick question, the items traded report kicks in when more than 3 trades are recorded against an item. I can understand the reasons behind 3 being the default value but it doesnt suit my own operation. I have had a peek in the config file and then ran home to momma, I'm no coder...

Can this value be changed, by me, to 1 for example?

---

Originally by: Shar Tegral

---

Feature Request: Market Order Income Predictions

It may prove beneficial to the mathematically impaired if you added a tool, for all the tools out there, that sums up the current active orders on a character and/or corp.

---