EDDiscovery

[iain666]

You're adding distances from the system you're in (with known coordinates all the time now) to the unknown system.

Those get stored by EDSM and every time it gets a new one for one of your target systems it'll see if it can trilaterate now, when it can the coordinates will come back to EDD and the status in the trilateration tab will change from 'Position Unknown' to 'Position Found'.

If you're a long way away then this can take a lot of distances because they're all in roughly the same direction, if you're close to where your earlier trips were then it should be easier.

If any are stubborn then drop them into the EDSM thread or discord and they can be pushed to the front to get other Commanders to add some distances too.

 

[Rardain]

You're adding distances from the system you're in (with known coordinates all the time now) to the unknown system.

Those get stored by EDSM and every time it gets a new one for one of your target systems it'll see if it can trilaterate now, when it can the coordinates will come back to EDD and the status in the trilateration tab will change from 'Position Unknown' to 'Position Found'.

If you're a long way away then this can take a lot of distances because they're all in roughly the same direction, if you're close to where your earlier trips were then it should be easier.

If any are stubborn then drop them into the EDSM thread or discord and they can be pushed to the front to get other Commanders to add some distances too.

Ah I see, thanks for that. As I say I have 402 systems to enter - the closest being 5.5 KLy from me and the farthest being 10.7 KLy.

I am still a bit confused about how I will get the distances for other systems though. The last time I trilaterated was before the current update to EDD and everything was done manually. So to trilaterate a system I was in all references were from my system to the reference systems.

Now the only accurate reference distance I will know will be from my current position to the target system...if it starts asking me for other distances I have no way of accurately finding these out.

 

[Rardain]

Ok, still confused. I tried adding the first two systems for my journey in the trilateration tab. The first is HIP 11470 which it let me enter but says position unknown. I can only enter the distance from my current system to HIP 11470 as its the only one I know so then I hit trilaterate and it says successful but position remains unknown.

So the next system I try to enter is SYNUEFE JH-F B42-0 but it won't allow this and says only systems with co-ordinates or already known to EDSM can be entered. So quick question...do I need to be entering these systems actually on the EDSM website rather than via the application?

Ta

 

[iain666]

Yeah, they need to get onto EDSM first. However, I've just had a look and the 'where are you now' box (that I would previously have used to get a system onto EDSM manually) has gone. I suppose it's not really needed any more.

Hmm, I don't know how to tell EDSM a system exists without verbose logs then.

Unless Anthor tells us how to do that I'll take that check out of EDD tomorrow and the next release should sort you out.

