Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Popular Posts

Tags

2008 2008 Express Add AFTER alert Alias Aliases Alter Alternating And ASC Assist BETA Blog Cancel Check ON Checkbox Checkbox Group Color Column Columns Combo Box Composite Confirm Confirm Message Control CREATE CREATE TABLE Data Data Springs Database DDL DELETE Delete Confirm Demo Demonstration DESC Direct Access DNN DotNetNuke Drop Drop Constratint Drop Down Drop Down List DS Dynamic Dynamic Blog Dynamic Forms Dynamic Registration Dynamic Views Edit Event Example Express Fade In Fade Out Field Filters FK Forms Full-Table Scan Generating Generator Generators Great Ideas Group Help HTML Increase Index Indexes Input Integrity jQuery Label Listbox Listener Message Modify My Account MySQL No NULL Often Ok ON Optimization Optimize Option Options Oracle Order By Perform Performance PK Popup PostreSQL Queries Query QuestionOptionValue Radio Button Radio Button Group References referential Round Script Search Search Filters SearchOption SearchOptionValue Select Server Snippet Sort Springs SQL SQL Driven SQL Driven Query SQL Express SQL Server SQL Server 2005 SQL Server 2008 SQL Server 2008 Express SQL Server 2008 R2 SQL Server Express SSMS Stored Stored Procedure TABLE Tables Temporary Tool Tools Tooltip Tooltips Transact-SQL Trials Triggers TSQL T-SQL Unique UPDATE Use Useful Views Widget Widgets Window Yes [userimage] 10 64 bit Ability ABS Action Active Forums Alleviate Alternating Colors Alternating Rows Analytics ARB asp.net asp.net validation AuthARB Authorize.NET Avoid Back Button Basecamp Blog Blog Posts Blogging Browser Browser Back Browser Close Browser History Browser Script Button cascading style sheet Case Char Character CharAt CharAt() Check chip levinson Click client side validation Close Browser Close Window Collection 5.0 Comment Compatibility Compatible Completion completion event Confirm Message Conform Constraints content localization Count Timer Countdown CRM css csv Cursor Custom Custom HTML Custom JavaScript Custom JavaScript File customer feedback Customize Data Data Integrity Data Springs Data Springs Blog Data Springs Collection Data Springs Development Data Springs Planning Data Springs Training Databases DataSprings Date Time JavaScript Debug Info default value Delete Demonstration DF DNN DNN Authentication DNN Blog DNN Core Profile Property dnn html module dnn modules dnn schedule error dnn schedule multiple DNN Store document document.getElementById DotNetNuke dotnetnuke 5.4.4 DotNetNuke Analytics DotNetNuke Forums DotNetNuke JavaScript DotNetNuke Modules dotnetnuke reporting dotnetnuke scheduler dotnetnuke user image Double Double Quotes DR DROP Drop Constraint DropDown Login DS dynamic Dynamic Data dynamic fields Dynamic Form Dynamic Forms dynamic forms silent post Dynamic Forms Tutorial dynamic login Dynamic PDF Form Completion Event dynamic registration dynamic registration silent post dynamic registration user image dynamic user directory dynamic views DynamicRegistration_Question DynamicRegistration_QuestionResponse email email issues Encapsulated Encapsulation Even Event Event Viewer Example Excel Execute Export Export to Excel Facebook Facebook Connect Field FieldID First FirstName Fix Foreign Key Form Form Post Formatting Forms Forum Flow Full Table Scan Fully Function Google Analytics Google Analytics Ecommerce Great Great ideas Grid guides hidden field Hide Show Rows Highrise Highrise API Hourly Services HTML HTTP Post iDeal IE IE 10 Image Image Button Include Inconsistancy Info Information Injection INSERT Integration Interactive User Import Interface internet Internet Explorer iPAD iPAD App for Highrise iPAD Highrise App Items JavaScript JavaScript hide show JS Function Layout Lead Generation Learn Left Left Quote Link LinkedIn list import Live Blog localization Log Logic Login login module login skin object Loop Mandeeps Match Message Microsoft Live Writer module configuration Modules Monthly Services Name Netherlands New News Blog NL NOT NULL oAuth2 Odd OnClick Open Web Studio opt in email OWS Part 1 Part 2 Passed payment gateway paypal Phone Number Placement Post Postback Posts Premium Integration Premium Services Premium Support Primary Key Procedure Products profile Quarterly Services Question question fields Question Loop Question Value QuestionOption Quick Quotes Recommend Recommendation Recurring Billing Redirect Referential Integrity registration Rendered Replace replace html text report views reports Resolution Resource resource files resx Retrieve Retrieving Right Right Quote Rows Ryan Bakerink Sales Force SalesForce Script Scripting Scripts Sequential Access server side validation Silent Post Single Single Quotes Single Sign On skin object Snowcovered Solution sp Springs SQL sql 2005 pivot sql default value SQL Example sql import SQL Injection sql query sql replace statement sql reports SQL Server sql server 2005 SSL SSO stored stored procedure String style sheet stylesheet Submit Submit Button Submit Image Submit Link success story Suggest Suggestion Support Syntax Table technical techwise research Temp test credit card numbers testimonial Text/HTML thumbnail image Time Timer Tip Token Topic Transaction Trial Trigger TSQL T-SQL Tutorial Twitter Types of Constraints Unique Update Highrise user user directory user profile image users online Variable View Web Based Work Around writer writing xls xlsx XML

