![]() For example you can specify that columns in the import file are separated by Tab characters, rather than commas: These options give you full control over how the import file is interpreted. If you are importing data in a format PerfectTablePlan already knows about you can select the format from the File type menu:Ĭlick on the button in the Import data window to show additional options. You can also import many other properties, such as addresses, meal choice, VIP status, RSVP status etc. The guests have now been imported in the groups you specified and an unnamed guest has been added for Mr Alan Black. Select the property drop-down lists as shown below. Add an additional group column and guest column to your spreadsheet, as below.įile>Save as to guests2.csv and import into PerfectTablePlan (as above). Select File> New to clear the current plan. You can also specify unnamed guests to import. If you want more control over groups you can add a group column to your spreadsheet. If you look in the Proximity pane you will see it has set proximity for the guests in each group. If you don't like how they have been grouped you can easily drag guests between groups in Drag and drop mode in the Groups pane. Note that Mr Alan Black and Miss Erica Black have been placed in the same group because they were listed one after the other with the same last name. The email address has been added to the guest Contact information. If it has guessed anything wrong you can easily change it in Edit mode. PerfectTablePlan has used title preferences to extract titles and guess age and gender. The guests should now be imported as below. Note that you can edit the data in the table before you import it. Select from the drop-down lists as shown below. We now need to tell PerfectTablePlan which columns correspond to which guest properties. You should now see the contents of the Excel file in the Import data window. csv file you just created and click Open. The Import window will appear.Įnsure text/CSV file is selected and click the OK button. If PerfectTablePlan is running create a new plan by selecting File> New. The data is now in a format PerfectTablePlan can read. Click OK on any windows warning you about changing format. csv file guests.csv (do not just rename a. xls files as they are in a proprietary binary format. Note The user interface of Excel may differ between different versions.Ĭreate a simple Excel spreadsheet like the one below: The principles are similar for other applications and file formats. We will illustrate this by importing some guest details from Excel. ![]() You can import guest details from spreadsheets, databases and other formats, so that you don't have to re-type them. The tutorial is also on your CD, if you purchased one. Note You can also view this tutorial as a movie on our website.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |