Skip to content

Instantly share code, notes, and snippets.

@2dpi
Created November 22, 2012 09:08
Show Gist options
  • Star 3 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 2dpi/4130110 to your computer and use it in GitHub Desktop.
Save 2dpi/4130110 to your computer and use it in GitHub Desktop.
SEBLOD: Importer readme
SEBLOD Importer
========================================
- create/open CSV file (use first row for column titles to make editing easier)
- NB! make sure the following columns exist (id, title, catid)
-- id (joomla core auto increment if not specified)
-- title (if not specified timestamp will be used)
-- catid (set a default category else will be save as uncategorised)
-- OPTIONAL - ADD ANY OTHER ARTICLE COLUMNS
- match existing exclusive columns (i.e. LOCKED -TABLE: cck_store_form_your_content_type - storage [standard - article - field_name])
- enter/update data
- upload
NEW RECORDS - Add New -
========================================
- CREATED: new content type
- CREATED: DB table (i.e. TABLE: cck_store_form_your_content_type)
- CREATED: exclusive fields (LOCKED - storage [standard - article - field_name])
- CREATED: joomla articles as per data
- CREATED: data records in (TABLE: cck_store_form_your_content_type)
NOTES:
NB! general fields are not imported (i.e. UNLOCKED - TABLE: cck_store_item_content - storage [standard - article - field_name])
NB! existing id's will be updated on import
NB! blank id will result in next joomla core auto increment id being assigned
NB! random id will create joomla articles with specified id's if not existing
NBB! CORE auto increment value will always start from last highest id (import might lead to break in id range eg 1,2,3,501,502,503)
ISSUES:
- creating new content type from CSV will fail if content contains HTML (import to existing content type works!)
HINTS:
Content types can be changed by importing content and selecting different content type form (id will be required)
Field Names can also be used (ie if field name is different to table column title either should work for import)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment