Introduction to myob-based premier database interoperability

Myob is a global business management solution provider that enables business managers and accountants to succeed without having to focus on tedious daily management. The software developed and released by myob has won multiple awards, providing a new operating mode for Growth Enterprises. Its products have won numerous awards worldwide for their quality and innovation. Myob URL: http://www.myob.com/, myobchinese http://www.myob.com.cn/chi /. My boss said myob is a company in Australia.
Because the customer needs to import the invoice data generated by another program to myob Premier (a version of myob accounting software), and this work is just done by me, therefore, we have the opportunity to access myob products and secondary development. (All involved are based on myob Premier .)
For developers, they are most concerned with the secondary interfaces it provides.
Myob premier uses myob ODBC to connect to its data. The current version of myob ODBC is V6. This driver is not installed by default. You can find this installer under its directory.
Myob premier database tables can be divided into two categories from the perspective of myob ODBC support:
1) only data import tables starting with "Import _" with "insert" are supported.
2) only other select tables are supported. These tables are the actual database tables used by myob premier.
By inserting data to a class table, myob premier automatically inserts the data to the class table. This design is exquisite.
The importantdates, importerrors, and importwarnings table users track data import. In fact, when warnings occurs, an exception is thrown when a transaction is used (odbctransation.
Myob premier databases have their own data types, but they are similar. Clearwtr. Myo is a random example database.
Myob premieris a dynamic data warehouse file. It is also said that a database file is required after myobp.exe (myob premier Startup File) is opened. You can also create a database file.
After the myob ODBC driver is installed, there will be some instructions on how to read 2) table data and 2) table, but this is not enough for secondary development. You can obtain more information and source code samples from http://d2d.myob.com.au/or http://www.myob.com/developers (You need to log on ).
For 1) type table, if the program is correct but the insertion is unsuccessful, try to fill in all fields.
Connection string example:

<Add key = "myobconnectionstring" value = "driver = {myob_odbc}; type = myob; access_type = read_write; uid = administrator; Pwd =; database = c: \ premier10 \ clearwtr. myo. myo; host_exe_path = c: \ premier10 \ myobp.exe; network_protocol = nonet; driver_completion = driver_noprompt; Key = c: \ premier10 \***. key; "> </Add>

　　
As you do not know much about it, you can only introduce it below. Share.