topic Data in Application server is getting truncated in Application Development and Automation Discussions

Data in Application server is getting truncated

Former Member — Mon, 05 May 2008 05:37:50 GMT

HI,

when sending data to application server using Open dataset at point data is getting truncated.

Please let me what should be done to oercome this.

Re: Data in Application server is getting truncated

Former Member — Mon, 05 May 2008 05:47:01 GMT

Hi Avinash,

The problem seems to be in TRANSFER command.

Please check specifying LENGTH while TRANSFER.

Thanks

Shital

Re: Data in Application server is getting truncated

Former Member — Mon, 05 May 2008 06:15:21 GMT

Hi,

The application server file shows 512 characters in a line even though the rest characters are available. The data is not truncated. It is available there.To check read the same dataset and download the contents in a notepad. U will get all the data.

Thank you.

<removed_by_moderator>

Re: Data in Application server is getting truncated

Former Member — Mon, 05 May 2008 06:44:09 GMT

I'm trying to download to excel sheet using the options provided in menu options of application server. It's downloading what it is showing (i.e. incomplete data)

My requirement is send the tab sepereated data to application server and form there they can download to excel sheet depending on there requirement.

Please help me out in this

Re: Data in Application server is getting truncated

Former Member — Mon, 05 May 2008 06:55:38 GMT

Hi,

U can create a small program with the READ DATASET syntax in it.Use GUI_DOWNLOAD for downloading in the excel sheet.

Reward points if gound useful.

Check the sample program to doenload in Notepad. The data shown is 512 chracters but in the notepad u will get 1000 characters.

DATA : l_string TYPE string,

con TYPE c LENGTH 10 VALUE 'AAAAAAAAAA',

temp TYPE c LENGTH 4 VALUE 'temp',

len TYPE i VALUE 1000.

DATA : itab LIKE TABLE OF l_string.

DO 100 TIMES.

CONCATENATE l_string con INTO l_string.

ENDDO.

OPEN DATASET temp FOR OUTPUT IN LEGACY TEXT MODE IGNORING CONVERSION ERRORS.

TRANSFER l_string TO temp LENGTH len.

CLOSE DATASET temp.

CLEAR l_string.

OPEN DATASET temp FOR INPUT IN LEGACY TEXT MODE IGNORING CONVERSION ERRORS.

READ DATASET temp INTO l_string.

APPEND l_string TO itab.

CLOSE DATASET temp.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

filename = 'C:\Documents and Settings\srrao\Desktop\temp.txt'

filetype = 'ASC'

TABLES

data_tab = itab.

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

<removed_by_moderator>

Edited by: Julius Bussche on Aug 27, 2008 4:26 PM

Re: Data in Application server is getting truncated

Former Member — Mon, 03 Nov 2008 11:42:13 GMT

Got the answer

Re: Data in Application server is getting truncated

Former Member — Sat, 16 Jan 2010 06:46:40 GMT

Hi Avinash,

I have a similar problem as well, can you let me know how did the issue get resolved.

Thanks in Advance,

Praveen