In Sharepoint 2007 I am trying to automatically set values read from business data for new documents added to the document list. Right now, when new file is uploaded, user:
- needs to go to the "Edit Properties" menu item
- copy the part of the file name
- paste it into column which is linked from Business Data Catalogue
- check the name (if the corresponding item was linked correctly)
- push the ok button to accept the changes.
Is there a way to somehow automatically process new documents (most preferably using workflows attached to document library) so those data would be auto-filled?