|
Group: Forum Members
Last Active: Thu 12 May 2016
Posts: 50,
Visits: 86
|
Anyone know how to export the SEO meta data from the categories using the database admin tools?
thanks!
H4 Interactive is a North Wales based Web Design and Development Agency specialising in e-commerce systems and content managed websites
|
|
Group: Forum Members
Last Active: Mon 6 Dec 2021
Posts: 235,
Visits: 750
|
Not from the admin page, no. However, you can export Meta data directly from the SQL Server database and if you had a need to export this from the admin pages you could create a custom page to perform this function.
For example, All SEO Meta Descriptions are in table tblKartrisLanguageElements and have an LE_FieldID value of '4'. If you only want the categories then you want records with an LE_TypeID of 3.
The actual categories are also in tblKartrisLanguageElements so if you wanted the category names and the SEO data in a single view then you would produce an SQL Server view that joined two instances of the same table to produce that lookup.
For example:
SELECT CatLE.LE_ParentID CategoryID, CatLE.LE_Value CategoryName, CatSeoLE.LE_Value SeoDescription
FROM tblKartrisLanguageElements CatLE LEFT OUTER JOIN tblKartrisLanguageElements CatSeoLE
ON CatLE.LE_ParentID = CatSeoLE.LE_ParentID
AND CatLE.LE_TypeID = CatSeoLE.LE_TypeID
WHERE CatLE.LE_FieldID = 1 AND CatLE.LE_TypeID=3
AND CatSeoLE.LE_FieldID = 4
We are always willing to help out the community or pitch in to help you fix a problem. However, if you want a complete solution made such as a code module or new feature added you have two options. Either
1) Reach out to the Kartris internal development team at http://www.kartris.com/Contact.aspx.
2) Contact one of the Kartris approved partners at http://www.kartris.com/t-Worldwide-Developers.aspx.
Have fun and good luck coding.
|