Re: Filemaker and Database events
Re: Filemaker and Database events
The date is derived from the file name, I should have mentioned that.
Everything else, the timeslots, duration, etc. is derived from the data.
Yes, the data has holes in it, the data is what it is and that won't change.
ES
On Jun 15, 2010, at 11:34am, Bruce Robertson wrote:
> Note that once again, you supply incomplete information.
>
> As in our backchannel communication, you supplied data with holes in it.
>
> Example - note repeated "|" characters with no data between them:
> 8:00 pm|(CNBC)|FINANCE|Mad Money||Money manager Jim Cramer discusses Wall Street investments.||||||||1 hr.|
>
> Then you complained that the transformed RESULT had identical holes in it.
> Your result shows date information, for instance. But there is absolutely no date data anywhere.
>
> Really. This just isn't enough to work with.
>
>
> On Jun 15, 2010, at 10:39 AM, email@hidden wrote:
>
>>>
>>
>> WHoops, hit send to soon : }
>>
>>> There is nothing that you've described that inherently takes that long.
>>> It takes YOU that long because you do not know how to do it better.
>>>
>>> But you're keeping it a secret. Nobody can help you at this point.
>>>
>>> Either disclose enough information to actually enable something to be accomplished.
>>
>>
>> If anything I was worried I was providing too much information to the list.
>>
>> And this may all be repetitive so skip this at will....
>>
>>
>> The data is tv listings in a pipe delimited format. It data on every program airing on a list of about 100 channels. The data comes in files separated by day of week.
>>
>> Each day's file starts with data for shows beginning at 6 am and through shows that begin at 5:45 am the following day.
>>
>> The fields in the data for movies and sports are different than the fields for all other programs.
>>
>> The data needs to be manipulated to include date; timeslot (half-hour start); end time and each pipe delimited field must have needs to have it's own field in Filemaker. (see below)
>>
>> The Database events side uses the same data, but we do not need to populate every field on a one to one basis.
>>
>> The purpose is to for a script to access all the listings for a particular channel for a specified time period, and parse them to give insert into an indesign document at runtime.
>>
>> At runtime a user makes a selection from the table, activates a script, the script reads and parses the data and then either replaces the text in the cell or gives the user a choice of what to insert into the field.
>>
>> The goal, and the point of this thread is to not have to manipulate the same raw data twice, once for FileMaker and once for DE.
>>
>> I'm going to try once suggestion in the thread, to export from FileMaker to DE.
>>
>> I'm also going to try to speed up the conversion process with some shell scripting (ug) and more advanced data manipulation, to avoid repeating through each line.
>>
>> I'm thinking about making three import scripts in filemaker, one for movies, sports, and the rest, and extracting movies and sports listings from the raw data and saving those as separate input files.
>>
>> This is all probably TMI.
>>
>> ES
>>
>>
>> This is what the raw data looks like
>>
>> 7:30 pm|(TNT)|SPORTS|NBA Basketball|Denver Nuggets at Phoenix Suns|From US Airways Center in Phoenix.|||||(cc)|||2 hrs. 30 mins.|(Live)
>> 8:00 pm|(KTTV)|MUSIC|American Idol||The remaining nine finalists perform; former ``American Idol'' runner-up Adam Lambert mentors the contestants.|||(TVPG-D,L)|(s)|(cc)|(Tape)||1 hr. 28 mins.|
>> 8:00 pm|(KFTR)|MOVIE|Hijos de la Mafia|HH|||(2001)|John Malkovich, Dennis Hopper.|El hijo de un gángster hace hasta lo imposible para recuperar una bolsa llena de dinero que fue perdida en un pueblo de Montana.|||(R)|1 hr. 33 mins.|(cc)||
>> 8:00 pm|(KOCE)|LOG|Antiques Roadshow|Reading|Butcher's shop model; painting.||||||||30 mins.|
>> 8:00 pm|(AMC)|MOVIE|Troy|HHH|||(2004)|Brad Pitt, Eric Bana.|The fierce warrior Achilles leads Greek forces in the Trojan War, ignited when Paris abducts Helen of Troy.|||(R)|2 hrs. 42 mins.|(cc)||
>> 8:00 pm|(APL)|SPECIAL|The Bear Whisperer||Steve Searles acts as a bear wrangler, handling 20 to 30 calls per week from panicky residents at Mammoth Lakes, Calif.|||(TVPG-V)|(s)|(cc)|||2 hrs.|
>> 8:00 pm|(BBCA)|LOG|Doctor Who|Journey's End|As Davros and the Daleks threaten the entire universe, the Doctor's companions join forces. However, the prophecy declares that one of them will die.|||(TVPG)|(s)|(cc)|||1 hr.|
>> 8:00 pm|(CNBC)|FINANCE|Mad Money||Money manager Jim Cramer discusses Wall Street investments.||||||||1 hr.|
>> 8:15 pm|(SHOW)|MOVIE|My Best Friend's Girl|H||(s)|(2008)|Dane Cook, Kate Hudson.|Complications crop up when an unlikable cad dates his best pal's ex-girlfriend in the pal's scheme to convince her to go back to him.|||(R)|1 hr. 43 mins.|||
>>
>> THis is the same data ready to import into filemaker.
>>
>> (The day of the week and date are derived from the file name)
>>
>>
>> 04-13-2010 Tuesday SPORTS 7:30 pm 7:30 pm 10:00 p.m. PrimeTime (TNT) NBA Basketball 2 hrs. 30 mins. (cc) (Live) Denver Nuggets at Phoenix Suns From US Airways Center in Phoenix.
>> 04-13-2010 Tuesday MUSIC 8:00 pm 8:00 pm 9:28 p.m. PrimeTime (KTTV) American Idol The remaining nine finalists perform; former ``American Idol'' runner-up Adam Lambert mentors the contestants. 1 hr. 28 mins. (cc) (s) (TVPG-D,L) (Tape)
>> 04-13-2010 Tuesday MOVIE 8:00 pm 8:00 pm 9:33 p.m. PrimeTime (KFTR) Hijos de la Mafia El hijo de un gángster hace hasta lo imposible para recuperar una bolsa llena de dinero que fue perdida en un pueblo de Montana. 1 hr. 33 mins. (cc) (R) (2001) John Malkovich, Dennis Hopper. HH
>> 04-13-2010 Tuesday LOG 8:00 pm 8:00 pm 8:30 p.m. PrimeTime (KOCE) Antiques Roadshow Reading Butcher's shop model; painting. 30 mins.
>> 04-13-2010 Tuesday MOVIE 8:00 pm 8:00 pm 10:42 p.m. PrimeTime (AMC) Troy The fierce warrior Achilles leads Greek forces in the Trojan War, ignited when Paris abducts Helen of Troy. 2 hrs. 42 mins. (cc) (R) (2004) Brad Pitt, Eric Bana. HHH
>> 04-13-2010 Tuesday SPECIAL 8:00 pm 8:00 pm 10:00 p.m. PrimeTime (APL) The Bear Whisperer Steve Searles acts as a bear wrangler, handling 20 to 30 calls per week from panicky residents at Mammoth Lakes, Calif. 2 hrs. (cc) (s) (TVPG-V)
>> 04-13-2010 Tuesday LOG 8:00 pm 8:00 pm 9:00 p.m. PrimeTime (BBCA) Doctor Who Journey's End As Davros and the Daleks threaten the entire universe, the Doctor's companions join forces. However, the prophecy declares that one of them will die. 1 hr. (cc) (s) (TVPG)
>> 04-13-2010 Tuesday MOVIE 8:00 pm 8:15 pm 9:58 p.m. PrimeTime (SHOW) My Best Friend's Girl Complications crop up when an unlikable cad dates his best pal's ex-girlfriend in the pal's scheme to convince her to go back to him. 1 hr. 43 mins. (s) (R) (2008) Dane Cook, Kate Hudson. H
>>
>>
>
_______________________________________________
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