open All Channels
seplocked Market Discussions
blankseplocked The Next EMMA thread. - 1.5.1.0 now available. Massive update.
 
This thread is older than 90 days and has been locked due to inactivity.


 
Pages: first : previous : ... 5 6 7 8 [9] 10 11 12 13 ... : last (30)

Author Topic

Vaerah Vahrokha
Minmatar
Vahrokh Consulting
Posted - 2010.01.27 18:23:00 - [241]
 

In case of communication failure at startup (ie eve-metrics unreachable / down), a popup appears... behind the splash screen. Of course this also prevents the splash screen from going away and so the program seems halted.

Ainnir Domhnal
Posted - 2010.01.28 20:24:00 - [242]
 

Originally by: Lost Hamster
Originally by: Ainnir Domhnal
I'm also having EMMA ask me to update on every start-up. Here are some details:



Originally by: Spyder John
Mine also keeps updating without success its the EveData.mdf that installs unsuccessfully.


I have no info why the auto update does not work, but I can give you an info, how to do a manual update. This is only a workaround and not the official way to apply an update!

The best way to do it is after a machine reboot, so it's sure, that the SQL server is not locking the files.
You need to download this 3 file:
http://dl.eve-files.com/media/corp/Ambo/EveData_log.zip
http://dl.eve-files.com/media/corp/Ambo/EveData.zip
http://dl.eve-files.com/media/corp/Ambo/EveMarketMonitorApp.zip

When downloaded, then unzip the 3 file.
And then you need to rename them.
original file name ---> new file name

EveData_log ---> EveData_log.ldf
EveData ---> EveData.mdf
EveMarketMonitorApp ---> EveMarketMonitorApp.exe

Make a copy of the c:\Program Files\EMMA\ directory to have a valid backup.

Then you need to replace the EveMarketMonitorApp.exe in the
c:\Program Files\EMMA\ directory
And the EveData.mdf , EveData_log.ldf in the
c:\Program Files\EMMA\data directory.

When the replacement is done, you can start-up the application.

Side note:
on a x64 system the directory would be:
c:\Program Files (x86)\EMMA\



OK, first I re-installed EMMA, but this time I installed it into my user file space, and I chose the option to install it only for me. This seems to have stopped other problems I was having with permissions, and having to run as administrator.

The updater is still trying to update EveData.mdf amd the log file each time. The EXE is updated fine the first time from 1.3.1.0 to 1.3.2.2.

I took some md5sums of the files as follows:
- after first install:
7b1a312123b44c3f5de0a69e1c22a254 *EveData.mdf
469f3ace86ff9f32d73645fb5d65f370 *EveData_log.ldf

- after first update, but before EMMA restarts:
8d97b84f46e9688c8825710376f78ac4 *EveData.mdf
67a5ff5737aceab395be6484d6ce5f0b *EveData_log.ldf
So we got new files installed. Question is were they the right ones?

- after closing EMMA after creating a login and an initial group and installing API keys:
0fe5cc71fb02e4145b87ac5ba51e85a1 *EveData.mdf
b91527e997087da25cf31d83546ad934 *EveData_log.ldf
So the files were updated after running EMMA. Makes sense for the log files, but should the EveData.mdf file be changed? Not sure.

- after restarting EMMA and letting in update the files again:
8d97b84f46e9688c8825710376f78ac4 *EveData.mdf
67a5ff5737aceab395be6484d6ce5f0b *EveData_log.ldf
So the updater put back the 2 files it downloaded last time.

So it looks like the update works, and new MDF and LDF files are installed, but either the updater doesn't recognize the new files, or the EveData.mdf file doesn't have the correct version number in it. Or it could be that the EveData.mdf file is getting changed when I run EMMA, which confuses the updater.

I downloaded the 3 files from eve-files, and renamed them, and took md5sums:
c0917e73c0c03528ab22f6713522e724 *EveData.mdf
eaa2311ff3e5a8a6780ec0e64d70431a *EveData_log.ldf
4a84058df992568923d0c5b92506b45e *EveMarketMonitorApp.exe

These sums match what eve-files says they should be, but do not match the files downloaded by the updater. So I could just keep running iwht EMMA and ignore the request to update each time, or I could install the files from eve-files and see. Feeling adventurous so ....

I copied the mdf. ldf, and exe files and replaced the ones in my current program folder for EMMA. And ... EMMA updater wants to update all 3 now - it thinks both the exe and mdf are version 1.3.1.0.

So I'll restore the backup and try running EMMA and just ignore the prompt to update each time.

It looks like the files on eve-files are not the 1.3.2.2 version.

Cheers.

