Closed

Extract .MYD/.MYI/.FRM database(s) and convert to (Magneto-importable) .CSV - repost

This project was awarded to ijerkov for £100 GBP.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
£20-£250 GBP
Total Bids
22
Project Description

I have a browser-accessible database of auto parts, which runs on Windows, using .jsp files to access the database. I want to import it into an ecommerce store. This requires extraction and conversion.

AFAIK, the DVD program, which install the database, installs a MySQL database and server into Windows, which lets the user search the database.

I installed it.

I was able to access the database using the installed software.
I was then able to access the installed databases using MySQL tools.
I was even able to export the .MYD/.MYI/.FRM files to a fat 3GB+ MySQL file.

This was unusable.

A subsequent partial .CSV conversion yielded a fat file of commands and table headings and other junk.

IMPORTANT NOTE 1: there are about 20,000 products in this DVD and thus a HUGE amount of data. The file names are in Italian and so is the language default. There IS an English-language version in there, as that's what shows up when I installed it.

IMPORTANT NOTE 2: This DVD is part-protected, I think. The product images files can't be opened directly in Windows. When other coders have downloaded the files from the DVD (that I uploaded for them), they couldn't run the software. When I was fiddling with the software myself, using MySQL tools, I eventually was unable to run it.

Anyway, I need an expert to:

a) Extract the data
b) Convert it to .csv file(s) [that can be imported into Magento, at some future point.]

- You can download the DVD files if you want (like the main '[url removed, login to view]' file) but this time I can post a burned copy of the DVD to you, as well.

See the screenshot of some of the files, below.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online