topic data upload inconsistency from notepad to database table in Application Development and Automation Discussions

data upload inconsistency from notepad to database table

Former Member — Tue, 27 May 2008 14:38:31 GMT

Hi I am uploading data from notepad to a database table which has two columns. The data is being read but the data in second column is not reading correctly.

Eg: Col1 Col2

A 1

B 2

C 3

Data in Col1 is being uploaded correctly, but data in Col2 is always taking value 9 into the database table. Please help me with this. Thanks in Advance.

Re: data upload inconsistency from notepad to database table

Former Member — Tue, 27 May 2008 14:40:46 GMT

check in your debudding mode, whats the value in the internal table.

Check the domain of the data element in the DB TAB whether it contains any fixed values?

Reward points if useful.

Rgds,

Anita

Re: data upload inconsistency from notepad to database table

Former Member — Tue, 27 May 2008 14:55:54 GMT

Hi Srinivas,

Check the below points.

1. The text file have any separator or not. if there is no separator, check the length of the fields in the table and file.

Ex: 1st field length is 10

1st field length is 10

then your text file data per record should be 20 char length.

2. The fields in the table should be char.

Reward if found helpful.

Regards,

Boobalan Suburaj