T24 - DM Tool - Data Mapping -Doubt

[madhu]

Hi,

All ,

i have a Doubt in DM Tool, i 'm uploading data from the Legacy
system to T24 .. Customer Table.. for that i have define the
DATA.MAPPING.DEFINITION .. and also DSC(Data Service Control) ....
but my requirement is ...

example: input file : customer.csv
in this data is in follwoing format :

Clientcode,NAME,NAME1,SHORTNAME,SECTOR
0000001,ABC,ABCD,ABC,1000

For this kind of the legacy data .. i have mapped the record in the
DMD 's field .. ID.TYPE TO DATA...... after making this field as
DATA , then i defined.... position no .. for each field.... it
is .ok.. if the no of records are more then no of characters in the
fields will be different and automatically position no will be
differences ... so how to solve this problem..
any one knows how to make use of DATA option in ID.TYPE -field please
have look on this ... and provide me a solution

thanks & regards
Madhu

[hareendra seneviratne]

Hi,

 

If you are passing @ID in your csv file, then in your DATA.MAPPING.DEFINITION record, you must define ID.TYPE  as DATA.

 

I think the problem is in your delimiter. Instead of ',' use some other charactor like '|'

 

Then your text file may look something like this.

 

0000001|ABC|ABCD|ABC|1000

 

 

 

 

 

--
Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines

IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24

To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@googlegroups.com
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en