Import Documents
The SISfm page space/fileDbMigrate.aspx is available for migrating photos and other documents from the SISfm file system to the facility database.
The querystring parameter type=facility specifies migration of facility photos and documents from the DataFolderPhoto folder into database tables docs_assigned, sisfm_docs and sisfm_docvers.
The querystring parameter type=asset specifies migration of asset photos and documents from the DataFolderAsset folder into database tables docs_assigned, sisfm_docs and sisfm_docvers.
This page is for use in a logged in SISfm session.
Following is an example of this page:
Migrating photos/documents to the facility database
Processing database folder C:\inetpub\wwwroot\SISfm\test\assets\0
Processing table folder C:\inetpub\wwwroot\SISfm\test\assets\0\eq
C:\inetpub\wwwroot\SISfm\test\assets\0\eq\EQ54322_1.jpg migrated
C:\inetpub\wwwroot\SISfm\test\assets\0\eq\EQ54323_1.jpg migrated
Following are other messages that may occur:
You must be logged in
Querystring parameter type=facility or type=asset is required
DataFolderAsset setting folder does not exist
DataFolderPhoto setting folder does not exist
Processing site folder folder
Database folders other than '0' are for assets not stored in the facility database - not migrated
Field docs_assigned.table_id does not exist - not migrated
Field table.table_id does not exist - not migrated
filename has incorrect name - not migrated
filename has no matching database record - not migrated
filename is already in the database - not migrated