📄 faq.htm
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>DataLoad FAQ</title>
<base target="_self">
<link rel="stylesheet" type="text/css" href="comstar.css">
</head>
<body bgcolor="#FFFFFF" link="#0000FF">
<h1>Frequently Asked Questions</h1>
<p><b>Q.</b> How much does DataLoad cost?</p>
<p><b>A.</b> There are two versions of DataLoad, Classic and Professional.
DataLoad Classic is absolutely free of any charges to download, use and
distribute. DataLoad Professional is a commercial product containing advanced
functionality for loading data via the forms server using the Oracle Forms
playback technology.</p>
<p><b>Q. </b>Why isn't data being sent to my form(s) (Copy & Paste mode, not
Forms playback)?</p>
<p><b>A.</b> First you need to establish whether it is DataLoad that isn't
sending the data or Oracle that isn't pasting into the forms. Run the following
tests to identify the issue:</p>
<ol>
<li>Use DataLoad to send your data to something other than Oracle, E.g. try
sending your data to notepad.</li>
<li>Try to copy and paste data into Oracle yourself.</li>
<li>Send your data from DataLoad as simulated keystrokes, i.e. prefix the data
with a '\'.</li>
</ol>
<p>If 1 and 3 succeed while 2 fails then Copy and Paste isn't working in the
Oracle forms. Two common reasons for this are:</p>
<ol>
<li>When your applet is unsigned, i.e. your windows have yellow bars at their
base copy and paste doesn't work. Run 'appscert.bat' to create the 'identitydb.obj'
file.</li>
<li>Copy & Paste won't work in flexfields in release 11.0.x until 11.0.3
and patch 857097 has been applied.</li>
</ol>
<p>If test 1 didn't work or test 2 does work then contact <a href="mailto:dataload@comstar.co.uk">DataLoad</a>
support.</p>
<p><b>Q</b>. Why don't my mouse clicks work (Copy & Paste mode, not Forms
playback)?</p>
<p><b>A</b>. Follow the same testing procedure as described in the previous
answer but with mouse clicks rather than data.</p>
<p><b>Q.</b> Why can't I use Excel-like formulas and functions in DataLoad?</p>
<p><b>A.</b> DataLoad doesn't support Excel-like functions and formulas and we
don't intend to introduce this functionality because we would just be
replicating Excel. We recommend that users who need to use formulas build their
loads in Excel then transfer the data to DataLoad when the load is ready. To
help facilitate DataLoad V4.2 and above includes fast Excel Import
functionality. This allows the user to import data from Excel in one mouse click
and there is also the option to start the load as soon as the data has been
imported too.</p>
<p><b>Q.</b> Does Oracle support data loaded into Oracle Applications using
DataLoad?</p>
<p><b>A.</b> Although Oracle does not support the DataLoad product they do
appear to support data loaded via Oracle. Indeed, Oracle Support have been known
to recommend DataLoad to customers in certain situations. This has been recently
confirmed by the posting of a Note on <a href="http://metalink.oracle.com" target="_blank">Metalink</a>,
Note 147380.1, which again appears to give Oracle's blessing to DataLoad.</p>
<p><b>Q.</b> Why doesn't *PB or *NB work in Oracle Applications 11i?</p>
<p><b>A.</b> A number of users have reported issues with *PB and *NB in 11i, and
while we have not been able to reproduce these we have identified two possible
causes of this problem:</p>
<ol>
<li>Only JInitiator 1.1.8.x should be used with 11i. Companies using 1.1.7.x
or the Appletviewer are not using an Oracle certified version so some
functionality may not work. At then time of writing, the latest certified
version of JInitiator is 1.1.8.13 and we recommend that version is tried.</li>
<li>Developer/2000 6i had problems with the PgUp and PgDn keys before Patch 2.
Please ensure you test DataLoad on a system with the highest Developer/2000
patch possible and at least Patch 3, since Patch 2 is not certified for use
with Applications. The current latest certified patch for most platforms is
Patch 6 and we recommend that is used.</li>
</ol>
<p>If you are unsure what versions of software you are using please ask your
Applications DBA.</p>
<p><b>Q.</b> Why doesn't the *CW() command change forms in 11i?</p>
<p><b>A.</b> The *CW() command is to change the active window not the form. The
command was actually introduced with the intention of it being used to change
forms, and this works fine in 10.7 NCA and 11.0.x because each form is a
separate window. However, we knew that 11i returned to the single parent window
approach so named the command *CW rather than something like *CF (Change Form)
because it does actually change the window not the form.</p>
<p>In order to change the active form in 11i you will need to enter the
keystrokes and/or mouse clicks in DataLoad that will open or activate the other
form for you. In other words, make a note of how you would do this when using
the Applications and setup DataLoad to action the same sequence of keystrokes.</p>
<p><b>Q.</b> In forms playback, how can we easily check what data has been
loaded?</p>
<p><b>A.</b> During the playback you can also record by adding a record
parameter to the command line. In 11i this needs to be added to the URL. For
example, add the following to the URL, replacing '[filename]' with the name of a
file to record to:</p>
<blockquote>
<p>&record=[filename]</p>
</blockquote>
<p>The whole load will be recorded to that file. When the load completes open
this file in DataLoad and you will be able to see what the load did.</p>
<p><b>Q.</b> Can I use DataLoad with Oracle Applications 11i?</p>
<p><b>A.</b> DataLoad works with any Windows based applications and there are no
issues using DataLoad with 11i. A number of changes have been made to
shortcuts in 11i, therefore the commands.dat file does need to be updated to
reflect these changes when using the Copy & Paste functionality. The
revised commands file is available to <a href="../download.htm#R11icommands">download</a>.</p>
<p><b>Q.</b> How do I toggle a checkbox in Keystroke simulation mode?</p>
<p><b>A.</b> Use a single space in the cell or the *SB command</p>
<p><b>Q.</b> How do I select an item from a pick drop down list?</p>
<p><b>A. </b>Values can be selected by the first letter of the value. Where 2
values begin with the same letter, repeating the letter moves down the list. For
example:</p>
<p><img src="Image6.gif" width="219" height="115"></p>
<p>Column containing <b>I</b> would select <b>Indirect</b></p>
<p>Column containing <b>C</b> would select <b>Contract</b></p>
<p>Column containing <b>CC</b> would select <b>Capital</b></p>
<p><b>Q.</b> Is DataLoad Classic open source/can we have the source code?</p>
<p><b>A.</b> No! Even though DataLoad Classic is free it is not open source
software and the source code is not available.</p>
<p><b>Q. </b>The DataLoad spreadsheet isn't big enough, how do I make it bigger?</p>
<p><b>A.</b> DataLoad versions prior to V4.1 had a fixed grid size, but
inserting rows or column using "Edit, Insert⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -