Release Trade Computer Extension Mk.II

Maedhros · Jan 26, 2016

Start problem

Been merrily cruising in ED using TCE with no problem. Added locations such as CZ and this seemed to work OK.

Exited TCE and ED for a bit and went back in but got this error

Had a look at the databases but nothing seems amiss

[Edit] - just wondering if you were willing to share the Database schema with us then we would have a bit more insight into the various relationships. Also, out of curiousity, which development tool are you using?

[Edit] - I think I may have solved the problem. There were a number of entries in the public_Store table that were apparently not linked to anything. I deleted these and adjusted the ID field so that it reamined sequential and then adjusted the foreign key fields in the public_Log table. Everything now seems to work fine.

bAdbUd · Jan 26, 2016

INCONSISTENCY BETWEEN STAR SYSTEMS AND MARKET PLACES.

It's a recently updated system.

Even after quitting TCE moving away and looking at the details again I see inconsistencies still.

INCONSISTENCY_BETWEEN_STAR_SYSTEMS_AND_MARKET_PLACES_3.png

INCONSISTENCY_BETWEEN_STAR_SYSTEMS_AND_MARKET_PLACES_4.png

rodsfree · Jan 26, 2016

Just a question, but is there any way that the database could reflect that of EDDB or Maddavo's. Both have very consistent data structures and are also including the new planetary posts, factions and the Powers. It would also make populating the initial database a lot easier, especially since EDDB uses ED Market Connector also.

And another thought, I'm out at FEHU and it wont let me add the Star data so that I can add the markets. The save button never appears when I try to add a new star and then when I try to select database stations it flashes UNKNOWN. It never gives me an error, it just won't let me do anything. The frustrating part is it shows FEHU at the top of the screen. Since it shows where I am could it add to the STARS database automatically???

It works GREAT when I'm closer to the center of the bubble!!!!
Thanks for the hard work!!!

Solarspaceprobe · Jan 26, 2016

I have a small problem. I have no idea how to use this. Yes, I'm going to be that idiot who missed something obvious. All I've figured out is how to open the launcher, which has the options menus, but I can't figure out how to make the actual overlay appear. I am definitely using Elite Dangerous in borderless mode, too. Help?

Djuwanna · Jan 26, 2016

Am I missing a setting somewhere? My star summary panel opens every time I enter a system I've some data on (i.e. location but not star type), but doesn't open if I have NO data on the star system....that's when I could use it the most. Is there a tick box I missed?

bAdbUd · Jan 26, 2016

rodsfree said:
Just a question, but is there any way that the database could reflect that of EDDB or Maddavo's. Both have very consistent data structures and are also including the new planetary posts, factions and the Powers. It would also make populating the initial database a lot easier, especially since EDDB uses ED Market Connector also.

I know for a fact that EDDB is out of date and has many errors. You need to bear in mind that EDDB started back in BETA days, and as such lots of data is defunct. For instance I've found 40'ish systems that don't exist in GAME but are in TCE and EDDB.

As to being updated to what is there currently, then the question becomes can you update it often. So becomes never ending, as being upto date means sourcing crowdsourced data often. TCE isn't about crowdsourcing, you have a base DB the rest is your oyster.

QUESTION: What do you think EDMC does?

bAdbUd · Jan 26, 2016

Solarspaceprobe said:
I have a small problem. I have no idea how to use this. Yes, I'm going to be that idiot who missed something obvious. All I've figured out is how to open the launcher, which has the options menus, but I can't figure out how to make the actual overlay appear. I am definitely using Elite Dangerous in borderless mode, too. Help?

I really can't help, except say read the instructions fully. Otherwise if you have a specific problem please detail what it is.

bAdbUd · Jan 26, 2016

Djuwanna said:
Am I missing a setting somewhere? My star summary panel opens every time I enter a system I've some data on (i.e. location but not star type), but doesn't open if I have NO data on the star system....that's when I could use it the most. Is there a tick box I missed?

Hmmm, intresting, I can't say I've seen this, but I'll try and be more observant next time. In my case I think it comes up every time.

atomic7431 · Jan 26, 2016

This must be the quietest ive seen this thread, hope the thargoids have not taken you all as slaves

eventure · Jan 26, 2016

Grumpy181155 said:
That is correct. The panel itself does not appear when I select database / stars. It worked fine for the first two days of my journey but yesterday after I applied the updates; installer 0.9.9.7 and update 0.9.9.9 the panel to enter new star data no longer appears.
Also the credits panel when selected appears briefly but then disappears leaving only the top row of buttons visible.

