The Joomla! Extensions Directory ™


SOBI2 Data Import plugin PluginExtension Specific Addon

Editor's Note
  • This extension requires registration to download.
This plugin allows you to import CSV data into Sobi from you favorite spreadsheet program. Mutliples categories and images are supported. Very helpful for starting with Sobi.

The data importation is not easy in Sobi, because the database structure is complex. That take a big time to import any data via manual sql queries. What can do this plugin:

* Import data from a CSV file (spreadSheet).
* Create a CSV template from your custom fields.
* Import data into the custom field from SOBI.
* Each entry can be set into the allowed number of categories.
* The program can import any type of data (textarea, text, listbox, checkbox).
* You can choise the owner of the entries.
* You can import images and icons.

3.1.0 : support enclosure charter (better support of excell)

At the moment I have write this plugin (04.2008), it's no way to import datas into sobi. Sigsiu provide now a import-export plugin and allow me to distribute my own import script ("There are surly many people for which Your script is fully enough. - Sigrid").
[English] , [Français] , [Spain] , [Romanian] , [Portuguese] , [lithuanian]

Report

Images
2011-11-26
Reviews: 1
Thanks to Rick for his great support.
Saved me a lot of time, this plugin is defintly € worth!!
2011-07-29
Reviews: 1
This plugin was well worth the price. Works very effectively, and does a great job of checking the integrity of the data before it tries to import and reporting errors. Z. Rick also stands behind his plugin and helped me with a PHP issue to get it set up. A+++
2011-02-13
Reviews: 1
I had a few small issues (User Error). I e-mailed Z. Rick and I received a response in lest than 24 hours. Very helpful, Great program. This saved us a ton of time.
2010-12-11
Reviews: 1
In a word, SUPERB! As a database guru, you simply can't crack Sobi2 easily. After all the time I spent trying, this was well worth the money spent. A bit quirky at first but that's because I needed to install OpenOffice despite my other database translators.

Just follow the step-by-step instructions on the developer's site.
2010-11-22
Reviews: 1
This saved me hours of work. A little frustrating trying to get the import file format correct but the support from the developer was fast and excellent!
2010-11-10
Reviews: 2
After a short learning curve on how the data should be formatted, and a mistake on my part regarding the delimiter. Works like a dream, checks for duplicate entries and any categories that don't exist (case sensitive). Once you've got your information right, click import and your done.
Thanks for this it's saved me hours of work. Worth every penny!!!
2010-10-20
Reviews: 1
Customers without a website are often faced with an issue of how to get the years of work they have done and created lists in Excel on to their website? I thought Sobi2 was gr8 until i was faced with manual entries of 1000's of records. An whooola here is the data import plugiin. I needed this for 100's of pages of Excel data. Thanks myjoom...I will contact you for any support I need in the coming weeks.
2010-08-27
Reviews: 1
I was so overwhelmed when I needed to import a ton of data into SOBI2 so you can imagine the relief I felt when I came across this data import plugin. I'm learning a lot as I go and found this to be easy to use and when I had a question, it was quickly and accurately answered on the support forums. The next time I need a plugin for my Joomla site, I'm checking to see if the creator has what I need first.

Highly recommended!
2010-04-17
Reviews: 1
I had to import thousands of entries from a previous database because of a full site migration. Without an automation it would have lasted for a very long time to accomplish the task. Among the alternatives this was the cheapest one and knew everything I needed.
Installation and setup was very simple and quick. To import properly some adjustments had to be made but also the support was fast and professional. The plugin was able to import even the special hungarian characters (éáűőúöüóí) without any problem.
Based on my positive experiences I decided to purchase an other SOBI2 related plugin from the developer.
Highly recommended.
2010-03-30
Reviews: 1
Perfect plug in and does what it says. A few teething problems from me being a bit thick but the support from Cedric was first class and well worth the cost. Still having a couple of formatting problems but Cedric is still patiently walking me through it.
I would recommend this and any other of Cedric's products to everyone.
2010-01-17
Reviews: 1
Ced's Sobi2 import plugin is very good and simple to use. It makes my work much faster and simpler. I have imported about 10 000 products in couple of hours. Good support via forum. You'll be satisfied.
2009-11-11
Reviews: 13
When left with a daunting directory website conversion I looked into the available import CSV tools for Sobi2. Because I wasn't sure how it was going to work and feeling a little strapped for cash I went with the least expensive of my options. After a few tweaks and a weeks worth of very excellent support from Cedric, I was able to convert my directory listings to Sobi2. The main problems I had was just figuring out how to setup my CSV and get it ready for import. Once that happened, it was beautiful. Excellent Price, Support, and Tool, hands down. Thanks for making this available.
2009-10-30
Reviews: 12
I am an avid buyer of low cost extensions that save time. This is definitely the case here as this import plugin for SOBI2 works great. The cost of a few bucks saves an enormous amount of time, there is nothing but good about that!

The bonus also is the developer is active on his support forum every day and follows up until you are completely satisfied. (I initially had issues with my import file, but he went out of his way to help)

Glad to recommend this ext.

Cheers!
2009-09-25
Reviews: 1
ok, purchased the module
installed it and fellowed the instructions on the website, all worked great.
Even added a field call icon and image.
Set them as HTML, which allowed to import a icon and image with the import.
all good fella's, good job
Owner's reply

New version in in test phase, it's now a SOBI2 plugin, and include the icon and images traitement natively.

Sobi2 gallery is projected for the next next release ;-)

2009-08-21
Reviews: 11
Why to get this script for importing?
First of all its the cheapest.
Cedric helped me personally via his forum.
It worked!

i made this work with excel and notepad.
i had NO idea notepad could create csv document.
Follow his direction on his site (use the forum).
Keep in mind these few things:
use notepad and you HAVE to add the .csv extention IN THE NAMING of the file. you have to type it in!! it will convert auto.
when i installed the module and retrieved my headers, i imported them and the headers didnt import from notepad to excel so i had to type them in. not a big deal considering it didnt take long and the importing was going to save me years.
more important hints:
1) the default and instructions say to use ";"
but excel, (well mine anyway) would not use ;.
and when saving, it would tell me it was losing info (meaning it was converting to "," instead.
so make sure you make note throughout the process.
2) you MUST use at least one category !!
3) when you copy and paste watch out for those comma's or ';' if you are able to use ';'.
you hit test and it will give you line errors.
go back to notepad and find the 'go to' line and enter the line and look it over. in my case there were commas separating words within my import, but the software was thinking it was an action. like so and so, inc.
it would see that comma and it would error because there was an extra comma... which leads me to my final hint.
4) you have to have EXACTLY the same amount of commas or ';' as items in the header. (title equals the company name).
if your header has title and 3 cat's and 7 fields, then you need to have 11 items. where you are NOT filling in info, you STILL need that comma!
i think those 4 hints will save someone a day that i spent working this stuff out.

OVERALL it was easy easy!
SO BUY IT!
2009-08-19
Reviews: 5
I had to import more the 1500 entries in an index.
I have chosen SOBI2 and Cédric Pelloquin made the import module.
Easy and fast !
Franck
2009-07-15
Reviews: 3
A great solution for anyone running the SOBI2 component. Author offers great support, I'm very happy with my purchase.
2009-04-12
Reviews: 1
Author went out of their way to help us out and offered us a refund if it didn't work out.

Lucky for us we didn't need one, it worked perfectly and we're really happy with the results and great support that goes the extra mile :)
2008-08-22
Reviews: 5
simlpy for import from a spreadsheet !