Write, Bureaucrats, Administrators
1,344
edits
Difference between revisions of "Writing Data"
Jump to navigation
Jump to search
no edit summary
(Created page with "== Overview == ODBClink allows you to write data into your accounting package. '''Note that this feature is only available in ODBClink Pro Edition'''. ODBClink provides a ...") |
|||
| (8 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
Specialised import tables have been designed in ODBClink to allow you to import data back into your accounting package. These tables are "prefixed" with specialised names (e.g. MYOXIMPORT_ for MYOB AccountRight Live). For a complete list of the import tables, see [[Import Tables]]. | Specialised import tables have been designed in ODBClink to allow you to import data back into your accounting package. These tables are "prefixed" with specialised names (e.g. MYOXIMPORT_ for MYOB AccountRight Live). For a complete list of the import tables, see [[Import Tables]]. | ||
To configure ODBClink to write data, you will need to [[Edit your data warehouse | To configure ODBClink to write data, you will need to [[Editing a data warehouse|Edit your data warehouse]] and include the appropriate import tables. | ||
== Adding records to the write data table == | == Adding records to the write data table == | ||
| Line 31: | Line 31: | ||
=== Fields used to return result information === | === Fields used to return result information === | ||
Each import table include specialised fields to provide result information. These fields do depend on the accounting package you are integrating with. | |||
These fields should be left blank. | |||
ODBClink will update these fields with information when writing data back to your accounting package. | |||
* '''RecordedUID''' is used for MYOB AccountRight Live and provides the '''UID''' of the transaction or data recorded. For endpoints that do not have a UID, the field will either contain the words '''Imported''' or '''Not Imported'''. | |||
* '''RecordedRowVersion''' is used for MYOB AccountRight Live and provides the '''RowVersion''' of the transaction or data recorded. For endpoints that do not have a RowVersion, the field will either contain the words '''Imported''' or '''Not Imported'''. | |||
* '''RecordedDate''' is used for MYOB AccountRight Live and provides the date when the transaction was recorded. If the import process failed, it will be set to NULL. This fields is also used a control field. ODBClink will only attempt to import records which have a RecordedDate of NULL. | |||
* '''RecordedResult''' is a text field used for MYOB AccountRight Live and provides the descriptive result returned by the import process. If the import was successful, it will set to '''Success'''. Any other value is an error and provides the description of the error. | |||
=== Fields used as data === | |||
All other fields in an import table are used as data field. | |||
== Writing Data == | |||
ODBClink provides multiple means to write data back into your accounting package. | |||
The command centre includes a '''Write Data''' button. Using this button, ODBClink will iterate through each data warehouse, data file and import table and record the data available. | |||
A '''WriteData''' macro can also be used and called which behaves exactly as the command centre '''Write Data''' button. | |||
Lastly, the '''Write Data''' macro accepts 3 parameters being an '''import table name''', a '''data warehouse name''' and a '''data file name'''. All three parameters can be used independently and allows you to control/refine how the data gets written into MYOB. | |||
== Related Topics == | |||
* [[Get Data]] | |||