10-29-2001
Hi!!,
frankly speaking.. I donno much about databases and MS Access. So, it would be much easier if u can somehow port the contents of the database to a simple unix file. Then a simple script can be used to change the file name depending upon the shape of the file and position of the columns.
I have a vague idea... but that might help you..I remember, one of my windows savvy client wanted my application to generate reports on Linux which can be open in Excel. All I had to do in that case was to separate the rows with a tab while generating the reports and that worked fine on Excel. Find out if you can do the vice versa.. I assume that the data in MS Access is displayed in Excel like format. If u can find a way to copy it to a Excel sheets, that might make ur life much easier..
Good Luck..
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
my company is considering a new development of our web site, which used to run on Apachi over Solaris.
The company who is going to do this for us knows only about developing it in ASP.
I guess this means we'll have to have another ISS server on NT for these dynamic pages :(
What are... (5 Replies)
Discussion started by: me2unix
5 Replies
2. UNIX for Dummies Questions & Answers
Hi there all
I am looking for both a web browser as well as a web server (Ie. Netscape Fasttrack) that will run on HPUX 10.
If you know where I can get these free via FTP, please contact me as soon as possible!!
Thanks,
Mark (1 Reply)
Discussion started by: mleathers
1 Replies
3. UNIX for Dummies Questions & Answers
Hi all! I'm a web developer with a question.
We have a contractor that is working on a project that requires the user to access a ton of files on the clients Unix server. He has plans to built a VB interface for on site windows users to access those files and wants us to develop a web based... (4 Replies)
Discussion started by: Imhotep1963
4 Replies
4. UNIX for Dummies Questions & Answers
How can I conncet web server via web?
What are the pre- requist?
I am having only one Public IP, I am useing SCO OPEN SERVER 5.0.5
Help Me.
Thanks in advance (3 Replies)
Discussion started by: max_san007
3 Replies
5. Shell Programming and Scripting
Greetings!
Does anyone know of a utility or a script for renaming files on a UNIX web server? I've seen several of these types of renaming utilities for Windows, but none for UNIX. I have 10,000 files that I need to rename in a several tier (deep) web site directory. I have the original... (2 Replies)
Discussion started by: everettr
2 Replies
6. Shell Programming and Scripting
script for to take files from FTP server to UNIX server and Unzipped that files (1 Reply)
Discussion started by: sunilamarnadh
1 Replies
7. Shell Programming and Scripting
I have to write a script to get some files from remote server using FTP and rename it after the FTP. I use wildcard to get the file as i do not no the exact file name or the number of files in the remote server.
My script is similar to the following...
#!/bin/sh
LOG=/Log/ftp.log
ftp (FTP... (0 Replies)
Discussion started by: infossiva
0 Replies
8. Shell Programming and Scripting
Hi Friends,
I have a requirement to get multiple files from ftp(remote) server and once the files is copied to local machine , I need to move the files on to a different directory in ftp machine.
FTP Machine : 9.9.999.999
Source File Directory : /ftpuser
File Pattern: TMS*
Now I have... (1 Reply)
Discussion started by: lokeshbao87
1 Replies
9. Shell Programming and Scripting
Hi,
In sftp script to get files, I have to rename all the files which I am picking. Rename command does not work here. Is there any way to do this?
I am using #!/bin/ksh
For eg: sftp user@host <<EOF
cd /path
get *.txt
rename *.txt *.txt.done
... (7 Replies)
Discussion started by: jhilmil
7 Replies
10. Shell Programming and Scripting
Good day all.
I'm trying to rename some files in my home directory with some bizarre results. Basically I need to change the IP address in the filename to the hostname which I ggrep from within the file:
-rw-r--r-- 1 bh694n nrc 5095 May 2 20:03 alarms_999.189.161.146.log... (2 Replies)
Discussion started by: BRH
2 Replies
LEARN ABOUT DEBIAN
bp_biofetch_genbank_proxy
BP_BIOFETCH_GENBANK_PROXY(1p) User Contributed Perl Documentation BP_BIOFETCH_GENBANK_PROXY(1p)
NAME
biofetch_genbank_proxy.pl - Caching BioFetch-compatible web proxy for GenBank
SYNOPSIS
Install in cgi-bin directory of a Web server. Stand back.
DESCRIPTION
This CGI script acts as the server side of the BioFetch protocol as described in http://obda.open-bio.org/Specs/. It provides two database
access services, one for data source "genbank" (nucleotide entries) and the other for data source "genpep" (protein entries).
This script works by forwarding its requests to NCBI's eutils script, which lives at http://www.ncbi.nlm.nih.gov/entrez/eutils/efetch.fcgi.
It then reformats the output according to the BioFetch format so the sequences can be processed and returned by the Bio::DB::BioFetch
module. Returned entries are temporarily cached on the Web server's file system, allowing frequently-accessed entries to be retrieved
without another round trip to NCBI.
INSTALLATION
You must have the following installed in order to run this script:
1) perl
2) the perl modules LWP and Cache::FileCache
3) a web server (Apache recommended)
To install this script, copy it into the web server's cgi-bin directory. You might want to shorten its name; "dbfetch" is recommended.
There are several constants located at the top of the script that you may want to adjust. These are:
CACHE_LOCATION
This is the location on the filesystem where the cached files will be located. The default is /usr/tmp/dbfetch_cache.
MAX_SIZE
This is the maximum size that the cache can grow to. When the cache exceeds this size older entries will be deleted automatically. The
default setting is 100,000,000 bytes (100 MB).
EXPIRATION
Entries that haven't been accessed in this length of time will be removed from the cache. The default is 1 week.
PURGE
This constant specifies how often the cache will be purged for older entries. The default is 1 hour.
TESTING
To see if this script is performing as expected, you may test it with this script:
use Bio::DB::BioFetch;
my $db = Bio::DB::BioFetch->new(-baseaddress=>'http://localhost/cgi-bin/dbfetch',
-format =>'genbank',
-db =>'genbank');
my $seq = $db->get_Seq_by_id('DDU63596');
print $seq->seq,"
";
This should print out a DNA sequence.
SEE ALSO
Bio::DB::BioFetch, Bio::DB::Registry
AUTHOR
Lincoln Stein, <lstein-at-cshl.org>
Copyright (c) 2003 Cold Spring Harbor Laboratory
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See DISCLAIMER.txt for
disclaimers of warranty.
perl v5.14.2 2012-03-02 BP_BIOFETCH_GENBANK_PROXY(1p)