• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Filemaker Import
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: Filemaker Import


  • Subject: Re: Filemaker Import
  • From: David Crowe <email@hidden>
  • Date: Fri, 23 Jan 2009 17:37:58 -0700

A technique I've used in FileMaker in the past is to import the data into a single field in FileMaker and then run the parsing routine within FileMaker to break it up into multiple fields.

But I think the idea of using 'tr' to break up the lines into tab delimited columns would probably be a good first pass. Title lines would be distinguishable by having nothing in any other column.

You definitely want to make sure your data remains normalized, so the information like "02-12-09 GENERIC LOG THURSDAY" would be in one table that would link to the individual entries. Whenever you have to add the same information to multiple fields your data is not properly normalized.

When you come across one of these records you will need to create a record in another table and then delete the header record. Other anomalies such as blank lines also would require a record deletion.

Regarding using separate formats for Movies etc., I would not recommend that as some important fields would probably be in common. For visual display the new 'tab' feature of FileMaker allows you to easily customize layouts which could be configured based on the "type" of the record which could be Movie/Sports/News/.../Other. Underneath you'd have a single record format, it would just be that for certain types some fields are not used.

If Applescript has a role it could be to glue the steps together: Download the file, run the shell script, tell FileMaker to Import, tell FileMaker to run a script to complete the parsing, delete the various temporary files, and so on.

- David Crowe
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden
  • Prev by Date: Re: FileMaker & Address Book image
  • Next by Date: Name only of app
  • Previous by thread: Re: Filemaker Import
  • Next by thread: FileMaker & Address Book image
  • Index(es):
    • Date
    • Thread