Dealing with Attachments that have Duplicate File Names

It is a possibility that one or more attachments to Topics, Posts, Tickets or Ticket Comments can have a duplicate file name, but actual contain a different source.

The Zendesk Migration Utility supports the ability to import multiple attachments with the same file name without overwriting each one whilst maintaining the name of the file in the target Zendesk database by making use of "AttachmentId's".

Create an AttachmentId within the Attachment CSV File Template

1. A new "AttachmentId" column must be introduced to the CSV Template used to import the attachments and a unique id specified as the value in this column for each attachment .
2. In this example the "Ticket #" column is used to identify the unique id of the Ticket to which the attachment belongs.
3. When using the AttachmentId, the file name is used as the name of the attachment once the information has been imported, but is not used to identify the file on the file system.

Reconcile ID's with Corresponding Files on the Files System

1. The files to be used as the attachments should be renamed accordingly in the zip file on your file system to correspond with the AttachmentId's in the CSV template.

So in this example there are 2 files named "mini.jpg", both of which contain a different picture content. The first has been renamed "1000001" and the second renamed as "1000002" on the files system and these names have been referred to as the values in the AttachmentId column in the CSV template.
However, once the import has successfully complete both attachments will be created with the name "mini.jog" in the target Zendesk database.

• media_1328798031091.png
• media_1328798516305.png