Mapprod populating

[b.kata]

Hi,

We are working with a database that doesn't have a prodinfo.map file set up. After looking through some topics on the forum, it seems to me that while populating the database, you should also be manually managing updating the database in the product information editor as well. Is there any way to populate the prodinfo.map with mostly automation? Tried my hands at using some of Darren's scripts but i couldn't get the outputs to import as they are not in the desired format (I think )

I mostly need this to replicate this powerBI function in our database, if there is any way to make this work without the prodinfo.map that i missed please tell me 

[cadbyken]

Darren's scripts are the best place to start off. The main problem you probably have is that there isn't an ID number assigned to most of the parts.

With the scripts, you could get Manufacturer, Description, Size, material. The Specification and Install Type (connection type) can be inferred from other fields can. Find the script that gives you the most information and add to it as needed.

Another method is to export out the data in the ITMs and import into Power BI or Excel to make populating the ID numbers easier. Then run the script mentioned above. Select all ITMs in a folder, shift right click on one of the parts and choose Export Product Lists

Note: I replaced the picture with the correct one

[Ty_]

Darren's scripts are the best place to start off. The main problem you probably have is that there isn't an ID number assigned to most of the parts.

With the scripts, you could get Manufacturer, Description, Size, material. The Specification and Install Type (connection type) can be inferred from other fields can. Find the script that gives you the most information and add to it as needed.

Another method is to export out the data in the ITMs and import into Power BI or Excel to make populating the ID numbers easier. Then run the script mentioned above. Select all ITMs in a folder, shift right click on one of the parts and choose Export Product Lists

This is the right answer but also happy to see more interest in the Fabrication PowerBI dashboard too. To get the most out of it, you'll need the 3 main datasets. Product Information, Supplier Information, and your Price List. Labor and the other tables can be extracted via script or other methods.  Name of the game is having clear Database ID's assigned to your ITM's since these ID's are unique and consistent throughout all of Darren Youngs scripts and Fabrication Parts as a whole.

Also, if you're looking for the downloads for the Fabrication dashboard the link below will get you the template and guides. I've been trying to fix the download link in the Linked In article but, would have to repost it and that would wipe out all the content that is currently there. I'm hoping to make an updated post here in the next few months as there are new features in PowerBI that can help with the editing/modifying of the Product Info. Also feel free to reach out with any ideas you have too, I'm always excited to chase a new data rabbit hole....

https://www.autodesk.com/autodesk-university/class/Navigating-Fabrication-BIM-Content-Power-BI-2019#downloads

[cadbyken]

Glad you are back! And, yes, Power BI is the way to go. I haven't done anything yet in it but I know it is a huge help in processing all of this information thanks to your videos. Can't wait.