Tags: apex, apexexport, apexexportclass, bubble, class, created, database, export, exporting, install, java, mysql, oracle, page, provided, sql
APEXExport.class export comments?
Does the APEXExport java class provided with the APEX 2.2 install support exporting the new page comments (Created with the comment bubble next to the run page icon in the upper right of a page edit screen)?
Leave a comment...
- 7 Comments
- From the readme.txt file in the utilities folder, seems like there is a new Java class that does component level exports
APEXExportSplitter Usage Instructions
The program APEXExportSplitter can be used used to split Oracle Application Express export files
into separate SQL scripts. This is useful for management of files corresponding to
the discrete elements of an Application Express application.
1) To use APEXExportSplitter, a JDK of version 1.4 or greater must be used.
To set the CLASSPATH, following are some examples:
...from the Bash shell or ...
...from Windows environments.
2) From the apex/utilities directory, issue the command:
...returns the following output with usage directions.
Usage java oracle.apex.APEXExportSplitter filename
-help : <
print this syntax >
-flat : <
flat file structure >
-debug : <
print debug info >
-update : <
create update file >
-nochecksum : <
don't check for changes >
3) To split an application export file (f123.sql in this example) creating sub directories for
each component type, issue this command:
java oracle.apex.APEXExportSplitter f123.sql
4) To split an application export file (f123.sql in this example) containing the component type
in the file name (not creating any directories), issue this command:
java oracle.apex.APEXExportSplitter f123.sql -flat#1; Fri, 22 Feb 2008 16:36:00 GMT
- I thought that might be the case, except the APEXExportSplitter class operates on an existing export file, and not the database.
Therefore, if the export file generated doesn't contain the comments, how can the export splitter split them into their individual components?
I'm just hoping that the APEXExporter does indeed support exporting of page comments some how. (The default options in APEXExporter does not export these comments)#2; Fri, 22 Feb 2008 16:37:00 GMT
- I'm guessing from lack of comments that there is no hidden option for APEXExport which will export page comments like setting Export Comments = YES in the htmldb export wizard will do?#3; Fri, 22 Feb 2008 16:38:00 GMT
- Joe: You are right, I didn't notice that the splitter class operates on a file and not on the database itself.
Don't know, maybe Mike or Joel can jump in.
Thanks#4; Fri, 22 Feb 2008 16:39:00 GMT
- The APEXExport java class provided with the APEX 2.2 currently does not support export of page comments.
This is something that is a great candidate for a future release.
Joel#5; Fri, 22 Feb 2008 16:40:00 GMT
- The APEXExport java class provided with the APEX 2.2 currently does not support export of page comments
I had a need to do this recently and turns out the internal APIs already support it so I went ahead and modified the Java class to do it.
Download the Command line export utility from the APEX Studio and modify the HTMLDBExport.java file
v_plsql = v_plsql + " wwv_flow_gen_api2.export(p_flow_id=> p_appID,p_page_id=>p_pageID);
v_plsql = v_plsql + " wwv_flow_gen_api2.export(p_flow_id=> p_appID,p_page_id=>p_pageID,p_export_comments=>'Y');
Works like a charm.#6; Fri, 22 Feb 2008 16:41:00 GMT
- I've noticed a buglet with the APEXExportsplitter...
If you have multiple computations for the same application level item, only one of the computations is remains after splitting. I guess that this because of the way in which the utility generates the filenames.#7; Fri, 22 Feb 2008 16:42:00 GMT