topic Re: Format Attachment data.csv - Data smashed into one column in Reporting Service & Alerting

Format Attachment data.csv - Data smashed into one column

mtkst13 — Wed, 29 Jan 2025 15:57:23 GMT

Greetings,

Our group has successfully created alerts. However, the attachment data.csv is useless, as it is smashing each record into one column/cell A. How can the attachment be formatted appropriately so that our users can actually find utility in the data? I've tried inserting commas, spaces, and several other hacks, but nothing has worked.

Kind Regards,

Maria

Re: Format Attachment data.csv - Data smashed into one column

Anil_Babu_Samineni — Thu, 18 Jan 2024 08:37:40 GMT

@mtkst13 Please share the screenshot how the format looks like.

Re: Format Attachment data.csv - Data smashed into one column

mtkst13 — Thu, 18 Jan 2024 14:32:23 GMT

@Anil_Babu_Samineni , It's actually tab delimited. When I opened the file, selected column A, went to data and clicked on columns to text, excel said it is tab delimited. However, the qlik alerting attaches the file as data.csv by default.

Re: Format Attachment data.csv - Data smashed into one column

Anil_Babu_Samineni — Thu, 18 Jan 2024 17:11:23 GMT

@mtkst13 If I understand correctly, You have created a data alerts using Qlik alerting and for that You have one excel to upload after you met all conditions.

If that is the case, Can't you change before upload in Alerting with Tab delimited and then upload?

Re: Format Attachment data.csv - Data smashed into one column

mtkst13 — Thu, 18 Jan 2024 22:38:35 GMT

@Anil_Babu_Samineni , I do not know if I have control/ability to change the file that the Qlik Alerting tool attaches, to be honest. I'm surprised that it's automatically uploading a .csv when it's really a .tsv

This is the only documentation we have: https://help.qlik.com/en-US/alerting/July2023/Content/QlikAlerting/custom-notifications.htm

Thoughts?

Re: Format Attachment data.csv - Data smashed into one column

Anil_Babu_Samineni — Sat, 20 Jan 2024 08:51:20 GMT

@mtkst13 Please help us what exactly and how exactly file is uploaded? Is this manually uploaded for the alerts or this is uploaded from Code?

Re: Format Attachment data.csv - Data smashed into one column

mtkst13 — Mon, 22 Jan 2024 13:58:46 GMT

Good morning. @Anil_Babu_Samineni , the attachment is autogenerated along with the email itself by the qlik alerting feature.

Maria

Re: Format Attachment data.csv - Data smashed into one column

Anil_Babu_Samineni — Mon, 22 Jan 2024 14:29:44 GMT

@mtkst13 I can see we can upload the files and there is no way to attach automate in the Data alerts from Qlik alerting. Maybe it's good to explain more how you do, so that we can offer.

Re: Format Attachment data.csv - Data smashed into one column

mtkst13 — Fri, 15 Mar 2024 13:38:54 GMT

Greetings,

@Anil_Babu_Samineni I believe that the purpose of the Upload Files button is to upload custom single.hjs or dimension.hjs file when one wants to customize the email message?? Not sure because at the moment, it won't load anything. Working on getting drives mapped.

Maria

Re: Format Attachment data.csv - Data smashed into one column

Anil_Babu_Samineni — Mon, 18 Mar 2024 06:00:47 GMT

@Andrew_Delaney Any suggestions?