Re: Applescripting an export from Palm for FIleMaker
Re: Applescripting an export from Palm for FIleMaker
- Subject: Re: Applescripting an export from Palm for FIleMaker
- From: KS Creative Design <email@hidden>
- Date: Sat, 12 May 2001 10:00:54 -0700
Hey Jason (and Chris Page lead Mac guy over at Palm Desktop land)
Thanks for the good info. I've managed to script Exports in FileMaker
from a monolithic Accounting package, that exactly match the import
structures in Palm (at least on the Mac side) for ALL four of the main
modules (contacts, tasks, memos, and even calendar). The part I want to
do is automate it (and take user error our of the loop of having a
person have to manually open the Palm->File->import command...) IMPORT
doesn't even seem to be an option in the dictionary for Palm Desktop.
Also, HOW problematic is the EXPORT command?
Triggering the addresses one at a time may be a way to go, do you have
an example script of how to coerce data from Palm to list to tab
delineated text and into FileMaker. Not to mention having FileMaker
return contents of Portals as AppleScript lists.
Thank you for your help...this is HUGE
On Saturday, May 12, 2001, at 04:39 AM, Jason W. Bruce wrote:
AppleScript works very well for transferring information from
FileMaker to Palm. Essentially, you place all your Filemaker records
into a
list, and then, using a repeat loop, create an address etc. in the Palm
Desktop for each FileMaker record in your list.
You can also capture the relational structure of your databases
by
writing each record and its portals into a Palm memo field. Your
FileMaker
data can always be captured as tab separated text, and FileMaker can
return
the contents of portals as AppleScript lists. Thus, you can put your
FileMaker data (including portals) into a list of tab separated text,
and
write that text to a Palm memo field.
Moving from Palm to FileMaker is also possible. You take each
Palm
address individually, put its contents into a list, create a single
record
in FileMaker from this list, and then go back to the next Palm
address. You
can even place a button on an address to trigger this transfer. I've
not
figured out how to retrieve the data from all addresses from Palm at
once,
however, which would obviously be much faster. Also, the export
command in
the Palm Desktop is apparently problematic.
Jason Bruce
Message: 2
Date: Fri, 11 May 2001 09:53:14 -0700
From: Kentster <email@hidden>
To: "Applescript-Users" <email@hidden>
Subject: Applescripting an export from Palm for FIleMaker
Any one out there know of how to write an AppleScript to automate an
export / importing process in Palm Desktop? Export is in the list of
AppleScript Dictionary commands for it (granted UNSUPPORTED by Palm
anymore) but try to phrase it as I might, Palm Desktop just doesn't
want
to make "the expected type of data" or the variable is not defined.
A more solid solution might be to use the J-Link(?) plug in. Not
something I want to do actually.
Is there any other way that Palm's Contact manager can be hooked up
with
a contact manager in FileMaker (would be really cool to hook up the
Palm
Calendar / Contacts with FileMaker Mobile...but since FileMaker mobile
doesn't seem to be able to even hook up with itself I don't hold out
hope for this...
"Every man dies, not Everyman truly lives..."
- BRAVEHEART (1995)
"Remember, no matter where you go, there you are."
- BUKAROO BANZAI across the eighth dimension (1984)
Kent Silveira
KS Creative Design
email@hidden
"Every man dies, not Everyman truly lives..."
- BRAVEHEART (1995)
"Remember, no matter where you go, there you are."
- BUKAROO BANZAI across the eighth dimension (1984)
quotes from Kent
email@hidden
_______________________________________________
applescript-users mailing list
email@hidden
http://www.lists.apple.com/mailman/listinfo/applescript-users
"Every man dies, not Everyman truly lives..."
- BRAVEHEART (1995)
"Remember, no matter where you go, there you are."
- BUKAROO BANZAI across the eighth dimension (1984)
Kent Silveira
KS Creative Design
email@hidden
From email@hidden Sat May 12 11:50:06 2001
Path: forum.apple.com!paloalto-snf1.gtei.net!crtntx1-snh1.gtei.net!cpk-news-hub1.bbnplanet.com!news.gtei.net!newshub2.home.com!newshub2.rdc1.sfba.home.com!news.home.com!pln-w!spln!dex!extra.newsguy.com!newsp.newsguy.com!igor