Question

Bulk import of contact photos

How can I do a mass import of image files for Contact records?

Like 0

Like

5 comments

Dear Lisa,

Unfortunately, there is no option import images since they are stored in different table, not in Contact 

Theoretically, you can upload the images encoded to base64 format into the SysImage table and then populate the pictureid column of the product with the id of the corresponding image. This process might be time consuming and not convenient, since it should be done on the database level.

We will register the idea for our R&D team to develop such a functionality that would allow to upload images in more convenient and faster way.

Best regards,

Dean

Dean Parrett,

Any news about this feature?

Dear Daniel,



The mentioned development request was considered by the responsible R&D team but it's implementation was postponed due to the fact there are requests and plans with higher priority. 

I will add your comment to the created request so they could take a look on it again and consider the possibility of implementing it in the next upcoming releases. 



Kind regards,

Roman

Roman Brown,

Hi Roman. We have a similar use case where we need to migrate photos and going via the Database is not an option for us.



I was looking into the 0/ImageAPIService/upload which is used by the platform internally when a Contact photo is uploaded. Can we use this API to upload an image into the SysImage table?? Few related questions below - 



1. I notice a few query parameters - fileapi, totalFileLength, fileId and mimeType. If we were to replicate this request via code, Which of these are mandatory and which are optional? 

2. What does the query parameter "fileapi16123676529964" refer to? And what is that number??

3. Believe the unique Guid() for the SysImage record is generated on the client side and gets stored in the Id column in the SysImage table. Is this right?

M Shrikanth,

 

Hello,

 

Let's discuss this question in a separate community thread you've created here https://community.creatio.com/questions/import-photo-image-imageapiserv…

 

Best regards,

Oscar 

Show all comments