How can I deploy a Formspider application for production?

First, install Formspider to your production environment using the Formspider installer. If you do not want to use the Formspider IDE in your production environment, uncheck “Formspider IDE Database Components” and “Formspider IDE Client” options during installation process.

Next, open the Formspider IDE in your development setup. Then select File-->Export from the menu. The export dialog will show up. Select the application you want to export from the combo box and choose the Export Entire Application radio button. Click Export and download the export file.

You may import your application in two different ways to production environment. If you installed Formspider IDE application, select File-->Import from the menu. The Import Dialog will show up. Choose your application export file and import it as a new application (If you want to overwrite an application already in production choose replace).

If you don’t have the Formspider IDE in your production environment, you may also import your application in the following way. Please note that you need an Oracle directory to place your application export file.

The following script will import your application to the Formspider installation in production without the need of an IDE. You will have to provide a value for three parameters: Oracle directory name, Application Name and Application export file name.

declare
v_oracleDirectory_tx varchar2(255) := '&oracleDirectoryName';
v_applicationName_tx varchar2(255) := '&applicationName';
v_xmlFileName_tx varchar2(255) := '&applicationExportFileName';

v_cl clob;
v_file bfile;
v_destoffset number:=1;
v_srcoffset number:=1;
v_warning number:=0;
v_context number:=0;
v_objectRecord_tt bdf_etl.tt_importObjects;

begin

bdf_application_api.applicationdelete(
    in_application_oid=>bdf_application_qry.getid(v_applicationName_tx),
    in_cascade_yn=>'Y');

dbms_lob.createtemporary(v_cl,true);    
v_file := BFILENAME(v_oracleDirectory_tx, v_xmlFileName_tx);

dbms_lob.open(v_file, dbms_lob.lob_readonly);

dbms_lob.loadclobfromfile(v_cl,    
    v_file,    
    DBMS_LOB.LOBMAXSIZE,    
    v_destoffset,    
    v_srcoffset,    
    0,    
    v_context,    
    v_warning);

dbms_lob.close(v_file);

bdf_etl.load(in_bdf_xml=>xmltype(v_cl),
    in_importOption_cd =>'AsNewApplication',
    in_projectOption_cd=>bdf_constant_etl.etlcreateOrReplace,
    in_applicationOption_cd=>bdf_constant_etl.etlcreateOrReplace,
    in_importObjects_tt=>v_objectRecord_tt);

commit;

end;
/