Are you having difficulty with the reference fields? It depends a lot on how you want to do it, but the reference fields require you to provide some unique identifier. That can be a sys_id or a serial number. Here is some code I used to import users' department information. If the department already exists, then it just sets the department ID and moves on. If the department doesn't exist, then a new one is created. You need to become familiar with GlideRecord and how to build a GlideRecord query.
This script had the reference value field name set to "id"
// Associate Department with User. Create new department or update department name if necessary
// Check if the Department already exists
if (!source.u_department_id.nil() && !source.u_department_name.nil()) {
var dept_gr = new GlideRecord("cmn_department");
var dept_id = source.u_department_id;
dept_gr.addQuery('id', dept_id);
dept_gr.query();
if (!dept_gr.next()) { // if department does not exists create a new Department and associate it with the user
dept_gr = new GlideRecord("cmn_department");
dept_gr.name = source.u_department_name;
dept_gr.id = source.u_department_id;
dept_gr.update(); // Create the department
} else {
if (dept_gr.name != source.u_department_name) { // if the department name has changed
dept_gr.name = source.u_department_name; // change the name
dept_gr.update(); // Update the department
}
}
answer = dept_id; // associate the department with the user
}
Does this get you any closer to what you are looking for? Do you have any more specific questions? I tried to guess where you might be running into some trouble. You will need to do something similar for setting the vendor to IBM. You can set the value using a script, but it's even simpler. You just need answer = "IBM" assuming IBM is already in the table and IBM is the display value.
In the import set for your date, there is a field called Date format that you need to set to match your date format on your source.
