Regarding this - we do this same functionality a lot, but our Europe clients
have trouble opening the files because their decimal characters and division
characters aren't the same as ours (',' where we use '.' etc..) Even if I
have them change their regional settings on their computer to match mine,
the file still doesn't open in Excel properly. Does any one else have
experience in this? (We're running WiTango 5 on W2K pro here in the US -
the client is in Germany).
----- Original Message -----
From: "Atrix Wolfe" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, February 16, 2003 10:25 PM
Subject: Re: Witango-Talk: Opening a result set in excel from a taf action.
> wow awesome.
>
> Im waiting patiently for the next R:Tango so i can use this and the other
> cool new features.
>
> ----- Original Message -----
> From: "Witango Support" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, February 16, 2003 10:14 PM
> Subject: Re: Witango-Talk: Opening a result set in excel from a taf
action.
>
>
> > Chris/Atrix,
> >
> > You don't actually need to write a copy to disk on the server as
> suggested.
> > It is possible to change the http headers and send the data to excel
> > directly.
> >
> > Attached is a very basic taf which demonstrates this functionality with
> > Witango 5.
> >
> > FYI this will be available along with other Witango components in our
> > forthcoming Witango Component Zone.
> >
> > Witango Support
> >
> >
> > ----- Original Message -----
> > From: "Chris Smith" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Monday, February 17, 2003 2:52 PM
> > Subject: Re: Witango-Talk: Opening a result set in excel from a taf
> action.
> >
> >
> > > Thanks So much for this information. I will be focusing on
implementing
> > this
> > > in the near future and will post my results or further questions.
> > > thanks again
> > > csmith
> > > ----- Original Message -----
> > > From: "Atrix Wolfe" <[EMAIL PROTECTED]>
> > > To: <[EMAIL PROTECTED]>
> > > Sent: Sunday, February 16, 2003 9:59 PM
> > > Subject: Re: Witango-Talk: Opening a result set in excel from a taf
> > action.
> > >
> > >
> > > > hi Chris,
> > > >
> > > > Take heart! We do this and do it successfuly.
> > > >
> > > > heres how.
> > > >
> > > > we gather whatever paramaters from the user, then preform the SQL to
> get
> > > the
> > > > results just like normal for displaying on the page.
> > > >
> > > > we then do a file write action.
> > > >
> > > > in the file name we use the user referance # as a unique identifier
> for
> > > the
> > > > file name:
> > > > <@WEBROOT>\<@userreference>.csv
> > > >
> > > >
> > > > then, in the data to write section we put:
> > > >
> > > > Header1,Header2,Header3,<@char code=13><@var local$Resultset
> aprefix=""
> > > > asuffix="" rprefix="" rsuffix="<@char code=13>" cprefix=""
> csuffix=",">
> > > >
> > > > What this essentialy does is write out the file with commas at the
> ends
> > of
> > > > the columns and new lines at the ends of rows so it can be read by
> > Excel.
> > > > Header1,2 and 3 are the headers that will apear at the top of the
> > columns.
> > > > They are optional of course, but make it look nicer and make the
data
> > make
> > > > more sense.
> > > >
> > > > After the file action, we have a results html which looks like this:
> > > >
> > > > <html>
> > > >
> > > > <head>
> > > >
> > > > <script language="JavaScript">
> > > >
> > > > <!--
> > > >
> > > > var Excel =
> > > >
> > >
> >
>
window.open('<@cgi><@appfilepath><@userreference>.csv','Excel',config='toolb
> > > >
> >
ar=yes,location=yes,status=yes,menubar=yes,scrollbars=yes,resizable=yes');
> > > >
> > > > Excel.focus();
> > > >
> > > > //-->
> > > >
> > > > </script>
> > > >
> > > > </head>
> > > >
> > > > <form name=excelform method=post action="JavaScript:history.go(-1)">
> > > >
> > > > <center>
> > > >
> > > > <input type=submit name=test value="Return">
> > > >
> > > > </center>
> > > >
> > > > </form>
> > > >
> > > > </font>
> > > >
> > > > </body>
> > > >
> > > > </html>
> > > >
> > > >
> > > > What this does is pop open a new window, and the part that says
> 'Excel'
> > > > tells the browser that if possible, we want to open the file in an
> Excel
> > > > window, which it so happily obliges us. This works great for us,
and
> in
> > > > fact, I learned how to do this from a post by Scott Cadilac i
believe
> so
> > > if
> > > > you have any problems with this or need it do behave differently
then
> > the
> > > > code above, im sure someone will be able to help you further (:
> > > >
> > > >
> > > > ----- Original Message -----
> > > >
> > > > From: Chris Smith
> > > > To: [EMAIL PROTECTED]
> > > > Sent: Sunday, February 16, 2003 5:22 PM
> > > > Subject: Witango-Talk: Opening a result set in excel from a taf
> action.
> > > >
> > > >
> > > > Hi All,
> > > >
> > > > I have an interface were I'm executing a dynamic query based on
which
> > > form
> > > > fields were included in the post. Due to some space limitations I'm
> only
> > > > able to bring back 7 columns to screen for these reports. Which is
> okay,
> > > but
> > > > for more detail I wanted to be able to have the user click an export
> > > button
> > > > on the interface that would open the result set in the excel plugin
> for
> > > the
> > > > web browser. What I would like to do is re-execute the query but in
> the
> > > > excel post have more columns returned (the equal of Select *) This
way
> > the
> > > > user could "push" the results to excel and manipulate the data
> > there...use
> > > > what columns the want...discard the columns they don't... Any
> > suggestion?
> > > >
> > > > csmith
> > > >
> ________________________________________________________________________
> > > > TO UNSUBSCRIBE: send a plain text/US ASCII email to
> [EMAIL PROTECTED]
> > > > with unsubscribe witango-talk in the message body
> > > >
> > > >
> ________________________________________________________________________
> > > > TO UNSUBSCRIBE: send a plain text/US ASCII email to
> [EMAIL PROTECTED]
> > > > with unsubscribe witango-talk in the message body
> > >
> > >
________________________________________________________________________
> > > TO UNSUBSCRIBE: send a plain text/US ASCII email to
[EMAIL PROTECTED]
> > > with unsubscribe witango-talk in the message body
> >
> > ________________________________________________________________________
> > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> > with unsubscribe witango-talk in the message body
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
> with unsubscribe witango-talk in the message body
>
>
________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
with unsubscribe witango-talk in the message body
