topic Re: CSV attachment in Application Development and Automation Discussions

CSV attachment

Former Member — Mon, 17 May 2010 11:01:03 GMT

Hi experts.

I've did a report for send mails with an attachment of type CSV.

the problem occured when i tried to open this attachment.

Ms Office raise a message saying that the file cannot be open.

the issue is that if i open this attachment with a text editor like notepad++ the file format is correct!!!!

Any idea??

Best regards

Marco

Re: CSV attachment

Former Member — Mon, 17 May 2010 11:48:45 GMT

Did you name the file with an extension .csv? If so, you would optimally open with Windows Explorer, not Excel, so that the auto import wizard would be invoked and insert the values into a .csv format worksheet, which could then be saved as an Excel Worksheet....

Re: CSV attachment

Former Member — Mon, 17 May 2010 12:03:55 GMT

I've tried to open the file with explorer but it doesn't work...

any other ideas??

marco

Re: CSV attachment

SimoneMilesi — Mon, 17 May 2010 12:27:19 GMT

What kind of separator are you using?

And what kind of separator is used in Excel to manage CSV?

Re: CSV attachment

Former Member — Mon, 17 May 2010 12:36:33 GMT

Ciao Simone

I'm using semicolon........and if i save a CSV file by excel the separator is still semicolon.

regards

Marco