Hi Dear All,
I need to upload some pdf report into document handler based on customer id using Ax Job. I created job for that. but it is not working properly. i need to ur help to get solve this.
static void DocumentHandling(Args _args)
{
DocuRef docuRef;
DocuValue docuValue;
smmBusRelTable smmBusRelTable;
System.String[] fileNames;
int fileCount, i;
str fileName, trimmedFileName,docName;
BinData binData;
custAccount custAcc;
;
binData = new BinData();
fileNames = System.IO.Directory::GetFiles(@“D:\Test”);
fileCount = fileNames.get_Length();
for (i=0; i<fileCount; i++)
{
fileName = fileNames.GetValue(i);
trimmedFileName = substr(fileName, strscan(fileName, ‘\’, strlen(fileName), -strlen(fileName))+ 1, strlen(fileName));
if (trimmedFileName)
{
trimmedFileName = strreplace(trimmedFileName, “.PDF”, “”);
docName = trimmedFileName;
trimmedFileName = substr(trimmedFileName,1,5);
}
custAcc = trimmedFileName;
select firstonly smmBusRelTable
where smmBusRelTable.smmCustAccount == custAcc;
ttsbegin;
if (smmBusRelTable)
{
binData.loadFile(fileName);
docuValue.File = binData.getData();
docuValue.OriginalFileName =fileName;
docuValue.FileType =‘PDF’;
docuValue.FileName = NumberSeq::newGetNum(DocuParameters::numRefDocuNumber(),false).num();
docuValue.insert();
docuRef.ValueRecId = docuValue.RecId;
docuRef.RefTableId = tableNum(smmBusRelTable);
docuRef.RefRecId = smmBusRelTable.RecId;
docuRef.RefCompanyId = curext();
docuRef.TypeId = “OrderForm”;
docuRef.Name = docName;
docuRef.insert();
}
ttscommit;
}
}
Thanks,
Sameera