In the Flow

rss

Data Springs, Inc. - An online diary and web log from staff and customers for premium DotNetNuke resources, Data Springs Modules, and Data Springs Services.


Dynamic Views - Common Questions / Potential Issues / Solutions

Several customers have had some issues with Dynamic Views recently depending on your specific version of Dynamic Views and implementation type (table, VS Dynamic Forms, etc...)

Below are a few of the most common situations and some of the best ways to solve the problems.

Occurrence #1


Issue: When selecting Dynamic Forms as a data source type, no Dynamic Forms instances appear.

Explanation: This is caused by certain DNN versions because the module title that is used is pulled in from a different table then versions of DNN prior to 5.2.3.

Solution: If this is happening please run this query under Host/SQL.

Occurrence #2


Issue: When selecting Dynamic Forms as a data source type, whenever saving the module instance the setting is not getting saved properly and its always reverting to the first/initial Dynamic Forms instance.

Explanation: This is a known bug in an earlier version of the initial 2.0 release.

Solution: If this is happening please contact support or check the patches and hot fixes for the updated 2.0 release.

Occurrence #3


Issue: When selecting / clicking 'Generate Columns' for a specific Dynamic Forms instance, no columns get generated.

Explanation: This is a common problem on very large forms. When you use the Dynamic Forms data source, what is really happening is that the stored procedures are generating a column within a temporary table for each and every question label within your form. So, this can create a problem in some situations if you 1. have the same question label multiple times in you form. 2. have question / question labels that
include invalid characters etc... Basically, if you would not be able to go into SQL Server and create a new table with each column named the same as a question label within your Dynamic Forms instance, the queries we use to do this also will fail.

How do you know if this is your situation? The best way to test and see if this is what is happening within your implementation is to create a sample Dynamic Forms instance with only a couple of fields (all with unique question names) and see if this form instance can generate columns. If this form instance can generate columns correctly but others cannot then the reason is likely because of some specific field(s) and their labels on those form instances.

Solution #1:
Check your form instance that is causing problems. Do you see any questions that are repeated with the same exact question label? Do you see any questions that appear to have invalid
character’s in them if you were to try and create a column with that same name?  If these are easy fixes then simply change/modify these questions accordingly.

Solution #2:
You can modify the query that Dynamic Views uses(both the 2.0 and 2.1 release) to utilize collecting Dynamic Forms fields based on the short field name for each column instead of based
on the question label. This query also checks and only displays questions that don't have more than 1 field with the same short field name (because repeating fields are not allowed, just the same as you could not create two columns with the same name in a SQL Server table).

