Re: Filemaker Import
Re: Filemaker Import
- Subject: Re: Filemaker Import
- From: "Mark J. Reed" <email@hidden>
- Date: Fri, 23 Jan 2009 07:53:53 -0500
If FM can't import pipe-delimited records, and using pure AS to
replace the pipes with tabs is too slow, perhaps this is a case for do
shell script? If the data is in a file, then
do shell script "tr '|' '\t' " & quoted form of posix path of
sourceFile & " >" & quoted form of posix path of destFile
After which you can tell FM to import destFile.
Or leave off the " >destfile" bit and just let it return the
tab-delimited data to AS and let AS send it to FM, but that seems
liable to be slower.
Tr is fast, but also simplistic - if you have any instances of pipes
within column values, quoted via some mechanism that leaves the
literal pipe character intact, they'll get converted to tabs, too.
On 1/22/09, email@hidden <email@hidden> wrote:
> I'm trying to find the most efficient way to import a large dataset
> into a Filemaker database.
>
> The raw data comes as vertical pipe delimited records, each containing
> either 14, 16 or 18 records, depending on the individual record format.
>
> Via appleScript I can format the data as tab-delimited or xml, but
> with thousands of new records on a daily basis the process can take
> too long.
>
> Any suggestion?
>
>
>
> Coach Ed Stockly
> email@hidden
> email@hidden
> Home: (818) 248-9343
> Cell: (818) 929-9335
> Work: (213)237-6880
>
>
>
>
>
> _______________________________________________
> 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