I am trying to use “Open DB feature” to import or insert some data but i still have some problems and error like:
“permission denied for schema public”
As i understand this is PostgreSQL database. How to het permissions for this?
–
Thanks
You can’t export or import data directly from/to OpenDB
You can export data this way:
as i see there is an option for import data, but i still have an error “permission denied on schema public”.
how to increase your privileges?
thank you
You can’t import data directly in OpenDB. You can make BP to read excell/csv files on backend
Also you can past raw SQL into DB Editor to execute query and import your data
yeah, i know, but still i have some problems because many thinks look different on tutorial and documenatation. Could you pls guide me a bit?
i make BP and Entpoint and trying to use “File Uploader” and “Smart Button” to upload a csv file to Endpoint after button clicking, but i don’t know which components should i use to Post scv file to BP
You need to upload file to your database and get ID of this file
Thin is an example and you need to connect ID from final block with csv input in your endpoint
hmm, but on my computer it looks differently, i am unable co connect output “Element” in “Array element” Block to input element (“csv” file) in “Server Request POST” endpoint block.
Is there any accurate and up-to-date instruction ?
thanks
Element has Model value type, csv has file id value type. You can expand model, boubleclick it