Completed

Automatic the Website Upload

Objective is to convert an excel file in one format (input) to another standardized format (output). Format here refers to the way data table is organized in the excel file. The input format can vary as data is received from various sources. The output format is the standard required.

See an example below:

Data is received from a supplier in the input format. See [url removed, login to view] and [url removed, login to view] files.

Data is then migrated to the output format. See [url removed, login to view]

Note, the input format can vary because it comes from different sources. But the output format is always organized the same way.

What is required from the coder:

Write a program that coverts any input format to the standardized output format. This can be done by matching which columns in the input file will match which columns in the output.

Notes on the columns in the output file:

Item code, Product name, Brand, Price and Quantity - must always come from input file

Age is sometimes available in the input file

Categories are usually not available in the input file

Description is sometimes available in the input file

Image URLs must be created. They do not come from the input file.

Three important issues to note in the format conversion:

1. The data must be kept in a standardized format.

- Product names must start with a capital letter, but not all capital.

- Age range must be in the format presented.

- There should be no extra spaces

etc.

2. Some data will need to be converted using a logic.

- Age range: We have standard age ranges of 0-2, 2-4, 4-6, 6-8, 8-12, 12+years. If for example, manufacturer provided age range is 5-10 years, then it must include the toy in three age ranges, which is 4-6, 6-8, 8-12.

- Image URLs must be standardized and must be in the same number as the number of images available.

3. Some information may be missing in the input file which is required in the output file. In this case, we are also interested in creating an automated search off the internet sites where this product is listed, which is common called web scraping.

We are looking for a tool that coverts the input format to the output format. And another tool that does web scraping for the information that is missing. The tools should be quick and easy to use.

Skills: Excel, PHP, Software Architecture, Visual Basic, Web Scraping

See more: winscp automatic upload, automatic ftp upload, auto ftp manager, file transfer automation, automatic ftp upload software, automatic ftp upload filezilla, fling ftp, automate ftp file transfer filezilla, convert existing website upload wordpress, convert pdf file excel format, convert text file excel format, convert standard website ajax website, upload video convert flv website, website upload convert video free, website upload mp3 convert m4r, convert standard template website baker templates, convert word file excel format, convert dat file excel format, website upload videos, create website upload video

About the Employer:
( 2 reviews ) Dubai, United Arab Emirates

Project ID: #16539430

Awarded to:

katilinas

Dear Employer, I'm ready to work on input format to the output format tool. Relevant Skills Excel, VBA Milestones 100 USD - input format to the output format tool (without webscraping) I have samples of More

$100 USD in 6 days
(111 Reviews)
6.3

9 freelancers are bidding on average $207 for this job

Gates777

Hello? I am very interesting in your project. I checked your details very carefully and understood all. I can do this in a short time with high quality. I am expert in php, c#, python, web automation, simulation, a More

$155 USD in 3 days
(77 Reviews)
6.5
abdulrahman91kh

Hello sir, I am Abdulrahman a highly talented Developer with more than 7 years experience looking forward to be hired by you. I have read your project description. I totally understand your requirements. I More

$300 USD in 20 days
(49 Reviews)
5.7
vmadhavan15

I am not random bidder. I have 14+ years of exp with various project exposure. Please ping me if you are intersted with my proposal and share more info. Thank you

$250 USD in 5 days
(17 Reviews)
4.2
microservices

Hi, Please consider us for this project. As we have successfully finished many projects for my client at here and [login to view URL] have 6 years of experience in software development , Web development and maintenance of bus More

$200 USD in 3 days
(12 Reviews)
3.5
nitinsaluja98

Hi, Hope you are doing great!! Thanks for reading my proposal. Please read it thoroughly. I am Nitin from Trigvent. I am a MEAN stack developer having rich experience with PHP and their extensions. I have work More

$300 USD in 7 days
(6 Reviews)
3.2
kkc264043kkc

I can convert into your required standard format. these are set of skills related to web scraping and crawling. Have done scraping in Nodejs, CasperJS Phantomjs, python Scrapy framework. Have done testing and automat More

$222 USD in 5 days
(6 Reviews)
3.2
jagdish6077

A proposal has not yet been provided

$111 USD in 2 days
(0 Reviews)
0.0
$222 USD in 5 days
(0 Reviews)
0.0