JOIN .csv FILES (Following rules)
Ce projet a été décerné à schoudhary1553 pour €34 EUR.
Obtenez des devis gratuits pour des projets similairesBudget
€8 - €30 EURNombre total d'offres
14Description 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.
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
Vous cherchez du travail ?
Travaillez sur des projets comme celui-ci et gagnez de l'argent en restant chez vous !
Inscrivez-vous maintenant- Forbes
- The New York Times
- Time
- Wall Street Journal
- Times Online