How does Rollbase handle the import of files in BLOB format? Comparable Binary Large Object variables are not listed in these Object Field Input options: 'TextInput', 'TextArea', 'CheckBox', 'CurrencyInput', 'DateInput', 'DateTimeInput', 'DecimalInput', 'EmailInput', 'IntInput', 'PercentInput', 'RadioButtons','CheckBoxesGroup', 'SelectList', 'SelectListMultiple', 'URLInput'
We treat BLOBs as files. You can create File Upload field, than populate it by uploading actual file or sending binary data through API.
Pavel, Thanks for timely response. Our API is in progress. At this time and not passing any blob data (of MSWord/PDF/etc files) into any object... we simply synchronize the Excel/CSV import of a file and map it to an object and ...the error "Import error: Field "Document File" must have a value" ...occurs - yet 'Document File' is not a field into which any data can be mapped when doing an 'Import'. Are there any work-arounds during an Excel/CSV import to perhaps load the BLOB as a file upload when exporting a schema? Please advise. Thanks, David
It looks like your File Upload field has "Required" attribute set. But we do not provide import of BLOBs through spreadsheet imports. So I suggest you simply remove this attribute (can keep it on page level, if you'd like to).
Hi David,
As Pavel suggests, you can edit this File Upload field and uncheck the "Require this field on all forms" property.
1. Login and Go to Setup > Applications Setup > Objects ... and find the object this field is part of.
2. Click on that Object to view it.
3. Scroll down to the "Fields" section and find the field called "Document File"
4. Click "Edit" next to that field
5. Uncheck the "Require this field on all forms" property
6. Click Save
The API will no longer require this field.
Hope this helps,
Matt