Link reference cell in properties to Excel catalog

Scott · Unread post by **Scott** » Fri Sep 28, 2012 7:06 pm

Does anyone know how to link the "reference" cell in the defined properties to an excel catalog?

I have a catalog part, but the catalog part is different then my part number. I want to have the reference cell (part number) to change based on the catalog code used when i include the standard into an assembly.

I have attached an image to help illustrate.

olaio · Unread post by **olaio** » Mon Oct 01, 2012 10:37 am

Hi,

In your excel file rename your column "DW Part Number" to "$Reference".
This should be enough.

Olaio

Scott · Unread post by **Scott** » Tue Oct 02, 2012 1:54 pm

Thanks for your reply.

I tried this with no luck.

Does Cell "E1" have to be defined like cell "A1"? (See attached image)

olaio · Unread post by **olaio** » Tue Oct 02, 2012 10:55 pm

Ok,

Just try this:
Close TopSolid.
Open the excel file.
In the excel file

File

Save As

In Type file choose Text(separated by tabulations).
Then in windows explorer rename the txt file to cat file.
Rename the excel file to another name.
Run TopSolid.
Check if everything is OK.

Olaio

Scott · Unread post by **Scott** » Tue Oct 09, 2012 4:00 pm

This didn't work...

What version of TopSolid are you using? We are using TopSolid 2012 (V613).

Would you be willing to take a look at the files that we have created?

Scott

olaio · Unread post by **olaio** » Tue Oct 09, 2012 11:28 pm

Hi Scott,

No problem, just upload your files and we will see what we can do

Olaio

Scott · Unread post by **Scott** » Wed Oct 10, 2012 2:49 pm

See attached files.

I had to add ".txt" to the ".cat" file so I could upload the file.

olaio · Unread post by **olaio** » Wed Oct 10, 2012 4:00 pm

Ok,

i checked where is the problem.

replace $Reference by $reference ("r" instead of "R").

Here it works.

Olaio

Scott · Unread post by **Scott** » Thu Oct 11, 2012 6:57 pm

That worked when I made the change to the .cat file!

Thanks for your help!!!