Why You Should Use Excel Integration for Agile PLM
Microsoft Excel is the industry standard for spreadsheets. It’s wide range of functionality, user friendliness and customizability make it the “go to” tool for data authoring and visualization. Agile PLM, on the other hand, is a comprehensive PLM Application with rich concepts and requires training to get familiarized. The biggest challenge that Agile users face is carrying out mass operations like updates and creating objects. It is only natural to marry Agile PLM with Microsoft Excel so that business flows can be executed in Agile using the household environment of Excel.
Users can carry out mass operations of Agile PLM data without ever having to login to Agile. Imagine updating hundreds of objects in Agile manually: opening each object one by one and setting values; not at all practical. In this case, a user will turn to utilities or custom tools to update specific data. Why not use one tool, built into Excel, which can update any kind of object? The same hundreds of objects can be modified at the same time by using the drag and drop feature of Excel. This saves precious time.
Industries that use Agile PLM mostly use Excel for consolidating data in any case. This tool automates that process, as Agile Administrators can create specific searches and pull all of the desired data right into Excel. Even if there is no intention to update data later, they can still use Excel’s data analysis features from the pulled information and later create reports in Excel.
Configure a saved search in Agile and pull all the data in that search directly into Excel
Make mass modifications in the pulled saved search data and export all the modifications directly into Agile
If Items are being updated and the modifications require a Change to be created, then the user is shown a Change Configuration screen where they can pull pending changes, create new changes, or search for existing changes
Refresh saved searches so that the spreadsheet is populated with the latest data
Updating BOM, AML and ASL
Provide a single item number or a comma separated list of item numbers to pull the cumulative BOM, AML or ASL data
If the AML or BOM table update requires a Change to be created, then the user is shown a Change Configuration screen where they can pull pending changes, create new changes, or search for existing changes
Make mass modifications to the pulled data and update all modifications directly to Agile
Modifications across different saved searches and AML, BOM and ASL sheets can be completed through a single Change by using the “Update All” feature
Generate template sheet of any base class, main class or subclass
Fill the template sheet with the desired information
Create data right from Excel
Support of Auto-numbers
Triggers creation events in Agile unlike OOTB import
Attributes that are List type are shown in Excel with dropdown values from Agile. Users can directly select the appropriate value from within Excel
In case list values are added or removed, users can “Refresh List” to reflect those changes in the spreadsheet
Accidental modifications can be reverted using the “Undo Change” feature
Provide your Agile PLM credentials only once and save them. No need to provide them with subsequent usage
Help button directs the user to the UPK Guide
To schedule a live demo of Xavor’s Excel Integration for Agile PLM:
Faisal has a Master’s Degree in Software Engineering and has 20 years of experience in Software Development. His areas of interest include Workflows/Business Process Automation, Integration and Enterprise Web Development. Currently, he is working on Xavor’s suite of products for Agile PLM. He specializes in dissecting requirements and coming up with intuitive solutions.