Read .dat file file

Forum Home Forums Understanding the Software Read .dat file file

This topic contains 12 replies, has 2 voices, and was last updated by Mikhail Mikhail 7 hours, 22 minutes ago.

Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • #5129

    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

    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

    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

    thohuynh1512
    Participant

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

    #5158

    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 1 week, 3 days ago by  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

    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,

    • This reply was modified 3 days, 17 hours ago by  thohuynh1512.
    • This reply was modified 3 days, 17 hours ago by  thohuynh1512.
    #5173

    thohuynh1512
    Participant

    Error in ScadaComm
    image1

    image2

    • This reply was modified 3 days, 17 hours ago by  thohuynh1512.
    #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

    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?

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic.