Re: Filemaker Import
Re: Filemaker Import
- Subject: Re: Filemaker Import
- From: "Mark J. Reed" <email@hidden>
- Date: Fri, 23 Jan 2009 17:46:11 -0500
As ed says, the field sequence after the category depends on the
category. It should be the same for all LOG records, for instance,
albeit with perhaps different ones blank.
On 1/23/09, Bruce Robertson <email@hidden> wrote:
> Appears to be quite inconsistent at the end of each record.
>
> 6:00 am|....|8394657|30 mins.|
> 7:00 am|....|8394657|30 mins.|
> 6:00 am|....|1 hr. 32 mins.|||810522
> 6:30 am|....|3660096|1 hr. 30 mins.|(Live)
>
>> Thanks everyone for your responses...
>>
>>>> I presume you mean a pipe-delimited text file Ed? If it's a plain
>>>> textfile I'd probably go for transforming it with a simple Unix
>>>> command (eg, tr or awk) into, say, tab-delimited, then import.
>>
>>
>>
>> Well, there are pipes that delimit data fields but it's a bit more
>> complicated than a straight pipe for tab translation.
>>
>> The data contains TV listings, and depending on the category (LOG,
>> MOVIE, SPORTS), the data is organized differently.
>>
>> 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
>>
>> All records will have a time, channel, category field. Only Movies
>> have a field for cast, year, mpaa ratings for example. Only Sports
>> have an event and venue.
>>
>> 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?
>>
>> 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.
>>
>> 02-12-09 GENERIC LOG
>> THURSDAY
>> 6:00 am|(KCBS)|LOG|News||||||(s)|(cc)|(N)|57251|1 hr.|
>> 7:00 am|(HGTV)|LOG|A Gardener's Diary|Movable Gardens|An Atlanta
>> attorney creates a container garden on wheels. Host: Erica Glasener.|||
>> (TVG)||||8394657|30 mins.|
>> 6:00 am|(AMC)|MOVIE|Flaming Star|HHH|||(1960)|Elvis Presley, Steve
>> Forrest.|The son of a settler and a Kiowa must side with whites or his
>> mother's tribe in 1870s Texas.|||(NR)|1 hr. 32 mins.|||810522
>> 6:30 am|(ESPN2)|SPORTS|NASCAR Racing|Nationwide Series -- Camping
>> World 300 Practice|From Daytona International Speedway in Daytona
>> Beach, Fla.|||||||3660096|1 hr. 30 mins.|(Live)
>
> _______________________________________________
> 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
>
--
Sent from Gmail for mobile | mobile.google.com
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