order of hosted filemaker files in filemaker server

#Order of hosted filemaker files in filemaker server serial#
#Order of hosted filemaker files in filemaker server manual#
#Order of hosted filemaker files in filemaker server pro#

Rename the 'gallery photo' / main product photo to match the integer ID PK on the inventory table so that the external-storage container loads the correct photo from the network share.

Move them to a folder on our network storage.

Load photos from the camera (an iPhone or iPad).

#Order of hosted filemaker files in filemaker server manual#

This will cut down on so many steps of manual rework.Ĭurrently, our main inventory database does use external-storage container fields. The project I'm working on now, is to bring the identification / documentation / photograph stages into FileMaker, so that our database can act as the system of record for the entire process. The physical piece of paper then acts as a sort of token to control the status of the inventory listing until it's been completely loaded into the system this process involves a lot of manual steps, many of which are around managing product photos.

#Order of hosted filemaker files in filemaker server serial#

Our current workflow is all paper-based until the inventory item is through the cleaning / identification / documentation / photograph stages - employees will write down make / model / serial / etc, take photos, write down the range of image filenames on the camera, and send it to the office when that process is complete. These parts have to be cleaned, identified, documented, photographed, inventoried, and priced. Our business is in the used industrial manufacturing equipment space we frequently buy injection molding machinery that's for parts / not working and break it down for parts. I'm going to give it some time to see if some sort of maintenance task kicks in after a given period of inactivity.

Verified that there were no other open connections.

Created a Container field on the default database.

fmp12 filesize reasonable, and I don't want to have to manually intervene. For reasons that are too boring to detail but that are otherwise sound, we want to keep our. What I am concerned about, however, is unchecked file growth without a good system in place to automatically prune things back from time to time. When we take this system live, records are going to be deleted one-at-a-time, not en masse, so I'm not terribly worried about things going wrong during a bulk delete. If FileMaker Server doesn't do this automatically - if I run fmserver restart, does it close the database connections gracefully? I could just run that nightly on the host machine and everything would probably be fine.

Filesize did not change appreciably (still read as 40 GB).

I imported about 30 GB of photos, one photo per record.

I created a table in a local file with a text field for a filename, and a Container field for a photo, with the Container field set to store the photo data in the record (i.e., not as a reference).

fmp12 file until I close the application - it may add some sort of soft-delete flag or something, but it doesn't actually reduce the filesize of my database until I close the application.ĭoes FileMaker Server manage this automatically?

#Order of hosted filemaker files in filemaker server pro#

I've been doing some tests locally, and I've noticed that the FileMaker Pro Advanced application doesn't remove deleted data from the.