 |
plc.myforum.ro
PLCs users www.plc.myforum.ro!
|
| View previous topic :: View next topic |
| Author |
Message |
khlid1144
Junior
Joined: 28 Mar 2018
Posts: 8
|
 Posted: 03/04/2018 15:22 Post subject: At FactoryTalk , transfer the trend to excel file |
 |
|
Hi all
I want to transfer the some trends to excel file at FactoryTalk , is it possible? if yes how can be done ?.
thanks |
|
| Back to top |
|
 |
fjs
Junior
Joined: 29 Mar 2018
Posts: 1
|
| Posted: 03/04/2018 17:14 Post subject: actoryTalk View SE Datalog files |
|
|
an answer from AB
The FactoryTalk View SE Datalog files, FactoryTalk View ME Datalog files, RecipePlus files and FactoryTalk View ME
Alarm Log file can be saved as .CSV or .DBF file formats.
Note: To read FactoryTalk View ME files from PanelView Plus CE or PanelView Plus terminals, copy the files to a
CompactFlash card or SD card and move them to the desktop where the FactoryTalk View File Viewer Utility resides.
These log files are in a non-standard format.
Note: With the File Viewer Utility, once the log file is open the file can be saved as a .CSV format file. You can only access the datalog files if they are closed, as a result you must stop a running FactoryTalk View Machine
Edition application or FactoryTalk View SE Datalog in order to be able to access the file.
The FactoryTalk View Enterprise File Viewer utility can be used to read and save the following files:
FactoryTalk View SE Datalog file (.DAT, .OBF formats)
FactoryTalk View SE HMI Tag Alarm file (.DAT format)
FactoryTalk View ME Datalog file (.LOG format)
FactoryTalk View ME Alarm Log file (HISTORY.ALM)
dBASE file (.DBF)
FactoryTalk View ME RecipePlus file (.RPP)
Syntax to convert to a .CSV List file:
| Code: | | RSView Enterprise File Viewer.exe /md process.log process.csv /tz8 |
Syntax to convert to a .CSV Table file:
| Code: | | RSView Enterprise File Viewer.exe /md process.log process.csv /tz8 /table |
Syntax to open a file when the Viewer is launched:
| Code: | | RSView Enterprise File Viewer.exe /sd datalog.dat |
The AppStart macro command can start the FactoryTalk Enterprise File Viewer utility.
However, to run and do a task in the background, the FactoryTalk Enterprise File Viewer utility requires command syntax.
For FactoryTalk View SE, the files chosen to open can use either command syntax /sd for a Datalog file or /dbf for a dBASE file.
If you don't specify a directory path, the file will be created in the same directory location where the FactoryTalk Enterprise File Viewer.exe utility is located.
However, Windows 7 or Server 2008 64-bit operating systems have enhanced default security settings for directory locations within such areas as C:\Program Files (x86)\ and C:\Windows\ and others.
There will be unexpected behavior if you place the FactoryTalk Enterprise File Viewer utility in these protected folder areas. A best practice would be to create and use specific "user" directory folder locations for any files that are to be generated.
To convert to a .CSV file using a button using Windows 7 or Windows Server 2008 Server 64 Bit operating system using AppStart a syntax example could be as follows:
| Code: | | AppStart “C:\Program Files (x86)\Rockwell Software\RSView Enterprise File Viewer.exe” /sd “C:\Users\Public\Documents\RSView Enterprise\SE\HMI Projects\Manning1303\DLGLOG\Run Report\2012 04 04 0000 (Float).dat” "C:\folder name\test.csv" |
https://rockwellautomation.custhelp.com/ci/fattach/get/1177722/0/filename/FTViewFileViewer_2.0.0.3.zip |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
Fa-ti si tu propriul forum GRATUIT, pe www.myforum.ro |
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
