protected override async Task ProcessBatchAsync(ImportExecuteContext context, CancellationToken cancelToken = default)
{
var segmenter = context.DataSegmenter;
var batch = segmenter.GetCurrentBatch <Customer>();
using (var scope = new DbContextScope(_services.DbContext, autoDetectChanges: false, minHookImportance: HookImportance.Important, deferCommit: true))
{
await context.SetProgressAsync(segmenter.CurrentSegmentFirstRowIndex - 1, segmenter.TotalRows);
// ===========================================================================
// Process customers.
// ===========================================================================
try
{
await ProcessCustomersAsync(context, scope, batch);
}
catch (Exception ex)
{
context.Result.AddError(ex, segmenter.CurrentSegment, nameof(ProcessCustomersAsync));
}
// Reduce batch to saved (valid) records.
// No need to perform import operations on errored records.
batch = batch.Where(x => x.Entity != null && !x.IsTransient).ToArray();
// Update result object.
context.Result.NewRecords += batch.Count(x => x.IsNew && !x.IsTransient);
context.Result.ModifiedRecords += batch.Count(x => !x.IsNew && !x.IsTransient);
// ===========================================================================
// Process customer roles.
// ===========================================================================
if (segmenter.HasColumn("CustomerRoleSystemNames"))
{
try
{
await ProcessCustomerRolesAsync(context, scope, batch);
}
catch (Exception ex)
{
context.Result.AddError(ex, segmenter.CurrentSegment, nameof(ProcessCustomerRolesAsync));
}
}
// ===========================================================================
// Process generic attributes.
// ===========================================================================
try
{
await ProcessGenericAttributesAsync(context, scope, batch);
}
catch (Exception ex)
{
context.Result.AddError(ex, segmenter.CurrentSegment, nameof(ProcessGenericAttributesAsync));
}
// ===========================================================================
// Process avatars.
// ===========================================================================
if (_customerSettings.AllowCustomersToUploadAvatars)
{
try
{
await ProcessAvatarsAsync(context, scope, batch);
}
catch (Exception ex)
{
context.Result.AddError(ex, segmenter.CurrentSegment, nameof(ProcessAvatarsAsync));
}
}
// ===========================================================================
// Process addresses.
// ===========================================================================
try
{
await ProcessAddressesAsync(context, scope, batch);
}
catch (Exception ex)
{
context.Result.AddError(ex, segmenter.CurrentSegment, nameof(ProcessAddressesAsync));
}
if (segmenter.IsLastSegment)
{
AddInfoForDeprecatedFields(context);
}
}
await _services.EventPublisher.PublishAsync(new ImportBatchExecutedEvent <Customer>(context, batch), cancelToken);
}
public async Task ExecuteAsync(ImportExecuteContext context, CancellationToken cancelToken)
{
var currentStoreId = _services.StoreContext.CurrentStore.Id;
var segmenter = context.DataSegmenter;
var batch = segmenter.GetCurrentBatch <NewsletterSubscription>();
using (var scope = new DbContextScope(_services.DbContext, autoDetectChanges: false, minHookImportance: HookImportance.Important, deferCommit: true))
{
await context.SetProgressAsync(segmenter.CurrentSegmentFirstRowIndex - 1, segmenter.TotalRows);
foreach (var row in batch)
{
try
{
NewsletterSubscription subscription = null;
var email = row.GetDataValue <string>("Email");
var storeId = row.GetDataValue <int>("StoreId");
if (storeId == 0)
{
storeId = currentStoreId;
}
if (row.HasDataValue("Active") && row.TryGetDataValue("Active", out bool active))
{
}
else
{
active = true; // Default.
}
if (email.IsEmpty())
{
context.Result.AddWarning("Skipped empty email address.", row.RowInfo, "Email");
continue;
}
if (email.Length > 255)
{
context.Result.AddWarning($"Skipped email address '{email}'. It exceeds the maximum allowed length of 255.", row.RowInfo, "Email");
continue;
}
if (!email.IsEmail())
{
context.Result.AddWarning($"Skipped invalid email address '{email}'.", row.RowInfo, "Email");
continue;
}
foreach (var keyName in context.KeyFieldNames)
{
switch (keyName)
{
case "Email":
subscription = await _services.DbContext.NewsletterSubscriptions
.OrderBy(x => x.Id)
.FirstOrDefaultAsync(x => x.Email == email && x.StoreId == storeId, cancelToken);
break;
}
if (subscription != null)
{
break;
}
}
if (subscription == null)
{
if (context.UpdateOnly)
{
++context.Result.SkippedRecords;
continue;
}
subscription = new NewsletterSubscription
{
Active = active,
CreatedOnUtc = context.UtcNow,
Email = email,
NewsletterSubscriptionGuid = Guid.NewGuid(),
StoreId = storeId
};
_services.DbContext.NewsletterSubscriptions.Add(subscription);
context.Result.NewRecords++;
}
else
{
subscription.Active = active;
context.Result.ModifiedRecords++;
}
}
catch (Exception ex)
{
context.Result.AddError(ex.ToAllMessages(), row.RowInfo);
}
}
await scope.CommitAsync(cancelToken);
}
await _services.EventPublisher.PublishAsync(new ImportBatchExecutedEvent <NewsletterSubscription>(context, batch), cancelToken);
}
