Parameterized Design (Table)

Hello

I was asked to modify a plan that is last called for a room that uses a table to design and edit it quickly, except that we are trying to edit two values,
Sans titre
the play does not follow and I have this message

Capture d’écran 2024-12-09 110005

Is it possible to guide me to remedy this problem,
it's not me who makes the file
Thank you

Hello

What do the circled values represent?
What are the original values, and what values are you trying to replace them with?

PS: it would be nice to correct the word " Length " with its correct version " Length " with a U. This could prevent future mistakes, if it is not already the case here.

3 Likes

Hello

Someone has probably changed either the name of the dimension or the name of the sketch.
Do a search in the filter of the creation tree to see if you find the sketch and then look in this sketch for the dimension " Ball length"
If you can't find a rating with this name, the problem comes from there.
→ either you modify the Excel file to put the name of the dimension that exists in the sketch, or you rename the dimension in the sketch (the most logical for me)

If it is the sketch that has changed its name, you need to update the Excel table with the correct sketch name

4 Likes

Hello @Farouk

Is the cell format good? (number)

Yes I was also thinking that someone corrected the mistake in the documentary, but that it remained in the table...

2 Likes

As stated on the message, the problem is in the column header (column name) not in the added values. (cf @froussel
If you can't identify the error in the header name, you copy and paste your table into another excel file for backup.
You delete the part family and you recreate it automatically.
And you compare and modify the values if you have any problems.

Hello Sirs,
@Sylk
The value in red was 8 I changed it to 7 as requested and corresponds to the length of the half-sphere
image

The value in green is that of the drilling, I have changed it from 9.2 to 8.8 but it does not change
image

I don't know about the nominations, I didn't make them myself.
@Rems51
The format of the cell is standard
@froussel
Or could I rename the sides?
Thank you all

You can start by deploying the " annotations " in the FeatureManager and see the names of the dimensions.

image

Hello;

In general, the easiest way to fix this kind of error is to delete the offending column in the Excel table... quit Excel... and to restart the room family table from the right click ...
image
Then re-select the value to be added in the Excel table.
image

A little tip (or reminder...) To view the Dimension Name more easily, In the Hide/Show menu click D1 Dimension Name:
image

4 Likes

Completely agree with @Maclane on this point.
And as explained, make a backup of your table before for the values (just in case)

1 Like

Afterwards, I also wonder about the point of the 8mm length


Will it not end up at 0 in length when the length becomes 7? This could explain a reconstruction problem and a decanting of the software

To be sure that it is indeed a naming error, I will already try to redo the sketch with the desired dimensions in " hard " in the Solidworks file

2 Likes

@coin37coin I will say " Yes "... and " No ".

The values entered in the Excel table are only raw data. If they cause a reconstruction error, it will only be visible under Solidworks with the function in error but nothing will appear in the part family...

@Maclane, it's just a question to make sure you don't miss an " obvious " point :slight_smile:

That said, another question with the names of columns. If they were changed, the problem would appear every time the Solidworks file was opened, wouldn't it? It wouldn't know where to point its value (although with Solidworks, I wouldn't be shocked that it keeps values cached and waits for a rebuild!)

=> You got it all figured out... The problem can only be seen if you edit the part family... Worse, it is only when saving/closing that Solidworks displays this alert (at the risk of losing any changes made in the meantime).
To also answer @sbadenis ... there is no need (although security obliges) to create a copy of the Excel file.
Solidworks only takes into account sheet 1 (sheet1) of Excel, so it is quite reasonable to create a new tab on the same workbook to duplicate the data... To be safe, however, I advise to leave two rows and two columns blank on this " backup " sheet. (Solidworks only takes into account rows and columns contiguous to cell " A1 "...)

3 Likes

Hello again sir
@Sylk
I don't see any odds
1
@Maclane
I can't display the dimensions (I can't click) and it shows me no dimensions when I open the table in a new window
6
4
5
@coin37coin
This is an area of construction:

3
I can force the values

2

I think there is a problem with the painting I piercing which has no link with the half sphere does not change too

Thank you all

… It happens! (This is why the " Show unselected objects again" checkbox should always be checked each time the room family tables are opened.
However, nothing is lost... with the Excel table open, double-click on the dimension to be added and it will be entered again in the table (in the last position)... (the formatting of the cell will be that of a hyper-link but this is a normal operation).

On the other hand, I wonder if your rating (here 7mm) is associated with each configuration (normally it will have to change color to go to " Pink ") here it looks like a " universal " rating for all configurations...

Erratum: if the " show/hide " option the name of the call numbers is not available, it means that you have not assigned specific names to them...

image

(the example is not very well chosen but I don't have access to my Solidworks right now).

Erratum n°2 (disregard erratum n°1): Click (disable) " Hide all types " to access the options for viewing the dimensions... (among others)
image
… Because if you hide everything, you can't see anything... :grin:

Note: Personally I strongly suggest that you name your dimensions clearly if you are working on a component intended to have several configurations...
See to copy the name of the supplier's table if it is a commercial component...

@Sylk Finally I will need the " Strike through text" :grin: option :sweat_smile:

1 Like

I found a way, while waiting for the implementation;

<del> texte à barrer </del>

Donne: Text to be crossed out
:innocent:

2 Likes

Il semblerait que:
image

fonctionne aussi et donne: strikethrough

Source forum discourse dont est issue ce forum:

Ou encore:
image
donne (valable uniquement pour une ligne pas de paragraphe):
strikethrough

1 Like

It is not so much the means as the button that is lacking :confused:

@Maclane

I think that the 7 rating is not associated, the other odds are in pink
image
for drilling it's in pink and extrudation
image
image