1. Forum
  3. T24 Technical Discussions
  5. T42 Data Migration
  7. How to fill USER through DM tool
× 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…

How to fill USER through DM tool

  • boblebibob
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 4 months ago #15219 by boblebibob
How to fill USER through DM tool was created by boblebibob
Not sure if is possible to do that, but I would like to create some users through the DM tool. We already load some application with the DM tool, but when we tried to load the USER, we got the following error.

LMDDCJ04//-1/NO,@ID:1:1=INPUT NOT NUMERIC*LMDDCJ04|LMDDCJ04|JOE.DOH|LMDDCJ4|EXT|1|CA0010001::CA0010002::CA0010003::CA0010004::GB0010001::GB0010002::GB0010003::US0010001|1|20140601M0601|20131205|20201231|0|2400|999|9||101254||ALL|@PAT|||||||NO|NO|NO|NO|DDMM|Y|BM::SM::SBM|L100::G160::|0|||QUEBEC!!DUBERGER::MONTREAL!!HOCHELAGA::|||,.||SUPER.USER

Don't understand why I got this error, since is possible to have @ID not numeric in the USER application.


Any idea ?

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
10 years 4 months ago #15222 by jpb
Replied by jpb on topic How to fill USER through DM tool
What does your DM.MAPPING.DEFINITION look like ?

Please Log in or Create an account to join the conversation.

  • boblebibob
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 4 months ago #15227 by boblebibob
Replied by boblebibob on topic How to fill USER through DM tool
Here the first part

Attachments:

Please Log in or Create an account to join the conversation.

  • jpb
  • jpb's Avatar
  • Offline
  • Moderator
  • Moderator
  • TAFj-R20 - 'unix'
More
10 years 4 months ago #15229 by jpb
Replied by jpb on topic How to fill USER through DM tool
I don't have real experience with DM but is it really needed to define the alternate name for the ID (USER.NAME) and place it in the record? With plain OFS you would never do it.
The following user(s) said Thank You: boblebibob

Please Log in or Create an account to join the conversation.

  • boblebibob
  • Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 4 months ago #15235 by boblebibob
Replied by boblebibob on topic How to fill USER through DM tool
By removing the user.id from my definition it's now working. With this definition is work!!! :-)
Thanks for your help
Attachments:

Please Log in or Create an account to join the conversation.

  1. Forum
  3. T24 Technical Discussions
  5. T42 Data Migration
  7. How to fill USER through DM tool
Time to create page: 0.239 seconds