Having trouble
- Chris Brown
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
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
#_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.
11 years 11 months ago #14
by Daniel
Thanks
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
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.
11 years 11 months ago - 11 years 11 months ago #15
by Daniel
Thanks
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
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.
- Chris Brown
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 4
- Thank you received: 0
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.