Hi,
I created an import project for a single entity (it contains CatVendorCatalogMaintenaceRequest inner joined with CatVendorCatalog and outer join with CatVendorProdcutCandidate)
I imported an empty excel file manually that is empty in it. and the file contains some fields like (product number, Action type, ProductSubType, product category name, product category hirerachy name, etc..)
but without the field Upload date time -- as if we use standard functionality, we import XML file without upload date time. -- we fill this field by code. -- and import for the empty file was successfull.
I uploaded a new excel file (not empty) with data (I made sure data is unique) and also without uploadDateTime field -- this upload was done from vend catalog form (customized button)
Then I did the following:
protected void preProcessCatalogMaintenanceRequestXML()
{
System.Exception ex;
try
{
CatVendorDateTime uploadDateTime = CatVendorCatalogMaintenanceRequest::findRecId(catVendorCatalogMaintenanceRecId).UploadDateTime;
using(ExcelPackage package = new ExcelPackage(this.fileStream))
{
int rowCount,columnCount, rowIterator, columnIterator;
package.Load(this.fileStream);
ExcelWorksheet worksheet = package.get_workbook().get_worksheets().get_Item(1);
OfficeOpenXml.ExcelRange range = worksheet.Cells;
rowCount = worksheet.Dimension.End.Row - worksheet.Dimension.Start.Row 1;
columnCount = worksheet.Dimension.End.Column - worksheet.Dimension.Start.Column 1;
int extraColumn= columnCount 1;
var range1 = range.get_Item(1, extraColumn);
System.String value = "UPLOADDATETIME";
range1.set_Value(value);
for(rowIterator = 2; rowIterator <= rowCount; rowIterator )
{
range1 = range.get_Item(rowIterator, extraColumn);
range1.set_Value(datetime2Str(uploadDateTime));
}
package.Save();
fileId = this.uploadFileToTempStorage(this.fileStream, fullFileName);
}
}
}
private str uploadFileToTempStorage(System.IO.Stream _outputStream, str _fullFileName)
{
try
{
FileUploadTemporaryStorageStrategy fileUploadStrategy = new FileUploadTemporaryStorageStrategy();
FileUploadTemporaryStorageResult fileUploadResult = fileUploadStrategy.uploadFile(_outputStream, _fullFileName);
if (fileUploadResult == null || !fileUploadResult.getUploadStatus())
{
warning("@ApplicationPlatform:FileUploadFailed");
}
else
{
if (fileUploadResult.getFileId() == "")
{
throw Exception::Error;
}
return fileUploadResult.getFileId();
}
}
catch(Exception::Error)
{
warning("@ApplicationPlatform:FileUploadFailed");
}
return "";
}
then the import
The import failed, when I went to the data entity execution details, I got this:
I clicked view staging data: -- why upload date is empty??
I clicked validate all, but I still can't see any meaningful error:
How can I find the error?
I also, tried to import the excel file manually, with uploadDateTime field, I got the same result, it failed with no meaningful error (but here upload date is filled)
