Sign in to follow this  
Followers 0
ron G

Export records into existing .fp7 possible?

7 posts in this topic

After a *lot* of climbing of the learning curve, I got my Import function to work. (thank you 360Works for ScriptMaster selectFile() ).

I figured I could write a similar procedure to 'archive'/export individual database records. So, I copied my original database (Members.fp7) and created (MembersArchive.fp7).

In my Members::Export Script, I selected MembersArchive.

When I opened MembersArchive there was all the data, but the Layouts, scripts etc have ALL been deleted. huh? It seems like Export isn't the way to go. It seems like Export is geared to sending .fp7 into spreadsheets etc. But, there is an .fp7 'type'?

Would I be better off if I would just OPEN Members.Archive and run an import script.

Is importing the only way to get a found set or a single record into MembersArchive.fp7???

Thank you

Share this post


Link to post
Share on other sites

Open the MembersArchive file and IMPORT the desired records from the Members table.

Share this post


Link to post
Share on other sites

Thanks. That's what I thought. Good to have the confirmation. Thank you.

Share this post


Link to post
Share on other sites

By the way, I need to import just the found set or just a single record (and it's related records). I didn't see any Import options that would apply these restrictions on the Source. Or, am I missing something?

thanks

Share this post


Link to post
Share on other sites

You will want to run a script in the archive file that goes to the source file and establish the found set before import.

Or just open the source file. Perform your find, then from the archive file, run the import. Filemaker will import based on the found set.

Share this post


Link to post
Share on other sites

What Ron said, but keep in mind that the source file must be open for this to happen. If it is closed, the target file will import all records of the source.

Share this post


Link to post
Share on other sites

What Ron said, but keep in mind that the source file must be open for this to happen. If it is closed, the target file will import all records of the source.

Ah ha!. That must be why I have so much trouble importing a found set. Thanks for the tip.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0

  • Similar Content

    • [ANN] FileMaker Training classes in Montreal and Ottawa
      By lazp
      Direct Impact, world-renowned for its certified FileMaker® developers, is pleased to announce its spring 2016 FileMaker 14 training schedule.
       
      Our certified FileMaker trainers have the experience and skills to offer you quality, French training, for the market in Quebec and English training, for the market in Ontario. Take advantage of this unique opportunity to be trained in the company of an expert of the FileMaker platform.
      Next training classes will be held on the following dates:
      FileMaker Training classes in Montreal (in French)
      Initiation à FileMaker 14 débutant - 4 avril 2016
      Développeur FileMaker 14 intermédiaire - 18 et 19 avril 2016
      Développeur FileMaker 14 avancé - 9 et 10 mai 2016
      FileMaker Training classes in Ottawa (in English)
      Introduction To FileMaker 14 Beginner - To be determined
      Developer FileMaker 14 Intermediate - To be determined
      Developer FileMaker 14 Advanced - To be determined


      Sign-up now

    • [ANN] FileMaker Training classes in Montreal and Ottawa
      By lazp
      Direct Impact, world-renowned for its certified FileMaker® developers, is pleased to announce its winter 2016 FileMaker 14 training schedule.

      Our certified FileMaker trainers have the experience and skills to offer you quality, French training, for the market in Quebec and English training, for the market in Ontario. Take advantage of this unique opportunity to be trained in the company of an expert of the FileMaker platform.

      Next training classes will be held on the following dates:

      FileMaker Training classes in Montreal (in French)




      Initiation à FileMaker 14 débutant - 8 février 2016
      Développeur FileMaker 14 intermédiaire - 22 et 23 février 2016

      Développeur FileMaker 14 avancé - 7 et 8 mars 2016

      FileMaker Training classes in Ottawa (in English)




      Introduction To FileMaker 14 Beginner - To be determined



      Developer FileMaker 14 Intermediate - To be determined


      Developer FileMaker 14 Advanced - To be determined
      Sign-up now
    • Portal exported to excel spreadsheet only contains one related field once, other fields are empty
      By justakid
      Hi All,
      Sorry if the title is a bit confusing, I wasn't sure how to explain it.
      Basically I've got a layout that contains a portal to another table. abc0198_cpa_v002 and xyz0570_cpa_v0008 are the link to the other table (linked to the table by the first 6 characters)

      the problem I have is when I export this I get the following in Excel. I was hoping that the empty fields beneath abc0198_cpa_v002 would be filled with abc0198_cpa_v002.

      I can get it to work by going to the related table, searching for those records (abc0198 & xyz0570), but I will fall into the same problem when I receive multiple records that relate to the same record in the other table. IE I might receive abc0198_cpa_v002 and abc0198_cpa_v005 etc.
      I hope this makes sense and thanks in advance for any help.
    • Container Fields and Printing
      By Answers
      In our database solution we have a table that holds other documents relating to the data. The enduser might insert a PDF or a JPG. So the table is made up of a container field, a job number (unique identifier). To view the file the user clicks in the container (script exports field contents and automatically opens).
      The thing we would like to do is when printing a job report if there are any "external documents", would like them to print as well. We want it be be part of the complete report. The container is setup for interactive content and start playback automatically. The script exports the container and imports it back in... on the Mac it produces the correct results, on the PC  it prints as a pdf icon for example. Maybe what I want is not possible. Any suggestions.
    • [ANN] Courez la chance de gagner une COPIE GRATUITE de FileMaker Pro 14 Advanced
      By lazp
      Courez la chance de gagner une COPIE GRATUITE de ‎FileMaker Pro 14 Advanced d’une valeur de 670.00 $ en vous inscrivant à notre formation Développeur 14 avancé qui aura lieu à Montréal le 7 et 8 décembre prochain. Inscrivez-vous ici http://formationfilemaker.ca