Import Data to a One to Many Relationship (Custom Module)

SuiteCRM Forum - English Language SuiteCRM General Discussion
#1

I am trying to import module data to a custom module related to Contacts. This module has a one to many relationship, many being the custom module to store multiple records relating to a specific contact.

I have exported the Record ID, Name, and Last Name to a csv file. The custom module is used to track monthly payments. Basically I need to use the Record ID from Contacts to create a new record to the related module on import from a csv file. Is this functionality possible?

#2

I believe that the easiest way to do it would be with a custom script that accesses directly the database.

#3

I figured it out. Functionality is there its just not evident.

You must relate a contact record id field in your csv and it will import properly.