How to monitor completion of an object import as a text file

Vamci

Hi,
I am using Navision 3.7 and importing objects as text file. I am using testpartner script to import one object after another. I would like to check if import is successfull before moving to import the next file in my script.

Is there any log or table updated after successfull import of an object?

Pls clarify.

Thanks
Vamci

kine

The object must be saved into Object table... it means, the BLOB in this table will be changed... but how do you want to check that... :?:

Vamci

Hi,
I am using Menu -> File -> Import and select the text file of the object to be imported into the Navision database.

When I do this, some objects take few seconds and some take minutes.

After the import of the first object, I want to check the import status before I start importing the second object.

Hence I would like to know if there is any table where I can write a query and find out import status of an object. e.g In Progress, Complete etc...
Or if there is any log where import activity is written.

I will use this information, ensure that import is successfully completed for the first object and then proceed with the 2nd object import.

Pls clarify.

Thanks
Vamci

kine

No, there is not such a information. There are just two dialog boxes if something goes wrong (one with info what is wrong and second one on which line the imports topped)... (when importing text files).

Marije_Brummel

If I remember correctly the compiled boolean is false after importing a textfile.

If you filter on compiled = FALSE you will see the imported textobjects.

kine

(but only if all objects are compiled before the import... ;-))

Marije_Brummel

Yes, this true off-course.

Vamci

The object must be saved into Object table... it means, the BLOB in this table will be changed... but how do you want to check that...
================================

What exactly do you mean by this above statement?
Can I check this BLOB chagned using a code unit and write the status of import completion in a file? If yes, how to do that? Would be helpful if you can give some pointers in coding this logic...

Thanks
Vamci

kine

It means, that if you export the blob before and after the import and if the data are different, the blob was changed - object was changed, imported... But you need to know that the blob can have few MB in size... :-)

kriki

[Topic moved from Navision Attain forum to Navision forum]

PaddyMullaney

You can always query the Objects table, via ODBC or SQL