Having trouble

More
12 years 7 hours ago #13 by Chris Brown
Having trouble was created by Chris Brown
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 to join the conversation.

More
11 years 11 months ago #14 by Daniel
Replied by Daniel on topic Having trouble
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 support@hexsystechnologies.com, we'll look into it.

Thanks
Danish Babu

Thanks
Daniel

Please Log in to join the conversation.

More
11 years 11 months ago - 11 years 11 months ago #15 by Daniel
Replied by Daniel on topic Having trouble
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: 11 years 11 months ago by Daniel.

Please Log in to join the conversation.

More
11 years 11 months ago - 11 years 11 months ago #16 by Chris Brown
Replied by Chris Brown on topic Having trouble
Thanks - fantastic!
Last edit: 11 years 11 months ago by Chris Brown.

Please Log in to join the conversation.

Cron Job Starts