EVE Technology Lab

Hi there!

Thanks for this excellent tool! First, let me say that everything is working fine for me as far as program setup and running is concerned. But I have a problem with some data I get from this.

Using YC-118-3_1.0_117575.zip with "import" followed by "export -csv", I get a bunch of CSV files. Among them is

mapSolarSystems.csv

in which I can find the following systems

10000004;20000047;30000327;D95-FQ;
10000004;20000047;30000328;ZSPJ-K;

where I have just copied the first four columns

regionID;constellationID;solarSystemID;solarSystemName;

Now, if we look at Dotlan, then we see that they are connected by a stargate

Dotlan map

I would expect to see this connection in

mapSolarSystemJumps.csv

Basically, there should be an entry

10000004;20000047;30000327;30000328;20000047;10000004;

which is just a connection from D95-FQ to ZSPJ-K according to

fromRegionID;fromConstellationID;fromSolarSystemID;toSolarSystemID;toConstellationID;toRegionID;

But in fact neither systems is listed here at all (the relevant SolarSystemIDs are not in this CSV file).

I am relatively sure that I'm reading the files right in general, since I get other connections right.

I can see three possibilities:

1. My understanding is false/incomplete, this particular connection is listed elsewhere or in a different manner.
2. CCP's SDE is corrupt concerning this, and Dotlan somehow knows better.
3. The SDE is correct, but something goes wrong in the import or export to CSV with your program.

I was hoping that you could shed some light on what is going on there. I should mention that I have basically zero clue about SQL databases, I just followed the various instructions to set stuff up (apparently successfully, everything seems to be running smoothly). I'm a Matlab kind of guy. Hence the export to CSV, which I can read into Matlab.

I've spotted this problem when I ran a Matlab script to collect all wormholes. My idea was to simply find all systems that have no static connections. That finds all the J-systems and Thera, but to my surprise I found several extras like this one...

Thanks for the quick response. I have now submitted a bug report! Actually, I found a lot more of these falsely isolated systems, I just didn't write this up:

'WF-1LM' 'D95-FQ' 'ZSPJ-K' 'U1F-86' 'T-P7A6' 'Y-T3JJ' 'F3R-IA' '74-YTJ' '8-RS3U' 'OVFN-N' '1Q-BBM' 'WXNC-N' 'G-EA07' 'X-L6BO' 'D-PHUA' '3-HXHQ' '18A-NB' '3-J5OQ' 'GYF-GD' 'W-6TS9' 'VIG-VR' 'KX-P5C' 'N-FJBK' '2-4ZT5' 'NVN-6F' '09-8TH' 'TI0-AX' '7O-POM' 'L6Q-SX' 'BFJ-TB' 'ZZ7-L6' 'L-CHVW' 'X0LN-U' 'RQAE-M' '7CO-SA' '4G-E5A' 'A-VWK9' 'JQHP-4' '6Q5K-5' 'P-MVFP' 'J-Z1UW' 'W477-P' 'NQ1-BL' 'K7A-G8' 'HP-PMX' '6BN-K9' 'WLE-PY' 'EH-HXW' 'OS-RR3' 'V4-GZL' '4C-Z91' 'RU-97T' '1S-1V7' 'PE1-R1' 'Polaris' 'JB-007' 'USJ2-M' '7M-RAL' 'LPBU-U' 'RF-342' 'J2V-XY' 'Z-JBTR' 'S-QNXH' 'S94-X8' 'J-YQEC' '8MX-OR' '97YC-C' 'V-AMD5' 'U-JC8X' '1HH3-E' 'DUIU-Q' 'LQH0-H' 'FRW3-2' '9MX-1C' 'IED-4U' 'N-9EOQ' '6F3-TK' '2E0P-2' 'U-ITH5' 'N-4G5L' 'RB-2EA' 'ZK5-42' 'YRZ-E4' 'A3-PAT' 'H55-2R' 'P6-DBM' '9XI-0X' 'Q8T-MC' 'Z-YOJ9' '4T4B-L' 'F-JB3H' 'XBO7-F' 'FI-449' 'UA7-U4' 'PZP1-D' 'R1KE-A' 'JGDF-B' '1SR-HT' 'SQ-2XA' 'Z-FYJR' 'ZA6-9N' 'J1-6CJ' '7H-Z5R' '0RZ5-2' 'A9-NB6' 'LG1-TA' 'TNK-BQ' 'E2AX-5' 'HPE-KP' 'THS-MN' 'UBES-K' 'I-R8B0' 'QIW-TQ' 'WLL-QX' 'BJC4-8' 'PQA-9K' 'S5-U0R' 'CW-R71' 'QO-3LC' '3E-ER7' 'REZ-YZ' 'OU-AIT' 'VYX2-I' '5-P3CQ' 'M-FDTD' '54-VNO' 'IAMZ-5' 'HD3-JK' 'PBXG-A' '9-ERCP' 'KN7M-N' 'Z-D1DW' 'FO-3PJ' '6-QXE6' 'N-FKXV' 'X7-8IG' 'R-G1SF' '6-NCE7' 'WDJQ-G' 'JS3-RS' 'JX-T1W' 'CZ-CED' 'BKK4-H' 'Y-4V7U' 'L-TPN0' '3-XORH' 'G1VU-H' 'W6H6-K' '6-23NU' 'DVAR-P' 'J-JS0D' 'VR3-PS' 'LH-J8H' 'I9D-0D' 'HGB-C6' '2L5-FI' 'RS08-B' '4U-14I' 'H-EDXD' '8-ULAA' 'KF1-DU' 'W-WQM5' 'G5J-LH' 'H7OL-I' 'TO21-U' 'RN-5K9' '0M-M64' 'W5-SGC' '8RV-1L' '1C-TD6' 'YBYX-1' '2-NF2Z' '0Z-VHC' '9-BUSQ' 'LQB-TC' 'II-1B3' '6-HFD6' 'P3UD-M' 'LCN-0V' 'FX-XMW' 'G-N6MC' '7-8XK0' '90G-OA' 'DT-7EO' 'B-Y06L' 'HHQ-8L' 'Z-KPAR' '8U-RZH' '2RV-06' 'CLDT-L' 'QU7-EE' 'UC-X28' 'R79-I7' 'E-RPGP' 'ZV-KZO' 'NSE-U1' 'KER-EU' '69A-54' 'M9-OS2' '5V-YL6' '8-UWFS' 'PQWA-L' 'BWO-UU' 'SQVI-U' 'T-YWDD' 'DLY-RG' 'T-C5A0' 'UP-L3Y' 'F-KBNV' 'JL-P9P' 'FR-RCH' 'FNS3-F' '7BA-TK' 'IAWJ-X' '50-TJY' '3-CE1R' '0IRK-R'

