Answers to: Automatic datasource creation scripthttp://osqa.theformspider.com/questions/2435/automatic-datasource-creation-script<p>Hi all,</p>
<p>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. </p>
<p>The rules to apply are </p>
<ol>
<li>Do not want to create if it is already present in formspider. </li>
<li>I want to keep my datasource defenition and datasource names the same. </li>
<li>Should also create bind varrables.</li>
<li>Should be able optionally write a WHERE clause. </li>
</ol>
<p>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.</p>
<p>Once it is ready all developers can use the script for easy creation of datasource.</p>
<p>Kindly help with a little script.</p>
<p>George.</p>enMon, 21 Jan 2019 17:31:17 -0000