Importing image to stock item
Any experience of how to create an import scenario where we want to import the item image to stock items?
Is it possible to, for exampe, in an column in the Excel data provider, have a column that contains the path/URL to the image on my computer, where I run the import(notice that I'm using SaaS, not locally installed)? So basically the URL/Path would correspond with the path I would select if I would upload the image from my computer manually to the stock item(Attributes-tab).
I tried with having a Excel file with column 'ItemID' and 'Image URL', where the 'Image URL' contains the path on my computer. Example: C:\Users\Matt.Example\Desktop\image.jpg
The Import scenario was built like this:
But when I run the import, the image isn't added to the item. Any ideas?
I am also interested in a solution for this. I tried converting my images to numeric values (which Acumatica supposedly accepts), but the length of the numeric field exceeds the character limit in an excel cell. I am currently having someone drag and drop hundreds of images into the system. I saw someone mention using REST, Flow, and OneDrive, but that's quite a hassle. Surely there's a native solution.
Link to other post:
Thanks for linking to that post Michael. As I mention in that post, I was able to do something like this with Microsoft Flow and the Acumatica REST APIs.
It's still on my list of things to blog about.
Unfortunately though, Microsoft Flow stopped working with Acumatica about a month ago. For more info, click here. Apparently it was never supported, but somehow it was working before it broke about a month ago.
I've heard a rumor that Acumatica might show something with Microsoft Flow at the upcoming Acumatica Summit. Of course, they would have to get it working again to do that so maybe they can pull some strings with Microsoft 🙂
Update (January 29, 2019): Acumatica is now working with Microsoft Flow again (click here)
Thanks for the replies! Based on the answer I conclude that this is not possible through a Import scenario, so I think I'll just do the upload manually to the items for now.
I should mention that I don't know for sure that it's not possible through an Import Scenario. I just personally don't know how to do it.
We asked Acumatica this question a while back. Got an answer but never tried it. I have attached the KB article they shared with us.
Supposedly, it can be done, but you need to convert the images to base64 string format with a 3rd party utility first and then use the import scenario from the article to import them.
Hope this helps someone.
If you try it, let us know about your battle scars.
An alternative might be to use a SQL Data Source. You should be able to get around the Excel data limitations there.
I am working on a new implementation where the images are stored in an SQL Server database on an items table and the fields is stored in a "varbinary' field type.
Any ideas on how to import these images in through an import scenario ?
Take a look at the Word document that @dws253 posted above. I could see how his later suggestion to use a SQL Data Source to get around the Excel limitation might work. I just haven't tried it. But it sounds like you're in a perfect position to try it @alex-kleyff. Does the Word document make sense?
One more thing here is the link to the command in SQL to convert varbinary field to base64 in case someone needs it.
Sweet! Thank you so much for sharing this information @alex-kleyff. I have had a number of people ask me about this so I'm glad to see someone finally do it.
If you have a folder which a bunch of image files, do you think it would be reasonable to rename the file names to match the Inventory ID that they should be loaded into? If so, I think Microsoft Flow would be a great way to get them in.