If you have jobs in another system or spreadsheet that you want to import into vWork you can import these in bulk using a CSV file. This saves time and reduces input errors - especially when you have a lot of jobs to create.
In this article
This article explains how to import job data from a CSV file. To find out how to prepare a CSV file for importing jobs please see the article, Prepare a CSV file to import data into vWork.
Topics covered in this article are:
- Things to consider when importing Jobs into vWork
- How to import jobs from a CSV file
- Consider using the API
You can click any link above to go directly to the topic you are interested in. You can return to this topic list at any time by clicking this icon.
Things to consider when importing Jobs into vWork
What you need to know about assigning workers and start times
- You create jobs in vWork when you import them. You’ll be able to view them in the Jobs tab and, if they have a worker assigned and/or a planned start time, also on the Schedule.
- Workers are assigned when their email is included in the job import information.
- Jobs are always created with a start time if they have a worker assigned to the job.
- The planned start time is always the time the job is created in vWork unless a specific start time is included in the import.
- You can save a job with a planned start time and keep it unassigned by leaving out the worker’s email in the CSV file.
When do you want jobs published?
- You can import jobs in a Draft state.
- When a job is in a Draft state no details are published to your workers until you manually publish the schedule. This is useful when you want to plan the schedule and shuffle jobs around to find the best fit before publishing jobs to your mobile workers.
- To create jobs with a Draft state add a column labeled “Import draft” to your CSV file. Use the value 't' for true (import in Draft state) or 'f' for false (do not import in Draft state).
Note: If you leave this field empty the job is not imported in Draft state. It will be published if it has a worker assigned to it in the job import.
How to import jobs from a CSV file
The job import process
Jobs are imported through the Jobs tab. When you import jobs from a CSV file you perform 2 steps:
- First, upload the CSV file into vWork.
- Next, match the specific data fields from the uploaded CSV file to the vWork job fields and run the import.
Upload the CSV file
Before you upload the job import CSV file make sure that it is ready for import. Take a look at the article, Prepare a CSV file to import data into vWork, for more information about how to set up the CSV file.
Note: You can import a maximum of 400 jobs in a single CSV file. If you want to import more jobs than this you can create multiple CSV files and import jobs in batches.
To upload the CSV file:
- Go to the Jobs tab.
- Click Import Jobs from the menu to open the CSV upload page.
- On the CSV upload page, click the drop-down list and select the job template that you want to use to create your jobs from step 1. Choose a template to use for your upload:.
In our example, we chose the Mobile car service job template.
- From step 2. Upload a CSV file:, click .
- Browse your computer to locate and select the job import CSV file.
Note: Once selected you can see the name of the CSV file next to the Choose File button.
- Click to upload the CSV file.
- As the file uploads, you will see the Start Matching button changes to Uploading.
- When the upload is complete the field matching page opens where you complete stage 2 of the Job Import process. The blue fields on the left correspond with the columns that you have in your job import CSV file. In this example, we have 7 columns in our CSV file.
Match the CSV job import fields to the job template fields
At this stage of the process, you begin matching the fields that contain the data from the CSV file to the corresponding fields in the selected job template.
- We only import data from the fields that you choose to match.
- Jobs are not created until you have completed the matching process and clicked Import Jobs. This means you can review where you have placed matched fields and adjust this before finalizing the job import.
💡Tip: If you want to geolocate a step in your job there are two important fields you must include in the CSV file;
- the formatted address for the step in one column - this shows the address in a format that is easy to read, and
- the corresponding Latitude and Longitude to match the address in a separate column - this is the actual location of the address on the map described in decimal degrees.
If you have multiple unique geolocated steps, you need to include separate columns for the formatted address and the combined latitude and longitude for each geolocated step.
To match the CSV fields to the vWork job template fields:
- Drag the first blue field that you want to match from the CSV fields on the left to the corresponding vWork job field on the right. Drop the CSV field in the corresponding job field. The vWork job field changes to green when the CSV field is matched, and the CSV field changes to light blue.
- Repeat step 1 for each field that you want to match.
💡Tip: If you accidentally drag a CSV field to the wrong job field you can click the X in the right-hand corner of the green box to remove the match.
- Once you have matched all fields from the CSV file to the vWork job template click to start creating the jobs in vWork.
- A warning shows to tell you how many jobs you are importing and how many fields you have mapped from the CSV file to the vWork job fields.
Click Accept to import the jobs.
- When you Accept the import, vWork returns to the Jobs tab and a banner displays at the top of the screen to tell you that the jobs are being imported. Depending on the number of jobs you are importing and the complexity of the job template this may take a while. The banner continues to display while the jobs are being imported. It shows the number of jobs created so you can track the job import progress. You can continue to do other tasks in vWork while the job import is processing. We’ll send you an email when the job import is complete.
Consider using the API
We also have a full API that can automate this process. If you want to find out more, the API documentation can be found here. Alternatively, send an email to firstname.lastname@example.org. We’ll get in touch to talk about your requirements.