RE: A simple script for FileMaker Pro
RE: A simple script for FileMaker Pro
- Subject: RE: A simple script for FileMaker Pro
- From: Prasad Vasadi <email@hidden>
- Date: Mon, 6 Jul 2009 11:06:42 +0530
- Importance: Normal
Hi,
My requirement is to fetch the data from Espresso Window and import into FileMaker.
Now I am doing copying data from Espresso Window & Paste into Excel Sheet, From Excel sheet I am importing into FileMaker.
I need a Apple script to fetch data from Espresso Window & Put into FileMaker, Either way From Excel sheet or directely from Espresso window.
the below is the Apple script, i have written. Now problem is sometimes working fine. Some times not, if any one distrubes the windows, it's not working.
tell application "Espresso"
connect username "espresso" password "yyyyy"
open file "Users:Admin:Desktop:Espresso Querys:Tickets B/W Dates.espressoSearches"
delay 10
try
set windowtype to espressoWindowType of window 1
activate
--display dialog windowtype
tell application "System Events"
keystroke tab
end tell
tell application "System Events"
tell process "Espresso"
tell menu bar 1
tell menu bar item "Edit"
tell menu "Edit"
click menu item "Select All"
end tell
end tell
end tell
end tell
end tell
if windowtype = "TicketList" then
set keyList to selection of window 1
else if windowtype = "TicketDetail" then
set keyList to getPrimaryKey of window 1
set keyList to {keyList}
end if
set columnsToGet to "title, callTypeCode, productCategoryCode, readByEscalatedPerson, lastModifiedDate, ranking"
-- Update DATA to FM
repeat with tempID in keyList
set resultData to GetTicketData ticketType 1 ticketID tempID columnNames columnsToGet given «class frln»:1
set resultData to first paragraph of resultData
set AppleScript's text item delimiters to tab
set resultData to every text item of resultData
set AppleScript's text item delimiters to ""
set tempTitle to (item 1 of resultData) -- title
--display dialog "title: " & tempTitle
set tempcallTypeCode to (item 2 of resultData) -- callTypeCode
--display dialog "title: " & tempcallTypeCode
set tempproductCategoryCode to (item 3 of resultData) -- productCategoryCode
--display dialog "productCategoryCode: " & tempproductCategoryCode
set tempreadByEscalatedPerson to (item 4 of resultData) -- readByEscalatedPerson
--display dialog "readByEscalatedPerson: " & tempreadByEscalatedPerson
set templastModifiedDate to (item 5 of resultData) -- lastModifiedDate
-- display dialog "lastModifiedDate: " & templastModifiedDate & "title: " & tempTitle & "title: " & tempcallTypeCode & "productCategoryCode: " & tempproductCategoryCode & "readByEscalatedPerson: " & tempreadByEscalatedPerson
--display dialog (count of keyList)
tell application "FileMaker Pro Advanced"
open file "Users:Admin:Desktop:Espresso Scpt:Espresso.fp7"
set theRecord to create new record at database "Espresso"
tell theRecord
set cell "Title" to tempTitle
end tell
end tell
end repeat
end try
end tell
Please help me.
With regards
Prasad Vasadi
> Date: Tue, 30 Jun 2009 10:57:55 -0700
> Subject: Re: A simple script for FileMaker Pro
> From: email@hidden
> To: email@hidden; email@hidden
>
> >
> > Hello,
> >
> > I'm looking for simple script for FileMaker Pro Advanced & Espresso.
> >
> > I need the following requirements.
> >
> > 1) How to open an excel sheet & paste the information from Clipboard using
> > Apple Script.
> > 2) Using Apple Script, read the Excel file & importing to FileMaker Pro.
> >
> > Can any one Please help me ?
> >
> > With regards
> >
> > Prasad Vasadi
>
> If your only purpose for creating the Excel file is for import into
> FileMaker, then why not just directly script FileMaker?
>
>
|
_______________________________________________
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