How to use Note module parent_type field in Tasks

💬 General Discussion
3

Thanks, pgr. I missed it somehow. Here is my dilemma, I am importing data from Salesforce that had two of these fields, WhoId and WhatId. Well, SuiteCRM only allows one of these fields, is there a good reason why that is and can it be overridden without breaking something?

My current plan is to put all the What Ids in the parent_type as there is more diversity. The Who Id field I can mitigate with two relate fields, one for Contacts and one for Leads, and then programmatically distribute, but it just seems janky. I would like to be able to have two parent_type fields and just increment the fields in the table with a number just like the relate field.


$ ./sfcsvparser_v2.py -f Task.csv -m Tasks -d |grep "Walk: WhoId" |awk '{ print $3 }' |sort |uniq -c
   7462 Contacts
    221 Leads
$ ./sfcsvparser_v2.py -f Task.csv -m Tasks -d |grep "Walk: WhatId" |awk '{ print $3 }' |sort |uniq -c
   2788 Accounts
     20 Opportunities
     78 props_Listings
      4 props_Properties
    974 props_Proposals
    173 props_Spaces

Also, how can I keep the drop down fro parent_type current with custom modules? Can I change the list used on the backend?