UDO SAP Note 804685 and Patch 14

[Former Member]

Hello,

one of the feature in the patch 14 of Business One is :

<i>Add records to UDO tables using the DI API - Problematic, Note 804685</i>

I looked everywhere in the MarketPlace but I can't find this note (804685)

I really need to be able to save data in the UDO with the DI.

Somebody has some information about it ?

Thank you

[Former Member]

Hi guys,

I've suceeded with this procedure, excepts for the UDO Document Lines tables.

Does any one know if it's possible to import data to UDO Document Lines Tables ?

Thnks,

Pegorer.

[Former Member]

Hi Sébastien,

I have an answer from SAP about this questio. I paste it:

Hello,

The note is not yet released, but it refers to the following bug.

"Get -4002 Error while trying to load records into User table from

Master Data type which is related to a User Defined Object.

The following code does not work:

oUserTable.Code = 1

oUserTable.Name = "FirstValue"

RetVal = oUserTable.Add

Following is the full error message that is recieved:

"-4002:[ONNM], 'Generating this document requires numbering

to be determined for the document'".

The solution is described below

There is a way to automatically fill your object's user tables:

This option has a bug which is planned to be fixed in a patch!

Create a text file containing all the records you are interested to

import to your object table. This text file will be read while

registering your object by the UDO registration wizard.

Create a text file with all you table's records. Name it TableName.txt

e.g. OLPO.txt

Create a new folder under SAP Business One's folder. Name it "TEMP_LS".

Copy your file e.g. "OLPO.txt", into the folder e.g. "TEMP_LS".

The registration wizard will copy the records into your User TBLS while

registering the UDO.

For more information please refer to the UDO documentation under:

Extending the business Logic => CSboBusinessObject => Virtual Methods =>

On Create Defaults

If this doesn't help or you are getting a different error.

Please provide the error message you are getting and also detailed step

to reproduce the issue.

It doesn't help us very much now !!!!!!!!!!

regards.

[Former Member]

So it's possible to enter data but these data have to be in a text file, and it's only possibhle when the UDO is registered.

AFter that it can only be done in C++ during an Upgrade.

Thanks for the information Angel

Message was edited by: Frank Moebius

[Former Member]

Hi

Did it works? I try it during the registration Wizard and SBO will make nothing. Is in 2005 the folder name the same like in 2004?

Thanks

Jörn

[former_member184566]

Hi Sebastian

Did it work for you? I once enquired on how i can make my udo filled with history (take on). SAP sent me the exact as above. I've tried it and had no success. The problem is that you need to know the exact format it needs and you get no errors. It's like the dtw, you can sit and import, gives error and then you try resolve error....you also have help files. Where the above method

>No help files/context

>What format exactly (will you have record key?)

>No errors

Please let us know Sebastian if you come right!!

[Former Member]

Hello,

I didn't try to implement this. As UDO can't be access by DI, I don't use them. So I don't know who to import data when they are registered.

Sebastien

[Former Member]

Hi Sebastian,

thnx for the information, for me was it the same for nearly one year, I hope in 2005 it is better, but it isn`t. My have to go ofter to a church so it will be possible

Thx

Jörn

[Former Member]

Hi Sénastien,

I've been testing it with new patch 14 but it doesn't work for me. I couldn't find note 804685, but I've asked for it to support team. I'll tell you for any news.

Kinds regards.