Abandoned [RELEASE] Trade Computer Extension

Status
Thread Closed: Not open for further replies.

Bragolatch

Bragolatch
When attempting to "update" the coordinates of a star already in the database,
I got error 3001

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


In TCE.mdb the entry for this systems looks like this:
IDStar Name:X-Coordinates:Y-Coordinates:Z-Coordinates:SOK:Note:
10510AC YANYAMAM-21.43827.843-127.875


Nothing I did afterward would get rid of this, the error kept popping up every time I click the DATABASE button,
and would come back after TCE and Computer restart.
Also started getting other errors and entering new stations would not save.

Re-installed TCE from scratch. (deleted everything but EliteOcr, installed beta 1 and beta 8 update.)
TCE starts normally but as soon as I click on the DATABASE button I get error 3001 again !
3001.jpg

I actually get this error again sometimes, when jumping from one system to another or
when clicking on the database button once I am in a new station that is not in my database yet.

I just click ok and it goes away, but otherwise, everything else seems to work fine now !
 
Last edited:

Bragolatch

Bragolatch
Ocr Scan tweak

A small feature that should be easy enough to implement.

once START OCR SCAN has been pressed, it could turn to Please Wait as it already does and also turn red
then once the picture has been taken, turn yellow or orange (a different shade from the normal UI)
then back to START OCR SCAN and green once it has added the data and is ready to scan again.

That way we could move the commodity list down to the next position
after the pic was taken while TCE is adding the data (yellow/orange state) and save a few micro seconds lol
 
Last edited:

Bragolatch

Bragolatch
3021

Just received a new error when trying to save scanned commodities for the first time in a station I have just added.
(was not in the unregistered list)

3021.jpg

Had to close because the error kept coming back.
on TCE restart I not get Error 9



Dim Station_ID_S As Long, Station_ID_Z As Long, ArProfit As Variant, b As Long, c As Long, lLZeile As Long, A As Long, Y As Long, ArMaxPrice(1 To 10000) As Long
Dim ArStations As Variant, ArCopy As Variant, x As Long

Call Add_Stations
Worksheets("Pre_Select").Range("Y2:Y1001").ClearContents
'Systemname schreiben
Station_ID_S = Worksheets("Werte").Cells(3, 2).Value
For Y = 1 To Worksheets("Werte").Cells(79, 8).Value
DoEvents
ReDim ArProfit(AzGoods)
Station_ID_Z = Worksheets("Pre_Select").Cells(1 + Y, 18).Value
For c = 3 To AzGoods + 2
DoEvents
If ArData_Buy(c, Station_ID_S + 2) <> 0 And ArData_Buy(c, Station_ID_S + 2) <> "" And ArData_Sell(c, Station_ID_Z + 2) <> 0 And ArData_Sell(c, Station_ID_Z + 2) <> "" And ArData_Sell(c, Station_ID_Z + 2) - ArData_Buy(c, Station_ID_S + 2) > 0 Then
ArProfit(c - 2) = ArData_Sell(c, Station_ID_Z + 2) - ArData_Buy(c, Station_ID_S + 2)
End If
Next c
ArMaxPrice(Y) = WorksheetFunction.Max(ArProfit)
Erase ArProfit
Next Y
With Application.WorksheetFunction
Worksheets("Pre_Select").Range("Y2:Y" & Worksheets("Werte").Cells(40, 2).Value + 1) = .Transpose(ArMaxPrice)
End With
Worksheets("Systems").Activate
Worksheets("Systems").Range("L2:V20001").ClearContents
Worksheets("Systems").Range("L2:V" & Worksheets("Werte").Cells(40, 2).Value + 1).Value = Worksheets("Pre_Select").Range("P2:Z" & Worksheets("Werte").Cells(40, 2).Value + 1).Value
Call Add_Stations_UR
ActiveWorkbook.Worksheets("Systems").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Systems").Sort.SortFields.Add Key:=Range( _
"U2:U20001"), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:= _
xlSortNormal
With ActiveWorkbook.Worksheets("Systems").Sort
.SetRange Range("L1:V20001")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With


Can't get rid of that one, I can't find the last station I added in the mdb.
I think TCE might have marked the system as having a station but not saved the station.

I tried to replace TCE.mdb with either of the 2 backup I have.
One dated today and one from yesterday.
I get the same error with both !

I guess I'll just have to start again from scratch lol

I've zipped my non working version, I'll send it if you need it for analysis.

