Re: Witango-Talk: help with export write csv

[Christian Platt]

OK. Thats the second way we do it. list is written to file. we use a colon as seperator. Christian <@ROWS> <li><@COLUMN 'index.name'>;<@COLUMN 'index.strasse'>;<@COLUMN 'index.plz'>;<@COLUMN 'index.ort'>;<@COLUMN 'contacts.prefix'>;<@COLUMN 'contacts.firstname'>;<@COLUMN 'contacts.lastname'><@crlf> <@ASSIGN name="theList" Value="@@request$theList<@COLUMN 'index.name'>;<@COLUMN 'index.strasse'>;<@COLUMN 'index.plz'>;<@COLUMN 'index.ort'>;<@COLUMN 'contacts.prefix'>;<@COLUMN 'contacts.firstname'>;<@COLUMN 'contacts.lastname'><@crlf>" scope="request"> </@ROWS> </table> Am 05.11.2005 um 17:54 schrieb Dan Stein: It is not the writing of the file and getting it is is the formatting of the csv that is the issue   From: Christian Platt [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 05, 2005 11:32 AM To: witango-talk@witango.com Subject: Re: Witango-Talk: help with export write csv   Normally, i do a search action , assign the result to a request variable, do a <@purgeresults> and save my variable with the result to a file. which is normaly <@WEBROOT><@APPFILEPATH>temp/sonstwas.csv   the temp folder has to be of witango, otherwise you cannot write into it (on OSX)   Christian   Am 05.11.2005 um 14:11 schrieb Dan Stein: I need to do a search on a SQL table and bring back and array with column headers and then write it to a .csv file so it can be opened with Excel This is what I am doing with the search result <@Assign request$applications @@resultset > <@ADDROWS ARRAY="request$applications" VALUE="@@resultset[0,*]"POSITION="0"> Then I am just doing a file write of @@request$applications Tgo <@APPFILEPATH>Data/applications.csv Thew file comes in an email but it is an array with all the HTML code. I might be losing my mind but this worked when I first built it and tested it but now it is not working Any help is appreciated. ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf   ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf