Sponsored Content
Full Discussion: Convert vnstat log to csv
Top Forums Shell Programming and Scripting Convert vnstat log to csv Post 302952624 by RudiC on Thursday 20th of August 2015 12:17:15 PM
Old 08-20-2015
Did you consider the various options of vnstat, like --dumpdb or --oneline?
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help to convert XML to CSV

Apologies if this has already been covered in this site somewhere, I did try looking but without any success. I am new to the whole XML thing, very late starter, and have a requirement to convert an XML fiule to a CSV fomat. I am crrently working on a Solaris OS. Does anyone have any suggestions,... (2 Replies)
Discussion started by: rossingi_33
2 Replies

2. Shell Programming and Scripting

how to convert .xls to .csv

Hi, I have problem..How to convert .xls file to .csv.. Plz help me for this problem.. (1 Reply)
Discussion started by: varma457
1 Replies

3. Shell Programming and Scripting

Txt to csv convert

Hi, I was trying some split command to pull out values like "uid=abc,ou=INTERNAL,ou=PEOPLE" into a csv file. However because of erratic nature of occurrance of rows made me stopped. Could someone help me in this? and if someone has a one liner for this? The text file contain pattern like this... (14 Replies)
Discussion started by: john_prince
14 Replies

4. Shell Programming and Scripting

Convert txt to csv

Hi - I am looking to convert the following text to csv. The columns may not always have data in them and they may have varying spaces but I still need to have a comma there anyway: Sample Data: ~~~~~~~ Name Email Location Phone Tom... (4 Replies)
Discussion started by: JPBovaird
4 Replies

5. Shell Programming and Scripting

Convert xml to csv

I need to convert below xml code to csv. I searched other posts as well but this post (_https://www.unix.com/shell-programming-scripting/174417-extract-parse-xml-data-statistic-value-csv.html) gives "sed command garbled" error. As of now I have written a long script to do it, but can it be done with... (7 Replies)
Discussion started by: dineshydv
7 Replies

6. Shell Programming and Scripting

Convert text to CSV

Hi Gurus I need urgent help to convert a flat log file into csv format to load into database. Log looks like: a=1 b=2 c=3 a=4 b=5 c=6 Only the values at right side of = will come into csv and it should create a new line once it receives "a" field. (8 Replies)
Discussion started by: sandipjee
8 Replies

7. UNIX for Dummies Questions & Answers

Convert csv to excel

Hi All, I have a csv file in unix and I need to convert it into excel formate. Please help me out (1 Reply)
Discussion started by: Abhisrajput
1 Replies

8. Shell Programming and Scripting

How to convert xml to csv ?

I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly. CODE: #!/usr/bin/perl # Script to illustrate how to parse a simple XML file # and pick out all the values for a specific element, in... (1 Reply)
Discussion started by: rspwilliam
1 Replies

9. Shell Programming and Scripting

Convert listner.log to csv format with comma seperated

Hi All, I am new to shell scripting i am trying to convert the listner.log to csv which can be inturn converted to excel for easy reading. i used this command awk '/SID=/ && /HOST=/ && /PORT=/ && /USER=/ { i=match($0,"SID="); i=i+RLENGTH; h0=substr($0,i); i=match(h0,")");... (6 Replies)
Discussion started by: skoshekay
6 Replies
VNSTAT.CONF(5)							   User Manuals 						    VNSTAT.CONF(5)

NAME
vnstat.conf - vnStat configuration file SYNOPSIS
/etc/vnstat.conf DESCRIPTION
vnstat(1), vnstati(1) and vnstatd(1) all use the same configuration file for storing configuration data. Some of the settings are common for all three programs. The file contains keyword-argument pairs, one per line. Lines starting with '#' and empty lines are interpreted as comments and not processed. Arguments may optionally be enclosed in double quotes (") in order to represent arguments containing spaces. Arguments can be padded with spaces or tabulator characters. A hardcoded default value will be used if a keyword can't be found from the configuration file. COMMON KEYWORDS
BootVariation Time in seconds how much the boot time reported by system kernel can variate between updates. CheckDiskSpace Enable or disable the checking of at least some free disk space before a database write. 1 = enabled, 0 = disabled. DatabaseDir Specifies the directory where interface databases are to be stored. A full path must be given and a leading '/' isn't required. DayFormat, MonthFormat, TopFormat Formatting of date in available outputs. Uses the same format as date(1). (vnstat and vnstati only) Interface Default interface used when no other interface is specified on the command line. (vnstat and vnstati only) Locale Locale setting to be used for prints. This replaces the LC_ALL environment variable. Set to "-" in order to use the system default value. (vnstat and vnstati only) MaxBandwidth Maximum bandwidth for all interfaces. If the counted traffic exceeds the given value then the data is assumed to be invalid and rejected. Set to 0 in order to disable the feature. (vnstat and vnstatd only) MaxBW Same as MaxBandwidth but can be used for setting individual limits for selected interfaces. The name of the interface is specified directly after the MaxBW keyword without spaces. For example MaxBWeth0 for eth0 and MaxBWppp0 for ppp0. (vnstat and vnstatd only) MonthRotate Day of month that months are expected to change. Usually set to 1 but can be set to alternative values for example for tracking monthly billed traffic where the billing period doesn't start on the first day. (vnstat and vnstatd only) OutputStyle Modify the content and style of text outputs. 0 = minimal and narrow output for terminal with limited width, 1 = normal output with bar column visible, 2 = same as 1 except rate is visible in summary and weekly outputs, 3 = rate column is visible in all outputs where it is supported. (vnstat and vnstati only) QueryMode Default query mode when no parameters are given. 0 = normal, 1 = days, 2 = months, 3 = top10, 4 = dumpdb, 5 = short, 6 = weeks, 7 = hours and 8 = xml. (vnstat only) RateUnit Select which unit is used when traffic rate is visible. 0 = bytes, 1 = bits. (vnstat and vnstati only) RXCharacter, TXCharacter Character used for representing the percentual share of received and transmitted traffic in daily output. (vnstat only) RXHourCharacter, TXHourCharacter Character used for representing the percentual share of received and transmitted traffic in hourly output. (vnstat only) Sampletime Defines how many seconds the -tr option will sample traffic. (vnstat only) TrafficlessDays Log days without any traffic to daily list. 1 = enabled, 0 = disabled. (vnstat and vnstatd only) UnitMode Select how units are prefixed. 0 = IEC standard prefixes (KiB/MiB/GiB/TiB), 1 = old style binary prefixes (KB/MB/GB/TB). (vnstat and vnstati only) UseFileLocking Enable or disable the use of file locking during database access. Disabling file locking may cause database corruption if several processes are trying to write to the file at the same time. DAEMON RELATED KEYWORDS
LogFile Specify log file path and name to be used if UseLogging is set to 1. OfflineSaveInterval How often in minutes cached interface data is saved to file when all monitored interfaces are offline. PidFile Specify pid file path and name to be used. PollInterval How often in seconds interfaces are checked for status changes. SaveInterval How often in minutes cached interface data is saved to file. SaveOnStatusChange Enable or disable the additional saving to file of cached interface data when the availability of an interface changes, i.e., when an interface goes offline or comes online. 1 = enabled, 0 = disabled. UpdateInterval How often in seconds the interface data is updated. UseLogging Enable or disable logging. 0 = disabled, 1 = logfile and 2 = syslog. IMAGE OUTPUT RELATED KEYWORDS
CBackground Background color. CEdge Edge color if visible. CHeader Header background color. CHeaderTitle Header title text color. CHeaderDate Header date text color. CLine Line color. CLineL Lighter version of line color. Set to '-' in order to use a calculated value based on CLine. CRx Color for received data. CRxD Darker version of received data color. Set to '-' in order to use a calculated value based on CRx. CText Common text color. CTx Color for transmitted data. CTxD Darker version of transmitted data color. Set to '-' in order to use a calculated value based on CTx. HeaderFormat Formatting of date in header. Uses the same format as date(1). HourlyRate Show hours with rate instead of transfered amount. 1 = enabled, 0 = disabled. SummaryLayout Select the used layout of the summary output. 1 = layout introduced in version 1.8 with monthly traffic included, 0 = layout used before version 1.8, doesn't contain monthly traffic and doesn't support average rate. SummaryRate Show rate in summary output if available. 1 = enabled, 0 = disabled. TransparentBg Set background color as transparent. 1 = enabled, 0 = disabled. FILES
/etc/vnstat.conf Config file that will be used unless $HOME/.vnstatrc exists or alternative value is given as command line parameter. AUTHOR
Teemu Toivola <tst at iki dot fi> SEE ALSO
vnstat(1), vnstati(1), vnstatd(1), units(7) version 1.11 JUNE 2011 VNSTAT.CONF(5)
All times are GMT -4. The time now is 05:26 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy