Import Data window

<< Click to Display Table of Contents >>

Navigation:  PerfectTablePlan 6.0.0 > Reference > User interface > Windows >

Import Data window

The import_16Import Data window allows you to import data into your plan from other applications, for example from an CSV or text file. This can save you a lot of typing. To display this window select File>import_16 Import... or the equivalent Insert tool bar button. The import_16Import window will be displayed. Select CSV/text file and click OK. An Open window will be displayed. Select the file you wish to import. The import_16Import Data window will be displayed.

Note PerfectTablePlan cannot read Excel files on Mac, you will have to convert it to a .csv which PerfectTablePlan can read. Renaming a file from .xls/.xlsx to .csv will not work.

Mapping imported columns to guest properties

Setting up common titles and suffixes will often help PerfectTablePlan to make better sense of the data you are importing. Click on the Titles and Suffixes buttons to set your preferences.

Select File type to import a pre-defined file type. Select custom to define your own. Click on the more_button_m button to show more options.

Map imported columns to guest properties shows you how the file data will be imported, including the effects of various options described below.

If you have selected the File type as custom you need to tell PerfectTablePlan which columns in the import file correspond to which guest properties. Select from the drop-down lists at the top of each column to do this. For example column 1 might correspond to the guest title, column 2 column to the guest last name and the column 4 column to the guest meal choice. Leave the drop-down list as <ignore> to ignore the contents of a column.

import_1_m

Empty lines in your import file are ignored.

If you have multiple guests in one row or the title, first name, last name or suffixes are not in separate columns, PerfectTablePlan will do it's best to unravel them. For example it can handle all the following:

import_2_m

If title is imported, but not gender or age, the import will attempt to guess the gender or age from the title using the titles set in the prefs_16Preferences window.

Note You can edit information in the table. This will change the information imported, but not affect the contents of the file you are importing. Make sure you press Enter to confirm any edits before clicking on Apply or OK.

Text is imported directly except for Gender, Age, VIP and RSVP, which are based on the values below:

Column

Values

Gender

Text must start with:

'F' or 'f' for a female

'M' or 'm' for male

otherwise the guest is imported with unknown gender

Age

Text must start with:

'C' or 'c' for a child

otherwise the guest is imported as an adult

VIP

Text must start with:

'V', 'v', 'Y' or 'y' for a VIP

otherwise the guest is imported as an non-VIP

RSVP

Text must be:

'Arrived' for arrived, case unimportant

'Opened', 'Unopened', 'Delivered' or 'Unconfirmed' for sent, case unimportant (for integration with paperlesspost.com, pingg.com and zankyou.com)

'Confirmed' for accepted, case unimportant (for integration with zankyou.com)

'Not coming' or 'Regrets' for declined, case unimportant (for integration with paperlesspost.com and zankyou.com)

Or else start with:

'S' or 's' for sent

'A', 'a', 'Y' or 'y' for accepted

'C' or 'c' for cancelled

'D', 'd', 'N' or 'n' for declined

Otherwise the RSVP status is unset.

Import this row

The row will not be imported if the cell contents are empty or contain text beginning with 'N', 'n', 'F' or 'f'.

You can easily edit any of these properties at a later point.

Advanced and Professional editions only

Importing custom fields

You can import custom fields as below:

Type

Value

Yes/No

'1' or text starting with 'y' or 't' (not case sensitive) imported as 'yes'

'0' or text starting with 'n' or 'f' (not case sensitive) imported as 'no'

Otherwise set to default

Text

Text imported

Number

Valid whole numbers imported

Otherwise set to default

Currency

Valid whole numbers or decimal numbers imported

Otherwise set to default

Selection

Allowed selections imported

Otherwise set to default

Tags

Text imported

If you want to import into a custom field that you haven't already created, select <custom field> from the drop-down list. This will create a new custom field for you. It will also do its best to guess the correct type and to set the allowed values for a custom field of type Selection.

import_custom_field_m

