176985602337900

Find freelancers. Lose those costly delays.

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

or, Register with Elance »

Download Amazon Browse Nodes
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

Job awarded.

May 6, 2013

Bidding period extended.

May 6, 2013

Job description changed. New Version|Previous Version

May 6, 2013
Close

Job Description

  |  Change History >>

Updated

Simple job here. Create an app (desktop, or webbased- whatever you prefer), that will allow me to upload a large database csv file (can be anywhere around, 20 Mb or larger in size). It will contain many columns (around 20-25 or so). Only two of the columns will be important to you/used in this app: ASINNo BrowseNode This app will then use the value found in ASINNo column (this will be an ASIN number used on Amazon) and using that, find the applicable Amazon.co.jp browse node (full text equivalent NOT the numerical value). In some cases, an item will have more than one browse node. In those cases, of course we do need to get all those browse nodes, and populate them into the BrowseNode field, separating each browse node, with the same separator used in the original database, for instances where one field has multiple values. This will run at the fastest possible speeds (ideally, at least 60,000-70,000 ASINs per hour) until done. In order to ensure efficiency and speed, the system will search only items (ASINs) where the BrowseNode field is blank. In some cases, my uploaded file will already have a value in BrowseNode. No need to fetch those again. When done, this file will be added to a database (containing all the same fields as in the imported original file- but now with all the BrowseNodes populated). As I upload and add more files, each file that's done, will again be added to the "master" database (it will be very large in size- approx. 1 Gb, if not larger... thus, I suspect a .bin database may be best (old technology but so much faster than sql databases). Finally, when I'm done there will be one more function: Export unique words: This will now export a csv/text file, of every unique word, found in the BrowseNode field in the master database. However, it will show the word, highlighted or in bold, but with its original position. For example: random/test/random2/<b>WORD</b>/random (I can't use bold here on eLance). So this output file, will now be a long list of every unique word (never showing the same word twice). And, there will be an Import Translations option here. After I will have each word in question translated (as our original data will be in Japanese), I will then upload the translated file (column 2 will have the English equivalent of each word) and find every instance of that word in the main database, and replace it with the English translation. Finally... a "Master Export" feature will allow me to export the entire database, in the exact same format/style/encoding, etc, as the original input files I entered into the app. This export feature will allow me to break up the export file into several smaller files (so for example say- 10 Mb limit per file... until the entire database is exported (so each file would have the original headers, and then just continue where the last file finished off) and we're done. In short... upload files where one field is usually blank... get data for that field... once done, and all the uploaded files are now one big complete database... we export a file showing each unique word found in the BrowseNode field of this big database... and later I will import a 2 column file- just showing that original unique word, and it's English transation, and now that English translation will replace every instance of that word in the BrowseNode field (retaining all other words, positions, etc- just replacing the exact instance of that Japanese word, with an English one). Finally, when done... export the entire thing, and the app has lived a full, complete, happy life. ;) Anyone with entry level database skills, and some experience with amazon API/MWS, should be able to deliver this in a few days.

Simple job here. Create an app (desktop, or webbased- whatever you prefer), that will allow me to upload a large database csv file (can be anywhere around, 20 Mb or larger in size). It will contain many columns (around 20-25 or so). Only two of the columns will be important to you/used in this app: ASINNo BrowseNode This app will then use the value found in ASINNo column (this will be an ASIN number used on Amazon) and using that, find the applicable Amazon.co.jp browse node (full text equivalent NOT the numerical value). In some cases, an item will have more than one browse node. In those cases, of course we do need to get all those browse nodes, and populate them into the BrowseNode field, separating each browse node, with the same separator used in the original database, for instances where one field has multiple values. **EDITED** This will run at the fastest possible speeds (ideally, at least 60,000-70,000 ASINs per hour) until done. Some fields will have numerical val...

May 6, 2013

Close
  • Posted: Wed, May 01, 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: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

Simple job here.

Create an app (desktop, or webbased- whatever you prefer), that will allow me to upload a large database csv file (can be anywhere around, 20 Mb or larger in size). It will contain many columns (around 20-25 or so). Only two of the columns will be important to you/used in this app:

ASINNo
BrowseNode

This app will then use the value found in ASINNo column (this will be an ASIN number used on Amazon) and using that, find the applicable Amazon.co.jp browse node (full text equivalent NOT the numerical value).

In some cases, an item will have more than one browse node. In those cases, of course we do need to get all those browse nodes, and populate them into the BrowseNode field, separating each browse node, with the same separator used in the original database, for instances where one field has multiple values.

**EDITED** This will run at the fastest possible speeds (ideally, at least 60,000-70,000 ASINs per hour) until done. Some fields will have numerical val...

Sign in or Register to see more

Job ID: 40990540
Proposals
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

 Ukraine  |  
Programmer with an experience of over 15 years. Freelancer UkrGuru from GURU.COM (> 50 successful projects). ASP.NET C# SQL SERVER WEB/DATABASE...
5
  |  
 5.0   |  $15,103 Earnings   |  4 Jobs
Bid ID: 41100383  |  Submitted: May 4, 2013 01:33 ET 
Proposal SEALED

 China  |  
Winner
php, java, html5, node.js, iPhone, Android, Titanium, Corona, Phonegap
7
  |  
 4.6   |  Private   |  21 Jobs   |  1 verified credential(s)
Bid ID: 41006855  |  Submitted: May 1, 2013 22:00 ET 
Delivery
Within 1 week
$438.36
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 »