Hmm, I checked lastest SDE...
I see the constellations and solarsystem there.

Edit. I can confirm missing data in mapSolarSystemJumps table

@Tristan Agion While I was dealing with the new SDE format I realized that region UUA-FA is the CCP region. If you look at the EVE client map you will see that there are only a few solar systems that are connected (i.e. have stargates). Therefor, the data are correct and you should close the bug report cause your claim doesn't stand.

Hi Desmont,

using the new (now deemed "legacy") SDE linked by CCP Tellus, I got an error:

Unable to import ramTypeRequirements
Reason was: Verletzung der PRIMARY KEY-Einschränkung 'ramTypeRequirements_PK'.
Ein doppelter Schlüssel kann in das dbo.ramTypeRequirements-Objekt nicht eingefügt werden.
Der doppelte Schlüsselwert ist (41590, 1, 38).

... which translates to

Reason was: Violation of PRIMARY KEY constraint 'ramTypeRequirements_PK'.
A duplicate key can't be inserted into the dbo.ramTypeRequirements object.
The duplicate key value is (41590, 1, 38).

I've also crossposted over in the SDE changes thread: https://forums.eveonline.com/default.aspx?g=posts&m=6457455#post6457455

@Hel O'Ween
After talking with CCP Tellus (https://forums.eveonline.com/default.aspx?g=posts&m=6458181#post6458181) I would suggest that you correct the blueprints.yaml file manually.

1. Delete lines 169277-78
2. Correct the quantity of typeID: 38 for manufacturing from 3 to 8.

How curious

Did you also find that several tables of the legacy ms sql dump are mssing their content? dgmTypeAttributes (and its dgmAttributeTypes) is a bit annoying.

I just got the info from Fuzzsteve that there was another more recent SDE, so I got that one

Hey Des,

Do you need to cut a new release of your tool with fixes for the new SDE? Or are you planning to leave it as-is for now?

Thanks! And thanks again for the great tool!

Awesome. Happy to help beta test when ready.

Sorry for the late reply. My eye just now caught your post.
UUA-FA has always been the CCP region meaning that in that region CCP tests things in production.
No capsuleer can access that region unless (s)he has been transferred there by CCP.
Dotlan hasn't updated its Universe data, since who knows when, probably from the time Wormholes where introduced, simply because there is no reason to do so as these data are static and don't change frequently.

Now if your O.C.D. (joke) impulses you for Dotlan and SDE to match, contact Wollari and ask him to update his DB.