Bangbroo
Posted - 2010.01.28 22:30:00 - [243]
 

Edited by: Bangbroo on 28/01/2010 22:30:42
edit. sorry question already answered above =)

Lost Hamster
Hamster Holding Corp
Posted - 2010.01.28 23:41:00 - [244]
 

Originally by: Ainnir Domhnal

....


When the SQL server just opens the file, then it writes to it, so the checksums will change. It does not necessary mean that EMMA have written anything to it.

The files what I linked are the latest files for sure.

What I can think of is, that the program does not recognise the correct versions.
I have an idea what can it be, THIS but to be sure, I will try to do a clean install on a VM tomorow night, to see if I can reproduce the problem.

Ainnir Domhnal
Posted - 2010.01.29 06:12:00 - [245]
 

Edited by: Ainnir Domhnal on 29/01/2010 06:14:59
Originally by: Lost Hamster

...

The files what I linked are the latest files for sure.

...



Are you really sure? EMMA thought they were older and listed older version numbers on the update details window. And I tried to run the exe you linked and skip the update, but it complained loudly that it didn't have the proper license key, and then exited. So it looks like a version of the exe that still expects a paid license key to be provided, which is an older version, isn't it? This all suggests that the files downloaded from eve-files were 1.3.1.0.

And yes I see your point about SQL server and the check sums. I'd not considered that SQL Server might twiddle the db file when it opens it, but I guess it might keep some housekeeping data there which changes while the CCP data doesn't.

Bangbroo
Posted - 2010.01.30 10:30:00 - [246]
 

For some odd reason my Journal tends to go into error mode sometimes not update the journal why's that?

Capitalist Swineherder
Posted - 2010.01.30 17:20:00 - [247]
 

Hmmm just did yet another clean install of EMMA from the google code page. This is getting to be a bi-weekly ritual. Once I fire it up it asks to update. If I allow it to update it tanks starting up after the update.


1/30/2010 10:10:50 AM Critical - EveMarketMonitorApp.Common.EMMAException - Error during startup
Inner Exception: The database 'C:\GAMES\UTIL\EMMA\DATA\EVEDATA.MDF' cannot be opened because it is version 655.
This server supports version 612 and earlier. A downgrade path is not supported.
Cannot open user default database. Login failed.


I thought the latest update fixed that problem?

Lost Hamster
Hamster Holding Corp
Posted - 2010.01.31 08:56:00 - [248]
 

Originally by: Ainnir Domhnal
...


The license issue: Can you give me the version of the Enforcer.dll ? It should be 1.3.0.5
If you have SQL management console than can you go to:
evedata \ Programmability \ stored procedure \ dbo._getversion there right click modify, and give me what is in the filed: SET @version = ?


Originally by: Bangbroo
For some odd reason my Journal tends to go into error mode sometimes not update the journal why's that?

Try to run only one journal update query at the time.

Originally by: Capitalist Swineherder

...


That error is when you try to update to a beta version, which was out for SQL 2008.
You need the regular update which is for SQL2005, here I described how to do a manual update, maybe try that one.

Ainnir Domhnal
Posted - 2010.01.31 21:06:00 - [249]
 

Edited by: Ainnir Domhnal on 31/01/2010 21:06:03
Re license issue: Enforcer.dll is 1.3.0.5. The license issue only appeared with the exe I got off the eve-files site. I didn't see it with the current installer version, either before or after the upgrade attempt. The attempt to use the exe from eve-files was after running the upgrade which installed enforcer.dll 1.3.0.5 iirc, so maybe there's a disconnect there?

I don't have the management console installed, but I'll see if I can get it. The SQL I have was installed by the EMMA installer - can I add the management console to that (vista 32 bit)?

Ainnir Domhnal
Posted - 2010.01.31 21:44:00 - [250]
 


Question about Item Details. This window has a filter box for items. The box has a number of items that I have bought/sold recently (but are not on the market now), except Torrent Missiles, which I have bought/sold recently and still have some on the market. Why would the missiles not appear in the item filter list?

