Query in creating AET fields

[Former Member]

Hi,

We are working on a upgrade project from crm 5.0 to 7.0.

In campaign overview page we need to create an assignment block with few custom fields which we have created using AET. In CRM 5.0 they have implemented a custom transparent table which holds the data for these custom fields.

How can we move the data from the custom table to CRM_MKTPL_ATTR table where the AET attributes are created?

Few programs use the existing custom table. Thus if we change the data in CRM_MKTPL_ATTR it will not be reflected in the custom table. How do we handle this situation?

Regards,

Sayan

[Former Member · Accepted solution]

Hi,

I guess reports would only be to read the data. If you want your system to be clean and with less issues I would suggest to go ahead and change reports to point to CRM_MKTPL_ATTR. This would be one time effort and right approach.

Possible approaches would be:

1. To update CRM_MKTPL_ATTR from Z table - You would have to create a z report to read data from custom table and update corresponding records in CRM_MKTPL_ATTR. This would be one time report and would have to run only once when your system is refreshed/set for first time.

2. To update custom table with data from custom fields - On save event of campaigns you can write logic to read custom attributes and then insert/modify your custom table accordingly. This would take care of ongoing updates for your data.

Regards,

BJ

[Former Member · Accepted solution]

Hi,

Thanks for the answer.

But I have one more doubt.

The assignment block where we are having these custom fields is part of the campaign overview page and the SAVE button of the overview page will update the entries in table CRM_MKTPL_ATTR. The event handler of the SAVE button is a standard delivery. How can I insert my code to update the custom table in it.

Can Database Triggers be used? Like, whenever the database CRM_MKTPL_ATTR is updated it will trigger and a corresponding update which will update the custom table. Is there any way we can achieve this functionality. If yes, can you guide me through it.

Regards,

Sayan

[Former Member · Accepted solution]

Hi,

I had one more doubt.

When we create AET fields in the header of the campaign overview page attributes are created in BOL entity Campaign.

If we create a custom component and add a model node using Campaign as the BOL entity we can access the fields. Now when we create binding between the custom component and custom component the fields are populated with correct data. But how can we make this field editable?

We added an EDIT button and added the code to make the view editable in the event handler of the edit button. It is not working. But if we click both the edit buttons in the header data assignment block and the custom assignment block field is becoming editable. How do we tackle this issue?

Thanks in advance.

Regards,

Sayan

[Former Member · Accepted solution]

if you want to make these fields editable, then you will have to lock the entity/switch it to change mode.

You can find both these methods in cl_crm_bol_entity class so you can use them.

Also please check view config if you have made these fields display only. And also put a breakpoint in get_I_xxx method to see if fields are disabled there.

That would help you to find cause of the issue.

Regards,

BJ

[Former Member]

Thanks