Join our DNN Community    (Newsletter, Tips, Tricks and Forums for DNN Skins & Modules)

 


 
Microsoft Gold Certified Partner - DNN Benefactor

DotNetNuke Powered! 
Monday, December 01, 2008 Register · Login · Contact · Search:  
Company Solutions Portfolio Contact
Forums
General
The ever-powerful ListX module forum. Post your questions, new configuration ideas and reviews.
Forums > Bi4ce.Modules.ListX > General
Subject:  : XML editing problem

You are not authorized to post a reply.   
Author Messages
ken.stessens
Middleweight
Posts:95
09/24/2008 11:08 AM Alert 
Hi,

Editing an ACTION tag in XML seems to be problematic because the <ActionInformation> contains some parameters that define the amount of characters (length) of the action definition. So editing the ACTION definition resulting in more or less characters won't work: inserting extra characters will cause the amount of extra characters to be truncated at the end of the string (not sure which effect omitting would have).

Now I want to update a certain reference that occurs in many modules, so I want to do that in the SQL xListSettings table. Unfortunately, this will result in the same issue.

Is there a way to overcome this? Going through all the modules manually will be cumbersome...

Thanks,
Ken
pauldes
Immortal
Posts:1392
09/24/2008 11:44 AM Alert 
I don't think there is a way to do this in an automated fashion in Actions. BI4CE would have to give you the exact reason why but I think it has something to do with certain actions representation in the XML being a specific string length to work properly.

You may be able to replace an ENTIRE <action> node with a replacement <action> node, beginning to end, complete with CRs and LFs, if you can get the replace SQL to work correctly.
ListX....makes you look brilliant, even though you're not.
ken.stessens
Middleweight
Posts:95
09/24/2008 11:58 AM Alert 
I was afraid for this. What make it really difficult is that the content that needs to be replaced is not only present in the actions, but mostly elsewhere. Unfortunately, the ACTION tag makes it impossible to run the update query for the other items as well...

Thanks anyway,
Ken
bgates
Heavyweight
Posts:197
10/05/2008 12:09 PM Alert 
Tag values in the ListX configuration are build with, what we call, a Smart Splitter. The string consists of:

HeaderLength:Value1Length;Value2Length;Value3Length;Value1Value2Value3

As an example:

9:15;20;36;This is value1!While this is value2And value3 occupies this much space.

So you could write SQL functions to take apart a SmartSplitter and another one to join values together. Your replacement function would then roll through the ListX config, split the SmartSplitter value, update the part you need to, then join it back together. If you're using SQL 2005, I STRONGLY recommend taking advantage of the excellent XML field support available.
Bob Gates
Business Intelligence Force, Inc. (bi4ce)
You are not authorized to post a reply.
Forums > Bi4ce.Modules.ListX > General > : XML editing problem


ActiveForums 3.6
Latest Post
 
At R2integrated (formerly Bi4ce), we take support seriously.  That's why we support our customers and DNN community with daily monitoring from our experienced engineering team.  We ask that the first step taken is to read the relevant documentation and support forums prior to submitting any questions that may already be available or have been answered.  We ask that you review the documentation that we provide for our products before posting a question.

The Forums are for our customers to chat, exchange ideas and strategies, and submit feedback.  Please be sure to perform keyword searches for previous related forum responses.

To be helpful when submitting a new item, please include the following: 
  1. DNN Version
  2. Module Version
  3. Admin Log Viewer Information
  4. Environment detail: Operating system, .NET framework version, database and version, IIS version, Browser version (if appropriate)
We always try to respond quickly and monitor the forums daily during business hours (EST).  Occasionally, requests for a specific project requirement may not apply for the free support offered. For project specific support please submit via our Information Request form.

Thank you for using our Forums.

Click here to register for the Forums
 
© 2008 by R2integrated (formerly Bi4ce) | DNN® is a registered trademark of DotNetNuke Corporation