Adding ACT notes into Sugar

[stevenjohn]

Hi there,

I'm currently *enjoying* trying to get our act data into sugar. Its not going too badly, but i have used pointers from here:

http://www.sugarcrm.com/wiki/index.p...mporting_Notes

to get where i am and its almost there

Now, I have my account id's matched up to my notes so when i import notes i can match to the account in question. All looks good, my data looks like:

515998d7-7a17-bc7c-50e7-4819e1660edd 04/08/08 11:18 AM 4 Accountancy Jobs Note www.4accountancyjobs.co.uk is the sister site of www.4accountancyjobs.com Our new site that can harvest your jobs from www.4accountancyjob.com or your own RSS feed if you have one. We are currently testing this site and are looking for a few feeds f
914d5309-6b20-a45b-3b3c-4819e11ed14f 04/21/08 6:50 PM 4 Secrearial Jobs Field Changed Last Results - Grant at DA Solutions
914d5309-6b20-a45b-3b3c-4819e11ed14f 04/21/08 6:50 PM 4 Secrearial Jobs Note "Request from Grant, we have docs in, should be a quick one as we have done these before."

When i import the data I get a message:

Success:
124 Successfully Imported
594 Records skipped because the id's either existed or were longer than 36 characters
0 Records skipped because they were missing one or more required fields

So it seems that as soon as the import script finds it is to import a line with an account id its already imported it sees it as a duplicate? Which seems bizarre because accounts would obviously have multiple note entries...?

Could anyone help out here. Is the best way forward to work on the dbase directly, or can I tweak the way this is imported so it will work?

Kind regards, Steve.

[vavalos]

It seems as if you have duplicates in your notes.id column.

You can have duplicates in the parent_id (this would be the place to reference the account that the note is associated with). Notes.ID should represent a unique value for each individual note. You will have to generate this unique id, preferably up to 36 characters.

[stevenjohn]

Hi Vavalos,

Thanks for your reply - turns out I was allocating the account name to the field 'name' and this was populating the id field which is unique...

Have now imported OK.

Thanks, Steve