By using this website, you agree to our Terms of Use (click here)
Hi
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:
https://www.augforums.com/augforums/everything-else/bulk-import-for-product-images/
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)
Hi
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.
That is what I tried, but the base 64 encoding creates a larger value than a single cell in Excel can hold. You can find the encoders online for free. If someone knows how to store this elsewhere without the restriction in excel, I'd be pleased to hear it. Maybe making a pure CSV file that you edit in something like Notepad++??? I've not tried editing a CSV by hand, but it should be relatively simple. However, I feel the time it took me to encode the images and then create the file would be greater than the time to drag and drop those images in directly.
An alternative might be to use a SQL Data Source. You should be able to get around the Excel data limitations there.
Hi Everyone
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?
Yes I did read it our issue was that the image was in varbinary field and not base64, did a little research and found the command to convert in sql to base64 into a new text field and we were able to successfully import the images last night
I found that if you have the pictures in actual individual files is a little more challenging, I wish there were more examples on how to convert to base64 and import into excel each individual file without having to do one by one specially if a customer has over 10k items, I got lucky this time because they where already in a table , also found that the suggested website and app in the document both have you convert one image file at a time and not in batch for an entire folder. But I guess I cross that bridge whenever I encounter a client with that situation.
Thanks for the quick response.
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.
Online Members
