Re: Filemaker Import
Re: Filemaker Import
- Subject: Re: Filemaker Import
- From: Bruce Robertson <email@hidden>
- Date: Fri, 23 Jan 2009 14:02:50 -0800
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