How to create mass entries in a database table

[adrian_mejido]

Hi,

I am going to do a program that can help me to charge registers in a database table. The origin of the registers is an excell file, that contains 39000 entries.

In other programs I use this function: 'ALSM_EXCEL_TO_INTERNAL_TABLE' but this function can only read 9999 registers. So I ask for us if There is another function that can help me. The other possibility that I think is call many times this function but If is possible to find another function, I guess that is better.

Thanks and regards.

[ThomasZloch]

Please allow me to translate "charge registers" into "create entries".

This function module works quite simple via the clipboard, you could take the code and create your own version that allows more rows. However there might be a bottleneck at some point due to your local PC power.

You could also store as CSV or TXT and use GUI_UPLOAD function or the "frontend" classes.

For more performant processing the data would need to be transferred to the application server and uploaded from there using OPEN DATASET and so on, please search for more information.

Thomas

[eduardo_hinojosa]

Hi

Try with FM KCD_FRONT_END_DIRECTORY_READ. After use FM KCD_EXCEL_OLE_TO_INT_CONVERT to populate your internal table.

I hope this helps you

Regards

Eduardo

[ThomasZloch]

The KCD-one is almost identical to the ALSM-one, and it has the same limitation of 9999 rows because of the cell coordinates being limited to four figures, see structures KCDE_CELLS or ALSMEX_TABLINE respectively.

Thomas

[eduardo_hinojosa]

Thanks Thomas, I wasn't aware about this limitation. You save me future researching !!!!