This is a public Forum  publicRSS

Forum post

    alison brownlee
    opening word doc file in a container
    Forum post posted October 14, 2012 by alison brownlee 
    215 Views, 3 Comments
    Title:
    opening word doc file in a container
    Post:

    i'm new to using Filemaker pro 12 - I know how to insert a word doc file into a container but i can't see or work out how to open that file in filemaker database. It just says the file name and nothing happens when i click on it. I am using the database to keep records of applicants and i want to be able to insert their cv into a container - and then be able to open it from the database - I also don't seem to be able to store more than one thing in a container - do i have to have separate containers for each file or pdf that i want to store?

    Hope someone can help

    alison

    Answer

     

    • DavidAnders

      Google "filemaker container youtube"
      https://www.google.com/search?q=filemaker+container+youtube

      https://www.google.com/search?q=filemaker+container+site%3Afilemaker.com

      Home > Using FileMaker Pro > Adding and viewing data > Using data in container fields
      http://www.filemaker.com/12help/html/add_view_data.4.34.html

      FROM  http://forums.filemaker.com/posts/696f6bd798

      I'm guessing that you are using Filemaker 12.

      If the files are inserted into a container field with Insert File and the "store a reference" option specified and the container field object on your layout is NOT optimized for interactive content, you can double click the container field to open the document in the OS system's specified default application for that file type. After editing and saving changes, they will be retained as your container field no longer embeds a physical copy of the file, it stores the filepath to the actual file instead.

      The main issue for you is that drag and drop does not insert the file with "store a reference", it embeds the file instead. Here are two options for handling that issue: 1) A script could be used to export the file to a specified directory and then re-insert it into the container field with the Store a reference option. 2) It's also possible to write a script that exports your embedded file to open it at a specified location and then a second script can use the same file path and name to re-insert the file. You can add a button to your layout labeled "Save Changes" or some such to accomplish that trick.

      Note that some storage options and data formatting optimization options (fileMaker 12) keep the double click from opening your file so you may have to go with the second option. Also, the "Optimize for interactive content" option does not work for container fields in a portal so if you need that feature, we may have to get a bit creative to make that aspect functional in conjunction with your portal.

       

      FROM   http://forums.filemaker.com/posts/2d7813df51

      There are key details, however, that can keep a file from opening when it is inserted into a container field:
      1) It must be inserted with the "store a reference" option.
      2) It must be inserted with the Insert File menu option. For reasons unkown, this doesn't work (Not in 12, not in earlier versions) if Insert Picture were used to insert the file into the container field.
      3) With FileMaker 12, you have a new limitation in that the container field cannot be optimized for interactive content.

      If you do not select "store as reference" you cannot open the file by double clicking the container. This is true for earlier versions of FileMaker as well as version 12. When you double click the container, FileMaker passes the location of the file to your computer's operating system and causes it to open the file. If you do not use Store a reference, there is no file path to send to the operating system. (But this doesn't explain why "store a reference" files inserted as a picture cannot be opened--never have figured out the why to that limitation.)

      Files inserted with the store a reference file have to be stored on the server and inserted from there. They must be located in a folder that is shared and accessible to all clients that need to see/open that file with the same file path stored in the container file. This requires mapping/mounting the shared folder with the same filepath as that used in the container file.

      It often helps to set up a script where a file is first inserted without the store a reference reference and then the script uses export field contents to export the file to the shared directory and then re-inserts it with the store a reference option from that shared location.

      It's also possible to open any file inserted into a container field by all of these methods if you use Export Field Contents to export a copy of the field to a specified location on the user's computer--such as the temporary items folder. The main limitations to this approach is if the user needs to open the file, edit it and then save the changes back to the copy in the container field, the edited copy on the user's computer would have to be re-inserted after the edits are made and saved.

       

      http://www.filemaker.com/11help/html/create_db.8.2.html#1027557
      Home > Designing and creating databases > Creating a database > About planning a database
      A well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.

      Follow these general steps to plan a database:
      <SNIP>

      http://help.filemaker.com/app/answers/detail/a_id/3248/related/1
      Relational Database Design 101 (part 1 of 3): Designing a Flat File Database


      http://help.filemaker.com/app/answers/detail/a_id/3247/related/1
      Relational Database Design 101 (part 2 of 3)

      http://help.filemaker.com/app/answers/detail/a_id/3246/related/1
      Relational Database Design 101 (part 3 of 3)


      LIST OF FILEMAKER LINKS

      The White Paper for FMP Novices is useful  - 
      http://foundationdbs.com/downloads.html

      Filemaker Free - Listing of free resources  - 
      http://filemakerfree.com/


      Free unlocked templates
      By Richard Carlton Consulting
      Starting Point -  Contacts | Accounts | Calendar | Estimates |Invoices | Projects |Products | Staff etc.
      http://fmstartingpoint.com/
      Donations -  Accounts | Contacts | Donations | Reporting | Prefs
      http://filemakerdonations.com/
      Recruiter -
      http://rccrecruiter.com/alt-index.html/
      Data4Life -  Contacts | Calendar | Projects | Prospects | Journal | Goals
      http://data4life.net/

      RCC Blog  - 
      http://filemakerbits.wordpress.com/

      By yzysoft.com  Contacts | Products | Invoices | Letters
      Sample Database -
      http://yzysoft.com/printouts/yzysoft_SampleDatabase.html


      Filemaker's  Online Help Pages
      FMP 12  http://www.filemaker.com/12help/index.html
      FMP 11  http://www.filemaker.com/11help/index.html
      FMP 9    http://www.filemaker.com/9help/index.html


      Hints, Tips, and Demo Downloads  FMP version 6 thru 12
      http://www.databasepros.com/resources.html

    • PhilModJunk

      If you use Insert File and select the "store a reference" check box. There's a good chance that you can open the file by double clicking the container field.

      There are data formatting and storage options, however, that can interfere with that behavior if they have been specified for your container field:

      "optimized for interactive content"--if that has been specified for your container field on a given layout, you won't be able to open the file with a double click on that layout.

      External Storage specified for the contiainer field, will also prevent this from working.

      Export Field Contents, however can be used to open the file for all possible insert/formatting/storage options that might be specified for that file and that container field.

    • arron lee

      Hi, alison.

      Why not try to build a 3rd party Word viewer to help open and read word documents in the container? You can google it and select one whose way of processing is simple and fast to help you with the related work. It will be better if it is totally manual and can be customized by users according to our own favors. Remember to check its free trial package first if possible. I hope you success. Good luck.



      Best regards,
      Arron