Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...DNN 8.x - Adding Content To HTML Module Using SQLDNN 8.x - Adding Content To HTML Module Using SQL
Previous
 
Next
New Post
6/14/2016 8:51 AM
 

We have a situation where we would like to have a custom Visual Studio AddOn we created to be able to add a new entry into an HTML Module on a specified page. We wrote the SQL code to identify the module and such. But every attempt to either add a new entry, or even to modify the content of the last (current) entry...results in the changes not being in "published" mode. The changes are visible when editing the page, but in view mode they are not visible. We have to edit the page, then edit the HTML module (like adding and removing a space) just so that a change is registered. Only then will a "Publish" button appear, then we click publish to make the changes appear on the page publicly.

We want to avoid all those extra steps. There must be other records somewhere that we are unaware of that completes the "publish" process on another table somewhere, but we cannot find it. Can anyone shed some light on this?

We have tried two different methods:

  1. Adding a new entry using the DNN stored procedure AddHtmlText
  2. Modifying the currently published entry directly within the table: HtmlText

Both methods result in "unpublished" content, regardless of the published state of the records added/modified.

Thank you for any assistance.

-Ben

 


Ben Santiago, MCP Certified & A+ Certified
Programmer Analyst
(SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS, Cognos ReportNet)
 
New Post
6/14/2016 8:57 AM
 
this might be caused by workflow, did you check table HTMLTextLog and add an item as well?

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/14/2016 9:20 AM
 

I thought about that, and I did in one of my iterations also use the stored procedure AddHtmlTextLog, but that didn't effect the process. This module is "Direct to Publish", so I am not sure if workflow affects it at all.

The strange thing is that if I edit the existing (currently published) record directly...meaning I only update the Content field, not touching any other fields such as published or created date or last modified date, one would expect that the changes would be immediately visible. But that is not the case, even doing a Cache flush doesn't fix it. The only thing that fixes it is editing the modules content, making a change, then clicking publish. The publish button doesn't even appear at first because DNN doesn't register that any changes were made. That's why we have to edit the module's content, like adding and removing a single space, so that it triggers the "change" and the publish button appears.


Ben Santiago, MCP Certified & A+ Certified
Programmer Analyst
(SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS, Cognos ReportNet)
 
New Post
6/14/2016 10:00 AM
 
as far as I can see, you need a entry in HtmlTextLog with same itemid, state = 1 and Approved=1

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
6/14/2016 10:04 AM
 
and make sure, HtmlText.StateID matches a workflowstates record

Cheers from Germany,
Sebastian Leupold (Microsoft MVP)

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
Previous
 
Next
HomeHomeDevelopment and...Development and...SQL and SQL Ser...SQL and SQL Ser...DNN 8.x - Adding Content To HTML Module Using SQLDNN 8.x - Adding Content To HTML Module Using SQL


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.

Content Layout

Subscribe to DNN Digest

DNN Digest is our monthly email newsletter. It highlights news and content from around the DNN ecosystem, such as new modules and themes, messages from leadership, blog posts and notable tweets. Keep your finger on the pulse of the ecosystem by subscribing.  


Copyright 2017 by DNN Corp Terms of Use Privacy
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out