Work On Perl Script & Sql
Required skills: Perl/CGI, MySQL, MS SQL, PostgreSQL, SQL
We need help to complete a complex Perl script. Only experienced Perl coders need apply.
The script generates SQL statements in text files so a knowledge of SQL is also required.
** Payment will not be made unless the script works on our test system(s) **
The script takes pipe delimited text files & database table structure information and constructs tab delimited text files with a header row, suitable for load into external databases, reporting tools or excel.
The text files created are all exported from a proprietary database using a unix command line utility and are initially pipe delimited - without a header row - but converted by the script to have tabs and a header row. At the moment the script also dynamically creates a file describing the structure (google schema.ini files) of the tables.
The script is configured by an XML configuration file (parsed by XML::Parser). It exports the database tables listed in the XML file and places them in a directory on the server, shared by samba.
The script is well commented and around ~500 lines long and contains half a dozen subroutines.
Your task is to add routines to the script to achieve the following:
1. Generate SQL statements to create the tables in MySQL, PostgreSQL and Microsoft SQL Server 2005 and 2008 based on the database structure information.
2. Alter the tab delimited files record by record, field by field, so that the date and number formats match the format understood by the database (currently the tab files contain dates of DD-MMM-YY). Databases are VERY picky about dates, and seldom have any way of specifying the format of the incoming date during a bulk load. The conversion of the date fields must be achieved by using basic perl and not date/time libraries as the libraries available are inconsistent across operating systems.
3. Create the BULK LOAD statements to load the tab delimited text files from their textual form into the databases (Listed in point 1).
4. Its not possible to ‘hard code' the SQL statements, the script must generate them dynamically, based on the selection of tables exported.
The script generates SQL statements in text files so a knowledge of SQL is also required.
** Payment will not be made unless the script works on our test system(s) **
The script takes pipe delimited text files & database table structure information and constructs tab delimited text files with a header row, suitable for load into external databases, reporting tools or excel.
The text files created are all exported from a proprietary database using a unix command line utility and are initially pipe delimited - without a header row - but converted by the script to have tabs and a header row. At the moment the script also dynamically creates a file describing the structure (google schema.ini files) of the tables.
The script is configured by an XML configuration file (parsed by XML::Parser). It exports the database tables listed in the XML file and places them in a directory on the server, shared by samba.
The script is well commented and around ~500 lines long and contains half a dozen subroutines.
Your task is to add routines to the script to achieve the following:
1. Generate SQL statements to create the tables in MySQL, PostgreSQL and Microsoft SQL Server 2005 and 2008 based on the database structure information.
2. Alter the tab delimited files record by record, field by field, so that the date and number formats match the format understood by the database (currently the tab files contain dates of DD-MMM-YY). Databases are VERY picky about dates, and seldom have any way of specifying the format of the incoming date during a bulk load. The conversion of the date fields must be achieved by using basic perl and not date/time libraries as the libraries available are inconsistent across operating systems.
3. Create the BULK LOAD statements to load the tab delimited text files from their textual form into the databases (Listed in point 1).
4. Its not possible to ‘hard code' the SQL statements, the script must generate them dynamically, based on the selection of tables exported.
Posted In:Perl/CGIMySQLSQLMS SQLPostgreSQL |
Related projects:
Mod title tags on perl script
er.txt file for title and meta tag info.
I'd like to have the script modified so that within the admin page, there was an option to create an individual title tag.
Would also like to do the same for meta tags description and keywords tags.
Does not have to be fancy, just has to work. Code should be clean and commented wherever possible.
Will post script on test site for you to look at admin panel page. Perl script files available for viwing on request.
I'd like to have the script modified so that within the admin page, there was an option to create an individual title tag.
Would also like to do the same for meta tags description and keywords tags.
Does not have to be fancy, just has to work. Code should be clean and commented wherever possible.
Will post script on test site for you to look at admin panel page. Perl script files available for viwing on request.
1-2 hours of work on phpprobid script, a few small fixes
ct it will take less than 1-2 hours to do these. So bid accordingly. Your bid amount will be for 2 hours of work.
It's ok if you can not do all these fixes in the time period I pay for just as long as you do as much as possible. I am open to discussion on the difficulty and time taken to do the fixes. If I am happy with your work after 2 hours theres potential for more work.
So enter your bid amount for 2 hours of work on my site! thanks.
It's ok if you can not do all these fixes in the time period I pay for just as long as you do as much as possible. I am open to discussion on the difficulty and time taken to do the fixes. If I am happy with your work after 2 hours theres potential for more work.
So enter your bid amount for 2 hours of work on my site! thanks.
need someone to fix the existing perl script in 2 hrs
hello all
i have a perl script which suddenly stops working
i need someone per expert who can fix the script for me
you must be fix it in 2 hrs
regards
tubemaker
i have a perl script which suddenly stops working
i need someone per expert who can fix the script for me
you must be fix it in 2 hrs
regards
tubemaker
strong PERL script Expert to tune existing perl scripts $ 60
Additional files submitted: (Files are only available for logged in users)
scripts-tables.zip
HOW-TO-Run.txt
Execute Perl Script from Stored Procedure in SQL Server Express 2008 database
that picks up a pdf file from a database table, feed it to a perl script which outputs parsed data that the stored procedure must store back into another table.
You don't need to write the parsing perl script, as it is already written and works, you all you need is just to invoke it from the stored procedure.
Should be an easy and straight forward job for someone who has done it before so please don't bid so high. Please PM me if you have any questions.
You don't need to write the parsing perl script, as it is already written and works, you all you need is just to invoke it from the stored procedure.
Should be an easy and straight forward job for someone who has done it before so please don't bid so high. Please PM me if you have any questions.
Classified Ad Perl Script Modifications
od communication skills that can make suggestions on other improvements if discovered while making modifications.
Work will be done on password protected domain we can both view and I'll copy changed files to live site after work completed. I'm attaching a few files so you can get an idea what current script functions look like. Note: script once used session IDs but now uses cookies, there may still be references to sessions in script functions but I believe they are commented out.
Work will be done on password protected domain we can both view and I'll copy changed files to live site after work completed. I'm attaching a few files so you can get an idea what current script functions look like. Note: script once used session IDs but now uses cookies, there may still be references to sessions in script functions but I believe they are commented out.
PERL: Modify Existing "interactive" script to "non-intractv"
before, but lost the file during a server recovery operation.
Basically we remove the non-interactive elements of the PERL script, then adapt the script to work with the other 5.
It's for an automated website publishing platform.
This project has capacity for future projects based on extending the ability of any of the 6 working parts.
Basically we remove the non-interactive elements of the PERL script, then adapt the script to work with the other 5.
It's for an automated website publishing platform.
This project has capacity for future projects based on extending the ability of any of the 6 working parts.
Modify Perl Script To Print Additional Line From Parsed File
g. It currently does not print out email addresses and would like to also print/save email addresses. So right now instead of printing the lines that have an email address is skips them.
This is a very simple thing i am sure for a Perl expert, so hoping to get this done today/tomorrow at the latest. Low budget due to how easy this should be.
Thanks for the help, also may have ongoing work in the future which would be nice to work with on person instead of many.
This is a very simple thing i am sure for a Perl expert, so hoping to get this done today/tomorrow at the latest. Low budget due to how easy this should be.
Thanks for the help, also may have ongoing work in the future which would be nice to work with on person instead of many.
Perl Script Changes
I am looking for someone who is a superstar with PERL to make some edits to an existing PERL script that we have. To make this simple, make your bid for 5 hours of work. If it is more then we will adjust accordingly.
You must be available to work on this between the hours of 10am and 2pm PST as it is collaborative in nature.
You must be available to work on this between the hours of 10am and 2pm PST as it is collaborative in nature.
CPanel eMail Script SQL
in to my email service on my web account. From that email, one data piece needs to be extracted and then used in a SQL query for a simple SELECT query. Then the results of the query will be inserted in a form letter and forwarded to the original email address along with a stock business response and some instructions.
I mentioned perl but any web script will do.
Happy bidding!
I mentioned perl but any web script will do.
Happy bidding!
need help writing unix / shell / perl scripts - $ 10 script
pt as detailed in pinnaclecart-catalog-script.txt file
this link has all test data
http://www.ameytech.com/data/sekhar/related-products/data.rar
in this script i already have perl script that connects to database and insert data
retrieve data.
i can share that too
let me know if some one is interested. you can write in any script
linux, shell, perl, ruby etc...
this link has all test data
http://www.ameytech.com/data/sekhar/related-products/data.rar
in this script i already have perl script that connects to database and insert data
retrieve data.
i can share that too
let me know if some one is interested. you can write in any script
linux, shell, perl, ruby etc...
php script - backup remote sql
les.
2) download the file to host computer
3) import them back into mysql (might have to drop and insert all or replace)
4) Delete the .gz files
It is up to you to determine the quickest and most efficient way to do this, perhaps download/upload file over ftp. Must work on my server flawlessly to get paid.
Expecting to pay $ 30-50 for the job, might need to still add a few small things to the script (will provide details if needed)
2) download the file to host computer
3) import them back into mysql (might have to drop and insert all or replace)
4) Delete the .gz files
It is up to you to determine the quickest and most efficient way to do this, perhaps download/upload file over ftp. Must work on my server flawlessly to get paid.
Expecting to pay $ 30-50 for the job, might need to still add a few small things to the script (will provide details if needed)
Review Error in My CGI/PERL Script installation, by montir
cript is Filechucker.cgi. Maybe somebody here have done with this before. I need your help.
I'm a web developer/designer too. But not so good on CGI/Perl language. That i know, its easy project for somebody that good on this. I just wanna pay $ 10 and good review for who can give me the solution.
Anyone who can do this, will be my partner for my another projects, especially on scripts modifying.
Link and details on PM
Regards,
Leksa
I'm a web developer/designer too. But not so good on CGI/Perl language. That i know, its easy project for somebody that good on this. I just wanna pay $ 10 and good review for who can give me the solution.
Anyone who can do this, will be my partner for my another projects, especially on scripts modifying.
Link and details on PM
Regards,
Leksa
Perl Script Mod... Changing The Way It Outputs Tables
; ( 1=yes 0=no)
NEW---my $ ColumnDivider = ./vert-rule.png
NEW---my $ use_RowDivider = 1; ( 1=yes 0=no)
NEW---my $ RowDivider = ./horz-rule.png
##########################################################
don't know about the "real programming" that needs to be done in the script but I suspect it is somewhere around line 381
I have attached 2 scripts that i currently use that are very simular...
NEW---my $ ColumnDivider = ./vert-rule.png
NEW---my $ use_RowDivider = 1; ( 1=yes 0=no)
NEW---my $ RowDivider = ./horz-rule.png
##########################################################
don't know about the "real programming" that needs to be done in the script but I suspect it is somewhere around line 381
I have attached 2 scripts that i currently use that are very simular...
Update A Perl Script
need to retrieve these infos
Actually, the OpenSRS Api is programmed in PHP. The perl programmation is deprecated and OpenSRS technicians do not continue to code in perl.
For me, it means redoing all my website. On the other hand, I do not know how to schedule(program) in PHP.
I need a coder knowing perl to do this update.
Attachments :
1. opensrs perl client
2. fields needing to be added to the form
You can find all infos typing opensrs perl client in Google
Actually, the OpenSRS Api is programmed in PHP. The perl programmation is deprecated and OpenSRS technicians do not continue to code in perl.
For me, it means redoing all my website. On the other hand, I do not know how to schedule(program) in PHP.
I need a coder knowing perl to do this update.
Attachments :
1. opensrs perl client
2. fields needing to be added to the form
You can find all infos typing opensrs perl client in Google
Perl script to parse SEC filings
the paragraph, 9 entries, until the line 'Total repurchase agreements' is found. The required entries are specified in the attached file output_sample.xls (this file gives the expected results of the parsing of the first file N-CSRS of the first url).
The output of the project is:
- the perl script used to parse the filings;
- an excel file similar to the file output_sample.xls (attached) containing all the extracted data.
The output of the project is:
- the perl script used to parse the filings;
- an excel file similar to the file output_sample.xls (attached) containing all the extracted data.
Perl script to scrape friends fb pages on the mobile site
. Scrape and save the information from all of the fields. Save all information from all freinds in a single delimited text file. The text file should be formatted with one friend in each row and one column for each possible field.
The only deliverable is the perl script and a sample text file. Send me the perl script and I will run it myself.
The only deliverable is the perl script and a sample text file. Send me the perl script and I will run it myself.
Update perl script, bug fixes
td align=right style="padding-left: 20px; width: 320px">
Additional files submitted: (Files are only available for logged in users)
steptortf.zip
Additional files submitted: (Files are only available for logged in users)
steptortf.zip
Apache Module, Perl Script: Limit Page Access Per IP/Sec
m/site.html
google.com/site.html
google.com/site.html
...
=> now restrict that to only 1 per IP per second.
Yes, I know there is mod_limitipconn but that doesn't work properly and is outdated.
If you can come up with a working solution, be it an apache module, perl script or shell script please bid.
Thanks
Oliver
google.com/site.html
google.com/site.html
...
=> now restrict that to only 1 per IP per second.
Yes, I know there is mod_limitipconn but that doesn't work properly and is outdated.
If you can come up with a working solution, be it an apache module, perl script or shell script please bid.
Thanks
Oliver
Looking for PHP and SQL DB developer to work on webpage
B developer.
if you skills match then you are most welcome to bid
I need this urgently done, so if you have good reviews, I will pay you full payment in advance, so
You can start work right away.
I have lots of projects lined up, so you will be very busy for long time
regards
rojoloc47
if you skills match then you are most welcome to bid
I need this urgently done, so if you have good reviews, I will pay you full payment in advance, so
You can start work right away.
I have lots of projects lined up, so you will be very busy for long time
regards
rojoloc47
