Welcome to the Onshape forum! Ask questions and join in the discussions about everything Onshape.
First time visiting? Here are some places to start:- Looking for a certain topic? Check out the categories filter or use Search (upper right).
- Need support? Ask a question to our Community Support category.
- Please submit support tickets for bugs but you can request improvements in the Product Feedback category.
- Be respectful, on topic and if you see a problem, Flag it.
If you would like to contact our Community Manager personally, feel free to send a private message or an email.
Linking a document to an external database
I need to link one of my documents to an external database. The database has a list of materials and I need to assign a material to a part of the document (e.g. a surface). How can I:
a) link the document to an external database
b) select a surface or a part (item) and access the database to assign the property
c) display the result in a display box on the document toolbar
I can't seem to find any resources on this in the Learning Center.
Best Answer
-
chadstoltzfus Member, Developers, csevp Posts: 144 PRO
Couple of challenges to tackle but this is doable. Here's where I would at least start; if you want to have it so you can drive the assignment from Onshape, you'll want to look into Onshape's API. They have an intro to the API course and they just released a new quickstart course.
You'll want to probably look into extensions, this will give you a fly out tab that can get the part id of a part that is currently selected. From there I imagine you could grab the property list from your database and give the user a list of selections to assign to that part.
Applications Developer at Premier Custom Built
chadstoltzfus@premiercb.com0
Answers
Couple of challenges to tackle but this is doable. Here's where I would at least start; if you want to have it so you can drive the assignment from Onshape, you'll want to look into Onshape's API. They have an intro to the API course and they just released a new quickstart course.
You'll want to probably look into extensions, this will give you a fly out tab that can get the part id of a part that is currently selected. From there I imagine you could grab the property list from your database and give the user a list of selections to assign to that part.
chadstoltzfus@premiercb.com
Many thanks, @chadstoltzfus. Will look into this.