Oracle 11g报表和表单属性批量更新 [英] Oracle 11g Reports and Forms Properties Mass updates

问题描述

用于处理Oracle报表和表单的全新功能，因此可以原谅任何术语/语法问题.

Brand new to dealing with Oracle Reports and Forms so forgive any terminology/syntax issues.

给予新的任务以帮助另一位开发人员将新系统安装到位.新系统实质上是现有系统的副本.

Given new assignment to help another developer put new systems into place. New Systems are essentially COPIES of existing systems.

我看到的过程涉及到很多FORM属性(名称和报告组源)的手工更新，对于REPORTS同样如此. FRM和RDF文件. 这些都是手动"完成的，打开/更改/保存/下一步.

The process that I've seen involves a LOT of by hand updates of FORM properties (Names and Report Group Sources) and Same is true for REPORTS. FRM and RDF files. This is all done "by hand", open/change/save/next.

(不要问，这是我们一直这样做"和我们没有时间研究更好的方法"之一).

(Don't ask, it's one of those "we've always done this" and "we don't have time to look at a better way" kind of things.)

但是看着这个，我肯定有更好的方法来解决这个问题. 在调查中，我遇到了一些我认为很方便的脚本.我可以编写一个几乎可以自动执行此操作的小型应用程序，但是有几个问题:

But in looking at this I thought surely there is a better way to handle this. In my investigation I ran across several scripts that I think would be handy. I could write a small app that pretty much automated this, but have a couple questions:

1.以下是处理表格的最佳过程吗?

1.Would the following be the best process for handling forms?

-将表单文件复制到XML进程

--Copy forms file to XML process

for %%f IN (*.fmb) do frmf2xml OVERWRITE=YES %%f

-通过某些应用程序搜索/替换"来批量更新XML

--Do mass update of XML via some app Search/Replace

-将XML文件复制回FMB格式

--Copy XML files back into FMB format

for %%f IN (*.xml) do frmxml2f OVERWRITE=YES USERID=<usr>/<pass>@<db> %%f

1. 对于报告文件，看起来我不得不将RDF更改为REX(?)文件，然后进行批量更新并重新转换吗?对于RDF，我真的不知道 x，但这有点相似..

1. For Report Files looked like I had to alter RDF to be REX(?) files, then do the mass updates and reconvert? For RDFs I really don't syntax but it would be something simliar to..

-将RDF复制到REX

--Copy RDFs to REX

for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v817 batch=yes source=%%f ?????

for %%f IN (*.rdf) do rwconverter userid=scott/tiger@v817 batch=yes source=%%f ?????

(任何有关语法的帮助或链接)

(Any help on syntax appreciated or links)

还是RDF应该采用其他格式? JSP?

Or should the RDFs go to some other format? JSP?

-通过某些应用搜索/替换"来批量更新REX

--Do mass update of REX via some app Search/Replace

然后使用rwConverter将REX文件复制回RDF吗?

Then use rwConverter to copy REX files back to RDF?

转换为REX然后返回会导致报告出现任何问题吗?

Will converting to REX then back cause any issue for reports?

推荐答案

可以使用JDAPI处理Forms批量更新，JDAPI包含在Forms Builder的安装中.FormsBuilder->帮助->在线帮助- >目录->使用JDAPI编程Oracle Forms.

Forms mass update can be handled using JDAPI which is included with the forms builder install.A good starting point is in Forms Builder -> Help -> Online Help -> Contents -> Programming Oracle Forms with JDAPI.

注意:以下环境变量需要正确设置:

Note: the following env variables need to be set correctly:

ORACLE_HOME={your forms/reports install}\{Oracle_FRHome1}
CLASSPATH=%ORACLE_HOME%\jlib\frmjdapi.jar;%CLASSPATH%
FORMS_PATH={path to your fmb's}
PATH=%ORACLE_HOME%\jdk\bin;%PATH%

JDAPI仅适用于表单，菜单和库，不适用于报表.我已经使用它成功地修改了400多个窗体的应用程序，所做的更改包括创建块，移动按钮，字体更改，窗口和画布大小更改，删除了不赞成使用的字段.

JDAPI works only on Forms, Menus and Libraries, does not work for Reports. I have used it to successfully modify a 400+forms application, changes included creating blocks, moving buttons, font change, window and canvas size change, removing deprecated fields.

报告大规模更新，在转换为xml然后进行编辑方面，我获得的成功有限，该过程适用于简单的报告，对于复杂的报告，在转换为XML然后再返回到RDF时缺少组件(这可能是我们的报告所特有的，您可能会有更好的结果.

Reports mass update, I have had limited success converting to xml then editing, the process worked on simple reports, on complex reports there were missing components when converting to XML then back to RDF (this may have been specific to our reports, you may have better results).

这篇关于Oracle 11g报表和表单属性批量更新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！