Delete object in Import Worksheet

gma · 2006-05-13

Does anyone know how to create a "killer object" with size 0 and to use that object to delete objects in database with import worksheet?
Thanks
gma

kriki · 2006-05-13

If you want to delete objects, you can just delete them from the object designer. I hope this ansers you question, because I didn't understand exactly what you wanted.

DenSter · 2006-05-13

:shock: what? A killer object? Where did you get that idea?

gma · 2006-05-15

I know that I can delete the object directly in the object designer but if I want to delete the same object in different databases I have to repeat the same delicate operation.
If you see at the help you see that It's possible to use the delete option using a killer object of size 0.
I don't know how to create an object of size 0.

gjgarciasm · 2006-09-12

Hi,

I need create a killer object also but I don´t how to do it. ](*,)

Does anybody know anything about this topic?

Please, it is very important for me.

Thank you.

Luc_VanDyck · 2006-09-12

gma wrote:

If you see at the help you see that It's possible to use the delete option using a killer object of size 0.

Please show us the relevant help text.

DenSter · 2006-09-12

Open the C/SIDE reference guide and search for the word 'killer', which will display the help text for the import worksheet

I have no idea how you would create such a killer object.

Alex_Chow · 2006-09-12

DenSter wrote:

Open the C/SIDE reference guide and search for the word 'killer', which will display the help text for the import worksheet I have no idea how you would create such a killer object.

Holy crap... 8 years of Navision experience and this is the first time I know about tihs.

matteo_montanari · 2006-09-12

deadlizard wrote:

DenSter wrote:

Open the C/SIDE reference guide and search for the word 'killer', which will display the help text for the import worksheet I have no idea how you would create such a killer object.

Holy crap... 8 years of Navision experience and this is the first time I know about tihs.

OBJECT Codeunit 50000 Killer Form Creator
{
  OBJECT-PROPERTIES
  {
    Date=13/09/06;
    Time=[ 1.36.03];
    Modified=Yes;
    Version List=;
  }
  PROPERTIES
  {
    OnRun=BEGIN
            Object.Type := Object.Type::Form;
            Object.ID := 50000;
            Object.Name := 'Killer Form';
            Object.INSERT;
          END;

  }
  CODE
  {
    VAR
      Object@1000000000 : Record 2000000001;

    BEGIN
    END.
  }
}

Import this code as a text file object in a cronus database
Compile Codeunit 50000 and run.
Search Form 50000 and save as a FOB
Delete Form 50000
Create a simple form 50000
Import your FOB

Matteo

ta5 · 2006-09-13

Hi Matteo
I still dont understand. :oops:
What happens?

Thomas

matteo_montanari · 2006-09-13

ta5 wrote:

Hi Matteo
I still dont understand. :oops:
What happens?

Thomas

When you import the fob with a 0 size object, Import Worksheet suggest "Delete" instead of "Replace" the existing object.

My example show how to create a 0 sized object.

Matteo

wakestar · 2006-09-13

Very interesting

... but it would be more useful to know how to delete objects which are not in the license :roll:

Marije_Brummel · 2006-09-13

wakestar wrote:

... but it would be more useful to know how to delete objects which are not in the license :roll:

Why do you want that? Are they in your way?

Marije_Brummel · 2006-09-13

Eto wrote:

When you import the fob with a 0 size object, Import Worksheet suggest "Delete" instead of "Replace" the existing object.

My example show how to create a 0 sized object.

Matteo

Good tip! I did not now that.

It should be in the Tips and Tricks selection.

wakestar · 2006-09-13

Mark Brummel wrote:

wakestar wrote:

... but it would be more useful to know how to delete objects which are not in the license :roll:

Why do you want that? Are they in your way?

YES, they are

We wrote our own tools for exporting navision objects automatically (for different purposes). It works very well, except when there is an object which is not in the license....

Marije_Brummel · 2006-09-13

Do you mean custom objects or standard NAV objects?

You cannot delete all standard NAV objects that are not in the license. This wil cause compile errors all over the database.

BTW, your tool sounds intersesting! How have you done this? Care to share the solution?

wakestar · 2006-09-13

Custom Objects... not Standard NAV Objects

It is all done with SENDKEYS... of course the user has to follow some "rules" like not changing the order of the fields in the object designer, because the tool automatically sets the filters.

Marije_Brummel · 2006-09-13

OK, I understand.

Isn't it possible to check the License Permission table in your routine? This way you might avoid to touch object that are not in the license.

wakestar · 2006-09-13

theoretically yes,

but because it is an external application (VB) which 'commands' the client, it is not that easy to read the table in navision. And at the end it is an 'In-house' Application... what means that nobody wants to pay for it

gjgarciasm · 2006-09-18

Eto wrote:

...

Import this code as a text file object in a cronus database
Compile Codeunit 50000 and run.
Search Form 50000 and save as a FOB
Delete Form 50000
Create a simple form 50000
Import your FOB

Matteo

Thank you!!!

It works. It is perfect.

Alex_Chow · 2006-09-18

Mark Brummel wrote:

Eto wrote:

When you import the fob with a 0 size object, Import Worksheet suggest "Delete" instead of "Replace" the existing object.

My example show how to create a 0 sized object.

Matteo

Good tip! I did not now that.

It should be in the Tips and Tricks selection.

:?: What would be a practical use of a 0 size object?

gma · 2006-09-28

The solution shown by Eto works very well.
Thanks
Giuseppe

G-Raj · 2007-03-15

Another way for this...

Export the object as .txt.
Delete every thing inside it except the start and the end brace.
Import the txt file. The object will get deleted automatically and will not even for a confirmation.

\:D/

Phenno · 2007-07-05

G-Raj wrote:

Another way for this...

Export the object as .txt.
Delete every thing inside it except the start and the end brace.
Import the txt file. The object will get deleted automatically and will not even for a confirmation.

\:D/

This is nice... why this thread is not in tips&tricks?

kriki · 2007-07-05

Phenno wrote:

This is nice... why this thread is not in tips&tricks?

I was waiting for someone to to note it

BTW : in case you find some other topic in a wrong forum, you can use the report function (the red ! on the right of the post) of the forum.

[Topic moved from Navision forum to Navision Tips & Tricks forum]

vytjak · 2007-08-24

Eto wrote:

deadlizard wrote:

DenSter wrote:

BEGIN
  Object.Type := Object.Type::Form;
  Object.ID := 50000;
  Object.Name := 'Killer Form';
  Object.INSERT;
END;

Alternatively, it can be done by browsing to the end of the list of the required type in the object designer until you are on a new record. Enter an ID and a name, and you will have created a 0 size object, which can be exported and which will default to the "Delete" option in the import worksheet while importing.

Note though: as far as I remember, despite being described in the manual, attempts to import/export such ojects used to crash Navision in the earlier versions.

Delete object in Import Worksheet

Comments

Categories