| Pages: 1 [2] 3 :: one page |
|
|
| Author |
Topic |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.07.29 16:14:00 -
[31]
Originally by: Ambo
Originally by: Hel O'Ween
Originally by: Shar Tegral
I'm a big propronent of csv standard for exporting. XML is a big standard, yes, but csv is even simpler and much easier on the eyes if someone should choose to review the data by eye. Add in that there is less likely to be any conversion issues no matter what database the data is imported too... win win all around.
But you are aware that "CSV" doesn't work well in an international environment, are you? That's due to the fact that different countries have different regional settings. In Germany, for example "." is the thousand seperator, whereas "," is the decimal separator. That's why in Germany CSV's use ";" as a column separator. Try improting that into an english Excel or vs.
In fact, I think CSV is perhaps the worst choice for exchanging data, as it also doesn't provide any kind of data typing (force a number to be a number or a date to be a date).
XML doesn't have this limitations.
This is exactly why I won't import CSV. Sure, I'll export so you can mess around with it in Excel but importing? No way. Far too much hastle.
Good point about csv. So what do you think I should do how should I approach a change in the import of the export market log files? I understand XML is the way to go but eve doesn't export in XML format, unless I missed something someplace.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.07.29 22:49:00 -
[32]
FYI,
I forgot to mention that I did test the export from eve market for a few different languages and region settings and it always exported with the same delimiter format. data,data,data.
But yes I do agree that for data exchange XML is much better. So I have to work with what eve exports plain and simple.
|

Hel O'Ween
Gallente Biotronics Inc. Alternative Realities
 |
Posted - 2008.07.30 10:04:00 -
[33]
Originally by: Gremrod
I forgot to mention that I did test the export from eve market for a few different languages and region settings and it always exported with the same delimiter format. data,data,data.
But yes I do agree that for data exchange XML is much better. So I have to work with what eve exports plain and simple.
We have to differentiate between two situations here:
1) EVE exports. As you have found (and I second that, German user here), EVE's market exports have a fixed format, regardless of regional settings. This is good and bad. Good, because you can rely on it, regardless of where your app is used. Bad because I, for example, had to write my own CSV parser to import the market logs.
2) Imports/exports that your application does. This is the tricky part and the part I was commenting to in the first place. As long as you use standard libraries (ADO, ADO.NET), im-/exports should in theory honor regional settings. If you're going to build your own "CSV writer", that might be different.
That's why I personally would go for XML. I could use standard libraries and still have the chance to catch errors caused by wrong localization. XML (or my app) would error out on the specific value, not like an ADO CSV import that wouldn't work at all, because of the (wrong) file structure.
But my main point against CSVs is the missing capability of (strong) data typing. -- EVEWalletAware - an offline wallet manager |

Tiirae
The New Era HUZZAH FEDERATION
 |
