?
Solved

Storing files in FM Database

Posted on 2006-10-24
5
Medium Priority
?
304 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 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: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

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

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…
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…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month14 days, 22 hours left to enroll

770 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