Mass download of BDS (Business Data Services) image files

[Former Member]

Hi,

We have a requirement to download all images (around 45,000) stored in BDS for conversion to another system (these images can be viewed through SE78 as well).

I know you can create a program to download each image one by one, however our requirement is to do a mass download of ALL images in BDS.

Does anyone know how this can be done and if possibe?

thanks

Jason

[former_member565026]

Hi Jason ,

first convert ur  images into binary format using method

call method cl_ssf_xsf_utilities=>get_bds_graphic_as_bmp

    exporting

      p_object  = fs_stxbitmaps-tdobject

      p_name    = fs_stxbitmaps-tdname

      p_id      = fs_stxbitmaps-tdid

      p_btype   = fs_stxbitmaps-tdbtype

    receiving

      p_bmp     = loc_graphic_xstr

    exceptions

      not_found = 1

      others    = 2.

then download using GUI_DOWNLOAD..

Regards

srini

[Former Member]

Thanks Srini,

Unfortunately I can't use that method. I understand you can write a program as per your suggestion, however we have around 45,000 images to convert so wouldn't be practical calling the GUI_DOWNLOAD for all of them.

Is it possible for a mass download (are the physical image files stored in a directory somewhere on the app server/database and how to find this location)?

thanks

jason

[Former Member]

Discovered I can do a mass download by writing a program to get all entries from table STXBITMAPS with:

TDOBJECT = 'GRAPHICS'

TDID = 'BMAP'.

TDBTYPE = 'BCOL' (for colour images)

then looping at this table and using Srini's suggestion to get BDS images in binary format (hex string).

call method cl_ssf_xsf_utilities=>get_bds_graphic_as_bmp

    exporting

      p_object  = fs_stxbitmaps-tdobject

      p_name    = fs_stxbitmaps-tdname

      p_id      = fs_stxbitmaps-tdid

      p_btype   = fs_stxbitmaps-tdbtype

    receiving

      p_bmp     = loc_graphic_xstr

    exceptions

      not_found = 1

      others    = 2.

Then download to application server via OPEN DATASET.