Re: Filemaker Import
Re: Filemaker Import
- Subject: Re: Filemaker Import
- From: "Mark J. Reed" <email@hidden>
- Date: Fri, 23 Jan 2009 12:22:07 -0500
On Fri, Jan 23, 2009 at 11:29 AM, email@hidden <email@hidden> wrote:
> 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?
> 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...
> 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.
> I was also wondering if tab-delimited is most efficient for importing into
> Filemaker, or XML which can also be used for a quick CSS Web browser
> display.
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.
But if you do have to parse and munge the pipe-based feed, it's worth
noting that this sort of processing is pretty much exactly what Perl
was created for.
--
Mark J. Reed <email@hidden>
_______________________________________________
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