topic Re: GUI_UPLOAD - Time Uploading into database table problem ! in Application Development and Automation Discussions

GUI_UPLOAD - Time Uploading into database table problem !

shubham_annadate96 — Mon, 27 Nov 2017 15:31:50 GMT

GUI_UPLOAD - Time Uploading into database table problem !
please take a look at screen shots :
Code part:
http://prntscr.com/hfx60w
http://prntscr.com/hfx581

Database table : http://prntscr.com/hfx0nw
Data Browser Uploaded data output : http://prntscr.com/hfx2b6

Re: GUI_UPLOAD - Time Uploading into database table problem !

iftah_peretz — Wed, 29 Nov 2017 07:02:39 GMT

Hi,

If you manage to insert some of the data and not the rest then you have 2 issues. First, inconsistency in the data (like space,format etc.). Second, your are not validating the data before entering it (as the screen shots show). An option is using the cl_abap_timefm=>conv_time_ext_to_int method (make sure you wrap it in a try-catch of cx_abap_timefm_invalid and handle it accordingly).

Re: GUI_UPLOAD - Time Uploading into database table problem !

Former Member — Wed, 29 Nov 2017 07:36:04 GMT

Define two local CHAR8 variables, e.g. lf_time, for your timefields in external format, use those two in the SPLIT, use CONCATENATE lf_time(2) lf_time+3(2) lf_time+6(2) into gs...-opened_at.