agazibara
skipping stones
Posts:24
 |
| 08-16-2006 12:34 AM |
|
User guides for Dynamic Forms module in DOC, PDF and CHM formats can be downloaded from the following locations:
|
|
|
|
|
Tim Cadieux
wading in the water
Posts:17
|
| 09-05-2006 04:38 AM |
|
My client wants to be able to Export the Questions and Answers to an Excel spreadsheet if possible, any help would be appreciated. |
|
|
|
|
Chad Nash
Posts:5260
|
| 09-11-2006 08:45 AM |
|
Hi. Right now there is no easy import/export feature but we will look to add that in the next release. One thing you can do is create a Dynamic Event within the module that is a SQL event and will insert all of the questions,answers into a table then you can then export them from? Its pretty easy to export from MS SQL to CSV or Excel. |
|
|
|
|
Tim Cadieux
wading in the water
Posts:17
|
| 09-12-2006 04:27 AM |
|
Can you provide any type of example, i am not a coder.
thank you. |
|
|
|
|
Chad Nash
Posts:5260
|
| 09-12-2006 09:21 AM |
|
Well until we implement the export feature you would at least have to have some experience working with SQL (at a minimum access to the SQL Server to be able to access query analyzer or run reports).
Steps would be:
1. Create a table called 'YourTable', within your table create a column for each question within Dynamic Forms.
2. Within Dynamic Forms create a dynamic SQL event. The SQL Event would insert data into your table and the SQL would be similar to:
INSERT INTO YOURTABLE(Question1, Question2, Question3) Values($(DynamicFormField1), $(DynamicFormField2), $(DynamicFormField3))
Once the user submits the form the data would be inserted into your custom table.
3. Within query analyzer you can 'select * from your table' and export that to CSV or Excel.
Again, ill try and see if we can implement a quick Export feature within the coming weeks though since it doesn't sound like too much work. |
|
|
|
|
Tim Cadieux
wading in the water
Posts:17
|
| 09-14-2006 07:05 AM |
|
That would be excellent, i am looking forward to this.
thank you. |
|
|
|
|
Tim Cadieux
wading in the water
Posts:17
|
| 10-11-2006 10:47 PM |
|
Has there been any progress on this new feature? |
|
|
|
|
Tim Cadieux
wading in the water
Posts:17
|
| 10-12-2006 05:47 AM |
|
Any word on this, we'd really like to be able to implement this feature/ |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-12-2006 01:50 PM |
|
Tim,
Along with many other enhancements and easier export feature will be part of the next release. We hope to release 2.2 for Dynamic Forms by the middle of November. Ill let you know if we have a pre-release or beta ready before then to see if you are interested.
-Chad
|
|
|
|
|
Tim Cadieux
wading in the water
Posts:17
|
| 10-13-2006 05:05 AM |
|
Awaiting patiently, thank you. |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-18-2006 09:47 AM |
|
Hi. I just wanted to let you know that this has been released as a feature in 2.1 of Dynamic Forms. |
|
|
|
|
Felix Demol
new to the springs
Posts:1
|
| 05-24-2007 12:17 AM |
|
Is it possible to use stored procedures when you create a dynamic SQL event ?
Is it possible to have multiple sql-statements in one dynamic SQL event ( purpose : using a normalized table with 3 columns, 1 row for each question => a column wherin a unique id to identify the whole query form, a column for the question, a column for the answer ) ?
|
|
|
|
|
Chad Nash
Posts:5260
|
| 05-24-2007 07:28 AM |
|
Yep. You can pass the properties to the stored procedure from the SQL event and you can execute the SQL directly.
i.e.
exec stp_your procedure '$(FirstName)', '$(LastName)'
IF you wanted to do multiple queries or hit multiple stored procedures you can just add GO to the end of each statement. I.e.
exec stp_your procedureOne '$(FirstName)', '$(LastName)'
GO
exec stp_your procedureTwo '$(FirstName)', '$(LastName)'
GO
exec stp_your procedureThree '$(FirstName)', '$(LastName)'
Hope this helps! |
|
|
|
|
Dante Eickhoff
new to the springs
Posts:1
|
| 05-28-2007 11:46 AM |
|
I need to import users from another instance of DNN. Why product to use? |
|
|
|
|
selamat selamat
new to the springs
Posts:1
|
| 10-01-2008 02:12 PM |
|
I am currently testing dynamic form trial version. I tried to drag and drop the icon but It does nothing or it doesn't create the new dynamic field. Is it because of trial version? |
|
|
|
|
Chad Nash
Posts:5260
|
| 10-06-2008 07:41 AM |
|
Hi, we actually discovered an issue with the drag and drop that has been fixed within the latest patch/release. The issue only exists if you try and use the drag/drop feature though for the very first field. If you use the wizard or standard ‘manage questions’ area to add the first field then you should be able to add any fields after that without any issues.
-Chad
|
|
|
|
|