πΈImport Excel with Image
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.
Excel with the Image Import feature is available in the Scale plan only! Feel free to reach out in case you want to try it out!
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 keep column type as Image
and importer will be ready to import images.
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.
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
.
Once selected click on Map Columns
.
3. Do 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.
Click on Re-Review Data
to complete the import, once all records are valid.
5. Complete Import
6. Get Imported Data
Imported data will be sent to a webhook with an endpoint to download and access the uploaded file.
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,
Have any doubts? Shoot us a message directly on Discord.
Last updated