Importing and exporting data > AppleScripts
AppleScripts
AppleScripts can be used to import and export data to and from your software, and to search your company file.
Note that any open windows that are related to the AppleScript routine will be automatically closed during the import and export.
To learn more about AppleScript, see your Macintosh documentation.
Exporting accounts
Use these scripts to export account data from your software. Terms displayed in brackets are optional.
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.’
[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 financial year you want to export data. Default is ’this year.’
Exporting activities
Use these scripts to export activity data from your software. Terms displayed in brackets are optional.
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.’
Exporting activity slips
Use these scripts to export activity slips data from your software. Terms displayed in brackets are optional.
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.’
[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.
Exporting budgets
Use these scripts to export budget data from your software. Terms displayed in brackets are optional.
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.’
Exporting cards
Use these scripts to export card data from your software. Terms displayed in brackets are optional.
Value syntax
of type customer/supplier/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.
[zip from string]
Specify which cards to export by their zips. Must also use until parameter (below) with this parameter.
[until string]
Specifies the end range of zips. Must be used with zip 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.
Exporting one card
Use these scripts to export one card from your software.
Value syntax
 
Of type customer, supplier, 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.’
Exporting custom lists
Use these scripts to export custom list data from your software. Terms displayed in brackets are optional.
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.’
Exporting stock adjustments
Use these scripts to export stock adjustment data from your software. Terms displayed in brackets are optional.
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.’
[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.
Exporting items
Use these scripts to export item data from your software. Terms displayed in brackets are optional.
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.’
Exporting one item
Use these scripts to export one item from your software.
Value syntax
 
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.’
Exporting jobs
Use these scripts to export job data from your software. Terms displayed in brackets are optional.
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.’
Exporting journal entries
Use these scripts to export journal entry data from your software. Terms displayed in brackets are optional.
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.’
[source journal general/sales/purchases/disbursements/receipts/stock/all]
Specifies the source journal to export. Default is ’general.’
[type disbursements all/spend money/employee paycheques/supplier payments/customer refunds/transfer money]
Indicates the type of disbursements to export. Default is ’all.’ 5
[type receipts all/receive money/customer payments/supplier 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.
Exporting nominal journal entries
Use these scripts to export nominal journal entry data from your software. Terms displayed in brackets are optional.
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.’
[dated from date]
Beginning date of a range of transactions to export.
[dated 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.
Exporting purchases
Use these scripts to export purchase data from your software. Terms displayed in brackets are optional.
Value syntax
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.
Exporting one purchase
Use these scripts to export one purchase from your software.
Value syntax
 
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.’
Exporting receive money transactions
Use these scripts to export receive money data from your software. Terms displayed in brackets are optional.
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.’
[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.
Exporting reminder logs
Use these scripts to export reminder log data from your software. Terms displayed in brackets are optional.
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.
Exporting sales
Use these scripts to export sales data from your software. Terms displayed in brackets are optional.
Value syntax
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.
Exporting one sale
Use these scripts to export one sale from your software.
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.’
Exporting tax code list
Use this script to export a tax code list from your software. Terms displayed in brackets are optional.
of type non consolidated/consolidated: type
Type of 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.’
Exporting spend money transactions
Use these scripts to export spend money data from your software. Terms displayed in brackets are optional.
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.’
[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.
Exporting timesheets
Use these scripts to export timesheet data from your software. Terms displayed in brackets are optional.
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.’
[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.
Importing accounts
Use these scripts to import account data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing activities
Use these scripts to import activity data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing activity slips
Use these scripts to import activity slip data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing budgets
Use these scripts to import budget transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing cards
Use these scripts to import card data into your software. Terms displayed in brackets are optional.
Value syntax
of type customer/supplier/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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing one card
Use these scripts to import the data from one card into your software. Terms displayed in brackets are optional.
Value syntax
of type customer/supplier/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.
Importing custom lists
Use these scripts to import custom lists data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing stock adjustments
Use these scripts to import stock adjustment data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing items
Use these scripts to import item data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing one item
Use these scripts to import one item into your software.
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.
Result
A unique record id of item; zero if item could not be found
Importing jobs
Use these scripts to import job data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing journal entries transactions
Use these scripts to import journal entries transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing nominal journal entries transactions
Use these scripts to import nominal journal entries transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing pay bills transactions
Use these scripts to import pay bill data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing purchases
Use these scripts to import purchase data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing one purchase
Use these scripts to import one purchase to your software.
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
Result
A unique record id of purchase; zero if purchase could not be imported.
Importing receive money transactions
Use these scripts to import receive money transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing receive payments transactions
Use these scripts to import receive payment transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing reminder logs
Use these scripts to import reminder logs data into your software. Terms displayed in brackets are optional.
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing sales
Use these scripts to import sale data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing one sale
Use these scripts to import one sale to your software.
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
Result
A unique record id of sale; zero if sale could not be imported.
Importing spend money transactions
Use these scripts to import spend money transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Importing list
Use this script to import a list into your software. Terms displayed in brackets are optional.
of type non consolidated/consolidated: type
Type of GST 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.
Importing timesheets
Use these scripts to import timesheet transaction data into your software. Terms displayed in brackets are optional.
Value syntax
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.
Result
A list containing records imported without errors, skipped and imported with warnings
Determine company file name
Use this script to determine the name of the company file currently open.
company name
Result
The name of currently open company file.
Determine company file path
Use this script to determine the filepath of the company file currently open.
company file path
Result
The filepath to currently open company file.
Determine country version of company file
Use this script to determine the country version of the company file currently open.
country version
Result
The country version of currently open company file.
Determine if open company file contains multiple currencies
Use this script to determine if the open company file contains multiple currencies.
multiple currencies
Result
Boolean return [false/true]
True if company file contains multiple currencies; false if not.
Determine current user
Use this script to determine the current user of the company file.
Result
The user ID of the current user of the company file.
Determine valid user account
Use this script to determine if the user has a valid user account.
company file alias
The name of the company file.
username string
Username of the company file.
password string
Password for the company file.
Result
True is the user account of the company file is valid; false if not.
Show me card
Open a particular card in AccountEdge
show me card
record id integer
unique record id of card to open
username string
username for company file
password string
password for company file
Show me item
Open a particular item in AccountEdge
show me item
record id integer
unique record id of item to open
username string
username for company file
password string
password for company file
Show me purchase
Open a particular purchase in AccountEdge
show me purchase
record id integer
unique record id of purchase to open
username string
username for company file
password string
password for company file
Show me sale
Open a particular sale in AccountEdge
show me sale
record id integer
unique record id of sale to open
username string
username for company file
password string
password for company file
Card exists
Determine if specified card exists
card exists
record id integer
unique record id of card to test for existence
username string
username for company file
password string
password for company file
of type [customer/supplier/employee/personal]
type of card to test for existence
boolean return [true if card exists, false if not]
Card id exists
Determine if specified card id exists
card id exists
card id string
card id of card to test for existence
username string
username for company file
password string
password for company file
of type [customer/supplier/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 exists
positive number is record id if only one card with card id exists
Card name exists
Determine if specified card name exists
card name exists
name string
company/last name of card to test for existence
first name string
first name of card to test for existence
username string
username for company file
password string
password for company file
of type [customer/supplier/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 exists
positive number is record id if only one card with card name exists
item exists
Determine if specified item exists
item exists
record id integer
unique record id of item to test for existence
username string
username for company file
password string
password for company file
boolean return
true if item exists, false if not
Item name exists
Determine if specified item name exists
item name exists
name string
name of item to test for existence
username string
username 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
Item number exists
Determine if specified item number exists
item number exists
number string
unique number of item to test for existence
username string
username for company file
password string
password for company file
boolean return
true if item number exists, false if not
Purchase exists
Determine if specified purchase exists
purchase exists
record id integer
unique record id of purchase to test for existence
username string
username for company file
password string
password for company file
boolean return
true if purchase exists, false if not
Sale exists
Determine if specified sale exists
sale exists
record id integer
unique record id of sale to test for existence
username string
username for company file
password string
password for company file
boolean return
true if sale exists, false if not
Error returns
1
An invalid record id was specified.
2
A company file is not currently open.
3
The requested card does not exist.
The requested item does not exist.
The requested purchase does not exist.
The requested sale does not exist.
4
A window associated with this cannot be closed.
A window associated with this export cannot be closed.
5
No card name was specified.
6
No item name was specified.
7
No item number was specified.
8
No card id was specified.
9
An invalid card type was specified.
 

Click to show more information

Top of page