Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Output large volume of data to CSV file
Top Forums Shell Programming and Scripting Output large volume of data to CSV file Post 302956675 by dellanicholson on Thursday 1st of October 2015 11:45:42 PM
Old 10-02-2015
Output large volume of data to CSV file
I have a program that output the ownership and permission on each directory and file on the server to a csv file. I am getting error message
when I run the program. The program is not outputting to the csv file.

Code:
Error:
the file access permissions do not allow the specified action
cannot change directory
xrealloc: cannot allocate 9900416 bytes

Here is my code
Code:
#!/bin/bash
monitorf=/sc/sb/monitor.csv
ls -l $(find /sasem/* -type f) > "$monitorf"
mail -a /sc/sb/monitor.csv -s "monitor" jgk@yahoo.com; billygm@yahoo.com

Last edited by Don Cragun; 10-02-2015 at 05:51 AM.. Reason: Add missing CODE tags.
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Large volume file formatting

Hi, I have a file which is around 193 gb in size. This file has tonnes of spaces and I need to sanitize it. I tried to use awk script to split this file but it gave me an error like line to long... As of now I am using a sed command to search replace the spaces; however its too slow for such a... (2 Replies)
Discussion started by: darshanw
2 Replies

2. Shell Programming and Scripting

Updating a line in a large csv file, with sed/awk?

I have an extremely large csv file that I need to search the second field, and upon matches update the last field... I can pull the line with awk.. but apparently you cant use awk to directly update the file? So im curious if I can use sed to do this... The good news is the field I want to... (5 Replies)
Discussion started by: trey85stang
5 Replies

3. Shell Programming and Scripting

select data from oracle table and save the output as csv file

Hi I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data. I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Discussion started by: rdhanek
2 Replies

4. Shell Programming and Scripting

Help Manipulating Large Csv File

Hello everyone, I am trying to manipulate a large .csv file where I have output similar to the following - http://imgur.com/TEXD8.png The result that I am looking for would be to consolidate the first column, but combine the second and third column so it still relates to the first. I... (8 Replies)
Discussion started by: xxwohxx
8 Replies

5. Shell Programming and Scripting

Severe performance issue while 'grep'ing on large volume of data

Background ------------- The Unix flavor can be any amongst Solaris, AIX, HP-UX and Linux. I have below 2 flat files. File-1 ------ Contains 50,000 rows with 2 fields in each row, separated by pipe. Row structure is like Object_Id|Object_Name, as following: 111|XXX 222|YYY 333|ZZZ ... (6 Replies)
Discussion started by: Souvik
6 Replies

6. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07... (8 Replies)
Discussion started by: refrain
8 Replies

7. Shell Programming and Scripting

Save output of updated csv file as csv file itself, part 2

Hi, I have another problem. I want to sort another csv file by the first field. result.csv SourceFile,Airspeed,GPSLatitude,GPSLongitude,Temperature,Pressure,Altitude,Roll,Pitch,Yaw /home/intannf/foto5/2015_0313_090651_219.JPG,0.,-7.77223,110.37310,30.75,996.46,148.75,180.94,182.00,63.92 ... (2 Replies)
Discussion started by: refrain
2 Replies

8. Shell Programming and Scripting

Copy data to CSV file from txt output

Hi Everyone , Below is output from a TL1 , I want just the NE Name: and beside that the Temperature and the voltages in a csv file , Is this possible? > act-user:AB1S2a:ArshadFO:493::**********; AB1S2a 2016-02-07 10:13:24 M 493 COMPLD "ArshadFO:2016-02-07 10-04-55,0" ;... (11 Replies)
Discussion started by: adgjmpt
11 Replies

9. Shell Programming and Scripting

Need a script to parse data and output to csv

I am not too savvy with arrays and am assuming that what I am looking for needs arrays. This is my requirement. So I have the raw data that gets updated to a log as shown below StudentInfo: FullInfo = { Address = Newark Age = 20 Name= John } StudentInfo:... (2 Replies)
Discussion started by: sidnow
2 Replies

10. Programming

Python script to run multiple command and append data in output csv file

Experts, I am writing a script and able to write only small piece of code and not able to collect logic to complete this task. In input file have to look for name like like this (BGL_HSR_901_1AG_A_CR9KTR10) before sh iss neors. Record this (BGL_HSR_901_1AG_A_CR9KTR10) in csv file Now have to... (0 Replies)
Discussion started by: as7951
0 Replies

LEARN ABOUT DEBIAN

powertop

POWERTOP(8)							  powertop manual						       POWERTOP(8)

NAME

       powertop - a power consumption and power management diagnosis tool.

SYNOPSIS

       powertop [ options ]

DESCRIPTION

       powertop  is  a	program that helps to diagnose various issues with power consumption and power management. It also has an interactive mode
       allowing one to experiment with various power management settings. When invoking powertop without arguments powertop starts in  interactive
       mode.

OPTIONS

       --csv[=FILENAME]
	      generate	a  CSV report. If a filename is not specified then the default name "powertop.csv" is used. The CSV report can be used for
	      reporting and data analysis.

       --calibrate
	      runs powertop in calibration mode. When running on battery, powertop can track power consumption as well as  system  activity.  When
	      there  are  enough  measurements,  powertop  can	start to report power estimates. One can get more accurate estimates by using this
	      option to enable a calibration cycle. This will cycle through various display levesl and USB device activities and workloads.

       --debug
	       run in "debug" mode.

       --extech=devnode
	      use the Extech Power Analyzer for measurements. This allows one to specify the serial device node of the serial to USB adaptor  con-
	      necting to the Extech Power Analyzer, for example /dev/ttyUSB0.

       --help
	       show the help message.

       --html[=FILENAME]
	      generate	an  HTML report. If a filename is not specified then the default name "powertop.html" is used. The HTML report can be sent
	      to others to help diagnose power issues.

       --iteration[=iterations]
	      number of times to run each test.

       --time[=seconds]
	      generate a report for a specified number of seconds.

       --version
	      print version information and exit.

BUGS

       Send bug reports to <powertop@lists.01.org>

SEE ALSO

       The program is more fully described at https://01.org/powertop

AUTHOR

       powertop was written by	Arjan  van  de	Ven  <arjan@linux.intel.com>,  and  is	currently  maintained  by  Chris  E  Ferron  <chris.e.fer-
       ron@linux.intel.com>.

Linux								   June 1, 2012 						       POWERTOP(8)
All times are GMT -4. The time now is 11:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy