Categories
View Replies (3)

Resolved import articles from drupal sql

  1. pascal_pasvorm
    pascal_pasvorm
  2. RO CSVI
  3. Friday, 30 December 2016
  4.  Subscribe via email
Is it possible to import articles from a drupal sql (csv) file.
The columns are different to joomla but my idea was to rename these and import...
But i'm not sure if this will work with csvimproved? or if anyone has tried this before.

Columns from drupal:
entity_type bundle deleted entity_id revision_id language delta body_value body_summary body_format

Joomla columns:
id asset_id title alias introtext fulltext state catid created created_by created_by_alias modified modified_by checked_out checked_out_time publish_up publish_down images urls attribs version ordering metakey metadesc access hits metadata featured language

Thanks in advance,
Pas
0
Responses (3)
tharuna
tharuna
Accepted Answer Pending Moderation
Hello Pas,
Is it possible to import articles from a drupal sql (csv) file.
The columns are different to joomla but my idea was to rename these and import...
But i'm not sure if this will work with csvimproved? or if anyone has tried this before.

If you know Joomla equivalent database field names you can import it with CSVI.

1. Create an import template with Action as import, Component as Joomla content and Operation as Content.
2. Add template fields and set your drupal fields name in your field so Joomla fields are mapped with drupal fields.
3. Try the import.

If you have any issues post the debug log and sample import file. To know on how to get the debug log check Where to get the debug information? on top of this page.
Kind regards,

Tharuna

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
pascal_pasvorm
pascal_pasvorm
Accepted Answer Pending Moderation
Hi Thatuna,
Thanks for your quick reply.
Was reading about article import (https://csvimproved.com/support/import/207-joomla-content/955-import-joomla-content).
Are these field required: alias, category_path ?
And does joomla add (auto increment) articles ids itself?

Thank you,
Pas
  1. more than a month ago
  2. RO CSVI
  3. # 2
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Pas,

The fields alias and category_path are required because CSVI uses those to identify any existing articles. The database will create the article IDs by itself because this field is the primary key and auto-increment.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!