AppleScripts can be used when multiple users are accessing the company file. Note that any open windows that are related to the AppleScript routine will be automatically closed during the import and export.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[balances from month of january/february/march/april/may/june/july/august/september/october/november/december]
Indicates from which month you want to export data. Default is the current month.
[in this year/last year]
Indicates from which fiscal year you want to export data. Default is ’this year.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[identifiers string]
Specify which transactions to export by their identifiers. No default.
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
of type customer/vendor/employee/personal
Type of card to export
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[identifiers string]
Specify which cards to export by their identifiers. No default.
[postcode from string]
Specify which cards to export by their postcodes. Must also use until parameter (below) with this parameter.
[until string]
Specifies the end range of postcodes. Must be used with postcode from parameter above.
[custom list 1 string]
Specifies what cards to export by the contents of their ’custom list 1’ fields. No default.
[custom list 2 string]
Specifies what cards to export by the contents of their ’custom list 2’ fields. No default.
[custom list 3 string]
Specifies what cards to export by the contents of their ’custom list 3’ fields. No default.
Of type customer, vendor, employee, personal
Type of card to export
record id integer
Unique id of record to be exported
to string
Name of file to which to export data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
record id integer
Unique id of record to be exported
to string
Name of file to which to export data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[source journal general/sales/purchases/disbursements/receipts/inventory/all]
Specifies the source journal to export. Default is ’general.’
[type disbursements all/spend money/employee paychecks/vendor payments/customer refunds/transfer money]
Indicates the type of disbursements to export. Default is ’all.’ 5
[type receipts all/receive money/customer payments/vendor refunds]
Indicates the type of receipts to export. Default is ’all.’
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
of type service/item/professional/miscellaneous
Type of purchases to export.
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[status opened/debit/closed/all bills/orders/quotes/all purchases]
Specifies what sales to export by their status. Default is ’all invoices.’
[identifiers string]
Specifies what purchases to export by their identifiers. No default.
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
Of type service, item, professional, miscellaneous
Type of purchase to export
record id integer
Unique id of record to be exported
to string
Name of file to which to export data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[identifiers string]
Specifies how to identify records. No default.
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
of type service/item/professional/timebilling/miscellaneous
Type of sales to export.
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[status opened/credit/closed/all invoices/orders/quotes/all sales]
Specifies what sales to export by their status. Default is ’all invoices.’
[identifiers string]
Specifies what sales to export by their identifiers. No default.
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
Of type service, item, professional, timebilling, miscellaneous
Type of sale to export
record id integer
Unique id of record to be exported.
Value syntax to string
Name of file to which to export data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
of type non consolidated/consolidated: tax code type
Type of tax code to export
to string
Name of file to export to.
username string
Username for company file.
password string
Password for company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
[thirteenth period false/true]
Indicates whether the date range specified above is in the 13th period.
to string
Name of file to which to export data.
username string
Username of the company file.
password string Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[identifiers string]
Specify which transactions to export by their identifiers. No default.
[dated from date]
Beginning date of a range of transactions to export.
[until date]
Ending date of a range of transactions to export.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
of type customer/vendor/employee/personal
Type of cards to import.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
of type customer/vendor/employee/personal
Type of cards to import.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record/delete existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
From Alias
Name of file from which to import data.
record id integer
Unique id of record to be imported
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject/update existing record]
Indicates what to do with duplicate records. Default is ’reject.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
of type service/item/professional/miscellaneous
Type of purchases to import.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
[add card false/true]
Indicates whether to add card. Default is false.
Of type service, item, professional, miscellaneous
Type of purchase to import
From alias
Name of file from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/ record id]
How record will be identified. Default is card id.
[automatch false/true]
Only used when first record is header. Default is false.
[add card false/true]
Indicates whether to add card. Default is false
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them/update existing record/delete existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/record id]
Indicates how to identify record. Default is card name.
[automatch false/true]
Only used when first record is header. Default is false.
of type service/item/professional/timebilling/miscellaneous
Type of sales to import.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
[add card false/true]
Default is false.
Of type service, item, professional, miscellaneous
Type of sale to import
From alias
Name of file from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/ record id]
How record will be identified. Default is card id
[automatch false/true]
Only used when first record is header. Default is false.
[add card false/true]
Indicates whether to add card. Default is false
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/add them]
Indicates what to do with duplicate records. Default is ’reject them.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card id.’
[automatch false/true]
Only used when first record is header. Default is false.
of type non consolidated/consolidated: tax code type
Type of tax code to export
from alias
Name of file to import from.
username string
Username for company file.
password string
Password for company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[duplicates are reject them/update existing record]
Indicates what to do with duplicate records. Default is ’reject them.’
[automatch false/true]
Only used when first record is header. Default is false.
from alias
File from which to import data.
username string
Username of the company file.
password string
Password for the company file.
[separated by tabs/commas]
How data will be separated. Default is ’tabs.’
[first record is header/data]
Record type of first record in the file. Default is ’header.’
[identify by card name/card id/record id]
How record will be identified. Default is ’card name.’
[automatch false/true]
Only used when first record is header. Default is false.
Boolean return [false/true]
True if company file contains multiple currencies; false if not.
company file alias
The name of the company file.
username string
Username of the company file.
password string
Password for the company file.
record id integer
unique record id of card to open
username string
username for company file
password string password for company file
record id integer
unique record id of item to open
username stringusername for company file
password string password for company file
record id integer
unique record id of purchase to open
username stringusername for company file
password string password for company file
record id integer unique record id of sale to open
username stringusername for company file
password string password for company file
record id integer unique record id of card to test for existence
username stringusername for company file
password string password for company file
of type [customer/vendor/employee/personal]
type of card to test for existence
boolean return [true if card exists,
false if not]
card id stringcard id of card to test for existence
username stringusername for company file
password string password for company file
of type [customer/vendor/employee/personal]
type of card to test for existence
integer negative count if multiple cards with same card id; zero if no card with card
id existspositive number is record id if only one card with card id exists
name string
company/last name of card to test for existence
first name stringfirst name of card to test for existence
username stringusername for company file
password string password for company file
of type [customer/vendor/employee/personal]
type of card to test for existence
integer negative count if multiple cards with same card name; zero if no card with
card name existspositive number is record id if only one card with card name exists
record id integer unique record id of item to test for existence
username stringusername for company file
password string password for company file
boolean returntrue if item exists, false if not
name string name of item to test for existence
username stringusername for company file
password string password for company file
integer negative count if multiple items with same name; zero if no item with name exists
positive number is record id if only one item with name exists
number string unique number of item to test for existence
username stringusername for company file
password string password for company file
boolean returntrue if item number exists,
false if not
record id integer unique record id of purchase to test for existence
username stringusername for company file
password string password for company file
boolean returntrue if purchase exists,
false if not
record id integer
unique record id of sale to test for existence
username stringusername for company file
password string password for company file
boolean returntrue if sale exists,
false if not