After re-installing everyting, shortly after the overlay showed up I got that previously mentioned (post #932) error 3001.
But again, everyting keeps working if I just keep going.
If I exit and start TCE again, everything seems ok.

Tried to add that star system again because the STAR SYSTEM window poped up and asked me to, and got :

-2147417848
Method 'Fields' of object'_Recordset' failed

AC YANYAMAM.jpg
Followed by the loggin window incryptx was talking about:
LOGGIN.jpg

and when you press Cancel

-2147417848
Cancelled


Now back in and the system is in there lol
 
Last edited:

punkerich

punkerich
Bragolatch said:
A small feature that should be easy enough to implement.

once START OCR SCAN has been pressed, it could turn to Please Wait as it already does and also turn red
then once the picture has been taken, turn yellow or orange (a different shade from the normal UI)
then back to START OCR SCAN and green once it has added the data and is ready to scan again.

That way we could move the commodity list down to the next position
after the pic was taken while TCE is adding the data (yellow/orange state) and save a few micro seconds lol
Click to expand...

i strongly support this.:)
 

Bragolatch

Bragolatch
incryptx said:
Thanks, but...its running with data updating and pausing. I had to reduce the zoom on all windows to 70% (with values of 65 and 78 for positions) but it's all on one screen now, with a size I can read. When trying to shut it down though, I was a bit confused as to whether I should save the tce.xlsm as it updated data. I decided to try to save it and now it won't open again with problems like "locked by another user" and giving me a .mdb login, wanting username, password and some user string or something. I did not mess with the database, or lock it in any way.
Click to expand...

You should take a look at :Yokai's guide to Trade Computer Extension (TCE) by Eventure

https://forums.frontier.co.uk/showthread.php?t=119873&p=1861206#post1861206

It would have answered that question about saving TCE.xlsm or NOT, and many more !

You can replace TCE.xlsm with the one from the latest update to fix this problem.

none of the data you've entered is saved in there, it's all in the mdb's !
 
Last edited:

Nionor

Nionor
Eventure I saw that someone else asked for the option to change color and I did a quick little change in your code to make it work.

DISCLAIMER! If anyone changes the code like below or in any other way, do complain to Eventure about it if it breaks!

In the Setup module I added the following
Code: 
Public Const MyColor As Long = 16689744 'RGB(80, 170, 254)

Sub ChangeColor(panel)
    Dim ctrl As Control
    For Each ctrl In panel.Controls
        If TypeName(ctrl) = "Label" Or TypeName(ctrl) = "Frame" Then
            If ctrl.BorderColor = 33023 Then
                ctrl.BorderColor = MyColor
            End If
            If ctrl.BackColor = 33023 Then
                ctrl.BackColor = MyColor
            End If
            If ctrl.ForeColor = 33023 Then
                ctrl.ForeColor = MyColor
            End If
        End If
    Next ctrl

End Sub

And then I just called it in all the UserForm_Initialize()
This actually change 80% of the colors, to fix the rest I just did a find&replace on the hard coded color &H80FF& to MyColor

Just thought I share that and maybe it will help in some way.
My TCE is a nice cool blue now ;)
 

Yokai

Yokai
My guide for TCE is now fully completed. It's a monster, but there is a TON of juicy detail, tips, and strategies for using TCE. See the yellow link in my sig block below.

Thanks again, Eventure, for creating such an awesomely immersive and useful tool. I'll be throwing some "donate" cash your way soon (and I recommend everyone else should do so too, lol.)

Spread the word: people should know about TCE!
 

CroBar

CroBar
Bragolatch said:
When attempting to "update" the coordinates of a star already in the database,
I got error 3001

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


In TCE.mdb the entry for this systems looks like this:
IDStar Name:X-Coordinates:Y-Coordinates:Z-Coordinates:SOK:Note:
10510AC YANYAMAM-21.43827.843-127.875


Nothing I did afterward would get rid of this, the error kept popping up every time I click the DATABASE button,
and would come back after TCE and Computer restart.
Also started getting other errors and entering new stations would not save.

Re-installed TCE from scratch. (deleted everything but EliteOcr, installed beta 1 and beta 8 update.)
TCE starts normally but as soon as I click on the DATABASE button I get error 3001 again !
View attachment 17828

I actually get this error again sometimes, when jumping from one system to another or
when clicking on the database button once I am in a new station that is not in my database yet.

I just click ok and it goes away, but otherwise, everything else seems to work fine now !
Click to expand...

I also keep getting Error 3001 "Arguments of the wrong type, are out of acceptable range, or are in conflict with one another."
I can't seem to find a solution to this. I have current office 365 (not the trial), my directories are correct, The folder with elitedangerous32.exe is where the appconfig directory is set, and the logs folder is where the netlogs is set.
I am running TCE V1.36beta1 with the v1.36beta8 update xlsm from the OP.
Please advise
 

Bragolatch

Bragolatch
Just had a 4 hours run, doing a bit of everything with TCE running.
Added a couple of start system
and 7 or 8 stations with their commodities.

No errors, no problems ! :)


Maybe something to add to the manual,

After scanning, when you click save and the TRADE INFORMATION opens up.
if it doesn't show the commodities that you just added,
open the commodity panel again, click any of the comodities so that save shows up again and save until Trade info does show what you have scanned.

I think it is what caused my last big crash. not saving again. Not sure, wasn't really paying attention to this at the time.
 

Yokai

