I'll try to translate. Dame information in the Russian-speaking community, I think it will help.
PS: sorry for my english
- Status
I'll try to translate. Dame information in the Russian-speaking community, I think it will help.
PS: sorry for my english
Translated what I can. Perhaps to help in the russian community. Unfortunately not good at English, so there may be errors, minor
Thanks for your offer, errors will be fixed by users, who using it. Please send the language.mdb file to eventure(at)ki.tng.de when finished. Again thank you for your help.
Is the personal logbook restricted to only being addon to TCE, or could it be developed as ships log, only? (edit -- my most favourite thing is, not so much the trade computer, but definitely your UI, it's great stuff)
It is integrated into TCE, thereafter you can't use it solely. I didn't have the time to make TCE compatible with OO, don't know, if it is possible.
Last edited:
TDM is compatible to all versions.
What happens, when you trying it with TDM? Did TDM not finding your database? Please check the manual, how to use it, or give me more details. Thanks
Last edited:
Fixed that; had misread how to pick up old database. Now getting a Debug code when I try and run the second page of commodity scanning at my first new station under 1.52:
Runtime error '9': Subscript out of range
Sub OCR_Process()
Dim fso As FileSystemObject, sLine As String, z As Long, instream As Object, ArOCR_Imp As Variant, OCR_Export As String, ZID As Long, a As Long, X As Long
Dim Ware_txt As String, t As Long, x1 As Long, ID As Long, temp As String, Sell As Double, Buy As Double, Stock As Double, lLZeile As Long, iLSpalte As Long, b As Long, Good_txt As String
ReDim ArOCR_Data(1 To AzGoods, 1 To 5)
Set fso = New FileSystemObject
AppPath = ActiveWorkbook.Path
OCR_Export = AppPath & "\OCR_Export\export.csv"
z = 0
Worksheets("Import_csv").Range("A1:A1001").ClearContents
If fso.FileExists(OCR_Export) = True Then
Worksheets("Import_Csv").Activate
With ActiveWorkbook.Sheets("Import_csv").QueryTables.Add(Connection:= _
"TEXT;" & OCR_Export, Destination:=Range("Import_csv!$A$1"))
.Name = "CAPTURE"
.FieldNames = True
.RowNumbers = False
.FillAdjacentFormulas = False
.PreserveFormatting = True
.RefreshOnFileOpen = False
.RefreshStyle = xlInsertDeleteCells
.SavePassword = False
.SaveData = True
.AdjustColumnWidth = True
.RefreshPeriod = 0
.TextFilePromptOnRefresh = False
.TextFilePlatform = 65001
.TextFileStartRow = 1
.TextFileParseType = xlDelimited
.TextFileTextQualifier = xlTextQualifierDoubleQuote
.TextFileConsecutiveDelimiter = False
.TextFileTabDelimiter = True
.TextFileSemicolonDelimiter = False
.TextFileCommaDelimiter = True
.TextFileSpaceDelimiter = False
.TextFileColumnDataTypes = Array(1)
.TextFileTrailingMinusNumbers = True
.Refresh BackgroundQuery:=False
End With
ActiveWorkbook.Connections("export").Delete
X = WorksheetFunction.CountIf(Worksheets("Import_csv").Range("A:A"), "<>")
ArOCR_Imp = Worksheets("Import_csv").Range("A1:A" & X)
t = 0
For a = 1 To X
ZID = Asc(ArOCR_Imp(a, 1))
If ZID = 9 Or ZID = 160 Or ZID = 32 Then
ArOCR_Imp(a, 1) = Replace(ArOCR_Imp(a, 1), Chr(ZID), "")
End If
If Left(ArOCR_Imp(a, 1), 15) = "<commodityconf=" Then
X = Len(ArOCR_Imp(a, 1))
Ware_txt = Mid(ArOCR_Imp(a, 1), 22, X - 22)
x1 = InStr(1, Ware_txt, "<")
If x1 <> 0 Then
Ware_txt = Left(Ware_txt, x1 - 1)
Else
Ware_txt = ""
End If
For b = 1 To AzGoods
Good_txt = Replace(Ar_DBGoods(b, 2), Chr(32), "")
If Good_txt = UCase(Ware_txt) Then
ZID = Asc(ArOCR_Imp(a + 1, 1))
If ZID = 9 Or ZID = 160 Or ZID = 32 Then
ArOCR_Imp(a + 1, 1) = Replace(ArOCR_Imp(a + 1, 1), Chr(ZID), "")
End If
temp = Mid(ArOCR_Imp(a + 1, 1), 17, 6)
x1 = InStr(1, temp, "<")
If x1 <> 0 Then
Sell = Val(Left(temp, x1 - 1))
Else
Sell = 0
End If
ZID = Asc(ArOCR_Imp(a + 2, 1))
If ZID = 9 Or ZID = 160 Or ZID = 32 Then
ArOCR_Imp(a + 2, 1) = Replace(ArOCR_Imp(a + 2, 1), Chr(ZID), "")
End If
temp = Mid(ArOCR_Imp(a + 2, 1), 16, 6)
x1 = InStr(1, temp, "<")
If x1 <> 0 Then
Buy = Val(Left(temp, x1 - 1))
Else
Buy = 0
End If
ZID = Asc(ArOCR_Imp(a + 5, 1))
If ZID = 9 Or ZID = 160 Or ZID = 32 Then
ArOCR_Imp(a + 5, 1) = Replace(ArOCR_Imp(a + 5, 1), Chr(ZID), "")
End If
temp = Mid(ArOCR_Imp(a + 5, 1), 19, 10)
x1 = InStr(1, temp, "<")
If x1 <> 0 Then
Stock = Val(Left(temp, x1 - 1))
Else
Stock = 0
End If
t = t + 1
ArOCR_Data(t, 1) = Ar_DBGoods(b, 1)
ArOCR_Data(t, 2) = Ar_DBGoods(b, 3)
ArOCR_Data(t, 4) = Sell
ArOCR_Data(t, 3) = Buy
ArOCR_Data(t, 5) = Stock
a = a + 8
Exit For
End If
Next b
End If
Next a
AzOCR_Data = t
Call Panel_Commodity.Show_Scan
For a = 1 To AzOCR_Data
Ar_TmpWares(ArOCR_Data(a, 1), 2) = ArOCR_Data(a, 4)
Ar_TmpWares(ArOCR_Data(a, 1), 3) = ArOCR_Data(a, 3)
Ar_TmpWares(ArOCR_Data(a, 1), 4) = ArOCR_Data(a, 5)
Hi Eventure
Love the new "Credit Accounting Session" now I can see what I'm spending and how much money I am making but you have a line for "Activities" with no entry box could you change that to "Missions" and put the entry box with the plus/minus so I record how much I/we are making there.
Oh and please update the ships list...
cheers...
Love the new "Credit Accounting Session" now I can see what I'm spending and how much money I am making but you have a line for "Activities" with no entry box could you change that to "Missions" and put the entry box with the plus/minus so I record how much I/we are making there.
Oh and please update the ships list...
cheers...
Thanks for the hint, changed the download link.
The Activities box is filled with your stored Activities for the session. So if you finishing a mission, open the Travel Logbook, select the entry, you have done the mission and select ACTIVITY at the bottom. Select further what mission you did and enter the profit out of it. Thereafter the profit is added to your Activities row.
That's the procedure.
Please tell me, which ships are missing?
Ups, yes, that is not okay, there must be a missing multiplier (-1) and 'Profit' should be changed to 'Loss' or 'Given'. Will check that later when I came home.
Last edited:
Hi
Thanks for telling me the correct way to fill the Activities box and as for the ships list
Federal Gun ship
Federal Assault Ship
These are the two not on my list and I'm running v1.52 beta 3.
thanks..
Full Version (1.53) released:
Changelog:
- Added Federal Gunship and Federal Assault Ship to the available ship types.
- Fixed an issue at the Activities area of the Personal Logbook not showing the full list of available wares, when selecting a mission type.
- Fixed an issue with Charity missions, adding a profit, but it should be a loss.
Note:
Please use the Transfer Database Manager (TDM) to make your database compatible with the actual version of TCE.
- Full-Version 1.53 installer: http://bit.ly/1PitkvZ
Changelog:
- Added Federal Gunship and Federal Assault Ship to the available ship types.
- Fixed an issue at the Activities area of the Personal Logbook not showing the full list of available wares, when selecting a mission type.
- Fixed an issue with Charity missions, adding a profit, but it should be a loss.
Note:
Please use the Transfer Database Manager (TDM) to make your database compatible with the actual version of TCE.
Last edited:
Hi Eventure,
Did the sorting of the 'Activites' panel get borked again?
Notice the first entry is the most recent which is correct, but then the rest run in reverse order.... but then the previous date I played is at the bottom (Had extra long shifts at work during the gap so no time ofr E: D :'( )
Eewec.
Did the sorting of the 'Activites' panel get borked again?
Notice the first entry is the most recent which is correct, but then the rest run in reverse order.... but then the previous date I played is at the bottom (Had extra long shifts at work during the gap so no time ofr E: D :'( )
Eewec.
Last edited:
Update (1.53.1) released:
Changelog:
- Fixed an issue at the Activities area of the Personal Logbook not sorting the entries correctly.
Note:
This update didn't need any TDM usage for your database. Copy the content into your TCE folder to update your version.
- Full-Version 1.53 installer: http://bit.ly/1PitkvZ
- Update 1.53.1: http://bit.ly/1Qakn65 (Full-Version 1.53 required)
Changelog:
- Fixed an issue at the Activities area of the Personal Logbook not sorting the entries correctly.
Note:
This update didn't need any TDM usage for your database. Copy the content into your TCE folder to update your version.
Last edited:
You're welcome.
There's no hack or anything involved, TCE is all about what you could achieve by yourself with pen and paper.
Enjoy, mate.
Hi Eventure
Just to be clear please, I want to add a High Intensity Extraction site to my Stored Locations.
So I go to the Logbook and highlight the nearest entry to that site - which may be a Star, an Inner System Sector Number or a Station - and then add my Note about the HI Extraction Site, click "Save" then click "Store Entry" and then "Extraction Site". If I now go to my Stored Locations I will see that site under Resource Extractions where I can add additional comments to your default Note if I wish.
Is this correct?
Thanks, Rob
Just to be clear please, I want to add a High Intensity Extraction site to my Stored Locations.
So I go to the Logbook and highlight the nearest entry to that site - which may be a Star, an Inner System Sector Number or a Station - and then add my Note about the HI Extraction Site, click "Save" then click "Store Entry" and then "Extraction Site". If I now go to my Stored Locations I will see that site under Resource Extractions where I can add additional comments to your default Note if I wish.
Is this correct?
Thanks, Rob
- Status