How to add images in bulk from excel in ERPNext on FrappeCloud on Windows10

Rana_Saheb · July 21, 2021, 5:23pm

can someone pls help me on this
i tried to do it this way

–in (Image) column of excel sheet from (data import tool) i pasted the Hyperlink* of image for that particular item, i did this for tens of items and as expected everything got imported except IMAGE, now i am doing this ONE by ONE…

Hyperlink* - C:\Users\rana_saheb\Desktop\My products\Stationery\Doms\DOMS_X1_Pencil_Kit.jpg

Muzzy · July 21, 2021, 5:39pm

Are you trying to set image to Items? If yes then try this script. Image file name should match item name. Images should be uploaded vif ERPNext file upload not from backend which doesn’t set image url.

gist.github.com

https://gist.github.com/Muzzy73/c7262cff187a09672c8e8d2983f53d23

image_script.py

import frappe
def execute():
    files = frappe.get_all(
        "File",
        filters={"is_folder": 0},
        fields=["name", "file_name", "file_url"],
    )

    for file in files:
        fname, fext = file.get("file_name").split(".")

This file has been truncated. show original

Rana_Saheb · July 21, 2021, 5:47pm

But i want a solution for Fcloud Hosting not Local Hosting and i am using Windows 10 btw tnx

revant_one · July 22, 2021, 1:35am

Use ReST API to set images in local pytht script that runs on your windows laptop.

You may have to check the rate limit from frappecloud

miso.reynaldoartuz · December 12, 2024, 7:34am

how to run this script base on naming series 0001 to upload to image 0001.jpg and so on.

10k image to be upload ty

Muzzy · December 12, 2024, 7:09pm

@miso.reynaldoartuz The code was built to set image to an item. Hence the image name and item name was kept same.

the script was made by @iRaySpace. Not sure if he is still around the forum. Maybe he can assist if you engage him on paid basis.