Fermé

JOIN .csv FILES (Following rules)

Ce projet a été décerné à schoudhary1553 pour €34 EUR.

Obtenez des devis gratuits pour des projets similaires
Budget
€8 - €30 EUR
Nombre total d'offres
14
Description du projet

Create a [url removed, login to view] file uniting the following files.

FILES TO UNITE:

01 - TALLO - [url removed, login to view]

02 - MASNOU - [url removed, login to view]

03 - OPENFOOD - [url removed, login to view]

04 - AECOC - [url removed, login to view]

05 - CODROPER - [url removed, login to view]

06 - MERCADONA - [url removed, login to view]

07 - PHARMA - [url removed, login to view]

08 - CONDIS - [url removed, login to view]

09 - CARREFOUR - [url removed, login to view]

10 - DESPENSA - [url removed, login to view]

11 - ALCAMPO - [url removed, login to view]

12 - VINATERIA - [url removed, login to view]

Download from: [url removed, login to view] (.zip file / 16Mb)

IMPORTING ORDER.

When creating the [url removed, login to view] follow this importing order.

- First, import file 01 - TALLO - [url removed, login to view]

- Second, import file 02 - MASNOU - [url removed, login to view]

- Thirdm import file 03 - OPENFOOD - [url removed, login to view]

...

- Last, import file 12 - VINATERIA - [url removed, login to view]

IMPORTING RULES:

The files should be united by EAN

The EAN will be like and UNIQUE ID.

An EAN will appear only in one row --> NO repeated EANS in different rows.

HOW TO PROCEED: (VERY IMPORTANT)

Before importing the row you have to check if the EAN exists in [url removed, login to view]

- If EAN do not exist --> Create the NEW row with the values of the columns.

- If EAN exist --> Update Values OVERWRITE EXISTING values. (We substitute old values for new ones if there is text in the cell)

If the value of the cell is NILL OR NULL OR "" OR VOID or FALSE --> We do not update that specific value, we do NOT OVERWRITE

All files have these columns.

A=EAN

B=NAME

C=BRAND

D=IMG_LARGE

E=IMG_SMALL

F=SIZE

G=CATEGORY

H=DESC

I=COMPANY

EAN Column: All of them have a value.

Rest of columns: some have values, some not.

Décerné à:
Compétences requises

Vous cherchez à gagner de l'argent ?

  • Fixez votre budget et les délais
  • Décrivez votre offre
  • Faites-vous payer pour votre travail

Embauchez des Freelancers qui ont aussi fait une offre sur ce projet

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