RE: Import item from excel with category
@Tabrez Ajaz thank you i resolved by this code :
child := ItemRecBuffer.ItemSubCategorie;
parentcategory := ItemRecBuffer.ItemCategorie;
If not CategorieItem.get(parentcategory) then begin
CategorieItem.init();
CategorieItem.code := parentcategory;
CategorieItem.insert;
end;
//Child
If not CategorieItem.get(child) then begin
CategorieItem.init();
CategorieItem.code := child;
CategorieItem."parent category" := parentcategory;
CategorieItem.insert;
end;
ItemRec.Validate("Item Category Code", ItemRecBuffer.ItemCategorie);
// Update or Insert Categorie
it s ok and please if you can help me for another probléme is :
i have evaluation ( description) to creat (extend text) on import liste from excel to my TablX:
with this code
//Exteded text
TotalTxt := GetValueAtCell(RowNo, 4);
if StrLen(TotalTxt) > 100 then begin
ItemTab.ItemDesc1 := TotalTxt.Substring(1, 100);
ExtTxt := TotalTxt.Substring(101);
end
else
ItemTab.ItemDesc1 := TotalTxt;
//Exteded text
so after kno i need to recuper my ExtTxt to be exteded text for the Item when a validat my tabx