open All Channels
seplocked Market Discussions
blankseplocked EMMA - The Eve Market Monitoring Application
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: [1] 2 3 4 5 6 7 8 9 ... : last (19)

Author Topic

Ambo
I've Got Nothing
Posted - 2007.11.29 12:47:00 - [1]
 

Edited by: Ambo on 01/12/2008 16:24:40

*********************************************************************
************* Please see this thread for the latest version of EMMA ************
*********************************************************************

Today I am releasing EMMA, a project that I have been working on, on and off, for around 6 months now.

EMMA is a helper application for traders, investors and CEOs in Eve. The code is open source and the program is free to download and use though I would hope to get a few ISK donations to pursuade me to keep things going. ;)

I will fix errors, implement new features and continue optimising the current code for free.

Alternatively, I’m happy for people to develop new features themselves through the project hosted at sourceforge.

History
Key Features
Bugs
Enhancement Requests
Common Problems

EMMA is still a reasonable complicated application so I highly recommend reading the manual included with the zip file before diving in.

If it does not work then try reading the ‘installation’ section in the manual, otherwise I can be contacted in-game or at ambo.emma@googlemail.com

Download Full Install for version 0.9.1.27
Patch to latest version (v0.9.1.27)

Requirements:
.NET 2.0 runtime - x86 version (get this one if you're not sure)
.NET 2.0 runtime - x64 version
SQL Express 2005.

In-game mailing list EMMApp will provide news on updates as they become available.

Please note that despite reigorus testing and being in daily use, EMMA is still at a 'beta' phase and problems should be expected.

Also, you use the software at your own risk, if it screws anything up then it's nothing to do with me.

Ambo
I've Got Nothing
Posted - 2007.11.29 12:48:00 - [2]
 

Edited by: Ambo on 29/04/2008 07:48:57

History


EMMA started as a replacement for an Excel sheet I was using back in June this year. I initially planned to have the whole thing finished and released within a month or so but after a few weeks I just wanted to finish it and rushed things a little, leaving the program in an unfreindly and unreleaseable state. Still, it was good enough for me so I just used it myself for a few months.

When I ran my IPO in September, I made some improvements to EMMA and tidyed the whole thing up a bit, it was still not very friendly but in early October, Ricdic asked if he could get a copy of the program I used to produce my reports and I was happy to oblige. A few days later, he contacted me asking if I could add the ability to automatically track dividends from the journal data.

Since then, I’ve been busy adding a lot of new functionality as well as pollishing and testing the old stuff.

Ambo
I've Got Nothing
Posted - 2007.11.29 12:49:00 - [3]
 

Edited by: Ambo on 29/04/2008 07:48:45
Key Features


• Retrieve journal and transaction data from the Eve API and store it in a local database that can be accessed without restrictions.
• Ability to work with corporate or personal data.
• Import/Export capability to allow transfer of data between systems, data backup and multiple accounts on one system.
• Assisted courier contract creation based upon many user-defined variables.
• Tracking of assets from transaction data and courier contracts.
• Ability to store details about public corporations including share value, dividends, web links, etc.
• Share transaction tracking
• Detailed reports including:
o An income statement constructed from journal data.
o Useful details such as profit margins and total profit on items traded.
o Current assets including value.
o Share profit details such as percentage return per day based on dividends, sales, etc.
• Highly customisable report style.

Ambo
I've Got Nothing
Posted - 2007.11.29 12:49:00 - [4]
 

Edited by: Ambo on 29/04/2008 07:48:30
Common Problems



1. 'Could not find stored procedure xxx' errors

Quote:
Find the file "user.config" in "C:\Documents and Settings\<windows username>\Local Settings\Application Data\EveMarketMonitorApp\EveMarketMonitorApp.exe_Url_<random numbers and letters>\0.9.1.26"

Open it in notepad and find a line that looks somthing like this:

<setting name="DatabaseVersion" serializeAs="String">
<value>15</value>
</setting>

Replace whatever the value is with 0 (zero) and restart EMMA. It will take a while to startup as it is rechecking all the changes it's made to the database but hopefully this will find and resolve the problem.


2. Cannot find file: item_data_update.xml

Quote:
Download the items_data_update file and extract the xml to your emma\data directory.


3. EMMA appears to hang on the splash screen

Quote:
This is caused by a large update to the database. On slow computers it may take an hour or so. Simply leave it running, overnight if necessary, and it should be fine.

Ambo
I've Got Nothing
Posted - 2007.11.29 12:50:00 - [5]
 

Edited by: Ambo on 11/12/2007 08:46:19

Ambo
I've Got Nothing
Posted - 2007.11.29 12:50:00 - [6]
 

* reserved *

Ricdic
Caldari
Caldari Provisions
Posted - 2007.11.29 13:35:00 - [7]
 

I detect a lot of Epic Win in EMMA. Installing it now to go for a test drive.

Thanks heaps Ambo

Astorothe
Aperture Science Industries
Posted - 2007.11.29 13:50:00 - [8]
 

Edited by: Astorothe on 29/11/2007 14:19:07

I'm getting a .NET Framework error on most of the actions - ranging from enabling corp mode to trying to view transaction details.

Shuan Jedai
The Graduates
Brutally Clever Empire
Posted - 2007.11.29 13:57:00 - [9]
 

Originally by: Astorothe
I'm getting a .NET Framework error on most of the actions - ranging from enabling corp mode to trying to view transaction details



Ditto.

I guess I have used the API within hour (EveMon) and it fails to download becouse of that. It can't seem to handle the error though and just crashes.

Shut down Evemon, going to give it another try in 1.5 hrs.

Astorothe
Aperture Science Industries
Posted - 2007.11.29 14:02:00 - [10]
 

I havn't used EVEMON in over 8 hours.

Ricdic's Hoe
Posted - 2007.11.29 14:03:00 - [11]
 

I use EveMon too constantly and haven't gotten the same error as you guys. I can log in and use the software no problem. As per the FAQ did you install that Framework stuff?

Cabernetter
Bene Gesserit ChapterHouse
The ENTITY.
Posted - 2007.11.29 14:06:00 - [12]
 

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

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

Shuan Jedai
The Graduates
Brutally Clever Empire
Posted - 2007.11.29 14:10:00 - [13]
 

Originally by: Ricdic's Hoe
I use EveMon too constantly and haven't gotten the same error as you guys. I can log in and use the software no problem. As per the FAQ did you install that Framework stuff?



I already wondered why he was suggesting to read the manual as it was just 2 pages long and seemed to hold just short overview of the features.

Except it wasn't and actually continues. Ooopps. Embarassed.

Maybe I'll have better luck after actually downloading the requirements..

Astorothe
Aperture Science Industries
Posted - 2007.11.29 14:19:00 - [14]
 

Ah yes the manual. I really must start reading those things. Embarassed

Ambo
I've Got Nothing
Posted - 2007.11.29 14:44:00 - [15]
 

Rofl, good to be able to do the classic: RTFM! Very Happy

Hopfully, that should sort everything but if you still have problems after that just let me know. Smile


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

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


Not currently, it's a nice idea though. I'll have a look at how easy it would be to do.

Hexxx
Minmatar
Posted - 2007.11.29 20:49:00 - [16]
 

*snip* - Please do not give out personal information on the forums

Ambo
I've Got Nothing
Posted - 2007.11.29 22:08:00 - [17]
 

*snip* - Please do not give out personal information on the forums

Motivated Prophet
Zerodot Schools
Posted - 2007.11.30 05:55:00 - [18]
 

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

Quote:
************** Exception Text **************
System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
...
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.EMMADataSetTableAdapters.TransactionsTableAdapter.ClearTransactions()
at EveMarketMonitorApp.GUIElements.Main.ClearAllData(Boolean keepAccountSettings, Boolean keepCharSettings)
at EveMarketMonitorApp.GUIElements.Main.ToggleCorpMode()
at EveMarketMonitorApp.GUIElements.Main.toggleCorpModeToolStripMenuItem_Click(Object sender, EventArgs e)
...
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

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

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

MP

Mr Horizontal
Gallente
Posted - 2007.11.30 06:22:00 - [19]
 

The database he's using is SQL Server Express, which you can download herefor free.

Astorothe
Aperture Science Industries
Posted - 2007.11.30 06:30:00 - [20]
 

Edited by: Astorothe on 30/11/2007 06:45:22
I really wish downloading MS SQL Express wasn't a requirment to try out this program. I'm going to give it a miss.

Thanks.

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

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

Shuan Jedai
The Graduates
Brutally Clever Empire
Posted - 2007.11.30 06:46:00 - [21]
 

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

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


Ambo
I've Got Nothing
Posted - 2007.11.30 08:53:00 - [22]
 

Edited by: Ambo on 30/11/2007 08:53:36
Originally by: Shuan Jedai
You said in the manual you haven't tested it in Vista.

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




That's a shame, sadly I have no access to a vista environment for either developing or testing so unless someone else wants to work out the compatibility issues, there will not be a fix any time soon. Sad

Quote:

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

Thanks.

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

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



I thought some people may feel this way, I choose MS express just because it was easy to use and could do everything I wanted.

It should not be too much of a big task to re-write the back end to plug into another database system, that could be somthing to think about in the future.

Quote:

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


Quote:

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




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

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

MP



Tbh I'm no expert on this stuff, in fact, this is the first time I've really used SQL outside of a uni course 5 or 6 years ago.

Do you have SQL express installed or just standard SQL server?

It sounds like this is the most likely cause of the problem.

Ambo
I've Got Nothing
Posted - 2007.11.30 12:29:00 - [23]
 

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

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

Daerkannon Shimmerscale
Paxton Industries
Paxton Federation
Posted - 2007.11.30 15:34:00 - [24]
 

Just a suggestion from someone that's been doing database development lately... try Firebird. There's a DLL you can use to embed it right into your client, thus no need to install a separate database server. The performance suffers when doing large batches (10000+), but it gets the job done without a need to install anything.

Ambo
I've Got Nothing
Posted - 2007.11.30 17:49:00 - [25]
 

Thanks, I'll take a look if I ever get round to it! Smile

Mr Horizontal
Gallente
Posted - 2007.11.30 18:51:00 - [26]
 

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

Ambo
I've Got Nothing
Posted - 2007.11.30 18:53:00 - [27]
 

Originally by: Mr Horizontal
For the record, Emma and Vista (32bit) works fine.


Awesome, glad to hear it :)

Shakuul
Caldari
RuffRyders
Axiom Empire
Posted - 2007.11.30 19:39:00 - [28]
 

this looks amazing i hope everything works out with this!

Motivated Prophet
Zerodot Schools
Posted - 2007.11.30 21:42:00 - [29]
 

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

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

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

MP

Ambo
I've Got Nothing
Posted - 2007.11.30 22:22:00 - [30]
 

Edited by: Ambo on 30/11/2007 22:31:33
Edited by: Ambo on 30/11/2007 22:22:29
Originally by: Motivated Prophet
Originally by: Ambo
I have uploaded a new zip containing a fix for an issue when adding transactions involving 0.0 player outposts.

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

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

MP



Just confirmed this, it seems to be intermittent though. Went wrong the first time but then works fine every time I try to debug it. Rolling Eyes

Will keep looking for a solution and post when I have a fix.


Pages: [1] 2 3 4 5 6 7 8 9 ... : last (19)

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


 


The new forums are live

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

These forums are archived and read-only