Yokai
Bragolatch said:
Just had a 4 hours run, doing a bit of everything with TCE running.
Added a couple of start system
and 7 or 8 stations with their commodities.

No errors, no problems ! :)


Maybe something to add to the manual,

After scanning, when you click save and the TRADE INFORMATION opens up.
if it doesn't show the commodities that you just added,
open the commodity panel again, click any of the comodities so that save shows up again and save until Trade info does show what you have scanned.

I think it is what caused my last big crash. not saving again. Not sure, wasn't really paying attention to this at the time.
Click to expand...


I'll add this tip to the guide soon.
 

eventure

eventure
Hello everybody,

today i am really busy, so no update today. With the last update i found many things to optimize and fix.
 

Nionor

Nionor
Was trying 1.36beta and started from a clean dir, added beta8 and loaded up.
This shows up every time I try to import an old db.
1004.png
It repeat itself 4 times and then it goes away, no crash just wont import.

I'm on Win7 64bit with Excel 2010.
 
Last edited:

th03bgt

th03bgt
I've donned my safari gear and now I'm one week into a month long trip across the milky way.

So no trading but following this thread closely and look forward to firing up version 4.3 when I get back.

Thanks for your hard work.
 

Yokai

Yokai
Bragolatch said:
When attempting to "update" the coordinates of a star already in the database,
I got error 3001

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.


In TCE.mdb the entry for this systems looks like this:
IDStar Name:X-Coordinates:Y-Coordinates:Z-Coordinates:SOK:Note:
10510AC YANYAMAM-21.43827.843-127.875


Nothing I did afterward would get rid of this, the error kept popping up every time I click the DATABASE button,
and would come back after TCE and Computer restart.
Also started getting other errors and entering new stations would not save.

Re-installed TCE from scratch. (deleted everything but EliteOcr, installed beta 1 and beta 8 update.)
TCE starts normally but as soon as I click on the DATABASE button I get error 3001 again !
View attachment 17828

I actually get this error again sometimes, when jumping from one system to another or
when clicking on the database button once I am in a new station that is not in my database yet.

I just click ok and it goes away, but otherwise, everything else seems to work fine now !
Click to expand...

BETA 8 is severely broken. I get the same "Arguments are of the wrong type..." message in nearly every new system I jump into. It got so bad I had to reinstall Beta 6, which works fine in every way (except for the DB import stuff, of course).
 

eventure

eventure
Yokai said:
BETA 8 is severely broken. I get the same "Arguments are of the wrong type..." message in nearly every new system I jump into. It got so bad I had to reinstall Beta 6, which works fine in every way (except for the DB import stuff, of course).
Click to expand...

Yeah, through the change of Star System saves, other routines are affected. Next update (hopefully tommorow) will fix this. Have to test it first, prior release.
 

dave562

D
Excel Error 3001 when opening DATABASE

Running version 1.36beta8

Issue exists with both new, clean TCE.mdb database and also from a clean database with pre-1.36 data imported. (Very nice import utility by the way.)

Program stays open.

Program continues to accept input and update.

Can you provide extended logging for Error 3001?

Can you tell me which Arguments / Functions to look into so that I can try to resolve it myself? (see attached screen shot)

TCE - Database 3001 Error.png
 

Bragolatch

Bragolatch
There is another feature that I had never noticed before Beta 6
(probably because I couldn't keep TCE working long enough)
That's been REALLY bugging me lately !

I use mouse and keyboard,
my mouse is setup for YAW and PITCH

When I get in combat or even just flying around and move my mouse up (YAW UP),
after a certain point I still see ED's cursor in the middle of the screen,
but I also see windows cursor popping up on TCE's Trade button. (center of main menu)

Even if I hide the panels, the same thing happens but the second mouse cursor now appears right on TCE's CONTROL button.

I almost crashed on stations a few times because of this,
not to mention all the beams and bullets I might have avoided or delivered if I had not lost control of my ship in the middle of a fight
because pressing any button when this happens places ED in the background and you need to realize what is happening,
then regain control by moving the cursor and clicking ED or use Alt-tab to get back in it.


Would it be possible to have the option of setting a modifier key that would switch the focus (make the windows mouse appear)

or at least, not have the mouse go to CONTROL when the panels are hidden.

I know it is part of windows mouse control scheme, but there must be a way around it !

Please ! :eek:
 
Last edited:

Bragolatch

Bragolatch
dave562 said:
Running version 1.36beta8

Issue exists with both new, clean TCE.mdb database and also from a clean database with pre-1.36 data imported. (Very nice import utility by the way.)

Program stays open.

Program continues to accept input and update.

Can you provide extended logging for Error 3001?

Can you tell me which Arguments / Functions to look into so that I can try to resolve it myself? (see attached screen shot)
Click to expand...


No biggie, but if you didn't see,

We all have this or at least many of us do with this version
and Eventure is aware and working on it as stated in previous post.
 
Status
Thread Closed: Not open for further replies.
Back
Top Bottom