if ( NOT StructKeyExists(request.params, "action") ) request.params.action = "form"; renderStats = false; if ( StructKeyExists(request.params,"stats") AND IsBoolean(request.params.stats) ) renderStats = request.params.stats; enableOneWaySync = application.ptProfile.getOneWaySyncStatus(); // true = removes profiles from CS - "one-way sync" (not just an "import" of the external data) processName = 'Profile-Bulk-Import'; processSchedule = application.ADF.scheduler.getScheduleStatus(processName); processStatus = 'nonexistant'; if ( StructKeyExists(processSchedule,"status") AND LEN(TRIM(processSchedule.status)) ) processStatus = processSchedule.status; processRunningMsg = "A Bulk Import Process is currently running! The 'Start Process' button as been deactivated."; statsLoadingMsg = "Loading... may take a few seconds to calculate."; application.ptProfile.scripts.loadFontAwesome(); application.ptProfile.scripts.addHeaderCSS(headerCSS,"TERTIARY"); application.ptProfile.scripts.addFooterJS(footerJS,"TERTIARY"); recordsToImport = 0; recordsToRemove = 0; if ( renderStats ) { extProfileQry = application.ptProfile.profileService.getExternalProfileData(); extProfileQry = application.ptProfile.profileService.scanProfileDataForChanges(qry=extProfileQry); recordsToImport = extProfileQry.RecordCount; if ( enableOneWaySync ) { syncProfileQry = application.ptProfile.profileService.afterImportCleanUpProfileQry(); recordsToRemove = syncProfileQry.RecordCount; } }

Configure Bulk Import Processing

Display External Data Records
Refresh Sync Statistics #statsLoadingMsg#
Records To Import/Update: #recordsToImport# - Display Records to be Imported/Updated
Records To Remove: #recordsToRemove#
Get Sync Statistics #statsLoadingMsg#
#processRunningMsg#
Check Bulk Import Processing Status
#Server.CommonSpot.UDF.tag.input(type="hidden", name="CSRF_Token", value=application.ptProfile.csSecurity.getCSRF_Token())#

Number of items per Batch:

Minutes to Pause:

Restart Processing:

Restart at Position:

class="disabled" disabled="true">

#processRunningMsg#

Error:User session could not be validated! Record could not be deleted.

// Check the Total value if ( NOT StructKeyExists(request.params, "total") ) request.params.total = 'ALL'; // Check the Update Check value if ( NOT StructKeyExists(request.params, "check") ) request.params.check = 'pre-schedule'; // Check the count if ( NOT StructKeyExists(request.params, "count") ) request.params.count = 1; // Check the pause minutes if ( NOT StructKeyExists(request.params, "pause") ) request.params.pause = 5; // Check if continuous scheduled process if ( NOT StructKeyExists(request.params, "cont") ) request.params.cont = false; // Check if continuous scheduled process if ( NOT StructKeyExists(request.params, "restart") ) request.params.restart = false; // Check if restart position if ( NOT StructKeyExists(request.params, "start") OR ( request.params.start LTE 0 ) ) request.params.start = 0; // Check if restart is checked if ( NOT request.params.restart ) request.params.start = 0; // Start the processing if ( processStatus NEQ 'active' ) { try { application.ptProfile.profileService.autoImportUpdate(restart=request.params.restart,passCount=request.params.count,scheduleProcess=request.params.cont,delayMinutes=request.params.pause,startAt=request.params.start); } catch(any ex) { WriteOutput("Error: " & ex.message); WriteDump(var=ex,expand=true); } }

Bulk Import Processing Activated

Process Started and Batch Scheduled

Check Bulk Import Processing Status | Return to the Form

Bulk Import Processing Status

#application.ptProfile.scheduler.getScheduleHTML(scheduleName=processName,doAjaxRefresh=true,refreshRate=10)#
Refresh Processing Status | Return to the Form

extProfileQry = application.ptProfile.profileService.getExternalProfileData(); outQry = application.ptProfile.profileService.scanProfileDataForChanges(qry=extProfileQry,logDiffs=true); //writedump(var=outQry); //writedump(var=outQry,top=100); cols = outQry.ColumnList; rows = outQry.RecordCount;

Output of Records to be Imported/Updated

Return to the Form

#rows# Records 1 Record
ROW #col#
#outQry.CurrentRow#. #outQry[col][outQry.CurrentRow]#
No Import/Update Records Found!


Return to the Form

outQry = application.ptProfile.profileService.getExternalProfileData(); //writedump(var=outQry); //writedump(var=outQry,top=100); cols = outQry.ColumnList; rows = outQry.RecordCount;

Output of External Data

Return to the Form

#rows# Records 1 Record
ROW #col#
#outQry.CurrentRow#. #outQry[col][outQry.CurrentRow]#
No Data Found!


Return to the Form

An error with your request.

Please try again