How does Rollbase handle the import of files in BLOB format?

Posted by Rollbase User on 04-Jun-2010 10:29

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'

All Replies

Posted by Admin on 04-Jun-2010 10:34

We treat BLOBs as files. You can create File Upload field, than populate it by uploading actual file or sending binary data through API.

Posted by Admin on 04-Jun-2010 16:18

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

Posted by Admin on 04-Jun-2010 16:42

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).

Posted by Admin on 02-Jul-2010 14:14

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

This thread is closed