melvin Posted June 20, 2011 Report Posted June 20, 2011 Hi All, Would like to check if anyone have tried using a NS series HMI with build-in ethernet port to grap data from a PC which has a .csv file and display it onto the HMI. Scenario: 1) KM50(Power Meter) keeps updating a .csv file every 5 mins which was created on the PC its power consumption value. 2) Touch screen goes to this file directory created on the PC via ethernet port to display its instance value, real time from the csv file. Can this be done? Tried using data block table but it could only display value which it have already been created and not updating it every 5 mins or so. Thanks for the advise. Regards Melvin
lostcontrol Posted June 22, 2011 Report Posted June 22, 2011 The only way I can think of that this may be possible, is to copy the file to the NS using ftp & then read that file. The problem with this method, is that the NS can only read/write binary files to the CF using this method. I am not sure of how one would convert a csv file to binary format for the NS, but would think there may be a way.... The DataLog tool can read/write csv files, but this is not what you want. So, one has to ask, what are you trying to do? If all it is is displaying the latest kwh value, then there would be other methods that are more standard & easier to implement. 1. Is there a PLC that the NS can connect to? 2. Can the PC write the data to the PLC? 3. Why not just do it in PLC & let the NS read the data from the PLC direct?
melvin Posted June 24, 2011 Author Report Posted June 24, 2011 Well, no PLC is connected to the NS. Have downloaded "Filezilla" and upload files via FTP, was successful to display on NS, but NS data block only allow 12 characters (8+3 format) whereby the KM50 output file is 10 character and KM50 output is unable to change its file naming convention hence using CX-Supervisor to write a script to update another excel file which the Data Block Table could read so when every there is an update on the KM50 file, it will pop over. Now the problem is it would not overwrite the existing file in the NS memory to the latest .csv file. Is there a function to this? Thanks for the advise.~ Attached pic on the left side denotes PC file whereby the right denotes NS memory files.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now