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