Copy a User table from a society to another

[Former Member]

Hi!

We need to copy a user table from a society to other. Copying them into sql server don't works.

Anyone knows if with an addon like BCSet it can be done?

Thanks.

[Trinidad · Accepted solution]

Hi Javier,

The better way to copy tables between two different societies is to use the DI and then create a table with the same parameters in both companies. You can also copy the datas from one table to the other by using the DI API.

If you do not want to use the DI, you can also create tables by hand directly using the B1 application.

Pay attention, Business One tracks all tables created by using SDK or B1 application and saves some information in other tables (OUTB for example).

It is not supported to modify this internal tables by hand.

Regards

Trinidad.

[Former Member]

Hi,

i'm not sure the BCSet add-on can make this work.

You can copy the User Tables into SQL, but you must also write the right user table reference into OUTB.

So, if you want to import the EX_TABLE, you must have a row into OUTB like this:

OUTB.TableName = EX_TABLE

OUTB.Descr = Example Table

OUTB.TblNum = "progressive numerator"

OUTB.ObjectType = 0 for none, 1 for master data header, and so on...

OUTB.UsedinObj = "related UserDefinedObject"

At this time SBO is able to view the @EX_TABLE.

Hope this helps.

Kind Regards,

Fabio Salucci

[Former Member]

also CUFD too can contain references. that is if you have added more fields.

Indika.

[barend_morkel2]

IF your writing your own add-on, you can write the DI code to create the table (on start-up check if it exists - if not create it).

Straight SQL copy won't work - SBO has other tables that also keep track of your user defined table.

(You can "extract" the build of the table using the SapBobsCOM.UserTablesMD object's function .GetAs XML as well)

[Former Member]

Barend is right, SBO has references of the table in other places too.

the best option is to create the user table through SBO or your add-on, and then transfer data using DTS

Indika.