Re: writefile, csv, tab and excel import behavior
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58223
interpreted = N
texte = Unfortunately it still tries to evaluate numeric fields. They only way I have seen around this is to treat the exported file as a text file and use the excel text import wizard. I just recently purchased Urchin and it has an excel and word export option for all its reports. They actually are in excel 2000 and word 2000 format. I am assuming this is done within the app. Are their any 3rd party cgi prog that can do this? I am trying to make this as idiot proof for the client as possible. Vincent -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Gary Krockover Sent: Friday, June 04, 2004 10:55 PM To: WebDNA Talk Subject: Re: writefile, csv, tab and excel import behavior I've always done a: [WriteFile somefile.xls] sku firstname lastname phone email [search db=yourdatabase.db&criteria][founditems] [sku] [firstname] [lastname] [phone] [/founditems][/search] [/WriteFile] With no problems at all. Before you open the file in Excel, click to select all the cells and then go Format > Cells > and select Text. You shouldn't have any formatting then. GK At 09:34 PM 6/4/2004, you wrote: >How would one use writefile to export a tab delimited file or csv so that >excel plays nice. > >Currently I can export using: > >"value1","value2","value3" > >Except excel formats some of the values and numeric and tries to evaluate >them. > >I was going to try a tab delimited format such as: > >[unurl][fieldname1]%09[fieldname2]%09[fieldname3][/unurl] > >Any ideas??? > >TIA! > >Vince ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
| |
- Re: writefile, csv, tab and excel import behavior ( Sal D'Anna 2004)
- Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
- Re: writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
- Re: writefile, csv, tab and excel import behavior ( Gary Krockover 2004)
- writefile, csv, tab and excel import behavior ( "Vincent Medina" 2004)
|
Unfortunately it still tries to evaluate numeric fields. They only way I have seen around this is to treat the exported file as a text file and use the excel text import wizard. I just recently purchased Urchin and it has an excel and word export option for all its reports. They actually are in excel 2000 and word 2000 format. I am assuming this is done within the app. Are their any 3rd party cgi prog that can do this? I am trying to make this as idiot proof for the client as possible. Vincent -----Original Message----- From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On Behalf Of Gary Krockover Sent: Friday, June 04, 2004 10:55 PM To: WebDNA Talk Subject: Re: writefile, csv, tab and excel import behavior I've always done a: [WriteFile somefile.xls] sku firstname lastname phone email [search db=yourdatabase.db&criteria][founditems] [sku] [firstname] [lastname] [phone] [/founditems][/search] [/WriteFile] With no problems at all. Before you open the file in Excel, click to select all the cells and then go Format > Cells > and select Text. You shouldn't have any formatting then. GK At 09:34 PM 6/4/2004, you wrote: >How would one use writefile to export a tab delimited file or csv so that >excel plays nice. > >Currently I can export using: > >"value1","value2","value3" > >Except excel formats some of the values and numeric and tries to evaluate >them. > >I was going to try a tab delimited format such as: > >[unurl][fieldname1]%09[fieldname2]%09[fieldname3][/unurl] > >Any ideas??? > >TIA! > >Vince ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Vincent Medina"
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
[OT] Test - THE ANSWER (2003)
Getting ready to launch?? (2001)
shipcost (1997)
Ok here is a question? (1997)
[format 40s]text[/format] doesn't work (1997)
Applescript error (1998)
Other tags inside the founditems context? (1998)
Help name our technology! I found it (1997)
Some Questions (1997)
RE: [WebDNA] Cheers (2008)
Country & Ship-to address & other fields ? (1997)
[WebDNA] Webcat install on Windows 2003 Server web edition - (2010)
For those of you not on the WebCatalog Beta... (1997)
Q: for those who use Cookies for sessions? (2004)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Cant open pages generated by Webcat (2004)
setting cookies then redirecting? (1998)
form data submission gets truncated (1997)
Silly Question (1997)
taxRate and grandTotal calculation is not showing up on my (2000)