Importing activities together with attachments using the DTW

[Former Member]

I would like to import activities and the corresponding attachments with the DTW, but I'm not sure how to link attachement to activities.

More specifically, I understand I've got to work with three DI objects :

• Contacts (for activities),

• Attachments2,

• and Attachments2_Lines,

but I don't understand what kind of link should exist between Contacts and Attachments2_Lines.

Do I have to import attachments first, obtain their absolute entries with a query on table ATC1 and only then import activities, referencing theses absolute entries in the "AttachmentEntry" column?

Or is there a simpler solution?

[ladislav_meszaros · Accepted solution]

Hi Emmanuel,

The column AttachmentEntry in the oContacts object sets or returns the identification key of the attachment file, as assigned by SAP Business One when adding an Attachment Entry.

The field name in Business One is AtcEntry.

Since the attachments object is not directly linked to the contacts object (activities) you will have to do the following:

1) Import the attachment with the oAttachments2 object in DTW

2) Run the query 'SELECT * FROM ATC1' to find the attachment entry of your attachment.

3) Enter in the column AttachmentEntry in the template oContacts the value from the AbsEntry (Absolute Entry) column from the query in step 2.

4) Import or update your oContacts

hope it helps,

Regards,

Ladislav

SAP Business One Forum Team

[Former Member]

Thanks for your reply, Ladislav.

It's a pity there's no simpler solution.