So... i manage to add C# function to export decoded *STK file to *CSV file.

And imported in ms sql table...

File:

SQL:

Included *ZIP with stk decoder...

Ok will check if i can understand Script Component Source thing.

Ok then i should chek how to parse a text file (*STK) and save to .csv or XML or JSON. Then read those files and write info in DB.

Yes still struggle to sort this out.

I have made in C# *STK file decoder. It makes  table vien in windows form.

namespace STK
{

    public...

BULK INSERT is maybe the option? Found this sample code.

BULK INSERT dbo.personlist

FROM 'c:\source\personlist.csv'

WITH

(

FIRSTROW = 2,

FIELDTERMINATOR = ';',  --CSV field delimiter

ROWTERMINATOR = '\n',   --Use to shift the control to next row

TABLOCK,

CODEPAGE =...

Sample file what i try to read or import.

• This reply was modified 2 years, 8 months ago by  ManiaKsLV.

I am so sorry for my bad explanation cuz i am not a programmer.

This is what i got now:

This is result i looking for:

Tryed...

SELECT 
 PK_KART
,TIME
,LOG
,TEMP1.FNAME
,TEMP1.LNAME
FROM LOG_DB

LEFT JOIN TEMP1 ON (LOG_DB.LOG LIKE ( '%Receiver:' + CONVERT(nvarchar,TEMP1.ID)))
   
WHERE TIME between '2020-01-01' and '2022-03-01' and PK_KART = '7151'

ORDER BY TIME...

• This reply was modified 2 years, 9 months ago by  ManiaKsLV.