(The trilateration successful message means that your current system now has a position - but it already did so that's basically all it will ever say on submission for ever more now... Keep adding them for HIP 11470 from different places and the 'Position Unknown' will change when EDSM gets it locked down)

 

[Rardain]

Yeah, they need to get onto EDSM first. However, I've just had a look and the 'where are you now' box (that I would previously have used to get a system onto EDSM manually) has gone. I suppose it's not really needed any more.

Hmm, I don't know how to tell EDSM a system exists without verbose logs then.

Unless Anthor tells us how to do that I'll take that check out of EDD tomorrow and the next release should sort you out.

(The trilateration successful message means that your current system now has a position - but it already did so that's basically all it will ever say on submission for ever more now... Keep adding them for HIP 11470 from different places and the 'Position Unknown' will change when EDSM gets it locked down)

Yeah, I jumped on EDSM last night and manually added SYNUEFE JH-F B42-0 then started adding distances for both SYNUEFE JH-F B42-0 and HIP 11470 from my next four systems. If I have to do that for all 402 systems I will be an old man before I finish [hehe]

 

[AnthorNet]

Yeah, they need to get onto EDSM first. However, I've just had a look and the 'where are you now' box (that I would previously have used to get a system onto EDSM manually) has gone. I suppose it's not really needed any more.

Hmm, I don't know how to tell EDSM a system exists without verbose logs then.

Unless Anthor tells us how to do that I'll take that check out of EDD tomorrow and the next release should sort you out.

(The trilateration successful message means that your current system now has a position - but it already did so that's basically all it will ever say on submission for ever more now... Keep adding them for HIP 11470 from different places and the 'Position Unknown' will change when EDSM gets it locked down)

The box hasn't change, only the label
Just enter the system in the front page, hit enter, EDSM will propose you to add the system as before.

 

[Rardain]

The box hasn't change, only the label
Just enter the system in the front page, hit enter, EDSM will propose you to add the system as before.

Is there a quick way of inputting a lot of systems in one go or would I need to send the info to EDSM themselves? I am busy filling out a spreadsheet with the systems as I only have the information in hardcopy at the moment.

 

[Redfox]

Is there a quick way of inputting a lot of systems in one go or would I need to send the info to EDSM themselves? I am busy filling out a spreadsheet with the systems as I only have the information in hardcopy at the moment.

Yes, there's quite an easy way to and have any number of systems quickly added to your EDD "Wanted" list for your reverse trilateration and initially 'created' on EDSM. I did that (entering and reverse trilaterating) for the DWE logo and the Coriolis on the 3D map and it worked great.

So here is how I did it.

1. Prepare all your systems in a list (txt or xls). Make sure you copy/paste every one of them into the ED GalMap search window once and make sure it is found. This is to ensure there are no typos and that no other system is found instead (which can happen under certain conditions). If you submit wrongly named systems to EDSM, someone will have to clean that up, which can be prevented with this check.
2. You'll be adding your systems directly into EDD's DB, so we need to create the SQl code to do so. For me, xls did that job very well. Here's what it looks like: http://i.imgur.com/lJ7WfJX.png
3. Download and install http://sqlitebrowser.org/. Close EDD and open the EDD DB in SQLite (my DB is at DriveID:\Users\UserName\AppData\Local\EDDiscovery\EDDiscovery.sqlite; you might want to make a backup before proceeding; you can ignore the other numbered sqlite files). Go to the 'Execute SWL' tab an paste the SQL code from the xls into the field and execute it (press the play button). Then 'save' the changes by clicking the "Write Changes" button at the top. Close SQLite.
4. Start EDD. Go to the "Trilateration" tab and click "Start new". At the bottom right you now should see you 'Wanted' list with all your systems (plus a few from EDSM). Clicking on them will add them to the trilateration list, meaning you can enter distances to them from your current position. Don't forget to click "Submit distances" when you're done, otherwise they will not get submitted to EDSM. Submitting them for the first time will create the systems on EDSM.
5. Repeat 4. from several systems and after some (few or probably many) submitted distances your systems will start to resolve (i.e. get their coordinates) and show as 'waypoints' on your map. The more you move between systems (especially high/low) the better your chances are at getting the systems resolved.

Hope this makes sense. If not, please ask.

 

[iain666]

That may not work, as unknown systems are validated against EDSM when you try to add them to the trilateration grid. Adding them to the wanted list by writing to the DB may circumvent this, or it may be that you hit the period when this validation was broken (when I wrote it EDSM returned -1 for nonexistent systems which changed to [] at some point without me noticing for a while and since [] != -1 you could add anything).

 

[Redfox]

That may not work

Currently running EDD v3.2.3 and just verified the procedure with the following systems and it still worked fine - please don't 'fix' it

INSERT INTO wanted_systems (systemname) VALUES
('plua eun vd-h c24-0'),
('plua eun vd-h c24-1'),
('plua eun tc-o b48-0');

 

[Inhumierer]

Yeah, I jumped on EDSM last night and manually added SYNUEFE JH-F B42-0 then started adding distances for both SYNUEFE JH-F B42-0 and HIP 11470 from my next four systems. If I have to do that for all 402 systems I will be an old man before I finish [hehe]

If you want to reverse trilaterate 400 systems, you have to enter AT LEAST 1600 distances. It will probably be about 2000-2500. What did you expect?
Or you just travel the same route again, then all systems will get known coordiantes.

 

[Redfox]

If you want to reverse trilaterate 400 systems, you have to enter AT LEAST 1600 distances.

Absolutely, and the emphasis on "AT LEAST" is important. The 440 systems making up the DWE logo required around 5000 distances, maybe more. Hardly doable without help from other CMDRs, preferrably in other parts of the galaxy (i.e. from different angles).

If I have to do that for all 402 systems I will be an old man before I finish [hehe]

Depends on what you're trying to achieve. If you just want your 'old' flight-path to be shown on the map then you could just pick every 20th or 30th system from your list and you'd still get a nice route drawn on the map.

 

[Rardain]

Absolutely, and the emphasis on "AT LEAST" is important. The 440 systems making up the DWE logo required around 5000 distances, maybe more. Hardly doable without help from other CMDRs, preferrably in other parts of the galaxy (i.e. from different angles).



Depends on what you're trying to achieve. If you just want your 'old' flight-path to be shown on the map then you could just pick every 20th or 30th system from your list and you'd still get a nice route drawn on the map.

Hi Redfox, yes, I thought about this after my last post when I thought 'what the hell am I on about - I only need to add in a few systems to draw the route' lol.

Gonna try your method later today...thanks for the help.

 

[Rardain]

Hi Redfox,

I have 15 systems I have identified that I want to enter to show my route. At the moment they are simply entered into a spreadsheet with no formula's - just text. Looking at your screenshot of the code is this what I need to enter in the spreadsheet (obviously replacing 'system name' with my systems)?

 INSERT INTO wanted_systems (systemname) VALUES
 ('system name'),
 ('system name'),
 ('system name');

And finally, to join the new line to the existing line seamlessly, do I need to enter the system name EDD has as the first system in its list as the last system name in the code I am entering into SQLite?

 

[Redfox]

Hi Redfox,

I have 15 systems I have identified that I want to enter to show my route. At the moment they are simply entered into a spreadsheet with no formula's - just text. Looking at your screenshot of the code is this what I need to enter in the spreadsheet (obviously replacing 'system name' with my systems)?

 INSERT INTO wanted_systems (systemname) VALUES
 ('system name'),
 ('system name'),
 ('system name');

And finally, to join the new line to the existing line seamlessly, do I need to enter the system name EDD has as the first system in its list as the last system name in the code I am entering into SQLite?

The code looks fine. Good luck

The sequence in the code is irrelevant, as the line will be plotted based on the timestamp of when you visited any given system.

 

[Rardain]

Hi Redfox,

I have followed all your instructions and all appears to be working fine but I have a query.

Two of the systems I have input (Hyades Sector HR-W d1-59 and Synuefe SF-F d11-3) are both successfully trilaterated but don't show up as waypoints on my maps...am I missing something?

 

[Redfox]

Looking at Synuefe SF-F d11-3 on EDSM it seems only Allitnil has visited that system, meaning EDSM does not know you've been there, thus not plotting your route through there.

Are you sure you've provided EDSM that part of your flight log? Or is there possibly a typo in the system name and you were somewhere else?

 

[Rardain]

Looking at Synuefe SF-F d11-3 on EDSM it seems only Allitnil has visited that system, meaning EDSM does not know you've been there, thus not plotting your route through there.

Are you sure you've provided EDSM that part of your flight log? Or is there possibly a typo in the system name and you were somewhere else?

Yes, this confused me too. Synuefe SF-F d11-3 is one of several systems I passed through on the 23rd December 2015 (the day I started out on my current journey).

Although I didn't discover any bodies in that system I definitely passed through it. I have just double checked and I can see all the bodies in that system so I have definitely been there and Hyades Sector HR-W d1-59 was my start point. [hehe]

Also, if you check the show distances tab for the system there are four entries from me (although not sure why it has calculated the same distance for the second entry as the third entry).

And finally, here is my jump-off system - well established in EDSM, and two entries from me but doesn't show in my travel history or 3d map.

Is there a step that can be done with the SQLite to add these systems manually to my travel history?

Cheers Redfox.

 

[Allitnil]

If those systems aren't in your flight logs then EDD / EDSM won't know you went there. I guess it would be possible to add them directly to the EDD database and then sync to EDSM but a proven method is to use the EDSM API to add them to EDSM and then sync them to EDD, see https://forums.frontier.co.uk/showt...ngerous-Star-Map/page53?p=3756205#post3756205 for the format. I used this technique to add a few hundred systems when recreating my earlier trips.

 

[Rardain]

If those systems aren't in your flight logs then EDD / EDSM won't know you went there. I guess it would be possible to add them directly to the EDD database and then sync to EDSM but a proven method is to use the EDSM API to add them to EDSM and then sync them to EDD, see https://forums.frontier.co.uk/showt...ngerous-Star-Map/page53?p=3756205#post3756205 for the format. I used this technique to add a few hundred systems when recreating my earlier trips.

Thanks Allitnill but I am not 100% sure what parts of the string I am replacing?

wget http://www.edsm.net/api-logs-v1/set-log?apiKey=YOURAPIKEY&commanderName=Andargor&systemName=Mel 111 Sector DB-O b6-0&dateVisited=2014-12-20 11:18:27

[hehe] At first glance it looks like part of the string is being rude (Your a Pikey)...ahem I digress.

So, just to double check, my Cmdr name is Rardain - if I want to add in HYADES SECTOR HR-W d1-59 on the 23/12/2015 at 8:30pm, the last part of the string should be this - correct?

...=YOURAPIKEY&commanderName=Andargor&systemName=Rardain HYADES SECTOR HR-W d1-59&dateVisited=2015-12-23 20:30:00