The sheet Set properties work perfectly but is not preferred. we would like to use the sheet set title for other purpose where we can rename and would not affect the part Number.
in the attached test.zip i previously uploaded is all the files and discrepancy that data extraction produced. From time to time, the result do come out properly but most of the time it produces the wrong result. As you can see from the 1 of the screen cast it did not produce the right report from data extraction. The test.xls should have a series of H01, H02, H03, H04, H05,H06 parts extracted. However, all the parts in the dwg_no ended up being H01's or ###.
In the Frame.xls file where the TAG-PART block, the FRAME-NO field is link to the file name. The extraction do not correspond to the file name. This is only an issue when extracting multiple files.
The autocad we use is out of the box with no custom setting and no 3rd part apps.
I am attaching a second run on the frame folder and a screencast - in this case the field is linked to the file name but the result the data extraction produces do not match.
screen cast
https://knowledge.autodesk.com/community/screencast/073b9bfe-3141-4649-99f6-2f516e90d83f
