Improve company productivity with a Business Account.Sign Up

x
?
Solved

Storing files in FM Database

Posted on 2006-10-24
5
Medium Priority
?
307 Views
Last Modified: 2010-04-27
I had earlier inquired about inserting files in FM DB, see link below.

http://www.experts-exchange.com/Databases/FileMaker/Q_21872743.html

The following was suggested:

*****
This problem can be alleviated by using a check-out//check-in system, where the user "requests" to export the document, and it is then flagged as "locked", so no other users can access it until the first user finishes with it and replaces it. This is a bit more complex to set up, but it's not unreasonable, it just requires some scripting of the user interface.

The biggest problem with storing the files in the database itself is how much this will increase the size of the database files and affect performance. If the files are mostly small, it may not be a problem, but if you're dealing with huge desktop publishing files, for example, it's probably not worthwhile.

*****
I'm not worried about increasing the size of the database since it will only host files for open/active jobs (not more than 100 word or pdf documents).  I'm looking for help with the "check-out/ check-in system" described above.

Thanks.

0
Comment
Question by:davidatlamont
  • 2
3 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 1000 total points
ID: 17797527
If you intend for instance to let the user open the file by clicking on its name, just modifiy the image box as a button which changes the flag "busy/locked" and then opens the file. If the flag is already busy, then issue a msg saying it is... You then need another kind of validate button to reset the flag for further use. But why do you need this?? If the file is in a media field, it will be locked if somebody opens it anyway, as it does with any field.
0
 

Author Comment

by:davidatlamont
ID: 17797706
Let me state the basic need.  I have a job db that I would like to be able to add job materials (normally a word or pdf document) to so that various users can acess/edit while maintaining version integrity.  My understanding was that I should use a Container field to store the file (I want the actual file stored and not just a reference).  Am in confused?
0
 
LVL 28

Expert Comment

by:lesouef
ID: 17798552
no, this is correct.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
If you are looking for an automated solution for backup single or multiple Office 365 user mailboxes to Outlook data file, then you can use Kernel Office 365 Backup & Restore tool. Go through the video to check out the steps to backup single or mult…
From store locators to asset tracking and route optimization, learn how leading companies are using Google Maps APIs throughout the customer journey to increase checkout conversions, boost user engagement, and optimize order fulfillment. Powered …

607 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question