OK here is my problem:

I need to download information to a fat client application (just some text stuff, files to download etc.)

I want a listx page that displays normally IF certain querystring arguments are not supplied. For example a list of portal files linked to a site say. So when the page is diplayed the output is normal. However, when the fat client does a web request to the page, it will pass a querystring variable for the specific siteid and the output it is pickingup, say 'files changed'.

So the base query would be like select * from dnn_files.
Actions would look at the 'what' querystring variable and then an action:

if [what,querystring] <> ''
then - output the data as csv

I can't seen to get it to work, I can get the data to display normally with and without a siteid, but the querystring that triggers the action does not even show the data or 'anything' debug or otherwise.

Any Clues<img src='desktopmodules/ntforums/images/emoticons/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>

PS trying to avoid writing a custom DNN module to do simple data transfer.

Here is the Quick and Dirty Example of what you are trying to do.... just take the XML... and use it in your config.


<?xml version="1.0" encoding="utf-16"?>
<xListSettings xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<recordsPerPage>0</recordsPerPage>
<enableAlphaFilter>false</enableAlphaFilter>
<enablePageSelection>false</enablePageSelection>
<enableRecordsPerPage>false</enableRecordsPerPage>
<enableCustomPaging>false</enableCustomPaging>
<enableExcelExport>false</enableExcelExport>
<enableHide_OnNoQuery>false</enableHide_OnNoQuery>
<enableHide_OnNoResults>false</enableHide_OnNoResults>
<enableAdvancedParsing>true</enableAdvancedParsing>
<enableCompoundIIFConditions>true</enableCompoundIIFConditions>
<enableQueryDebug>false</enableQueryDebug>
<enableQueryDebug_Edit>false</enableQueryDebug_Edit>
<enableQueryDebug_Admin>false</enableQueryDebug_Admin>
<enableQueryDebug_Super>false</enableQueryDebug_Super>
<enableQueryDebug_Log>false</enableQueryDebug_Log>
<enableQueryDebug_ErrorLog>false</enableQueryDebug_ErrorLog>
<autoRefreshInterval />
<skipRedirectActions>false</skipRedirectActions>
<skipSubqueryDebugging>false</skipSubqueryDebugging>
<enableAdmin_Edit>true</enableAdmin_Edit>
<enableAdmin_Admin>false</enableAdmin_Admin>
<enableAdmin_Super>false</enableAdmin_Super>
<enableAJAX>false</enableAJAX>
<enableAJAXCustomPaging>false</enableAJAXCustomPaging>
<enableAJAXCustomStatus>false</enableAJAXCustomStatus>
<enableAJAXManual>false</enableAJAXManual>
<includeJavascriptUtilities>false</includeJavascriptUtilities>
<includeJavascriptValidation>false</includeJavascriptValidation>
<javascriptOnComplete />
<enableMultipleColumnSorting>false</enableMultipleColumnSorting>
<ModuleCommunicationMessageType />
<showAll>false</showAll>
<useExplicitSystemVariables>false</useExplicitSystemVariables>
<enabledForcedQuerySplit>false</enabledForcedQuerySplit>
<searchItems />
<queryItems />
<listItems />
<messageItems>
<anyType xsi:type="MessageActionItem">
<Index>0</Index>
<ActionType>Condition-If</ActionType>
<ActionInformation>6:8;1;5;'[do,Q]'='csv'</ActionInformation>
<Level>0</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>1</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>10:8;8;7;5;1;<Action>myResult<table>False0</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>2</Index>
<ActionType>Action-Execute</ActionType>
<ActionInformation>9:7;42;5;0;myQueryselect TabName from tabs order by taborderFalse</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>3</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>11:8;8;35;5;1;<Action>myResult<tr><td>[Tabname,myQuery]</td></tr>False1</ActionInformation>
<Level>2</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>4</Index>
<ActionType>Action-Assignment</ActionType>
<ActionInformation>10:8;8;8;5;1;<Action>myResult</table>False1</ActionInformation>
<Level>1</Level>
</anyType>
<anyType xsi:type="MessageActionItem">
<Index>5</Index>
<ActionType>Action-Output</ActionType>
<ActionInformation>6:14;10;Complete ExcelmyTabs.xls</ActionInformation>
<Level>1</Level>
</anyType>
</messageItems>
<query />
<filter />
<customConnection />
<listItem />
<listAItem />
<defaultItem />
<noqueryItem>[myResult,Action]</noqueryItem>
<SearchQuery />
<SearchTitle />
<SearchLink />
<SearchAuthor />
<SearchDate />
<SearchKey />
<SearchContent />
<SearchDescription />
<Version>17</Version>
</xListSettings>

Thanks

Thnkas for the reply - however.

The XML will not load - I am on version 1.9.6.

Tried to manually enter the actions based on the XML but looks like there is a new table assignment feature that is not in my version. Is is possibly to use viewstate and/or session? Or is that not possible. our company purchase this a while ago, the primary developer, Kell, has since left the company.

Thanks

May be something got screwed up in the XML above... use the attached one.

Once you load the XML, you wont see any thing on page but add ?do=csv at the end of URL and hit enter in order to see the result.

Thanks,
DP

Kool that worked thanks.

Another thing, the difference between Excel, Word and CSV output. The Excel worked out fine based on the result set materialized by the execute action. But when I change the output to delimited, nothing comes out.

Thoughts?

You need to build the proper out put HTML that will be supported by different types. i the example i gave is is just a starting point for you.

if you are building html table that is supported by Word and Excel.

OK almost there but how can you output ascii crlf chars

I tried the following
ascii(13) ascii(10)
chr(13) chr(10)
System.Environment.NewLine
Microsoft.VisualBasic.Constants.vbCrLf
vbCrLf
\\n

Did I miss any....<img src='desktopmodules/ntforums/images/emoticons/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>

put char(10) + char(13) in your query in it's own column (as crlf) and output the field in the format action. Kind of lame but worked like a champ. Is there a better method?

Hello smummert,
I believe that is the prefered method.