agazibara
Posts:0
 |
| 08-16-2006 2:34 |
|
User guides for Dynamic Forms module in DOC, PDF and CHM formats can be downloaded from the following locations:
|
|
|
|
|
Tim
Posts:18
wading in the water
|
| 09-05-2006 6:38 |
|
| My client wants to be able to Export the Questions and Answers to an Excel spreadsheet if possible, any help would be appreciated. |
|
|
|
|
Chad
Posts:2385
river guide
|
| 09-11-2006 10:45 |
|
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
Posts:18
wading in the water
|
| 09-12-2006 6:27 |
|
Can you provide any type of example, i am not a coder.
thank you. |
|
|
|
|
Chad
Posts:2385
river guide
|
| 09-12-2006 11:21 |
|
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
Posts:18
wading in the water
|
| 09-14-2006 9:05 |
|
That would be excellent, i am looking forward to this.
thank you. |
|
|
|
|
Tim
Posts:18
wading in the water
|
| 10-12-2006 12:47 |
|
| Has there been any progress on this new feature? |
|
|
|
|
Tim
Posts:18
wading in the water
|
| 10-12-2006 7:47 |
|
| Any word on this, we'd really like to be able to implement this feature/ |
|
|
|
|
Chad
Posts:2385
river guide
|
| 10-12-2006 3:50 |
|
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
Posts:18
wading in the water
|
| 10-13-2006 7:05 |
|
| Awaiting patiently, thank you. |
|
|
|
|
Chad
Posts:2385
river guide
|
| 10-18-2006 11:47 |
|
| Hi. I just wanted to let you know that this has been released as a feature in 2.1 of Dynamic Forms. |
|
|
|
|
Felix
Posts:1
new to the springs
|
| 05-24-2007 2:17 |
|
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
Posts:2385
river guide
|
| 05-24-2007 9:28 |
|
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
Posts:1
new to the springs
|
| 05-28-2007 1:46 |
|
| I need to import users from another instance of DNN. Why product to use? |
|
|
|
|
selamat
Posts:1
new to the springs
|
| 10-01-2008 4:12 |
|
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
Posts:2385
river guide
|
| 10-06-2008 9:41 |
|
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
|
|
|
|
|