Getting Data In

I want to publish a formatted .csv via email in splunk

aslamsayyed
New Member

Hi Team,

I have well formatted data into a .csv, just I have publish the data(.csv) as it is on email in well color format.

What approach shall I use in splunk(like Dataset, lookups or anything)

Regards,
Aslam Sayyed

Tags (1)
0 Karma

wmyersas
Builder

CSVs don't have any "formatting" - that is entirely up to whatever tool you use (eg Excel) to render.

In fact, there is no way to encode "format" in a CSV - it's just a text file (https://en.wikipedia.org/wiki/Comma-separated_values)

Therefore, you have about two options:

  • export a PDF of your report/dashboard
  • export a CSV, import into a tool like Excel, and reformat
0 Karma

aslamsayyed
New Member

Sorry I think, I confused you.
I have a comma separated .csv on my Linux prod server.
My question :
1. How shall I send that comma separated .csv file onto splunk.
2. Post I want to send the .csv data over email(in html format or color format)
So could you please let me know how shall I achieve the above two scenarios in splunk.
Appreciate your response.

0 Karma

wmyersas
Builder

There is no such thing as a "formatted" CSV file

You can get a CSV into Splunk in one of a few ways:

  • get the UF to monitor it
  • upload it as a lookup
  • ssh it to the SH as a lookup
  • post it to the HEC with a script
  • one-shot it via the web UI or command line
  • etc etc etc

Once you've got it available to Splunk, you could manipulate it into a panel on a dashboard, and then schedule PDF delivery of that dashboard

But you can't "html format or color format" a CSV

A CSV is a text file

There is no "formatting" in it

0 Karma
Get Updates on the Splunk Community!

Platform Highlights | November 2022 Newsletter

 November 2022 Skill Up on Splunk with our New Builder Tech Talk SeriesCan you build it? Yes you can! *play ...

Splunk Education - Fast Start Program!

Welcome to Splunk Education! Splunk training programs are designed to enable you to get started quickly and ...

Five Subtly Different Ways of Adding Manual Instrumentation in Java

You can find the code of this example on GitHub here. Please feel free to star the repository to keep in ...