×
Discuss on porting data from legacy systems to T24. Data mapping, Data Migration tool, Extract Statergy, Writing runbook, Cut-over, Migrate static and Financial data, Balance transfer, Technical and Functional reconciliation, etc…
TAKEOVER.MAPPING
- dfixx
- Topic Author
- Offline
- Senior Member
-
Less
More
- Posts: 73
- Thank you received: 0
13 years 7 months ago #6873
by dfixx
TAKEOVER.MAPPING was created by dfixx
Dear All,
I am working on uploading records in t24 R08 system window2008 environment and i am having problems uploading the file into DAO table, can someone assist me with with setup of TAKEOVER.MAPPIMG for easy upload.
Thank you
I am working on uploading records in t24 R08 system window2008 environment and i am having problems uploading the file into DAO table, can someone assist me with with setup of TAKEOVER.MAPPIMG for easy upload.
Thank you
Please Log in or Create an account to join the conversation.
- nguyenminhhuy
- Offline
- Junior Member
-
Less
More
- Posts: 31
- Thank you received: 3
13 years 7 months ago #6875
by nguyenminhhuy
Replied by nguyenminhhuy on topic Re: TAKEOVER.MAPPING
Dear dfixx,
As i know, TAKEOVER.MAPPING & EBS.AUTO.FUNCTION are used to upload data into application.
The usage of TAKEOVER.MAPPING & EBS.AUTO.FUNCTION is quite simple but the preparation of text file to be input.
To preparation of text file, you should do the following stuff:
1. Create a MS Excel file with TAKEOVER.MAPPING column and data (file 1)
2. Create a MS Excel file with TAKEOVER.MAPPING column format and position (file 2)
3. Then write a macro on file 2 to format THE COLUMN WIDTH of file 1
These will give you the correct format text file for TAKEOVER.MAPPING.
For the next steps, please refer to your documents.
BR,
Huy Nguyen
As i know, TAKEOVER.MAPPING & EBS.AUTO.FUNCTION are used to upload data into application.
The usage of TAKEOVER.MAPPING & EBS.AUTO.FUNCTION is quite simple but the preparation of text file to be input.
To preparation of text file, you should do the following stuff:
1. Create a MS Excel file with TAKEOVER.MAPPING column and data (file 1)
2. Create a MS Excel file with TAKEOVER.MAPPING column format and position (file 2)
3. Then write a macro on file 2 to format THE COLUMN WIDTH of file 1
These will give you the correct format text file for TAKEOVER.MAPPING.
For the next steps, please refer to your documents.
BR,
Huy Nguyen
The following user(s) said Thank You: dfixx
Please Log in or Create an account to join the conversation.
- jpb
-
- Offline
- Moderator
-
- retired
Less
More
- Posts: 2859
- Thank you received: 649
13 years 7 months ago #6880
by jpb
Replied by jpb on topic Re: TAKEOVER.MAPPING
Why don't use OFS, easy to apply within EXCEL and bothering with fieldformats and definitions within TM.
All you need is something like :
DEPT.ACCT.OFFICER,//PROCESS/1/1,<USER>/>PASSWD>/<COMPANY>,<RECORD-ID>,ALT.DEPT.LEVEL:1:1=50,ALT.DEPT.PARENT:1:1=5060,AREA:1:1=XXXX,DELIVERY.POINT:1:1=XXXXX,DEPT.LEVEL:1:1=90,MNEMONIC:1:1=XXXX,NAME:1:1="Xxxxx Xxxx",
[using PROCESS/1/0 will even put the record directly to live = Zero-Authoriser]
and setting up the respective OFS.SOURCE and Phantom/Service.
All you need is something like :
DEPT.ACCT.OFFICER,//PROCESS/1/1,<USER>/>PASSWD>/<COMPANY>,<RECORD-ID>,ALT.DEPT.LEVEL:1:1=50,ALT.DEPT.PARENT:1:1=5060,AREA:1:1=XXXX,DELIVERY.POINT:1:1=XXXXX,DEPT.LEVEL:1:1=90,MNEMONIC:1:1=XXXX,NAME:1:1="Xxxxx Xxxx",
[using PROCESS/1/0 will even put the record directly to live = Zero-Authoriser]
and setting up the respective OFS.SOURCE and Phantom/Service.
The following user(s) said Thank You: dfixx
Please Log in or Create an account to join the conversation.
Time to create page: 0.071 seconds