You are not registered yet. Please click here to register!


 
 
plc storereviewsdownloads
This board is for PLC Related Q&A ONLY. Please DON'T use it for advertising, etc.
 
Try our online PLC Simulator- FREE.  Click here now to try it.

---------->>>>>Get FREE PLC Programming Tips

New Here? Please read this important info!!!


Go Back   PLCS.net - Interactive Q & A > PLCS.net - Interactive Q & A > LIVE PLC Questions And Answers

PLC training tools sale

Reply
 
Thread Tools Display Modes
Old April 16th, 2015, 04:56 PM   #1
yrret0715
Member
United States

yrret0715 is offline
 
Join Date: Nov 2013
Location: Ohio
Posts: 11
FactoryTalk View SE data logging problems

Hi all,

I am a total beginner struggling to make modifications to other people's work, please forgive me if I could not describe my problem properly.

I have a FactoryTalk Historian running but just run out of available tags, so I would like to try logging through FactoryTalk View Studio - View Site Edition (Network Distributed). The ultimate goal is to have a time based data log in a excel sheet (first row = tag names, first column = time stamps) I tried following different documents and forum threads but ran into problems for all of them.


======
1. I tried following these:

http://www.plctalk.net/qanda/showthread.php?t=64250
http://www.scribd.com/doc/212048625/...-Manual#scribd (starting p98)

FT Administration Console->Tool->FT Diagnostics->Setup->Destination Setup->ODBC Database
(a) For data source, I tried both File Data Source and System Data Source
How do I determine which one I should use? No of these combined with the later options worked for me.
(b) For Driver, I tried Driver do Microsoft Excel, Microsoft Excel Driver (*.xls), Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb), and Microsoft Text Driver (*.txt, *.csv)
Since I don't have any idea what the Target Table should look like in each case, so I tried a little bit of everything.
For the first three drivers, I tried creating an excel sheet but ran into errors later in Data Log Models in FT View Studio as described in the thread of the first link (Column#n invalid)
For the last one, I tried following the thread but failed to understand what are the exact steps.

2.
Despite the problems above, when I tried to open the component under Data Log Models, nothing but an error message popped up:
FactoryTalk View Datalog Editor
The server 'test' in area 'RNA://$Global/test' is out of service

I thought the problem was similar to the one described in the follow thread:
http://www.plctalk.net/qanda/showthread.php?t=67424

I followed everything and rebooted the software and the computer a few time, but it did not work.

===========

I have run out of ideas now, and any related input will be greatly appreciated.
Thanks for going through such a long post!
  Reply With Quote
Old April 16th, 2015, 05:22 PM   #2
seth350
Member
United States

seth350 is offline
 
seth350's Avatar
 
Join Date: Jul 2011
Location: Over yonder
Posts: 237
Try this, it may not work for what you are wanting but it does offer datalogging to an excel .csv file that can either be local on the panelview, usb thumbdrive, or network drive.

http://theautomationblog.com/datasto...lk-viewstudio/
  Reply With Quote
Old April 17th, 2015, 08:45 AM   #3
yrret0715
Member
United States

yrret0715 is offline
 
Join Date: Nov 2013
Location: Ohio
Posts: 11
Huge thanks to seth350! The info totally saved my day.

I have a more updated version of FT View SE so a lot of the display tricks could be skipped.

The method worked almost perfectly for me except that the logging stops when I open the log file by Excel and resumes when I close it. I will keep trying to solve it, but any suggestion on avoiding the stoppage will be awesome. Thanks again everyone!

Quote:
Originally Posted by seth350 View Post
Try this, it may not work for what you are wanting but it does offer datalogging to an excel .csv file that can either be local on the panelview, usb thumbdrive, or network drive.

http://theautomationblog.com/datasto...lk-viewstudio/

Last edited by yrret0715; April 17th, 2015 at 08:47 AM.
  Reply With Quote
Old April 17th, 2015, 10:55 AM   #4
seth350
Member
United States

seth350 is offline
 
seth350's Avatar
 
Join Date: Jul 2011
Location: Over yonder
Posts: 237
When you need to open the file for viewing, copy the "logged-to" file and paste it somewhere else and then open the copied file.

I'm glad I could help you.
I use this same method for recording measurements in our waste water facility.
  Reply With Quote
Reply
Jump to Live PLC Question and Answer Forum

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Topics
Thread Thread Starter Forum Replies Last Post
Using FactoryTalk View SE for data logging blackdiamonz LIVE PLC Questions And Answers 9 August 19th, 2015 05:46 PM
Saving Graphs data to file (FactoryTalk View Studio SE) AutomationNewbie LIVE PLC Questions And Answers 0 September 18th, 2014 11:14 AM
Webcam in FactoryTalk View SE FactoryTalktotheHand LIVE PLC Questions And Answers 4 August 8th, 2014 10:30 AM
FactoryTalk View SE issue: upgrading AB/Rockwell is such a pain in (_!_) KuulKuum LIVE PLC Questions And Answers 1 August 4th, 2014 02:00 AM
FactoryTalk View SE 7.0 to FT View SE 5.10 Problems ebolbol LIVE PLC Questions And Answers 8 December 13th, 2013 10:59 AM


All times are GMT -5. The time now is 04:39 AM.


.