際際滷

際際滷Share a Scribd company logo

Proficy machine edition logging

Download as PPT, PDF
I
Iamtubalcain

The document provides instructions for connecting to an MS Access database and logging data to a table within it from a script. It involves: 1) Creating a system DSN in Control Panel to connect to an Access file using the MS Access driver. 2) Creating a script to connect to the DSN and log data periodically. 3) Creating another script to start MS Access, open the database file, and check that data is logging correctly to the table. 4) Running the scripts by clicking buttons on the runtime interface.

1 of 22
Downloaded 20 times
In Control Panel Select Admin Tools
Select Data Sources
ADD new system DSN
We will use the MS Access Driver
Enter a DSN eg: MyLog and then selectCreate Keep a note of the Data Source Name you use as you will need to use this exact name to connect through your scripting
Enter a filename you will need to remember this to use it in your Start MS Access script and also to configure the Table within it.
油
Create this script. Run it on condtion and when true by placing a button on the screen which has touch animation with an internal variable eg:ODBC, which is set as momentary you will be able to connect to your data source MyLog
This scripts logs data through the connected DSN The syntax must be correct. Try one variable first just to get it working Run Periodically at 1000mS
This disconnects from the DSN
Create this script. Run it on condtion and when true by placing a button on the screen which has touch animation with an internal variable eg:access, which is set as momentary you will be able to start MS Access The Path to MSAccess.exe must be as written in your script which may differ from above
Dont forget to download the Project
Open the database file you created eg Myaccessfile.mdb Doubleclick on the column headers to change them to match your logging script
Click SAVE
油
Accept ,YES
Select Table1 as per you logging script to check the table is ok
Close MS Access
Start runtime and click on your button to run the connect script
油
Click on your button to run the MSaccess script
You should have logged data

More Related Content

Proficy machine edition logging

  • 1. In Control Panel Select Admin Tools
  • 4. We will use the MS Access Driver
  • 5. Enter a DSN eg: MyLog and then selectCreate Keep a note of the Data Source Name you use as you will need to use this exact name to connect through your scripting
  • 6. Enter a filename you will need to remember this to use it in your Start MS Access script and also to configure the Table within it.
  • 7. 油
  • 8. Create this script. Run it on condtion and when true by placing a button on the screen which has touch animation with an internal variable eg:ODBC, which is set as momentary you will be able to connect to your data source MyLog
  • 9. This scripts logs data through the connected DSN The syntax must be correct. Try one variable first just to get it working Run Periodically at 1000mS
  • 11. Create this script. Run it on condtion and when true by placing a button on the screen which has touch animation with an internal variable eg:access, which is set as momentary you will be able to start MS Access The Path to MSAccess.exe must be as written in your script which may differ from above
  • 12. Dont forget to download the Project
  • 13. Open the database file you created eg Myaccessfile.mdb Doubleclick on the column headers to change them to match your logging script
  • 15. 油
  • 17. Select Table1 as per you logging script to check the table is ok
  • 19. Start runtime and click on your button to run the connect script
  • 20. 油
  • 21. Click on your button to run the MSaccess script
  • 22. You should have logged data

Editor's Notes

  1. Select: Start---settings---control panel---administrative tools
  2. Select Data sources (ODBC)
  3. We need to add our own DSN Data Source Name
  4. Now we need to to specify the driver that will be used to obtain the data from the source and pass it to the database
  5. Now specify the DSN and select Create. I have called it MyLog and have put in a description in case I need to create some more connections
  6. This will bring up an input box where we will name the database file myaccessfile is this one click ok
  7. We get confirmation that we now have an MS Access database file that will be supplied with data through our connection (DSN) MYlog
  8. The way in which we get data from our project to the MS Access database is to use a script command dbconnect which connects to the ODBC source (MyLog). Select how the script runs, here its on condition that the bool variable ODBC comes on momentarily
  9. You can only call SQL commands after having a connection. Here dbSQL INSERT into puts values into the database table the syntax is most important and is shown in detail in the help file. Here the variable odbc will will be placed into a column named odbc if the column isnt found data wont be logged.
  10. We need to put in a script to close our connection
  11. We will put a button on our panel to start MS Access. A momentary button that has the Appexec command will achieve this.
  12. We must download for the scripts to take effect
  13. Locate your database file Myaccessfile be aware that there can be problems with the path of these files. Path names with spaces in the route sometimes will not work ie documents and settings We need to change the header names from field 6 etc to the names written in our logging script
  14. Save the changes
  15. Keep it simple and maybe accept table1
  16. MS Access will prompt for a key which is a good way to follow your data
  17. Finally check the table has the correct header names and close Access
  18. We have a button on our screen that runs the dbconnect script
  19. We had a message box programmed in our script to come up if we connected or not
  20. We added a button to our screen to launch MS Access
  21. Hopefully you will now have access open and data showing the data does not update live but will keep logging in the background and will show when the table is re-opened