topic string too long in Application Development and Automation Discussions

string too long

Former Member — Fri, 03 Feb 2012 07:13:02 GMT

Hello ,

Requirement is to generate an excel file in DMS .

Data for this excel file is retreived from Tables , tables have very huge amount of data .

method used to generate the excel file is :--

1. we create a string by concatinating all the data from tables

but we get dump in creating this string, since we have large amount of data .

2 . create an Xstring

3 Convert that to binary

4. create an excel in DMS

Can anyone please suggest how can we avoid step 1.

Any way by which we can merge two excels to generate one Excel

Re: string too long

Former Member — Fri, 03 Feb 2012 09:02:43 GMT

Please look into code exchange project, might get some help:

[ABAP2XLSX|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Thanks

Re: string too long

marcin_cholewczuk — Fri, 03 Feb 2012 09:54:49 GMT

Hi,

That would mean that you'have more than 2GB of data (this is the maximum size of string as far as I know). Does it really make sense to prepare so big files? When user will try to load it into memory it will take ages and I'm pretty sure that with ~65k lines limit in excel it won't be possible to see all results. So maybe it would be better to split this file?

Best Regards

Marcin Cholewczuk

Re: string too long

Former Member — Fri, 03 Feb 2012 17:01:09 GMT

why not GUI_UPLOAD into a binary table to start with? Or store as file on apps server and read into variable described as xstring?

Sounds like you're uploading as ASCII and then trying to convert to binary....unnecessary step, at least for me....

Re: string too long

marcin_cholewczuk — Fri, 03 Feb 2012 22:57:12 GMT

He didn't write that he is readig data from file, but from table (probably DB Table).

I suspect that xstring also has a limit, so it won't change anything.