Contact Us Today! | vcare@wdmtech.com

WDMtech

Topic-icon Import Yootheme Blog to Joomla Article

More
1 year 2 months ago #2903

Hello,

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


Thanks
Daniel

Please Log in or Create an account to join the conversation.

  • Thomas Seeliger
  • Thomas Seeliger's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 2 months ago #2899

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:

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 or Create an account to join the conversation.

More
1 year 2 months ago #2898

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 or Create an account to join the conversation.

  • Thomas Seeliger
  • Thomas Seeliger's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
More
1 year 2 months ago #2895

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
#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?

Attachments:

Please Log in or Create an account to join the conversation.