|
Group: Forum Members
Last Active: Thu 21 Sep 2017
Posts: 13,
Visits: 179
|
I cant be the first person trying to do this so i'll ask here.
I want to sync data from my accounting software. I am starting with Categories accessing the CategoriesBLL._AddCategory method
Is there any documentation that covers what ptblElements and pParentsList requires
I think the remaining parameters are straight forward as the basically match the entry screens. I assume ptblElements refers to the lnaguages being added but its hard to guess this stuff.
|
|
Group: Forum Members
Last Active: Thu 21 Sep 2017
Posts: 13,
Visits: 179
|
|
|
Group: Forum Members
Last Active: Thu 21 Sep 2017
Posts: 13,
Visits: 179
|
So these are the language elements, you want a row for each element and repeat for each language.
A good example is categories if you add a category and get the CAT_ID of your new category from tblKartricCategories then
SELECT LE_LanguageID, LE_TypeID, LE_FieldID, LE_ParentID, LE_Value, LE_ID
FROM tblKartrisLanguageElements
WHERE (LE_TypeID = 3) AND (LE_ParentID = @CATID)
ORDER BY LE_ParentID, LE_FieldID
will show you the rows you need to populate LE_FieldID 1-5 & 8
I don't really know why we make the null values but the admin does it so I assume we should too.
I have made another post showing how to add a category
http://forum.kartris.com/Topic3101.aspx
and i'll share there some helper classes that take away the pain. If this helps anyone please post a note os I know if anyone is using this or not.
|