Relationship between a custom module and contact

[yoann49]

Hello,

Sorry for my english but i'm french.
I'm working on Sugar and I have a problem to relate my data from my custom module to my contacts when I import it.
So I create a relationship between my custom module and contact a many to one. After I import my account where I created an ID and then my account with the relationship between the ID's but after when I want to import the date for the custom module they don't ask me to mapp it with the account ID so I don't have any way to do the relationship.

If someone can help me please. If you don't understand anything just ask me to repeat by an other way.
Thank you

[rafael.q.g@hotmail.com]

You can import the relationship of contacts and your custom module inserting the relationships directly in your database. There will be a specific that to store this relationship. You could adjust your csv file to be an sql file with insert statments and then execute it over your db.

Of course this solution requires a little of SQL knowleadge.

[Ramblin]

I believe if you want to import the Account to synch, you have to include the ID coilumn with the ID of each Account for which you are importing data.

[yoann49]

Thank you for answering.

I will not be able to do with sql lol.
And I create the column with the account's ID but they don't ask me to map it so it doesn't work.
I found an other way, I stoped to work with my custom module and I took an existing one, by this way I can easily do a relationship between my contact and this module. I took the invoice module but the problem is to modify the line items because we cannot do it in the studio and it's kind of hard for me to customize it by the code.
Thank you, and if you have any idea about the line items in order to customize it, I will be happy.