How to Delete the obsolete object using non-accessed license

Andwian

I have a few objects that can only be read by the Developer license, and not by the customer license. And now, I want to clean them from the customer database.

I have recommend the customer to use their license, and do the deletion. The problem is they even could not delete them because their license did not allow it.

Another option is to do the remote session and do the Change License into Developer license and then delete the objects. But, I could not do that.

Finally, I fall into the online help saying that we could delete the objects using the Import Worksheet in Object Designer. There is a DELETE action when we are in Impor Worksheet form. Unfortunately, when I change the Action into Delete, there is error message saying:

Delete is only allowed for empty objects.

Further reading the online help:

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. A new object that has this function is sometimes called a 'killer object'.

I have tried to create a new object with a new form, and I did not set anything, just give it an ID, and a Name, and then save it, but it will show any BLOB Size.

The query is:

How to create a 0 sized object?

Or, in general,

How to delete those obsolete object using Non-accessed license?

einsTeIn.NET

You could create an object, e.g. report, that is able to delete those objects. But what's the problem with those data and objects? If it's not accessable then it shouldn't disturb the user in his normal work.

Andwian

einsTeIn.NET wrote:

But what's the problem with those data and objects? If it's not accessable then it shouldn't disturb the user in his normal work.

Good question! But the problem arouse when the user want to be able to run that object, and then I resend them with the ID that they can access. Unfortunately, when they import it, the error message saying that:

The object name already exist. Object: Form XXX

Hence, I must delete those obsolete objects first.

Anyway, can I delete the - let's say Form50000 - with the object Report 50000?

einsTeIn.NET

Renumbering of objects is not a solution for missing access! They should simply pay for those modules!!

lvanvugt

How to create a 0 sized object?

1. Open Object Designer

2. Select youir object type

3. Go to last (i.e. empty line) of the object list

4. Make it editable, i.e. click F2

5. Enter a value in the ID field (and populate the other fields like Name ...)

Note that the size is 0!

6. Select the object record

7. Export object in .fob format

Now if you reimport the object (using gthe Inport Worksheet you will see it will suggest to delete the objects still in your database. If click OK the eventula result will be that the object is delted from the database.

Andwian

einsTeIn.NET wrote:

Renumbering of objects is not a solution for missing access! They should simply pay for those modules!!

I understand for that, of course

Actually, the object that the customer want to use is Universal Excel Importer, which in default will be using CU999991, which I am sure this will be outside of the customer reach, and can be reached only by developer license. Thus, I will renumber this ID into the ID No. that customer license afford. That's all.

Andwian

lvanvugt wrote:

5. Enter a value in the ID field

Thank you Luc Van Vugt, I can now create a zero size object, however what value ID should I use?
For example, if I want to delete Form 90000, then I should create a new object with the same ID to delete the object, right?
I have tried it, but it can not create a new object with the duplicate ID existing in the Object Designer.

Andwian

Andwian wrote:

For example, if I want to delete Form 90000, then I should create a new object with the same ID to delete the object, right?

RIGHT

Andwian wrote:

it can not create a new object with the duplicate ID existing in the Object Designer.

I must use another database that do not have duplicate ID, for object that will be deleted.

SUMMARY:

1. create the zero object with

ID in question in another database. How?

a. Go to the Object Designer b. Choose the Object Type, i.e: Form, Table, etc. c. Go to the last empty line (Ctrl + End) d. Press F2 on ID field, enter the ID that you want to delete e. Input the Name field. f. Save object & close.

2. Export the object
3. Import the object
4. Choose 'Delete' in Import Worksheet form

Thank you all!

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Tips & Tricks' forum]

Andwian

I agree with you, but I have to make it available with the ID No. that are accessible, so that I have to delete the old one, to prevent the duplicate name of object.