Q. How do we not sync some attachments
A. By default, all attachments are synced. If you don't want specific attachments synced then the attachments need to have a common word in the name. So, the attachments need to have a specific word in the name. So, if all of the attachments have a word like "Plan" for like floor plans. Then those would not be synced. You could also rename attachments in Firehouse that you don't want to be synced and use a common word like "Ignore" or whatever word or number works for you.
For 5.0 Clients: In order to ignore certain attachments from the database you need to open FH Converter from your task Bar. Then click the Configure link. Click on the tab Pre-Sync Scripts and then click "6. Ignore Syncing attachments that have a specific word in the name." Then in the box below that put in the word you want to ignore. If these attachments have already been synced and you want to remove them, click the "3. Delete all attachment records from the database." Then click "1. Remove the last Sync date." This will force a full sync and the attachments will be redownloaded and it will now sync the attachments that have your specific word.
For 4.0 Clients: In order to remove the occupancy data from the database you need to open SQL Management Studio and right-click on the FH_Mobile DB then choose New Query. In the query window paste the script and choose execute. This will need to be done once per device. The following script will delete all attachments from the FH_Mobile DB, clear the last Sync date and add the option of the word not to sync. Replace the word in red below with your word or number. Then do a sync after this has executed.
DELETE FROM fh_mobile.dbo.sys_mset WHERE Setting = 'LastSyncTime' and Module = 'Global'
DELETE FROM fh_mobile.dbo.SYS_MSET WHERE Setting = 'IGNOREATTACHMENTS' AND Module='ADASHI'
DELETE FROM fh_mobile.dbo.SYS_MSET WHERE Setting = 'ATTACHMENTIGNORENAME' AND Module='ADASHI'
INSERT INTO fh_mobile.dbo.sys_mset (PK_SYS_MSET,Module,Setting,Set_Val) VALUES ( NEWID(), 'ADASHI', 'IGNOREATTACHMENTS', 'True')
INSERT INTO fh_mobile.dbo.sys_mset (PK_SYS_MSET,Module,Setting,Set_Val) VALUES ( NEWID(), 'ADASHI', 'ATTACHMENTIGNORENAME', 'IGNORE')
DELETE FROM FH_MOBILE.dbo.ATT_FILE;