Sign in to follow this  
Followers 0
Bharat

CX Supervisor + Access Database Data Extraction

3 posts in this topic

Hello Everyone, I m new to CX supervisor, I have been building graphic images for small plant. Now there is a issue with CX supervisor v3.1 and Access database. I have built a databse .mdb file and hve been successful in connecting it to the CX supervisor. But I am not able to extract any information. Attemping: I am trying to build a Manufacturing record form and I am trying to populate cells in it with information from the databse. eg: Operator would select a product on the Cx supervisor and the CX supervisor , should extract all the informtion, like temperature , ingredients etc and populate the CX supervisor page with it. But i am not sure how i can extract and populate spaces like that. I have attached a record sheet whcih is a sample from internet. Here you would see tables which have information like soultions, weights and volumes, which are to be filled when a particular product is selected , in this case its RD1374. Please do let me know how we can extract information from the database, there should be some syntax which states Productid.Ingredients and this extracts the ingredienst from the database. 2) Second issue, I am trying to create a login page, so that only selected users can access the maintenance page. My projects starts with the title page which requests fro a login, if the operator has logged in, he should be able to access the Maintenance page, but if the Maintenance engineer has logged in, he should have access to Maintenance page. How can I achieve this? Thank you 20110705081316.pdf Edited by Bharat

Share this post


Link to post
Share on other sites
Hi Bahrat, Yes this should be easily achievable with CX-Supervisor. It connects to your database Table (or Recordset) with a 'Point' linking to each column. Checkout the "Database Demo" installed with the developer, which should show how to Write records, navigate records and Read values etc. This should give you enough info to get the first steps complete. Assuming you're using the inbuilt login functions, the security can also be achieved various ways. A couple tastes to show: - The Maintenance page button animation can have a security access level applied. See the "Security" chapter in the User Manual for details. - The System Points like $SecurityLevel can be used in an animation to hide or disable your button that opens the maintenace page hope that helps, Regards, BB.

Share this post


Link to post
Share on other sites

Hi, Bharat.

I wonder whether you have found your way out yet? Do you have any idea about pdf extraction? Any suggestion will be appreciated. Thanks in advance.   

 

 

 

Best regards,

Pan

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0