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.
Lookup table creation workflow?
EvanReese
Member, Mentor Posts: 2,135 ✭✭✭✭✭
What's a good workflow to automate the creation of a lookup table without having to type each entry? In a thread I was unable to find again, I remember @kevin_o_toole_1 (I think)
mentioning it could be done in one's "language of choice", but I'm a neophyte with no language of choice. Can someone recommend a language and, maybe an IDE a beginner could use for this? Any rough overview of the workflow steps would also help a ton. Otherwise, I guess I can try hacking it together in a spreadsheet with lots of concatenate functions.
mentioning it could be done in one's "language of choice", but I'm a neophyte with no language of choice. Can someone recommend a language and, maybe an IDE a beginner could use for this? Any rough overview of the workflow steps would also help a ton. Otherwise, I guess I can try hacking it together in a spreadsheet with lots of concatenate functions.
Evan Reese
0
Best Answer
-
kevin_o_toole_1
Onshape Employees, Developers, HDM Posts: 565 
I'm sure you'll get different favorites from different folks, but one advantage of using Python or JS for this is that you'll also be able to use the Onshape API to easily upload the code you've generated. In fact for JS this is already implemented with the "Upload blob" sample app here: https://github.com/onshape-public/apikey/tree/master/Node
Once you get that running from a terminal, you can then add bunch of JS work which generates your code, which seems to me like the fastest path to a completed project!
If this is just a one-time thing that you're okay copy-pasting, I'd say Python and JS are still good options, as both are easy to get up and running quickly.5
Answers
Once you get that running from a terminal, you can then add bunch of JS work which generates your code, which seems to me like the fastest path to a completed project!
If this is just a one-time thing that you're okay copy-pasting, I'd say Python and JS are still good options, as both are easy to get up and running quickly.
looking through that, it seems like that's not a rabbit hole I'm ready for, at least for this project. I am impatient about getting it to a usable place. I've just updated the table entries manually (194 of them!) with some thoughtful use of the find/replace tool. If detailed lookup tables become more a part of my life, I'll be digging into this. I appreciate you taking the time to find the link and give some pointers!