176985602337900

Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Database Schema Design and Data Importer Application
Sign in to Add to Watch List

IT & Programming > Database Development

View Change History

The client has made the following changes to the job.

Description
Date
Close

Job Description

  |  Change History >>

Updated

Close
  • Posted: Wed, Feb 13, 2013
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:
    Anywhere

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Not Sure
  • Fixed Price Job
  • Elance Escrow Protection
  • U.S. freelancers must have W9
Sign in to view client's details

The goal of this project is to import a large number of XML & CSV documents and associated image files into a database in an automated manner. The project scope is to develop a database schema appropriate for the type and volume of data being entered, and then developing an importer tool to ingest the files into the database.

DTDs are available for the XML documents.

Here is a rough outline of how the importer should work:

1. Unpack a zip or tar file (provided)
2. Traverse subdirectories recursively
3. Unzip internal zip files within subdirectory
4. Import XML document
5. Import TIFF images (if any)
6. Fetch an ID from the XML record
7. Make "curl" or other mechanized HTTP request to fetch additional zip file from web.
8. If additional file exists, download zip
9. Unpack zip file
10. Import CSV files
11. Import PDF files (if any)
12. Commit information/record to database

Project requirements:

• Recommendation of DB type to use (SQL vs. NoSQL), CouchDB preferred if you cons...

Sign in or Register to see more

Desired Skills
Ruby on Rails, XML, Ruby, SQL, NoSQL
Job ID: 37858275
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Sigma Infosolutions Ltd      
One or more team members at  are verified.  Learn More
 India  |  
Sigma Infosolutions is Certified Partner of Pentaho, Magento, Openbravo and Microsoft. We operate from Irvine, CA, Cleveland & Bangalore, India. We...
10
  |  
 4.8   |  $105,520 Earnings   |  40 Jobs
Bid ID: 38374716  |  Submitted: Feb 27, 2013 04:20 ET 
Proposal SEALED

Diana B., Devmen      
Diana B.'s identity has been verified.  Learn More
 Russia  |  
INVITED
We are providing a full service for development of web and mobile applications including design, server setup and all steps in between. We do not...
3
  |  
 2.2   |  $2 Earnings   |  1 Jobs   |  1 verified credential(s)
Bid ID: 37945369  |  Submitted: Feb 16, 2013 04:27 ET 
Proposal SEALED

 United States  |  
I am a graduate student at Stanford university. I have more than 10 years of experience in web, mobile and database development. However, I believe...
1
  |  
 0.0   |  Private   |  0 Jobs   |  1 verified credential(s)
Bid ID: 37935398  |  Submitted: Feb 15, 2013 18:58 ET 
Proposal SEALED

 United States
INVITED
I am an experienced backend drupal developer (php developer, 2+ years) and rails developer (1+ year). Though not a front end developer I have a lot...
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37932099  |  Submitted: Feb 15, 2013 16:09 ET 
Proposal SEALED

 China  |  
HZCW Tec. Co., Ltd. was founded in 2014 by a group of young people full of ideals and enthusiasm and focus on mobile Internet product R&D. Based...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37920207  |  Submitted: Feb 15, 2013 10:04 ET 
Proposal SEALED

 Netherlands
INVITED
Heroes in websites, web applications and mobile applications. Tailored to clients. The project management is done from our head quarters in the...
3
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37903556  |  Submitted: Feb 14, 2013 23:45 ET 
Proposal SEALED

 Singapore  |  
INVITED
I'm a dedicated programmer who offer quality service with reasonable budget.
1
  |  
 0.0   |  $0 Earnings   |  0 Jobs
Bid ID: 37900778  |  Submitted: Feb 14, 2013 21:11 ET 
Proposal SEALED

Ivan B.      
Ivan B.'s identity has been verified.  Learn More
 Serbia  |  
INVITED
Software engineer. Ruby on Rails, TDD, BDD, HTML/CSS/Javascript, databases, scraping, crawling.
4
  |  
 5.0   |  Private   |  7 Jobs
Bid ID: 37898669  |  Submitted: Feb 14, 2013 18:56 ET 
Proposal SEALED

Miklós Kalózi      
Miklós Kalózi's identity has been verified.  Learn More
 Serbia  |  
"We can not solve our problems with the same level of thinking that created them."
8
  |  
 4.9   |  Private   |  34 Jobs
Bid ID: 37897287  |  Submitted: Feb 14, 2013 17:45 ET 
Proposal SEALED

 Romania  |  
INVITED
Zepto Solutions is a web development and design company located in Iasi, Romania . We are a dedicated team of web professionals, designers and...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37893035  |  Submitted: Feb 14, 2013 14:57 ET 
Proposal SEALED

 Tunisia  |  
- SQL Server Administration - SSIS, SSAS, SSRS and DTS. - Pentaho BI ( Data Integration, Reporting and Analysis) - Talend components...
3
  |  
 0.0   |  Private   |  3 Jobs
Bid ID: 37890491  |  Submitted: Feb 14, 2013 13:37 ET 
Proposal SEALED

 India  |  
I have been developing rails application since last 2 and half year.I have developed business requirements into working application. My approach...
2
  |  
 0.0   |  Private   |  0 Jobs
Bid ID: 37887676  |  Submitted: Feb 14, 2013 12:18 ET 
Proposal SEALED

 United States  |  
IDS has been developing focused, web based applications since 1994. Our forte is rapid application development. Timelines run days, not weeks or...
9
  |  
 5.0   |  $48,263 Earnings   |  5 Jobs
Bid ID: 37886967  |  Submitted: Feb 14, 2013 11:58 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »