06-30-2008
is this one time effort or you have to do this every time?
if its just one time only:
1) export the excel file as csv , choose a suitable delimiter
2) loop through the csv file, construct SQL statements as you go along
3) depending on which database you have, there will usually be some command line database tool to bcp into the database.
if its every time you need to do this: i suggest you use programming languages such as Perl/Python which have libraries to extract data from excel file (automated). Then as usual, construct SQL statements and do your database updating. there may also be command line tools designed to extract excel data as well so you can also use that in your script.
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: sachin_kaw
4 Replies
2. Shell Programming and Scripting
Hi all
i have a such question this is my shell script my script must upload file to webdav server
//////////////////////////////////////////////////////////////////////////////////////////////////////////////
#!/bin/sh
###... (1 Reply)
Discussion started by: knut
1 Replies
3. Shell Programming and Scripting
hello,
I'm trying to upload a file to this ftp server and others ftp://ftp.byethost12.com as you can see in the output of CURL using the -v option
curl reports that the upload succeeded but when i connected to the server with file-zilla there is no file uploaded the same command
upload files... (5 Replies)
Discussion started by: laraaj
5 Replies
4. Shell Programming and Scripting
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)
Discussion started by: nbsparks
7 Replies
5. Shell Programming and Scripting
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)
Discussion started by: Showdown
5 Replies
6. Shell Programming and Scripting
All,
I have an excel sheet Excel1.xls that has some entries.
I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls
These may be in different workbooks. They are totally independent made by 2 different users.
I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies
7. Proxy Server
I have a requirement of following -
1. Transfer excel spreadsheet from desktop to unix server
2. Open the spreadsheet and read the sql row by row at a time
3. Run each sql on database using unix and then send output back to spreadsheet that was uploaded earlier and then transfer file back to... (12 Replies)
Discussion started by: Analabhatla
12 Replies
8. Programming
I have some records to be updated in oracle table. I am using sql developer tool. could any one tell me how to update those records in oracle table. I am having excel sheet with those records. (4 Replies)
Discussion started by: ramkumar15
4 Replies
9. UNIX for Dummies Questions & Answers
Hi,
I have requirement for automation, wanna confirm whether is it possible in shell scripting.
1) Need to read data from excel sheet
2) And upload the details in html page
I know first requirement is possible by converting excel into csv form, but not sure about the second one.
If... (6 Replies)
Discussion started by: stew
6 Replies
MONGO(1) Mongo Database MONGO(1)
NAME
mongo - the Mongo command-line tool
SYNOPSIS
mongo [OPTIONS] [DB_ADDRESS] [FILE+]
DESCRIPTION
mongo is a JavaScript shell (with GNU readline capabilities). It supports interactive and non-interactive use. When used interactively,
JavaScript can be used to query the database or perform any other function normally available with SpiderMonkey. Database output is dis-
played in JSON format.
If JavaScript files are specified on the command line, the shell will run non-interactively, running each one in sequence and then exiting.
EXAMPLES
mongo start the shell, connecting to the server at localhost:27017 and using the test database
mongo foo
start the shell using the foo database at localhost:27017
mongo 192.169.0.5/foo
start the shell using the foo database at 192.169.0.5:27017
mongo 192.169.0.5:9999/foo
start the shell using the foo database at 192.169.0.5:9999
mongo script1.js script2.js script3.js
run three scripts and exit
OPTIONS
--shell
run the shell after executing files
--help show usage information
--host HOST
server to connect to (default HOST=localhost)
--port PORT
port to connect to (default PORT=27017)
--nodb do not connect to mongod
--eval SCRIPT
evaluate JavaScript
-u USERNAME
specify user to log in as
-pPASSWORD
specify password of user (notice there is no space)
COPYRIGHT
Copyright 2007-2009 10gen
SEE ALSO
For more information, please refer to the MongoDB wiki, available at http://www.mongodb.org.
AUTHOR
Kristina Chodorow
10gen June 2009 MONGO(1)