Advance Steel Forum
Welcome to Autodesk’s Advance Steel Forums. Share your knowledge, ask questions, and explore popular Advance Steel topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Help! SQL Management Studio to rename Astorprofile, not working

3 REPLIES 3
SOLVED
Reply
Message 1 of 4
mwwm
365 Views, 3 Replies

Help! SQL Management Studio to rename Astorprofile, not working

mwwm
Advocate
Advocate

As the attached screenshot, I tried to rename a user custom Astorprofile (not sub-profile). The table name and Key, Index were renamed, then in the management tools => Astorprofiles, I can see the new name, but the Preferred sizes => section class => Available classes still shows the old name and same as when I create a beam which only has old name to choose and shows no profiles(because I have already changed the name through SQL management studio).

 

What did I miss? Thanks for any help.

 

Michael

 

Capture.JPG

0 Likes

Help! SQL Management Studio to rename Astorprofile, not working

As the attached screenshot, I tried to rename a user custom Astorprofile (not sub-profile). The table name and Key, Index were renamed, then in the management tools => Astorprofiles, I can see the new name, but the Preferred sizes => section class => Available classes still shows the old name and same as when I create a beam which only has old name to choose and shows no profiles(because I have already changed the name through SQL management studio).

 

What did I miss? Thanks for any help.

 

Michael

 

Capture.JPG

3 REPLIES 3
Message 2 of 4
ChristianBlei
in reply to: mwwm

ChristianBlei
Advisor
Advisor
Accepted solution

Hi,

 

because shape classes are registed in the ProfilesMasterTable in AstorProfiles.mdf, you have to make equivalent adjustments- change the name- as well there.

 

HTH, Christian Blei

Christian Blei
CBT Christian Blei Tools
christianblei.de
youtube.com/channel/UCxjA_NbeScQy9C0Z1xjwXpw

Hi,

 

because shape classes are registed in the ProfilesMasterTable in AstorProfiles.mdf, you have to make equivalent adjustments- change the name- as well there.

 

HTH, Christian Blei

Christian Blei
CBT Christian Blei Tools
christianblei.de
youtube.com/channel/UCxjA_NbeScQy9C0Z1xjwXpw
Message 3 of 4
mwwm
in reply to: ChristianBlei

mwwm
Advocate
Advocate

Thank you, Christian. Could you please give more details? I need to edit under dbo.ProfileMasterTable some value in SQL Management Studio?

0 Likes

Thank you, Christian. Could you please give more details? I need to edit under dbo.ProfileMasterTable some value in SQL Management Studio?

Message 4 of 4
johnjmbennett
in reply to: mwwm

johnjmbennett
Mentor
Mentor
Accepted solution

Hi,

 

as @ChristianBlei  said in the profilemastertable, which is within the Astorprofiles database, you need to access this DB and then under that table find the line relative to the user profile you added, then the ‘table name text’ Column, in that field , change the old name to match your new name of the table.

 

johnjmbennett_0-1594189945916.jpeg

 

this old faq explains process To add in via access, it is Same for SQL.

https://knowledge.autodesk.com/support/advance-steel/learn-explore/caas/simplecontent/content/advanc...

 

tou can do this via the management tools table editor, to change the field value for the table name.

 

 

 

John Bennett
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

Hi,

 

as @ChristianBlei  said in the profilemastertable, which is within the Astorprofiles database, you need to access this DB and then under that table find the line relative to the user profile you added, then the ‘table name text’ Column, in that field , change the old name to match your new name of the table.

 

johnjmbennett_0-1594189945916.jpeg

 

this old faq explains process To add in via access, it is Same for SQL.

https://knowledge.autodesk.com/support/advance-steel/learn-explore/caas/simplecontent/content/advanc...

 

tou can do this via the management tools table editor, to change the field value for the table name.

 

 

 

John Bennett
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.

EESignature

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report