On the Script I’m working on it has 3 options for Input/Output to finally develop a process that’s efficient & effective.
Q: I’d like to get help Combing Opt 1 & 2 “Inputs” (aka: Export of Data), to basically get the Element Id’s (GUID’s) & combine the Excel Headers accordingly…Is there a Point A to B script (shortest path)?
So my Main Goal is to use predefined Excel files with Headers to define the Parameters I want to Export based on the Category chosen (with Element ID’s included). Then, modify & Import the Excel file & have it grab the Headers again to specify Parameters to update without having to adjust a Strings/Code Blocks to update each column of parameters…that drop the headers & apply all else data. My goal is to possibly have the user highlight columns & or rows updated & or delete columns not updated in Excel. Finally, use Dynamo Player to just specify the Excel files to Export/Import Data. The scripts here are from what I’ve learned from labs/tutorials/research I’ve done. I’ve been at it looking back on notes & trying to make sense of Language that looks like Vulcan to me at times. Trying to get the smell of noob washed off (my 3rd try for practical Dynamo use) & the smell of new journeyman put on if I can get over this hump ;p Been on this for 2 days now & have hit a mental wall. Attached is the script with all 3 Process Options on Frozen until it’s being used (better than open/closing each option at a time to test).
I used the OOTB Advanced Model Sample to play with the scripts. This topic has so many ins/out to compose, & haven’t been able to pin-point my desire approach from all the posts & blogs but from 1 at “BIM-Troublemaker”.
Export-Import Studies.dyn (78.9 KB)
Sample Headers w ID.xlsx (8.4 KB)
