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

    • Container export to IOS Photo app?
      By 34South
      I have developed a solution for IOS devices which also utilizes scripts that facilitate importing of GPS coordinates and especially photos from the device, i.e. iPhone or iPad, within FMGo. Although I have scripted the possibility of emailing images originally captured by the solution outside of the solution, there does not seem to be a possibility for exporting the captured image to the Photos app and thus pushing them to the iCloud. I know one could first capture the image in the Camera app and then import it into a container within the solution, but this distracts from the all-in-one nature of my solution, where quick image capture is paramount. Ideally, the user would use the solution to capture the image and related contextual data, but also elect to save such an image in the Photo app at a later stage to permit sharing it to social media apps, for example.
       I'm fairly advanced, having used FM since the Claris days.
    • [ANN] Productive Computing, Inc. Releases Vessel Service Solutions (VSS) v2
      By Productive Computing, Inc.
      San Diego, CA - April 12, 2016 - Productive Computing, Inc., a Platinum member of the FileMaker Business Alliance, is proud to announce the release of Vessel Service Solutions (VSS) version 2. This vertical solution was designed for the marine assistance industry and operates as a virtual command center to manage vessel assistance orders. VSS version 2 offers additional features and modules, a completely redesigned UI, and improved processes for users.  
       
      What is VSS?
      VSS was built with a “paperless and efficient” philosophy and allows users to fully digitalize the entire tow order process from beginning to end. As soon as distress calls are received, dispatchers have the ability to send mobile orders straight from the office to in-field captains. The captain receives the order on an iPad and, after assisting the boater, updates and submits the order to dispatch for final processing. VSS also allows invoices and items to be pushed directly to QuickBooks via the FM Books Connector. 
       
      What's New? 
      VSS version 1 provided companies with a customizable framework they could employ to achieve a paperless solution. Version 2 has been crafted with industry input and takes the entire tow order process to the next level by offering the user a truly comprehensive solution. Dispatch can send, receive, and submit orders for payment without printing a single document. Using FileMaker Go, captains can receive, update, and send orders from their iPads. They can even perform data entry while at sea without an internet connection. Version 2 has expanded functionality to allow users to maintain fuel logs, maintenance logs, maintenance schedules, time sheets, and pull various reports.
       
      As with most FileMaker products, this solution allows for customization, including the ability to personalize all terms, disclaimers, notes and signature requirements, company information, tower ID, and company logo in the modules.  
       
      "We're quite excited about the new and improved VSS, because this dynamic solution enables users to efficiently and digitally dispatch, track, and manage tow orders, eliminating the need for time-consuming paperwork, resulting in improved accuracy and turnaround time. We've had a lot of support from industry leaders, and we're pleased to be delivering something we think will continue to greatly help the boat towing industry" - Marc Larochelle, Chief Executive Officer, Productive Computing, Inc. 
       
      For more information please visit www.vesselservicesolutions.com. Have additional questions? Contact sales@productivecomputing.com or 760-510-1200. 
       
      FileMaker Pro Support and Plug-in Integration:
      Do you have database enhancements you would like to have programmed?  Want help getting a plug-in professionally installed into your FileMaker solution?  We can help! The process is easy - complete our online Request For Quote form (RFQ) or call us directly at (760) 510-1200 and one of our certified developers can work with you on improving your solution today.
       
      About Productive Computing, Inc.
      Since 1996, Productive Computing, Inc. has been helping its customers become more efficient and profitable by implementing custom software solutions using FileMaker Pro. Utilizing FileMaker Pro as a rapid application development tool, their certified FileMaker developers can create custom applications that a business can run on their Windows or Macintosh desktop computers, in a web browser, on an iPad or iPhone or shared simultaneously on all of these platforms.
       
      Productive Computing, Inc. also produces several off-the-shelf productivity solutions such as Core4 CRM, Music Director Pro, and Vessel Service Solutions, as well as a suite of FileMaker Pro plug-ins that allow FileMaker Pro to integrate with third party applications including Outlook, QuickBooks, Apple's Address Book and Calendar, PDF forms, digital signatures, and biometric fingerprint scanners.
       
      In addition to building custom and off-the-shelf FileMaker Pro solutions and plug-ins, Productive Computing, Inc. is a full service FileMaker Pro hosting company. FileMaker hosting services allow customers to host their own FileMaker Pro solutions on Productive Computing servers in the cloud instead of purchasing and supporting the necessary server infrastructure themselves. These same servers also provide the infrastructure for customers who would prefer to subscribe to Productive Computing's Core4 CRM and Vessel Service Solutions products under a SaaS (Software as a Service) pricing model.
       
      Productive Computing, Inc. is one of only a few companies in the United States to have earned the highly respected platinum level membership within the FileMaker Business Alliance and recently won the exclusive FileMaker Business Alliance "Partner of the Year" award.
       
       
      Productive Computing, Inc.
      950 Boardwalk, Suite 205
      San Marcos, CA 92078
      www.ProductiveComputing.com
      sales@productivecomputing.com
      (760) 510-1200
       
      Press Contacts:
      Productive Computing, Inc.
      Keith Larochelle
      (760) 510-1200
       
      # # #
      ---------------------------------------------------
    • mail record as PDF with calculated name?
      By Mike Blackburn
      I have found ways to do this from Filemaker in OSX but I can't seem to apply this to FMGo.
      I want to mail the current record as a PDF and to have the PDF name be derived from the value of a field (in this cas, the name of the client)
       
      Below is the script as it stands. Is this a possibility in FMGo?
       
      1. Go to Layout [ layout name ]
      2. Set Variable [$name ; Value: Patients::LastName ]
      3. Save Records as PDF [ Restore ; No dialog ; "$name.pdf" ; Crerate email ; Current record ]
      4. Go to Layout [ original layout ]
       
      THoughts?
    • Multi Machine Deployment
      By Arjun
      Hi everyone,
      I am new here. I just began working with a project that has been using FileMaker Server 9 and Pro 9. The current architecture uses one machine deployment but the machine is quite ancient and doesn't support any micro-frameworks that eases my web development duties.

      I wanted to split this architecture to a multi machine deployment this ancient machine having only the Database, another better machine having a webserver and/or a web publishing engine. The reasoning behind this being that I can use a webserver(Gunicorn + Flask) and use PyFileMaker to obtain my data from the DB using XML.

      I, however, realize that the web publishing engine is required at the database to publish my XML data which in turn requires a web server running(apache). This goes back to the same one machine deployment.
      Am I missing a point here?

      Thank you so much for taking your time to read this. It would be truly awesome if you could help me with this question.
      Thank you once again and have a good day.

      Regards,
      Arjun
    • Wanted - Programmer for work on existing vertical market applications
      By John Kamm
      We are an established vertical market application developer in need of additional programming assistance for the web portion of our solution. We customize each of our FileMaker and companion web site solutions to meet the needs of our clients. The web site architecture is based on a YII MVC design. Programmer should have knowledge of FileMaker PHP API, PHP, HTML, YII (or other MVC), Tortoise SVN and basic Windows server configuration. Ongoing work would be available, all work is remote to our development servers.