Joomla Content
Introduction
This tutorial explains how to import and export joomla articles into and from Joomla using CSV Improved.Import
Requirements
Creating the template
A template can be created by following these steps:- Go to Components -> CSVI Pro -> Templates
- Click New
- Give the template a name
- Set Action to Import
- Set Component to Joomla content
- Set Operation to Content
- Click Next: Select Source
- Source is set default to Load from your computer. No need for change.
- Click Next: Select options
- The default values are OK, change if needed.
- Click Next: Select fields
- Nothing needed here as we set to Use column headers as configuration in step 10.
- Click Next: Finalize
- All done here
- Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

Adding the template fields
Template fields can be added by following these steps:- Go to Components -> CSVI Pro -> Templates
- Click on Template fields
- In the Search Tools select your template
- Click on New to add a single field or click on Quick Add to add multiple fields.
The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

Required fields
- alias
- category_path
Criteria
- alias
- category_path
Creating the import file
As in the example file, the fields we are trying to import are listed below, more fields can be added according to the requirement. Check the available fields page in CSVI to find out which fields are available for the Joomla! Content import.
Run the import
The import can be run by following these steps:- Go to Components -> CSVI Pro -> Import
- Select the template created earlier
- Click Select file
- Select the file to import
- Click Preview
- You now see a preview of the file as to how CSVI sees the file
- Click Start import
- The import is run
- The Log details page will be shown with information regarding the import if the Enable logging is enabled in the template

Examples
Import a Joomla article
"title";"alias";"category_path";"state";"introtext"
"Random article";"random-article";"news/local-news";"1";"<p><a>A random site</a></p>"
Example file
joomla_content_import.csvFurther reading
Additionaly Joomla custom field support has been added to CSVI content import. Every custom field for Joomla content will be available as a available field in import. An example custom field import is explained below.
- Add an custom field from Joomla administrator menu > Articles > Fields, For example add a custom field with Title, Additional information
- Save the custom field
- Go to Components -> CSVI Pro -> Available fields
- Update the available fields
- Go to Components -> CSVI Pro -> Template fields
- Select your Joomla content import template
- Click on New button, search for the new custom field added. Save as a template field
- Run the import
Export
Requirements
Creating the export template
A template can be created by following these steps:- Go to Components -> CSVI Pro -> Templates
- Click New
- Give the template a name
- Set Action to Export
- Set Component to Joomla content
- Set Operation to Content
- Click Next: Select Source
- Destination is set default to Download. No need for change.
- Click Next: Select options
- The default values are OK, change if needed.
- Click Next: Select fields
- Fields must be added otherwise there is nothing for CSVI to export. Click Edit template fields.
- A new window opens with the Template fields page. You can add new fields by clicking New or Quick Add.
- When all fields are added you can close the window
- Click Next: Finalize
- All done here
- Click Close to return to the list of templates or Edit if you want to fine-tune the template further.

Add the fields to export
Template fields can be added by following these steps:- Go to Components -> CSVI Pro -> Templates
- Click on Template fields
- In the Search Tools select your template
- Click on New to add a single field or click on Quick Add to add multiple fields.
The Quick Add Option allows you to quickly add multiple fields to a template. It is not possible to set any settings per field here but that can be done after the fields have been added to the template.

Run the export
The export can be run by following these steps:- Go to Components -> CSVI Pro -> Export
- Select the template created earlier
- Click Export
- The export is run
- The Log details page will be shown with information regarding the export if the Enable logging is enabled in the template

