After building a web application using Formspider, I would like to have deployed the application for production (hosting). Is there a tool or steps to be followed to do this?

asked 20 Dec '11, 08:46

asdr's gravatar image

asdr ♦
9949
accept rate: 8%

Yes, it can. How it is given is described as an aswer to this question because of the text being too long for this comment area.

(19 Aug '12, 00:45) formspider ♦♦

IMPORTANT!!!

Starting with Formspider 1.9. there is a new export and import API. Please see this thread for more information on how to use the new export/import API's.

-----------


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;
/

link

answered 20 Dec '11, 08:48

formspider's gravatar image

formspider ♦♦
138310
accept rate: 22%

edited 03 Nov '15, 09:05

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5

Good morning.

For work purposes, what you mentioned works great.

Are there ANY hosting companies for personal applications that support FormSpider.

I can surely install the application on my personal PC. However I am a bit concerned if I have open only the ports that are needed to access the application from outside.

Is there any information that can be followed to ensure we do it right, if I have to install it on my PC and open it to the public?

Thank you, Viswa

link

answered 31 Mar '14, 09:15

viswapsp's gravatar image

viswapsp
36112
accept rate: 11%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×15
×2
×2
×2

Asked: 20 Dec '11, 08:46

Seen: 4,239 times

Last updated: 03 Nov '15, 09:05


© Copyright Gerger 2017