Topic: Import data into Sobi2 from a CSV file

[pelloq1]

Hello,

I have developped a php programm that can import data in sobi from Excel (csv).

The CSV structure must be :

Code: [Select]

TITLE;CAT_1;CAT_2;CAT_3;CAT_4;CAT_5;field_xxx;field_yyy;field_zzz;.... all customfields
the title;Cars;Trucks;Boats;;;Value;;Value
the title2;Cars;Trucks;;Aicrafts;;Value;Value;Value
My programm is a simple file to copy on your server by ftp, and call like : www.yoursite.com/importsobi2.php
Know limitiations :

• If you have multiples categories with the same name the programme use the first finded
• For the listBox typ custom fields you must use optionName and not optionValue

I'am testing my prog during the next weeks ... with thousand entries...

[nvhengel]

This tool looks very usable to me!

I have some questions;

• Does it work with the plugin Gallery as wel?
  
• And when you want to add just a few entries from a csv file, does it just add them of does it replace the rest of the entries?
  
  • When is the plugin available for (free??)download?
    
    Thanks,
    N

[pelloq1]

Hello,

No, the program dont work with any plugin (galery and download) and not with the images and logo. My program can just import these data :the title (the program detect if you allow the duplication or not), the categories (min 1 max 5), and any custom field you have created.

The program dont replace any value, just add entries (if the same title exist and you not authorize the duplication, the importation dont start.

The programm work in 2 phases : 1 test (check the cvs file, title, cat, and fields), 2 import, importation of data. The programm detect automaticaly the data base password and the joomla table prefix.

The program is finished. I need to test it. I dont have time now to do this, I hope in 2 or 3 weeks.

The program is not for free, but, I send it to you after a paypal donation (about 20 EUR).

[ronbruner]

I am very interested in this as well (and will gladly donate). I will be doing an import to a fresh install of SOBI2 - no existing users in the database. Would love to have access to your plugin as soon as possible. Please keep us posted on the progress.

Thanks!

[nvhengel]

Sounds good, I hope to hear from you as soon as possible and I don't really mind to make a donation...Free would have been better but i can imagine that you would see some reward for the work you did!

Keep me posted!!

Greetz,

Niek

[BC]

I look forward to seeing this soon. I would be happy help beta test but I just can't see paying for the privilege............ 

[jsteurer]

I would like to test this for you as well.  Let me know when it's available.. 

[pelloq1]

At this time, I dont have time to test my program, I search 2 or 3 testers.

Procedure :

01/ send me a MP with your reference and your experience with sobi2
02/ I send you for free the program.
03/ You can test it, repport me any problems.
04/ After that I make the corrections
05/ loop the 03 and 04 step
06/ at the end you have the import program for free !

Conditions :
 - Dont use it on a production site ! The program is not tested ...
 - You cannot send it to a friend, copy it or sell it. Its my job ! the program is copyright.
 - If you are interessed to buy the right to make an official plugin make me an MP
 - I need 2 or 3 tester, not more...
 - You cannot modifiy the program.

[efflux]

Hi,

I think your program/plugin could be very helpfull to me. I have some questions though.
My database is created in ms access. So normally this should be no problem to create a csv-file.
My site uses community builder together with sobi2. Does your program fills also CB-profile data? If not, what can i do to populate the CB and sobi2-entries at the same time.
My DB consists of about 1000 entries. For each cb-profile there is only 1 sobi2-entry, (so the relation is 1-to-1)
The SOBI2 "Country" field is an listbox already filled with all the countries. Will that pose any problems?
I have little to no knowledge about php programming so this plugin should be almost "monkey-proof"

If you could help me with that i'll be glad to make an appropriate donnation.
My test site www.evenio.be/evenio

Greets
Piet

[pelloq1]

Hello,

My programm can only insert news entries in Sobi2. The program has no connexion with CB.

You can insert all custom_field that you need. At this time the programm insert the entries with the owner ID 1. That is a limitation. I am modifiing the program now that the user can customise this value.

If you want I can modify the code to add a new column in the CSV file ton add the owner of entry information.

The program cost a simply donation of about 20€. I do not make this modification if you dont use it. If you assure me that you buy it, I make the modification, else I dont make it.

The list boxes in sobi2 are composed by 2 values 1-the name of the value, 2-the value. My program use the name of the value.

I dont speak good english, I hope that I have understand and answers your questions,

Cédric

PS : your site is an .be, do you speak french ?