The order tab shows my current sell orders for the missiles - some are colored yellow, and some red (or perhaps it's dark orange). What do these colors mean?

Lost Hamster
Hamster Holding Corp
Posted - 2010.01.31 22:27:00 - [251]
 

Edited by: Lost Hamster on 31/01/2010 22:28:11
Originally by: Ainnir Domhnal

I don't have the management console installed, but I'll see if I can get it. The SQL I have was installed by the EMMA installer - can I add the management console to that (vista 32 bit)?

If you have sql 2005, then:
this
Or if you have sql 2008 then:
this

Just choose the correct 32 bit download.

Dethmourne Silvermane
Gallente
Origin.
Black Legion.
Posted - 2010.02.01 05:13:00 - [252]
 

Maybe I'm dumb, but the reprocessor doesn't appear to be working..

Ainnir Domhnal
Posted - 2010.02.01 06:04:00 - [253]
 

Edited by: Ainnir Domhnal on 01/02/2010 06:44:08
Originally by: Lost Hamster
Edited by: Lost Hamster on 31/01/2010 22:28:11
...
If you have sql 2005, then:
this
Or if you have sql 2008 then:
this

Just choose the correct 32 bit download.


Thanks for that. OK, I have SQL Express 2005, and I installed the SQLServer2005_SSMSEE.msi without problem. It's gives me some errors on start up but seems to run anyway.

I attached my database (for anyone else following this, you may have to change your SQL to run as Local System to find your data base file - see this post [#94] - the attach db function couldn't browse my user file space until I did this). The contents of dbo._GetVersion are:
Quote:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_GetVersion]
@version varchar(50) OUTPUT
AS
SET @version = '1.3.0.0'
RETURN



Ta daaa Very Happy

Ainnir Domhnal
Posted - 2010.02.01 07:44:00 - [254]
 

Ooops, I broke something. Now EMMA can't login. I got:

Quote:
01/02/2010 1:49:09 AM Critical - EveMarketMonitorApp.Common.EMMAException - Error during startup
Inner Exception: Cannot open user default database. Login failed.
Login failed for user 'LUCKY\<myuserid>'.
Stack Trace: 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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.Updater.Update()
at EveMarketMonitorApp.GUIElements.Main..ctor(Boolean checkForUpdates)


So I change SQL Express back to run as Network Service. EMMA the complained:

Quote:
01/02/2010 1:53:34 AM Critical - EveMarketMonitorApp.Common.EMMAException - 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.
Stack Trace: at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) ...


and the on-screen pop-up suggested a restart. I tried restarting the SQL Express service, but no good, so I restarted Vista, and got back to the login exception.

What did I do with the console program to change the DB login?



Lost Hamster
Hamster Holding Corp
Posted - 2010.02.01 14:59:00 - [255]
 

Originally by: Ainnir Domhnal
Ooops, I broke something. Now EMMA can't login. I got:



What I can think of is if your db is still attached to the SQL then you can get this error. As it can not attach it again.

Alternatively if your db is attached to the SQL server as EMMAdatabse and EVEdata then you can change the EMMA config (EveMarketMonitorApp.exe.config) to:

<add name="EveMarketMonitorApp.Properties.Settings.EMMA_DatabaseConnectionString"
connectionString="Data Source=localhost\sqlexpress;database=EMMADatabase;Trusted_Connection=yes"
providerName="System.Data.SqlClient"
/>
<add name="EveMarketMonitorApp.Properties.Settings.ebs_DATADUMPConnectionString"
connectionString="Data Source=localhost\sqlexpress;database=EveData;;Integrated Security=True"
providerName="System.Data.SqlClient"
/>
</connectionStrings>

Then it will not try to create an instance for the connection. Personally I like this system better. However the db upgrade I can only do manually. :)

Ainnir Domhnal
Posted - 2010.02.01 16:58:00 - [256]
 

Originally by: Lost Hamster
Originally by: Ainnir Domhnal
Ooops, I broke something. Now EMMA can't login. I got:



What I can think of is if your db is still attached to the SQL then you can get this error. As it can not attach it again.

...



Yes, I think that was it. I had already detached the EveData db from the management console, but I think I did it wrong, and EveData.mdf or its ldf got corrupted. EMMA wouldn't load, and the management console couldn't reattach it. I couldn't even move the files elsewhere because some other program had them open. I shut down SQL Express and EMMA and anything else I could think of that might keep those files open, but they were still locked. So I rebooted Vista and then moved the EveData mdf anf ldf away, and started EMMA. EMMA was real smooth - it re-installed them! And then started. And then updated the EveData again. So I'm back to a working EMMA.

I tried attaching EveData.mdf to the management console again, and detaching it. EMMA won't run with it attached, but will when I detach it properly. I didn't try the edits to the config file - not feeling adventurous today.

BTW (back to the earlier question), was the info from dbo._getVersion useful? Looks like the updated EveData.mdf has the older version number in it.

Pel GarThur
Posted - 2010.02.03 19:13:00 - [257]
 

I recently sent the 100M isk for EMMA to Ambo. Was this correct?

Ambo
I've Got Nothing
Posted - 2010.02.03 20:18:00 - [258]
 

Originally by: Ainnir Domhnal
<lots of bad stuff>


