Write some Software

$30-250 USD

Completed

Posted

about 8 years ago

$30-250 USD

Paid on delivery

I need someone to write a short script for me. It can be PHP, Python, or Perl. I have a directory with about a thousand vcf files. I ultimately want that data to be inside a MySQL database table. I can handle importing a CSV file into the table, but I don't have time right now to convert the vcf files to a single CSV file. Here's the algorithm as I see it: 1. open CSV file 1.a . Write header row: "full-name","title", "loc1office","loc1street1","loc1street2","loc1city","loc1state","loc1zip","loc1phone", "loc2office","loc2street1","loc2street2","loc2city","loc2state","loc2zip","loc2phone", "email" NOTE: some contacts have two offices, some have only one. The CSV needs both if present in the VCF. If location 2 is not present in the VCF, make the location 2 fields empty. 2. read directory 3. for each VCF file in the directory a. read the vcf format b. write the data to a new row in the CSV file, in the appropriate columns 4. close the files, give a short status report (XYZ contacts added, 0 errors), and exit Feel free to use any libraries you want (like PHP's File_IMC), but I don't know jack about OOP and I don't have any of that stuff installed on my computer, so make that as easy as possible on me. I'm using Ubuntu 14.10.

Project ID: 9941112

About the project

38 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@waechtertroll

Hello, As I understand your project, you're looking for a script to parse any number of vCard files from a directory and collect that information into a .csv file. The .csv file must follow your specification, so you'll be able to automatically add all collected information to a SQL database. Your algorithm should work pefectly well. I would suggest using a simple, straightforward Python implementation for the task; just parsing the files linewise, storing found data into a simple container object and transforming the information to a string, with placeholders for missing data to keep the csv consistent. The only dependency that comes to my mind is something to treat command line arguments properly, but that won't require anything installed. If you're interested, feel free to contact me with any details I might have missed, and let me know which Python version (2 or 3) you want to target. Regards Hermann

$35 USD in 3 days

5.0

(2 reviews)

2.2

38 freelancers are bidding on average $108 USD for this job

@gangabass

This is pretty easy work for me! I can create such script in Perl in less than a days and I can offer you best price here. All I need to start is several sample files (for testing) and milestone payment from you. You'll release it after you check everything. Also I can create compiled version for Ubuntu (no need to install additional libraries). Thanks. Roman

$44 USD in 1 day

4.9

(879 reviews)

8.2

@rajdeepa555

Hello Sir, I have 6 years of experience in J2EE, php, python based technologies. Regarding front end technologies, I am proficient in html, java script, jquery. My recent java works are as follows - 1. Property extractor and search system - This project is developed in J2ee in which we need to extract properties from various property portals in India. The scraper work is done in Python. J2EE is used to provide back end system for searching [Lucene] and various database level operations. 2. Disease Gene Search Solution - This application is also built on J2ee which uses search capability of lucene to index more that 10 GB of data and provide efficient search system to users. Thanks & Regards Rajdeep Agrawal

$105 USD in 3 days

5.0

(86 reviews)

7.3

@sdgcode

Hi I can create Python script but for that you must install python on your comp. If you have question you can ask me. Regards

$277 USD in 2 days

5.0

(54 reviews)

6.7

@FernandoCanizo

Hello. If as you stated on your project, you know how to import CSV files, then you don't need to install anything on your computer. You can handle me all your VCF files and I'll provide you with a CSV file and/or a direct Mysql dump that you can import into your database. I also will give you the script so if you need later to run it, you'll have it around. Since you're on an Ubuntu machine, I can also provide you with step-by-step instructions to install stuff if you don't have it yet. Could you please attach me on a message here some sample VCF files so I can take a look at them? Are you sure only "two offices" is the maximum? What if a contact has three? O seven? Maybe it would be best to make a script that handles importation directly into database. I won't be hard for you to run it, but you'll need to provide some extra information. Do you manage yourself around Mysql? How do you intend to review collected information once you have it in your Mysql database? Anyway, I'd like to help you with your project and I believe my bid is ok if you don't have further requirements. Please send me some VCF files so I can check them. Thank you.

$280 USD in 5 days

5.0

(16 reviews)

6.3

@iticus

Hello, I have a lot of experience with Python and data processing. If you can send me a sample file (or the whole folder) I can run a test to see what we can come up with it. Best wishes, iticus

$100 USD in 1 day

5.0

(34 reviews)

6.0

@flashsaiful

Web scraping expert I use python language. My scripts works on windows, mac or linux, but linux is preferably. I can schedule scripts on server if it is required. I have more 100 finished projects (google scraping, facebook scraping, yellow pages, linkedinIn, amazon, webshops and other sites with lists of any items). I can scrape secured and protected sites, my crawlers can enter into login form, emulate ajax requests etc. If site block IP i can use proxy or TOR. I can try avoid captha on site in avtomatic or manual mode. I can export data into json, xml, csv (excel), or any database (mysql, mongodb, mssql, etc). I can develop web-interface for management running script (start, stop, etc), using PHP, HTML, JS.

$155 USD in 3 days

5.0

(21 reviews)

5.3

@flaproj

Can you share sample VCFs? Python 2.7 on Ubuntu should work just fine for the processing. I assume you're fine with that. Cheers

$45 USD in 2 days

4.9

(18 reviews)

5.4

@khannouman

Hello I can do this work for you in PHP I can satisfy you with my work and I assure you that your satisfaction is most prior attribute of the work I do. Hope you get back to me soon.

$50 USD in 3 days

5.0

(3 reviews)

3.6

@joeltl

Hi, I am interested in this project. Would you please pm me some sample vcf files? I am going to use perl to implement. May need to install 2 perl lib. One for writing csv. One for reading vcf file. Btw, can I use ssh to work on your Linux?

$120 USD in 2 days

5.0

(6 reviews)

3.8

@tarunsitlani

Hello i am very positive about your requirement and eager to discuss with you in detail. I have read your requirement and as i understand is you need the VCF files's data to be inserted in the mysql database. For that if you can provide me the VCF files i can provide you CSV file for that.. and a php script that will read that csv file and insert data in your database table. For this i will make an C#-Window based application which will be easier for me. and i will give this application to you also so if in future you need to read other files you can use the same application and script. I can also do this task in PHP if its mandatory. Please reply so we can discuss and i can provide you better solution. ** Payment will be based on milestones and we can discuss about the payment terms. Looking forward for a positive reply. Regard, Tarun

$111 USD in 2 days

5.0

(4 reviews)

3.1

@amsak

vcf files in mysql using perl to extract csv files and populate into mysql ...............................................................................................................................................................................................................................................................................................................................................................................................................................................................................................................

$55 USD in 14 days

4.3

(10 reviews)

3.8

@money800

Hello, I would simply use PHP. Your algo looks good, I would do it as is. Report status would be another file? My server is also on ubuntu 14. We have a lot in common. I would need all your files to work on my computer, then I would send you the script. Cheer!

$50 USD in 3 days

4.9

(8 reviews)

2.6

@hasanucak

hi. i can do your job only use php. i can use a few function in php , file read,string proccessing and mysqldb functions into data to db. not necessary oop. i think,i can finish your job 1-2 hours.

$55 USD in 3 days

5.0

(2 reviews)

2.3

@vw7400260vw

Hi, I have 3+ years of experience in developing complex Python applications. Based on the project description, I will be able to complete the task in 3 days. You don't need to assign the project to me right away. Please provide me the project details and I will come up with the script. If you are completely satisfied, then only assign the project to me.

$100 USD in 3 days

5.0

(2 reviews)

1.6

@cmouchel

Hello, I often write scripts to help me in my work (Process Engineer in industrial IT). Mostly in Python with Scrapy. I also write scripts at home to help me finding a new car on autoscoot24 for example or buy downloading and compiling flash video found over the web.... I'm a passionated and young guy. I really enjoy offer my skills to other :) at work or in my private life ! Hope we'll get in touch !

$66 USD in 5 days

0.0

(0 reviews)

0.0

@PunaneTellis

Hi! I would do it in python. I also need couple of these vcf files for testing. It probably won't take longer than couple of hours.

$166 USD in 3 days

0.0

(0 reviews)

0.0

@fwsoftware

I'm a programmer for ten years. I have done many scripts like the one you need. I use python for programming scripts in my server daily. I will use the open source library pyvcf to read the vcf files and test the script in my laptop with ubuntu 14.10. I hope we can work together.

$50 USD in 3 days

0.0

(0 reviews)

0.0

@akshayabhi

Hi, I am having 4 years of experience in Indian IT industry and working for Morgan Stanley Financial firm. I have developed many scripts for Morgan in PERL and Unix. For your requirement i will develop the PERL script which you can run on Ubuntu. Below is the plan will execute: 1. Communicate with you for exact requirements. 2. Analyze and prepare design document. 3. Once design is finalized, will start preparing code. 4. Do the Unit and integration testing for the developed code. 5. Deliver the code to you, if all looks good. If my proposal looks good, them please contact me on below mail id or cell number: Akshay Jain Mob: +918888853846

$35 USD in 3 days

0.0

(0 reviews)

0.0

@samuelhwilliams

Good evening. I do this manner of data manipulation on a daily basis in my role as a Python programmer, so I believe I am perfectly suited to turn this job around for your quickly. Following a short period of requirements elicitation and discussion I will begin work immediately. I work with SQL and Ubuntu again, every day, so have no concerns that I will be able to provide you fully functional solution with minimal hassle. Hope to hear from you.

$100 USD in 2 days