Saving mappings

If you create a new import mapping you will be given the option to save it for use as a new File type. This will then be available the next time you import.

Note If your import mapping contains custom fields, then you must ensure that these custom fields exist in your plan before you use the import mapping.

Importing groups

If you wish to import guests as couples, families and/or groups you need to:

1.have a group column in your input data

2.use the same name in the group column for each person in the couple, family or group

3.make this column the group field during import

import_3_m

If group consecutive guests with same last name is checked then consecutive guests with the same last name will be added to the same group. This can be useful for family events. This option is not available if you have set a group column.

You can choose the proximity to use for members of the same group from the Proximity for guests in the same group drop-down list.

import_data_proximity_m

The Num. guests field is the number of anonymous guests to be added to the names imported. It can be from 0 to 999. For example, if the guest is "John Smith" and Num. guests field is 2 the guests "John Smith" and 2 anonymous guests will be added (all in the same group).

1_name_per_1_col_and_n_total_m

The Num. in group field is the total number of guests in the group, including any named guests. It can be from 0 to 999. For example, if the guest is "John Smith" and Num. in group field is  4 the guests "John Smith" and 3 anonymous guests will be added (all in the same group). If Num. in group is fewer than the number of named guests, it will be ignored.

Note You can set the Num. guests or Num. in group column, but not both.

You can easily change the grouping of guests later by dragging them to another group in the couple_16Groups pane.

Professional edition only

Importing seating data

You can specify the guest table or table+seat during import. You must create tables with the appropriate names and numbers of seats before you import guests.

import_5_m

For more information see Import seating data.

videoVideo with audio (0:25 minutes)

Importing guest proximities

You can specify which guests to sit near to (or away from) during import. Guests can be referred to by name, ID or group.

import_proximity_m

For more information see Import proximity data.

Importing guest IDs

Select ID to designate a column as containing the unique identifier for guests. The identifier can be any unique string of characters of any length. The guest will keep this identifier right through to saving or exporting the plan, even if their name is changed. If you don't have an ID column guests will be assigned unique identifiers by PerfectTablePlan.

Further options

Location shows the location of the import file. Click on the Choose... button to change the file you wish to import.

Use Ignore first if you wish to ignore one or more rows in the file. Often the first row is a header and you won't want to import it.

Use the Format drop-down list to choose whether the imported file is in CSV format or a custom format (e.g. columns separated by Tab characters). If you are using a custom format, set Column separator and Row separator to the field and record separators in the import file.

Check group consecutive guests with same last name if you want to automatically assign consecutive guests with the same last name into the same group. This option is not available if you have selected a group column.

Uncheck single guest per cell if some rows might contain names of multiple guests e.g. if you want to interpret "Mr & Mrs Smith" as separate guests "Mr Smith" and "Mrs Smith".

Click on Add row to add an additional row to be input. This is useful if you want to type in the data for additional guests. If a row is selected the new row will be added below, otherwise it will be added to the end.

Click on Delete row to delete the currently selected row.

Click on Add column to add an additional column to be input. This is useful if you want to type in some additional data for each guest, e.g. their gender or group. If a column is selected the new row will be added to the right, otherwise it will be added to the end.

Click on Split column(s)... to split one or more selected columns into multiple columns. Click on Join columns... to join two or more selected columns into a single column. See below for more details.

Click on Delete column to delete the currently selected column.

Splitting and joining columns

When you are importing it can be useful to split and join columns. For example you might want to  split a column in the format "name, company" into two separate columns "name" and "company", so you can import them into separate fields in PerfectTablePlan. You can carry out multiple split and join operations to get the data into the appropriate format.

For more details see joining and splitting columns.

Buttons

Click OK to import the data and close the window. Click Cancel to discard the changes.

See also:

Importing

Quick Add Guests window

Importing guests from Apple Address Book

Importing guests from Excel files

Importing guests from text and CSV files

Importing guests from vCards

Example import formats