Read .dat file file

Forum Home Forums Understanding the Software Read .dat file file

This topic contains 22 replies, has 2 voices, and was last updated by Mikhail Mikhail 3 months, 2 weeks ago.

Viewing 15 posts - 1 through 15 (of 23 total)
  • Author
    Posts
  • #5129
    Avatar
    thohuynh1512
    Participant

    Hi,
    i wanna convert data from excel files to database in RapidScada. I think i have 2 chooses
    1. I convert from excel files to .dat file and save in ArchiveDAT. I tried to read .dat file by anyway, but i can’t.
    2. I edit your sourcode, but i don’t know how to do start.
    Could you please give me a way to resolve my problem.
    Thank you,

    #5130
    Avatar
    thohuynh1512
    Participant

    Could you tell me about anything?
    1. When you read data from physical device, the beginning data has it been saved in .dat file or .sql file or both?
    2. Where does TableEditor take data to display in web? Because i want to change a huge data into TableEditor, i don’t know .dat file’s format to implement my project.
    Thanks a lot.

    #5136
    Mikhail
    Mikhail
    Moderator

    Hi,

    You should not write to DAT files directly. You should develop a driver for Communicator that reads Excel file. Example of the driver is here.

    1. When you read data from physical device, the beginning data has it been saved in .dat file or .sql file or both?

    SCADA-Server saves to DAT.

    2. Where does TableEditor take data to display in web? Because i want to change a huge data into TableEditor, i don’t know .dat file’s format to implement my project.

    Table editor creates table views in XML format. The web application takes data from SCADA-Server to display them. Ready to use classes that work with DAT are here.

    #5137
    Mikhail
    Mikhail
    Moderator
    #5156
    Avatar
    thohuynh1512
    Participant

    Thank you a lot!
    Could you show me direction about my issue? i read data from excel file and save it to DB of SQL, don’t i? I can read but i don’t know how to save it to where. Please help me.

    #5157
    Avatar
    thohuynh1512
    Participant

    If i save it DB of SQL, is the data in .dat file updated?

    #5158
    Avatar
    thohuynh1512
    Participant

    I think i need to know format of data, Excel has plenty of information so that i have select data which is usage.
    When i have selected yet, i have to know the data i convert to where and what is format in that place to synchronize between data has read from excel and data is used in RapidScada.
    I have been wondering data’s format, that i need create, is the same as the table file You included.
    I have a lot of questions, i was hoping you could help me. Thanks a lot.

    • This reply was modified 4 months, 1 week ago by Avatar thohuynh1512.
    #5164
    Mikhail
    Mikhail
    Moderator

    Hello,
    As I know it’s possible to connect to Excel like it is a database. I didn’t try it. If you can do this, then you can read data by KpDbImport driver.

    #5170
    Avatar
    thohuynh1512
    Participant

    Hi Mikhai,
    After receiving your answer, i read source code, i don’t understand much.
    I try to connect but the connection is failed.
    I could ask you some questions?
    Maybe i will config some options in Microsoft SQL Server Management Studio, after that, i will connect database i have just created to ScadaComm. All steps is below:
    1. in Authentication option, i choose Windows Authentication, so i think Password of this field is my computer.
    Image1

    2. After create database successfully with name is ExcelImport, i connect from SQL Server to ScadaComm as below images.
    image2

    At first, i config in ScadaAdmin as below image.
    Image3

    Finally, i config in ScadaComm
    Image4

    Image5

    After that, all failed. I was wondering i did the wrong steps. Could you tell me how to fix this problem.
    Thanks so much,

    #5173
    Avatar
    thohuynh1512
    Participant

    Error in ScadaComm
    image1

    image2

    #5175
    Mikhail
    Mikhail
    Moderator

    Hi,

    Thanks for the detailed description.

    in Authentication option, i choose Windows Authentication, so i think Password of this field is my computer.

    Windows Authentication is when you specify no password. Select an option with a password.

    #5179
    Avatar
    thohuynh1512
    Participant

    Hi,
    i created a user with password, i imported data to Sql server successfully. But when i connect sql server with ScadaComm, i have a problem: My excel data only include a data type, when connect with ScadaComm, i think ScadaComm doesn’t understand data from sql server, data in sql server doesn’t contain input channel.
    Follow images which you can know my issue
    h1

    h2

    h3

    #5180
    Mikhail
    Mikhail
    Moderator

    Hi,

    What is shown in Communicator?

    #5182
    Avatar
    thohuynh1512
    Participant

    Hi,
    Error in Communicator.
    h1

    h2

    #5183
    Mikhail
    Mikhail
    Moderator

    Hi,
    Please make a screenshot of communication line log too.

Viewing 15 posts - 1 through 15 (of 23 total)

You must be logged in to reply to this topic.