Skip to main content

Setting Source Format Mapping Destinations Programmatically

Using your browser console, it's possible to set the mapping destination in a Source Format without using the mouse. This is especially useful when setting up the All CAS by Liaison - Applications source format with its thousands of columns.

Video Demo

Examples

Simplest Way to Set a Destination

$('.dialog_closeable:not(.hidden) select.build_field').val("field:hispanic");

image.png

Setting the Group

$('.dialog_closeable:not(.hidden) input.build_ordinal').val(2);

Setting Up a Field Fusion

This will map the supervisor first name and supervisor last name to Job Supervisor in Group 2.

$('.dialog_closeable select[name="src1"]').val("suppInfo.expe.expe2.supervisorFirstName");
$('.dialog_closeable select[name="src2"]').val("suppInfo.expe.expe2.supervisorLastName");
$('.dialog_closeable:not(.hidden) select.build_field').val("job:supervisor");
$('.dialog_closeable:not(.hidden) input.build_ordinal').val(2);

image.png

Set a Field, Save and Next

For maximum efficiency, find all the fields of a certain type, map them using this script without having to touch the mouse, and then move on to the next field. For example, you might map all experience start dates, then all end dates, then all titles, etc.

This only works if you can filter to find only the exact Source Fields you need to map. In this example, searching suppInfo.expe.expe .avgWeeklyHrs works!ย Sometimes this technique isn't perfect. For example, suppInfo.expe.expe .type will also findย .typeId. Extending this JavaScript to such situations is left as an exercise to the reader.

First, set i=0; or whatever group you're currently on. i++ will increment i by one. Press the Up arrow key in your console to get this script back over and over.

i++;
$('.dialog_closeable:not(.hidden) select.build_field').val("job:hours");
$('.dialog_closeable:not(.hidden) input.build_ordinal').val(i);
$('.dialog_closeable:not(.hidden) button.icon-right.build_dialog_save').click();

image.png

Here's a version for a Job Supervisor field fusion:

i++;
$('.dialog_closeable select[name="src1"]').val("suppInfo.expe.expe" + i + ".supervisorFirstName");
$('.dialog_closeable select[name="src2"]').val("suppInfo.expe.expe" + i + ".supervisorLastName");
$('.dialog_closeable:not(.hidden) select.build_field').val("job:supervisor");
$('.dialog_closeable:not(.hidden) input.build_ordinal').val(i+1);
$('.dialog_closeable:not(.hidden) button.icon-right.build_dialog_save').click();