import-excel-with-image.md

icon	description
images	Impler allows importing data files with images. Image import is useful in scenarios like Employee data with profile photos, Products with images, or Assets with pictures.

Import Excel with Image

{% hint style="info" %} Excel with the Image Import feature is available in the Scale plan only. Feel free to contact us if you want to try it out! {% endhint %}

How do I enable Image upload in Import?

The first step for image import is to add or update a column with the Image type. In case providing runtime-schema.md keep column type as Image and importer will be ready to import images.

Add Column with Type Image

How does Image Import work?

Once the import is configured to import data with Image. We can start importing data with Images. Here is the image import flow,

1. Generate a Template with Images,

The first step is to upload all images and generate a template with uploaded image names. All columns with the type Image will appear in Select Column dropdown and Uploaded images will be shown below Upload Image section.

Once all image files are selected, click on Generate Template to generate an Excel file holding the names of all uploaded images.

Upload Images and Generate Template

2. Upload Excel with data and image names.

Clicking on Generate Template will download an Excel file and Importer will move to the Upload section. You can enter data in the downloaded Excel file and select image names for image columns.

It's possible to generate a template again by clicking on Generate Template.

Upload data file with image cell values

Once selected click on Map Columns.

3. Do mapping for columns

Do and verify mapping for columns

Click on Review Data to verify data getting imported.

4. Review Data

The review step checks if image columns contain the name of the uploaded image. If not shows a validation error.

Review data getting imported

Click on Re-Review Data to complete the import, once all records are valid.

5. Complete Import

Data Imported Confirmation

6. Get Imported Data

Imported data will be sent to a webhook with an endpoint to download and access the uploaded file.

Import Webhook Response

7. Download or Access the uploaded file

The download file endpoint is secured using accesskey which is available in Settings section on the left side. Here is the CURL for a review,

{% code overflow="wrap" %}

curl --location --request GET 'https://api.impler.io/v1/upload/66b759d087a854c817cd3e98/asset/logo-icon.png' \
--header 'accesskey: <ACCESS_TOKEN>'

{% endcode %}

{% include "../.gitbook/includes/your-feedback-is-crucial-in....md" %}