Export BOM with Levels from Workflow...

Ok... I'm a little rusty on api programming with EPDM... so I'm hoping someone can point me in the right direction on this one.  I need to find a way to make the following happen automatically on a workflow transition:

This is the manual process:

- Locate the assembly file in the vault in Windows Explorer

- Select the BOM tab

- Select "Export as CSV"

- Wait for Excel to launch tmp file

- File Save As

- Map to H:XML

- Save file to Config name

This is how the data that comes into the CSV looks now... and that's what I need from an automated process as well:

LevelFILE NAMECONFIGURATION
1TC0000083.SLDPRTTC0000083P01
2TC0000014.SLDPRTTC0000014P01
3TC0000008.SLDPRTTC0000008W01

Does anyone have any pointers?

SolidworksSolidworks Pdm enterprise Pdm