User Defined Field migration with long predelined list in DTW

[Former Member]

Hi Expert,

The project is using 2007A PL30. Due to mapping to customer existing legacy system, there are UDF with a set of predefined value so that user can select from drop down list. The list is very long and description is more than 30 characters which we cannot make use of link table.

Any idea whether DTW can migrate this type of UDF rather than manually keying into UDF?

Regards

Tlhomas

[Former Member · Accepted solution]

Hi Thomas

Let's clarify your question first.Do you try to import the content of the drop down list?

Or you want to import the content of the UDF while importing other objects(ex:BP,Invoices)?

As DTW can only import the content of UDF into the system.It is not possible

to create/modify UDF themselves via DTW.

However,It is possible to create UDF via DIAPI,maybe you can try to import UDF

into system by coding a little addon.

Here is a sample code about how to create UDF via SDK.

Dim oUserFieldsMD As SAPbobsCOM.UserFieldsMD

oUserFieldsMD = oCompany.GetBusinessObject(SAPbobsCOM.

BoObjectTypes.oUserFields)

oUserFieldsMD.TableName = "OCRD"

oUserFieldsMD.Name = "BE_UserField1"

oUserFieldsMD.Description = "A user field"

oUserFieldsMD.Type = SAPbobsCOM.BoFieldTypes.db_Date

oUserFieldsMD.SubType = SAPbobsCOM.BoFldSubTypes.st_Time

oUserFieldsMD.Add()

End Sub

Regards,

Syn Qin

SAP Business One Forums Team

Edited by: Syn Qin on Nov 21, 2008 6:03 AM

[Former Member]

It is possible to migrate UDF through DTW.

Say you have an UDF called, 'abc' in your BP Master, you have to just add a new column named, 'u_abc' in the default DTW template file for BP Master.