We used CATI our VAR to write a script for us. We had our models in a separate workflow from the drawings which made it exceptionally difficult. Plus we had drawings in each of the states of its workflow. So to match that all up and match the revisions it had to be automated. Now you know that my VAR has a script already, they'll still charge you, but it may be cheaper since they don't need to write it from scratch.
Thanks for the response, I thought that might be the case some form of scripting from my VAR.
Thing is that if you want to output correct BOM's then all of your models need to match production drawings.
I'll contact my VAR in the UK see if they have written one before.