Soz, havn't read this thread for ages...
I recommend trying the beta version if you have not already done so. Settings -> other settings. Check the 'look for beta updates' flag and then try updating again.

Software is the same at the moment for both versions and you can always turn it off if you don't want betas in future.

Originally by: Pel GarThur
I recently sent the 100M isk for EMMA to Ambo. Was this correct?


EMMA is free and has been for over 6 months, jsut update to the latest version. I'll send the isk back asap.

Sir Ibex
Posted - 2010.02.06 18:26:00 - [259]
 


Posted - 2010.02.06 17:44:00 - [349] - Edit - Quote
Report
I posted 3 times already in these EMMA threads, but for some reason I'm always being ignored. I tried reading the faq on sourseforge forums, but the forum does not work. someone please help me.

ERROR!!! EMMA IS UNABLE TO CONNECT TO DATABASE !!!

=====================================================================================
EXCEPTION REPORT
=====================================================================================
2/6/2010 12:29:36 PM Critical - EveMarketMonitorApp.Common.EMMAException - 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.
Stack Trace: 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.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at EveMarketMonitorApp.DatabaseClasses.Updater.WaitForAcknowledge()
at EveMarketMonitorApp.GUIElements.Main.waitForSQLAcknowledge()
=====================================================================================
EXCEPTION REPORT
=====================================================================================
2/6/2010 12:34:36 PM Critical - EveMarketMonitorApp.Common.EMMAException - 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.
Stack Trace: 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.S



Vista 32, SQL 2005

Lost Hamster
Hamster Holding Corp
Posted - 2010.02.06 19:08:00 - [260]
 

Originally by: Sir Ibex

Posted - 2010.02.06 17:44:00 - [349] - Edit - Quote
Report
I posted 3 times already in these EMMA threads, but for some reason I'm always being ignored. I tried reading the faq on sourseforge forums, but the forum does not work. someone please help me.


Are you running EMMA as an administrator?

Ambo
I've Got Nothing
Posted - 2010.02.06 22:46:00 - [261]
 

Originally by: Sir Ibex
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.


This error is usually caused by a configuration issue with SQL server Express.

Try the following:

1. Stop the SQLEXPRESS service in control panel -> services.
2. Delete C:\Documents and Settings\<WINDOWS USERNAME>\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS
3. Restart SQLEXPRESS service.

Breaker77
Gallente
Reclamation Industries
Posted - 2010.02.07 03:41:00 - [262]
 

Edited by: Breaker77 on 07/02/2010 03:44:03
I'm having an issue when updating the orders it won't update and hovering my mouse over the checkbox shows a tooltip that says "The EVE API has reported that this data has already been retrieved, no update has occured".

New accounts that I set up for audits work properly, but for this character it has been over a month since the orders were downloaded.

Also my personal journal downloads fine, but my corp journal says "invalid beforeref ID provided" and has been ever since you fixed the datatype a few weeks ago.

Ambo
I've Got Nothing
Posted - 2010.02.07 07:52:00 - [263]
 

Originally by: Breaker77
Edited by: Breaker77 on 07/02/2010 03:44:03
I'm having an issue when updating the orders it won't update and hovering my mouse over the checkbox shows a tooltip that says "The EVE API has reported that this data has already been retrieved, no update has occured".

New accounts that I set up for audits work properly, but for this character it has been over a month since the orders were downloaded.

Also my personal journal downloads fine, but my corp journal says "invalid beforeref ID provided" and has been ever since you fixed the datatype a few weeks ago.


Well the problem with the orders sounds like it's happening because EMMA is requesting the data too soon after some other program (or possibly itself) has already done so. When it fails, try looking at the API access logging page to see when the last access to the orders API was made.
If the last access was less than an hour before EMMA failed to update then that's the problem.

As for the corp journal ID, it could be that CCP have not updated the corp journal API page to accept a 64-bit parameter instead of a 32-bit one. (They had to do this for the character journal page but corp page may have been missed) Is anyone else having similar problems or having the corp journal working fine?

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

Originally by: Ambo

As for the corp journal ID, it could be that CCP have not updated the corp journal API page to accept a 64-bit parameter instead of a 32-bit one. (They had to do this for the character journal page but corp page may have been missed) Is anyone else having similar problems or having the corp journal working fine?


I'm seeing this also for Corp Journal API in EWA.

Breaker77
Gallente
Reclamation Industries
Posted - 2010.02.07 13:06:00 - [265]
 

Originally by: Ambo
Well the problem with the orders sounds like it's happening because EMMA is requesting the data too soon after some other program (or possibly itself) has already done so. When it fails, try looking at the API access logging page to see when the last access to the orders API was made.
If the last access was less than an hour before EMMA failed to update then that's the problem.



