[thohuynh1512]

hi,
in Query tab, i don’t write any thing. So, it’s empty

[thohuynh1512]

Hi,
i didn’t config parameter in Communicator, so in Type of Communication channel, i have chosen Undefined. From Excel file connect with Communicator through SQL Server, i don’t know what I choose the following parameters:
– Address, Call number in Scada – Administrator
– Type of Communication channel in Scada – Communicator.
Data in Excel file is read from Meters by TCP/IP protocol.
The images display my configuration in Scada – Administrator and Communicator.
Scada-Administrator Configuration
Scada-Administrator Configuration1
Scada-Communication Configuration
Scada-Communication Configuration 1
Scada-Communication 2
Could you please help me?

• This reply was modified 6 years, 5 months ago by thohuynh1512.

[thohuynh1512]

Hi,
I’m done and it worked. Thank you very much.

• This reply was modified 6 years, 5 months ago by thohuynh1512.
• This reply was modified 6 years, 5 months ago by thohuynh1512.

[thohuynh1512]

Unfortunately, i don’t know how to refer that. Please help me. I looked over all of parameters, but i don’t know where to refer

[thohuynh1512]

Hi,
i include 2 images in Communicator, i don’t know i missed. But i think i set full request. Could you direct to me?
p1
p2

[thohuynh1512]

Hi,
the image display a screenshot of communication line log
error

[thohuynh1512]

Hi,
In existing channels, i have to take channel number which existed, don’t i?
Thanks,

[thohuynh1512]

Hi,
Error in Communicator.
h1

h2

[thohuynh1512]

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

[thohuynh1512]

Error in ScadaComm
image1

image2

• This reply was modified 6 years, 5 months ago by thohuynh1512.

[thohuynh1512]

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 6 years, 5 months ago by thohuynh1512.
• This reply was modified 6 years, 5 months ago by thohuynh1512.

[thohuynh1512]

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 6 years, 5 months ago by thohuynh1512.

[thohuynh1512]

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

[thohuynh1512]

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.

[thohuynh1512]

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.

[Author]

Posts