If you already have travel arrangements organized within files or databases, you can use EventPro Planner’s import feature to avoid manual data entry and save time. You can import these bookings into the Attendees |Travel tab in the Event Maintenance screen.
You can import travel bookings from a variety of sources: CSV (Comma Separated Values) file, Microsoft Excel file (.xls. or .xlsx), or Microsoft Access Database (Use Table Name or SQL Statement).
2.
Select the radio button next to the import method you want to use.
3.
Click the Open icon to the left of the Import File field. Locate the file and click Open.
4.
If you are using a Microsoft Access Database, type in a Table Name or SQL Statement.
This next screen will allow you to review the imported data and associate it with fields in the program.
1.
The list of Import Table Fields on the right displays all fields in the program into which you can import data. The selection grid on the left, Imported Data,represents a table view of the data you are importing.
2.
The travel records you are importing must refer to Attendees already added to the event, and the attendee names in the import file must exactly match the names in the event. Also, if you include other companies in the import, such as Carriers, the company names in the import file must match the company names in the program.
3.
If you have any saved templates, you can select one from the Template drop-down list.
4.
If you are not using an existing template, you must indicate the fields into which you want the data placed. Select a field on the right and drag it onto the corresponding column in the left pane. The data from the column will be imported into that field. Continue dragging and dropping fields onto the corresponding columns until you have created a complete template for the import.
5.
If you want to save your newly created template for future use, click Save Template, enter a Description for the template and click OK.
6.
Click Next.
7.
If you attempt to introduce some new information through the import, such as a new Carrier, the Confirm dialog will warn you that the record does not exist in EventPro Planner. You can click OK to continue with the import, but the record related to the new attendee or carrier will not be converted or imported.
This of the wizard will be populated with data for your review.
1.
Scroll to the right to review all of the converted data. You can click on a heading (Travel Type, Last Name, Carrier, etc.) to sort the list by that heading.
2.
From this screen, you can also make data changes that will apply to all or selected travel records. For example, you will not be able to post the data unless all travel records have been assigned a LegType and Travel Type, so you may need to add a leg and travel type to all travel records.
a.
If you do not want to apply the changes to all travel records, select multiple records by holding down the Ctrl key and clicking on the desired records. You can also limit the number of records that are visible by clicking the Set Filter button.
b.
After you have selected records, if necessary, click the Multi-Edit button. The Attendee Travel Multi-Edit window will appear. Make any changes you like, but remember that the new values will overwrite the original values for all selected travel records.
c.
Click Save. Choose whether you want to add the new information to Selected Attendees or All(Filtered) Attendees and click OK.
3.
If you do not want to import certain travel records in the selection grid, you can delete the records from the list.
a.
Click to highlight the record or select multiple records.
b.
Click the Multi-Delete button.
c.
The Confirm dialog will ask if you want to delete the selected records. Click Yes to continue deleting.
