Topic-icon Having trouble

  • Chris Brown
  • Chris Brown's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
14 Sep 2013 07:47 #16

Thanks - fantastic!

Last edit: 14 Sep 2013 07:47 by Chris Brown.

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

More
14 Sep 2013 07:19 #15

Hi,

I've modified the profile settings on your server, Please now try to import your data.

Problem was:
You were checking the reference to box for every field, while You only need to check it when you need to compare data from other tables like you need to fetch category id from #__categories table based on title or some other column.

Thanks
Danish Babu


Thanks
Daniel
Last edit: 14 Sep 2013 07:23 by Daniel.

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

More
14 Sep 2013 04:32 #14

Hi,

There are few extra fields which are required to be imported into articles table, here these are:

Alias ( same as title )
category ( it will be either catid or if title it should already be existing in database. HexData doesn't create a new category, it just connects with already existing categories )
Status ( should be 1 or 0 )
Access ( should be 1 or depending upon the access level of the item )
Language ( keept it * for all languages or for example for english "en-GB")
created ( current date or whatever you want "2013-09-14" )
created_by ( either reference it with #__users table or directly give here the id of user whoever you wants to be the author of these articles most likely id of super user )
publish_up ( keep same as created field )

Please try to include the above fields, if it doesn't solve your problem, Please email us your login credentials at This email address is being protected from spambots. You need JavaScript enabled to view it., we'll look into it.

Thanks
Danish Babu


Thanks
Daniel

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

  • Chris Brown
  • Chris Brown's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
13 Sep 2013 19:24 #13

I've got a csv with my article category, title, into text & full text and I've set up a profile with the content table which I have 4 active fields.
#_content:title
#_content:introtext
#_content:fulltext
#_categories:title

When I import the csv all I get are blank articles and only the category assigned (so no title or content). If I export using that profile all I get is a csv with the field titles and the existing categories in the category columm. The other columns are empty.
I'm using Joomla 3.1.5

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

Cron Job Starts