Solved

Storing files in FM Database

Posted on 2006-10-24
5
298 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
5 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 250 total points
Comment Utility
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
Comment Utility
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
Comment Utility
no, this is correct.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

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…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

763 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now