Download a db table through UNIX shell script

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Using Isql for SQL SERVER to get the table rows counts in UNIX shell script to

need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix) i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable. isql -v DSN USERNAME PASSWD ...

2. Shell Programming and Scripting

How to log file processing details to database table usnig UNIX shell script?

we are getting files on daily basis.we need to process these files. i need a unix shell script where we can count 1-The no of files processed 2-No of data/record processed for each files. The script should log these details into a database table. If there is any error while file...

3. Shell Programming and Scripting

Shell script - Download - Mysql replace

Hi, I have a video script. it has embedded Youtube videos. I want replace them downloaded version mp4 videos. this script has a mysql table. I want search "url_flv" field on table a youtube link if has a youtube link I want download it this command. I want extract uniq_id field for file...

4. Shell Programming and Scripting

Download latest file via ftp server unix through shell script

Hello this is my first post in this forum , I dont want to be unhappy.. I am writing one script but facing difficulty to find the latest file with some new pattern My requirement is 1. The file is coming like "ABCD-23220140303" at FTP server once in a week. 2. script will run on daily...

5. Shell Programming and Scripting

Need of shell script to download data using ftp

Hi ! I am just wondering shell script to download data from ftp... I have text file containing ftp address...looks like this ftp://site...../filename.xyz ftp://site...../filename.xyz ftp://site...../filename.xyz ftp://site...../filename.xyz script has to read ftp address and...

6. UNIX for Dummies Questions & Answers

How to Update DB table from txt file using CRONJOB in Unix Shell Script

Hi Experts, can guide how we can Update a Database Table using a txt file source Using Unix Shell Scripts. What are the Cron Jobs codes can written to Update DB table. txt file contains record like data. US 09/03/2012 User DocType DocID. these above feilds in txt files need to be updated in...

7. Shell Programming and Scripting

Help on FTP download using UNIX script

Hi guys, I'm new on this forum and on UNIX. Can somebody help in writing a script to download a file from an FTP server and validating if there is a file to download. If there is a file, I would send it to a mail recipient and if not I would generate an error log. Thanks in advance!:D

8. Shell Programming and Scripting

Shell script to automatically download files

I am new to shell scripting and need to write a program to copy files that are posted as links on a specific url. I want all the links copied with the same file name and the one posted on the webpage containing the url onto a specific directory. That is the first part. The second part of the script...

9. Shell Programming and Scripting

shell script to download variables files

Hello all i am working on creating shell script to download files daily example : file12_10_2009.txt.gz next day this file will be file13_10_2009.txt.gz and so on.. i need help to know how to download this incrimental date files daily ? regards

10. Post Here to Contact Site Administrators and Moderators

Where can I download the VTC - Unix Shell Scripting Advanced complete video

Where can I download the VTC - Unix Shell Scripting Advanced complete video. I don't know in which thread I should post this question.Plz help me out, or just tell me the link in the reply to this post. Thanks in advance.

LEARN ABOUT DEBIAN

clipf

clipf(1)						      General Commands Manual							  clipf(1)

NAME

       clipf - Personal finance manager with command line interface

SYNOPSYS

       clipf [<conf_dir>]

DESCRIPTION

       Simple  personal finance manager, allow to track Your incomes/expences by accounts and hierarchical categories. Store all data in flat text
       files.

ARGUMENTS

       <conf_dir>
	      Directory with configuration file and data files. Default to ~/.clipf/. If there is no such directory found at program  startup,	it
	      would be created and populated by default configuration and empty data files.

DEFINITIONS

       account - describe independent money storage, for which You want to track remains and turnover.

       item - describe categories of Your incomes/expences. Can be nested as files/directories in file system.

       item code - it is segmented unique identifier of item/item group. Period "."  in item code define nesting levels. Period at the end of item
       code describe, that this item is group (have subling items).

       operation - define single money transaction (income or expense).

       tag - arbitrary string, used for additional classification of operations.  Have the same nesting rules as items.  Any number of tags can be
       added to each operation. It may be good idea to store available tags in item list.

