data for spreadsheet


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting data for spreadsheet
# 8  
Old 09-06-2012
The usual thing is to stage each file to a staging table, and then move it to the transaction tables using additional parameters.
Login or Register to Ask a Question

Previous Thread | Next Thread

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Can't locate Spreadsheet/ParseExcel

Hi I can't seem to figure out why i keep getting this error. the Spreadsheet::PhaseExcel is installed on 3 servers and is working on only 2... the last one it is installed exactly the same way but I keep getting this error. This is whats odd. If i run this script as a normal user i get... (2 Replies)
Discussion started by: vpundit
2 Replies

2. Shell Programming and Scripting

Using Spreadsheet on Perl in UNIX

Very new to UNIX, so still getting used to all this. I made a Perl script where I want to create a spreadsheet file when extracting "data" from a text file. Now, this works perfectly fine on my Windows OS since I'm using the Win32 libraries with Microsoft Excel, but when I want to try it out on... (0 Replies)
Discussion started by: kooshi
0 Replies

3. Shell Programming and Scripting

Renaming files based on data in a spreadsheet

I have a spreadsheet in a folder that looks like this: Sector1...Sector2...Sector3...Sector4...Sector5...Sector6...Sector7 SomeID....Title.......SomeID...SomeID....SomeID...SomeID....SomeID OtherID...MyTitle....SomeID...SomeID....SomeID...SomeID....SomeID... (7 Replies)
Discussion started by: Xterra
7 Replies

4. Shell Programming and Scripting

Trying to send an excel spreadsheet.

And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here: # This script sends Email acoording to command line arguments. # $1 - file to be attached (full path with name) # $2 - file name as it... (1 Reply)
Discussion started by: NycUnxer
1 Replies

5. AIX

Trying to send an excel spreadsheet.

I may have posted in the wrong section, either way I need some help. And I have to modify this part of the script, I'm not sure what to change the content-type to for this to work, or what else I would need to change here: # This script sends Email acoording to command line arguments. #... (1 Reply)
Discussion started by: NycUnxer
1 Replies

6. Shell Programming and Scripting

Converting HTML data into a spreadsheet

Hi, I have a perl script that prints some data in the form of a table (HTML table) Now, I want to be able to convert this data into a report on an Excel sheet. How can I do this? Regards, Garric (4 Replies)
Discussion started by: garric
4 Replies

7. Shell Programming and Scripting

help in Spreadsheet::WriteExcelXML

I want to know that will Spreadsheet::WriteExcelXML coding will work in unix with perl and shell scripting. (1 Reply)
Discussion started by: akash
1 Replies
Login or Register to Ask a Question
acctsh(1M)																acctsh(1M)

NAME
acctsh: chargefee, ckpacct, dodisk, lastlogin, monacct, nulladm, prctmp, prdaily, prtacct, shutacct, startup, turnacct - shell procedures for accounting SYNOPSIS
login-name number [blocks] [files ...] number file [mmdd] file [heading] [reason] DESCRIPTION
Can be invoked to charge a number of units to login-name. A record is written to to be merged with other accounting records during the night. Should be initiated via It periodically checks the size of If the size exceeds blocks, 1000 by default, is invoked with argument switch. If the number of free disk blocks in the file system falls below 500, automatically turns off the collection of process accounting records via the argument to When at least this number of blocks is restored, the accounting will be activated again. This feature is sensitive to the frequency at which is executed, usually by Should be invoked by to perform the disk accounting functions. By default, it will do disk accounting on the special files in If the flag is used, it does a slower version of disk accounting by login directory. files specifies the one or more filesystem names where disk accounting is to be done. If files is used, disk accounting will be done on these filesystems only. If the flag is used, files should be mount points of mounted filesystem. If omitted, they should be the special file names of mountable filesystems. Invoked by to update which shows the last date on which each user logged in (see runacct(1M)). Should be invoked once each month or each accounting period. number indicates which month or period it is. If number is not given, it defaults to the current month (01 through 12). This default is useful if is to executed via on the first day of each month. creates summary files in and restarts summary files in Creates file with mode 664 and ensures that owner and group are It is called by various accounting shell procedures. Can be used to print the session record file normally created by (see acctcon(1M)). Invoked by (see runacct(1M)) to format a report of the previous day's accounting data. The report resides in where mmdd is the month and day of the report. The current daily accounting reports may be printed by typing prdaily. Previous days' accounting reports can be printed by using the mmdd option and specifying the exact report date desired. The flag prints a report of exceptional usage by login id for the specifed date. Previous daily reports are cleaned up and therefore inaccessible after each invocation of The flag prints a report of exceptional resource usage by command, and can be used on current day's accounting data only. Can be used to format and print any total accounting file. Should be invoked during a system shutdown to turn process accounting off and append a "reason" record to Should be called by system startup scripts to turn the accounting on whenever the system is brought up. An interface to (see acct(1M)) to turn process accounting or The argument turns accounting off, moves the current to the next free name in then turns accounting back on again. (incr is a number starting with and incrementing by one for each additional file.) is called by and thus can be run under and used to keep to a reasonable size. FILES
holds all accounting commands listed in section(1M) of this manual accumulator for fees working directory current file for per-process accounting used if gets large, and during execution of daily accounting procedure contains the limits for exceptional usage by command name contains the limits for exceptional usage by login id summary directory, should be saved login/logoff summary SEE ALSO
acct(1M), acctcms(1M), acctcom(1M), acctcon(1M), acctmerg(1M), acctprc(1M), cron(1M), diskusg(1M), fwtmp(1M), runacct(1M), acct(2), acct(4), utmp(4). STANDARDS CONFORMANCE
acctsh(1M)