Customization and Integration

[skipwhitten]

Hello,

The length of the txtCustReference field is 15 characters. Can that be increased? I don't see that option. If no, can I add a UDF to that form that is longer than 15 characters.

Thanks in advance,

Skip

[trodman]

Unfortunately it's a database limitation.  There are 4 user-defined fields available, but they are also limited to 15 characters each.

You could add a table (we named ours tarCustomer_TRC) with the extra fields that you desire with whatever length that you desire, and then bind the fields to the screen using Customizer.

Also, Macabe has an enhancement that allows you to add extra fields through the front-end without using Customizer.  I haven't used it, but it looks nice:

http://www.macabe.com/pdfs/library/MAS%20500%20User%20Defined%20Fields%2007-11.pdf

[skipwhitten]

Hi,

I created a masked edit field and defined the maximum length at 18 characters. I can type in my data but in essence, there has been no change to the data dictionary and I won't be able to query SQL from an external source. We need 18 characters to link to an external CRM program field. Thoughts?

Thanks in advance.

Skip

[trodman]

Did you populate the "Data Binding" tab?

[skipwhitten]

No,I have to figure that out.

Thanks,

Skip

[skipwhitten]

I looked into the Macabe enhancement but you have to be on v7.3 or above. Looks good but we can't use it.

Skip

[LouDavis]

You will need to create a new extension table in SQL Server (example: tarCustomerExt_AAA) and include your new column as well as the column CustKey (primary key for tarCustomer).   You do not have to do anything with the data dictionary.  All you need to do is bind this new table to the customer maintenance form with Customizer and set the relationship using the CustKey column.  Once you do that, you can use the new column in your extension table to hold the custom data you need.

[skipwhitten]

I installed SQL Server Management Express Studio and created my extension table (tarCustomer_Vev). I added two colunms.

CustKey (PK, int,not null)

VeevaCustID (nchar(18),not null)

How's this?

Skip

[skipwhitten]

Final steps:

In maintain customers using Customizer:

1.Created Label (Veena CustID)

2. Created MaskedEdit max length 18 (ID is 18 characters)

3. Data Binding - Parent Table is tarCustomer, Bound Table is tarCustomer_Vev (Column is CustKey)

4. Click Relationship but NO columns are displayed to link.

Please advise.

Skip

[skipwhitten]

Resolution ID 516596 fixed the issue. It was screen resolution. Now I see the columns but the first time I bring up a customer record, the following message appears

SELECT permission denied on object 'tarCustomer_vev, database 'BIOmas500_app',owner 'dbo'

In table properties (SQL Server Management Studio Express), I gave myself SELECT & UPDATE permissions on the table and the error went away.

Skip