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.

New Here? Please read this important info!!!


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

Reply
 
Thread Tools Display Modes
Old December 1st, 2021, 04:07 PM   #1
PLCDontUQuitOnMe
Member
Canada

PLCDontUQuitOnMe is offline
 
Join Date: Jan 2008
Location: Ontario
Posts: 86
Panelview Plus 7 CSV export to USB stick

I am trying to export the alarm history on a Panelview Plus 7 to a USB stick. I cannot get it to write to the USB stick.


I have tried the following:



In FTView Studio, under CSV Export setup:


I have "Enable CSV Export" checked
Under "type" I have "alarm information" checked
Under "connection" I have my export trigger that I have checked that it is coming on and off when I press the pushbutton assigned to that tag.


Under Path, I have tried:
\Storage card2
\USB Storage\


When I tried it with the path set to \USB Storage\ and I went to the desktop of the panelview, there was a folder called \USB Storage\ in file explorer, but it appeared to be on the local disk, and not written to the USB.


I am assuming I do not have the correct path set up for this to work. Anyone have any ideas? I don't have any kind of techconnect contract so I'm hoping someone here can assist.
  Reply With Quote
Old December 1st, 2021, 04:28 PM   #2
sharkyh2o
Member
United States

sharkyh2o is offline
 
sharkyh2o's Avatar
 
Join Date: Dec 2013
Location: Snow Shoe
Posts: 118
I have never done a CSV export but to save a .mer file to usb external storage the path is Rockwell Software/RsViewME/Runtime.

if you plug in a new flash drive, wait a few minutes and the panelview will create the directory.
  Reply With Quote
Old December 1st, 2021, 04:33 PM   #3
Ken Moore
Lifetime Supporting Member
United States

Ken Moore is offline
 
Ken Moore's Avatar
 
Join Date: May 2004
Location: North, West, South Carolina
Posts: 3,228
It's not easy, and it's not a direct .csv export.

See this knowledge base article: Access everyone.

https://rockwellautomation.custhelp....ew/a_id/823751
__________________
Certified Siemens Functional Safety Professional,
ID: SFSP17010238
NRA Benefactor
  Reply With Quote
Old December 1st, 2021, 04:39 PM   #4
KuulKuum
Member
United States

KuulKuum is offline
 
Join Date: Jun 2006
Location: Texas
Posts: 297
You will want to check your FTV Studio "Startup" and see if a check mark "Alarms" in the Start when project is run is enabled.

In the CVS Export Setup in Path use for external USB drive: \USB storage
For external USB drive folder use example: \USB storage\CVSfolder
  Reply With Quote
Old December 1st, 2021, 04:57 PM   #5
PLCDontUQuitOnMe
Member
Canada

PLCDontUQuitOnMe is offline
 
Join Date: Jan 2008
Location: Ontario
Posts: 86
Quote:
Originally Posted by sharkyh2o View Post
I have never done a CSV export but to save a .mer file to usb external storage the path is Rockwell Software/RsViewME/Runtime.

if you plug in a new flash drive, wait a few minutes and the panelview will create the directory.

I am not seeing this, when I plug the USB stick into either of the two USB ports and look at file explorer on the panelview's desktop, I am not seeing anything change, no new directories created, nothing on the screen popping up showing it recognizes anything has been plugged in...


Quote:
Originally Posted by Ken Moore View Post
It's not easy, and it's not a direct .csv export.

See this knowledge base article: Access everyone.

https://rockwellautomation.custhelp....ew/a_id/823751

Thanks Ken, but I am confused when you say it's not a .csv export, the function I am trying to use in FTView studio V11 is called "CSV Export Setup" I would think that would export a CSV file? I can see the CSV files being created in the Panelview's file explorer, under whichever folder I specify in the CSV Export setup dialog under the "Path" field. However the folder that I specify is being created in the Panelview's memory and not being written to USB.



IE: if I specify the path as "\USB Storage", download the project, then click my new button which triggers the CSV Export, then go to the desktop of the panelview, in file explorer I see a new folder called "USB Storage" is created and the CSV files with the alarm history is in the folder. However I wanted it to write this CSV to the USB stick inserted into the back of the panelview. This is where I am stuck.


Quote:
Originally Posted by KuulKuum View Post
You will want to check your FTV Studio "Startup" and see if a check mark "Alarms" in the Start when project is run is enabled.

