Extract .MYD/.MYI/.FRM database(s) and convert to (Magneto-importable) .CSV - repost
£20-250 GBP
Completato
Pubblicato più di 11 anni fa
£20-250 GBP
Pagato al completamento
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 '[login to view URL]' 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.
If you send me a DVD image (iso) I can make a custom Java program that will connect to Mysql database from DVD, fetch data and write it to csv file(s) in Magento friendly format so you can import it later. Images are probably saved also in database so you cannot see them in windows explorer. My program will extract images from database and save them into separate files that you can open and view in Windows explorer.
I am Java programmer and I work daily with mysql and jsp. I don't work often on freelancer, only when some project draw my attention and this task I find very interesting.
Please note that I will not accept the project or request any milestones before I see the DVD and make sure that I can do it. I would not like to waste your time and money.
If you have any questions or want to discuss something, please do not hesitate to contact me.
Best regards.
£100 GBP in 7 giorni
0,0 (0 valutazioni)
2,5
2,5
19 freelance hanno fatto un'offerta media di £183 GBP
Here are Magento Experts , please check Our Latest Magento work In PMB For Our Experience and skills Regarding Magento proejcts and Let me start your work , Thanks
I have been working with MySQL since 2000 and databases in general since 1987. A fair amount of my background is in POS and Inventory Control. Please see my profile and the PMB for more.