Write, Bureaucrats, Administrators
1,344
edits
(7 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 34: | Line 34: | ||
Each import table include specialised fields to provide result information. These fields do depend on the accounting package you are integrating with. | 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. | |||
* '''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'''. | 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. | * '''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. | ||
Line 45: | Line 49: | ||
All other fields in an import table are used as data field. | 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]] |