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