private void SyncUserFolder(int portalId, ExportFolder folder)
{
var portal = PortalController.Instance.GetPortal(portalId);
var tempUsersFolderPath =
$"{string.Format(UsersAssetsTempFolder, portal.HomeDirectoryMapPath.TrimEnd('\\'))}{folder.FolderPath}";
var newUsersFolderPath = $"{portal.HomeDirectoryMapPath}{folder.FolderPath}";
if (!Directory.Exists(tempUsersFolderPath))
{
return;
}
if (!Directory.Exists(newUsersFolderPath))
{
Directory.CreateDirectory(newUsersFolderPath);
}
var files = Directory.GetFiles(tempUsersFolderPath, "*.*", SearchOption.AllDirectories);
var dirInfo = new DirectoryInfo(newUsersFolderPath);
foreach (
var mFile in
files.Select(file => new System.IO.FileInfo(file)))
{
if (File.Exists(dirInfo + "\\" + mFile.Name))
{
File.Delete(dirInfo + "\\" + mFile.Name);
}
mFile.MoveTo(dirInfo + "\\" + mFile.Name);
}
}
private async Task ExportToFile(IEnumerable <NytCountyDay> CountyDayInfo)
{
StorageFile csvFile = await ExportFolder?.CreateFileAsync(CountyDayInfo.FirstOrDefault().DateString + "-county-info.csv", Windows.Storage.CreationCollisionOption.ReplaceExisting);
using (CsvFileWriter dataWriter = new CsvFileWriter(await csvFile.OpenStreamForWriteAsync()))
{
CsvRow headerRow = new CsvRow();
headerRow.Add("fips");
headerRow.Add("cases");
headerRow.Add("deaths");
headerRow.Add("cases7dayavg");
headerRow.Add("deaths7dayavg");
headerRow.Add("casesper100K");
headerRow.Add("deathsper100K");
dataWriter.WriteRow(headerRow);
foreach (var county in CountyDayInfo)
{
CsvRow nextRow = new CsvRow();
nextRow.Add(county.Fips);
nextRow.Add(county.Cases.ToString());
nextRow.Add(county.Deaths.ToString());
nextRow.Add(county.Cases7Avg.ToString());
nextRow.Add(county.Deaths7Avg.ToString());
nextRow.Add(county.Cases7AvgPer100K.ToString());
nextRow.Add(county.Deaths7AvgPer100K.ToString());
dataWriter.WriteRow(nextRow);
}
dataWriter.Close();
}
}
private void ExportChoose_Click(object sender, EventArgs e)
{
ExportFolder.ShowDialog();
if (ExportFolder.SelectedPath != "")
{
ExportPath.Text = ExportFolder.SelectedPath;
}
else
{
ExportPath.Text = "N/A";
}
}
private async Task WriteBackup(IEnumerable <Conversation> conversations, CancellationToken cancellationToken)
{
var exportFolderName = $"backup-{DateTime.Now:yyyyMMddHHmmssfff}";
var exportFolder = await ExportFolder.CreateFolderAsync(exportFolderName);
var attachmentFolder = await exportFolder.CreateFolderAsync("attachments");
UpdateExportStepState(ExportStep.StoreConversations, ExportStepState.InProgess);
await FileIO.WriteTextAsync(
await exportFolder.CreateFileAsync($"conversations.csv"),
await Task.Run(() =>
ServiceStack.Text.CsvSerializer.SerializeToCsv(conversations), cancellationToken));
UpdateExportStepState(ExportStep.StoreConversations, ExportStepState.Done);
UpdateExportStepState(ExportStep.StoreMessages, ExportStepState.InProgess);
await FileIO.WriteTextAsync(
await exportFolder.CreateFileAsync($"messages.csv"),
await Task.Run(() =>
ServiceStack.Text.CsvSerializer.SerializeToCsv(conversations.SelectMany(convo => convo.FlattenedMessages)), cancellationToken));
UpdateExportStepState(ExportStep.StoreMessages, ExportStepState.Done);
UpdateExportStepState(ExportStep.StoreAttachementsMetadata, ExportStepState.InProgess);
await FileIO.WriteTextAsync(
await exportFolder.CreateFileAsync($"attachments.csv"),
await Task.Run(() =>
ServiceStack.Text.CsvSerializer.SerializeToCsv(conversations.SelectMany(conversation => conversation.Attachments)), cancellationToken));
UpdateExportStepState(ExportStep.StoreAttachementsMetadata, ExportStepState.Done);
UpdateExportStepState(ExportStep.StroeAttachmentFiles, ExportStepState.InProgess);
await Task.WhenAll(conversations
.Where(conversation => conversation.Attachments.Any())
.SelectMany(conversation => conversation.Attachments)
.Select(attachment => Task.Run(async() =>
{
var attachmentFile = await attachmentFolder.CreateFileAsync($"{attachment.Id}.{attachment.GuessedExtension}");
using (var fileStream = await attachmentFile.OpenStreamForWriteAsync())
{
await Attachment.WriteDataToStream(attachment, fileStream);
}
})));
UpdateExportStepState(ExportStep.StroeAttachmentFiles, ExportStepState.Done);
}
private bool ProcessFolder(ExportImportJob importJob, ImportDto importDto, ExportFolder folder)
{
var portalId = importJob.PortalId;
if (folder == null)
{
return(false);
}
var existingFolder = CBO.FillObject <ExportFolder>(DotNetNuke.Data.DataProvider.Instance().GetFolder(portalId, folder.FolderPath ?? ""));
var isUpdate = false;
var modifiedBy = Util.GetUserIdByName(importJob, folder.LastModifiedByUserId, folder.LastModifiedByUserName);
if (existingFolder != null)
{
switch (importDto.CollisionResolution)
{
case CollisionResolution.Overwrite:
isUpdate = true;
break;
case CollisionResolution.Ignore:
return(false);
default:
throw new ArgumentOutOfRangeException(importDto.CollisionResolution.ToString());
}
}
folder.FolderPath = string.IsNullOrEmpty(folder.FolderPath) ? "" : folder.FolderPath;
var folderMapping = FolderMappingController.Instance.GetFolderMapping(portalId, folder.FolderMappingName);
if (folderMapping == null)
{
return(false);
}
var workFlowId = GetLocalWorkFlowId(folder.WorkflowId);
if (isUpdate)
{
Util.FixDateTime(existingFolder);
DotNetNuke.Data.DataProvider.Instance()
.UpdateFolder(importJob.PortalId, folder.VersionGuid, existingFolder.FolderId, folder.FolderPath,
folder.StorageLocation, folder.MappedPath, folder.IsProtected, folder.IsCached,
DateUtils.GetDatabaseLocalTime(), modifiedBy, folderMapping.FolderMappingID, folder.IsVersioned,
workFlowId, existingFolder.ParentId ?? Null.NullInteger);
folder.FolderId = existingFolder.FolderId;
if (folder.UserId != null && folder.UserId > 0 && !string.IsNullOrEmpty(folder.Username))
{
SyncUserFolder(importJob.PortalId, folder);
}
}
else
{
folder.FolderMappingId = folderMapping.FolderMappingID;
var createdBy = Util.GetUserIdByName(importJob, folder.CreatedByUserId, folder.CreatedByUserName);
if (folder.ParentId != null && folder.ParentId > 0)
{
//Find the previously created parent folder id.
folder.ParentId = CBO.FillObject <ExportFolder>(DotNetNuke.Data.DataProvider.Instance().GetFolder(portalId, folder.ParentFolderPath ?? ""))?.FolderId;
}
//ignore folders which start with Users but are not user folders.
if (!folder.FolderPath.StartsWith(DefaultUsersFoldersPath))
{
folder.FolderId = DotNetNuke.Data.DataProvider.Instance()
.AddFolder(importJob.PortalId, Guid.NewGuid(), folder.VersionGuid, folder.FolderPath,
folder.MappedPath, folder.StorageLocation, folder.IsProtected, folder.IsCached,
DateUtils.GetDatabaseLocalTime(),
createdBy, folderMapping.FolderMappingID, folder.IsVersioned, workFlowId,
folder.ParentId ?? Null.NullInteger);
}
//Case when the folder is a user folder.
else if (folder.UserId != null && folder.UserId > 0 && !string.IsNullOrEmpty(folder.Username))
{
var userInfo = UserController.GetUserByName(portalId, folder.Username);
if (userInfo == null)
{
folder.FolderId = 0;
return(false);
}
userInfo.IsSuperUser = false;
var newFolder = FolderManager.Instance.GetUserFolder(userInfo);
folder.FolderId = newFolder.FolderID;
folder.FolderPath = newFolder.FolderPath;
SyncUserFolder(importJob.PortalId, folder);
return(true);
}
else
{
folder.FolderId = 0;
return(false);
}
}
return(true);
}
protected override void Execute(CodeActivityContext context)
{
string message = "";
List <LogMessage> logList = new List <LogMessage>();
List <string> nonInvoices = new List <string>();
List <string> notConfidenceList = new List <string>();
message = "Loading FlexiCapture Engine for Recognition ...";
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
string documentProjectId = DocumentProjectId.Get(context);
message = "Get Document Project ID: " + documentProjectId;
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
int confidenceLevelLimitation = ConfidenceLevelLimitation.Get(context);
message = string.Format("Confidence Level Limitation: {0}", confidenceLevelLimitation);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
string sourceFolder = SourceFolder.Get(context);
message = string.Format("Get PDF folder: {0}", sourceFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
string ocrTemplate = OCRTemplateFolder.Get(context);
message = string.Format("OCR Template Folder: {0}", ocrTemplate);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
string exportFolder = ExportFolder.Get(context);
message = string.Format("Get Export Folder: {0}", exportFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
if (!Directory.Exists(exportFolder))
{
Directory.CreateDirectory(exportFolder);
message = string.Format("Folder {0} is created completely", exportFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
string recognizedFolder = RecognizedFolder.Get(context);
Console.WriteLine("Get Recognize Folder: " + recognizedFolder);
logList.Add(new LogMessage("Recognize Folder is: " + recognizedFolder, LogType.Information));
if (!Directory.Exists(recognizedFolder))
{
Directory.CreateDirectory(recognizedFolder);
message = string.Format("Folder {0} is created completely", recognizedFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
string notConfidenceFolder = NotConfidenceFolder.Get(context);
Console.WriteLine("Get Not Confidence Folder: " + notConfidenceFolder);
logList.Add(new LogMessage("Not Confidence Folder is: " + notConfidenceFolder, LogType.Information));
if (!Directory.Exists(notConfidenceFolder))
{
Directory.CreateDirectory(notConfidenceFolder);
message = string.Format("Folder {0} is created completely", notConfidenceFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
string rejectFolder = RejectFolder.Get(context);
Console.WriteLine("Get Reject Folder: " + rejectFolder);
logList.Add(new LogMessage("Reject Folder is: " + rejectFolder, LogType.Information));
if (!Directory.Exists(rejectFolder))
{
Directory.CreateDirectory(rejectFolder);
message = string.Format("Folder {0} is created completely", rejectFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
engine = LoadEngine(documentProjectId);
Boolean isRecognized = false;
bool isValidInvoice = false;
int count = 0;
int noError = 0;
int noSuccess = 0;
int noNotConfidence = 0;
try
{
message = "Creating and configuring the FlexiCapture Processor...";
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
processor = engine.CreateFlexiCaptureProcessor();
message = "Adding Document Definition to process...";
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
string[] TotalOCRFiles = Directory.GetFiles(ocrTemplate, "*.fcdot", SearchOption.AllDirectories);
if (TotalOCRFiles.Length == 0)
{
message = string.Format("OCR Template *.fcdot is not found in the folder {0}", ocrTemplate);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Error));
throw new Exception(message);
}
foreach (string ocr in TotalOCRFiles)
{
processor.AddDocumentDefinitionFile(ocr);
message = string.Format("OCR Temhplate {0} is added", ocr);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
message = string.Format("Adding images to process...");
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
string[] TotalFiles = Directory.GetFiles(sourceFolder, "*.pdf", SearchOption.AllDirectories);
if (TotalFiles.Length == 0)
{
message = string.Format("PDF Files *.pdf is not found in the folder {0}.", sourceFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Error));
throw new Exception(message);
}
foreach (string pdfFile in TotalFiles)
{
processor.AddImageFile(pdfFile);
message = string.Format("PDF Files {0} is added", pdfFile);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
message = "Recognizing the images and exporting the results...";
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
while (true)
{
// Recognize next document
confidenceLevel = 0;
confidenceDetailLevel = 0;
confidenceHeaderLevel = 0;
totalConfidenceLevelHD = 0;
IDocument document = processor.RecognizeNextDocument();
if (document == null)
{
IProcessingError error = processor.GetLastProcessingError();
if (error != null)
{
// Processing error
message = string.Format("processing error because of {0}.", error.MessageText());
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Error));
continue;
}
else
{
// No more images
message = string.Format("all PDF Files has been executed or no PDF file in the folder {0}", sourceFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
break;
}
}
else if (document.DocumentDefinition == null)
{
// Couldn't find matching template for the image. In this sample this is an error.
// In other scenarios this might be normal
message = string.Format("PDF file is not matched with existing OCR Templates.");
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Error));
//string tempPage = document.Pages[0].OriginalImagePath;
//if(tempPage != null)
//{
// string movefile = Path.GetFileName(tempPage);
// string tempfilename = Path.GetFileNameWithoutExtension(tempPage);
// logList.Add(new LogMessage("Move to Reject Folder", LogType.Information));
// if (File.Exists(tempPage))
// {
// MoveFileToDestinationFolder(sourceFolder, rejectFolder, tempPage, tempfilename);
// }
// else
// {
// MoveFileToDestinationFolder(notConfidenceFolder, rejectFolder, notConfidenceFolder+"\\"+movefile, tempfilename);
// }
//}
continue;
}
string originalPath = document.Pages[0].OriginalImagePath;
string file = Path.GetFileName(originalPath);
string filenamewithoutextention = Path.GetFileNameWithoutExtension(originalPath);
message = string.Format("Recognizing pdf {0} is started.", originalPath);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
//set confident level and status
message = string.Format("Extracting data from pdf {0} is started", originalPath);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
for (int i = 0; i < document.Sections.Count; i++)
{ // extracing
var section = document.Sections[i];
if (object.ReferenceEquals(section, null))
{
continue;
}
for (int d = 0; d < section.Children.Count; d++)
{
var child = section.Children[d];
if (object.ReferenceEquals(child, null))
{
continue;
}
var field = ((IField)child);
message = string.Format("Extracting column {0} = {1}", field.Name, field.Value.AsText);
Console.WriteLine(message);
if (field.Name.ToUpper().Trim() == "INV_CONFIDENCE_LEVEL")
{
var value = TextFieldHelper.GetConfidenLevel(engine, document);
totalConfidenceLevelHD = value;
var data = engine.CreateText(value.ToString(), null);
field.Value.AsInteger = value;
confidenceLevel = value;
message = string.Format("Confidence level of {0} is {1}", file, value);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
}
if (field.Name.ToUpper().Trim() == "INV_STATUS")
{
var value = "Recognized";
var data = engine.CreateText(value, null);
field.Value.AsText.Delete(0, field.Value.AsText.Length);
field.Value.AsText.Insert(data, 0);
}
if (field.Name.ToUpper().Trim() == "FILE_NAME")
{
var data = engine.CreateText(file, null);
field.Value.AsText.Delete(0, field.Value.AsText.Length);
field.Value.AsText.Insert(data, 0);
}
}
} //end extracting
isValidInvoice = true;
if (isValidInvoice)
{
message = string.Format("Total Confidence is {0} ", totalConfidenceLevelHD);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
//check confidence level validation
if (totalConfidenceLevelHD >= confidenceLevelLimitation)
{
try
{
message = string.Format("Exporting process for pdf {0} is started ...", file);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
//IFileExportParams exportParams = engine.CreateFileExportParams();
//Console.WriteLine("XLS");
//exportParams.FileFormat = FileExportFormatEnum.FEF_XLS;
processor.ExportDocument(document, exportFolder);
Console.WriteLine("Exporting process is completed ...");
MoveFileToDestinationFolder(sourceFolder, exportFolder, originalPath, filenamewithoutextention);
Console.WriteLine(string.Format("Moving {0} to Export folder {1} is completed", file, exportFolder));
logList.Add(new LogMessage("Exporting process is ended ...", LogType.Information));
noSuccess++;
}
catch (Exception e)
{
noError++;
Console.WriteLine(string.Format("exporting is failed because of {0}.", e.Message));
logList.Add(new LogMessage(message, LogType.Error));
MoveFileToDestinationFolder(sourceFolder, rejectFolder, originalPath, filenamewithoutextention);
message = string.Format("Moving pdf {0} to Reject folder {1} is completed", file, rejectFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
continue;
}
}
else
{
message = string.Format("Confidence of PDF {0} is {1} less than target confidence {2}", file, totalConfidenceLevelHD, confidenceLevelLimitation);
logList.Add(new LogMessage(message, LogType.Error));
notConfidenceList.Add(file);
logList.Add(new LogMessage(string.Format("Total number of not confidence is {0}", notConfidenceList.Count), LogType.Information));
MoveFileToDestinationFolder(sourceFolder, notConfidenceFolder, originalPath, filenamewithoutextention);
message = string.Format("Moving pdf {0} to Not Confidence folder {1} is completed", file, notConfidenceFolder);
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
noNotConfidence++;
}
}
count++;
}
var msg = processor.GetLastProcessingError();
if (msg != null)
{
var msgError = string.Format("the processing error because of {0}.", msg.MessageText());
Console.WriteLine(msgError);
logList.Add(new LogMessage(msgError, LogType.Error));
noError++;
}
message = string.Format("No. of Not Confidence {0} and No. of Error {1} and No. of Exported to DB {2}", noNotConfidence, noError, noSuccess);
logList.Add(new LogMessage(message, LogType.Information));
isRecognized = true;
}
finally
{
UnloadEngine(ref engine);
message = string.Format("Released FlexiCapture Engine for Recognition...");
Console.WriteLine(message);
logList.Add(new LogMessage(message, LogType.Information));
IsRecognized.Set(context, isRecognized);
NonInvoiceList.Set(context, nonInvoices);
Messages.Set(context, logList);
TotalExported.Set(context, noSuccess);
TotalError.Set(context, noError);
TotalNotConfidence.Set(context, noNotConfidence);
NotConfidenceList.Set(context, notConfidenceList);
}
}
