[?]: Is it possible to data-logging in excel time-stamp?

[pmmdavid]

Hello all,

i would like to request samples and any support document from all senior engineer about time stamping in excel datalogging (read from Rs5k). is it possible to do that? i just read this forum topic (Reading data to Excel)and i follow their instruction and do it. i also can read rs5k data to excel sucesssful. thanks a lot and appreciate for this topic and forum moderator. so anybody can help us to data logging in excel with time stamping? thanks in advance,,,,,

with thanks and regards,

[D3V17]

Hi, yes it is possible.
You have to create a Dint tag (example My_Time_Stamp[7]) that is minimum 7 words long,
and then use the GSV (Get System Value) function to 'COPY' the WallClock DateTime value to the tag you created.
Check the instruction help section for specifics - I don't have RsLogix at home.
Also, the date and time in the PLC has to be the same as the real world, then you can just use the OPC stuff as you are already doing to read your tag values into excel.
Note, the 7 words are for Year, Month, Day, Hour, Minute, Second, Fractional Seconds.

Best of Luck.

Peace.

[dehell]

Hi,
It is more easy to use a data logger software.
Follow this link:
viewtopic.php?f=43&t=8594&p=33795&hilit ... ger#p33795
enjoy

[pmmdavid]

Hello dear,

thanks for your help and show me a way to do datalog, really appreciate for your time . but now when i use opc datalogger, i cann't see rslinx opc server driver in available opc driver list. i only can see exor opc server and simatic protool opc server. so how can i configure to see rslinx opc driver in progid views. please reply me. thanks in advance....

thanks a lot to all especially dehell

[dehell]

Hi,
You must use RSLinx PRO or Gateway. RSLinx lite don't working.
Regards