• Uses an installer that actually installs the prerequesites for you! No more messing around trying to find the right version of SQL Server Express.


• Data from multiple characters and/or corporations can be combined in views of data and repots.


• Multiple user system - no more importing/exporting data if you are wanting to look at another character's data. Everything is always in the database.


• Configurable automatic API updating


• Program Auto-update feature - no more watching threads in MD to make sure you're up-to-date.


• In-program tutorial - also has support for multiple languages. For now, only English is available though.


• Order tracking - EMMA now tracks infromation about your market orders and can notify you when orders are completed or expire


• Performance improvements across the system. Calculating routes, generating reports, running the auto-contractor and now faster than before. EMMA is also less of a memory hog


• Report enhancements
  
  
  
  • Item report can now include broker fees, transaction taxs and transportation costs.
  
  
  • Assets report can now be organised by market category and can show the perfect reprocess value of assets as well as the expected market value.
  
  
  • NAV report - calculate the complete net value of all your cash + escrow + investments + assets (excluding BPO/BPCs due to the limitations of the API)
  
  
  
  


• Automatic valuation of market items through eve-central and non-market items (officer, faction, deadspace, etc) through eve-prices


• Full support for bank accounts (ebank, dbank) to complement the older IPO/bond tracking features


• Route planner - optimise 100+ waypoint routes in minutes

Originally by: Droshee

---

When running the app I get this:

Description:
Stopped working

Problem signature:
Problem Event Name:CLR20r3
Problem Signature 01:evemarketmonitorapp.exe
Problem Signature 02:1.0.0.1
Problem Signature 03:49313770
Problem Signature 04:mscorlib
Problem Signature 05:2.0.0.0
Problem Signature 06:4889e950
Problem Signature 07:3492
Problem Signature 08:119
Problem Signature 09:System.IO.DirectoryNotFound
OS Version:6.0.6001.2.1.0.256.1
Locale ID:1033

______

Using Vista 64-bit, maybe that's the reason? Previous version worked for me.

---

Originally by: donzie

---

Have you beta-tested it? if not, then it is not very nice to sell it for isk with all the bugs still in it. a program might act different on different computers.

---

Originally by: Erah

---

I installed it and followed the tutorial instructions
When i get to the point "Manage Account" and try to add my char to the report group i get this

Error

Problem storing data: Value of parameter '-10000,00000000' out of range.

Any idea how to resolve it?

Thx

---

Originally by: donzie

---

Edited by: donzie on 29/11/2008 14:12:10

Originally by: Shar Tegral

---

---

Yes i know EMMA is a good program and worth paying for for some ppl, and that the author should get some kind of reward for it. I am not whining about wanting it for free etc. but imo there should be some kind of beta testing phase before the final product, you see that with most products.

Some errors i get

Will take a look thakns for the info. However, please bear in mind I am not a professional software house and do not have those kind of resources. 100 mil isk is the price of a pretend battleship in spaceships online. Not exactly hard cash.

Originally by: Shar Tegral

---

Hey Ambo, might I suggest you setup some form of free forum or something for feedback, error reporting, and other associated topics. Can't exactly post my error report here as EO only allows so many characters. Besides it might help to avoid having this thread swamped with exception dialogues.

---

that would be nice.

---

Originally by: Kronooo

---

how can i import my old data of the entire year?

---

Originally by: Quazal Atreides

---

hi just thought i would try this, see if it fills my need, however when it comes to the logon, i have only just downloaded and its already saying free trial period finished as soon as i close the account key logon :)

Any ideas, obviosuly i wanna try it before i pay :)

---

Originally by: Orexis Kirhal

---

The autoupdater tells me there is an update available every time, in the details it show the Evedata.mdf file current version as being "unknown". It says it updates succesfully every time, but when I try to run EMMA it just does the exact same thing trying to update every time. I thought it might be a problem from my old install cause I had installed SQL express 2008 to get the .9x to run, and so I uninstalled 2008, reinstalled using the package included to get 2005, wouldn't work, even did a system restore to before I even installed SQL at all, and it still wont work. Tried reinstalling, redownloading... still wont work. Any ideas?

---

Originally by: Vested Interest

---

edit3: Can you give us a way to change the durations on the API update timers? I'd be totally happy with 1 or 2 journal and transaction updates a day rather than hourly.

---

Quote:

---

Edit4: I don't want any price updates or communication with eve-central, can I turn it off? Ok I found the check-box. That should be off by default.

---

Quote:

---

**** I'm just going to try it again tomorrow, I can't add a 2nd group:

************** Exception Text **************
System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK__ReportGroups__27F8EE98'. Cannot insert duplicate key in object 'dbo.ReportGroups'.
Violation of PRIMARY KEY constraint 'PK__UserRptGroups__345EC57D'. Cannot insert duplicate key in object 'dbo.UserRptGroups'.
The statement has been terminated.

---

• The 'value of parameter <x> out of range' error will no longer occur when adding characters to a report group or refreshing standings.


• Updating from the journal API will now work correctly.


• Error in certain circumstances when adding/updating dividends will no longer occur.


• The auto-updater will now start EMMA automatically in a 'don't check for updates' mode after it has been closed or completed updating.


• Adding a second report group should no longer cause an error (I couldn't reproduce this one but I've put in some checks that should stop it occuring anyway.)

Originally by: Atheana Vernius

---

Edited by: Atheana Vernius on 30/11/2008 11:52:28
you good

Looks atm like u will be getting my iskies for this little toy :), if only my company was as quick and efficient at software fixes we of actually made money

I do have a request (or need training not sure which)

Is there anyway we could have total when we look at the orders/transaction screen, a simple sum of all items filtered :)

cheers again

---

Originally by: Fumbles

---

Edited by: Fumbles on 30/11/2008 12:28:23
Firstly, congratulations on the launch of EMMA 1.x. and for including some requested features which will make reports even better.

Secondly I'm unable to create a new group. I click New Group, type in a word then click ok and the error comes up.

"Cannot insert the value NULL into column id....column does not allow NULLS. insert fails" (I can post the whole error message if you need it). Any ideas? Windows XP btw.

---

Originally by: Erah

---

Edited by: Erah on 30/11/2008 13:13:04
is there any way to delete transactions in the bank management menu?
the value i introduced is wrong, is there any way to correct it?

thx

edit: same if you add twice the same corp in investments, can't delete one

---

• Report Groups




• The bugs you mention should be fixed, just need to wait for eve-files to come back up and then it will get the update.


• I'll look into fixing the issue with corp data being downloaded multiple times.




• API Downloader




• EMMA should be able to handle 0.0 stations. I'll send an alt out to gather some test data.




• Assets




• BPOs are somthing I'd like to deal with better, just did not get around to it.. One for the future!


• POSs - I really have no clue about. Having never so much as seen one in-game. (Crazy I know) Makes it a little hard to design an app around but I'll put it on the to-do list anyway. Just don't expect it any time soon.




• Contracts




• Could you send me the details from logging->exception log.txt for that error you're getting. ([email protected])




• Investments / IPOs




• Will take a look at those issues and add look at adding the other bits in, should be fairly simple for the most part.




• Investments / Banks




• The system is supposed to only recalculate interest after the withdrawl/deposit that you create because any interest payments before that date should still be the same.


• I'll nail that data/time bug asap




• Reports




• Income statement: Reformat slightly to look like a more proper P&L report - Don't know what that would look like.. I'll take a look on wikipedia (I have zero RL accounting/finance experience)


• Item Report: group by market group - You can, check 'categorise items' on the parameters form.


• I'm working on improving the NAV report. The next major thing to get right is valuation of BPOs imo. That's going to involve a fair bit of work but it will get there eventually.

Originally by: Vested Interest

---

The update came down and everything is working spiffy now!

I accidently cleared a market order alert and it disappeared. Could you add a check box to display cleared order alerts in that log window, or something like that?

---

Originally by: SencneS

---

Although I haven't installed the update I'm hesitant to even do it as the old version did exactly as I wanted.

Feeds my wallet journal, transactions, assets into an SQL Database in which I've been working on reports to run against those entries. This isn't a bug report but more of an "Ideas" report, or a "What I would like to see". I'm not looking for a free handout and am not going to install EMMA 1.0, so I'll give you 25mil for the work done on EMMA 0.9's API functionality.

The reason is I want you to keep working on EMMA but I have no reason to update to this version. I use EMMA as an API grabbing tool and nothing else. The API information I get I run reports against, or at least I'm working on. Reports like....

---

Originally by: Elisa Day

---

Quote:

---

Prerequisite check for system component SQL Server 2005 Express Edition failed with the following error message:
"This version of SQL Server 2005 Express Edition is not supported for the current processor architecture."

---

Running Vista 64.

---

Originally by: lacal

---

Anyone who's using the new version able to post up a screenie of a sample report?

---

Originally by: Erah

---

Originally by: Ambo

---

Edited by: Ambo on 01/12/2008 12:10:33

If you take a look in the transactions view then are all the entries in there sales? (easy to tell because they will have green amounts, buy transactions have red).

---

that's exactly what i did, sorry i wasn't clear
all green!

---

Originally by: Orexis Kirhal

---

Got the following error and EMMA crashed.
Seems the other modules all updated correctly, except the Evedata.mdf which still shows as unknown. I'm not sure what to do here.

EventType : clr20r3 P1 : evemarketmonitorapp.exe P2 : 1.0.0.3
P3 : 49328cd9 P4 : mscorlib P5 : 2.0.0.0 P6 : 4889dc80 P7 : 343f
P8 : 119 P9 : system.io.directorynotfound

---

Originally by: Elisa Day

---

EDIT: Creating a sub-folder called "Logging" fixes this. I have UAC off and administrator privileges etc, but it seems like the vista feature of not allowing applications to write to stuff outside appdata/documents is making an appearance.

You should be storing all config/logs/etc in appdata anyways .

---

Quote:

---

MORE EDIT:
Trying to create a report group causes an error:

Quote:

---

Execution of .NET Framework code is disabled. Set "clr enabled" configuration option and restart the server.

---

---

• Entering a share transaction date/time now works correctly.


• 0.0 stations now supported.


• Fixed a possible error when entering the route planner.


• Fixed a possible error when downloading prices from eve-central.


• Fixed an issue where the route planner would complete before the progress dialog was displayed, trapping the user.