If you can't edit the panel.db file yourself, please replace it by using the panel.tdm file from the TDM folder. Copy it into the DB folder, delete your old panel.db file and rename the panel.tdm to panel.db. Thereafter it should show up.

Maedhros said:
Been merrily cruising in ED using TCE with no problem. Added locations such as CZ and this seemed to work OK.

Exited TCE and ED for a bit and went back in but got this error

View attachment 98281

Had a look at the databases but nothing seems amiss

[Edit] - just wondering if you were willing to share the Database schema with us then we would have a bit more insight into the various relationships. Also, out of curiousity, which development tool are you using?

[Edit] - I think I may have solved the problem. There were a number of entries in the public_Store table that were apparently not linked to anything. I deleted these and adjusted the ID field so that it reamined sequential and then adjusted the foreign key fields in the public_Log table. Everything now seems to work fine.

Thanks for your databases, found the bug in TCE.

bAdbUd said:
INCONSISTENCY BETWEEN STAR SYSTEMS AND MARKET PLACES.

View attachment 98292 View attachment 98291

It's a recently updated system.

Even after quitting TCE moving away and looking at the details again I see inconsistencies still.

View attachment 98299 View attachment 98300

It is okay, because Update shows the date, when you updated the commodity data. Last shows, when you have visited the market at last. Reduce the font size for the Star System panel and you will see LAST VISIT, instead of only LAST.

rodsfree said:
Just a question, but is there any way that the database could reflect that of EDDB or Maddavo's. Both have very consistent data structures and are also including the new planetary posts, factions and the Powers. It would also make populating the initial database a lot easier, especially since EDDB uses ED Market Connector also.

And another thought, I'm out at FEHU and it wont let me add the Star data so that I can add the markets. The save button never appears when I try to add a new star and then when I try to select database stations it flashes UNKNOWN. It never gives me an error, it just won't let me do anything. The frustrating part is it shows FEHU at the top of the screen. Since it shows where I am could it add to the STARS database automatically???

It works GREAT when I'm closer to the center of the bubble!!!!
Thanks for the hard work!!!

Please hit the ENTER key every time you enter data. The row is highlighted in green, if the input was accepted. The SAVE button will appear, if all red colored rows truned green and all dropdown lists are selected.

Solarspaceprobe said:
I have a small problem. I have no idea how to use this. Yes, I'm going to be that idiot who missed something obvious. All I've figured out is how to open the launcher, which has the options menus, but I can't figure out how to make the actual overlay appear. I am definitely using Elite Dangerous in borderless mode, too. Help?

Please start TCE without ED and you should see the overlay. When starting ED in the back, it shows on top of it. If it doesn't show on top, please change the display mode of ED to full screen, apply and turn it back to borderless.

Djuwanna said:
Am I missing a setting somewhere? My star summary panel opens every time I enter a system I've some data on (i.e. location but not star type), but doesn't open if I have NO data on the star system....that's when I could use it the most. Is there a tick box I missed?

If you have no data about the star system (shown as unknown star system at the position display), the summary won't show up, because it can't show any information about it. Add the star system to your database and you will see, that the summary shows some informations about it. The summary shows the data about stored star systems.

mearmortal · Jan 26, 2016

Didn't retain size.

Launching TCE this afternoon, gave me the impression something was wrong with the summary window.
On examination it appears the size has not been maintained.

The opacity is fine, and the position is fine when it's at the right size.
View attachment 98436

*** Edit ***
Might be related, this is the first time in a long while I had to shutdown the game to set verbose logging enabled, after the update to the game.
I shut down TCE as well and re-started at the small window.

Abil Midena · Jan 26, 2016

Scrolling doesn't work either by mouse wheel or manual clicking in the trade panel/trade advisor.

eventure · Jan 26, 2016

Abil Midena said:
Scrolling doesn't work either by mouse wheel or manual clicking in the trade panel/trade advisor.

Thanks for reporting. Found the issue!

Grumpy181155 · Jan 26, 2016

Thanks Eventure. I have deleted and replaced the panel.db file and will try it tonight when I get home. What program are you using to open / edit the *.db files?

mearmortal · Jan 26, 2016

Observation:
When you are in markets creating a new station profile, have you noticed that the order for refuel, restock and repair is actually, refuel, repair and restock.
If you concur, would you be willing to change the order please.

View attachment 98535

punkerich · Jan 26, 2016