In the CVS Export Setup in Path use for external USB drive: \USB storage
For external USB drive folder use example: \USB storage\CVSfolder

I have checked this and under startup, Alarms is checked
  Reply With Quote
Old December 1st, 2021, 05:04 PM   #6
KuulKuum
Member
United States

KuulKuum is offline
 
Join Date: Jun 2006
Location: Texas
Posts: 297
Odd, maybe the PVP is not recognizing your USB drive. Try this, go to the configuration screen on the PVP and select the load option, then see if it will show External Storage 1 and External Storage 2. If these selections remain grayed out then the usb drive media is not recognized.
  Reply With Quote
Old December 1st, 2021, 05:08 PM   #7
sharkyh2o
Member
United States

sharkyh2o is offline
 
sharkyh2o's Avatar
 
Join Date: Dec 2013
Location: Snow Shoe
Posts: 118
Quote:
Originally Posted by KuulKuum View Post
Odd, maybe the PVP is not recognizing your USB drive. Try this, go to the configuration screen on the PVP and select the load option, then see if it will show External Storage 1 and External Storage 2. If these selections remain grayed out then the usb drive media is not recognized.



Yes, it has taken 5 or more minutes for some sticks on my end and a few were never recognized.
  Reply With Quote
Old December 1st, 2021, 05:23 PM   #8
PLCDontUQuitOnMe
Member
Canada

PLCDontUQuitOnMe is offline
 
Join Date: Jan 2008
Location: Ontario
Posts: 86
Ok, I figured it out. Before starting, I grabbed a new usb stick and it was formatted for "exfat" I had to reformat for "FAT32" and after that it worked. In the desktop it now shows the USB stick when I insert or remove and it displays it as a drive and not a folder in file explorer in the panelview's desktop.



It now exports a CSV file containing the alarm history to the inserted USB stick.


Just for future reference for anyone wondering, the directory of the two USB ports in the back are "\USB Storage2" and "\USB Storage3"
  Reply With Quote
Old December 1st, 2021, 08:47 PM   #9
tom_stalcup
Lifetime Supporting Member
United States

tom_stalcup is offline
 
tom_stalcup's Avatar
 
Join Date: Jan 2004
Location: fresno
Posts: 456
Quote:
Originally Posted by PLCDontUQuitOnMe View Post
Ok, I figured it out. Before starting, I grabbed a new usb stick and it was formatted for "exfat" I had to reformat for "FAT32" and after that it worked. In the desktop it now shows the USB stick when I insert or remove and it displays it as a drive and not a folder in file explorer in the panelview's desktop.



It now exports a CSV file containing the alarm history to the inserted USB stick.


Just for future reference for anyone wondering, the directory of the two USB ports in the back are "\USB Storage2" and "\USB Storage3"
Lol. Thanks for the update. I was scrolling down to the bottom post to ask about the format. Those type of things are why I carry this around with me.

Screenshot_20211201-164322_Gallery.jpg
Screenshot_20211201-164247_Gallery.jpg
__________________
"If beating your head against the wall doesn't work, try banging a little harder. It won't help you any, but at least I'll be amused"
  Reply With Quote
Old December 2nd, 2021, 09:23 AM   #10
PLCDontUQuitOnMe
Member
Canada

PLCDontUQuitOnMe is offline
 
Join Date: Jan 2008
Location: Ontario
Posts: 86
Quote:
Originally Posted by tom_stalcup View Post
Lol. Thanks for the update. I was scrolling down to the bottom post to ask about the format. Those type of things are why I carry this around with me.

Attachment 60222
Attachment 60223

Might not be a bad idea!
  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
Panelview Plus USB The Plc Kid LIVE PLC Questions And Answers 14 October 18th, 2018 03:45 AM
Panelview C600 USB port connection AA_Ron LIVE PLC Questions And Answers 4 March 16th, 2017 02:42 PM
Migrating FactoryTalk View Projects to Windows 7 64 bit Rob S. LIVE PLC Questions And Answers 27 November 29th, 2015 10:17 AM
PanelView Plus 6 loading runtimes via usb Patient LIVE PLC Questions And Answers 2 November 4th, 2013 06:56 PM
PanelView Component USB cable godfrey LIVE PLC Questions And Answers 2 September 10th, 2013 06:29 AM


All times are GMT -4. The time now is 12:32 AM.


.