• Added a check in the route planner to not run if the user has not specified at least 4 waypoints.


• Corrected possible divide by zero error when producing an investment report.


• Added a check to prevent the user from including the same corporation multiple times through different characters. - Note, Mr H has tested this for me and it's still a little iffy, however, given the other fixes and the niche nature of this problem I've decided to release anyway, more fixes to follow.


• Corrected an issue that could cause all old EMMA transactions to be imported as sell transactions

Originally by: Sophie Daigneau

---

I get the error below when trying to view either the journal or transactions for my corp.


http://img.waffleimages.com/5ffd3e5ba5e0fde4c84b0edd26c17ea994f34cbe/emma.JPG

---

Originally by: Vested Interest

---

Originally by: Ambo

---

Corrected an issue that could cause all old EMMA transactions to be imported as sell transactions[/*]

---

My imported data seems to be afflicted by this as well. Will I need to re-add the characters and re-import their data or could I just get away with re-importing the same data a 2nd time?

Thank you!

---

Originally by: Kawoni Star

---

Edited by: Kawoni Star on 02/12/2008 14:01:01
If this is as good as it looks you'll be getting some isk from me :)

However, I need to get it working first.

I accidentally used my limited API key when setting up an account in a report group. I deleted the account but now when I try to add the account with the full API I get the following error.

Problem Setting account details. Supplied userid xxxxx is already in the database, however the supplied APIkey does not match the one in the database.

I currently have no accounts in the report group. I've tried uninstalling and reinstalling EMMA but it didn't reset anything.

How can I clear the database or get around the error?

Edit: I deleted the report group and created a new one but when I try to add the account I still get the error. This could be a big problem if you need to change your API at some point.

---

Originally by: Orexis Kirhal

---

Well, the addition of the logging folder atleast lets it make an exception report instead of just crashing so here ya go...

12/1/2008 4:34:04 PM Error - Problem updating database
Inner Exception: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

---

Quote:

---

you need to delete the C:\Documents and Settings\<username>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS directory. (In Vista - C:\Users\\AppData\Local\Microsoft\Microsoft SQL Server Data\SQLEXPRESS)

What everyone else failed to emphasise is that you might need to restart Windows. Simply bouncing the SQL Server Express service doesn't always fix it.

This is what I did:

Reboot the computer.
Log in as Administrator (I run with non-Admin privileges most of the time).
Delete the SQLEXPRESS directory for my normal user account.
Log back in as my normal user.

---

Quote:

---

Sometimes it is a permissions issue which can be solved by giving the SQL service account the necessary permissions.

---

Quote:

---

check out the error log for the user instance, it will likely give you more information about what is happening. You will fine the error log at C:\Documents and Settings\<user name>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS.

---

• Added a new control panel button 'Check/Repair Data'. This will perform checks on the database and repair any invalid data. For now it just removes duplicated dividend records.


• Added some checks to try and prevent the 'sellerwallet' problem in transactions/journal view. (I could not reproduce this or even find a likley cause.)


• Fixed an unrelated bug that caused the seller's wallet to never display for personal transactions in the transactions view.

Originally by: SencneS

---

Edited by: SencneS on 02/12/2008 19:53:22
I'm trying out 1.001 with the updates and I've come across something weird... The Office I have in a region is in the wrong station. All the items within the corp hanger are listed in the wrong station.

To make sure, I logged in to see If we had an office at that station and we don't. It's listing the personal items at the correct station, it's just the Corporation assets are located incorrectly.

EDIT:-
I wanted to add I'm using Vista 64Bit with SQL 2008 64Bit and everything appears to be 100% correct. The only issue I've seen so far is the oddness in the asset report for one particular station.

---

Originally by: Vested Interest

---

Originally by: Ambo

---

At the moment, you need to remove the transactions already there... Don't do anything for now though as I'll change the import to modify the database with the data from the XML if it's different. (Should have somthing out to do this later today)

---

I don't have the XML data for comparison, just the whole year of old exported emma transactions and journal for a bunch of characters. What's the easiest way to just zero out my data and start clean so I can reimport to a blank database?

---

Originally by: Vested Interest

---

Edited by: Vested Interest on 02/12/2008 21:19:41

Originally by: Ambo

---

Easiest way would be to just uninstall, delete the database files and then re-install.

---

Kinda what I was thinking, no biggy thank you!

Could you make some kind of pop-up rolling log window that shows when a character last updated what, and how many entries were updated? I'm always wondering if my guys actually pulled any data.

And some sort of automatic prune of the API call history files after X days would be nice too. I have 1946 items in there after about 72 hours of sporadic operation.

For me, EMMA always starts full screen, which in my case is 1920x1200. Could you put in a way to set, or have it remember the starting window size?

If I could hide the Control Panel and reopen it with a button on top that would be cool too.

---

Originally by: Erah

---

Originally by: William Ytiri

---

Hmm, all works fine afer installing except the report views seem to display only a big black rectangle on the right and another black geometric shape on the left of the report view and nothing else.

Do I have to install something that will diplay the report views?

---

I'd say: change your font size :)
Setting -> Report Style Settings to change it

---

Originally by: lacal

---

Great app I must say - a far cry from 0.9

Having another play tonight with 13 days remaining to see if it can help make me money rather than just reporting and I'm struggling with the contracts screen - the only station that I can pick for the destination is Jita and the pickup station is blank (and blank in the drop down)

Do I need to import market data from somewhere?

---

Originally by: SencneS

---

<Lots of detail>

---

Originally by: Orexis Kirhal

---

Mk, so I finally after hours of uninstalling and deleting everything I could find about all instances of any SQL stuff.. I finally reinstalled and the update went wonderfully and then.... another exception.... though this time it says that the Filestream feature isn't supported even though I specifically checked all boxes to install the filestreaming feature, and when I go to the config tool it shows that filestream is active. Also, the instance is called SQLEXPRESS as needed so it's not that. Any ideas?

12/3/2008 11:42:18 AM Critical - Unable to enable the CLR on SQL server express.
Inner Exception: FILESTREAM feature is not supported on user instances.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.

---

• Changing things to work properly with Vista will take a while, in the meantime, I've added some checks to not even attempt to run if the appropriate permissions (Full file read/write and registry read/write) are not available.


• User can now amend api key by double clicking the eve account line in 'manage group'


• If an eve account is already in the database but is not used by any report groups then the user can now add that eve account to a report group using a different api key than the one already in the database.


• EMMA will now remember main window state, size and location and use it when starting up next time.


• Added a new button in bank account details to recalculate all bank interest payments (from 1/1/2000 onwards). This is a stop-gap measure until I actually find and fix the problem.


• Made changes to the auto-updater progress bar so that it actually shows you what's going on rather than appearing to freeze.

Originally by: Orexis Kirhal

---

My main user is registered as the admin

---

Originally by: Yatta I

---

update:

i uninstalled SQL express 2005 and installed 2008.

problem still persists... EMMA crashes after autoupdating to new version.

---

Originally by: SencneS

---

Ambo:- I'm also getting something new that doesn't work and I can't find out why.
All of a sudden after the update the data appears to be disappearing in the database. All the records that it pulls from the journal and transaction API come up as "DELETED#"

I checked with Management Console and it's the same.

I'm going to re-install EMMA and this time not update. See if that is the problem. Because it was working without issues before the update :)

---

Originally by: Vested Interest

---

requesting the option to minimize to tray and to start minimized.

---

Originally by: 0vermama

---

2 questions
1) why the reports page are blank ? vista x64 user
2) why emma connect to shiny.stackworks.net ?

---

Originally by: Dr Keane

---

Everything seems to be OK for me except one thing. It wont run a NAV report, it successfully did one but it's been throwing an error at me since trying again.

"Exception of type 'System.OutOfMemoryException' was thrown"

Any ideas on what's causing this?

---

Originally by: SencneS

---

Ambo, Not sure what the difference is but it appears to be working fine again. Although that concerns me as it wasn't just me having the issues. I was thinking it was my ODBC link messing around with the data. However since someone else has the issue as well...

Anyway I uninstalled EMMA, deleted the EMMA folder. Reinstalled EMMA, updated (As it doesn't give me an option to just skip over the update) and re-setup. Now everything is fine again. I'll play around to see if I can re-duplicate the data deletion.

As a side not - How does EMMA calculate "Reprocessing Value"?
I ask because apparently I have several items that if sold is worth 6mil. However after reprocessing it's worth 1.516B :)

---

Originally by: Trox Aeze

---

How do I add Proxy to it?

---

Originally by: Skie Ankora

---

Hi,

I'm a long time user of Emma, looking forward to upgrading to the full license once I have it up and running properly.

I would prefer to be able to install Emma in a folder under my user account and not give it full admin access to my system (call me paranoid, but there you go). However, when the AutoUpdater.exe program runs, I automatically get prompted to escalate it's privileges to administrator (on Vista with UAC enabled).

I know this fixes Emma so it 'just works' for most users. However is there some way I can turn off the automatic prompt?

I am trying to work out what causes it, so I can disable it. It doesn't appear to be the filename. Maybe the file properties, or maybe a manifest embedded in it? Could there be an option (or some way I can modify the file) to turn this off when it is not necessary?

---

Originally by: SencneS

---

Yeah they are missiles lol

As for the deleted# I think I found the problem. Vista all of a sudden started reporting harddrive failure. And is reporting bad sectors all over the drive.

I've moved the data and everything to a new drive and have not had the problem since. As for the other user who had blank reports I am not sure what could have caused it. It may not be harddrive failure but that's a big sign to overlook.

---

Originally by: Orexis Kirhal

---

Any news on those of us that are getting the Filestream error? To repeat, I get the following error even though filestreaming has been enabled and I am the admin:

12/6/2008 1:05:35 PM Critical - Unable to enable the CLR on SQL server express.
Inner Exception: FILESTREAM feature is not supported on user instances.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EveMarketMonitorApp.DatabaseClasses.Updater.InitDBs()

---

Originally by: James Omerand

---

I love this thing!... going to wire the 100m over as soon as I get back ingame...

but, one question.... How does Ambo come up with the NAV report... does it assign values to things Like Blueprints? ive got several expensive prints

---

Originally by: Vested Interest

---

I'm looking for a new report type. I'll call it an "Item detail report."
.
.
Edit: Also, I just created a new guy in an empty slot I had. How do I get EMMA to refresh the characters on an account? The new guy doesn't show up in the list.

edit2: This new toon isn't showing up in EveMon yet either so it may not be an EMMA thing.

---

Originally by: Mace Blackhammer

---

I haven't read through the whole thread but it doesn't look like it works on windows XP x64, it just crashes on launch.

---

Originally by: Brock Nelson

---

Why do you even need SQL Express? Why not store information on a file? This just reduces the need to install more program to support EMMA.

---

Originally by: c0rnf3d1

---

I look to have fixed my problem. for some reason the "SQL SERVER (SQLEXPRESS)" item in my services was set to disabled.
i had to set it to manual, then enable.
i would recommend putting a check for this in the startup (as i've never intentionally started/stoped that service. its only there from emma .9)
looks like ill be buying this in 14 days :)

---

Originally by: Orexis Kirhal

---

Any news on those of us that are getting the Filestream error? To repeat, I get the following error even though filestreaming has been enabled and I am the admin:

12/6/2008 1:05:35 PM Critical - Unable to enable the CLR on SQL server express.
Inner Exception: FILESTREAM feature is not supported on user instances.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EveMarketMonitorApp.DatabaseClasses.Updater.InitDBs()

---

Originally by: Astorothe

---

Ambo,

I just installed 1.0 on Vista and it's working perfectly first time. It's come a LONG way since early days - definitely worth a hundred mil.

Nice one.

---

Originally by: Fumbles

---

I'm wondering if the formula in the Cost of Goods Sold column in the Item Report is functioning correctly.

The reason is that in the report I have several items which have a higher average buy price than the cost of goods sold value. E.g. average buy 145k, cost of goods sold is 93K. In one case the cost of goods sold is shown as 700K or so when the actual item always costs me at least several million.

---

• Fixed an issue with report default font size on systems with non-standard decimal characters.


• Added highsec/lowsec/nullsec jump cost options to the route planner.


• Reprocess value is now calculated correctly for blueprints that produce more than one of an item per run.


• EMMA will now minimise to system tray. If you close it when minimised (right click the icon and click quit) then it will start minimised to system tray next time.

Originally by: R'ambo

---

I can't set the end date in item report parameters, is this not possible in the new version??

---

Originally by: Elisa Day

---

Have you considered using SQLite to make setup easier for users?

---

Originally by: Vested Interest

---

Would it be possible to add a time-zone offset in the program so eve-time is converted to local time in the various display windows?

Thanks again!

---

Originally by: Mace Blackhammer

---

EventType : clr20r3 P1 : evemarketmonitorapp.exe P2 : 1.0.0.8
P3 : 493bdf61 P4 : mscorlib P5 : 2.0.0.0 P6 : 461f060e P7 : 3375
P8 : 119 P9 : system.io.directorynotfound

is what i get

---

Originally by: dr doooo

---

there seems to be quite a few items not showing up in my 'Assets Report'. I just skimmed through looking for maybe a couple of dozen different item types, and about 5 or 6 of those were missing (core x-type LARs, and 5 different various basic and standard learning implants). The API has updated a few times since I loaded it but they are still missing?

The total wealth in the NAV report also varies day to day, over three days of the report, by 4-5 bill, even though I have done virtually nothing in Eve in this time. Is this due to price fluctuations?

---

Originally by: Blazing Fire

---

Hi Ambo,

Could you please make the update process not to start every time EMMA is started?

I start and close EMMA at least 20 times a day and every time it checks for an update.
And it takes a lot of time while it does it. And high CPU usage.

Just add an "Check for update" button somewhere. Prefferably in teh settings menu.

With the latest verstions I get a lot of "System.OutOfMemory" exceptions.

Quote:

---

************** Exception Text **************
System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.

---

---

Originally by: Orexis Kirhal

---

Finally got it working; I kept apparently missing different parts of SQL still left in my system and registry so I did the following:
1) System restored to before I installed any SQL
2) Found the C/docs and settings/<user>/local settings/application data/microsoft/sql server folder and deleted it completely
3) Found the C/program files/sql server folder and deleted it completely
4) emptied the recycle bin and made sure there was nothing in my registry or add/remove programs list that had anything to do with sql
5) restarted the computer and ran the emma 1.0 installer
6) updated succesfully
7) ran emma successfully

The program is nice but I'm not sure it was worth the two weeks of the pain in the butt 8p. Na, but I like it, and it definately looks useful. Once I get enough income to afford throwing 100m at it, I will.

---

Originally by: SencneS

---

Ambo - Another oddity...

The imported data from the old EMMA file shows the Buyer and the Seller in the wrong location.

If I look at the data in Transactions it shows Me as the Seller, and other as the buyer. That's wrong, it should be the other way around. I didn't sell all that stuff, I purchased it. Its running this for Minerals.

---

Originally by: ingenting

---

Prerequisite check for system component SQL Server 2005 Express Edition failed with the following error message:
"This version of SQL Server 2005 Express Edition is not supported for the current processor architecture."

See the setup log file located at 'C:\Users\Stefan\AppData\Local\Temp\VSDBC45.tmp\install.log' for more information.

---------------------------------------

ran setup.exe which is supposed to install everything u need...

---

Originally by: Vested Interest

---

Sometimes when I launch EMMA it pops up (this happened twice in the last 2 days) and says that an update is available. The details pane indicates that EveData.mdf is an "unknown" version and that the latest version is 1.0.0.0. After I let it "update" it works fine.

Also did we ever get an answer about that shiny.stackworks.net or whatever url that someone noticed EMMA had connected to?

Also would like an option to not autoupdate, or to bypass it for a single startup--whenever eve-files is having problems it takes like 2 minutes for EMMA to open.

One other thing, related to the time-zone offset thing I requested. I am in US Mountain time (GMT -7 in the winter). Whenever I bring up a set of logs (i.e journal or transactions or whatever) it sets the date range to cut off at the current local time rather than the current eve time.

So I have to manually click on the date range and move it forward to get all the entries visible, everytime I open the logs.

---

Originally by: Alihahd

---

Thanks for a great app, I've enjoyed using your previous version of EMMA. I haven't seen this question raised yet, but is is possible you can provide a config file similar to what you created for version 0.9.27 that allows us to enter connection strings to a full SQL server environment? I imagine we would need to dump the DB in there as well...etc

Thoughts?

---

Originally by: Mace Blackhammer

---

This fixed my problem so far it works a lot better than the old emma and I'll prolly buy it.

---

Originally by: c0rnf3d1

---

I am getting an issue: "the value for column 'corporationID' in table 'staStations' is DBNull." whenever i try to run a report. Any clue on what is causing this / what i can do to fix it.

---

Originally by: Arya Aiedail

---

I LOVE IT

Really you have done here a great job i m going to buy it for sure

i only have one problem that i cant get the asset report to work otherwise it s just so good really it save me so much time keep on the great work and people dont hesitate buying this it s worth the money

---

• Data import will now overwrite older data if there are differences.


• Added a check on startup to see if the sql express service is running and try to start it if it's not. If the service is in the process of starting up then EMMA will wait for it to be available before doing anything else. (This can all be disabled for those people who use a full SQL server instead).


• Added a check on startup to detect if the subdirectories EMMA requires could not be created and inform the user.


• Added an option to disable the automatic check for updates when starting up (and a button to manually check for updates - Settings -> Auto-update Settings).


• Added options to configure how often data will be retrieved from the API (Settings -> API Update Settings).


• Added a market order state filter to the market orders view.


• User can now delete unused public corps (but not banks) and can delete bank account transactions.


• The interest paid on bank accounts will now be correctly recalculated when historic withdrawls or deposits are added.

Originally by: Blazing Fire

---

Anything about the OutOfMemory problem?

---

Originally by: SencneS

---

Ambo - On re-importing the old data I get an Exeption error. Doesn't crash the computer, just closes out of the App.

---

Originally by: Saira Jin

---

I was looking forward to buying a license for this, but so far its been a real shaky ride.

---

Quote:

---

Suggestions/Requests:

1) I wish there was a way I could search for one specific item and see the history of how much I have paid for it. I don't buy and sell in the same day, and so it would be handy to be able to find out how much I have paid, on average for say Warp Disruptor I before I sell. Right now, I use the workaround of creating an assets report and scrolling like a monkey till I find warp Disruptor I :-) ( No search here either, in te assets report).

So please think of adding a search feature of some sort.

Also,

2) It would be GREAT if you could have a tool that summarizes how long it took for an order to get filled, the rate at which it got filled/sold, and buying/selling efficiency, so I can drop the less profitable items that move slower.

Thank you. This has a future, with a little TLC :)

---

• Fixed the issue I introduced in the orders view with the last update.


• Conquerable stations will now have corporation ID set correctly. Also, the system will handle stations that do not have a corpID set more gracefully.


• When starting up, EMMA will attempt to ping the various web servers it connects to (eve api, eve-central, etc) if a ping fails then EMMA
  will temporarily disable useage of that server until it is next started.


• EMMA now has the ability to use alternate update locations automatically if eve-files is not available. (Though none have been setup yet)

Originally by: SencneS

---

Edited by: SencneS on 11/12/2008 13:29:23
Ambo - Not really a major bug this time, but check this out.

It appears that it opened that many windows + between 5 and 10 more. Now I didn't see it happen, this is an overnight thing.

Fortunately, I understand the cause. Have it do a window check before reporting the orders, if the window is open, refresh. :)

Of cause if you are doing that then there is another issue.. Like I said, low of list of bug, but if you went away for a weekend you'd have a nice load of windows open :)

They were all open too, I had iconified them to see if it was never ending open window but it wasn't.

---

Originally by: c0rnf3d1

---

not sure if this is a universal problem or not.
i have 2-3 character in a corporation all of which use the corp wallet for buy / sell orders.
problem i am running into is 60% of my purchases / sells are not showing up in the item report. ive taken some time to try to diagnose whats going on. it looks as if all items do show up in the transactions for the corporation but do not get processed for the report. i have sent you an in-game mail with a link to an image depicting this. -- is it possible that im missing a 'update traded items' like was in the previous version?


another thing
http://dl.eve-files.com/media/0812/Untitled-1.gif
notice how the corporation is added on the left hand side like 6 times

and... while in the process of writing this message
i get this :
http://dl.eve-files.com/media/0812/errors.gif
:P

---

Originally by: Jonas DaVerde

---

I have just installed EMMA and I can't update it. The autoupdater can't connect to the server. I can't use the app as it does not allow me even to save API key data saying 'Problem storing data: Input string was not in a correct format'. I suppose it has been fixed somewhere in newer version but as for now I can't update to it and so I'm unable to use the app in any way. Is there any problem with the server hosting the updates or is it something on my side?

---

Originally by: Jonas DaVerde

---

Edited by: Jonas DaVerde on 12/12/2008 11:38:35
It seems something got fixed as the autoupdater downloaded updates and finished with success. Although after EMMA restart it cannon connect to any of the remote servers. Exception log says: 'Error - Failed to contact api.eve-online.com Status - TimedOut'. Same for eve-central, eve-prices and eve-files. It looks like something was blocking the connection for EMMA but I checked firewall settings and the connection rules for EMMA are all set correctly. Any ideas?

---

Originally by: ingenting

---

I had it installed already according to my OS.

---

Originally by: Vested Interest

---

Does the Assets report and the Assets total in the NAV report reflect the estimated value of items currently up for sale on the market?

---

Originally by: Ansem Stelrach

---

Originally by: Orexis Kirhal

---

Any news on those of us that are getting the Filestream error? To repeat, I get the following error even though filestreaming has been enabled and I am the admin:

12/6/2008 1:05:35 PM Critical - Unable to enable the CLR on SQL server express.
Inner Exception: FILESTREAM feature is not supported on user instances.
Configuration option 'clr enabled' changed from 1 to 1. Run the RECONFIGURE statement to install.
Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at EveMarketMonitorApp.DatabaseClasses.Updater.InitDBs()

---

Ambo, I suspect I've found the reason why this is happening. SQL is attempting to attach the database files to the server. It seems that the application is attempting to attach the EVE DATA file first, and causing an exception because I believe that the attach information may have been hard coded to a file path in your personal Documents and Settings (I have a screenshot of the results when I attempted to attach the above file manually. Because the file path contains some personal information (your first name and last initial), I WILL NOT post the image here, but have eve-mailed you in-game to see if there's a good way of getting the screenshot to you.

When manually attaching the EMMA DATABASE.MDF file to the server, I get no problems. I hope this can shed some light to the situation.

---

Originally by: Vedyma Dark

---

Edited by: Vedyma Dark on 13/12/2008 15:00:07

Originally by: Ambo

---

User can now amend api key by double clicking the eve account line in 'manage group'

---

I was trying to update the API key (I got a new API) and get an error:

Supplied user ID 'xxxxxxx" is already in the database. However, the supplied APIkey does not match the one in the database.

How do I clear that?

I also tried removing and adding the account, but get the same problem.


Edit: Apparently, after you do "remove account" and it shows it as removed, you still need to press OK to close the window to confirm the removal - not very intuitive if you ask me.

So, I was able to remove that account and put in a new one, problem fixed

But, new one! And it's more of a question I guess, but my assets report has a number of '-' for items, such as Armor Thermic Harderner, Large 'Notos', etc. in the Est. Sell Price. Are these values obtained from Eve-Central? because going to there, those items have lengthy entries from which to obtain a sell price. Does EMMA use certain criteria to obtain such?

---

Originally by: Vedyma Dark

---

Edited by: Vedyma Dark on 13/12/2008 15:42:10

Originally by: Ambo

---

As for the items, try looking in 'Logging\Eve Central History'. And see if there is an XML for itemID 9772 (Large 'Notos'). The value used by the report should be the median buy price.

---

Alright, went there and found 3 such files. One has all 0s, the other two have same values:
2078 325068.31652 499950.0 230243.15 73149.7472601 302500.0 1925 234860.589351 236501.1 230243.15 2107.9053381 235021.57 153 354149.345228 499950.0 244990.0 68881.8837707 342000.0

2078 325068.31652 499950.0 230243.15 73149.7472601 302500.0 1925 234860.589351 236501.1 230243.15 2107.9053381 235021.57 153 354149.345228 499950.0 244990.0 68881.8837707 342000.0

The one with all zeros is from Region=10000002 (Forge I guess?) The ones with values is from Region=10000043 and one without a region indicator.

Also, can you change how the Est Sell Value is established? because using the median buy gives you odd results, such as for Radio L, which has some low buy orders of 100,000 units for like 5000isk, such that the estimated value ends up very low as compared to the true value (highest Jita buy order IMO.)

Or better yet, average of two: highest buy and lowest sell prices.

---

Originally by: Jane Salva

---

Edited by: Jane Salva on 13/12/2008 16:22:11
I'm having some issues with the Assets report.

I added 11 accounts to EMMA, checked off the 33 chars in the manage accounts. Downloaded the API assets, transactions, journal, etc. Then I went to reports, all characters seem to be present there and all char boxes checked. Ran the report, but didn't get all the assets reported, only a large but far from complete report. So, I went back and just checked off one char out of 33 (which is a pain to do, since there is no check all or check off all buttons, or ability to sort by char name), then I realized that that it was Income Statement in the drop down Report to Create: menu, so I selected Assets Report, which reset all the Chars/Corps to have all chars selected again

So, I checked off all but one char (the one that's suppose to have some assets that were not reported before in the full report) ran it, but suprisingly it showed the same report as before, the incomplete full one. Tried again, and got the same result

---

Originally by: Selene D'Celeste

---

Edited by: Selene D''Celeste on 13/12/2008 22:37:09
I noticed that EMMA crashed on Vista-32 if you try to load old exported EMMA 0.9 data before adding characters via the API. Whoops =)

Edit: Also, I do not see any way to filter things such as Journal entries by some of the data columns? For example I like being able to see all entries involving person X, over a period of time. It would be nice to be able to filter based on the name columns. (unless I missed it, quite likely)

---

• Fixed an issue causing multiple order notification windows to open. Only one should ever be open at a time and will be automatically refreshed as required.


• Corrected an issue that caused an error when starting up if the user has unacknowledged completed orders and closed EMMA while minimized.


• EMMA will now fail more gracefully if a connection to the database cannot be established on startup.


• The API update status window will never show more than one of each char or corp.


• The update server check on startup will now check www.eve-files.com instead of go-dl.eve-files.com. This seems to be less prone to random ping timeouts.


• Added a setting to allow the user to use either the max buy or median buy value from eve-central as the value of an item. (Settings -> Item Values)

Originally by: Feek

---

I don't seem to be able to get the new version because when I run EMMA, I get a message "This component should not be run manually ()" when the splash screen is showing "Checking for updates..."

---

Originally by: Ahmune

---

Only have 3 days left on my trial. I tried adding a group and everytime I try to create an item report I get this error.

"Object reference not set to an instance of an object."

Any ideas?

---

Originally by: c0rnf3d1

---

when i create a report i still have 7 corps listed, and doesnt show 1/2 my data.
same pic i sent you ingame still applies.

---

Originally by: trader2069

---

I installed the version of emma from this link
http://dl.eve-files.com/media/corp/Ambo/EMMA_v1.0.0.1.zip

followed the instructions in the readme.
started it up it updated and now it wont work...

it starts the splash screen then crashes.
i am using windows vista home premium X64. any help would be much appreciated.

---

Originally by: Jonas DaVerde

---

There is an error in Orders tab. With filter set to 'Active' orders only it shows cancelled and expired orders as well.
And a small request: could we have some option to separate buy and sell orders from eachother. I can sort by type column atm but not by name at the same time. In result when I sort by type (Buy/Sell) the items are in a real mess in the Name column. Two column sorting (primary/secondary) would be great. Thanks in advance.

---

Originally by: Anest Dura

---

Hi Ambo ever since the last 2 patches my Emma App craps out on me when I first load it up. I first had to create the logging folder manually, otherwise it would crash at start up. Now once I load the application it tries to see if these websites are up and I know they are. Below is what was stored in my exception log. Any help would be great.

I am using Windows XP SP3 32Bit

---

Originally by: Anest Dura

---

Ok thanks Ambo, I got the update now. I am not sure if this is related but I cant even get into EMMA any more. I have tried uninstalling EMMA and SQL 2005 Express and re-installing it and this message still comes up.

=====================================================================================
EXCEPTION REPORT
=====================================================================================
12/15/2008 4:45:46 PM Critical - Error connecting to database
Inner Exception: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.

---

Originally by: trader2069

---

Originally by: Ambo

---

Originally by: trader2069

---

I installed the version of emma from this link
http://dl.eve-files.com/media/corp/Ambo/EMMA_v1.0.0.1.zip

followed the instructions in the readme.
started it up it updated and now it wont work...

it starts the splash screen then crashes.
i am using windows vista home premium X64. any help would be much appreciated.

---

yeah umm stupid question im sure but where is the log file located? i dont see it in the emma install directory....
Could you send me your ExceptionLog.txt file from the logging folder. ([email protected])

---

---

Originally by: Vested Interest

---

Found a glitch where "quarterly" income statements are actually calculating 4-month periods rather than 3-month periods. Seems to be happening in the NAV report as well.

---

Originally by: Jonas DaVerde

---

Another request. (Yes I know I have lots of 'em without even paying for the software but I like to check what I'm paying for and still 10 days remaining on trial period :) ). Here it goes. While displaying Items Raport I need to set dates interval. But there is no option to change to what data I want the raport to be generated. It's always set to 'today'. And I can't see the raport for only one day (ex. Monday 15th Dec), because if I set same date in both fields raport shows nothing. Could we have option to set any time interval for the raport as well as option to show it for only one selected date.

---

Originally by: Rixar

---

is there a way to exclude some items in the item report? i have some skillbooks which i used for own training therefore i have no avg. sell price for them. on the other hand i am missing some items in the report which i have traded but they are not listed.

---

Originally by: trader2069

---

ok well i finally gave up on getting it to run in vista so i installed it on a vmwared version of xp pro on the same machine...
but its still not working quite right. when i installed the charachters on the account and updated their journals returned an error. when i try to generate a revenue report it doesnt return anything and when i try to do an asset report it cant get the market values from eve-central. so far. not worth 100 mil.
hopefully you can resolve some of these issues. here isa link to the logfile.

http://pastebin.com/m5ed847b8

---

Originally by: Arya Aiedail

---

hello i m still getting the memory error for the asset report and the nav report and in the item report it doesn t show all the qty i buyed there are missing some qty.

is there a way to add the qty missing manualy and for other items it s not calculating the profit % well i think it s all i ll post the error log tonigth i m at work keep on the good work

a question would it be hard to change from sql to something else are do you have to rewrite the whole thing ?

---

Originally by: Lord Zoran

---

Edited by: Lord Zoran on 17/12/2008 21:04:46
Edited by: Lord Zoran on 17/12/2008 21:02:36

nice program, but i've had a few problems, i'm using vista and i think someone else said but in the orders some of the orders are not active yet still displayed due to what looks likes a typo and it fails to connect to eve central for asset prices so the asset report doesnt work for me

---

Originally by: Saira Jin

---

I lost the little window with the potraits of the characters and the update status display.

To reproduce the bug:

1) maximize the character status display window
2) minimize the said window, so that it does not show except as a small shade in the lower left of the EMMA screen
3) Restart EMMA

How do I get the character updates window back? I would like to see how long it has been since the last time the assets were updated.

---

Originally by: inVictu5

---

Is EMMA worth 100m? 100m Isk is not really that much. But since the majority of users are players within the 100m-2b range I dont think its worth 100m. Plus there are many errors and bugs with the program. Indeed its a good program, But I only use it when first thing in the morning. I dont really need it and wont pay 100m for it. Due to its very limited uses.

Im going to try cracking it with the reg or hex. Unless anyone else has a key I can use

---

Originally by: Dead Dreger

---

I have this bug: [ 2444794 ] Cannot add journal transactions

I've tried everything I could think of to not reproduce this bug, but even if I get everything loaded in without the error, it still behaves the same (0 journal entries) and it will display the error eventually. I also think that most of the other difficulties I'm having are caused by this error (very few reports have the correct figures if there's any figures to be seen).

I also noticed at one point that very new transactions don't display unless I set the end time/date range to some time in the future. Could this have something to do with not taking daylight savings time into consideration or something along those lines? It is displaying the correct current date/time for the end date/time dropdown.

Anyhow.. After spending a couple of days getting everything running (working or not), I've decided to not spend much more time with the program until this issue is resolved. If I can help in any way, please feel free to drop me a line. When you get past this bug I'll be happy to try again. If I can get a version that does work how it should for me, then I'll be glad to pay the 100M ISK.

Thanks, and good luck :)

---

• Required sub-directories will now be checked for and created before anything else is done.


• Order state filter on the orders view will now work correctly when set to 'active'.
  User can no longer import data unless there is a character or corporation in the current report group.


• If the update status window is not visible when EMMA is started then it will be moved back to it's default position.


• User will no longer get the journal generations issue when updating the wallet journal from the API.


• Modified the import of old EMMA data to work in batches of 1000 entries at a time. This makes things a little quicker if you've got masses of data to import.

Originally by: Arthor Dark

---

Originally by: Jane Salva

---

Edited by: Jane Salva on 13/12/2008 16:22:11
I'm having some issues with the Assets report.

I added 11 accounts to EMMA, checked off the 33 chars in the manage accounts. Downloaded the API assets, transactions, journal, etc. Then I went to reports, all characters seem to be present there and all char boxes checked. Ran the report, but didn't get all the assets reported, only a large but far from complete report. So, I went back and just checked off one char out of 33 (which is a pain to do, since there is no check all or check off all buttons, or ability to sort by char name), then I realized that that it was Income Statement in the drop down Report to Create: menu, so I selected Assets Report, which reset all the Chars/Corps to have all chars selected again

So, I checked off all but one char (the one that's suppose to have some assets that were not reported before in the full report) ran it, but suprisingly it showed the same report as before, the incomplete full one. Tried again, and got the same result

---

Not trying to be rude, but is that on the to-do list somewhere at least? :)

Thanks.

---

Originally by: Raijen Ar'Desh

---

Originally by: Raijen Ar'Desh

---

No longer getting the journal generation error, and the journal updated successfully for my research toon and his 1 man corp just fine, however my main is now returning a different error updating the journal - "Eve API Error 100".

Will update after it tried to update again

---

Everything seems to be working fine now, all the journal information is there and reports seem to be running fine.

---

Originally by: Saira Jin

---

Edited by: Saira Jin on 19/12/2008 18:24:20
The orders are messed up for me.

Selecting, Expired/Filled orders, or really any of the "order" types does not yield any items in the list, except for one - a Rocket Launcher I buy order.

Edit: It is the Expired/Filled that does not show anything. Expired/Filled Acknowledge shows a list, which is long, but I don't have a way of telling if its complete. Overbid orders list does not work either.

I really appreciate the effort you put into this, Ambo. I bet you're wishing it was an Open Source project so others could fix issues concurrently ;)

---

Originally by: Vested Interest

---

Originally by: Ambo

---

Ah, yes.. expired/filled does not show anything because nothing should ever be set to that, they should go to expired/filled unacknowledged (or acknowledged if you've turned notifications off). The 'overbid' status is one that I put in there but does not actually get used yet so there will never be anything in there either.

I'll tidy them up in the next update.

Also, the code is still actually open source...

---

I actually have about 8 items under "Exipred/filled" (note the typo)

---

Originally by: Shar Tegral

---

Have to ask: Would it be possible to return some level of "manual" updating? I think this would also be helpful for debugging purposes. I just like having the control of what data gets added in and when. That can be important in trying to figure out what is going on.

---

Originally by: engimonger

---

Good Morning!

First things first, I love the EMMA app, it's perfect for what I've needed to get done. However... i have a minor glitch perhaps. For some reason EMMA is passing a System.OutOfMemoryException whenever I try to build a report on my asset data. I currently have three characters loaded in, so I'm hoping to figure out what's going on!

Don't get me wrong through, I love the program for what it does, makes my life far easier!

Note -- Exception Logs below!

=====================================================================================
EXCEPTION REPORT
=====================================================================================
12/20/2008 8:00:22 AM Error - ---------------------- Memory exception diagnostics ----------------------
List sizes:
Prices = 16777216, Capacity = 16777216, Mem = -268435Kb
Quantities = 3
Total quantities = 3Mem = 0.024Kb
Mem in use = 271755Kb

---

Originally by: Saira Jin

---

Edited by: Saira Jin on 21/12/2008 10:15:57

Originally by: Ambo

---

Ah, yes.. expired/filled does not show anything because nothing should ever be set to that, they should go to expired/filled unacknowledged (or acknowledged if you've turned notifications off). The 'overbid' status is one that I put in there but does not actually get used yet so there will never be anything in there either.

I'll tidy them up in the next update.

Also, the code is still actually open source...

---

oh well, then you shoul dhave a bounty system for fixing bugs - fixing a bug gets you your money back, of course, depending on the intensity of the bug/feature.

Damn I could take a crack at that Routing thing for collecting region-wide orders after they are filled, that you responded to in some other thread - that would rock, if I could get an optimal route to pick stuff up given a specific ship size. Even the display of item volumes in various locations would be nice to have.

No, I won't fix your <strike>computer</strike> program!

PS: Get Well SOON! and merry x'mas!

---

Originally by: Shar Tegral

---

Another suggestion I would make:

Put station, system, and region as columns in the "orders" display. Having those sortable is very helpful, even more so if some sort of filtering is possible.

Having this ability would be a mild cure to the lack of this in game.

Also, I'm finding that when the orders screen is displayed there is additional system load. (Haven't check to see how much additional load or specifically where.) Is the orders display a snapshot or a real time view of the SQL data?

---

Originally by: Arthor Dark

---

How many licenses have been purchased so far, if you don't mind me asking?

Reason I ask, is that I'd hate for you to stop bug fixing and updating if you felt that you're not getting compensated enough to continue doing this.

Also, do you take bribes to put in certain features into Emma?

Nothing personal Ambo. This issue probably has been brought up before, but how secure (from Ambo) is our finance information is? I know this is run locally on our machines, but what are the chances that Emma may be sending API keys to Ambo?

---

Originally by: c0rnf3d1

---

let me know when multiple corp issue is fixed, i still only see about 1/4 of my transactions on a report. my trial has ran out, but will purchase once fixed.

---

Originally by: Vested Interest

---

I use Eve Asset Manager 1.5.1 to keep track of what's where. I really dig the simplicity of the interface. But when I update the database from the API it keeps EMMA from being able to update it's own data for 24 hours.

I can export a csv file out of the Eve Asset Manager and I believe it keeps the XML files it downloads (\application data\heavyduck.eve\) for each character, until the next update.

Any chance you could get EMMA to be able to import either the .CSV data export or the XML files so I can get up-to-date inventory into both programs for analysis? I'm thinking a one-button "Update inventory data from cached XMLs in location X" would be ideal.

Or is this functionality present already somewhere?

---

Quote:

---

I'd also like to see some rudimentary inventory level alerts implemented, like "Alert: Stock of 'Arbalest' Capacitor Flux Coils has dropped below specified level of X units!"

---

Quote:

---

Thanks again Ambo, I had my 3 biggest days of sales ever this weekend and I credit it entirely to EMMA keeping me on my toes with alerts. I juggle 8 traders and this program makes it fun again!

---

Quote:

---

I have a glitch where sometimes the alerts window doesn't pop-up again after I've closed it. Then when I launch EMMA in the morning I'll get like 65 alerts that I somehow missed the day before.

---

Quote:

---

Edit: Could you make the Orders window default to whatever view you left it on, or barring that have it open up with "Active" orders visible?

---

Originally by: Vested Interest

---

Does the Assets report and the Assets total in the NAV report reflect the estimated value of items currently up for sale on the market?

---

Originally by: Sophie Daigneau

---

Would it be possible to include the industry API information in a report? I know you don't want to get too deep into industry info, but just having the industry jobs included in the NAV report would be handy for valuing corps with large numbers of build jobs.

My second request would be to be able to exclude the different corporate hangar divisions from the asset and NAV reports.

---

Originally by: Shar Tegral

---

Next little thing... when making a report I often deselect from the list of available toons/corporations to be included. This list is sometimes long given some of the people I provide accounting services. Also, if I change the report type I want (after doing my selections) all toons/corporations are reselected.

The thing is, could you make a select/deselect all?

---

Originally by: Vested Interest

---

Originally by: Ambo

---

The assets report does not but the NAV report assets total does.

This is simply because I figure with the assets report you want to see stuff that is 'out there' rather than waiting to be sold in sell orders. The NAV report obviously needs to try and include everything you own. Also, the assets in those sell orders will be valued at the price of the order rather than trying to work it out like normal.

---

Excellent! Exactly how I'd like it.

Have you played with that cross-region trade analyser Eve Market Scanner? You point it at your marketlogs folder and mash the export button with every lookup you do and it lets you compare regional data side by side. I think I mentioned this earlier but I'd like to see something like this in EMMA with some steroids pumped in so it flags you on deals you need to take advantage of in some fashion.

---

• Added a 'toggle all' button to the create report screen that will select/deselect all characters and corporations.


• Various lists and dropdowns of characters/corps in the report group and dropdowns of public corporation names will now be sorted alphabetically.


• Dropdowns in the route planner tool will now be sorted alphabetically.


• Dividend, share transaction and share value history creation/maintenance screens will no longer allow banks to be selected.


• The times of journal entries, transactions, orders, contracts, dividends and share transactions can now be configured to be displayed in eve-time (UTC) or your system's local time. Internally, EMMA will ALWAYS store dates in eve-time (UTC).


• 'Auto-update settings' has been changed to 'Other settings', this contains the new timezone settings.


• On the item report, time can now be specified as well as date.


• When updating from the assets API, the time of the update will be set to the time the data snapshot was taken rather than the actual time the update request was made. This ensures that EMMA can make the next request as soon as possible.


• The 'OutOfMemory exception' will no longer occur when running certain reports. For those who are intersted, this was not caused by using too much memory (useage was only around 250Kb when this occured). It was caused by the caluclation of median values where more than 2.7 million units where being bought or sold and was corrected by using a frequency distribution table instead of a flat list.

Originally by: Vested Interest

---

Dang you've been busy!

Edit: For those of us using Margin Trading does the API show how much we owe on margin? I'd like to see that data in the NAV report somehow.

Here's a recurring crashlog I get maybe 1 in 5 times I launch EMMA. Probably something squishy with SQL on my box. It always comes up clean the next attempt:

=====================================================================================
EXCEPTION REPORT
=====================================================================================
12/20/2008 9:39:24 PM Critical - Error connecting to database
Inner Exception: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)

---

Originally by: engimonger

---

Great patch!

The fix works perfectly and I can use the asset dumping report. Quick thing I noticed, nothing huge, but in the trade route planner, a .net exception is thrown if you accidentally stuff the same system in twice, one right after the other. Normally this shouldn't be a problem, but using emma on my laptop, I've more than once hit Add WP twice by accident, would it be possible to add a remove WP button or something of the type?

Also, the the setting for local time makes things much easier! Many thanks!

---

Originally by: Adlee

---

Bug with report generation in .18:
Generating asset report with just Num items, Est buy price, and Recycle price listed, get unhandled exception, total est. value cannot be found. Parameter name columnName

Details:
************** Exception Text **************
System.ArgumentException: Column named Total Est. Value cannot be found.
Parameter name: columnName
.
.
Also: Is there an easy way to hardcode mineral prices?

---

Originally by: Vested Interest

---

Request: saving "memorized" reports and report groups, by name, that can be initiated all at once.

I.E. I want to select a report group to be run and get my custom Assets report, my custom NAV, and my custom income report, all from one "go" button once i've defined, named and grouped the different reports.

Edit: I have pruned up my Items Traded (settings->item values) list a couple times so it would only have the stuff I'm currently trading. Twice now the list has apparently auto-repopulated itself with all the stuff I removed.

Any way to have it not re-add things to the list that I've removed, or to prevent it from auto-updating itself after I've cleaned up the list?

---

Originally by: Gunpey

---

Hi Ambo

Would it be possible to make it remember all window sizes, what i think of is the internal windows, like journal and transactions, that would be nice, and maybe also it remember the width of the columns.

---

Originally by: Gunpey

---

Hi Ambo

Don't know if this error has been reported before.
When im trying to do a Item Report, and i tick "Categorise Items" i get "Arithmetic overflow error converting expression to data type int."
Error Log below.

=====================================================================================
EXCEPTION REPORT
=====================================================================================
29-12-2008 15:59:57 Error - Problem creating report.
Inner Exception: Arithmetic overflow error converting expression to data type int.

---

Originally by: Vested Interest

---

Feature request:

Could you make an option for EMMA send out a plain-text email alert for each Order Alert it generates? I would like to have just one more place where these alerts are stored. Sometimes I clear one and make a mental note to act on it, and then forget about it.

I'm not a programmer but I assume you could utilize something like the BeyondLogic Bmailer:
http://www.beyondlogic.org/solutions/cmdlinemail/cmdlinemail.htm

I'm still having some glitches with the alerts window not popping back up after I've closed it during a session. Basically if there are alerts in the window that I haven't cleared and I close it, I can't get that window back without re-opening the client. Then it pops back up automatically.

Edit: glitch report. When I have a list of unacknowledged orders sorted, let's say by "Owner" and I clear an alert, it resorts the list according to some criteria rather than leaving it sorted in the manner I'd picked.

Also, what is the criteria for the default sort on the Orders-expired/filled Acknowledged view? It doesn't seem to sort by any of the fields visible, but I suspect it is sorting by the date the alert was generated somehow. This is good, but not visible to the user.

---

Originally by: Mita Tza

---

I`d like to see an analysis of the current assets against the current highest buy-orders.

How much would i get for all my assets now if i sell to buyorders in Region X ?

I wanted to value my assets - but those idiotic scammer sell orders (200 mil for a 1mn afterburner 1) are having a very bad impact on the average isk value.

Thats why matching to buy orders would make sense

---

Originally by: tonedog2008

---

whats the licence key for? do i need that to download this program as the link aint workin for me?

---

Originally by: Marcus Praetor

---

Hi Ambo

I would gladly take you up on your kind offer of a free licence key. EMMA looks fantastic, and I only wish that I had 100 million ISK spare to give you.

I'll gladly give you the ISK once I've been able to make some though!

Thanks
Marcus

---

Originally by: Jonas DaVerde

---

Thanks for the explanation. I thought it is working this way but it has a little glitch in it that makes the received data unprecise. To get proper values every time I would have to start gathering data into EMMA with clean assets on the character. And I don't think anyone is doing so.
I don't know how to explain my point but it is like this. When I started downloading EMMA data I already had some 425mm in stock. I sold them and bought many times since but none in the last 2 weeks (and I had none in stock for that time). So in EMMA data it stands as I have sold more then I have bought. Yesterday I bought another 100 pieces on half price of what it used to be 2 weeks ago and sold for the same price as 2 weeks ago. Meaning the real cost of units sold for that 100 should be the price I payed yesterday not the one 3 weeks old. So it looks like if I had that 100 pieces before downloading EMMA data and I sold them the raport says Bought=0 Sold=100. Now I buy another 100 and sell them and it states Bought=100 Sold=200 but it calculates the price for the new buy using the old prices giving me inaccurate profit information.
I don't know if you get my point. my english is not good enough to explain it simplier.

---

Originally by: Olari Vanderfall

---

For some reason my transactions are not being updated. It says they are, but when I go to look at them I only see a few transactions. I know there are more because I can see them in game and with the old version of EMMA.

Also what files are necessary to backup if I want to restore the data?

Thanks.

---

Originally by: Lui Kai

---

First off - great app.

However, when I first loaded it up, I got a failure to load error when the app was getting my journal data. Ever since, the app completely ignores all of my assets except a single shuttle for some unknowable reason :p There are quite a few ships, several billion in minerals, blueprints, et cetera at the same station as the shuttle, so I have no idea what that item was picked.

Is there any way to just clear out the old data and get it to try loading the API completely fresh?

---

Originally by: RaTTuS

---

Ambo ,
Very nice app.

Please update your BIO to say that you do Emma ;-P

I've sent you some iskies

---

Originally by: General Newbold

---

just started trading recnelty and i cant find a alternative to this, other than excel!

---

Originally by: Yatta I

---

tried it... didnt help :X

---

Originally by: Vhiskey

---

assets:

a) the data on the left and right arent corresponding. e.g.: left side shows 1 cormorant in a specific station, right side says 2 cormorants

b) the data on the left AND the right arent correct at all. e.g. : on that station above i got 3 cormorants.

---

Quote:

---

trit, iso, zyd and mega arent displayed at all. cant remember if it was under assets or assets report or both

---

Quote:

---

NAV report:

- i got stats before my ingame date of birth. why?

---

Quote:

---

asset report parameters:

- display the regions in alphabetical order or just leave the option to sort that way
- give single display options, such as: constellation, a system, a single station, a single container in a station (can the containers¦ names be imported?), and so on. maybe running 2 bulding cycles. first for the filters, second for the display options

---

Quote:

---

asset report:

- i dont like that the item category trees are all open by default. would like to be able to decide whether its all open or closed
- add a column "reprocess value per item" including the display options "perfect" or "based on skills"
- add the option: dont display items bought in 0.0
- i¦d like to be able to sort that report by clicking columns¦headers, e.g. sort by difference betw. est. gross profit and reprocess value (desc/asc) (such a column should be added)
- dont display reprocess value for items that arent reprocessable (i bought some of them cause that value was really great.. )

---

Quote:

---

route planner:

- add the option to display only systems with a specific amount of items or m¦

---

Quote:

---

display an (b) or (s) behind items in the assets report i have active buy or sell orders for

---

Originally by: Van Doren

---

Suggestion: Make the grab of the API stuff only after the user logged in and in the case of Trial, that the Close on the Trial key window is pushed (or succesful addition of the Emma key - waiting for mine atm).

Opened the app but the trial was over and while I had the Emma Key prompt open, the App was loading the API stuff behind wich screwed other applications from getting the results of the same API call for awhile. (and assets stuck there for 24h.)

---

Originally by: Loaby

---

mmmh....the asset tab doesnt show me my coercer on the left but it does on the right. i still dont get it.

also: i have 13 containers and i got 2 rows for containers on the right (quantity 11 and quantity 2). behind the 11 containers there is a number (xxxxxx). why are my containers splittet and what do these numbers say?

info: the asset tabs shows me all my minerals while the asset report still does not.

one more question: how do i zell the autorouter my starting system? cant find that.

---

Originally by: Skie Ankora

---

Understood about priorities vs. effort etc. I don't want you to go to a lot of effort to fix this just on my account.

However that said, rather than my ISK back, I would still like to be able to use EMMA again :)

I think we should be able to come up with a quick work-around that will be minimal effort on your part. I have an idea, I'll convo you in game about it if I catch you online if that's OK.

---

Originally by: Loaby

---

is it possible to force an assets update and not to wait for the next automatic update?

---

Originally by: Jonas DaVerde

---

Little bug: yesterday one long term sell order of mine has expired due to the time running out. But in orders tab in EMMA it is still shown as active order. It was a first order to expired by its own since I started using EMMA so can't confirme it happens every time.

Question: assets raport estimated value of items in my possession shows 1b. When looking at orders value of items being sold I see 500m. That gives me total of 1,5b worth of assets. Now generating NAV raport and in Assets position I get a number of 2,5b. So what is EMMA calculating into this position of raport that it is so much higher then the real value od assets?

---

Originally by: DrDimeBar

---

How do i install this?

downloaded 1.0.0.1 off the front page of this thread, extracted to an EMMA folder that i put within eve, and when i run setup i get:

Unable to satisfy all prerequisites for EMMA. setup cannot continue until all system components have been successfully installed.

Details:
Prerequisite check for system component SQL Server 2005 Express Edition failed with the following error message:
"This version of SQL Server 2005 Express Edition is not supported for the current processor architecture."

I checked the readme, and the faq on the first page, and no clues.

I am running xp64.

Help?

---

Originally by: Dibsi Dei

---

Edited by: Dibsi Dei on 12/01/2009 06:16:35
Hmm, even deleting account api from group and readding doesn't help. Should I remove and readd the whole group? :S

Edit: Even with readding report group it says No Access on this character.

---

Originally by: Leveraged Equity

---

No issues to report with the new version. Still trying to get it to see my newer trader though. Will any data be lost with removing an account from the group and re-adding it?

---

Originally by: Arya Aiedail

---

Edited by: Arya Aiedail on 12/01/2009 23:09:47
hello i was wondering if you could send me a licence now if possible i ll send you the isk now thanks arya

isk sent

---

Originally by: Leveraged Equity

---

well I removed the account and quit and then readded it, and nothing seemed to change.

Then I relaunched a couple times and waited about 5 minutes and opened "Manage group" and there she is!

I have no idea

---

Originally by: Hiroto Nakamura

---

Hey Ambo great piece of software on my first few hours with the trial right now. Must say I haven't used EMMA in awhile because .9 was too slow and than I had SQL Express 2005 problems with Vista. However using 1.x and SQL 2008 as per the guide here I have it running real nice, only a few .NET exceptions here and there but seems to not hinder the program from running. I will most likely be purchasing this but I have a question.

Under Investments I have tried adding some deposits to banks and than I adjusted the interest rate in the Corp Details but it does not change the interest already calculated. I click the Recalc Interest button but nothing happens, I delete the deposit and try to recreate a new deposit but it leaves the already calculated balance as Current balance. As well I cannot delete any of the corps, the button is grayed out.

That is probably the only section I am having problems with everything else is very smooth and providing me with great information. Some features that right away I feel a must have would be ability to copy values from cells. If I wanted to copy ISK values out of the transactions (I kept trying to right click and copy like excel lol). Next some kind of built in calculator to be able to add up ranges of numbers would also be really a real time saver and wonderful feature. As right now I am typing everything manually into windows calculator and when you are dealing with many transactions in the 8-10 digit range this becomes very tedious.

However I realize this program is more about fetching information into databases and displaying it so none of those features would be possible or in the scope of the program, but I thought I would throw in my two cents. Keep up the great work and thanks again.

---

Originally by: Highlord Nicolai

---

I got an error when starting up:

Error

There was a problem validating your installation.
Requested registry access is not allowed

Any ideas?

---

Originally by: Deimosian

---

So far I like the idea of what EMMA does, but I have run into exceptions using. An example of such an exception is below:

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.

---

Originally by: Leveraged Equity

---

The alerts are working much better Ambo. It's almost spooky how quiet Emma is now, instead of waking up to 125 new (repeat) alerts there are maybe 2 unique originals Almost makes me wonder if it's working


Only gotcha I still have is if I close the alert window with an unacknowledged alert in it, I have no way to get it open again without relaunching.

---

Originally by: Vhiskey

---

Edited by: Vhiskey on 14/01/2009 11:59:10
how do i change the destination station in the courier settings and/or courier calculator? dont get it

---

Originally by: Vhiskey

---

uh oh, stupid me

thank you


edit: i just caused an unhandled exception when i entered a quantity in the courier creation window without an item type. when i hit ¦add¦ it caused the exception. i hit the quit button of the exception window and emma was closed. after restarting emma showed me 13 unacknowledged expired orders. these orders are all "duplicates" as i already got them earlier today or yesterday. intended?

edit 2: it might help to add a column with the date of the expiration

---

Originally by: Ulecese

---

is this compatible or are there any plans to make this compatible with windows 7?

---

Originally by: dArK v1rU5

---

Hi,

I have just downloaded this and am trying to get the program to work. I have input my api details, but when it tries to update the program with all my stats, eg assets, orders, journal, transactions, then in the api update window it just says error and a timer for 30 mins. What is this, and how can I fix this.

Many Thanks

---

Originally by: dArK v1rU5

---

Hi, it says that i need to input the full api key to receive financial information. Only the full api key has been input, i have even changed the api key and it still doesn't work, i dont know what the problem is !?!

---

Originally by: Loaby

---

another unhandled exception when i tried to close emma. wasnt able to close it at all (had to do it with the task manager):


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.NullReferenceException: Object reference not set to an instance of an object.

---

Originally by: Loaby

---

Edited by: Loaby on 16/01/2009 08:08:33
mmh....something strange appeared to me. the assets view shows me not the correct number of items. it shows me way more than i have at one station. an example: at station x i have 74459 paradise cruise and emma shows 140099. same problem for wrath (for wrath it is exactly 2 times the amount) and cataclysm. all other items are correct so it might be an "cruise missile"-error? i havent picked up, courier conracted or sold any items at that station since the last assets update. i looked at another station in the same system and the items¦ amount is correct (including cruise missiles).

edit: same to civilian shield booster. it shows me exactly 1 more at several stations

---

Originally by: Daijoubu

---

Ok, thanks for your help. I see where I was having troubles. I was testing in the route planner and typing Hek. It found the Hek system, but there's no feedback because it was a perfect match. Now I have a new issue. When I run the Auto-Contractor I get Error An item with the same key has already been added. What does this mean? (besides the obvious db admin issue)

---

Originally by: Daijoubu

---

Thanks for your quick response Ambo! Looking forward to the next version as Auto Contractor is the big selling feature for me at the moment.

---

Originally by: Viuhti

---

Eve Files :-(

I cannot download anything from there, for some weird reason... No matter at what time or browser i use. The download get either stuck at 0% with 0 kb/s or at 4% with random kb/s.

That's with all the files from there, not just yours - and have been since, ever.

---

Originally by: Saira Jin

---

Edited by: Saira Jin on 17/01/2009 20:43:15
When I try to create reports, say an NAV report for all my characters, EMMA bugs out when it gets to one character (of three total characters).

The message in the window where the report is being created is:

Problem Creating report
Object reference not set to an instance of an object.

This happens when it get to the assets of the first character. creating a report without this character selected succeeds. Please let me know if there is something I can do to provide debugging info. Do let me know if you manage to fix this - this is very annoying.

---

Quote:

---

Also, when I try to create the Assets report for only one character, the report actually includes items for all the characters!!! So there is no way I can deselect two characters and the corps and get an Assets report only for one character. This is just broken.

---

Originally by: Loaby

---

edit: whats new in the new version?

---

Originally by: Ricdic

---

Hi Ambo in the "Order Notification" box that comes up. I just wanna say firstly that is awesome and an immense help.

However could there be a way in the Order Notification settings for one to set a timeframe that an order notification comes up. For example when the order has reached X% completion, or X units remain in the order? Basically allows us to choose to restock before we run out rather than after the occurance

---

Originally by: Leveraged Equity

---

Still fighting with the alerts a bit: When you have a bunch of unacknowledged alerts in the window sorted by owner, and you clear one of them, it reshuffles the list view sometimes causing me to clear alerts from a different character the next time.

---

Quote:

---

Could we get the usual "Owner" drop down menu and "Any Owner" check box at the top of the # Unacknowledged Orders window?

---

Quote:

---

Edit: I just discovered the Assets report is broken, it isn't calculating any sell values for me anymore. The Qty and Avg Buy Price columns are populated but none of the columns to the right are.

Sorta throws off my NAV report too

---

• New system to store historic values for individual items. This is used by the NAV report and results in more consistent figures, particularly over longer periods of time.


• Complete reprocessing module added. See tutorial for full info.

• An 'About' screen has been added. Accessible through the control panel.


• The Orders view will now show the remaining isk value of an order as well as the system and region the order is placed in.


• The orders view now has filters for station and type (buy/sell/any). The Transactions view also has a type filter.


• The orders view now has a button to open the unacknowledged orders screen.


• The Journal view now has a filter for name. This will match any journal entry with a sender, corp sender, reciever or corp reciever whose name contains the sequence of characters in the filter field.


• The sizes and positions of most major forms will now be remembered. Additionally, the widths of all columns in most data table views will now be remembered and used next time the view is opened.


• The list of regions on the asset report parameters screen will now be sorted alphabetically.


• The assets report now has an extra column showing the profit based upon using either the sale value or the refine value, whichever is better.


• All 'view' tables (i.e. transactions, orders, etc) now have a right click menu that allows you to copy text or data from the row or cell that you click on to the clipboard.


• Combobox dropdowns for stations, items, etc, are now textboxes that will prompt the user with suggestions when typing (This matches the style used in-game).


• The auto-updater details screen will now show version history. This document will also be available in your EMMA directory.


• The auto-updater will now work better with Vista serurity. Big thanks to Skie Ankora for helping me with this. You should now be able to run EMMA on a non-administrator account under Vista. If the auto-updater detects that updates are available then it will test for write access to the EMMA runtime files. If you donÆt have access then the program will prompt you to run as an admin to complete the update.

• Fixed a bug causing a crash in some cases when running reports or creating contracts involving an unknown item. (This was caused by the snowballs because they are not in the Eve data export)


• Fixed a bug that caused crashes when running the assets report when the total quantity of a particular item or exceeded the 32-bit integer limit (around 2.1 bil).


• Also fixed a similar bug affecting item reports when there were historical transactions for an item with quantities totalling more than 2.1 bil.


• Fixed a bug that would cause a crash when creating a contract when the contract had a total expected profit of zero.


• Fixed a bug affecting the item and assets reports that caused the character/corp settings to be ignored. i.e. they were retrieving data for all characters and corps.


• Fixed a bug that caused group locations involving a station + x jumps to only return stations within the specified system.


• The Route Planner will no longer crash when the same system is entered twice.


• Fixed a crash that occured when displaying an assets or item report with certain columns disabled.


• EMMA will now check for new characters on an account automatically, these will be displayed on the report group management screen as soon as they are available through the API.


• EMMA will now deal correctly with characters that have thier corporate data access privilages removed.


• Views will now correctly remember the column and direction used for sorting when filters are changed, order notifications are acknowledged, etc.


• Fixed several bugs that could cause crashes when closing EMMA.


• Fixed a bug that caused a crash if the user clicked the æaddÆ button in the contract calculator with a quantity specified but no item selected.


• Fixed a bug that caused an error when running the auto-contractor if the pickup station was the same as the destination station.


• Fixed a bug that could cause a null reference exception when running the NAV report if the character being reported on has been removed from the account.


• Fixed a bug that caused the æskip sectionÆ button in the tutorial to always skip right to the end.

Originally by: Skie Ankora

---

Hi Ambo,

Thanks for the updates :)

I'm running the new release 1.1.0.3.

The AutoUpdater.exe still prompts for me admin access on Vista. Did you say it was not supposed to any more?

It has the little shield icon next to it which means explorer somehow auto-detected that it requires admin access.

My AutoUpdater.exe version is 1.1.0.0, is that right?

---

Originally by: Qordel

---

It'd be great if EMMA refreshed existing windows to show the most current data rather than having to change the dates manually to cause a refresh (or closing/re-opening for orders).

---

Quote:

---

It'd be cool if windows remembered their sizes/locations/etc, too... which I don't think they currently do.

---

• Fixed a bug causing the first column of reports to always be blank.


• Fixed a long-standing bug with the item report that could cause items to not be shown on the report despite sales or purchases definatley having been made within the specified time frame.

Originally by: Skie Ankora

---

Originally by: Ambo

---

I havn't changed anything in that area since we were testing yesterday so it shouldn't be prompting now if it wasn't then.

If Vista is detecting that it needs admin access automatically then I'm not sure what else I can do.

---

No mate the update program is working just like it was before - no problems there. It did exactly the same thing on the test beta version you sent me. Although we were talking about you making further changes to stop Vista detecting it as needing administrator rights. I just wasn't sure whether you'd done that for this update or not.

---

Quote:

---

Also, I'm having a problem with the 'cost of units sold' not being correct (this was wrong before the update aswell). E.g. Transactions window shows a single unit bought for 8m and a single unit sold for 15m, but cost of units sold shows 4.5m. I know the cost can depend on previous buy orders etc. but this is an item that I have literally only ever sold and bought exactly one unit of, so I know the value should be 7m (assuming I am understanding it correctly of course!)

---

Originally by: Saira Jin

---

By the way, reprocessing crashed on me too, but since you have a couple of bug reports, I will wait till the first minor update to see if it exists!

---

Originally by: Saira Jin

---

The Unit Value for items in the Reprocessing window - how is that calculated?

Also Ambo, I keep forgetting how item values are calculated in the NAV report. Could you please add that to the main description of EMMA in this thread or in the docs/tutorial or someplace accessible?

Sometimes the values for items reported by EMMA just "feel" way off, intuitively, so I see my NAV jumping up 200mill one day, and down 200mill the next, and I have spent hour figuring out why sometimes.

---

Originally by: Loaby

---

the auto-contractor doesnt seem to use the values i set via ¦item values¦

---

Originally by: Karan Diras

---

I am not sure if that problem was already posted:

It seems to me, that the reprocessor is pretty much off considering prices and the amount I can reprocess... I mean I am pretty sure that I wont get 4.7 bil on a cyclone if I reprocess it.
Unit values are off most of the time in the reprocessor: A basic implant costs normally around 6 million, not 600 mil...

Also in the assetts report some numbers, espescially for ships, are off like that mentionend 4.7 bil or 7.3 bil on a drake.

So, do I have to give him the unit values manually, even if I have those prices correctly somewhere else in the program? Or is it just a bug?

---

Originally by: Leveraged Equity

---

Assets report still shows me only total units and average price and is blank to the right of that.

---

Quote:

---

Edit: just found the "unacknowledged orders" button but it doesn't seem to pull up the window for me.

Request: clicking on the character portrait in the main window checks/unchecks all API boxes for that character.

---

Originally by: Rada Ionesco

---

So I am wondering with this new version costing 100 mil, how quick will the problem/support solution be? I would like to invest in this for my corp, but don't want to waste 100 mil if the fixes take days of weeks to implement. Any user feed back, or even author feed back that may may change my mind?

---

Originally by: Mantarro

---

Edited by: Mantarro on 21/01/2009 18:37:46
I was wondering if I am missing something in the item report.

I produce modules and sell them but never buy them, so the buy price is always blank and the gross profit is negative by the sales tax amount.

Is there a way of entering say the build price as a buy price for use in this report?

Regards,

Mantarro

PS lates upgrade fixes the NAV report thanks :)

---

Originally by: Leveraged Equity

---

positively 1.1.0.4 here,

---

Originally by: Bret Caliaro

---

How do you update your API code I tried to change mine in the manage group window but it will not change from the original one that I entered?

---

Originally by: Deielle

---

Holy Jesus. This app is awesome. Thank you.

---

Originally by: Skie Ankora

---

I did some research and I think I found the problem - Vista detects any executable with certain keywords in the name as requiring administrative rights, including the keyword "update" (see here for further details: http://msdn.microsoft.com/en-us/library/aa905330.aspx).

The best way to stop it is to include an application manifest with requestedExecutionLevel set to "asInvoker", as explained here (shows how to do it in Visual Studio): http://msdn.microsoft.com/en-us/library/bb206295.aspx.

---

Originally by: Skie Ankora

---

Originally by: Ambo

---

The cost of units sold is still wokred out in the same manner as described in the FAQ here .
The only change I've made is that if there are reprocess jobs that produce the item then they are taken into account as well when calculating the cost of units sold.

If you buy one unit at 7m and sell it at 15m and you currently have no units anywhere else then the cost of units sold should be 7m.

I'll try setting up some simple test cases with an alt to make sure it's definatley still working as it should but certainly it seems fine on my main.

---

I've looked into it some more and you are right - I was misunderstanding how cost of units is calculated.

I'm still finding it gives misleading answers in some situations. For example look at the attached graphic showing a dump of my transactions for an item and the corresponding item report on it http://eve-files.com/dl/184736. The cost of units is shown as 9m because that was the earliest buy price back in December. The sale price was 15.5m so that gives a net margin of 6.5m. However I recently bought the item for 5.25m and sold for 15.5m, for a net margin of 10.25m.

So the net profit values emma is currently giving me are quite misleading at the moment. However, the new algorithm improves on the way Emma used to work in some situations. e.g. in the reporting period you sell an item but don't buy any units, the old Emma would show a profit equal to total sale value rather than deducting the earlier buy price.

I need to think on this some more, it's complicated... All I know now is most of the time I'm not finding the output of the item report very useful for determining my actual net profit. But on the other hand the new way of doing things does make sense in a lot of ways. What are your thoughts on it?

---

Originally by: mr bighelmet

---

I got this error when Emma was pulling data.

=====================================================================================
EXCEPTION REPORT
=====================================================================================
22/01/2009 06:04:55 Error - EveMarketMonitorApp.Common.EMMAException - Error when adding journal data from api
Inner Exception: Violation of PRIMARY KEY constraint 'PK_Journal'. Cannot insert duplicate key in object 'dbo.Journal'.

---

Quote:

---

This one i got when trying to run the NAV for the charcter that got the data update error

=====================================================================================
EXCEPTION REPORT
=====================================================================================
22/01/2009 06:26:26 Error - EveMarketMonitorApp.Common.EMMAReportingException - Problem creating report.
Inner Exception: Object reference not set to an instance of an object.
Stack Trace: at EveMarketMonitorApp.DatabaseClasses.ItemsTraded.GetItemValue(Int32 itemID, Int32 regionID, DateTime valueDate, Boolean buyPrice)

---

Originally by: Saira Jin

---

Ambo,

I think I stumbled across a major problem - (NAV/Asset report inconsistencies)

---

Originally by: Loaby

---

found a small thing:


the autocontractor uses the unrepackaged m¦ for ships although ships have to be repackaged when you sell them via market.

that gives me huge m¦ numbers for my contracts and might as well exclude some possible contracts due to my autocontractor settings

---

Originally by: Mantarro

---

I do trading and production so EMMA is still the best option for me ATM.

Am I correct in saying that in the traded items list you can now override prices of items by typing them in?

If so then you could add a check box to the item report "use traded as buy price when zero" and achieve the result I am thinking of.

Is that feasible?

Regards,

Mantarro.

---

Originally by: achoura

---

Is this capable of tracking and analysing contracts data or is it limited to raw market data?

---

Originally by: Rada Ionesco

---

I just realized that one way around this problem could be through contracts or sells orders done with a alt in a shell company. Let me know if this doesn't seem like it would work, but it I am thinking it might make sense. You have an alt produce the items (or just get them from your main), then he puts them up for a sell order, you time it so you can purchase the order immediately then set up your sells, thereby allowing the EMMA to track the buy as a trade function. I was thinking this may work with contracts too, but I am unsure about how EMMA outputs contract data in relation to sell info.

One drawback for me with recently is that my API won't work with it, same problem I am having with evemon. Ever since the Quantum Rise expansion my api keys only work on certain programs. Spo I can't really try this theory out because I can't get my info to load up on EMMA.

---