Please login or register.

Login with username, password and session length
Advanced search  

News:

Anzeige:

SOBI2 Featured Listings Plugin
Featured Listings
SOBI2 Radius Distance Search Plugin
Radius Distance Search
SOBI2 Import & Backup Plugin
SOBI2 Import & Backup
SOBI2 Search Module
Search Module
SOBI Donation/Spende
Pages: [1] 2   Go Down

Author Topic: Import data into Sobi2 from a CSV file  (Read 15590 times)

0 Members and 1 Guest are viewing this topic.

pelloq1

  • SOBI Experte
  • ****
  • Thanx from users: 26
  • Offline Offline
  • Posts: 243

  • Reviews:

    What is it?

Import data into Sobi2 from a CSV file
« on: 31. January 2008, 21:53:48 »
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...
« Last Edit: 31. January 2008, 21:56:44 by pelloq1 »
Logged
Z. Rick - More SOBI2 Extensions: http://www.myjoom.com
Country: Switzerland Switzerland |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile WWW

nvhengel

  • SOBI Newbie
  • *
  • Thanx from users: 1
  • Offline Offline
  • Posts: 4

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #1 on: 07. February 2008, 11:38:59 »
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
Logged
Country: Netherlands Netherlands |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile

pelloq1

  • SOBI Experte
  • ****
  • Thanx from users: 26
  • Offline Offline
  • Posts: 243

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #2 on: 07. February 2008, 11:55:08 »
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).
« Last Edit: 23. February 2008, 14:35:59 by pelloq1 »
Logged
Z. Rick - More SOBI2 Extensions: http://www.myjoom.com
Country: Switzerland Switzerland |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile WWW

ronbruner

  • SOBI Newbie
  • *
  • Thanx from users: 0
  • Offline Offline
  • Posts: 2

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #3 on: 07. February 2008, 16:40:18 »
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!
Logged
Country: United States United States |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile

nvhengel

  • SOBI Newbie
  • *
  • Thanx from users: 1
  • Offline Offline
  • Posts: 4

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #4 on: 07. February 2008, 16:57:01 »
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
Logged
Country: Netherlands Netherlands |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile

BC

  • Moderator
  • SOBI Profi
  • *
  • Thanx from users: 10
  • Offline Offline
  • Posts: 173

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #5 on: 07. February 2008, 20:51:11 »
I look forward to seeing this soon. I would be happy help beta test but I just can't see paying for the privilege............  :blink:
Logged
“We are what we repeatedly do. Excellence, then, is not an act, but a habit.” Aristotle

"Once you go MAC, you never go back" Bill Gates
www.spaclique.com
Country: United States United States |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile WWW

jsteurer

  • SOBI Newbie
  • *
  • Thanx from users: 0
  • Offline Offline
  • Posts: 6

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #6 on: 08. February 2008, 04:12:54 »
I would like to test this for you as well.  Let me know when it's available.. 
Logged
Country: United States United States |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile

pelloq1

  • SOBI Experte
  • ****
  • Thanx from users: 26
  • Offline Offline
  • Posts: 243

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #7 on: 11. February 2008, 11:12:15 »
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.
Logged
Z. Rick - More SOBI2 Extensions: http://www.myjoom.com
Country: Switzerland Switzerland |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile WWW

efflux

  • SOBI Newbie
  • *
  • Thanx from users: 1
  • Offline Offline
  • Posts: 31

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #8 on: 21. February 2008, 00:54:31 »
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
Logged
Country: Belgium Belgium |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile

pelloq1

  • SOBI Experte
  • ****
  • Thanx from users: 26
  • Offline Offline
  • Posts: 243

  • Reviews:

    What is it?

Re: Import data into Sobi2 from a CSV file
« Reply #9 on: 21. February 2008, 15:39:31 »
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 ?

« Last Edit: 23. February 2008, 14:36:29 by pelloq1 »
Logged
Z. Rick - More SOBI2 Extensions: http://www.myjoom.com
Country: Switzerland Switzerland |  OS: Unknown Unknown Browser: Unknown Unknown |  View Profile WWW
Pages: [1] 2   Go Up
« previous next »
 

Page created in 0.226 seconds with 26 queries.

Partner Sites: Joomla Web Design  |  Yagendoo Templates  |  LayDev - Joomla Templates  |  Joomla Downloads  |  CyberTyper.ch  |  Codingfish  |  Akeeba Backup  |  FLEXIcontent  |  templates4ALL  |  Joomla! InSecurity