|
Author |
Thread Statistics | Show CCP posts - 4 post(s) |
Calvin
Israeli Space Corporation
4
|
Posted - 2014.07.14 22:56:00 -
[1] - Quote
Desmont McCallock wrote:You must specify the data source in the connection string at the config file. How do you expect the tool to know where the SQL server is and how you named the database?
Hi Desmont, I apologize for the totally n00b question here, but... well that's a good description of my skills in this area (I nearly had a panic attack when I saw the BP material list being moved to YAML).
Where exactly do I need to change the connection string so your tool hooks up with my MS SQL database? I see the connectionStrings section in the config file, but it's all greek to me at the moment. |
Calvin
Israeli Space Corporation
4
|
Posted - 2014.07.17 02:12:00 -
[2] - Quote
Darkblad wrote:Hel O'Ween wrote:Calvin wrote:Now I need to figure out how to get it to import the blueprints.yaml file... When extracting the archive, it creates two folders: SQLITEFILES and YAMLFILES, with the YAMLFILES folder holding a file appropriately named "Put yaml files here" . Now I leave it to you to guess how to import that blueprints. yaml file ... Problem is, that the current version of Desmont's tool doesn't respect the blueprints.yaml (new file for crius). First thing that comes to mind would be "what if I change its name to one of the .yaml files that Desmont's tool actually uses" - but that would break things - worst case being that the wrong data gets inserted into the wrong tables of the MSSQL database.
Thanks Dark, that about sums up the problem. I'm starting to hit panic mode as I'm about to loose my BP material list table, which means about 85% of all my database functionality goes out the window... I love Desmont's tool, but arg, stops short of solving my problem at the moment! |
Calvin
Israeli Space Corporation
4
|
Posted - 2014.07.18 22:12:00 -
[3] - Quote
Desmont McCallock wrote:Guys don't panic. I will work on a new version that supports the Crius patch this weekend. Stay tuned.
u r my hero (-:
Thanks Desmont! Anything you can do to have this ready for Crius I really appreciate! |
Calvin
Israeli Space Corporation
4
|
Posted - 2014.07.19 18:40:00 -
[4] - Quote
Desmont McCallock wrote:Doing a query on the Rubicon 1.2 SDE all have productTypeID. So I believe this is still a problem, Steve.
Totally understand Desmont, would rather see a properly-debugged tool than a half-assed one (-: Thanks for working on this! |
Calvin
Israeli Space Corporation
9
|
Posted - 2014.07.27 16:21:00 -
[5] - Quote
Desmont McCallock wrote:Just released a beta version for the Crius patch. You'll find the dl link in the first post of the thread. Please report any inconsistencies you may find.
Hi Desmont,
Thanks for your work on this. The blueprints stuff imported successfully, however I'm not sure I completely understand what data is going where. It looks like you re-made the old tables? Could you give some indication on what data from the blueprints.yaml file goes where exactly?
Thanks much! |
Calvin
Israeli Space Corporation
9
|
Posted - 2014.07.27 18:02:00 -
[6] - Quote
Desmont McCallock wrote:I tried to make the smallest changes to the existing tables to avoid breaking changes. Therefore I kept all old columns and added new ones for those data that I found in the yaml file and was not sure where to put them.
So in the invBlueprintTypes I added the following columns: - [duplicatingTime] - [reverseEngineeringTime] - [inventionTime]
In the ramTypeRequirements I added the following columns: - [level] (I refrained from using the quantity column for this as it made more sense to add that data in there own column) - [raceID] - [probability] - [consume]
I also found an inconsistency in the data parsing and I released a new beta version.
Would I be correct in that consume is 0 if it's not consumed, and null if it is?
Can I ask how you're separating the ramTypeRequirements data from the invTypeMaterials data?
Thanks Desmont, |
Calvin
Israeli Space Corporation
15
|
Posted - 2014.07.27 18:02:44 -
[7] - Quote
Desmont McCallock wrote:I tried to make the smallest changes to the existing tables to avoid breaking changes. Therefore I kept all old columns and added new ones for those data that I found in the yaml file and was not sure where to put them.
So in the invBlueprintTypes I added the following columns: - [duplicatingTime] - [reverseEngineeringTime] - [inventionTime]
In the ramTypeRequirements I added the following columns: - [level] (I refrained from using the quantity column for this as it made more sense to add that data in there own column) - [raceID] - [probability] - [consume]
I also found an inconsistency in the data parsing and I released a new beta version.
Would I be correct in that consume is 0 if it's not consumed, and null if it is?
Can I ask how you're separating the ramTypeRequirements data from the invTypeMaterials data?
Thanks Desmont, |
Calvin
Israeli Space Corporation
9
|
Posted - 2014.07.27 18:52:00 -
[8] - Quote
Desmont McCallock wrote:Quote:Would I be correct in that consume is 0 if it's not consumed, and null if it is? Looking at the data the 'consume' attribute is only applied on datacores and if I'm not mistaken they don't get consumed anymore. The 'Null' in the column indicates that it isn't specified. Quote:Can I ask how you're separating the ramTypeRequirements data from the invTypeMaterials data? Good question, as I stumbled on that myself. invTypesMaterials is now only used to determine the reprocessed materials of an item. Everything you need for a blueprint activity is now in the ramTypeRequirements.
Thanks for clarifying that. It does look like the 'consume = 0' characteristic is applied only to the interfaces, not datacores, which makes a bit more sense. No need to get people overly excited (-:
Thanks again for continuing to work on this Desmont! |
Calvin
Israeli Space Corporation
15
|
Posted - 2014.07.27 18:52:52 -
[9] - Quote
Desmont McCallock wrote:Quote:Would I be correct in that consume is 0 if it's not consumed, and null if it is? Looking at the data the 'consume' attribute is only applied on datacores and if I'm not mistaken they don't get consumed anymore. The 'Null' in the column indicates that it isn't specified. Quote:Can I ask how you're separating the ramTypeRequirements data from the invTypeMaterials data? Good question, as I stumbled on that myself. invTypesMaterials is now only used to determine the reprocessed materials of an item. Everything you need for a blueprint activity is now in the ramTypeRequirements.
Thanks for clarifying that. It does look like the 'consume = 0' characteristic is applied only to the interfaces, not datacores, which makes a bit more sense. No need to get people overly excited (-:
Thanks again for continuing to work on this Desmont! |
Calvin
Israeli Space Corporation
9
|
Posted - 2014.07.27 19:07:00 -
[10] - Quote
Desmont McCallock wrote:OK, I will change the beta to RC, as it looks solid. I worked with it for EVEMon and things look good. So if noone else finds anything odd with it, this version will be the official release version of the tool.
Forgive me if I'm totally missing something here, but is there data here that can link a T1 BP to it's T2 invention counterpart? |
|
Calvin
Israeli Space Corporation
15
|
Posted - 2014.07.27 19:07:26 -
[11] - Quote
Desmont McCallock wrote:OK, I will change the beta to RC, as it looks solid. I worked with it for EVEMon and things look good. So if noone else finds anything odd with it, this version will be the official release version of the tool.
Forgive me if I'm totally missing something here, but is there data here that can link a T1 BP to it's T2 invention counterpart? |
Calvin
Israeli Space Corporation
9
|
Posted - 2014.07.27 19:26:00 -
[12] - Quote
Desmont McCallock wrote:Yes, in ramTypeRequirements, activityID = 8, look for the requiredTypeID that is a blueprint. (i.e typeID : 879, activityID : 8, requiredTypeID : 12634). Usually it comes with a probability attribute too (in the example case it's 0.4).
Edit: I spend two weekends wrapping my head around the data in the blueprint.yaml file as it contains the combined data of two previous tables, plus new data for the Crius patch.
Ooh, I get it. Anything under activity 8 with a probability is a potential output of the invention for that BP.
Believe me, your effort is really appreciated! I tried to work with the file myself, and decided to just throw my arms up in frustration after wracking my brain on it. |
Calvin
Israeli Space Corporation
15
|
Posted - 2014.07.27 19:26:45 -
[13] - Quote
Desmont McCallock wrote:Yes, in ramTypeRequirements, activityID = 8, look for the requiredTypeID that is a blueprint. (i.e typeID : 879, activityID : 8, requiredTypeID : 12634). Usually it comes with a probability attribute too (in the example case it's 0.4).
Edit: I spend two weekends wrapping my head around the data in the blueprint.yaml file as it contains the combined data of two previous tables, plus new data for the Crius patch.
Ooh, I get it. Anything under activity 8 with a probability is a potential output of the invention for that BP.
Believe me, your effort is really appreciated! I tried to work with the file myself, and decided to just throw my arms up in frustration after wracking my brain on it. |
|
|
|