Dataload professional software

If possible the problem should be reproduced with a user manually entering the volume of data where the problem occurs. The issue can then be reported to Oracle Support and because it has been reproduced by a user the issue is definitely an Oracle rather than DataLoad problem.

My load to enter Users Define Users form fails with a Post insert trigger error, why? All user names must be in upper case. If they are not then this error occurs.

Where Oracle converts data manually entered in a form to upper case then the data entered with forms playback should also be in that format. If your database uses the Unicode UTF-8 character set certain characters may cause the load to fail because they will have been saved in your local character set and are not compatible with UTF8.

By default DataLoad processes data in your local Windows character set. That is described here. In some R12 forms the mouse navigation may not work or the focused field may not change when the user clicks in a new field. This can be fixed by closing the form when it is first automatically opened in recording mode, that is before you enter any data, and re-opening it from the Navigator.

We also recommend the latest Oracle Forms focus patch is applied to maximise forms stability. More details can be found here. Oracle Forms' support for pick lists list of values on playback can be poor and problems have been identified where either the value is not inserted into the field or the wrong value is inserted.

To avoid such problems it is strongly recommended that when the load file is recorded data is not picked from a list of values in order to populate a cell. Instead, the data should be directly typed into the field. Typing the data into the field also makes for a more performant playback and often makes editing the load easier.

Where a pick list must be used the behaviour of the pick list on playback should be carefully tested to ensure the field is populated with the correct data. This generally happened with Oracle Forms 6i, 6. The full text of the error in the Java Console is a follows:. FRM Your connection to the server was interrupted.

EOFException at java. This issue is fixed by recording the forms session at the same time as running the playback. See the Setup page for information on using the record and play parameters at the same time, which is now the default setup. If there is a resize command for the Navigator window then a playback will stop at that point with the following error message - "FRM Cannot resize view: Invalid Size".

Commands such as the following cause this error and should be manually removed from the forms load file please contact DataLoad Support for help making this change :. The most likely cause is that the recorded file is missing the first keyword on each line, thus rendering the file useless. This behaviour has been seen on Windows and Solaris servers, but may affect other platforms too. The problem was introduced by the later Developer 1.

The most common problems encountered are usually resolved by changing or adding delays. If spurious errors occur, or keystrokes are being missed, insert or increase a delay. Start with large delays to determine if a pause helps. If it does, gradually reduce the delays to the minimum that works. Delays can particularly help when saving records, navigating into fields with pop lists, or when activating a menu. Delays are also important in less obvious situations, such as the following example.

You are running a load but occasionally data is pasted into the wrong field, in this case the field before the one that was intended. The DataLoad cells look like the following The field where 'Data1' should be entered is actually being populated with 'Data2'.

This can occur as follows Thus, because DataLoad is sending data faster than Oracle can process it, data is pasted into the wrong field. The solution is to slow down the speed of the load. Jump to navigation. Use the most popular data loader for Salesforce to quickly and securely import, export and delete unlimited amounts of data for your enterprise. Use your existing Salesforce credentials to log into dataloader. Spend less time mapping data from the source file to the Salesforce fields with features such as auto-mapping, keyboard shortcuts and search filters.

Contact DataLoad Support at:. If you contact us concerning a problem you are having with DataLoad please supply as much of the following as possible:. DataLoad version Application name and version, e. One copy of the software product may be installed on a single computer for each license obtained from JD Stuart Ltd. Any such restrictions to the license will be documented by JD Stuart Ltd when the license is granted.

The primary user of the computer on which the software product is installed may make a second copy for his or her exclusive use on a portable computer. No other copies are allowed to be installed under this license.

The software product may not be used by the owner s of this license, including their employees or third parties engaged by the licensee, their customers or suppliers with computer systems or components owned or utilised by the licensee's customers or suppliers. Should a supplier or customer of the licensee wish to make use of the software product, or should the license owner, including their employees or third parties, wish to use the software product with a customer or supplier's computer systems, additional licenses must be obtained from JD Stuart Ltd.

You may also store or install a copy of the software product on a storage device, such as a network server, used only to install or run the software product on your other computers over an internal network. However, you must acquire and dedicate a license for each separate computer on which the software product is installed or run from the storage device. A license for the software product may not be shared or used concurrently on different computers. You may not reverse engineer, decompile, or disassemble the software product, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation.

You may permanently transfer all of your rights under this license, provided you retain no copies, you transfer all of the software product, including all component parts and any upgrades, and the recipient agrees to the terms of this license.