Odd CSV Results
Group, I have written a rather simple report to indicate pages on the site that have not been updated within a specific time span. I am outputting this report to a CSV file. The entire process works, but when I click the link to the generated report, only the first two lines are displayed in Excel. If I go to the file location and open the file directly, it opens normally and displays all the information contained. Has anyone seen this before? This is not the first time that I am creating CSV files from CF, but it's the first time that I have seen this occur. Running CF8 on Win 2k8 R2 with Office 2010 on my workstation. David Phelan Web Developer IT Security Web Technologies Montefiore IT 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.commailto:dphe...@emerginghealthit.com www.emerginghealthit.comhttp://www.emerginghealthit.com/ www.montefiore.orghttp://www.montefiore.org/ [Description: Montefiore IT logo]http://www.emerginghealthit.com/default.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd CSV Results
I would assume you are doing a loop to generate the CSV content. Are you adding CHR13 to the end of each line? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:01 PM To: cf-talk Subject: Odd CSV Results Group, I have written a rather simple report to indicate pages on the site that have not been updated within a specific time span. I am outputting this report to a CSV file. The entire process works, but when I click the link to the generated report, only the first two lines are displayed in Excel. If I go to the file location and open the file directly, it opens normally and displays all the information contained. Has anyone seen this before? This is not the first time that I am creating CSV files from CF, but it's the first time that I have seen this occur. Running CF8 on Win 2k8 R2 with Office 2010 on my workstation. David Phelan Web Developer IT Security Web Technologies Montefiore IT 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.commailto:dphe...@emerginghealthit.com www.emerginghealthit.comhttp://www.emerginghealthit.com/ www.montefiore.orghttp://www.montefiore.org/ [Description: Montefiore IT logo]http://www.emerginghealthit.com/default.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd CSV Results
I am and the issue now appears to have worked itself out. I had to clear my cache even though I had Always Refresh From Server selected in dev tools. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, May 13, 2014 2:03 PM To: cf-talk Subject: RE: Odd CSV Results I would assume you are doing a loop to generate the CSV content. Are you adding CHR13 to the end of each line? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:01 PM To: cf-talk Subject: Odd CSV Results Group, I have written a rather simple report to indicate pages on the site that have not been updated within a specific time span. I am outputting this report to a CSV file. The entire process works, but when I click the link to the generated report, only the first two lines are displayed in Excel. If I go to the file location and open the file directly, it opens normally and displays all the information contained. Has anyone seen this before? This is not the first time that I am creating CSV files from CF, but it's the first time that I have seen this occur. Running CF8 on Win 2k8 R2 with Office 2010 on my workstation. David Phelan Web Developer IT Security Web Technologies Montefiore IT 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.commailto:dphe...@emerginghealthit.com www.emerginghealthit.comhttp://www.emerginghealthit.com/ www.montefiore.orghttp://www.montefiore.org/ [Description: Montefiore IT logo]http://www.emerginghealthit.com/default.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Odd CSV Results
Good. Glad it's solved. I've done a lot of CSV files and they do seem to work well once you get the syntax correct. Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:19 PM To: cf-talk Subject: RE: Odd CSV Results I am and the issue now appears to have worked itself out. I had to clear my cache even though I had Always Refresh From Server selected in dev tools. -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, May 13, 2014 2:03 PM To: cf-talk Subject: RE: Odd CSV Results I would assume you are doing a loop to generate the CSV content. Are you adding CHR13 to the end of each line? Robert Harrison Director of Interactive Services Austin Williams Advertising I Branding I Digital I Direct 125 Kennedy Drive, Suite 100 I Hauppauge, NY 11788 T 631.231.6600 X 119 F 631.434.7022 http://www.austin-williams.com Blog: http://www.austin-williams.com/blog Twitter: http://www.twitter.com/austin_williams -Original Message- From: David Phelan [mailto:dphe...@emerginghealthit.com] Sent: Tuesday, May 13, 2014 2:01 PM To: cf-talk Subject: Odd CSV Results Group, I have written a rather simple report to indicate pages on the site that have not been updated within a specific time span. I am outputting this report to a CSV file. The entire process works, but when I click the link to the generated report, only the first two lines are displayed in Excel. If I go to the file location and open the file directly, it opens normally and displays all the information contained. Has anyone seen this before? This is not the first time that I am creating CSV files from CF, but it's the first time that I have seen this occur. Running CF8 on Win 2k8 R2 with Office 2010 on my workstation. David Phelan Web Developer IT Security Web Technologies Montefiore IT 3 Odell Plaza, Yonkers, NY 10701 914-457-6465 Office 862-234-9109 Cell dphe...@emerginghealthit.commailto:dphe...@emerginghealthit.com www.emerginghealthit.comhttp://www.emerginghealthit.com/ www.montefiore.orghttp://www.montefiore.org/ [Description: Montefiore IT logo]http://www.emerginghealthit.com/default.cfm ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:358645 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
