Database Output
Project ID:
727357Project Type:
FixedBudget:
$30-$250 USD
Project Description:
Hi all,There is a site that outputs 1,000,000 single cell rankings on a daily basis (.csv). These rankings change on a daily basis. This csv file only has two things: the numbered ranking, and the name of the item.
I want an automated way to crunch this data in the following ways:
1. Find new additions to the list.
2. Biggest gainers and losers in terms of rankings. (so this process will involve yesterday's list)
I have servers available to crunch data (mysql) and would prefer this process be done there rather than a macro/script that crunches this on my desktop.
I would like the results to be outputted into excel format.
Skills required:
Excel, Microsoft Access, MySQL, Perl, PHPPublic Clarification Board
4 messages
-
slnima
Dear Sir,
Im a IT graduate with 5 yrs MySQL experience. i can create two simple queries (whic run on the server) to obtain these information you need. but sir i need more details regarding other tasks. pls tell me whether u wish to copy csv files manually to the server (database) or do i have to automatically import them form a given URL.
and i you wish to have the system using Access i also can do it very easily because i have 10 yrs experience in MS Access (2003). but i hope its better to use my SQL
Thank you very much and expecting a gladsome feed back.over 1 year ago
-
yazinc
We are ms access specialist.
Yazinc Providing smart and sharp business solutions by making easy to use and result oriented smart applications according to business needs. We developed Warehouse system to Medical Clinic System, Netcafe application to Fee management solution. Contact with us to get an accurate solution according to your requirements. Email yazinc at gmail do com
www.yasirikram.co.ccover 1 year ago
-
tueken
Although its easy by using perl and mysql, but someone need to install "DBI" modules on the server side.
over 1 year ago
Awarded Bids
All Bids ()
clearware
|
clearware
From Bulgaria
Offline
|
PHP Level 1 (88%, 99th percentile)
$230
in 5 days
over 1 year ago
Hello,
this sounds funny and interesting. Let's do it.
Please contact me if you are interested in out team or the technologies we use and the skills we have.
Hope to hear from you soon.
Regards
Peter Long
C... more
Hello,
this sounds funny and interesting. Let's do it.
Please contact me if you are interested in out team or the technologies we use and the skills we have.
Hope to hear from you soon.
Regards
Peter Long
ClearWare Team less
jhaynes75
|
jhaynes75
From Canada
Offline
|
HTML Level 1 (75%, 73rd percentile)
SQL Level 1 (98%, 100th percentile)
General Freelancer Orientation (95%, 100th percentile)
$75
in 2 days
$38 Milestone Requested
$38 Milestone Requested
over 1 year ago
professional software developer with over 10 years of experience
webtechinfo
|
|
webtechinfo
From India
Offline
|
Foundation EUFreelance.com Member
$180
in 3 days
over 1 year ago
please check inbox
thank you
Please see PM for full details
ViliusSutkus
|
ViliusSutkus
From United Kingdom
Offline
|
Freelancer Orientation (80%, 97th percentile)
HTML Level 1 (75%, 73rd percentile)
PHP Level 1 (78%, 89th percentile)
SEO Level 1 (83%, 94th percentile)
General Freelancer Orientation (90%, 98th percentile)
$150
in 3 days
$15 Milestone Requested
$15 Milestone Requested
over 1 year ago
Problem handler at your service.
indivar
|
indivar
From India
Gold Member
Offline
|
US English Level 1 (98%, 88th percentile)
General Freelancer Orientation (80%, 90th percentile)
$125
in 2 days
over 1 year ago
Hi,
Kindly view PM for details about our proposed solution.
Kind Regards
Inderjeet Singh
Pls see PM
Lucvba1
|
|
Lucvba1
From Israel
Offline
|
Foundation LimeExchange Member
Foundation EUFreelance.com Member
$90
in 4 days
over 1 year ago
Hi,
Please view the PM for more details.
Regards,
Luc
ixvivxi
|
ixvivxi
From United States
Offline
|
US English Level 1 (100%, 100th percentile)
C++ Level 1 (93%, 98th percentile)
Unix Level 1 (95%, 87th percentile)
General Freelancer Orientation (80%, 90th percentile)
$50
in 4 days
$5 Milestone Requested
$5 Milestone Requested
over 1 year ago
This bid is for a script that meets the listed requirements and also generates probabalistic analysis.
This is easy. I can make this for you in 1 or 2 days.
souvikbasu00
|
souvikbasu00
From India
Offline
|
$150
in 10 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
Hi,
This is very easily possible in Perl.. I can do this work for you in the given time :-)..
regards
SouvikB
vishalgoyal4
|
|
vishalgoyal4
Offline
|
Foundation EUFreelance.com Member
$30
in 0 days
$11 Milestone Requested
$11 Milestone Requested
over 1 year ago
Please Check PMB
Hi,
I can do it.
vasundhar
|
|
vasundhar
From India
Offline
|
Foundation EUFreelance.com Member
$500
in 3 days
$250 Milestone Requested
$250 Milestone Requested
over 1 year ago
Lets do it.
vitotafuni
|
|
vitotafuni
From Italy
Offline
|
Specialist Marketeer
General Freelancer Orientation (85%, 95th percentile)
Foundation EUFreelance.com Member
$300
in 10 days
$150 Milestone Requested
$150 Milestone Requested
over 1 year ago
nice to help you
I have experience with this type of calculation, I know exactly how to do this with MySQL and PHP. I will do this to suit your needs exactly, and won't let you down, this is reflected in my feedback too. Please check y... more
I have experience with this type of calculation, I know exactly how to do this with MySQL and PHP. I will do this to suit your needs exactly, and won't let you down, this is reflected in my feedback too. Please check your PMB for further information. less
afama
|
|
afama
From China
Offline
|
General Freelancer Orientation (80%, 90th percentile)
$50
in 2 days
over 1 year ago
Please check the PM, thanks
mike121zz
|
|
mike121zz
From United States
Offline
|
$30
in 2 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
take my bid only if you decide to go with the script from excel/vba.
ReliableRoshan
|
|
ReliableRoshan
From India
Offline
|
General Freelancer Orientation (80%, 90th percentile)
$125
in 3 days
over 1 year ago
Hi, I am interested in doing your project.
I am a perl and php programmer, I think I can do this easy ;)
Dear Sir, Please see the PM.I need more details.
anushreeshenoy
|
|
anushreeshenoy
From United States
Offline
|
$100
in 5 days
$100 Milestone Requested
$100 Milestone Requested
over 1 year ago
Hi,
I have experience in SQL, Python and excel. Using my Skillset i would be able to perform the data crunching mentioned by you in a small timeframe. Please do consider my bid.
Thanks and Regards,
Anu
ready to work at the minimum price
one of the experts with over 16 years of exp..
Hi
Please find PMB. We have same experience.
Thanks & Regards,
Devang Modi
Together Everyone Achieves More
Dear sir,
I using perl/php over 7 years and write a lot of scripts for text processing.
Thanks
nikka123
|
|
nikka123
From India
Offline
|
Freelancer Orientation (75%, 94th percentile)
$130
in 3 days
$46 Milestone Requested
$46 Milestone Requested
over 1 year ago
I am interested in your project. Can start as soon you assign. Plz chk PMBox.
Hi,
I'm expert on web search and data entry. you couldn't pay me if you will not satisfy.
Regards,
SRAS
alainalexa
|
|
alainalexa
From United Kingdom
Offline
|
$200
in 3 days
$100 Milestone Requested
$100 Milestone Requested
over 1 year ago
I am very interested in developing this project as the skills and the knowledge needed are matching with my area of expertise.
Hi I have a .net application that can do this immediately. please see PM for details
i can finish this project with time period
please check inbox thank you
I have some questions to you about this project. Without more details hard to predict right time for work. If you will be able to talk, please, send me e-mail.
Imranmahaadkhan
|
|
Imranmahaadkhan
From Pakistan
Offline
|
$150
in 15 days
$45 Milestone Requested
$45 Milestone Requested
over 1 year ago
i have done a bachelors degree and i am a master in advance ms access.
I have experirnce of 5 yrs in a Multinational company in this field.I thing it is enough for this job.
Regards
Sounds like a great project to me! Please view the private message I sent you. Thanks!
I can import the data (*.csv) file into a access database. then we can find the new additions from the previous day's data and also we can find biggest losers and gainers (like top 100) through query. finally we can ex... more
I can import the data (*.csv) file into a access database. then we can find the new additions from the previous day's data and also we can find biggest losers and gainers (like top 100) through query. finally we can export the query results to a excel file. less
Muslin
|
|
Muslin
From Ghana
Offline
|
Foundation EUFreelance.com Member
$80
in 3 days
$80 Milestone Requested
$80 Milestone Requested
over 1 year ago
hello Sir, Please check PM.
Hi, I can help you with this... Please reply to me.. I am a system admin starting freelancing now, looking to build a reputation here.. for the record, my last employment was with Red Hat and I am very good at what I d... more
Hi, I can help you with this... Please reply to me.. I am a system admin starting freelancing now, looking to build a reputation here.. for the record, my last employment was with Red Hat and I am very good at what I do, I just need a chance...
I can create a perl script to extract details and produce ouput as an excel file. less
I would start by gathering the csv importing to a mysql table. Set this process as a cronjob. Cron would have a process to rename the current table then pull the information for today when ran and import that into a ne... more
I would start by gathering the csv importing to a mysql table. Set this process as a cronjob. Cron would have a process to rename the current table then pull the information for today when ran and import that into a new table. Then to export the differences and gainers and losers as an xls file the server would need to have Spreadsheet_Excel_Writer which can easily be installed from root or normally thru a control panel as long as the host are not blocking to create the xls file with 3 sheets (Newly Added, Gainers, Loosers). Therefore preferably the servers should be linux. less
alexcarbor
|
|
alexcarbor
From United States
Offline
|
$250
in 15 days
$50 Milestone Requested
$50 Milestone Requested
over 1 year ago
I have a lot of experience in this. ask for details.
rizwanfpak
|
|
rizwanfpak
From Pakistan
Offline
|
General Freelancer Orientation (85%, 95th percentile)
Foundation EUFreelance.com Member
$150
in 5 days
over 1 year ago
Hi, Please see your PMB for more details. Thanks
I am an expert PHP / SQL developer with more than 6 years commercial experience developing complex applications for corporate and government clients.
I could easily complete this script for you. I have a number of ... more
I am an expert PHP / SQL developer with more than 6 years commercial experience developing complex applications for corporate and government clients.
I could easily complete this script for you. I have a number of scripts that already do this work for different data sets so I would have no problems with this work.
For more info and examples of our work please search online for openDYNAMIX. less
Faqhi
|
|
Faqhi
From Pakistan
Offline
|
Foundation EUFreelance.com Member
$200
in 7 days
$80 Milestone Requested
$80 Milestone Requested
over 1 year ago
Contact with me to get accurate solution 100% according to your requirements within deadline.
I am a software engineer dedicated to automation.Let me know if you still have the requirement ready
MilagroStudio
|
|
MilagroStudio
From Canada
Offline
|
$250
in 5 days
$125 Milestone Requested
$125 Milestone Requested
over 1 year ago
Good Morning,
I am running a small company located in Canada with 8 developers working full time in Montreal.
We have a large experience developing online applications in many languages such as: PHP, XHTML, MYSQL, OR... more
Good Morning,
I am running a small company located in Canada with 8 developers working full time in Montreal.
We have a large experience developing online applications in many languages such as: PHP, XHTML, MYSQL, ORACLE, JavaScript, AJAX, CSS, JQuery, JavaScript, framework, CMS, C ++, JAVA. We also have a solid experience with Drupal, because, over the last 3 years we were involved in 3 projects using Drupal as CSM.
If you are looking to improve your website or create a new website you can contact me, you will get high quality and price. less
Please check PMB. Thanks.
I have experience for this kind of Project. Please see PMB for details. Thank you
Please check PMB, Thanks.
niltonbicalho
|
|
niltonbicalho
From Brazil
Offline
|
$50
in 3 days
$10 Milestone Requested
$10 Milestone Requested
over 1 year ago
I have extensive experience with database maintenance, handling, export and import.
billfan88
|
|
billfan88
From China
Offline
|
Foundation Freelancer.co.uk Member
$180
in 5 days
over 1 year ago
hi
I have ten years experience on MS Access.
I have done serven Access DB for client in 2009
also I have five years in MS Access 2003 and Access 2007
I am sure I can do it well.
Let us start now.
look f... more
hi
I have ten years experience on MS Access.
I have done serven Access DB for client in 2009
also I have five years in MS Access 2003 and Access 2007
I am sure I can do it well.
Let us start now.
look forward to your reply.
Btw: I were MVP about Mircosoft Access in 2003
Zhi Zhang
less
makeuglobal
|
makeuglobal
From India
Offline
|
HTML Level 1 (70%, 60th percentile)
General Freelancer Orientation (90%, 98th percentile)
$50
in 2 days
over 1 year ago
Please check inbox for details.
MidasInfotouch
|
MidasInfotouch
From India
Offline
|
$30
in 2 days
$30 Milestone Requested
$30 Milestone Requested
over 1 year ago
I will do it award it to me
Seems like an easy job to do
Its an easy job by perl and mysql,check PMB!
biddyweb
|
|
biddyweb
From Nigeria
Gold Member
Offline
|
$200
in 0 days
$20 Milestone Requested
$20 Milestone Requested
over 1 year ago
Send a sample of the csv and project full description and lets get started.
everjoseph
|
|
everjoseph
From India
Offline
|
Foundation LimeExchange Member
$30
in 1 day
over 1 year ago
Hi,
Kindly check your PMB.
Thanks & Regards
Joseph
baleon
|
|
baleon
From Poland
Offline
|
General Freelancer Orientation (75%, 81st percentile)
$250
in 10 days
$75 Milestone Requested
$75 Milestone Requested
over 1 year ago
PHP/MySQL programmer. I could issue an invoice.
ictforever
|
|
ictforever
From United Kingdom
Offline
|
Foundation EUFreelance.com Member
$155
in 1 day
over 1 year ago
I am absolutely happy to deliver you the solution asap.
Please do not hesitate to contact me.
Hi,
Please check PM.
Regards,
Rishi