USAGE

       Type help to see available commands. Type help <command> to see online help about particular <command>.

       For most reporting commands, output can be piped to external shell command the same way, as shell do.

COMMANDS CONCERNING ITEMS

       prod add [-d] <item_code> <item_name>
	      Add new item. Type <item_name> in quotes, if it contain spaces.

	      -d     - define this item as income (default to expence).

       prod rm <item_code_prefix>
	      Remove all items, which code starts with <item_code_prefix>. This don't affect the operations list.

       prod ls [<item_code>]
	      Show one level of item list - direct sublings of <item_code>. Default to root level.

       prod mv <old_item_code_prefix> <new_item_code_prefix>
	      Update  all  item  codes,  which starts with <old_item_code_prefix>, replacing it to <new_item_code_prefix>. Item codes in operation
	      list would be updated as well.

COMMANDS CONCERNING OPERATIONS

       op add [-d <date>] [-a <account>] [-t <tag>] <item_code> <amount> [<note>]
	      Add new operation

	      -d <date>
		     - override default operation date to <date>.

	      -a <account>
		     - override defaut operation account to <account>

	      -t <tag>
		     - label operation with <tag>. Any number of -t options can be used to add several tags to operation.

       op ls [-t <tag_prefix>] [<item_code_prefix>]
	      Show list of operations in current reporting period. If <item_code_prefix> specified, list would be limited by the operations, which
	      item  code  starts  with <item_code_prefix>. If '-t <tag_prefix>' option specified, limit output with operations, labelled with tag,
	      starts with <tag_prefix>

COMMANDS CONCERNING REPORTING

       Reporting period is always between <date_from> and <date_to> global options, which You set by set command.

       rep prod [-t <tag_prefix>] [-a <account>] [<item_code>]
	      Show turnover report for items (item groups), which are direct subling of <item_code> (default to root). Turnover for item group	is
	      summ of turnovers of all their nested items/groups.

	      -t <tag_prefix>
		     take into account only operations, labelled with tag, starts with <tag_prefix>

	      -a <account>
		     take into account only operations by <account> account.

       rep acc
	      Show remains and turnovers for all accounts.

OTHER COMMANDS

       set <option> <value>
	      Set global option <option> value to <value>. For date options, base format is Y-M-D. Leading 0 can be ommited. For the current year,
	      year part can be ommited. For current month, year and month parts can be ommited.  Available options:

	      date   - default date for new operations. Can be overriden by -d option of "op add".

	      date_from

	      date_to
		     - reporting period for "op ls" and all "rep" subcommands.

	      acc    - default account for new operations. Can be overriden by -a option of "op add".

	      max_lines
		     - if number of lines in report output exceed this value, then "less" would be used to show report output.

       show [<option>]
	      Show current values of all global options or specified <option>.

       calc <expression>
	      Embedded calculator. Evaluate numeric expression and print the result.

ALIASES

       Aliases is the simple way to make shortcuts for frequently used commands. Alias can be defined by the pair of  strings:	<command_line_pre-
       fix>  and  <prefix_substitution_string>. If command line starts with any of the defined aliases <command_line_prefix>, this prefix would be
       substituted with corresponding <prefix_substitution_string>. Examples can be found in system configuration file (see FILES ).

EXAMPLES

       set date_from 2008-04-01
	      - set reporting start period to 2008-04-01.

       r prod - show turnover report by top level items.

       op ls | grep foo | less
	      pipe report output to shell command.

       op ls | cat - >somefile.txt
	      save report output to file

FILES

       All configuration files have the same format - plain python code, that would be executed during clipf startup, in the context of main  mod-
       ule.  More specific configuration file can overwrite settings from more general one.

       /etc/clipf.conf
	      system-wide configuration file

       ~/.clipf.conf
	      user-specific configuration

       <config_path>/clipf.conf
	      configuration-specific settings.

       ~/.clipf/
	      Default configuration directory. Contain clipf.conf configuration file, and db/ subdirectory with data files.

AUTHOR

       Denis Galtsev <galtsevdv@gmail.com>

SEE ALSO

       Program site at: http://code.google.com/p/clipf/

																	  clipf(1)

Shell Programming and Scripting