Csv file

mrkintaro

Member
M
Join Date
Sep 2009
Location
Trento
Posts
7
Hi,
Is it possible to read data from csv file and put the data in a table inside a page.
What that I need is if I change the csv with another application immediatly the table must be able to read the updated csv file.
Thank.
 
What is generating the csv file?

What is reading the csv file?

Brand, model, software, communication network??????

Need more info.
 
The file is generated by another software for the access monitoring of room. Wincc Explorer is the software thet need to read the csv file. The file is on the same pc of Wincc.
 
Ok, so you are saying:

"I want WinCC to monitor the .csv file for any change. When a change happens, perform an action." (action not defined yet)

Is that correct?

Unfortunately, I am not great with WinCC, but many people here are.
 
More or less,
I have a *.csv file where are stored any data, this file is modified from another application.
In Wincc I want something that be able to show what i have inside the file csv like a table.
So to have in wincc a table with the same data in the csv file, and if the csv file is changed in the same time the table upgrading itself in wincc with an action or event.
I hope everything is clear.
 
Yes, it is clear now.

You want WinCC to show a table.

The table will contain the data from the .csv file.

If the .csv file is changed, you want WinCC to automatically recognize the change and update the displayed table.

If no one drops in with an answer, I would repost the question with the title "Display .csv file in WinCC"
 
It can be done using scripting. You would need to write a script that executes periodically checking for a change to the file and then run a routine to extract the data from the .csv file. I've done this sort of thing before with text files. Have process 1 write the .CSV file to location A. Have WinCC look for this file periodically; when it is found, move the file to location B and read its contents into WinCC tags.

It might be posible to do it with DDE but I've never done it with WinCC.

Nick
 
Display .csv file in WinCC

Manglemender said:
It can be done using scripting. You would need to write a script that executes periodically checking for a change to the file and then run a routine to extract the data from the .csv file. I've done this sort of thing before with text files. Have process 1 write the .CSV file to location A. Have WinCC look for this file periodically; when it is found, move the file to location B and read its contents into WinCC tags.

It might be posible to do it with DDE but I've never done it with WinCC.

Nick
Click to expand...

Could you explain where can I find dde for wincc explorer, or aa guide?
 
There is a problem. the status of driver connection in runtime is disconnected.
Is a problem if I use office 2007 in Italian language?
I attach some immages to show the configuration....

1.jpg 2.jpg 3.jpg 4.jpg
 
Need Help on a similar issue

mrkintaro said:
Thx I resolved all my problems
Click to expand...

Dear mrkintaro,

I am facing the same issue, I have a CSV file of sensor's data that is being updated continuously by the data sent by sensor wirelessly, I want to show those sensor's readings or just the latest reading in WinCC. Is it possible? Could you please share your solution with me. I will be grateful for your help

Thanks

khyzer
 

Similar Topics

M
RSLogix 5 failed to ASCII import CSV file to database
I am trying to import addresses and symbols from a PanelBuilder32 application into the RSLogix 5 Address/Symbol database - however each time I...
Replies
5
Views
552
OkiePC
OkiePC
W
Red Lion HMI Displaying .csv File
Hi Everyone, I am hoping a Red Lion Expert can point me in the right direction. I am experimenting with data logging on a CR3000 10" screen...
Replies
4
Views
613
woolie161
W
P
Access Panelview CSV file from remote server
I am trying to copy a .csv file from a PanelView's SD card onto a a remote windows server. I understand that the panelview does not allow you to...
Replies
6
Views
2,184
celichi
celichi
R
Siemens WinCC - Counting rows of a .csv file
Been scratching my head at what I thought should be a relatively simple task. I need to count how many rows a .csv file has, so I can later read...
Replies
6
Views
2,560
L33er
L33er
F
Write CSV file
Hello! I have a question about a problem writing to a CSV file via twincat3. From the example code that beckhoff provides, I would like to be able...
Replies
0
Views
1,012
Frapp99
F
Back
Top Bottom