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 On Tue, Jun 15, 2010 at 6:53 PM, madhu <[email protected]> wrote: > 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 > > -- > 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 [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- 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 [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
