En cours

JOIN .csv FILES (Following rules)

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.

Compétences : Excel

Voir plus : multiple html files csv, merge xml files csv, script convert text files csv, convert turbolister files csv, perl csv files csv, convert turbo lister files csv format, tranferxls files csv, generate html files csv, convert text files csv files using vbnet, need multiple create csv files csv file, multiple csv files csv file using perl, oscommerce files left join fix, convert txt files csv files, script convert html files csv, files csv report chart

Concernant l'employeur :
( 16 commentaires ) Barcelona, Spain

N° du projet : #13422428

Décerné à :

schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of ex Plus

34 € EUR en 1 jour
(129 Commentaires)
6.3

13 freelance font une offre moyenne de €27 pour ce travail

Beacon09

Hi, Ready to start. I can create custom scripts to join CSVs as required. Could you please send the link again? It is disabled. I am detail oriented and I strive to maintain accuracy and high quality in my work. Loo Plus

39 € EUR en 1 jour
(41 Commentaires)
6.0
faheems189

Hi There, I have read project details carefully and I will add in [url removed, login to view] file from all 12 .csv files according to provided description, kindly message me so I will be able to complete sample to show you or I am rea Plus

30 € EUR en 1 jour
(76 Commentaires)
5.8
Attractionnet

Hello. I'm a programmer, I create custom programs for any purpose. I will create a program which will read the input files and create the new files according to the specifications you want. I will do with working with Plus

55 € EUR en 1 jour
(53 Commentaires)
5.1
sangwanpankajs

hello sir i understand what needs to be done ,,,, i can do this work in 2-3 hours from now i am an expert in excel and have completed many excel projects in past with excellent ratings so please msg me to d Plus

26 € EUR en 0 jours
(52 Commentaires)
4.9
gangabass

I can merge all your CSV files in couple of hours and I can offer you best price here. You have pretty good project description so all I need to start is milestone payment from you. You'll release it only after you Plus

30 € EUR en 0 jours
(54 Commentaires)
5.1
rocph

EXPERIENCED WITH THIS PROJECT. I am Certified Professional at award winning digital marketing startup company in the Philippines called ROC.PH. I am available and can start immediately.

23 € EUR en 1 jour
(4 Commentaires)
4.1
LancerBSL

Hello I am Asaduzzaman Apu I see your project and i do it as your acceptation.I have 3 years experience to work in a any kind data process Web Scraping, Web Search, Excel,Affiliate Marketing, Email Marketing, Internet Plus

30 € EUR en 1 jour
(18 Commentaires)
3.9
rakshitdadhich

Greetings! My Name is Ram dadhich and I am an expert in Microsoft excel/ Data entry. I would love to have the opportunity to discuss your project with you. I feel I am best fit to complete your project. I have 10 y Plus

19 € EUR en 1 jour
(2 Commentaires)
1.2
engrtan

I would like to work on your project. I believe I can complete in a few hours, depending on the number of rows in each file. I would just have to prepare a script to run through each row for each file, to determine t Plus

30 € EUR en 1 jour
(1 Commentaire)
0.8
MaWareAndTech

Hello sir/madam I've read your ad about managing CSV in excel. I have checked your data. I can work for you and deliver you in some hours or more. Hope you hire me!

12 € EUR en 1 jour
(0 Commentaires)
0.0
sayadnabin

I did excel works befor...and as per rules... and the major thik is I am 24/7 active.. so buyer can communities with me any time

19 € EUR en 2 jours
(0 Commentaires)
0.0
ryanmykell

Hi Client, Good Day! I am Mykell Lirio. I think I can help you with this project as I know how to consolidate your CSV files. Here's what I'm going to do: 1. Import your files sequentially as stated in your job Plus

8 € EUR en 1 jour
(0 Commentaires)
0.0
uxamashahid

A proposal has not yet been provided

24 € EUR en 3 jours
(0 Commentaires)
0.0