Form Name: Blobber Form for Binary Large Objects (BLOBs)
File Name: EarthSoft.Forms.Library.78163.dll
Software: EQuIS Professional
Source: Available for the EarthSoft Primary Point of Contact (POC) on the EarthSoft Community Center downloads dashboard > Products > Additional Resources > v7.0
Description: The EQuIS Blobber Form is a form that allows download or update of Binary Large Objects (BLOBs) to an EQuIS database.
Installation Instructions: Download the Blobber Form from the EarthSoft Community Center, unblock the *.zip file, and extract the DLL to the EQuIS Professional installation folder. For default installations this directory is C:\Program Files\EarthSoft\EQuIS. The form will be available for selection once Professional has been relaunched.
1.Open the Blobber Form for Binary Large Objects (BLOBs)
2.Select a table from the drop down list
3.Enter the primary key value for the BLOB record (i.e. ST_REPORT.REPORT_ID, DT_FILE.FILE_ID, etc.)
After selecting the table and primary key value, the blob can be downloaded, updated or set to NULL.
Download a BLOB
When downloading a BLOB you will need to specify the location, file name, and the file extension. After downloading, the file will automatically open.
Update a BLOB
Click the Update button; you will be prompted to select a file. After a file is selected, the BLOB will be replaced in the database. Some tables (e.g., DT_FILE) may need other fields associated with the BLOB updated manually (e.g. FILE_NAME, FILE_TYPE, etc.). When updating a report *.dll (i.e. ST_REPORT.ASSEMBLY), EarthSoft recommends that you first download the existing *.dll (use Download button) and save it in case you need to restore that *.dll at some point.
Set Null button
The Set Null button will delete the BLOB by setting the corresponding field equal to null (e.g. "UPDATE ST_REPORT SET assembly = NULL where REPORT_ID = 9999"). Set Null will not delete the record or affect any related records. Deleting the BLOB is useful for dll reports that have been published to the database. Publishing a report is needed for the report to show up in Enterprise EZView. Deleting the BLOB will force Enterprise EZView to use the report dll in the executable directory.
Copyright © 2020 EarthSoft, Inc • Modified: 28 Apr 2020