Hi all,

I have large number of tables and view. I want to create formspider datasource defenition and datasource for all of them. Instead of creating them manually I am looking for a solution (probably sql script) that will create them automatically.

The rules to apply are

  1. Do not want to create if it is already present in formspider.
  2. I want to keep my datasource defenition and datasource names the same.
  3. Should also create bind varrables.
  4. Should be able optionally write a WHERE clause.

One suggestion I can think of is the piece of script that you use for exporting the datasource from the formspider UI. This can be modified for creating formspider XML script from database table and then the generated xml file can be imported to formspider UI.

Once it is ready all developers can use the script for easy creation of datasource.

Kindly help with a little script.


asked 23 Jan '14, 18:12

grajan777's gravatar image

accept rate: 10%

edited 23 Jan '14, 23:44

Be the first one to answer this question!
toggle preview

Follow this question

By Email:

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



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



Asked: 23 Jan '14, 18:12

Seen: 1,223 times

Last updated: 23 Jan '14, 23:44

© Copyright Gerger 2017