Import Yootheme Blog to Joomla Article

Daniel
Offline
Administrator

25 Jul 2016 10:35 #2903 by Daniel

Replied by Daniel on topic Import Yootheme Blog to Joomla Article

Hello,

Please provide your backend & FTP login credentials via Contact us form, We'll look into it.

Thanks
Daniel

Please Log in to join the conversation.

Thomas Seeliger
Topic Author
Offline
New Member

24 Jul 2016 06:39 #2899 by Thomas Seeliger

Replied by Thomas Seeliger on topic Import Yootheme Blog to Joomla Article

Thanks for the answer!

I have learned that the csv file must be prepared. Note to Mac users: Xtabulator is a good lightweight tool.
Now unfortunately I have a new problem:

Code:

Insert fail with error COM_CONTENT_WARNING_PROVIDE_VALID_NAME.

The logfile has no more information (line number with the invlid name)
Should I delete the first line in the CSV file? Here are the column names in it. :huh:

Please Log in to join the conversation.

Daniel
Offline
Administrator

23 Jul 2016 11:31 #2898 by Daniel

Replied by Daniel on topic Import Yootheme Blog to Joomla Article

Hello,
Before importing the Data in Articles table, related Categories must be created / imported in the Database. If the categories are created then you can import the articles either with the related catid or with the help you Category Title / Alias. And as I can see in your screenshot, you have not chosen any column for Category extension and Title.

Thanks
Daniel

Please Log in to join the conversation.

Thomas Seeliger
Topic Author
Offline
New Member

21 Jul 2016 17:25 #2895 by Thomas Seeliger

Import Yootheme Blog to Joomla Article was created by Thomas Seeliger

Hey,
need a little help to import the yootheme zoo blog into the joomla article.
The structure is:
Id,Name,Alias,"Author Alias","Create date",Category,Category,Category,Tag,Tag,Tag,Tag,Tag,Tag,Tag,Tag,Tag,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Text,Image

I try to import the file with the Profile title - Import Joomla Articles.

and

The logfile shows the problem:
#Date: 2016-07-21 17:06:58 UTC
#Software: Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Code:

#Fields: datetime	priority clientip	category	message
2016-07-21T17:06:58+00:00	INFO xxxxxxxxxxxx	com_vdata	Import Profile title - Import Joomla Articles
2016-07-21T17:06:58+00:00	INFO xxxxxxxxxxxx	com_vdata	Import Table - #__content
2016-07-21T17:06:58+00:00	INFO xxxxxxxxxxxx	com_vdata	Import Format - CSV
2016-07-21T17:06:58+00:00	ERROR xxxxxxxxxxxx	com_vdata	catid - reference data not available in source data
2016-07-21T17:06:58+00:00	ERROR xxxxxxxxxxxx	com_vdata	created_by - reference data not available in source data
2016-07-21T17:06:58+00:00	ERROR xxxxxxxxxxxx	com_vdata	Insert Fail, record already exists with id = 255 .
2016-07-21T17:06:58+00:00	ERROR xxxxxxxxxxxx	com_vdata	catid - reference data not available in source data
2016-07-21T17:06:58+00:00	ERROR xxxxxxxxxxxx	com_vdata	created_by - reference data not available in source data
2016-07-21T17:06:58+00:00	ERROR xxxxxxxxxxxx	com_vdata	Insert Fail, record already exists with id = 257 .

What can I do?

Please Log in to join the conversation.