Pages: 1 2 3 4 [5] 6 7 8 9 10 11 12 13 14 15 16 17 18 19 .. 19 :: one page |
|
Author |
Thread Statistics | Show CCP posts - 0 post(s) |
gicaduru
Black Omega Security Pandemic Legion
|
Posted - 2007.12.21 14:38:00 -
[121]
Hope the SQLite work is going well. I, and I'm sure others, are holding off waiting for this as I don't want to run a full SQL server for this. :)
|
Ambo
2nd Outcasters
|
Posted - 2007.12.21 22:17:00 -
[122]
Edited by: Ambo on 21/12/2007 22:20:10
I'm afraid it's not going as well as I hoped...
SQLite as turned out to be too much of a PITA to get everything working. I'm now looking at firebird again. Unfortunatley, I don't think it's going to be much better...
I could use basic XML files to store the data but I'd have to sacrifice functionality and it would be much slower for large amounts of data so it's not a good option.
I'm pressing ahead with it anyway but the difficulties are more substantial than I thought so it's going to take some time.
SQL express is really nothing like running a full SQL server, it's far more lightwieght. tbh, I think if it was called somthing different (like Firebird) and not made by MS, people would not be so unhappy using it as it really is a great system.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
gicaduru
Black Omega Security Pandemic Legion
|
Posted - 2007.12.22 00:57:00 -
[123]
This is a crazy long shot but could you not abstract a little more and let it connect to remote SQL servers. I know in some projects they use like, a library that lets it talk to mysql, postgresql, ms sql, stuff like that. I can't think of the name of the thing now, typically, but I already run a remote mysql server. It would give users more options and I figure the stuff you're using is fairly generic SQL?
|
Ambo
2nd Outcasters
|
Posted - 2007.12.22 10:30:00 -
[124]
Sounds good but I have no idea how I'd go about it or how much work it would be.
I'll look into it if Firebird does not meet epectations.
At the moment, everything is already very abstracted. I wouldn't have to change any of the functional parts of the program. It's just the database communication layer.
In my current program, this is built automatically by visual studio because of it's great integration with MS SQL. Having to actually code it myself for another database is easy but takes a lot of time and is more error prone than the automatic approach.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Ambo
2nd Outcasters
|
Posted - 2007.12.22 11:45:00 -
[125]
A new patch is available to version 0.9.0.23.
This adds the ability to import data from eve-MEEP files and some minor interface tweaks.
To import eve-MEEP data, use the tools->import data from...->Eve-MEEP Journal/Transactions. You will find the data in your Eve-MEEP folder under \Resources\Profiles\my profile\my char. Where my profile and my char are your Eve-MEEP profile and character names respectively.
That's probably going to be it until after New year. Have a good one all!
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Pinpisa Jormao
|
Posted - 2007.12.24 18:10:00 -
[126]
Personally I'd just use LINQ to objects with binary serialization if you don't require any features that LINQ can't already do.
If you do require SQL specific things then you could look at VistaDB. It's "world's first fully managed and typesafe embedded SQL database engine built for Microsoft .NET, Compact Framework and Mono" with "Royalty-free distribution". So only the developer pays ($170). They promise LINQ bindings in future so upgrading from LINQ to object or LINQ to XML shouldn't be an issue.
|
Hagen Stein
Biotronics Inc. Alternative Realities
|
Posted - 2007.12.27 13:08:00 -
[127]
Here's the promised feedback. I installed v0.9.0.23 yesterday, but the error (showing incorrect amounts in both Wallet and Journal view) have become worser. Now it's not only off by a factor of 10, but a factor of 1000.
I'll download and install SQL Server Management Suite this evening and see if this is just a display issue or if the values stored in the DB are really that high.
In the meanwhile, let me know what I can/should do to help you track down this issue.
|
Hagen Stein
Biotronics Inc. Alternative Realities
|
Posted - 2007.12.28 00:02:00 -
[128]
Uuh...disregard, please.
I was looking at old data. New imported data now looks like it should.
I'm sorry for the confusion.
|
Brother Mainard
Chocolate Reign Free Trade Zone.
|
Posted - 2007.12.29 11:22:00 -
[129]
Bumping a great tool!
|
Frenzei
Gallente Brotherhood of Wolves
|
Posted - 2008.01.03 05:21:00 -
[130]
Bump for an awesome tool.
Newbie, not n00b. Mining, Reprossecing and Producing. |
|
Ambo
2nd Outcasters
|
Posted - 2008.01.03 07:05:00 -
[131]
Thanks for the bumps, I've not had a chance to do anything since the last update and am currently absorbed in a few games I got the christamas (Guitar hero 3 on xbox 360, COD4 and Bioshock on PC if you're interested).
In other words, there probably won't be any updates for at least a few weeks. This project is not dead, just on a bit of a holiday.
As ever, if you know some C# and want to add a feature or just look at the code yourself, check out the project page at sourceforge.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Taraw
Amarr Dark Rising Shadow
|
Posted - 2008.01.05 16:48:00 -
[132]
I try to update corp transactions but there's an error: Screenshot The english translation would be something like "An entry with the same key is already there" No transactions are being stored. There's no problem with the journal.
|
Ambo
2nd Outcasters
|
Posted - 2008.01.05 17:43:00 -
[133]
Originally by: Taraw I try to update corp transactions but there's an error: Screenshot The english translation would be something like "An entry with the same key is already there" No transactions are being stored. There's no problem with the journal.
I'll take a look at this asap. Will hopefully get a chance tomorrow and let you know when I've sorted it.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Imuran
|
Posted - 2008.01.06 14:52:00 -
[134]
Looks excellent - I have no problems using the SQL Express as I can link into the data with other tools to manipulate outside of EMMA. If you move to an integrated database there should be an option to export so can get to it with the likes of Excell/Access etc
|
Frenzei
Gallente Brotherhood of Wolves
|
Posted - 2008.01.09 11:24:00 -
[135]
Bump for a great tool.
Newbie, not n00b. Mining, Reprossecing and Producing. |
Ambo
2nd Outcasters
|
Posted - 2008.01.17 08:36:00 -
[136]
Edited by: Ambo on 17/01/2008 08:37:48 Quick update on this since it's been in the wilderness for some time now:
Most of the time I spent on EMMA was free time at work, i.e. periods when I had nothing better to do, some lunch breaks, etc. For the first week and a half after new year I was very ill and the last 4-5 working weeks I've been very busy on several projects and it dosn't look like this is going to change any time soon. Consequently, the major work such as migrating to a new database is indefinatley on hold.
I had been thinking about abandoning EMMA altogether but several people contacting me about bugs and asking for changes have made me decide to carry on doing what I can.
Overall this means that I'll be working on fixing bugs and doing minor enhancements rather than any of the larger additions.
Thanks all for your support.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Deez Onit
|
Posted - 2008.01.17 09:05:00 -
[137]
Thanks Ambo, it's an amazing tool don't let it die.
|
Mtber
Caldari Mtber Corp
|
Posted - 2008.01.17 09:44:00 -
[138]
I've just installed EMMA and can see immediately how useful this can be for 3rd party verification purposes
Haven't investigated it enough yet to see how useful it will be to me in my trading activities
|
Ophia
|
Posted - 2008.01.17 10:53:00 -
[139]
Ambo,
You might just consider rewriting it to use an .mdb access database file. I skimmed 2 or 3 pages and saw the database trouble mentions. If you're using standard .NET (C# or whatever) then converting to a .mdb would be pretty easy. Off the top of my head its a matter of changing the database host strings and changing the ADO.NET options to connect to a file vs. a database.. Once everything is in place all of the SQL queries should work the same afaik.. Its been a long time since I've interfaced .NET to MSAccess but for the most part you have to change the database interfaces to OLE DB Jet...
Good luck none the less...
Oph
|
Ambo
2nd Outcasters
|
Posted - 2008.01.17 13:29:00 -
[140]
Originally by: Ophia Ambo,
You might just consider rewriting it to use an .mdb access database file. I skimmed 2 or 3 pages and saw the database trouble mentions. If you're using standard .NET (C# or whatever) then converting to a .mdb would be pretty easy. Off the top of my head its a matter of changing the database host strings and changing the ADO.NET options to connect to a file vs. a database.. Once everything is in place all of the SQL queries should work the same afaik.. Its been a long time since I've interfaced .NET to MSAccess but for the most part you have to change the database interfaces to OLE DB Jet...
Good luck none the less...
Oph
I though about this, or even using plain XML files to store the data since .NET is very flexible with data providers. Sadly, with large amounts of data, these types of systems just don't give good enough performance to be viable.
If you're racking up 1000's of transaction or journal entries per month then some of the reports would become very slow indeed.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
|
Ambo
2nd Outcasters
|
Posted - 2008.01.17 13:32:00 -
[141]
A patch to version 0.9.0.25 is now available.
This adds the ability to customise the functioning of the infamous 'auto add' button on the traded items screen. It should all be fairly self explanatory but if you have problems then just let me know.
I have had 3 or 4 people now contact me about the 'duplicate transaction key' problem. I am looking into this but right now it's proving rather elusive hopefully will have a fix in the next few days.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
shags
CyberDyne Industries
|
Posted - 2008.01.17 16:46:00 -
[142]
Edited by: shags on 17/01/2008 16:52:57 Edited by: shags on 17/01/2008 16:48:27 deleted my post. i was reading on eve-search and it hasn't updated your edits to the first post.
|
William Walker
Amarr
|
Posted - 2008.01.17 18:41:00 -
[143]
It says the security level of my API isn't high enough...?
Code: 200 Description: Current security level not high enough. ________________________________________________
|
Ambo
2nd Outcasters
|
Posted - 2008.01.17 19:20:00 -
[144]
That means you are using the limited access API key rather than the full access one.
To change this, goto File -> change account details.
Click on the link there, then click on the 'yes I need my full acceess key, blah, blah' button and enter the details into the account details screen.
Everything should then work fine.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
William Walker
Amarr
|
Posted - 2008.01.17 19:26:00 -
[145]
Originally by: Ambo That means you are using the limited access API key rather than the full access one.
To change this, goto File -> change account details.
Click on the link there, then click on the 'yes I need my full acceess key, blah, blah' button and enter the details into the account details screen.
Everything should then work fine.
Oh yeah, it works now. Thank you. :) ________________________________________________
|
Tobin Shalim
Vulcan Foundry
|
Posted - 2008.01.18 00:26:00 -
[146]
Please use Firebird, as I've done everything I can think of to get SQLite working and still cannot after 2 hours of screwing with it (to be fair, I'm not a novice at computers). Would like a solution that would work, as I can see myself using this tool extensively
If I can ever get it working |
Astorothe
Aperture Science Industries
|
Posted - 2008.01.18 02:05:00 -
[147]
This would be an awesome tool if it was a stand alone app.
Ze logs show NOTHING! ~ Eve Corp and Fansite Web design, development and hosting services
|
Ophia
|
Posted - 2008.01.18 02:42:00 -
[148]
Originally by: Tobin Shalim Please use Firebird, as I've done everything I can think of to get SQLite working and still cannot after 2 hours of screwing with it (to be fair, I'm not a novice at computers). Would like a solution that would work, as I can see myself using this tool extensively
If I can ever get it working
You're not going to get it to run under SQLite by just... messing with it... Not unless SQLite could run in an emulated MS Sql server mode. It's hard coded into the software to use MSSQL. I have an MSSQL database on my computer but I haven't installed the EMMA software because I'm a drop worried it might mess with the databases/tables I'm already using for various projects. =)
I looked at Firebird and it seems to have a decent .NET implementation. Anyone whos not Ambo reading this should know that writing a bunch of code to switch database types is generally a pain in the ass. He writes it out of his spare time and generally in MY spare time I like to write code that's... enjoyable... Writing database code, to me, is anything but enjoyable. It's a lot of queries and testing and double checking and rewriting. It's far more QA testing than coding.
Oph
|
Ambo
2nd Outcasters
|
Posted - 2008.01.18 08:47:00 -
[149]
Originally by: Ophia writing a bunch of code to switch database types is generally a pain in the ass. He writes it out of his spare time and generally in MY spare time I like to write code that's... enjoyable... Writing database code, to me, is anything but enjoyable. It's a lot of queries and testing and double checking and rewriting. It's far more QA testing than coding.
Oph
Exactly.
Writing a database communication layer is pretty much the most boring thing I can imagine coding. It's monotonus and dull but takes ages. Which is exactly why I used the automatic code generation in Visual Studio to do it for me with MSSQL.
The automatic generator does produce rather bloated code but to give you an idea, the current generated code file is around 30,000 lines. In comparison, the biggest single file I've written is around 1,000 lines. Adding together all the files I've actually written the code for comes to roughly 25,000 lines.
I would really like to move to another system so EMMA appears as a standalone app but I'm not going to spend weeks of free time doing somthing I dislike in order to achieve it, particularly when my free time is in such short supply.
Nope, I'm afraid that unless someone else wants to step in and write the code, EMMA is going to stick with SQL Express for the forseable future.
--------------------------------------
Trader? Investor? Just want to track your finances? Check out EMMA |
Slasher Arcana
|
Posted - 2008.01.18 10:42:00 -
[150]
Edited by: Slasher Arcana on 18/01/2008 10:45:06 Purely for discussion purpose and definitely should not be taken as a critique, I'm surprised this project didn't start with mysql right off.
mysql has free DBD/DBI for C++, is a scalable database engine, does not need to be installed (just run the EXE, then stop it as and when needed), and all its working files and database data files are stored as files in a single mysql (or specified) folder, eg mysql/data, mysql/config, etc.
With mysql you COULD go with the whole install-next-next-next shebang that comes with all the fancy admin GUIs, but u can also download the zip and just extract the bin/mysqld.exe for your own use. With that and mysql.ini it works just fine.
As a program that needs an integrated SQL server without actually integrating it, it would have been more seamless with mysql: include mysqld.exe in ur download, do a system call to mysqld.exe to start the database, then use named pipe calls (via .) or TCP/IP (via localhost:port) whichever way you fancy to perform ur SQL queries. With the provided mysql DBD/DBI, it'll just be a simple 1-line C++ "new" call to connect to the DB, then u run SQL queries with "mysqlquery" calls.
With ur permission I might give that a try from ur sourceforge CSV. Is it in .Net 2.0?
|
|
|
|
|
Pages: 1 2 3 4 [5] 6 7 8 9 10 11 12 13 14 15 16 17 18 19 .. 19 :: one page |
First page | Previous page | Next page | Last page |