Jump to content

  •  

Photo

Export records into existing .fp7 possible?

export .fpy filemaker

  • Please log in to reply
6 replies to this topic

#1 ron G  Amateur Developer

ron G
  • Members
  • 621 posts
  • LocationCoeur d'Alene, ID
  • FM Application:12 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 6d 1h 6m 42s

Posted 10 March 2012 - 11:55 PM

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
  • 0

#2 Vaughan  Mostly Harmless

Vaughan
  • Moderators
  • 10,294 posts
  • LocationSydney, Australia
  • FM Application:13 Advance
  • FMGo:iPhone / iPod Touch, iPad
  • Platform:Cross Platform
  • Skill Level:Expert
  • Certification:8, 9, 10, 11
  • Membership:TechNet
  • Time Online: 4d 9h 48s

Posted 11 March 2012 - 12:30 AM

Open the MembersArchive file and IMPORT the desired records from the Members table.
  • 0
Vaughan Bromfield
Sydney, Australia

Please post questions to the Forum, not directly to me. Back-up your files before making changes!

Whenever I hear the term "popular culture" I reach for my Iridium Q-36 Space Modulator.

#3 ron G  Amateur Developer

ron G
  • Members
  • 621 posts
  • LocationCoeur d'Alene, ID
  • FM Application:12 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 6d 1h 6m 42s

Posted 11 March 2012 - 01:18 PM

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

#4 ron G  Amateur Developer

ron G
  • Members
  • 621 posts
  • LocationCoeur d'Alene, ID
  • FM Application:12 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 6d 1h 6m 42s

Posted 11 March 2012 - 11:26 PM

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
  • 0

#5 Ron Cates  journeyman

Ron Cates
  • Members
  • 502 posts
  • LocationMorristown TN ( Near Knoxville )
  • FM Application:12 Advance
  • Platform:Windows 7
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 19d 20h 33m 23s

Posted 12 March 2012 - 04:09 AM

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.
  • 0
"I don't think I am a Newbie anymore. But I still feel like one sometimes :)"

Ron Cates

#6 doughemi  lifetime learner

doughemi
  • Members
  • 704 posts
  • FM Application:12 Advance
  • Platform:Cross Platform
  • Skill Level:Intermediate
  • Time Online: 88d 17h 26m

Posted 12 March 2012 - 07:15 AM

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.
  • 0

Give the gift of life. Register as an organ donor today!
http://www.organdonor.gov/become.asp


#7 ron G  Amateur Developer

ron G
  • Members
  • 621 posts
  • LocationCoeur d'Alene, ID
  • FM Application:12 Advance
  • Platform:Mac OS X Lion
  • Skill Level:Intermediate
  • Membership:TechNet
  • Time Online: 6d 1h 6m 42s

Posted 12 March 2012 - 02:42 PM

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.
  • 0





FMForum Advertisers