Export (0) Print
Expand All

Import Worksheet

Microsoft Dynamics Nav 2009

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.

To import objects, do the following:

  1. Click Tools and then click Object Designer.

  2. Click File and then click Import.

  3. In the Import Objects window, select the file that contains the binary objects from the dialog. These files have a .fob extension.

  4. 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.

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.

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.

NoteNote

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.

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.

Community Additions

ADD
Show:
© 2014 Microsoft