WeStandWithUkraine

by Octopoos

Add-ons Octopoos Free

SEBLOD importer is the ultimate time saver when you have need to bring in a lot of content!

  • Import Articles, Categories, Users
  • Update Users
  • Import as Standard or Custom storage
  • Joomla! 3.x

It is a CSV importer that handles articles, bulk categories and users complete with custom fields. All you need is a spreadsheet with in the right format.
Here's the basic spreadsheet setup: For existing fields, column headers must match the database column names for those fields. For example, Title should be title, the date the article was created should be "created" and formatted in the correct date format ( yyyy-mm-dd hh:mm:ss). Category should be catid (with the id, not name) and so on. Any custom fields need to match the machine name (db column name) used if they already exist. There should be one item per row. When you're done, save/export your spreadsheet as a .csv file using the one of the 3 delimiters SEBLOD offers (comma, semi-colon, pipe). If you use MS Excel, it will probably export a comma separated CSV.

You can also use the importer to create a brand new content type, complete with new custom fields. In fact, this can save time, although the new fields must be text fields. In your spreadsheet, simply add columns and name them as you wish (all lowercase can no spaces allowed). Then when you're ready to import, in the importer under Content Type, choose "Add New" and enter a name.
Before you import, you must choose an object. The first dropdown should match the type of object you are importing, and the second should usually be standard. Then make sure to choose correct separator for the CSV, and any defaults as desired.

Once installed, SEBLOD Importer can be found under Components->SEBLOD 3.x->Importer.

Business Clubs:

  • Lifetime License
  • Unlimited Domains

Single purchase:

  • Free Updates
  • Lifetime License
  • Unlimited Domains

Details:

7060
36697
GNU GPLv2
2013-03-11
2021-02-15
2021-02-15

Requires:

Latest SEBLOD

Screenshots

Downloads

ChangelogFileVersionDate

# Introtext: imported data fixed.

Sign In1.13.02021-02-15

! SEBLOD 3.18 ready.
! Code refactored.
+ AJAX multi-step mode:
  * Field Mapping
  * Prepared/Raw Input
+ Ability to create Categories.
Ability to create Tags.

Sign In1.12.02019-12-26

# Unterminated statements (JS).
# Minor fixes.

Sign In1.11.22018-12-03

! SEBLOD 3.16 ready.
^ Copyright updated.

Sign In1.11.02018-06-27

! Joomla! 3.8 ready.

Sign In1.9.42017-08-29

# AJAX mode issues.

Sign In1.9.32017-07-31

! Cleaning performed.

Sign In1.9.22017-06-09

^ Replace JFile::read()

Sign In1.9.12017-05-22

^ Copyright updated.
! Copyright Updated.
+ "Encoding List" process added.
# Import issue fixed.
# Minor issue fixed.

Sign In1.9.02017-05-10

# UTF-8 issue fixed.

Sign In1.8.12016-09-30

! Extensive cleaning performed.
- "ALTER IGNORE TABLE" removed.

Sign In1.8.02016-08-26

^ Icon added on "Import" Button.
^ Icon for "Session" updated.

Sign In1.7.12016-06-06

+ Additional info/details for Columns/Fields implemented.
   >> "data_type" to force column creation to be INT(11), VARCHAR(255) or else
   >> "label", "type", "options" or other attributes can be overriden for field creation.

^ Default separator is now ";"

# Conditional States fixed.
# User Import issue fixed.

Sign In1.7.02016-06-02

+ "onCckPreBeforeImport" added.
+ "onCckPostBeforeImport" added.
+ "onCckPreAfterImport" added.
+ "onCckPostAfterImport" added.
^ CHARSET now "utf8mb4_unicode_ci".
"onCCK_Storage_LocationAfterImport" replaced by
"onCCK_Storage_LocationAfterImports".
# Data Consistency issues fixed.

Sign In1.6.12016-04-28

! Ability to manage Sessions.
+ Session Manager button added.
+ Session Dropdown updated.
# Javascript issues fixed.

Sign In1.5.02015-07-20

! Joomla! 3.4 ready.
+ Update by Custom Key.
^ Implement JCckImporterVersion.
^ InnoDB SQL table storage engine.
# Force fieldnames to lowercase.

Sign In1.4.02015-05-09

+ "CSV Length" added to Options. # CSV Length issue fixed.

Sign In1.3.32014-12-07

! Download URL for SEBLOD 3.3.4

Sign In1.3.22014-05-13

# cck.dev-3.3.0.min.js loaded.

Sign In1.3.12014-04-15

! Joomla! 3.2 ready.
! Performance improvements.
+ AJAX mode added.
+ "Force Password" added.
+ "Reordering" parameter added.
# Queries overloading issue fixed.

Sign In1.3.02013-12-24

! Joomla 3 ready.

Sign In1.2.02013-04-12

# Storages fixed.

Sign In1.0.22012-04-16

# Various improvements.

Sign In1.0.12012-02-17

Initial Release.

Sign In1.0.02012-01-18

Rating & Reviews

Simply works!

9 years ago
Works great. I had to import users with extra profile fields. Some of them existed already, some not. The importer updated the existing users and added the new ones. That's what was expected, that's what happened. ;-) Tnx you Seblod-heros.
5
5
3

Works grate - one question

9 years ago
First of all: thanks for the free and awesome (and working!) tool!

When importing large number of items, things go quite slow. I am importing 2000 items and it takes hours ;[ Anything I can do?
5
5
4