Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Overriding Table Name Prefix in New Form Wizard View modes: 
User avatar
Member
Member
scott_hancock-urmc.rochester - 10/18/2012 9:10:30 AM
   
Overriding Table Name Prefix in New Form Wizard
Hi,

The New Form Wizard in v6 appends the current site name to the table name of all new forms. We had a naming convention in v5 that we want to continue using. Is there a way to override this behavior? Why was this changed. I get forms from many developers so I would end up with all different table name prefixes for Forms.

Thanks,
Scott

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 10/19/2012 2:15:54 AM
   
RE:Overriding Table Name Prefix in New Form Wizard
Hi,

This would require pretty complex customization. I am afraid but there is no setting for it and it is hardcoded like this. I am sorry for this inconvenience.

Best regards,
Juraj Ondrus

User avatar
Member
Member
scott_hancock-urmc.rochester - 10/19/2012 7:48:05 AM
   
RE:Overriding Table Name Prefix in New Form Wizard
Do you know why they changed this? I understand wanting to avoid naming collisions but it seems odd to use the site name and to force it on the users.

Scott

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 10/22/2012 3:22:51 AM
   
RE:Overriding Table Name Prefix in New Form Wizard
Hi,

The reason is to make the forms available to be used on other sites wihtin the same installation.

Best regards,
Juraj Ondrus

User avatar
Member
Member
scott_hancock-urmc.rochester - 10/22/2012 9:13:15 AM
   
RE:Overriding Table Name Prefix in New Form Wizard
That makes sense. I've found a workaround for us. You can override the default prefix with your own by doing the following:

In the file:
~\CMSModules\Bizforms\Tools\BizForm_New.aspx.cs

Change line 25 from:
private string mFormTablePrefix = null;

To:
private string mFormTablePrefix = "<Your Prefix>";

Thanks,
Scott

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 10/22/2012 9:22:09 AM
   
RE:Overriding Table Name Prefix in New Form Wizard
Hi,

This is also an option - but be careful when upgrading or hotfixing so it won't be reverted back.

Best regards,
Juraj Ondrus