Extract Data with Hyperlink column
Hello @stefano6UNFR
<<....Autocad does not read the hyperlinks within the 3D block editor, but read the one when the 3D block is selected...>>
Of course it does. Since that's the way AutoCAD does it, you'll need to TRICK the DataExtraction into using the HYPERLINK and not the text 'when the 3D block is selected.' You 'll need to perform an edit in the EDITOR then perform the Data Extraction.
1. For example, I have six solids (image-1).
2. Each solid has a HYPERLINK as shown in the Editor below (image-2). The 'Hyperlink' itself and the 'Text to Display' are identical. The Text to Display is captured during DataExtraction, not the Hyperlink.
3. The DataExtraction will compile the extraction results in a csv file (image-3). Since the Text to Display is read during extraction, the hyperlink ends up in column G.
Chicagolooper
Questions:
- Where did this block originate?
- Who created the hyperlink?
When I use data extraction I am able to pull out the hyperlink, but you’re implying you can’t.
Can you share your block(s) for troubleshooting?
Chicagolooper
Thanks for uploading your dwg.
I was able to do it but there's a 'catch.' I had to perform DATAEXTRACTION command twice: (1) the two blocks in group A and (2) the block in group B. Both A blocks (parts named Standard Key Clamp and Zinc Plated Mesh) are individual blocks whereas B block which is a block itself, but is comprised of 3 separate blocks, make up the part named Crank Barrel Bolt.
Refer to image-1.
When I use DataExtraction command on group A and group B, I can generate and .xls like this (image-2 & image-3),
In both spreadsheets, the DataExtraction output will display the hyperlink in column C.
NOTE:
The data in image 2 and 3 are from your blocks. The blocks were not modified. No blocks were edited in the Block Editor. The Block Editor is not needed to extract the hyperlink to xls. The same procedure also allows you to extract to txt and csv formats. You may even extract to an AutoCAD Table that can be inserted directly into the same dwg file.
Are you using DATAEXTRACTION (image-4).
Chicagolooper
@stefano6UNFR wrote (post#3)
<<….This is because the database is set in that way…>>
Since you are unable to foresee the issues that will occur with the data upon insertion of the block, then your output like that.
Data extraction doesn’t predict what data you’ll need and put it in the order that will make you happy, it simply pulls the data out. It’s up to you, the user, to manipulate and massage the data so it works for you. You are in control, not AutoCad.
<<…I wonder if there is a way to have the Hyperlink set when I create and store the 3D block?>>
Of course there is, but not using plain vanilla AutoCad.
Plain vanilla Cad is like a dumb phone….you can talk and text. That’s it. No voice directions when driving, no bluetooth, no internet. Do you run Map3D or Civil3D? Those versions can work with database files. Easily work with them. They can create, read and manipulate data. Various types of data. They’re hammers.
<<I wonder if there is a way to have the Hyperlink set when I create and store the 3D block?>>
Of course there is. But not with vanilla Cad, it can’t and doesn’t read database files.
Right now, you’re pounding nails with a brick. To improve your pounding, you’ll search for one with the right shape and right weight and you’ll eventually find one. But in the end, it’s still a brick, not a hammer.
<<….the list is unusable as the hyperlink comes where the 3D solid row is and in random order….>>
This is due to the data’s author, not the data user. The user can, if he knows how, leverage the data into a format that’s productive.
However, using the right software, the data can either be automatically added during block insertion, and depending on the block and type of data, can be ‘attached’ to existing objects en masse.
<<….adding it everytime I import a 3d block is a waste of time…>>
You’re right, it’s a waste of time. So is your solution to give up? Accept the limitations of vanilla Cad and fine tune data extraction in a spreadsheet. Then move forward with more important things.
Chicagolooper
Use Map3D.
BTW, if your data is originating from different manufacturers then it's likely you'll still need to massage the output because each manufacturer will have their own way of describing each part or each piece. Also, if you have created your own data, you yourself, have likely developed your own personal way of describing each part. Due to the various descriptions that may be given to each part you'll need to put some effort into the process to achieve your final list.
For example, an individual part might be described differently by different suppliers: Part No., Part#, ID, Name, Item, Desc., etc., etc. Even though each term describes a 'Part' you want to order, you'll still need to find a way to list all Parts in the same column despite their varied descriptions.
Chicagolooper
