oTool is easy to configure and use, but sometimes you will encounter minor errors. This oTool Help guide will assist you in achieving a successful out0migration.
Some of my CSV entries have double quotes– oTool Help
This will occur with Checkbox, Combobox, Dialogue List, or List Box fields if they hold multiple values. The simplest solution is to open the CSV file in a non-formatting text editor such as Notepad and do a Search and Replace on double quotes to turn them into single quotes. Re-save the CSV, and it will then open cleanly in Excel.
Some Attachments did not export– oTool Help
If there is a problem with a duplicate or corrupt attachment, it will not be exported. A log entry will be made for each attachment error in the “Attachment Status” field at the bottom right of the Xport form.
It may be possible to manually extract these attachments.
Some of my data are missing– oTool Help
Data accessibility is based on the permissions of the active user. Please ensure that your UserID has a sufficient access permission level for the data you wish to export.
Object variable not set – oTool Help
If this occurs while running “Get Row Columns” it indicates that the View name specified does not exist in the specified database. Please check for the correct name. It may be the primary or alias name. This issue was corrected in V3.
For complete documentation, please see oTool Documentation.
oTool is a product of KSI. For more information about KSI, please visit www.ksi.ca