Forum Home › Forums › Understanding the Software › Read .dat file file
- This topic has 22 replies, 2 voices, and was last updated 5 years ago by Mikhail.
-
AuthorPosts
-
March 6, 2019 at 7:11 am #5129thohuynh1512Participant
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,March 6, 2019 at 9:10 am #5130thohuynh1512ParticipantCould 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.March 6, 2019 at 3:19 pm #5136MikhailModeratorHi,
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.
March 6, 2019 at 3:20 pm #5137MikhailModeratorMarch 9, 2019 at 6:09 am #5156thohuynh1512ParticipantThank 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.March 9, 2019 at 6:11 am #5157thohuynh1512ParticipantIf i save it DB of SQL, is the data in .dat file updated?
March 9, 2019 at 7:20 am #5158thohuynh1512ParticipantI 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 5 years, 1 month ago by thohuynh1512.
March 11, 2019 at 6:15 am #5164MikhailModeratorHello,
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.March 16, 2019 at 4:18 am #5170thohuynh1512ParticipantHi 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.
Image12. After create database successfully with name is ExcelImport, i connect from SQL Server to ScadaComm as below images.
image2At first, i config in ScadaAdmin as below image.
Image3Finally, i config in ScadaComm
Image4After 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 5 years, 1 month ago by thohuynh1512.
- This reply was modified 5 years, 1 month ago by thohuynh1512.
March 16, 2019 at 4:28 am #5173thohuynh1512ParticipantMarch 17, 2019 at 5:46 am #5175MikhailModeratorHi,
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.
March 19, 2019 at 9:55 am #5179thohuynh1512ParticipantHi,
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
h1March 19, 2019 at 2:14 pm #5180MikhailModeratorHi,
What is shown in Communicator?
March 22, 2019 at 2:21 pm #5182thohuynh1512ParticipantMarch 22, 2019 at 2:34 pm #5183MikhailModeratorHi,
Please make a screenshot of communication line log too. -
AuthorPosts
- You must be logged in to reply to this topic.