These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

EVE Mentat 1.2.15 - true trade tool
Author
Previous Topic Next Topic
Wafou Ka'Djo
Yellow Box Ltd.
#161 - 2013-02-25 10:31:31 UTC
Thart wrote:
Does anybody know how to receive e-mail notification when there are new posts in this thread for instance?


I think it's not possible. The "Receive notifications for this topic" gives you useless notifications within EveGate/Forum.
Tobilth Kring
Graviton Technologies
#162 - 2013-03-03 13:11:04 UTC
Just wondering I use an alt to buy stuff ship it to a region then sell it there on another toon, Is there a way to have the price of items set to the cost from my alt instead of having to set it manually
Reah Loth
Deep Core Mining Inc.
Caldari State
#163 - 2013-03-04 00:35:47 UTC
Tobilth Kring wrote:
Just wondering I use an alt to buy stuff ship it to a region then sell it there on another toon, Is there a way to have the price of items set to the cost from my alt instead of having to set it manually


On your alt, go to transactions. Select "buy orders". Press CTRL-A to select everything, right click and select "set multiple cost".
Tobilth Kring
Graviton Technologies
#164 - 2013-03-04 07:14:59 UTC
Reah Loth wrote:
Tobilth Kring wrote:
Just wondering I use an alt to buy stuff ship it to a region then sell it there on another toon, Is there a way to have the price of items set to the cost from my alt instead of having to set it manually


On your alt, go to transactions. Select "buy orders". Press CTRL-A to select everything, right click and select "set multiple cost".



thanks for that actually worked perfectly
Duchy Duke
Fresh Provisions
#165 - 2013-03-28 13:59:24 UTC
Thart wrote:
Does anybody know how to receive e-mail notification when there are new posts in this thread for instance?


You can form the thread into an RSS feed with the RSS button at the top of the thread. It's not email, but it's push (like email) vrs pull (like these forums).

I have an unrelated question also. There are certain orders that Mentat sees as being (in-range) competitors to my buy orders, but as far as I can tell they are not (example: Region Khanid, Neyi 10 Jumps vrs. Palas 5 Jumps) I've looked at some 2D maps to try and see where they overlap and they don't seem to. This leads me to my main question; is there a way to disregard a competitors order ID relative to one of my buy orders for the purposes of Mentat deciding if the order is "overridden"? (hope that makes sense)
Stacy Blackoak
Der Tobende Mob
#166 - 2013-04-03 21:20:30 UTC
Nice tool, thanks Big smile
Jaq Royale
Royale Strategic Imperative
#167 - 2013-04-08 18:53:31 UTC
I can't tell you how much I enjoy using this tool.
Thank you kindly.
Gheyna
Hoover Inc.
#168 - 2013-05-08 10:15:54 UTC
I love this tool :D

is there any plan to add profit from contracts?
Sharpstock
Deep Core Mining Inc.
Caldari State
#169 - 2013-05-14 18:08:21 UTC  |  Edited by: Sharpstock
Quote:
I'd like to give this program a try but every time I go to add a character I get:

Error 203: Authentication Error

All the API information is correct. I've checked the website for any possible solutions, besides make a new one. I've done that one already.

Any help would be greatly appreciated.




Annnnnnddd never mind, I'm going to back to licking windows.
Kira Everm4x
R E B E L L I O N
The Skeleton Crew
#170 - 2013-05-19 04:37:00 UTC
Seems that this tool can be illegal now ... is this true?
Florian Bao
Black Box Technologies
#171 - 2013-05-20 13:00:48 UTC  |  Edited by: Florian Bao
hey guys, quick question:

assuming i have a corp key, but not the character key associated with this corpkeys owner.

can I use the tool properly, since I get some importing errors all the time.


one more question:

can i check for beein outbid purely on a regionwide order? (say i have a order that is region wide, and i only want to compare it with other regional orders and see if i am outbid)
Kethas Protagonist
Protagonist Ventures
#172 - 2013-06-29 00:29:35 UTC
1) Is there a way to force EVE Mentat to update its entire market journal/transaction history, as far back as (multiple calls, using multiple fromID values, to) EVE's WalletJournal/WalletTransactions APIs go?

2) If not, I'd like to update Mentat's local database manually. What format is EVE Mentat's dynamic database .database file in, and is there a way to interconvert between that and MySQL?

I can see that Mentat makes multiple API queries when requesting journal/transaction data, I assume because there's more new data than a single call can return. However, in my case it seems to miss big swathes of history. There's a two-day period where I don't have any journal/transaction data, for example. I know that any particular API call has a maximum number of entries (1000 by default, 2560 if you send it a rowCount parameter), but that doesn't seem to explain the problem; if I move the local database and make Mentat start a new one, it only queries back about a week before giving up, and I know there's more data available farther back in time from the API by looking at manual calls.

Thanks. EVE Mentat seems like it'll be very useful, but at the moment this partial data coverage problem is driving me nuts, and I may be forced to write a manual solution anyway.
Kethas Protagonist
Protagonist Ventures
#173 - 2013-06-29 09:01:02 UTC  |  Edited by: Kethas Protagonist
Okay. So.

TL:DR I have my wallet transaction data but I cannot update Eve Mentat's database file, how do I do so manually.

After many, many ImportXML calls in Google Docs and a lot of reading, I now have my entire month's wallet transaction history sitting safe and sound in an Excel spreadsheet. There are, indeed, plenty of transactions that EVE Mentat misses, even when I delete its old database file and make it construct a new one.

I can't figure out how to update the database file though. I figured out it was SQLite, downloaded the SQLite Browser, and attempted to update manually, but the application won't let me mass-INSERT into an existing database from a CSV file, and if I drop the existing mentatTransactions table and import a new one from a CSV file, EVE Mentat fails to recognize it (I assume from some kind of index-breaking problem from the new table? I'm no SQL expert) and downloads a new transaction history (placing it into MY new mentatTransactions table, interestingly).

I would be very, very appreciative for any help on how to get the transaction data - that I have! It's sitting right there on my screen! - into Eve Mentat. I love the app but hate spending nine hours data wrangling.

Edit: you KNOW I'm exhausted when I start making typos.

Edit edit: I really think the simplest solution would be a "Force Eve Mentat to download your entire wallet transaction/journal history, not just until it starts finding duplicate entries" toggle.
Kethas Protagonist
Protagonist Ventures
#174 - 2013-06-29 20:59:43 UTC
To anyone FROM THE FUTURE that had the same problem and is reading this, I seem to have made progress deleting all records from the mentatTransactions table from a clean (i.e. Eve Mentat-generated) database, but not the table itself, i.e.

*save CSV file with your transaction history, collated elsewhere and sitting in e.g. an excel file*

*use SQLite Browser to import that CSV as a new table with a placeholder name, e.g. bob*

DELETE FROM mentatTransactions
INSERT INTO mentatTransactions SELECT * FROM bob

I'll post again if I get everything working.
Kethas Protagonist
Protagonist Ventures
#175 - 2013-06-30 06:59:27 UTC  |  Edited by: Kethas Protagonist
Yup, got it working. I can now reliably recover an entire month's worth of transaction and journal history (as much as CCP makes available through the API) into my Eve Mentat local database, which is comforting.

Potential pitfalls:

1) Eve Mentat's picky about the date/time formatting. It's YYYY-MM-DD HH:MM:SS (note the hyphens and the leading zeros), even though it isn't displayed as such within Eve Mentat.

2) Another formatting thing: Eve Mentat doesn't store "price" (in transactions) or "amount" or "balance" (in journal) as decimals; it stores them as ints, equal to price * 100, so the 1s place equals the hundreths place in the actual price. You'll need to convert.

3) SQLite Browser takes FOREVER to import CSV tables because it creates and closes a connection to the SQL database for EACH RECORD. This StackOverflow discussion was very helpful in providing a script + command line instruction to use to import directly using SQLite3, which is far, far faster (I'm talking 1-2 seconds versus 1-2 hours; wish I'd learned that earlier).

Good luck to anyone that ends up having to do this.

And, again, I humbly suggest that adding a way to force Eve Mentat to download an entire month's journal + transaction history, so it can do all this heavy lifting instead of a user, would be a nice feature.
Blademaster Hattori
Ruby Code
#176 - 2013-08-29 19:23:46 UTC
This is great tool is only the import was working all i get is stale messages when its clearly not

PI_Trader - Creating, designing and managing your PI sales market tool
Yabba Addict
Perkone
Caldari State
#177 - 2013-09-03 17:10:55 UTC  |  Edited by: Yabba Addict
Can't seem to get the cache scrape to work since the patch, deleting the cache doesn't work
Caerfinon
Caldari Provisions
Caldari State
#178 - 2013-09-03 17:18:59 UTC
Yabba Addict wrote:
Can't seem to get the cache scrape to work since the update, deleting the cache doesn't work


Seems all cache scaping apps got hit.

Ftrom Twitter;

Quote:
Fuzzysteve ‏@Fuzzysteve 2h
hmm. @erlendur? has someone changed the caching for market data without telling us? #devfleet

Erlendur ‏@erlendur 2h
@Fuzzysteve Very possibly, we made a number of low-level changes in this release. Do you have a forum thread?

Cheers C.

@Caerfinon - Twitter
Blademaster Hattori
Ruby Code
#179 - 2013-09-04 15:59:50 UTC
Anyone still getting stale data?

PI_Trader - Creating, designing and managing your PI sales market tool
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#180 - 2013-09-04 16:39:25 UTC
Blademaster Hattori wrote:
Anyone still getting stale data?



Yes. Everyone.

The cache has changed format, and until there's an updated release, you won't get updated data.

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter