Re: Filemaker Import
Re: Filemaker Import
- Subject: Re: Filemaker Import
- From: email@hidden
- Date: Sat, 24 Jan 2009 12:02:04 -0800
The data contains TV listings, and depending on the category (LOG,
MOVIE,
SPORTS), the data is organized differently.
What does "LOG" mean in this context?
It refers to a program as a generic TV log entry. In the old days TV
listings were done in a newspaper column linear format that were
called TV logs.
The date information is in the first line of the file but needs to be
included with every record and needs to change for records from
midnight to
5:59 am
So each day gets its own file. There's no need to watch out for a
"FRIDAY" line coming up while processing THURSDAY records...
Except a "day" begins at 6:00 am and ends at 5:59 am. After midnight
the Thursday becomes Thu-Fri.
I'm assuming I need to convert the records to a consistent format
before
importing into filemaker. Or would I be able to import three
formats into
the same FM database using one import for Movies, a different one
for Sports
and and a third for everything else?
Well, I know absolutely nothing about FileMaker. If I were designing
a schema for this in an RDBMS (MySQL, SQL Server, Oracle, etc), I
would have one table, say SHOWS, with columns for the common
information, and then an additional table for each specific
subcategory (MOVIES) which would have a foreign key back to SHOWS
along with columns for the subcategory-specific data.
XML is also useful in many other environments. And it's sufficiently
popular that you might be able to convince your upstream data provider
to send you XML to start with, and avoid a lot of hassle.
That's where I started, but got nowhere.
After some pounding away (and using BBEdit for some speedy text
processing) I've figured out that once I have the data parsed,
exporting a both an xml and tab-delimited version is pretty quick and
fairly simple.
ES
_______________________________________________
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