Copy data and enterprise unit from one company to another

How to copy data from one company to another

Steps to Copy/Transfer data of one Company to another Company

1. Create Sequential dump of the company which you want to copy.(session -ttaad4226m000)

This step will create sequential dump file in the folder specified by you.(see Fig -02)

(Fig – 01)

(Fig – 02)

2. Next run the session copy company data( session – tccom0214m000) along with enterprise unit.

(Here 125 – Represent source Company, 525 – Represents Target Company). Make sure that you run this session in source company only (in our e.g. company number 125)

3. Finally reorganize tables.

3gl with user input

Sometimes we required to change any parameter or condition at runtime.

I have developed a very simple yet powerful 3gl which accepts parameter from the user and based on input of the user, value of the variable modified.

In following example user is asked to provide percentage value which will be stored in the variable.

|******************************************************************************
|* Test 3GL
|* 21/06/14 [12:41]
|******************************************************************************
|* Script Type: 0
|******************************************************************************
                                                                               
function main()
{
domain tcmcs.str10 hold.path
domain tcmcs.long ret
hold.path= "10"
| hold.path="C:\Program Files\Microsoft Office\Office"
exec_dll_function("ottdllinputstr", "input.string", ret,
  "New Commission Percentage", "Enter New Value:", 50, 50, hold.path)
if ret then
|****HERE EXECUTE YOUR FUNCTION WITH NEW VALUE IN hold.path************

| hold.path = hold.path&"\excel.exe"&" c:\temp\convert.xls"
| exec_dll_function("ottdllbw", "app_start", ret, hold.path,
|      "", "", "", "", "")
endif

}

3gl for sensitivity labelling

Below is the simple 3gl script to add sessions,scripts and reports for sensitivity labelling.



|******************************************************************************
|* Sensitivity Labeling 3gl
|* devloc
|* 13-01-11 [15:05]
|******************************************************************************
|* Script Type: 0
|******************************************************************************
                                                                             
table tttadv200
table tttaad352

function main()
{
select ttadv200.*
from ttadv200
where ttadv200._compnr = {0}
selectdo
ttaad352.allc = ttyeno.no
ttaad352.comp = 999
ttaad352.rese = ttaad.rese.session
ttaad352.ccod = ttadv200.cpac & ttadv200.cmod & ttadv200.cses
ttaad352.lrep = ttyeno.yes
ttaad352.slvl = 10
ttaad352._compnr = 0

db.insert(tttaad352, db.skip.dupl)

| ttaad352.allc = ttyeno.no
| ttaad352.comp = 901
| ttaad352.rese = ttaad.rese.session
| ttaad352.ccod = ttadv200.cpac & ttadv200.cmod & ttadv200.cses
| ttaad352.lrep = ttyeno.yes
| ttaad352.slvl = 30
| ttaad352._compnr = 0
|
| db.insert(tttaad352, db.skip.dupl)

commit.transaction()
endselect

}

Hello Friends, This blog is for Technical persons who are in to Baan/InforLN ERP.