Need to create a perl script that adds a header line to a csv file and updates the date format column.
Files
Raw File called ftc_order.csv
The Perl scripts needs to add the following header line to the csv
header.csv (file attached)
Also the date format column needs to be updated from "20110327" to "27/03/2011"
The file then needs to be saved at ftc_order_(Todays date).csv
Timeline for project 48 hours.
Tags: add format csv file, csv, date, date format csv iphone excel, excel add date format, excel changes date format csv, excel changes date format saving csv, excel csv change date format, excel date time csv change, file, format, header, line, linux script add line file dont exists, perl, php script add host header iis, shell script add line file
Apr 1
Posted by admin in MySQL, Perl, PHP, Python, Twitter | Comments off
We require a program to use the twitter search api for specific terms and archive the resulting tweets and info (handle, datetime).
Perl / Python only Please
Tags: amp, api, archive, customize search specific databse fields joomle, ebay search api php, odesk search api, open twitter search desktop flex application, perl, Python, remove terms use tag google maps api flash, search, search specific folder vba outlook, search specific outlook appointment vb net, time needed implement clickbank api, Twitter, twitter search autoreply, wordpress search specific category
The script must be in perl. This is not negotiable. 90% of the work is done already, you can adapt an existing script, see attached.
The script scrapes a list of tickers for companies releasing Earnings Announcement data today, from the website briefing.com, and outputs the data into a text file. The program will visit the page:
http://www.briefing.com/Investor/Private/Calendars/EarningsCalendar.htm
It will obtain a list of tickers (The fourth column, normally a 3 or 4 letter code), for all companies releasing earnings Before the Open today. It will ignore those companies realising earnings After the close. The script will then visit the page:
http://www.briefing.com/Investor/Private/Calendars/EarningsCalendarYesterday.htm
It will then obtain a list of tickers for all companies releasing earnings After the Close yesterday. It will ignore those companies realising earnings Before the Open. The script will then output the ticker list to a text file, with one ticker per line. The text file will be stamped with todays date e.g. tickers-YYYYMMDD.txt.
I have some code available for a related project available to make your life very easy. See attached.
Tags: companies, data, earnings, extract data website perl, list, perl, perl program read data website, perl read data website parse, perl script extract data website, perl script pull data website, php script scraping data fields website, scraping data bash perl, scraping data website, script, simple flash animation line drawing website, simple program code, tickers, website data extraction perl
Apr 1
Posted by admin in CSS, HTML, Javascript, PHP, Script Install | Comments off
ace Perl formmail script with a PHP script. Add email validation and reCaptcha to existing form.
Need PHP script and Javascript to have functions commented so they can be modified to use with other forms. Can place some comments in separate text file where needed,
Tags: convert php script perl, formmail, install, install php script website, install recaptcha php, install recaptcha php form, install recaptcha php sample, Javascript, perl, PHP, php script install wizards, php script required install complete, price install php script, recaptcha, recaptcha php custom install, replace clickbank php script, script
Willing to build site to perform HK Stock analysis. Scripts are written.
Need Long term relevant expert assist on differnt tasks.
Guarantee no more than 5 tasks in a month and you will also have ownership of the site built.
Hope see them as lesiure tasks
if having investment experience (HK stock market prefer) & know what the attachment is
pls kindly place a bid for monthly salary
p.s.
for the attachment, scripts/reload_all.prl is the main entry point …
Mar 29
Posted by admin in Javascript, PHP | Comments off
Need to have old Perl script for mailing replaced with a flexible PHP script for emailing form data that is submitted. Also install Captcha of my liking (show me examples and options). Some look strange. Want a reasonably clean looking and straight forward implementation and image choices.
I will need the PHP mail script to be commented where variables can be changed so script duplicated and renamed for other forms if needed. Also provide a text file with a brief explanation of what was done and any helpful tips on using what has created and resolving any future problems if they come up.
Tags: captcha, formmail, install, perl, PHP, replace, script
Mar 29
Posted by admin in Javascript, Perl, PHP | Comments off
i need a small perl or php or javascript
to handle below logic
step1: First remove duplicates from input/data/1.csv file ( remove based on 2nd column
"Model" – out of 152 rows you will get 5 rows without headers
Create a file in output/data/1.csv which will have 5 rows.
read 1st row in output/data/1.csv and read value in "Images1"
and go to input/images/ folder copy matching file and paste it to
output/images/ folder
Like this repeat for "Images2", "Images3" columns and copy files to output/images folder
step2: Now open the original csv file input/data/1.csv and read value in
"Images1" column and go to output/data/1.csv and get the image name and then
go to output/images/ folder and copy matching image and rename it as the name of file
image in "Images1" column in input/data/1.csv file paste it to final/images/ folder
This step is critical and you must understand clearly
here is sample test data
www.ameytech.com/tmp/tmp/projects/lcds-images/image-mapping.zip
I am looking hire Perl/CGI Programmer to rewrite the scripts usde in the following url
http://www.toursudan.com/cgi-bin/esdb/2bb.cgi?seq=board&board=12
Tags: board, cgi, perl, programmer
Mar 28
Posted by admin in Javascript, Perl, PHP | Comments off
You will write a Perl script that will extract products information from a website,
you will have to get crawl multiple pages to get all records, the information collected should
be parsed and stored in an mysql database.
Requirements:
– ability to code modular Perl script
– can build bot with WWW::Mechanize or WWW::Scripter
Tags: information, perl, scraper, script
Ive been running an Apache2 server with Perl in Windows 2000 since about 2002. Yesterday our computer went down. We were able to recover but now our Apache2 and Perl do not seem to be working. Both Apache2 & Perl were installed on the D drive which was not effected by the crash. We had to copy system files from a new installation of Windows 2000 to get the C drive back and Windows working. I think that its missing the system files to run apache2 and Perl. I need it fixed asap!
Mar 21
Posted by admin in Javascript, Marketing, PHP, Software Architecture, Telemarketing | Comments off
Upon receipt of an email inquiry, we wish to make an outbound (pre-recorded) phone call (US and Canada ONLY) using a service like CallFire. Currently, we receive and interrogate email inquiries and identify those to which we can respond positively. Most of these email inquiries contain a telephone number which is normalized by a perl script.
I seek assistance with the integration of the CallFire API (outgoing broadcast) using PHP and initiated by the receipt of a qualified inquiry. (We qualify the inquiry automatically using .procmailrc, a perl script and MySQL.)
Tags: email, inquiries, inquiry, outbound, perl, telephone, using
Expert Advise needed. No coding necessary.
This is a 90% complete project that is dropped by a coder. I need Expert Advise to find out what he did to my server. Fixing the code need not be done.
As far as I can see, the project requires
Mod_Perl,
Perl 5.12
ImageMagic 6.6
node 0.4
Dancer
I am guessing that a server was written in node language … to listen on a port. The daemon then interfaces with the perl app … Dancer is like something to manage the html portion of the site. I expect it to be a 3 day job at best
Mar 20
Posted by admin in Perl, Software Architecture, Troubleshooting | Comments off
Hi everyone,
This is a simple task but lo and behold I cant get this software to run on my machine. Backing up a lost site on behalf of a friend, project suitable for those with some experience in Perl. The site were trying to save is small, I doubt itll exceed 10MB so really no concerns in terms of bandwidth. Please check out the details below and let me know what you think in PMB.
http://warrick.cs.odu.edu/warrick.html
Thanks (P.S urgent-ish project)!
Tags: perl, piece, project, site, software, someone, warrick
Mar 19
Posted by admin in Perl, Web Scraping | Comments off
Hi,
I need a custom PERL script that opens a telnet connection to another application, executes a command and interpretes the result.
The first line in the script should be #!/path/to/perl -w followed by use strict;. Clean and good code is therefore required and warnings about uninitialized variables or else are not accepted.
The script has to run on CentOS 5.5 which comes with an older version of perl which is 5.8.8. Only the use of one addtional module is allowed which is Net::Telnet (Version 3.03-5) as available on CentOS 5.5.
The script shall take three command line parameters: ip, port and common_name
It establishes the connection to ip and port and sends the command "kill <common_name>". The resulting line gets interpreted. If the connection with the identifier <common_name> could be killed by the remote service you give back the exit code 0, if you couldnt connect via telnet the code 1, if the connection couldnt be killed 2, if the result of your command times out 3.
The remote application that is contacted via telnet is the openvpn management console.
Examples:
Common name found, connection killed (example with telnet client):
#####################################################################
[TEST]tunnel1 etc # telnet localhost 4242
Trying 127.0.0.1…
Connected to localhost.
Escape character is ^].
INFO:OpenVPN Management Interface Version 1 — type help for more info
kill sgloeckner
SUCCESS: common name sgloeckner found, 1 client(s) killed
quit
Connection closed by foreign host.
#####################################################################
Common name not found, connection not killed (example with telnet client):
#####################################################################
[TEST]tunnel1 etc # telnet localhost 4242
Trying 127.0.0.1…
Connected to localhost.
Escape character is ^].
INFO:OpenVPN Management Interface Version 1 — type help for more info
kill sgloeckner
ERROR: common name sgloeckner not found
quit
Connection closed by foreign host.
#####################################################################
As in all our biddings – since were an incorporated german company – the service provider has to be able to issue a valid invoice for his work – either with local tax payer id or vat code (if its a company).
Best regards,
Sebastian
Need a small Perl script that extracts XML attributes (ID for element) and nested child elements from a very large XML document (10MB+) and converts each element into a variable, then print to a flat file. The number of rel and target varies for each element and there will need to be logic to deal with this. Exact document provided after bidding completed.
Note: DO NOT OVERBID THIS PROJECT. FIRST $30 GETS IT. THIS SHOULD ONLY TAKE ABOUT 15 MINUTES.
e.g.
<element id="1" text="example 1">
<rel>rel1</rel>
<target>target1</target>
<rel>rel2</rel>
<target>target2</target>
<rel>rel3</rel>
<target>target3</target>
<element id="2" text="example 2">
<rel>rel1</rel>
<target>target1</target>
<element id="3" text="example 3">
<rel>rel1</rel>
<target>target1</target>
<rel>rel2</rel>
<target>target2</target>
<rel>rel3</rel>
<target>target3</target>
<rel>rel4</rel>
<target>target4</target>
….
desired output:
Element ID: 1, Text: example 1, Rel: rel 1, Target: target1
Element ID: 1, Text: example 1, Rel: rel 2, Target: target2
Element ID: 1, Text: example 1, Rel: rel 3, Target: target3
Element ID: 2, Text: example 2, Rel: rel 1, Target: target1
Element ID: 2, Text: example 2, Rel: rel 2, Target: target2
etc.
Dear,
I need an expert in C/C++ & Perl/CGI & Berkely database in Linux Debian System for teaching and customizing a small project related to networking.
Nabil
Tags: amp, customizong, Linux, perl, teaching
You will write small Perl scripts that will extract about 10-500 records from
websites, sometime you will have to get crawl multiple pages to get all records
and other times all records will appear on the same start page.
Requirements:
– ability to code modular Perl script
– can build bot with LWP::UserAgent, WWW::Mechanize
– good knowledge of HTML encode transferring
Longterm or shorterm, bid for 10 crawl scripts.
Tags: based, crawl, crawler, perl, project, records, scripts
I have a lot of static web pages with contact information I would like to convert with a tool like PERL script.
This way I can use it in the future going forward on all future files, with a little modification.
I need someone to write this script. Its basically searching through an HTML file template, and grabbing data from a few of the tables in the document.
I have a lot of static web pages with contact information I would like to convert with a tool like PERL script.
This way I can use it in the future going forward on all future files, with a little modification.
I need someone to write this script. Its basically searching through an HTML file template, and grabbing data from a few of the tables in the document.
I have a lot of static web pages with contact information I would like to convert with a tool like PERL script.
This way I can use it in the future going forward on all future files, with a little modification.
I need someone to write this script. Its basically searching through an HTML file template, and grabbing data from a few of the tables in the document.
I have two tasks to be completed quickly. Programmer should know linux & basic scripting.
1) Download this test page from youtube: http://www.youtube.com/results?search_type=videos&search_category=10&uni=3&suggested_categories=10,24&search_query=hello
I need a script (bash or perl), which will extract basic video information from the saved html page. For example, video url, video title, uploaded by, etc. You can output a CSV file or preferably mysql statements to dump in a database table.
2) See this page: http://stream0.org/2008/02/howto-extract-images-from-a-vi.html
ffmpeg is a tool that can be used on linux. Using some command line options, it can be used to extract frames of a video (specific frame number, or specific time, etc). Write a bash/perl script, that will extract all frames in a given video file. The frames should be stored per minute and per second. That is, say the video is 5 minutes long. then create folders 1, 2, 3, 4, 5 inside each of them, create folders named 0 to 59 (for seconds). All frames of a video (count=fps) to be stored in corresponding folder. This is an easy task (no video knowloedge is required, you dont need experience with ffmpeg). Just study the syntax and you have to write appropriate for-loops).
I will select the lowest bid from someone who can work today.
Note: This is very urgent requirement. I am in US Eastren time zone available from 10am – 12:00 midnight
You must communicate in SKYPE or GTALK.
You need to finish this work in 1 Day if not in 2 days. Do not bid if you do not have time
Here is the work:
Task # 1
currently i am using perl scripts to load product data into mysql tables and it is taking very long time to run.
it takes data from excel spread sheet and use template and load it to mysql database and after finishing it will
download as .sql file This whole process is taking long time because we have large data
We can avoid loading to mysql and create a similar format file as csv file and execute multiple threads so it will
run and finish faster.
Task #2
once above task # 1 is finished we are running another task wcich executes another perl script to do replacements
of variiable values again it uses mysql database to load data and perform replacemnts. if you expert in perl
you can do this on unix machine i have server and complete the task much faster.
Just to give example – currently for task # 1 to process 20mb file which will create 1.5gb .sql file it takes about 3 to 3.5 hours, like this i can only process 7 to 8 files per day.
This is for task 1 and for task 2 it takes equal amount of time.
I need your dedicated support to finish this project.
Note; these are existing perl scripts. you need to provide a work around or redo to finish each task in 5 to 10 minutes
Majority of time is consuming to create intermediate csv files, parsing, loading to mysql.
My estimate for this work is $40.00. But i can pay 50% more if you are skilful and finish the task on time.
Mar 10
Posted by admin in Perl, Software Architecture | Comments off
I need a script to parse a text file
The text file is an mbox file – a file from thunderbird containing email in text format
There are specific text patterns to look out for and I need specific fields to be pulled out and saved in a CSV file
Afterwards, I want to get rid of duplicates
The file itself maybe several GB in size!
So its not possible to load the whole file into memory and then parse it
I need a desktop solution – so Ill install Perl on my machine to run the script
Ill be happy to use something else if its easier to do in that
Please send a PM and I will send you a sample of the script
This job only pays $30 – its only a few lines of code
Thanks
OM
List of tasks. When bidding give a price for each task if you do not feel you can handle all of them, or one price for all. All of these tasks must all be completed within 10 days.
1. We need an installed security wrapper completed, with the sales and verification of the security codes. The site is buyorsell.it (both storefront and auction).
2. when you get those complete we need to smooth out the function of the Deed, reed seed program so users can add another item for sale more easily…. maybe add the donation level to their profile, or auto fill it in on the next addition too
3. domains forwarded to buy.it need to be operational so vendors can set up their inventory on the site and sell it from there (cannot be seen right now) upikapart.com and writerspublisher.com are two already they would be best set up as 10peak.buyorsell.it or as 10peak.storefront.buyorsell.it
4. another point we need to cover is to go through the items in the storefront… and be able to convert them to auction items using a clickbox or radio button type of scenario.
1.More Magic (cellphone refill) API
2.Liberty Reserve (payment system) APi
3. Privatbank.ru (payment system) API
4. https://www.cashu.com (payment system) API
5. mpayy API
6. Paypal isnt working quite right, not sending us (email) notification of payments made. (& other payment systems need to be offered as a choice of sellers).
7 Need the ability to create multiple (ebook) items for a single price so buyers get all of a set or series the author is selling without making another transaction.
8. We need the ability for authors uploading their ebooks for sale to have the security codes for them in a related secure directory. In the listing function.
9. deed, reed or seed a function that existed before and needs to be put into the when listings are being made
10. The control panel for the storefront isnt working properly (not sure what is required but it needs fixing/repair).
From you we expect daily progress reports, and that you have ratings as a perl programmer. No ratings no job.
Tags: buyorsell, com, payment, perl, security, storefront, system
I am seeking a perl programmer who can make the following:
A perl script that can get search terms from a database (around 20 a day), finds the local (Dutch) monthly search volume for that search term from Google External Keyword Tool and inserts that into the same database.
I found out that can be done with API, but I dont have an API key from Google, so thats part of the project too.
Provide the Maintenance of a Linux Debian System installed as a Vserver.
perform apt-get dist-upgrade and make sure the services are up and running.
Perform all installation process special with Plone and Zope CMS. – Experienced of Plone Installation of adds-on.
IT system administrator role, paid for this task :
The following packages will be REMOVED:
debian-maintainers libdatrie0 libept0 libgraphviz4 libmagick10 libmodule-pluggable-perl libsys-syslog-perl libxcb-xlib0 libxcb-xlib0-dev libxml-libxml-common-perl odbcinst1debian1 plone3-site
python-numeric python-psycopg python-psycopg2da python-zopeinterface zope-cachefu zope-cookiecrumbler zope-externaleditor zope-linguaplone zope-mysqlda zope-plone3 zope-psycopgda zope-tinytableplus
zope-zwiki zope2.10 zope3
The following NEW packages will be installed:
apache2.2-bin apt-xapian-index autopoint bind9-host consolekit cpp-4.4 dahdi dahdi-linux dmsetup exiv2 fakeroot fancontrol freetds-common fxload g++-4.4 gcc-4.4 gcc-4.4-base geoip-database git gnupg-curl
groff insserv install-info iso-codes lib32bz2-1.0 lib32v4l-0 libalgorithm-diff-xs-perl libalgorithm-merge-perl libaprutil1-dbd-sqlite3 libaprutil1-ldap libavahi-client3 libavahi-common-data
libavahi-common3 libbind9-60 libboost-iostreams1.42.0 libbsd0 libc-bin libc-client2007e libc-dev-bin libcdt4 libcgraph5 libck-connector0 libclass-inspector-perl libcommon-sense-perl
libcompress-raw-bzip2-perl libcorosync4 libdata-validate-domain-perl libdata-validate-ip-perl libdata-validate-uri-perl libdatrie1 libdb4.7 libdb4.8 libdirectfb-1.2-9 libdjvulibre-text libdns69
libdpkg-perl libdrm-intel1 libdrm-radeon1 libeggdbus-1-0 libept1 libexiv2-9 libfile-copy-recursive-perl libflac8 libfont-freetype-perl libgl1-mesa-dri libgmime-2.0-2a libgraph4 libgssapi-krb5-2 libgvc5
libgvpr1 libio-compress-perl libio-pty-perl libipc-run-perl libisc62 libisccc60 libisccfg62 libjack-jackd2-0 libjbig2dec0 libjpeg8 libjs-mootools libjson-perl libjson-xs-perl libk5crypto3 libkrb5-3
libkrb5support0 liblqr-1-0 libltdl7 liblua5.1-0 liblwres60 liblzma2 libmagickcore3 libmagickcore3-extra libmagickwand3 libmpfr4 libmysqlclient16 libnet-domain-tld-perl libnet-ipv6addr-perl
libnet-netmask-perl libnetwork-ipv4addr-perl libnss3-1d libonig2 libopenais3 libopencore-amrnb0 libopencore-amrwb0 libopenjpeg2 libopenr2-3 libossp-uuid16 libpam-ck-connector libpaper-utils libpathplan4
libpciaccess0 libpolkit-gobject-1-0 libpoppler5 libpri1.4 libqdbm14 librarian0 libreadline6 libregexp-assemble-perl libresample1 libsdl1.2debian libsdl1.2debian-alsa libsensors4 libsndfile1
libsox-fmt-alsa libsox-fmt-base libsox1b libspandsp2 libss7-1 libstdc++6-4.4-dev libsub-name-perl libsybdb5 libtalloc2 libtask-weaken-perl libtonezone2.0 libudev0 libunistring0 libv4l-0 libvorbisfile3
libwavpack1 libwiki-toolkit-plugin-json-perl libxapian22 libxcb-atom1 libxcb-event1 libxdot4 lm-sensors manpages-dev odbcinst odbcinst1debian2 php-auth-sasl php5-suhosin postgresql-8.4
postgresql-client-8.4 psutils python-apt python-apt-common python-chardet python-debian python-pkg-resources python-pyasn1 python-pygments python-xapian python-zope.interface python2.6 python2.6-minimal
rarian-compat sensible-utils sox squirrelmail-viewashtml tcl8.5 tsconf ufraw-batch xz-utils
The following packages have been kept back:
mysql-server mysql-server-5.0
The following packages will be upgraded:
adduser apache2 apache2-mpm-prefork apache2-utils apache2.2-common app-install-data apt apt-file apt-utils aptitude aspell aspell-en asterisk asterisk-config asterisk-sounds-main at awffull base-files
base-passwd bash bash-completion binutils bsd-mailx bsdmainutils bsdutils busybox bzip2 ca-certificates console-common console-data coreutils courier-authdaemon courier-authlib courier-authlib-userdb
courier-base courier-imap courier-imap-ssl courier-ssl cpio cpp cpp-4.3 cron curl cvs-buildpackage dash dbconfig-common dbus dbus-x11 dcraw dctrl-tools debconf debconf-i18n debhelper
..
Feb 23
Posted by admin in Perl, PHP, Software Architecture | Comments off
I change the requirement. Just simple login screen. after login, show a pull-down menu + data entry to take care the crud (create, read, update & delete) for customer file.
Perl + Session, no cookie. compare to previous is more easy. I think you have wrote the basic that day. just show me the video and quote me the price for the said software development time. Thank you very much.
Will attach a new sample for you reference.
This one, the sample login screen, I cut from my current php project…., i need it in perl too… thanks and hope to hear from you soonest.
http://dl.dropbox.com/u/2852409/page%201.jpeg
can pay 30$
I change the requirement. Just simple login screen. after login, show a pull-down menu + data entry to take care the crud (create, read, update & delete) for customer file.
Perl + Session, no cookie. compare to previous is more easy. I think you have wrote the basic that day. just show me the video and quote me the price for the said software development time. Thank you very much.
Will attach a new sample for you reference.
This one, the sample login screen, I cut from my current php project…., i need it in perl too… thanks and hope to hear from you soonest.
http://dl.dropbox.com/u/2852409/page%201.jpeg
can pay 30$
Tags: login, perl, programming, sample, screen, script, show
I have the Perl script to take data in XML and put it in a MySQL database. (FYI I have the script so I dont need it written.) We are currently using an older database that needs to be updated. I will need a non disclosure agreement signed. My website is in Perl and we are using a MYSQL database on a Linux server. I have an XML database and a Perl script that takes the XML Data and makes it into a MYSQL database. This should only take an hour or two to run this script. I have other work I need done but this is a priority so if you cant do the work right away please dont bid. You must be proficient in English so we can communicate clearly. Also, You must be available 8am – 6pm Central standard time or DALLAS Tx Chicago time. Im looking for someone long term that has exceptional perl programming experience to do upgrades to my website.
Arclite theme by digitalnature | powered by WordPress