You can download and execute this query here... After you have executed the query you should go to host, host settings, and click restart application.

Note: this will affect previous view instances so you should consider this when making the change.


Occurrence #4


Issue: When using an external connection, even selecting a basic table or simple query is not returning any results.

Solution #1: When using an external connection, and NOT using the 'free form' option, you will need to create the stored procedure that the module uses to filter results, search results, and limit the number of records returned. This query can be downloaded here, you will need to run and execute the query on the external server. We have removed the database owner and object qualifier parameters because if you are using an external server its likely they are not using these. We also removed the option to integrate with Dynamic Forms because we are assuming that since you are using an external connection you will not need that portion.

Solution #2: Use the free form option...  When do I use the 'SQL Query Free Form Option'? How do I use the free form option?

The free form option was added within the 2.0 release to support queries against external database connections that are (primarily) NOT using SQL Server.

Why? The built in features for selecting only a certain number of records, adding filters / search criteria are handled via database calls and not within the VB.NET  code. So, when you do not select to use the Free Form option you need to make sure you create the stored procedure (mentioned in Occurrence #3). If you are ARE using the free form option you need to keep in mind that things such as filtering the data, limiting the top records, and also your search criteria will not be used within the built in functionality.

Please refer to the user guide for full instructions on how to use search criteria for the free form query option.  The basics are - use $(SearchFieldName) within the SQL Query / stored procedure
to reference the search field value, and use $(SearchFieldName_Condition) to use the condition. So if a user entered 'John' for the search field FirstName and the user selected Begins With as the condition
then the token $(FirstName) would render 'John' within the query and token $(FirstName_Condition) would render 'Begins With'. You could then use the condition string to limit/change your query.

Note: Enable Debug Mode to see the exact SQL query you are sending to your external connection

Tip: Only the 'Free form option' will allow support against a external connection that is not SQL Server.

I would love to hear any comments, suggestions, or issues you run into... I just wanted to compile this list as I thought it would be very helpful!

Thanks,

Chad



Comments are closed.
Showing 7 Comments
Avatar  SK 5 years ago

My situation is like #3. I'm using the Trial version and had to create the SP. When I generated columns I still get rowID, ViewLinkDetail and ViewLinkDetailURL... not columns in the form. The simplist form is Firstname,Lastname created using the form wizard.

Using DNN 6.2.2
DF: 4.0.12 (Unlicensed on a test system)
DV: 3.0.1 (Trial)

Avatar  Mark Saunders 6 years ago

I don't have that supplied Stored Proc after an install of trial version "02.20.10_DNN45Plus_TrialVersion"

Avatar  Dan C 6 years ago

My form view has issues like #3. I simplified the field names but no special char were in before: firstname, lastname, Location (dropdown), Distance (dropdown), notes.
Very simple and small form.
DNN 6.1.3, SQL 2008 R2, Win Server 2008 R2

Avatar  Dan C 6 years ago

Thanks for the post and it appears my DF View is symtopmatic of occourance #3. I have attempted to simplify field names even though there were no character issues: firstname, lastname, location (dropdown), distance (dropdown), notes. I have not tried to create the stored procedure and as you can tell the form is really small so I think this must be another issue: DNN 6.1.4, Win Srv 2008 R2, SQL Server 2008 R2.

Avatar  Ram 6 years ago

Nice Post

Avatar  advertising personal statement 6 years ago

Its realy good site. Very interesting information. Thank you for this sharing.

Avatar  candace 6 years ago

Help! I ran the SQL exactly as it is in the link for occurrence 4, solution 1, and got this:

Msg 156, Level 15, State 1, Procedure DataSprings_RetrieveDynamicView, Line 26
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure DataSprings_RetrieveDynamicView, Line 35
Incorrect syntax near '@SQLToExecute'.

Recent Comments

 
 

Join our mailing list...

Get current news and events the easy way
 
 
   
Subscribe Me

Recent Blogs...

 
Copyright 2005 - 2011 by Data Springs, Inc.