I feel stupid now. I had set up evemon with my full key and it was pulling my orders. I have changed my key back to a limited one and I'm waiting to see if that fixes it.

Lost Hamster
Hamster Holding Corp
Posted - 2010.02.07 16:11:00 - [266]
 

Edited by: Lost Hamster on 07/02/2010 16:32:23
Originally by: Breaker77

I feel stupid now. I had set up evemon with my full key and it was pulling my orders. I have changed my key back to a limited one and I'm waiting to see if that fixes it.


I suggest you disable in EVEMON the market order updates.
You can find it under Tools\Options\ General \ Updates
And there set the Market Orders to NEVER

That is a fix as well.

---------------------------------------------------
Now about something else:

I finished dominion 1.1.1 update for EMMA.
Download link: -http://rapidshare.com/files/347261740/evedata-dom1.1-sql2005.ZIP.html
(valid for 10 download, let me now if you need it again)

Jukhta Mein
22nd Black Rise Defensive Unit
OWN Alliance
Posted - 2010.02.07 18:11:00 - [267]
 

I'm not too sure where to seek clarification on this so I thought I'd ask here.

When using 'Item Report' gross margin per item (and therefore gross profit) is calculated by subtracting average sell price with cost of unit. I'm not sure what this 'cost of unit' figure is, but it's always lower than average buy price. Is there a way to calculate using the latter figure instead of the 'cost of unit' figure? The 'cost of unit' figure tends to make things more rosy than it is.

Ambo
I've Got Nothing
Posted - 2010.02.08 08:35:00 - [268]
 

Originally by: Lost Hamster

I finished dominion 1.1.1 update for EMMA.
Download link: -http://rapidshare.com/files/347261740/evedata-dom1.1-sql2005.ZIP.html
(valid for 10 download, let me now if you need it again)


Thanks Hamster, will hopefully get that sorted sometime today. (though it's crazy at work atm so if I don't get time over lunch, it will have to wait)

Originally by: Jukhta Mein
I'm not too sure where to seek clarification on this so I thought I'd ask here.

When using 'Item Report' gross margin per item (and therefore gross profit) is calculated by subtracting average sell price with cost of unit. I'm not sure what this 'cost of unit' figure is, but it's always lower than average buy price. Is there a way to calculate using the latter figure instead of the 'cost of unit' figure? The 'cost of unit' figure tends to make things more rosy than it is.


the 'cost per unit' is the estimated unit cost of the item you are selling. It works like this:


1. Buy 10 units of x at 20 isk p/u
2. Buy 30 units of x at 40 isk p/u
3. Sell 15 units of x at 100 isk p/u

If you now run an item report then the cost per unit will be 26.67 isk p/u. Even if the actual items sold came from the stack bought at 40 isk p/u. This is because individual items cannot be tracked.

Instead, EMMA uses a Last in, Last out model to determine the buy price of items that you sell. i.e. from the example above, the 15 units are assumed to be the 10 units at 20 isk p/u and 5 units from the 40 isk p/u stack.

This can cause some slight oddities from time-to-time and can really cause a mess if you don't sell everything you buy (e.g. if you buy a load of missile launchers, fit some to a ship and sell the others).

However, assuming that you do sell everything you buy (I would think this is the case for most serious trader chars) then I believe it's the best solution.

Vaerah Vahrokha
Minmatar
Vahrokh Consulting
Posted - 2010.02.08 09:43:00 - [269]
 

Quote:

This can cause some slight oddities from time-to-time and can really cause a mess if you don't sell everything you buy (e.g. if you buy a load of missile launchers, fit some to a ship and sell the others).



You should see how fun the NAV becomes for those who blew lots of battleships for the insurance. They get like (-70,000,000,000) NAV and similar.

Ambo
I've Got Nothing
Posted - 2010.02.08 11:03:00 - [270]
 

Version 1.4.0.0 BETA is now available

This has the updated Dominion 1.1.1 data.

Assuming no problems are reported, I'll put it on general release later in the week.


Originally by: Vaerah Vahrokha
Quote:

This can cause some slight oddities from time-to-time and can really cause a mess if you don't sell everything you buy (e.g. if you buy a load of missile launchers, fit some to a ship and sell the others).



You should see how fun the NAV becomes for those who blew lots of battleships for the insurance. They get like (-70,000,000,000) NAV and similar.



haha! I suppose they would. I didn't really have insurance fraud in mind when designing it. Smile


Pages: first : previous : ... 5 6 7 8 [9] 10 11 12 13 ... : last (30)

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