Posted - 2008.07.30 11:19:00 -
[34]
Edited by: Tiirae on 30/07/2008 11:20:42 Hmm, I like this a lot but relying on the individual user to export data from eve means you aren't leveraging all users together. You need to add the ability to upload these imported logs to a central website and the software can also download from there. Basically like eve-central but with your app as the client instead of a web browser.
I'm sure it would become more widely used then.
(ps. not sure if it offers this already as it's DT and I can export any logs to try it out right now)
pps. I loathe XML because it's so bloated but in this situation it's really the best thing you can do. I would love to see JSON support for excel as that's much easier to code against and to read by sight, but I haven't got any hope of that happening anytime soon.
ppps. free bump cos you deserve more eyeballs.
 |

Emporia Tzard
 |
Posted - 2008.07.30 11:33:00 -
[35]
Originally by: Tiirae You need to add the ability to upload these imported logs to a central website and the software can also download from there. Basically like eve-central but with your app as the client instead of a web browser.
But what's the point when Eve Central already does this?
The point of using this app is that you can maintain your own 'trade intelligence' and keep the secrets to yourself.
|

Tiirae
The New Era HUZZAH FEDERATION
 |
Posted - 2008.07.30 11:41:00 -
[36]
Originally by: Emporia Tzard
Originally by: Tiirae You need to add the ability to upload these imported logs to a central website and the software can also download from there. Basically like eve-central but with your app as the client instead of a web browser.
But what's the point when Eve Central already does this?
The point of using this app is that you can maintain your own 'trade intelligence' and keep the secrets to yourself.
My view is that the loss of secrecy is more than made up for by the vastly increased amount of information available. I back my own ability to mine the data better than others, to spot routes and take advantage of them before others.
 |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.07.30 15:15:00 -
[37]
Edited by: Gremrod on 30/07/2008 15:18:13
Originally by: Tiirae
Originally by: Emporia Tzard
Originally by: Tiirae You need to add the ability to upload these imported logs to a central website and the software can also download from there. Basically like eve-central but with your app as the client instead of a web browser.
But what's the point when Eve Central already does this?
The point of using this app is that you can maintain your own 'trade intelligence' and keep the secrets to yourself.
My view is that the loss of secrecy is more than made up for by the vastly increased amount of information available. I back my own ability to mine the data better than others, to spot routes and take advantage of them before others.
I started on a php webservice that the application can DL and UL market data to a central server. Some feed back I got was that people didn't want to share their data. That is fine so I put the webservice to the side. But an idea would be to create the webservice and put that up for DL for users that want to use/share a central db market data collection with their friends or Corp.
Also I under stand eve-central does the whole data share. ISK MEDIC was made to view the market and expose some data trending that eve-central doesn't do. eve-central's focus is mainly set for trade routes between sell orders to buy order routes.
With ISK MEDIC we were looking at it being easy to use for players new to the free market in eve, also at the same time useful for vetren players.
Now, I could still develop the php webservice and put up a central database but make it an option to use the ISK MEDIC central DB or you can the URL of your own hosted webservice/central database.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.07.30 15:23:00 -
[38]
Originally by: Hel O'Ween
But my main point against CSVs is the missing capability of (strong) data typing.
I agree with you 100% We can only hope for CCP to change their market export format. But for now the CSV for my application has done fine. The only thing I have heard is an error/crash when trying to import more than 300 log files at a time.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.06 19:09:00 -
[39]
Anyone else have any requests for adding in some new feature?
|

Sianchi
 |
Posted - 2008.08.09 20:43:00 -
[40]
ISK Medic looks awesome but I have a problem: prices aren't correctly imported from the market logs.
It doesn't seem to parse the decimal seperator.
For example, a price of 680.0 in the market log becomes 6.800,00 in ISK Medic. 5255.95 becomes 525.595,00 and so on.
Any idea?
|
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.13 16:35:00 -
[41]
Originally by: Sianchi ISK Medic looks awesome but I have a problem: prices aren't correctly imported from the market logs.
It doesn't seem to parse the decimal seperator.
For example, a price of 680.0 in the market log becomes 6.800,00 in ISK Medic. 5255.95 becomes 525.595,00 and so on.
Any idea?
What is your country/region settings? I have ISK MEDIC set to detect and use your default region setting during import and displaying the data. I wonder if I missed something.
|

Margret Putnam
 |
Posted - 2008.08.13 20:50:00 -
[42]
Is there a fast way to download the market data? Going from item to item can get very tedious if i do it 50-100 times, especially if i have to do it in multiple regions.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.14 18:56:00 -
[43]
Originally by: Margret Putnam Is there a fast way to download the market data? Going from item to item can get very tedious if i do it 50-100 times, especially if i have to do it in multiple regions.
I wish the eve client had a way to dump out data for all items in your current region. But no there is no auto/easy way to export the market data from eve.
|

Sianchi
 |
Posted - 2008.08.18 08:33:00 -
[44]
I solved the decimal sperator problem by setting it from "," to "." in Vista.
Anyway, I have another problem. When I import data from a 0.0 region (Providence), ISK Medic won't display it. It's empty. I'm assuming that ISK Medic doesn't recognise the stationIDs.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.18 18:02:00 -
[45]
Originally by: Sianchi I solved the decimal sperator problem by setting it from "," to "." in Vista.
Nice work around!
Originally by: Sianchi
Anyway, I have another problem. When I import data from a 0.0 region (Providence), ISK Medic won't display it. It's empty. I'm assuming that ISK Medic doesn't recognise the stationIDs.
At current version the database is missing the new region with the lastest update to the game.
Does this system/station happen to be in the new region?
I will try to get a dump of the update-to-date data into a new DB for ISK MEDIC soon.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.18 18:56:00 -
[46]
Just an FYI the database format that ISK MEDIC is MS Access. So if you have the data dump of the new region,systems, and stations in a .csv file etc. You can open the access database and import the new data yourself.
If you know how to do it..... |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.18 18:59:00 -
[47]
Also, I have been putting some Trading 101 for trade beginners using CamStudio but I can't seem to get them small enough.
If anyone has some good information on doing videos for 101 guides, let me know.
My vids end up being too large and the one I made small enough to upload to youtube was really poor after upload so I deleted it.
|

Sianchi
 |
Posted - 2008.08.18 21:48:00 -
[48]
Edited by: Sianchi on 18/08/2008 21:49:26
Originally by: Gremrod At current version the database is missing the new region with the lastest update to the game.
Does this system/station happen to be in the new region?
I will try to get a dump of the update-to-date data into a new DB for ISK MEDIC soon.
No, it's not a new region, it's Providence, an old 0.0 region and I guess the stations in question are player-built outposts. I import the market logs into ISK Medic and when I try to access the information ISK Medic tells me that there is no data.
I'm assuming that it has something to do with the stationIDs because there is another program I use (forget the name, my PC is broken, I'm on the laptop right now and can't look it up) and when I import data there, the station names don't show up either (but the rest of the data does).
Anyway, you can test it for yourself. I uploaded a marketlog from Providence here: Market Log
So maybe ISK Medic simply doesn't recognize the IDs of outposts in non-NPC 0.0? |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.19 16:51:00 -
[49]
Edited by: Gremrod on 19/08/2008 16:51:50 That is correct. ISK MEDIC only has data on NPC stations. Anyone know where you can get the data on all non-NPC stations? |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.19 22:12:00 -
[50]
It appears I can get the non-NPC station data from the EVE API eve/ConquerableStationList.xml.aspx
I think I will see about making some changes here to get this data from the API. But for the mean time I can add this stations to the ISK MEDIC database and put it up for an update download. I guess I should and try to find a dump of the EVE data with the new region, systems, stations. |
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.08.21 04:11:00 -
[51]
Got the new region, systems, and stations added to the database see top of thread for download link. Still need to get non-NPC/player controled stations added. |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.09.04 18:53:00 -
[52]
Edited by: Gremrod on 04/09/2008 18:53:24 I will get the player owned stations into the database. I think I may have isk medic use the api to grab these stations since they can change names and not have static names like the npc stations.
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.09.13 21:28:00 -
[53]
Bug fix released see top of thread!!!!! Or download HERE
|

Shar Tegral
 |
Posted - 2008.09.13 21:36:00 -
[54]
Originally by: Gremrod Bug fix released see top of thread!!!!! Or download HERE
If I may ask, what was the bug?
To Shar -verb: 1 - To say what you mean. 2 - To say what it means. 3 - To say something mean. |

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.09.16 18:02:00 -
[55]
There was an error in the Quanity column values during import. Import logs hold a double value and during import 10.0 would import as 1
|

Shar Tegral
 |
Posted - 2008.09.16 19:29:00 -
[56]
Ah... so that is what was causing that. Cool.
To Shar -verb: 1 - To say what you mean. 2 - To say what it means. 3 - To say something mean. |

Aredhela
 |
Posted - 2008.09.16 22:45:00 -
[57]
I cannot use this program . When i click to any item program to import prices program crashes.Here is what i got:
Szczeg=łowe informacje na temat wywoływania debugowania w trybie JIT (just in time) zamiast tego okna dialogowego znajdują się na końcu tego komunikatu.
************** Tekst wyjątku ************** System.Data.OleDb.OleDbException: Błąd składniowy (brak operatora) w wyrażeniu kwerendy '(MarketData.bid = True ) AND (invtypes.typeName = 'Prophecy' ) AND (mapregions.regionName IN ())'. w System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult) w System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult) w System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult) w System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) w System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior) w System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) w System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) w System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) w System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) w EVEMarket.DL.market.getRegionMarketData(Boolean bid, String item, String regions) w EVEMarket.Browse.tvMarketGroups_NodeMouseDoubleClick(Object sender, TreeNodeMouseClickEventArgs e) w System.Windows.Forms.TreeView.OnNodeMouseDoubleClick(TreeNodeMouseClickEventArgs e) w System.Windows.Forms.TreeView.WndProc(Message& m) w System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) w System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) w System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
************** Zestawy załadowane ************** mscorlib Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- EVEMarket Wersja zestawu: 1.0.0.15 Wersja Win32: 1.0.0.60 CodeBase: file:///G:/iskmedic/iskmedic.exe ---------------------------------------- System.Windows.Forms Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Windows.Forms.resources Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms.resources/2.0.0.0_pl_b77a5c561934e089/System.Windows.Forms.resources.dll ---------------------------------------- System.Data Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Xml Wersja zestawu: 2.0.0.0 Wersja Win32: 2.0.50727.1433 (REDBITS.050727-1400) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------
|

Gremrod
Minmatar DEEzNUTS-DzN
 |
Posted - 2008.09.18 15:25:00 -
[58]
Originally by: Aredhela I cannot use this program . When i click to any item program to import prices program crashes.Here is what i got:
Szczeg=łowe informacje na temat wywoływania debugowania w trybie JIT (just in time) zamiast tego okna dialogowego znajdują się na końcu tego komunikatu.
I am not sure why you would get this error at this point. Let we double check the import process to double check it is using your local region settings and default language. A work around would be to set your region and language to US/English.
I will look into the issue.
|

Levenson
Caldari Unknown Corp DeaDSpace Coalition
 |
Posted - 2008.09.24 15:22:00 -
[59]
Help me. I can't import any logs. When it's running i try to import logs, but it silently crashed!! There are no any messages. Here is my comp info file if you need. http://eve-files.com/dl/173744 To Think.. |

Shipmaster Siskind
 |
Posted - 2008.09.24 15:41:00 -
[60]
I can't start the program. When I try to run iskmedic.exe it tells me there's an error (blaw blaw, has ecountered an error, blaw blaw)
|
|
| Pages: 1 [2] 3 :: one page |
| First page | Previous page | Next page | Last page |