Page 2 of 2
Re: problems with uploading Files (uppy)
Posted: Thu May 16, 2024 10:09 pm
by databs1234
I've tried this for an file object created and after I upload the file it disappears, I'm using the above code for one file as well as created a database field as a blob. Is there something I'm missing? Thanks.
Re: problems with uploading Files (uppy)
Posted: Fri May 17, 2024 9:43 am
by kev1n
Is your question related to uppy?
Re: problems with uploading Files (uppy)
Posted: Wed May 29, 2024 3:25 pm
by databs1234
I'm not certain, I have set up a file object, when I upload a file and click save, the file is no longer there and I can't see the file on the database side.
Re: problems with uploading Files (uppy)
Posted: Wed May 29, 2024 3:28 pm
by kev1n
Uppy only upload files to the file system, not database.
See Input -> Target:
2024-05-29_152749.png
Re: problems with uploading Files
Posted: Thu Jun 06, 2024 12:46 am
by databs1234
This was an capability is MS-Access, it was called an OLE there. When creating a form in nubuilder, there is an object option called FILE:
Screenshot 2024-06-05 174223.jpg
In MYSQL it's called a BLOB. I'm wanting to upload word or pdf files into the database for storage. I've set up the object as a file / database and set up the MYSQL as a BLOB. Is there anything else needed? If there is a better way to do this please let me know.
Thanks
Re: problems with uploading Files (uppy)
Posted: Thu Jun 06, 2024 11:32 pm
by kev1n
The Input/File Object, is designed for straightforward file uploads such as photos and pictures etc.
However, since files are converted to JSON, this method is impractical for storing larger files (over 300 KB) due to slow upload times as file size increases.
For larger files, it is recommended to use Uppy and store the files on the file system, or develop a custom upload script capable of handling files exceeding 300 KB.
Re: problems with uploading Files (uppy)
Posted: Tue Jun 18, 2024 9:28 pm
by databs1234
files would be word or pdf, sizes would always be under 300k, the same issue existed with access, larger file sizes had to use a more complicated method, the OLE could handle small doc and pdf file. is there something I need to do to get a word doc or pdf to upload and store? when I select the file and upload it is not there in the nubuilder form or in the back end when I check the database. thanks.
Re: problems with uploading Files (uppy)
Posted: Fri Jun 21, 2024 11:04 am
by kev1n
The Files form shows how to upload files to the database.
You can view the source code to see how it is done.