Further reading
Exporting Joomla custom fields with Joomla content is possible with CSVI. The custom fields for an article will be available as a template field to export as other normal template fields. If you dont see the custom field in template fields list, make sure that you update available fields.
As an example, say if there is a custom field Additional information added to Joomla articles. This field can be exported by adding to the export fields.
Fields
Field | Import | Export |
---|---|---|
access | access | access |
alias | alias | alias |
alternative_readmore | alternative_readmore | alternative_readmore |
article_layout | article_layout | article_layout |
article_url | article_url | article_url |
asset_id | asset_id | asset_id |
attribs | attribs | attribs |
category_path | category_path | category_path |
catid | catid | catid |
checked_out | checked_out | checked_out |
checked_out_time | checked_out_time | checked_out_time |
combine | combine | combine |
created | created | created |
created_by | created_by | created_by |
created_by_alias | created_by_alias | created_by_alias |
custom | custom | custom |
featured | featured | featured |
float_fulltext | float_fulltext | float_fulltext |
float_intro | float_intro | float_intro |
fulltext | fulltext | fulltext |
hits | hits | hits |
id | id | id |
images | images | images |
image_fulltext | image_fulltext | image_fulltext |
image_fulltext_alt | image_fulltext_alt | image_fulltext_alt |
image_fulltext_caption | image_fulltext_caption | image_fulltext_caption |
image_intro | image_intro | image_intro |
image_intro_alt | image_intro_alt | image_intro_alt |
image_intro_caption | image_intro_caption | image_intro_caption |
introtext | introtext | introtext |
language | language | language |
link_author | link_author | link_author |
link_category | link_category | link_category |
link_parent_category | link_parent_category | link_parent_category |
link_titles | link_titles | link_titles |
metadata | metadata | metadata |
metadesc | metadesc | metadesc |
metakey | metakey | metakey |
modified | modified | modified |
modified_by | modified_by | modified_by |
ordering | ordering | ordering |
publish_down | publish_down | publish_down |
publish_up | publish_up | publish_up |
show_article_options | show_article_options | show_article_options |
show_author | show_author | show_author |
show_category | show_category | show_category |
show_create_date | show_create_date | show_create_date |
show_email_icon | show_email_icon | show_email_icon |
show_hits | show_hits | show_hits |
show_icons | show_icons | show_icons |
show_intro | show_intro | show_intro |
show_item_navigation | show_item_navigation | show_item_navigation |
show_modify_date | show_modify_date | show_modify_date |
show_noauth | show_noauth | show_noauth |
show_parent_category | show_parent_category | show_parent_category |
show_print_icon | show_print_icon | show_print_icon |
show_publishing_options | show_publishing_options | show_publishing_options |
show_publish_date | show_publish_date | show_publish_date |
show_title | show_title | show_title |
show_urls_images_backend | show_urls_images_backend | show_urls_images_backend |
show_urls_images_frontend | show_urls_images_frontend | show_urls_images_frontend |
show_vote | show_vote | show_vote |
skip | skip | skip |
state | state | state |
targeta | targeta | targeta |
targetb | targetb | targetb |
targetc | targetc | targetc |
title | title | title |
urla | urla | urla |
urlatext | urlatext | urlatext |
urlb | urlb | urlb |
urlbtext | urlbtext | urlbtext |
urlc | urlc | urlc |
urlctext | urlctext | urlctext |
urls | urls | urls |
urls_position | urls_position | urls_position |
version | version | version |
xreference | xreference | xreference |
Usage
alias
Description
Set the alias for the menu item.Usage
Format
Text: No HTMLExample
company-informationattribs
Description
Set the extra attributes required for the articleUsage
- show_title
- link_titles
- show_tags
- show_intro
- show_category
- link_category
- show_parent_category
- link_parent_category
- show_author
- link_author
- show_create_date
- show_modify_date
- show_publish_date
- show_item_navigation
- show_icons
- show_print_icon
- show_email_icon
- show_vote
- show_hits
- show_noauth
- alternative_readmore
- article_layout
Format
Text: No HTMLExample
{"show_title":"1","link_titles":"1","show_tags":"","show_intro":"0","show_category":"","link_category":"","show_parent_category":"","link_parent_category":"","show_author":"","link_author":"","show_create_date":"","show_modify_date":"","show_publish_date":"","show_item_navigation":"","show_icons":"","show_print_icon":"","show_email_icon":"","show_vote":"","show_hits":"","show_noauth":"","alternative_readmore":"","article_layout":""}category_path
Description
The category path specifies in which category an article belongsUsage
Format
Text: No HTMLExample
Creating one category
"category_path"
"Parent/Child"
Creating multiple categories
"category_path"
"Parent/Child|Second Parent/Second Child"
checked_out_time
Description
The time the article has been checked out.Default
0000-00-00 00:00:00Format
Text: No HTMLExample
2017-02-22 18:22:02created_by
Description
Set the user who created the articleUsage
Format
NumericExample
42images
Description
Image settings for an article.Usage
- image_intro
- imagetype_intro
- float_intro
- image_intro_alt
- image_intro_caption
- image_fulltext
- imagetype_fulltext
- float_fulltext
- image_fulltext_alt
- image_fulltext_caption
Format
Text: No HTMLExample
{"image_intro":"","imagetype_intro":"full","float_intro":"","image_intro_alt":"","image_intro_caption":"","image_fulltext":"","imagetype_fulltext":"full","float_fulltext":"","image_fulltext_alt":"","image_fulltext_caption":""}link_titles
Description
Set the Linked Titles option.Usage
- *
Use Global - 1
Yes - 0
No
Format
NumericExample
1metadata
Description
Set the metadata.Usage
- robots
- author
- rights
- xreference
Format
Text: No HTMLExample
{"robots":"","author":"","rights":"","xreference":""}metadesc
Description
Set the meta descriptionFormat
Text: No HTMLExample
CSV Improved import made easy.modified_by
Description
Set the user who modified the article lastUsage
Format
NumericExample
42publish_down
Description
The date the article needs to be unpublished.Usage
The date in the following format:
YYYY-MM-DD HH:MM:SS
Year-Month-Day Hour:Minute:Seconds
The time is optional and will by default be set to 00:00:00
Format
Text: No HTMLExample
2013-06-05 09:44:00publish_up
Description
The date the article needs to be published.Usage
The date in the following format:
YYYY-MM-DD HH:MM:SS
Year-Month-Day Hour:Minute:Seconds
The time is optional and will by default be set to 00:00:00
Format
Text: No HTMLExample
2013-06-05 09:44:00skip
Description
The skip field is used to skip the field from being imported.Usage
Format
Text: No HTMLstate
Description
Set the published status of an articleUsage
- 1 - Published
- 0 - Unpublished