Fermé

Merge tab delimited files and upload to mysql db (magento)

Need someone to develop a php or executable that:

1) merges content from two downloadable tab-delimited text files

a) one file is a large set of all product details

b) second file is a set of price points and stock data for a allowable set of items

c) items in (b) but not found in (a) should not be in the combined file

2) reduces the combined file based on a set of rules that can be customizable (filter for a set of categories and subcategory values in two of the columns)

3) transforms the combined file into a format that can be uploaded by magento's csv-based dataflow system

a) schema will involve remapping columns from the combined file from (2) for magento's format

4) one field in the csv will require mapping category values to numeric ID values in a third file (defines the numeric ID value of the category name)

a) I am flexible in how this can be delivered. My thought was a csv/txt/xls file with three columns (cat, subcat, ID). Maybe this can be merged with requirement 2

----------------

- Experience with Magento is a plus but not a requirement.

- Project should be flexible to acomodate constant changes to category/subcategories mix.

- PHP or executable is required since this will need to run as a cron several times a day.

- Extra budget if you can code to directly upload to the mysql database on my server. The magento schema for products is dispersed across multiple tables. Magento database-experience will be required.

Compétences : Traitement de Données, Excel, Visual Basic

Voir plus : mysql db, how to develop the product, tabs products magento, files uploadhtml, magento dataflow mapper rules, upload products magento mysql, merging delimited files, merge multiple tab delimited files, magento mysql schema, magento multiproducts, magento csv prices comma, ecell merge tabs, upload tab delimited text file mysql, read tab delimited file mysql, csv mysql tab, magento product reviews tab, php upload tab delimited file, magento multi tab, merge tab files, tab delimited file mysql, type file magento upload, php upload tab delimited file mysql, excel merge tab delimted, stock quote text delimited, magento datafeedfile

Concernant l'employeur :
( 1 commentaire ) Rowlett, United States

N° du projet : #331475

24 freelance font une offre moyenne de $131 pour ce travail

consus

Hello Sir Please Check PMB for bid detail Thanks

220 $ USD en 5 jours
(19 Commentaires)
6.7
yousefla

More info was sent in the PM. Best Regards, Yousef

195 $ USD en 3 jours
(27 Commentaires)
5.8
gangabass

I can do this job for you. See PM for details.

100 $ USD en 2 jours
(69 Commentaires)
5.4
mohanlg

Hi, I will do the job, and combined the data in the requires files (csv, excel etc) Thanks sunny

90 $ USD en 2 jours
(15 Commentaires)
4.1
SSYES

Hi,Pls refer PM

100 $ USD en 5 jours
(1 Commentaire)
2.0
zadr50

Let's start. Thanks/TalagaSoft

200 $ USD en 10 jours
(0 Commentaires)
0.0
pandey1911

Regards Pandey1911

30 $ USD en 2 jours
(0 Commentaires)
0.0
sharmahits

Hi, I have extensive experience experience in reviewing technical, business or other similar work. Will appreciate if you can offer this work to me. I am a dba working with a mnc, recently left the job. Regards, Plus

30 $ USD en 2 jours
(0 Commentaires)
0.0
ranganathp

Can help... check my reviews... costs more...

250 $ USD en 15 jours
(0 Commentaires)
0.0
MrMaro

Please see clarification board.

125 $ USD en 15 jours
(0 Commentaires)
0.0
frq50

i have fme software to do this. [url removed, login to view]

250 $ USD en 5 jours
(0 Commentaires)
0.0
hzsolt

Please check PM. Thanks

100 $ USD en 2 jours
(1 Commentaire)
3.4
samirram007

I want to show u a demo first. just to make sure what acctually u want..Am i already ready with that result. Samir Ram

50 $ USD en 4 jours
(0 Commentaires)
0.0
DataFeedFile

I am an American programmer and I am a data feed / product feed file expert. I am the founder of [url removed, login to view] and PriceComparison.com. I am very familiar with all aspects of Data feed / product feed generation a Plus

200 $ USD en 2 jours
(0 Commentaires)
0.0
gkra

I can do this for you. I hav been working with csv files, So this project may be done with in specified period.

120 $ USD en 5 jours
(0 Commentaires)
0.0
avanis

I have done several similar projects. I will be able to complete this project in 3 days or less once I get all the details and relevant files.

200 $ USD en 3 jours
(0 Commentaires)
0.0
philnelson07

Hi, I am a database expert, I work frequently with SQL, CSV Tab-delimited, etc. manipulating databases and migrating data. I have done jobs similar to this before, and I can complete this work in 2 days. If yo Plus

75 $ USD en 2 jours
(0 Commentaires)
0.0
maruti1001

Hi, I am interested. Thanks

100 $ USD en 2 jours
(0 Commentaires)
0.0
innuendoits

Please the PMB Thank you

250 $ USD en 5 jours
(0 Commentaires)
0.0
RFORD29

I have designed many solutions for similar conversions to the one you describe using MS Access or MS Excel. I am new to this site and am looking for experience so I have bid low, this does not mean I am not experienced Plus

60 $ USD en 14 jours
(0 Commentaires)
0.0