- This topic has 22 replies, 2 voices, and was last updated 5 years, 1 month ago by
.
-
Posts
-
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,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.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.
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.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.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.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.
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,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.
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
- You must be logged in to reply to this topic.