Sponsored Content
Top Forums Shell Programming and Scripting Import data from compressed file Post 52419 by obitus on Friday 18th of June 2004 01:39:17 AM
Old 06-18-2004
Personally, I don't know orcale.

However, how would you normally import the data? Is it like a text file with SQL statements, or a CSV file or something?

If there is a tool for orcale that supports reading the data from STDIN, you'll be able to use [b]zcat to cat the compressed data and pipe it into the import tool.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

import compressed files using pipe

I am trying to import compressed files using a pipe on a server, IBM AIX UNIX 3.4, with very little disk space The command is: nohup cat xaa xab xac xad xae xaf xag | uncompress - > imp_pip & Then the imp_pip file is used in the import statement, files=imp_pip Does this statement... (0 Replies)
Discussion started by: pengwyn
0 Replies

2. Windows & DOS: Issues & Discussions

import data files from Unix to Windows?

Hi, Is there any way to import data files from Unix system to Windows system? I have many data files on Unix machine generated every night. I need to pick certain data from each file and plug them into this windows file on the network share drive. Anyone has any idea? Thanks in advance! (8 Replies)
Discussion started by: whatisthis
8 Replies

3. Solaris

invalid compressed data--crc error

I am getting this error when trying to unzip a file.gz . Anyone know how to resolve this ? (3 Replies)
Discussion started by: jxh461
3 Replies

4. UNIX for Dummies Questions & Answers

How can import data files to XL sheet.

Hi, I have the file(F1.XL) in Unix Box. it's updating every 1hr. I would like to import f1.xl to Windows excel sheet, when i need see the reports. can any one clarify, is there any VB script for importing data from UNIX, like sql connection.... thanks (1 Reply)
Discussion started by: koti_rama
1 Replies

5. Shell Programming and Scripting

Data Import perl script

Hi, I have a requirement for creating a Perl Script which will perform Data Import process in an automated way and I am elaborating herewith : Section 1 ) - use the following command line format : "./import.pl -h hostname -p port -f datafile.txt" Section 2) datafile.txt will... (3 Replies)
Discussion started by: scott_apc
3 Replies

6. Shell Programming and Scripting

Ucompress the compressed data

Hi, I have a file that has got compressed data. I would want to uncompress the packed decimal data(not the file). is there a way to do that in ksh? (6 Replies)
Discussion started by: ahmedwaseem2000
6 Replies

7. UNIX for Dummies Questions & Answers

Extracting data from many compressed files

I have a large number (50,000) of pretty large compressed files and I need only certain lines of data from them (each relevant line contains a certain key word). Each file contains 300 such lines. The individual file names are indexed by file number (file_name.1, file_name.2, ... ,... (1 Reply)
Discussion started by: Boltzmann
1 Replies

8. Shell Programming and Scripting

shellscript to read data from txt file and import to oracle db

Hi all, Help needed urgently. I am currently writing a shellscript to read data/record from a flat file (.txt) file, and import/upload the data to oracle database. The script is working fine, but it takes too long time (for 18000 records, it takes around 90 mins). I guess it takes so long... (1 Reply)
Discussion started by: robot_mas
1 Replies

9. Shell Programming and Scripting

Data to import the database as snippets

Hi all, I don't know if this the right place to post my question to get some ideas on how to done this. I have a text files extracted from OCR that need to have snippets to be import to database as snippet table which have columns "snippet, date, title" I dont know if shell scripts can do it... (11 Replies)
Discussion started by: lxdorney
11 Replies

10. UNIX for Beginners Questions & Answers

Using bash script : How to Import data from a dsv file into multiple tables in mysql

HI I have a dsv file that looks like: <<BOF>> record_number|id_number|first name|last name|msisdn|network|points|card number|gender 312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M 313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M... (4 Replies)
Discussion started by: tera
4 Replies
evolution-addressbook-import(1) 				   User Commands				   evolution-addressbook-import(1)

NAME
evolution-addressbook-import - import contact information into the local address book in Ximian Evolution, Sun Microsystems Edition SYNOPSIS
evolution-addressbook-import [--help] [--input=input-file] [--usage] [--version] DESCRIPTION
Import contact information into the local address book from a file. The file contents can be in either virtual-card (Vcard) format or comma-separated value (CSV) format. OPTIONS
The following options are supported: --help Display help text. You can also use -? to specify this option. --input=input-file Specify the input file that contains the information to be imported. --usage Display brief usage text. --version Display version information. EXAMPLES
Example 1: Importing Contact Information into Local Address Book From contacts.vcf example% evolution-addressbook-import --input=contacts.vcf EXIT STATUS
The following exit values are returned: 0 Application exited successfully 1 Application exited with failure FILES
The following files are used by this application: /usr/bin/evolution-addressbook-import Executable to import data into Evolution local address book $HOME/evolution Per-user configuration files and local storage for Evolution $HOME/evolution/mail/account/folders Temporary files for Evolution mail $HOME/evolution/sunone/account/folders Temporary files for Evolution Sun ONE account ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Architecture |SPARC | +-----------------------------+-----------------------------+ |Availability |SUNWevo | +-----------------------------+-----------------------------+ |CSI |Enabled | +-----------------------------+-----------------------------+ |Interface stability |Standard | +-----------------------------+-----------------------------+ |MT-Level |MT safe with Exceptions | +-----------------------------+-----------------------------+ SEE ALSO
Ximian Evolution Sun Microsystems Edition User Guide evolution(1), evolution-address-export(1) NOTES
Written by Steven Zhang, Sun Microsystems Inc., 2004. SunOS 5.10 15 Apr 2004 evolution-addressbook-import(1)
All times are GMT -4. The time now is 06:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy