Import CSV

Import CSV

Closed - This job posting has been filled and work has been completed.

Job Description

IMPORT CSV

We need a component for joomla 2.5.6, Community builder 1.8.1. This component should be install and work with any joomla website (with same version of joomla).

We will provide you templates of how the component should look like.

We will test the component before to make the final payment.

We have a lot of csv files to import in adsmanager & community builder.
Each csv file contain contact details of different business of differents cities of different countries.

The name of csv files are : NAME-OF-CATEGORY_CITY.csv

The organisation of the folders are like this:
Country/category/NAME-OF-CATEGORY_CITY.csv

The csv file contain these columns in first line:
Category Business Name Full Address Address City State Postal Code Country Phone Fax Website Email Map Link Details Link

So we need to creat an advert adsmanager for each business. Each advert will need a CB user as publisher. So we will have to create firstly the CB user and then the advert adsmanager associated to this new CB user. We will have to control for doble. 1 CB user can have many different ads (i.e: Barclay bank has many agencies in Spain.)

We need to import these info in Adsmanager:
name=Business Name
ad_headline= Businessname City
ad_phone= Phone
ad_businessname=Business Name
ad_website= Website
ad_text= Business Name
ad_address= Address
email= Email
ad_zip= Postal Code
There are other adsmanager fields need to be import but csv files doesn't contain these data. Your script will have to import it. It is fix values (always the same) but we need to configure it in some text fields.
ad_youwanttopublishanoffer=Yes
ad_currency=EUR
ad_price=0

We need to import these info in Community Builder:
name=Business Name
username= Lowercase(Business Name) (remove spaces) -- > i.e.: "BANCO BAÑALA-MONTO" will be "bancobañala-monto"
cb_businessname= Business Name
cb_tel= Phone
cb_address= Address
cb_website= Website
email= Email
cb_postcode= Postal Code
registerDate= date of the import

There are other CB fields need to be import but csv files doesn't contain these data. Your script will have to import it. It is fix values (always the same) but we need to configure it in some text fields.
password= yesifun
!!! Becareful!!!! some data are with special charcaters (ñ,é,ô,î,etc...) be sure to import it correctly

The problem is now to import the correct location data and to know in which adsmanager category to import.

Your script will have to search in our database the city, country, region, subregion. The city is in the filename. The country is in the folder name. region and subregion will have to be found automatically.

We will specify by hand in which adsmanager category to import.
After we selected the category for a category subfolder, the script should create the CB users and import all the businesses of all the csv of the subfolders in Adsmanager.

The algoritm should be somthing like that:

FOR EACH file
FOR EACH line
IF email already exist in CB THEN
IF Ads doesn't exist in Adsmanager THEN (a unique ad is defined by Business name + city + Address + phone number)
CREATE Advert in adsmanager with publisher the existant CB user You need to creat ad with correct country, region, subregion, city. The name of the city is in the name file(the last word after "_"). Of course you need to put the city of the correct country (Main folder selected previously. i.e.: Spain)
END IF
ELSE
CREATE user in CB
CREATE Advert in adsmanager with publisher the CB user newly created
END IF
FEND
FEND

The component will have 3 tabs: Import CSV | History | Upload screenshots

Import CSV is to import the csv files. Once a folder is imported, it will be moved in History tab
History is to displayed all the folders we imported. (dat & qty of csv files imported)
Upload screenshots is to upload images in the adverts.

We use a program to make screenshot of websites. We need to upload these screenshots in the apropriate advert.

It is possible that many adverts has the same website (i.e:bank has many agencies), in this case, your script must upload the jpg if the advert doesn't contain any images.

We will store all the screenshots in the folder administrator/screenshots/
The name of the screenshots file jpg is: website.com.jpg
Look at this screenshot:



SO your script will hace to take the name of each screenshot (Which is the name of the website), search for all the advert with ad_website= website(of the screnehsot) and upload it in the adverts.
You don't need to upload the screenshot if the advert has already a picture.

Make your best offer.

---
Skills: import