there's an error in modifying a stored location.
had a type 'point of interest' in kelin samba, planetside, with notes.
changed the poi later to 'resource extraction'.
when saved it gets confused:

shows wrong even in flight log, see:

the highlighted entry should be a planet in kelin samba.

another one:
when filtering via star system name, then clicking through the 'types', you'll get this:

details:

************** Ausnahmetext **************
System.Data.SyntaxErrorException: Syntaxfehler: Fehlender Operand nach dem Operator 'Star'.
bei System.Data.ExpressionParser.Parse()
bei System.Data.DataExpression..ctor(DataTable table, String expression, Type type)
bei System.Data.DataView.set_RowFilter(String value)
bei Trade_Computer_Extension.Panel_Navigation.Filter_Locations() in C:\Users\Hellfire\Documents\Visual Studio 2010\Projects\Trade Computer Extension\Trade Computer Extension\Panel_Navigation.vb:Zeile 5402.
bei Trade_Computer_Extension.Panel_Navigation.SL_FTR_Type_Click(Object sender, EventArgs e) in C:\Users\Hellfire\Documents\Visual Studio 2010\Projects\Trade Computer Extension\Trade Computer Extension\Panel_Navigation.vb:Zeile 5549.
bei System.Windows.Forms.Control.OnClick(EventArgs e)
bei System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message& m)
bei System.Windows.Forms.Label.WndProc(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bei System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bei System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

mearmortal · Jan 26, 2016

I have a new station for you, simply called 'outpost'

View attachment 98538 View attachment 98539

bAdbUd · Jan 26, 2016

mearmortal said:
I have a new station for you, simply called 'outpost'

View attachment 98538 View attachment 98539

Nice picture.

rodsfree · Jan 26, 2016

Can't add a New Star on a new installation of TCE_II

I've got an unhandled exception on a completely new installation of TCE. I was attempting to add a new Star to the database and got this error. This was the very first thing I tried to do with the new install.
The Database is the completely clean initial db.

Code:

See the end of this message for details on invoking 
just-in-time (JIT) debugging instead of this dialog box.


************** Exception Text **************
System.Runtime.InteropServices.ExternalException (0x800401D0): Requested Clipboard operation did not succeed.
   at System.Windows.Forms.Clipboard.ThrowIfFailed(Int32 hr)
   at System.Windows.Forms.Clipboard.SetDataObject(Object data, Boolean copy, Int32 retryTimes, Int32 retryDelay)
   at System.Windows.Forms.Clipboard.SetText(String text, TextDataFormat format)
   at System.Windows.Forms.Clipboard.SetText(String text)
   at Trade_Computer_Extension.Panel_DB_Stars.BTN_Add_Click(Object sender, EventArgs e) in C:\Users\Hellfire\Documents\Visual Studio 2010\Projects\Trade Computer Extension\Trade Computer Extension\Panel_DB_Stars.vb:line 221
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.Label.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)




************** Loaded Assemblies **************
mscorlib
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1063.1 built by: NETFXREL3STAGE
    CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
Trade Computer Extension MK.II
    Assembly Version: 1.0.0.0
    Win32 Version: 1.0.0.0
    CodeBase: file:///C:/TCE/Trade%20Computer%20Extension%20MK.II.exe
----------------------------------------
Microsoft.VisualBasic
    Assembly Version: 10.0.0.0
    Win32 Version: 14.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Runtime.Remoting
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
System.Configuration
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Data.SQLite
    Assembly Version: 1.0.99.0
    Win32 Version: 1.0.99.0
    CodeBase: file:///C:/TCE/System.Data.SQLite.DLL
----------------------------------------
System.Data
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Data/v4.0_4.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.Transactions/v4.0_4.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
System.EnterpriseServices
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_32/System.EnterpriseServices/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll
----------------------------------------
Accessibility
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Accessibility/v4.0_4.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
System.Numerics
    Assembly Version: 4.0.0.0
    Win32 Version: 4.6.1038.0 built by: NETFXREL2
    CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Numerics/v4.0_4.0.0.0__b77a5c561934e089/System.Numerics.dll
----------------------------------------


************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.


For example:


<configuration>
    <system.windows.forms jitDebugging="true" />
</configuration>


When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

MrJohnDC · Jan 26, 2016

mearmortal said:
I have a new station for you, simply called 'outpost'

View attachment 98538 View attachment 98539

I've noticed something similar to that. At some stations after getting docking permission it shows it as just Outpost, but if I check the left hand cockpit panel before asking for docking permission it will show what type of outpost it is. It usually seems to be a Civilian Outpost.