Closed

Keywords database

I have an excel file where I store a keywords (one word or a multiple words –sentence), this file have 11 columns

This file have to be imported and stored inside a database and I have to update it every day with a CSV file with 5 columns.

Requetes Clics Impressions CTR Position # Type Region ST2 ST3 ST4

When I import the new file with a name like [url removed, login to view] where yyyy yearn, mm mounth, dd date,T (time) , hh hour, mm minutes, ss seconds

I have to look if the keywords is already exist,

- If the keyword is not here, I create a new line with that keyword and store all the related information “Clicks, Imression, CTR & Position”

- If the keywords is already here I have also to store the related information “Clicks, Imression, CTR & Position”

Evry keywords can have inside it some specific word like a region, city, special activity or type

I have a column where I have a list of types of keywords and have to be updated

I have a column where I have a list of regions and cities will be updated

I have a column where I have a list of ST2 and cities will be updated

I have a column where I have a list of ST3 and cities will be updated

Now I have stored all my list of keywords on a daily basis, with the 4 main informatins

1 - I will look inside my sentence, if it have one word from my column “Type”, if it have it I will associate the keyword or sentence with that type

2 – I will look inside my sentence, if it have one word from my column “Region”, if it have it I will associate the keyword or sentence with that “Region” but here a region can be writed in different type like “fes, fès, fés or fez, فاس » so we have to deal with that and also if in the keyword have 2 regions inside it like country maroc morocco and a city name like fes we have to consider the name of a city as first choice

3 – I will see if my keyword – sentence have a word from my column ST2, I will associate it

4 – I will see if my keyword – sentence have a word from my column ST3, I will associate it

5 – I will see if my keyword – sentence have a word from my column ST4, I will associate it

Skills: .NET, Database Development, Database Programming, Java

See more: ترجمة الجملة i want to extend my stay here for 3 months, moodle external database email exist, special editor remove line feed, perl print specific word line, create front end excel database, mysql import sql database dont exist, countdown clock specific time zone date php, extract keywords database php, phplist database error 1146 query table doesnt exist, create sql database archives records weekly basis, php special characters database, database exist php, related keywords database, save database special characters, exist database

About the Employer:
( 0 reviews ) Casablanca, Morocco

Project ID: #15646300

3 freelancers are bidding on average $34 for this job

arunsankar555

A proposal has not yet been provided

$55 USD in 3 days
(10 Reviews)
3.8
Harshnkhunt

Hire me Relevant Skills and Experience Never give up for any work

$25 USD in 1 day
(0 Reviews)
0.0
basit39

Hi There, I have reviewed your requirements & understood them. I can develop your preconceived project. Im actually a web developer and designer and work with a team. Relevant Skills and Experience developer Stay t More

$21 USD in 5 days
(0 Reviews)
2.4