1. I'm able to ftp the file from desktop to Unix directory via windows cmd. Will there be any way to perform this FTP operation via UNIX directly? I meant logging in to putty and then ftp to desktop location and then get the file to unix directory. This way it will help me to automate the uploading process for other csv files.
Sorry but cant help you in this, this is something you need to contact your network/admin to check at firewall side whether the relative port is open or not. you need to provide the windows hostname/ipaddress to them.
Quote:
Originally Posted by Analabhatla
2. The csv file has the 4 fields and sql's that i need to run on database are present in 3rd field. I need help in writing the command / script which reads the sql in 3rd field for all the records and run it against the database and fill the result back in to last field of the file?
Does this mean you want to extract third filed from CSV? If yes,
do something like,
I am having problems uploading files to my new server. I am new at this so im sure im doing it wrong. I tried using wsftp but that didnt work. please help me!! (4 Replies)
hi,
i m working on a perl cgi script which uploads a file to the server. i m stuck. i hav written the errors.
plz help.
Sachin Kaw
______________________________________________________________________
#!/usr/bin/perl -w
use CGI;
use CGI qw(:standard);
use strict;
use POSIX... (4 Replies)
Hi
I have an excel file with only 5 rows .I want to uplaod those 5 rows to a database using a shell script.Is this possible.If so where do i start.
Thnks (1 Reply)
Hi,
Just wanted to know, how can I ftp/transfer/copy a (design.tar.gz) archive from a Unix Server (sdmc222.sdmc.cp-srv.com) which is at a remote location, to my Windows Desktop. Obviously, it is not possible at cmd prompt on my Windows using the following commands :-
ftp... (3 Replies)
Hi all
i have a such question this is my shell script my script must upload file to webdav server
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
#!/bin/sh
###... (1 Reply)
Hi ,
I want to upload some files from my desktop to unix server through FTP . The list of files are in a text file .Please suggest how to do it through scrip .
Thanks in advance ..
Anupam (8 Replies)
Hello,
I have a script that finds the latest version of a file in a folder on my Minecraft server. I'm trying to come up with something that will then FTP that file over to my fileserver.
Here's what I have that finds the newest file:
find /home/mc/archive/sbhouse -type f -mtime +45 -exec... (7 Replies)
Xperts,
My requirement is something like this,
I have a sql script which i need to embed in a shell. The sql (oracle) script will generate a .csv file in some Unix directory. the approximate file size is around 10 mb which i need to upload to an sftp server. My concern here is how to make... (5 Replies)
Hi,
I want to use scp to upload file to my unix server.
i am using this:
scp D:\testr.txt unixuser@unixhost:/path
it returns an error:
ssh: D: host/servname not known
i am not sure how to tell path of my D drive in the command and how will command understand it has to pick from my... (5 Replies)
Discussion started by: Kohli
5 Replies
LEARN ABOUT DEBIAN
cldump
cldump(1) User Manuals cldump(1)NAME
cldump - Clarion database extractor
SYNOPSIS
cldump [options] database.dat
DESCRIPTION
cldump extracts the data contained in a Clarion database; Clarion is a Windows IDE similar to Delphi or others, and has its own (simple)
database format.
cldump can extract the data contained in such a database, and export it to CSV, SQL (including the database schema, keys and indexes) or
its own format (this format will give you all the meta information, but isn't easily parsable).
A Clarion database consists in a set of files :
.DAT files contain the data,
.Kxx files contain the key/index data,
.MEM files contain the memo entries associated to the data.
OPTIONS -x n, --decrypt n
Decrypt an encrypted file. Required argument n indicates the location where the key will be retrieved. Valid values are in the range
1 - 4 inclusive. n = 1 usually works.
Decryption happens in-place so KEEP A BACKUP as there is no guarantee the decryption process won't fail. Encrypted files must be
decrypted before they can be dumped.
Note that only the data file and the memo file are decrypted in this process; key/index files are left untouched as cldump doesn't
use them.
-d, --dump-active
Dump active entries only
-D, --dump-data
Dump the actual data (active and deleted entries)
-m, --dump-meta
Dump meta information (no SQL or CSV output format exist for this option)
-f c, --field-separator c
Set the field separator to character c. Only valid for CSV output (see below).
-c, --csv
Dump data or schema in CSV format
-S, --sql
Dump data or schema in SQL format
-s, --schema
Dump database schema
-M, --mysql
Use MySQL specific construct (backticks, ...)
-n, --no-memo
Do not dump memo entries
-U[charset], --utf8[=charset]
Transcode strings and memos from charset to UTF-8 (charset defaults to ISO8859-1; for the list of supported charsets, see iconv
--list)
OUTPUT
cldump outputs the data to stdout or stderr depending on the output format selected, the data to extract and the type of the data (data,
meta data).
BUGS
The SQL output could be improved. Not all the types supported by the Clarion database format are implemented yet (due to lack of test data-
bases using these types of data); see the source code for details.
Please report bugs to jb@jblache.org; if possible, please send patches as the set of test databases I have is very limited.
AUTHOR
cldump was written by Julien BLACHE <jb@jblache.org>.
HOMEPAGE
http://www.technologeek.org/projects/cldump/
Linux November 2010 cldump(1)