Subtotal: $63,733.00
I am having issues with Live Forms and Live Visualizer communicating. I have a search form created with Live Forms that allows you to search by State or Zip Code. Then Live Visualizer will display the results. I have included the code for the State part below and attached screenshots. When you hit Search, nothing happens. When I run the same SQL query in the DNN SQL editor on that site, it returns results fine which tells me there is either an issue in the module or in the settings I am using. Please help!
Live forms:
SELECT a.firstname, a.lastname, a.email, a.phone, a.phone3, a.city, a.state, a.zip, b.web_address, a.webLocation2, a. webLocation3 FROM NPI_Members a JOIN NPI_CompanyInfo b ON a.CompanyID = b.CompanyID WHERE b.IsNPI = 1 AND b.IsActive = 1 AND a.IsAdmin = 0 AND a.IsStaff = 0 AND a.UserID > 0 AND a.webLocation2 IS NOT NULL AND a.webLocation3 IS NOT NULL ORDER BY a.webLocation3
Live visualizer:
<table class="lv-table lv-table-striped" style="border: 1px solid black;"> @foreach(dynamic row in Model.Submissions){ <tr> <td> <b>@row["a.webLocation2"]</b><br /> @row["a.webLocation3"] </td> <td> @row["firstname"] @row["lastname"]<br /> <a href='tel:@row["phone"]'>@row["phone"]<br /> <a href='tel:@row["phone3"]'>@row["phone3"]<br /> <a href='mailto:@row["email"]'>@row["email"]</a><br /> <a href='@row["web_address"]' target='blank'>@row["web_address"]</a> </td> </tr> } </table>
Please disable cache of visualizer and see if it work. Manage > Edit visualizer > Click on Configure Data Source > disable Cache Results
This issue is already logged to be resolved in next update.
When I click on Configure Data Source, it only gives me the option to pick the data source but that is it. I don't see any options for disable cache results anywhere. Also, did you look at all my samples above? Does it look like I built everything properly?
Please make sure that you are on latest version of Live Visualizer.
Option for disabling cache will be here see screenshot CacheResultOption.png
Followed the instructions to update Live Forms and the Visualizer. Live Forms updated with its dependencies but Live Visualizer won't run the install and now our Porto admin area is gone and I am getting a message to activate the license again but can't since I can't access the admin area to put it back in. Purchased a time slot of premium support (even though I am already on a Premium license that is supposed to cover support) so I can get help ASAP.
Please open a support ticket regarding your issue through https://www.mandeeps.com/support/standard so that we can take a look.
I already did and only get an answer 24 hrs after I post it in the middle of the night here and when I respond I hear nothing else again until the middle of the night the next day. I also own a Premium annual license but it showed I didn't have any premium support I could use so I purchased a timeslot but that didn't seem to do any good. Now I have a broken site and I provided them login creds so they could help me fix the upgrade they said we had to do to fix my original issue and the only reply I got last night was for me to adjust some code and upload a file manually. I am not convinced that is the whole issue. I am at the point where I need to roll back my sites and start again.
David, I see that your ticket was last updated with instructions. We've not heard back from you. We also tried calling you on the phone number provided but could not get past a voicemail.
Your browser doesn't have Flash, Silverlight or HTML5 support.