The Import Worksheet is a form that is used during binary import of objects. If the import file contains only objects that are either new or have been updated, they will be imported. If, however, one or more objects with the same ID Property already exist, a decision must be made about what to do. The Import Worksheet displays information about both existing and new objects, and lets you decide how to handle conflicts.
The functions of the Import Worksheet (version check and so on) are only relevant for binary objects (files with a .fob extension). Objects in text format are always imported, regardless if they overwrite existing objects.
How to Import Objects
To import objects, do the following:
-
Click Tools and then click Object Designer.
-
Click File and then click Import.
-
In the Import Objects window, select the file that contains the binary objects from the dialog. These files have a .fob extension.
-
After you choose a file, it will be examined. Depending upon the contents of the file, one of the following occurs:
-
If the file contains new or updated objects only, you will be asked if you want to import it now. If you click Yes, the objects will be imported. If you click Cancel, the import will be aborted. If you click No, the Import Worksheet (described below) is displayed.
-
If there are conflicts, you will be informed of them and you can choose either to cancel the import or go to the Import Worksheet by clicking OK.
-
There are two kinds of conflicts. The first may occur if the version list numbers of the new and the existing objects are not the same. The second may occur if the default actions that were created by storing the Import Worksheet settings in the file with the objects are not valid because the versions of the objects in the database are different from when the file was created.
-
Default Actions in the Import File
The value of the Action option for each object in the Import Worksheet can be saved in the file with the objects. This means that how conflicts should be resolved can be decided when the file with the objects is created. When importing, you can choose to revise these settings by clicking No in the dialog box that appears after the file has been examined, or you can choose to import the objects.
If the assumptions that were made when the settings were saved are no longer valid, you must revise the settings. This is the case if the objects in your database are not the same as the objects that were used to create the file.
The Import Worksheet
Each line in the Import Worksheet displays information about one object and allows you to decide how to handle the object by setting the Action option. The following table shows the information that is displayed about each object, and, in addition, the Name, Modified, Version List, Size, Date, and Time fields are displayed on the form for the object that has the focus.
- Type
-
The type (such as form or report) of this object.
- No.
-
The ID of the object.
- Name
-
The name of the (new) object.
- New Object
-
This option is selected if this is a new object that was not in the database before.
- New Object Changed
-
This option is selected if the new object has been marked as changed.
- Existing Object Changed
-
This option is selected if the existing object has been changed, for example, the modified flag set or version list changed.
Note If a warning icon is displayed in this column, it means that there is a conflict that must be resolved before this object can be imported.
- Action
-
This option is the only field with contents that can be changed. This setting determines how a conflict will be resolved. The options are the following:
-
Create The new object will be added to the database. This option is only valid if no such object already exists.
-
Replace The existing object will be replaced by the new object.
-
Delete The existing object will be deleted and no new object created. This option is only valid if the new object has size 0. The intended use is to remove obsolete objects from the database.
-
Skip This object will not be imported.
-
Merge: Existing<-New Only valid for tables. All fields in the existing table will remain and any additional fields from the new object will be added.
-
Merge: New<-Existing Only valid for tables. All fields in the new table will be imported and any additional fields in the existing table will be added to the new table.
-
- Existing Object Modified
-
This option is selected if the existing object has the Modified field set to Yes.
- Existing Object Version List
-
The version list of the existing object.
- New Object Modified
-
This option is selected if the new object has the Modified field set to Yes.
- New Object Version List
-
The version list of the new object.
Using the Import Worksheet
For each object, you can choose an action, given the constraints outlined in the preceding table. You can apply these actions by clicking the appropriate buttons.
Action | Definition |
---|---|
OK |
Perform the import according to the current settings in the worksheet. |
Cancel |
Cancel the import. |
Replace All |
Set Action for all objects to Replace. |
Save As |
Save the current settings in the worksheet in the import file, together with the objects. |
Help |
Display the Help topic. |
© 2010 Microsoft Corporation. All rights reserved.