|
By polychromenz - Wed 4 Jun 2014
|
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.
|
|
By polychromenz - Wed 4 Jun 2014
|
I found an item on the forum http://forum.kartris.com/Topic2547.aspx?Keywords=ptblElements#bm2554 but that seems to suggest that I would fetch the full languages table and pass it as a parameter.
That's easy enough I guess but the question is why? If its always all records from that table why doesn't the function just do that itself?
|
|
By polychromenz - Tue 10 Jun 2014
|
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.
|