adccommunitymod (AutomationDirect) asked a question.

Edited September 16, 2020 at 10:42 PM
Productivity Data Logger Auto Export

Created Date: December 15,2016

Created By: FishFacs

**** 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.****

Hello, Can anyone suggest a way to automatically export the CSV files from the data logger on a productivity PLC to a network drive? Or even an FTP server? Doing it manually is getting tedious. Thanks FF

  • 7 answers
  • 653 views

  • adccommunitymod (AutomationDirect)

    Created Date: December 15,2016

    Created by: FishFacs

    Hello,

    Can anyone suggest a way to automatically export the CSV files from the data logger on a productivity PLC to a network drive? Or even an FTP server? Doing it manually is getting tedious.

    Thanks

    FF

  • REHJ (Customer)

    I have used advancedhmi before and recently... and I am sure you could do this if you know how to map to the SD card??? But that is the piece of the puzzel that I am missing??? ANY HELP ON THIS FROM ANYONE WOULD BE GREAT!! heapere@vytron.com if you can please!!!

  • Garry (Customer)

    Hi @REHJ (Customer)​ 

    Currently, the Productivity line of controllers does not have an FTP server. There are a few ways that this can be done.

    • Set up an Email from the PLC and email the file each day. You would then transfer the file to the server.

    Email and Text Communication – Video

    Google is removing “Less Secured Apps” in the mail app. (Gmail) If you are using this to send email from your controller, you must enable 2-step verification. This will then give you the option to generate an “App Password” for your controller or program.

    Gmail Less Secure App Access – App Passwords

    • Use a C-More EA9 HMI. Setup the logging and an FTP server on the screen. Have a batch file automatically transfer the file to your network at an interval you want.

    Data Logging – Video

    FTP (File Transfer Protocol) – Video

    • Use AdvancedHMI or Node-RED to get and file the information. I prefer putting the information into a database instead of separate flat files. This way you can then have multiple people reading and comparing the data.

    Modbus RTU / TCP Communication – Video

    Node-RED SQL Database Log – Video

    Node-RED SQL Database Spreadsheet Connection – Video

    Productivity PLC Node-RED MQTT – Video

     

    Additional Links for reference:

    https://accautomation.ca/series/productivity-1000-plc/

    https://accautomation.ca/series/c-more-hmi-series-panel/

    https://accautomation.ca/series/node-red-iot-enabling-software/

     

    I hope this helps you out.

    Regards,

    Garry

    ACC Automation

     

    Expand Post

    • REHJ (Customer)

      Thanks Garry for your response! You mention using AdvanceHMI and I would love to do that! That has been my plan as my plan in the end is to log all the info from ALL 11 production lines to one database. This would give us the instant ability to compare line stats and how well parts perform on each line given the variations we have... but how can I read these files has been my issue. What specifically I am needing is how to map to the SD card on the PLC? I know it can be done as they do this with the html software... so somehow there is a path structure I need to get there. Something like this... Public MyFileLocation As String = "\\192.168.81.173\MemCard\Logfile.csv"

      OR

      using the canned function of ModbusTCPCom2.Read("400021", 2) where the pointer to the IP address includes the path to the file or something I am not familiar with????

      If you can let me know how to get the file uploaded using this programming method that would be AWESOME!!!

      THANKS GARRY!!!

       

      Roy Heape!

      heapere@vytron.com

      Expand Post

 

Did this information resolve your issue?