Import invoice images/PDF

shakeel_viam1 · January 22, 2022, 10:03pm

https://support.google.com/docs/thread/16362151/get-names-and-links-for-multiple-files-on-google-drive?hl=en

pgr · January 24, 2022, 7:55am

Thank you @shakeel_viam1 for your message!

Does erpnext then import the files from google drive, or just save the URLs?
I previously tried to import the URLs, but that only led to persistence of the URLs (and not the download of the files into erpnext)

Uncle_Dead · January 25, 2022, 3:15am

Make a text editor field, name it invoice image ect.
Use a screenshot tool to capture pdf
I use a tool called fireshot it is a chrome plugin. Then paste the image into the field. Add the field to your print format and then you can view/print it inline.

pgr · January 25, 2022, 8:34am

and how can I import it on mass with a csv?

shakeel_viam1 · February 3, 2022, 4:15pm

You have to put the URLs in the template and upload

pgr · February 3, 2022, 11:03pm

Sure, it simply attaches the URL then (and doesnt download it), whats logical, but not what we need, if we want to shutdown the old assets.

shakeel_viam1 · February 3, 2022, 11:15pm

Shut down the old asset as in?

pgr · February 4, 2022, 8:07am

I mean the system, on which those images/pdfs are located.
So the goal is to migrate them into ERPNext… not just the URLs.

shakeel_viam1 · February 5, 2022, 8:43am

You have to upload all the images into a folder in Google Drive. And make URLs of all the image files, paste the URL into the relevant field in the template from Erpnext and upload it.

pgr · February 5, 2022, 8:54am

Thanks again for your suggestion, I was still asking, if erpnext will then import just the urls, or if it will get downloaded.

I think, we’ll in the end build a simple script to iterate the invoices and post them with several curl commands to the api.

shakeel_viam1 · February 5, 2022, 9:16am

Once it’s migrated to ERPNEXT you can download it to ERPnext through the link

shakeel_viam1 · February 5, 2022, 2:10pm

I can assist you if we can connect 1-1

pgr · February 7, 2022, 9:40am

No worries, but thanks. I didn’t have a drive integration yet, and so far, I am still not sure, that the files will get downloaded into ERPNext .

This is not enough, it needs to be located IN ERPNext.

However, as I already told, before making it complicated, I’ll just use the API with curl

➜ curl -X POST \
  http://<base-url>/api/method/upload_file \
  -H 'Accept: application/json' \
  -H 'Authorization: token xxxx:yyyy' \
  -F file=@/path/to/file/file.png

(from REST API)