Clew ONLY | How Can We Import Attachments and Links?

Modified on Thu, 10 Sep at 4:54 PM

Internal only: importing attachments and links

Why attachments and links are not part of a standard data import, and what to tell customers who ask

Internal only: This article is for the Clew team, not the customer portal. It describes how attachments and links are handled during a data import so support can answer the question. Do not publish it to the public knowledge base.

Contents


1. Introduction & Context

Data imports work the same way for most record data. Attachments and external links are the exception. They are files and URLs rather than field values, so they do not travel through the standard import route and cannot be loaded from a CSV alongside everything else.

There are two ways they get into the system. In bulk, they are imported by development using a script. Individually, a user adds them on the record itself, through the Attachment and External Links panels.

Who is it for? Support and implementation. Use it when a customer asks whether their attachments or links can come across as part of an import.

What does it impact? Import scoping, timelines and cost. A bulk attachment import needs development time, so it is normally scoped as a separate piece of work and is usually chargeable. Identify it early rather than at the end of a migration, so the customer is not surprised by either the delay or the cost.


2. Key Features & Functions

RouteWho does itWhen to use it
Bulk import via scriptDevelopmentMigrations, or any volume of files large enough that manual upload is not realistic.
Attachment panel on the recordThe customerOngoing day-to-day use, and small numbers of files. Several files can go up at once.
External Links panel on the recordThe customerPointing at a document held elsewhere rather than uploading a copy.

3. Requirements

For a bulk import, development needs three things. Gather all three before raising the request, because a partial set is the usual reason these stall.

  • A list mapping each attachment or link to its record, so the script knows where everything belongs.
  • A folder containing the actual attachment files, with names matching the list.
  • Development time to run the script. This is not self-service. It is normally scoped as a piece of work and usually carries a cost, so it needs agreeing with the customer as well as scheduling.

For a customer adding files themselves, all they need is access to the record and permission to edit it.


4. Step-by-Step Guide

Importing in bulk, via development

  1. Confirm with the customer how many attachments and links are involved, and which records they attach to. Flag at this point that a bulk import is scoped as a piece of work and is usually chargeable.
  2. Ask them for the list mapping each file or URL to its record, and for a folder containing the files themselves.
  3. Check the list and the folder agree with each other before passing them on. Missing files and unmatched rows are what send the job back.
  4. Raise the request with development, who will run the script.
  5. Spot check a handful of records afterwards to confirm the attachments landed on the right ones.

Adding an attachment to a record

This is the route a customer uses themselves, and the answer to give when the volume is small enough not to need development.

  1. Open the record the attachment belongs to.
  2. Scroll down to the Attachment panel.
  3. Click Add on the right-hand side.
  4. Select the file, or several files, to upload. Multiple files can go up in a single action.
  5. Add a description if you want one. This is optional.
  6. Click Save.
  1. Open the record the link belongs to.
  2. Scroll down to the External Links panel.
  3. Click Add on the right-hand side.
  4. Enter the Title of the link. This is what people will see on the record.
  5. Add a description if you want one. This is optional.
  6. Enter the full URL, including https://, for example https://www.clew.io.
  7. Click Save.
Note: The URL has to be complete. A link entered without https:// will not work properly.

5. Common Issues & Troubleshooting

IssueLikely CauseSolution
A customer expects attachments to arrive with their CSV importAttachments and links are not part of the standard importExplain the two routes, and scope a development import if the volume warrants it.
A bulk import request is sitting with development and not movingThe list, the files or the mapping between them is incompleteCheck every row in the list has a matching file in the folder, and every file has a row.
A link on a record does not openThe URL was entered without https://Edit the link and enter the complete URL.
Attachments landed on the wrong records after a bulk importThe mapping list was keyed on something that is not uniqueGo back to development with the corrected mapping. Agree the key before the script runs next time.

Best practices:

  • Ask about attachments and links at the start of an import conversation, not the end. They are the part that needs development time, and the part that carries a cost.
  • Agree the record key in the mapping list up front, and make sure it is genuinely unique.
  • Reconcile the list against the folder before handing anything over. It saves a round trip.
  • Where the volume is small, show the customer the Attachment panel instead. It is quicker than scoping a script.
  • Suggest links rather than uploads where the document already lives somewhere the customer maintains.

▾CSV ImportsOpen full article »

Related article

The standard import route for record data, which covers everything except attachments and links.

▾Universal Imports & ExportsOpen full article »

Related article

How data moves in and out of the platform generally, for scoping what a migration can and cannot cover.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article