Re: Filemaker Import
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