Import Worksheet
When you import objects from a binary file (.fob), if there are conflicts with objects that exist in the database with the same ID, then you use the Import Worksheet to resolve the conflicts. If the import file contains only objects that are new, then the objects are imported.
If you import objects from a .txt file, then the objects in the file overwrite any existing objects in the database.
You use the Import Worksheet when you import objects by using the UI in the development environment. For more information about how to import objects, see How to: Import Objects.
Default Actions in the Import File
The value of the Action column for each object in the Import Worksheet can be saved in the .fob file with the objects by choosing the Save As button in the Import Worksheet. When you import a .fob file, in the dialog box, you can choose the Yes button to import all objects and use the actions that are saved in the .fob file, or choose the No button to open the Import Worksheet and revise the action for any object in the file.
The Import Worksheet
Each line in the Import Worksheet displays information about one object. You decide how to handle the conflict by choosing an action in the Action column. The following table shows the information that is displayed about each object in the import file.
| Object | Description |
|---|---|
Type |
The type of this object. The type is one of the following:
|
No. |
The ID of the object. |
Name |
The name of the object. |
New Object |
Specifies if the object to import is a new object that does not exist already in the database. |
New Object Changed |
Specifies if the new object to import has been marked as changed. |
Existing Object Changed |
Specifies if the object to import is an existing object that has been changed, for example, the Modified field is set or the Version List is changed. |
Warning |
Specifies if there is a conflict that must be resolved before this object can be imported. |
Action |
Specifies how the conflict will be resolved. This is the only field that you can change The options are the following:
CreateThe new object will be added to the database. This option is only valid if no such object already exists.
ReplaceThe existing object will be replaced by the new object.
DeleteThe 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.
SkipThis object will not be imported.
Merge: Existing<-NewOnly valid for tables. All fields in the existing table will remain and any additional fields from the new object will be added.
Merge: New<-ExistingOnly 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 |
Specifies if the existing object has the Modified field set. |
Existing Object Version List |
The version of the existing object. |
New Object Modified |
Specifies if the new object has the Modified field set. |
New Object Version List |
The version of the new object. |
In addition, the Name, Modified, Version list, Size, Date, and Time fields are displayed in the window for the object that is selected.
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 choosing 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 in the worksheet to Replace. |
Save As |
Save the current settings in the worksheet in the import file, together with the objects. |
Help |
Display the Help topic. |