Solved

Storing files in FM Database

Posted on 2006-10-24
5
303 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 28

Accepted Solution

by:
lesouef earned 250 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
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…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

726 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