adccommunitymod (AutomationDirect) asked a question.
Created Date: April 01,2012
Created By: alt
**** This post has been imported from our legacy forum. Information in this post may be outdated and links contained in the post may no longer work.****
Dear All, I have requirement of data logging and printing to prepare the invoice for the process data from the Cmore or koyo plc or atleast a excel sheet of the data to log it and print.I have dl-260 cpu and c-more(EA7-T6CL).in my application i need to store the process data like total flow to make invoice for the customer.I have made data logging in cmore to USB ,but it is coming in txt file not in excel and the whole data is coming in different text files.I need to have format in which data to be stored in excel file and get the printout when ever required.Please provide me the information which i am looking for, with hardware i have mentioned either c-more data logging or DL-260 cpu (if possible).Waiting for the positive reply. Thanks
Created Date: April 02,2012
Created by: ljbeng
We have a data logger for SD card or USB flash drive. Both loggers also saves as .txt files, comma delimited but I could easily custom modify to make the extension .CSV for you. .XLS may be a proprietary file format. CSV files open easily in Excel. Our logger logs to one file continuously even over many days.
www.ljbeng.com
Created Date: April 02,2012
Created by: alt
Can it log the data in fixed format or everything will be stored in a file randomley.Can you provide the more details of the data loggers or where to buy and which brand.What i exactly need is data logging in fixed format to give it to customer for invoice and get the print whenever required .
Created Date: April 02,2012
Created by: ljbeng
If the device is used with direct net or modbus, the device polls the plc for v-memory data and stores a new line of text, comma spaced, and appends that line to the file. The file will look like this with the header information on the top 2 lines and the polled data on the 3rd,4th lines. This will log every 20s.
0020
V02000:B,V02001:B,DATE,TIME
0023,0024,04/02/12,06:41:00
0147,1288,04/02/12,06:41:20
You can also log by serial print. In this mode, you may print whatever text out the serial port and the DF3 will recognize certain patterns in the text to know you want to write this data to the USB or SD card. In this mode, you can name the file anything with the 8.3 format (8-character naming). So if you want to write to one file named Invoice1.CSV You would send this string out the serial port with a PRINT or ASCII OUT command.
W$RInvoice1.CSV$R
THIS IS A SERIAL PRINT FILE
WRITTEN FROM MY PLC
001% 444 555
PARAMETER 1 = 23.1145
END OF FILE
$R.$R
Then you could also do this with the DF3USB logger or the DFII.
Created Date: April 06,2012
Created by: kasky
Open the files as "TAB Delimited " in Excel.
Created Date: April 01,2012
Created by: alt
Dear All,
I have requirement of data logging and printing to prepare the invoice for the process data from the Cmore or koyo plc or atleast a excel sheet of the data to log it and print.I have dl-260 cpu and c-more(EA7-T6CL).in my application i need to store the process data like total flow to make invoice for the customer.I have made data logging in cmore to USB ,but it is coming in txt file not in excel and the whole data is coming in different text files.I need to have format in which data to be stored in excel file and get the printout when ever required.Please provide me the information which i am looking for, with hardware i have mentioned either c-more data logging or DL-260 cpu (if possible).Waiting for the positive reply.
Thanks