Home » Developer & Programmer » Forms » creation of text file of form
creation of text file of form [message #132759] Tue, 16 August 2005 01:03 Go to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
i want to create a text file of all the information written as source code in the form
can anyone tell me is there any way to generate a text file of information stored in forms

thanks
sarfraz
Re: creation of text file of form [message #132767 is a reply to message #132759] Tue, 16 August 2005 01:45 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
If you are using 4.5 or earlier, use the administrative function to give you a text file. If you are using 9i or later, then use the XML extraction program. Alternatively, you can buy a tool like FormGreg or FormsTool and get them to dump it for you.

David
Re: creation of text file of form [message #132778 is a reply to message #132767] Tue, 16 August 2005 02:55 Go to previous messageGo to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
hi
thanks for ur reply
can u pl explain me what is XML extraction program and from where i can get it or how to run it

thanks
Re: creation of text file of form [message #132915 is a reply to message #132778] Tue, 16 August 2005 18:49 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
From my notes on 6i to 9i conversion.
Quote:

5. Oracle 9i Forms has command level support programs that can handle fmb, mmb, and olb files.

They are:

For NT/2000/XP:
iff2xml90.bat - Converts Forms Modules to XML format,
Oracle9i Forms to XML Tool
Copyright(c) Oracle Corporation 2001. All rights reserved.

File /? does not exist

Correct usage:
   java oracle.forms.util.xmltools.Forms2XML [options] file1 [file2...]
The tool will accept .fmb, .olb and .mmb files.
Options: (default value in brackets)
DUMP=ALL/OVERRIDDEN dumps ALL properties or just those OVERRIDDEN (OVERRIDDEN)
OVERWRITE=YES/NO overwrite files that already exist (NO)

ifxml2f90.bat - Converts XML to Forms Modules,
Oracle9i XML to Forms Tool
Copyright(c) Oracle Corporation 2001. All rights reserved.
Nothing to do.

Correct usage:
  java oracle.forms.util.xmltools.XML2Forms [options] file.xml [file2...]
Options: (default value in brackets)
OVERWRITE=YES/NO overwrite files that already exist (NO)
PRINTTREE=YES/NO prints a forms object tree as the xml is parsed (NO)
USERID=database connection string - for record group queries (none)

NOTE: Verify that the fmb file is write enabled before running the ifxml2f90 command.

ifxmlsg90.bat - Generates the Forms XML Schema (forms.xsd), and
Oracle9i Forms XML Schema Generator
Copyright(c) Oracle Corporation 2001. All rights reserved.

Forms XML Schema saved as forms90.xsd


ifxmlv90.bat - Validates the structure of a Forms XML file.
Oracle9i Forms XML Validator
Copyright(c) Oracle Corporation 2001. All rights reserved.


file:/I:/?<Line 1, Column 8>: XSD-2038: (Error) Can not find definition for element 'title'
file:/I:/?<Line 2, Column 1>: XML-0100: (Error) Expected 'EOF'.
Invalid XML - file /? does not validate against Forms XML Schema:
Can not find definition for element 'title'



Look for 'xml' in the Forms help system. The 'bat' files are in the Oracle 9 Forms directory structure, just search for them (probably in the 'bin' directory).

David
Re: creation of text file of form [message #132953 is a reply to message #132915] Wed, 17 August 2005 00:42 Go to previous messageGo to next message
sarfraz_attari
Messages: 123
Registered: July 2005
Senior Member
i dont find any of this command on my orant/bin directory
i have developer 6.0
pl advice

thanks
Re: creation of text file of form [message #132957 is a reply to message #132953] Wed, 17 August 2005 00:59 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Then either buy one of the two tools that I recommended or attempt to use the FMT output.

David
Previous Topic: reg locking mode in forms
Next Topic: inserting unique id against each record
Goto Forum:
  


Current Time: Fri Sep 20 00:27:25 CDT 2024