• upload json/download xlsx file to/from www.xxx.co.xx

    From timepro timesheet@21:1/5 to All on Thu Sep 1 19:52:24 2022
    hi:

    my app is in xhb+dbf+ps32+wvw

    from my app's billing screen, user selects an invoice (e.g. inv#:'ABC_1234/22-23' record# 44892), clicks on 'make-json' (menu to prom) to create a .json file of that invoice (jfile).
    e.g. jfile=diskname()+':\TAX\INVOICE\JSON_OUT\'+jsonfilename.json
    -this process is already coded & running proper.

    now, can this be programmed from within my app:
    1. open www.xxx.co.xx (predefined variable)
    2. login with username,password & the 'captcha' (user,psw are predefined)
    3. open/click the specific 'bulk-upload' tab (in the opened www.xxx.co.xx)
    4. upload the 'jfile'
    -www.xxx.co.xx will now validate & generate a file (embedded with qrc) to be downloaded. (options: xlsx / json / xml / zip)
    5. download/save the generated 'xlsx' file (e.g. ABC_123.XLSX) to diskname()+':\TAX\INVOICE\JSON_IN folder
    6. replace 'qrc_xls' field with ABC_123.XLSX in record#44892 (INVTAX.DBF)

    the user does not have to click/hit any key.
    (all this time, the screen would 'continue' to show inv# ABC_1234/22-23 details.)

    thank you

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to timepro timesheet on Fri Sep 2 11:14:28 2022
    On Friday, September 2, 2022 at 8:22:25 AM UTC+5:30, timepro timesheet wrote:
    hi:

    my app is in xhb+dbf+ps32+wvw

    from my app's billing screen, user selects an invoice (e.g. inv#:'ABC_1234/22-23' record# 44892), clicks on 'make-json' (menu to prom) to create a .json file of that invoice (jfile).
    e.g. jfile=diskname()+':\TAX\INVOICE\JSON_OUT\'+jsonfilename.json
    -this process is already coded & running proper.

    now, can this be programmed from within my app:
    1. open www.xxx.co.xx (predefined variable)
    2. login with username,password & the 'captcha' (user,psw are predefined)
    3. open/click the specific 'bulk-upload' tab (in the opened www.xxx.co.xx)
    4. upload the 'jfile'
    -www.xxx.co.xx will now validate & generate a file (embedded with qrc) to be downloaded. (options: xlsx / json / xml / zip)
    5. download/save the generated 'xlsx' file (e.g. ABC_123.XLSX) to diskname()+':\TAX\INVOICE\JSON_IN folder
    6. replace 'qrc_xls' field with ABC_123.XLSX in record#44892 (INVTAX.DBF)

    the user does not have to click/hit any key.
    (all this time, the screen would 'continue' to show inv# ABC_1234/22-23 details.)

    thank you

    hello all:

    upon scouring & poring over various threads, i managed to reached here:
    (this is the first, am experimenting/coding with: turl, cPassword, tipclienthttp...)

    oUrl := TUrl():new("http://xxxxx.tax.gov.xx") && how to 'httpS' in place of 'http'
    oUrl:cUserId := "myname"
    oUrl:cPassword := "mypass1234"
    oConn:=TipClientHttp():New(oUrl,.t.)
    //IF oConn:Open()
    //cPageContent:=oConn:ReadAll() && len(cPageContent) returns 0
    //oConn:Close()
    //ENDIF

    -how to auto login with cUserId & cPassword. (also how to validate if userid/password are valid)
    after successful login (http://xxxxx.tax.gov.xx)
    a] how to get the specific 'bulk-upload' tab opened/activated/clicked (it asks file to be uploaded)

    b] how to get my jfile.json uploaded.

    c] post validation, how to download the generated .xlsx file to diskname()+':'\folder\subfolder2\downloadedfilename.xlsx
    OR
    after a] & b], the user would download the generated (.xlsx) file manually. (for this http://xxxxx.tax.gov.xx has to be open/visible on screen - mouse over the 'download-file' link)

    thank you

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to timepro timesheet on Sat Sep 3 09:08:01 2022
    On Friday, September 2, 2022 at 11:44:29 PM UTC+5:30, timepro timesheet wrote:
    On Friday, September 2, 2022 at 8:22:25 AM UTC+5:30, timepro timesheet wrote:
    hi:

    my app is in xhb+dbf+ps32+wvw

    from my app's billing screen, user selects an invoice (e.g. inv#:'ABC_1234/22-23' record# 44892), clicks on 'make-json' (menu to prom) to create a .json file of that invoice (jfile).
    e.g. jfile=diskname()+':\TAX\INVOICE\JSON_OUT\'+jsonfilename.json
    -this process is already coded & running proper.

    now, can this be programmed from within my app:
    1. open www.xxx.co.xx (predefined variable)
    2. login with username,password & the 'captcha' (user,psw are predefined) 3. open/click the specific 'bulk-upload' tab (in the opened www.xxx.co.xx) 4. upload the 'jfile'
    -www.xxx.co.xx will now validate & generate a file (embedded with qrc) to be downloaded. (options: xlsx / json / xml / zip)
    5. download/save the generated 'xlsx' file (e.g. ABC_123.XLSX) to diskname()+':\TAX\INVOICE\JSON_IN folder
    6. replace 'qrc_xls' field with ABC_123.XLSX in record#44892 (INVTAX.DBF)

    the user does not have to click/hit any key.
    (all this time, the screen would 'continue' to show inv# ABC_1234/22-23 details.)

    thank you
    hello all:

    upon scouring & poring over various threads, i managed to reached here:
    (this is the first, am experimenting/coding with: turl, cPassword, tipclienthttp...)

    oUrl := TUrl():new("http://xxxxx.tax.gov.xx") && how to 'httpS' in place of 'http'
    oUrl:cUserId := "myname"
    oUrl:cPassword := "mypass1234"
    oConn:=TipClientHttp():New(oUrl,.t.)
    //IF oConn:Open()
    //cPageContent:=oConn:ReadAll() && len(cPageContent) returns 0 //oConn:Close()
    //ENDIF

    -how to auto login with cUserId & cPassword. (also how to validate if userid/password are valid)
    after successful login (http://xxxxx.tax.gov.xx)
    a] how to get the specific 'bulk-upload' tab opened/activated/clicked (it asks file to be uploaded)

    b] how to get my jfile.json uploaded.

    c] post validation, how to download the generated .xlsx file to diskname()+':'\folder\subfolder2\downloadedfilename.xlsx
    OR
    after a] & b], the user would download the generated (.xlsx) file manually. (for this http://xxxxx.tax.gov.xx has to be open/visible on screen - mouse over the 'download-file' link)

    thank you

    for most of you, it's easy-peasy, but i am an average skilled programmer. (pre-xhb) used to code in clipper. ('i don't know what i don't know')

    please would any of the xhb gurus assist me with the syntax/command for: ************************************
    function loginwebsite_touploadfile
    ************************************
    1. open 'https://websiteaddress' from inside by app's invoicing screen. (xhb+wvw+dbf+ps32)
    2. auto-login with userid,password,'captcha' (userid, password are predefined) 3. open/clickon specific 'bulk-upload' tab (in the logged https://websiteaddress)
    -in the logged site, the user will browse & manually upload/download the json/xlsx file-
    (return to the invoicing screen, on exiting websiteaddress)
    *eofunc

    thank you

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to timepro timesheet on Sat Sep 3 09:03:20 2022
    On Friday, September 2, 2022 at 11:44:29 PM UTC+5:30, timepro timesheet wrote:
    On Friday, September 2, 2022 at 8:22:25 AM UTC+5:30, timepro timesheet wrote:
    hi:

    my app is in xhb+dbf+ps32+wvw

    from my app's billing screen, user selects an invoice (e.g. inv#:'ABC_1234/22-23' record# 44892), clicks on 'make-json' (menu to prom) to create a .json file of that invoice (jfile).
    e.g. jfile=diskname()+':\TAX\INVOICE\JSON_OUT\'+jsonfilename.json
    -this process is already coded & running proper.

    now, can this be programmed from within my app:
    1. open www.xxx.co.xx (predefined variable)
    2. login with username,password & the 'captcha' (user,psw are predefined) 3. open/click the specific 'bulk-upload' tab (in the opened www.xxx.co.xx) 4. upload the 'jfile'
    -www.xxx.co.xx will now validate & generate a file (embedded with qrc) to be downloaded. (options: xlsx / json / xml / zip)
    5. download/save the generated 'xlsx' file (e.g. ABC_123.XLSX) to diskname()+':\TAX\INVOICE\JSON_IN folder
    6. replace 'qrc_xls' field with ABC_123.XLSX in record#44892 (INVTAX.DBF)

    the user does not have to click/hit any key.
    (all this time, the screen would 'continue' to show inv# ABC_1234/22-23 details.)

    thank you
    hello all:

    upon scouring & poring over various threads, i managed to reached here:
    (this is the first, am experimenting/coding with: turl, cPassword, tipclienthttp...)

    oUrl := TUrl():new("http://xxxxx.tax.gov.xx") && how to 'httpS' in place of 'http'
    oUrl:cUserId := "myname"
    oUrl:cPassword := "mypass1234"
    oConn:=TipClientHttp():New(oUrl,.t.)
    //IF oConn:Open()
    //cPageContent:=oConn:ReadAll() && len(cPageContent) returns 0 //oConn:Close()
    //ENDIF

    -how to auto login with cUserId & cPassword. (also how to validate if userid/password are valid)
    after successful login (http://xxxxx.tax.gov.xx)
    a] how to get the specific 'bulk-upload' tab opened/activated/clicked (it asks file to be uploaded)

    b] how to get my jfile.json uploaded.

    c] post validation, how to download the generated .xlsx file to diskname()+':'\folder\subfolder2\downloadedfilename.xlsx
    OR
    after a] & b], the user would download the generated (.xlsx) file manually. (for this http://xxxxx.tax.gov.xx has to be open/visible on screen - mouse over the 'download-file' link)

    thank you

    for most of you, it's easy-peasy, but i am an average skilled programmer. (pre-xhb) used to code in clipper. (i don't now what i don't know)

    please would any of the xhb gurus indulge me with the syntax/command for: ************************************
    function loginwebsite_touploadfile
    ************************************
    1. open 'https://websiteaddress' from inside by app's invoicing screen. (xhb+wvw+dbf+ps32)
    2. once site open, auto-login with userid,password,'captcha' (userid, password are predefined)
    3. open/clickon specific 'bulk-upload' tab (in the logged https://websiteaddress)
    -in the logged site, the user will browse & manually upload/download the json/xlsx file-
    (return to the invoicing screen, on exiting websiteaddress)
    *eofunc

    thank you

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to timepro timesheet on Sun Sep 11 18:14:31 2022
    On Saturday, September 3, 2022 at 9:38:02 PM UTC+5:30, timepro timesheet wrote:
    On Friday, September 2, 2022 at 11:44:29 PM UTC+5:30, timepro timesheet wrote:
    On Friday, September 2, 2022 at 8:22:25 AM UTC+5:30, timepro timesheet wrote:
    hi:

    my app is in xhb+dbf+ps32+wvw

    from my app's billing screen, user selects an invoice (e.g. inv#:'ABC_1234/22-23' record# 44892), clicks on 'make-json' (menu to prom) to create a .json file of that invoice (jfile).
    e.g. jfile=diskname()+':\TAX\INVOICE\JSON_OUT\'+jsonfilename.json
    -this process is already coded & running proper.

    now, can this be programmed from within my app:
    1. open www.xxx.co.xx (predefined variable)
    2. login with username,password & the 'captcha' (user,psw are predefined) 3. open/click the specific 'bulk-upload' tab (in the opened www.xxx.co.xx)
    4. upload the 'jfile'
    -www.xxx.co.xx will now validate & generate a file (embedded with qrc) to be downloaded. (options: xlsx / json / xml / zip)
    5. download/save the generated 'xlsx' file (e.g. ABC_123.XLSX) to diskname()+':\TAX\INVOICE\JSON_IN folder
    6. replace 'qrc_xls' field with ABC_123.XLSX in record#44892 (INVTAX.DBF)

    the user does not have to click/hit any key.
    (all this time, the screen would 'continue' to show inv# ABC_1234/22-23 details.)

    thank you
    hello all:

    upon scouring & poring over various threads, i managed to reached here: (this is the first, am experimenting/coding with: turl, cPassword, tipclienthttp...)

    oUrl := TUrl():new("http://xxxxx.tax.gov.xx") && how to 'httpS' in place of 'http'
    oUrl:cUserId := "myname"
    oUrl:cPassword := "mypass1234"
    oConn:=TipClientHttp():New(oUrl,.t.)
    //IF oConn:Open()
    //cPageContent:=oConn:ReadAll() && len(cPageContent) returns 0 //oConn:Close()
    //ENDIF

    -how to auto login with cUserId & cPassword. (also how to validate if userid/password are valid)
    after successful login (http://xxxxx.tax.gov.xx)
    a] how to get the specific 'bulk-upload' tab opened/activated/clicked (it asks file to be uploaded)

    b] how to get my jfile.json uploaded.

    c] post validation, how to download the generated .xlsx file to diskname()+':'\folder\subfolder2\downloadedfilename.xlsx
    OR
    after a] & b], the user would download the generated (.xlsx) file manually. (for this http://xxxxx.tax.gov.xx has to be open/visible on screen - mouse over the 'download-file' link)

    thank you
    for most of you, it's easy-peasy, but i am an average skilled programmer. (pre-xhb) used to code in clipper. ('i don't know what i don't know')

    please would any of the xhb gurus assist me with the syntax/command for:

    ************************************
    function loginwebsite_touploadfile
    ************************************
    1. open 'https://websiteaddress' from inside by app's invoicing screen. (xhb+wvw+dbf+ps32)
    'https://websiteaddress' will open on the screen.
    2. auto-login with userid,password,'captcha' (userid, password are predefined)
    3. open/clickon specific 'bulk-upload' tab ('bulk-upload' would be a variable)
    -in the logged site, the user will browse & manually upload/download the json/xlsx file-
    (return to the invoicing screen, on exiting websiteaddress)
    *eofunc

    thank you

    could someone/anyone program this 'PROFESSIONALLY'?. (with a .prg file source code)
    for steps 1 & 2: us$100.
    for steps 1 & 2 & 3: us$250.
    (my app would just call your function with the relevant parameters).

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to timepro timesheet on Thu Sep 22 02:38:38 2022
    On Monday, September 12, 2022 at 6:44:32 AM UTC+5:30, timepro timesheet wrote:
    On Saturday, September 3, 2022 at 9:38:02 PM UTC+5:30, timepro timesheet wrote:
    On Friday, September 2, 2022 at 11:44:29 PM UTC+5:30, timepro timesheet wrote:
    On Friday, September 2, 2022 at 8:22:25 AM UTC+5:30, timepro timesheet wrote:
    hi:

    my app is in xhb+dbf+ps32+wvw

    from my app's billing screen, user selects an invoice (e.g. inv#:'ABC_1234/22-23' record# 44892), clicks on 'make-json' (menu to prom) to create a .json file of that invoice (jfile).
    e.g. jfile=diskname()+':\TAX\INVOICE\JSON_OUT\'+jsonfilename.json
    -this process is already coded & running proper.

    now, can this be programmed from within my app:
    1. open www.xxx.co.xx (predefined variable)
    2. login with username,password & the 'captcha' (user,psw are predefined)
    3. open/click the specific 'bulk-upload' tab (in the opened www.xxx.co.xx)
    4. upload the 'jfile'
    -www.xxx.co.xx will now validate & generate a file (embedded with qrc) to be downloaded. (options: xlsx / json / xml / zip)
    5. download/save the generated 'xlsx' file (e.g. ABC_123.XLSX) to diskname()+':\TAX\INVOICE\JSON_IN folder
    6. replace 'qrc_xls' field with ABC_123.XLSX in record#44892 (INVTAX.DBF)

    the user does not have to click/hit any key.
    (all this time, the screen would 'continue' to show inv# ABC_1234/22-23 details.)

    thank you
    hello all:

    upon scouring & poring over various threads, i managed to reached here: (this is the first, am experimenting/coding with: turl, cPassword, tipclienthttp...)

    oUrl := TUrl():new("http://xxxxx.tax.gov.xx") && how to 'httpS' in place of 'http'
    oUrl:cUserId := "myname"
    oUrl:cPassword := "mypass1234"
    oConn:=TipClientHttp():New(oUrl,.t.)
    //IF oConn:Open()
    //cPageContent:=oConn:ReadAll() && len(cPageContent) returns 0 //oConn:Close()
    //ENDIF

    -how to auto login with cUserId & cPassword. (also how to validate if userid/password are valid)
    after successful login (http://xxxxx.tax.gov.xx)
    a] how to get the specific 'bulk-upload' tab opened/activated/clicked (it asks file to be uploaded)

    b] how to get my jfile.json uploaded.

    c] post validation, how to download the generated .xlsx file to diskname()+':'\folder\subfolder2\downloadedfilename.xlsx
    OR
    after a] & b], the user would download the generated (.xlsx) file manually.
    (for this http://xxxxx.tax.gov.xx has to be open/visible on screen - mouse over the 'download-file' link)

    thank you
    for most of you, it's easy-peasy, but i am an average skilled programmer. (pre-xhb) used to code in clipper. ('i don't know what i don't know')

    please would any of the xhb gurus assist me with the syntax/command for:

    ************************************
    function loginwebsite_touploadfile
    ************************************
    1. open 'https://websiteaddress' from inside by app's invoicing screen. (xhb+wvw+dbf+ps32)
    'https://websiteaddress' will open on the screen.
    2. auto-login with userid,password,'captcha' (userid, password are predefined)
    3. open/clickon specific 'bulk-upload' tab ('bulk-upload' would be a variable)
    -in the logged site, the user will browse & manually upload/download the json/xlsx file-
    (return to the invoicing screen, on exiting websiteaddress)
    *eofunc

    thank you
    could someone/anyone program this 'PROFESSIONALLY'?. (with a .prg file source code)
    for steps 1 & 2: us$100.
    for steps 1 & 2 & 3: us$250.
    (my app would just call your function with the relevant parameters).

    ok, i will up the ante.
    for step 1 & 2: us$300.00.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Thu Sep 22 13:07:10 2022
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan@21:1/5 to All on Thu Sep 22 16:12:07 2022
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to Dan on Thu Sep 22 08:33:47 2022
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Enrico Maria Giordano@21:1/5 to All on Thu Sep 22 19:09:12 2022
    Il 22/09/2022 17:33, timepro timesheet ha scritto:

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).

    There is no standard procedure that can do that. It could still be
    impossible.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Ella Stern@21:1/5 to Dan on Thu Sep 22 11:11:54 2022
    On Thursday, September 22, 2022 at 8:19:36 PM UTC+3, Dan wrote:
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the >> OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...
    I think that to open the page with the browser is easy, but to interact
    with the page isn't. How to automagically compile the fields user/passw?
    Once the browser starts, you have no control on it, if not via OLE. The
    only thing I tried has been: open the page, print it, close. Not very
    much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a
    local page carefully crafted (=with a script that modifies the
    FRAME/IFRAME content). This is forbidden if the loaded page is not in
    the same domain of the local page (cross-domain policy). Years ago I
    studied the problem and tried some hacks, but to no avail. Google
    "script injection" if you are interested. Recent improvement in
    browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour),
    modify the HTML (now the page is simply a text file on your PC),
    injecting a script able to compile the controls (a bit less easy), then
    open in the browser the modified page that should result pre-compiled. Unsure, however. Never tried such a thing.

    Dan

    If the login is done via GET request, the user and password are always URL parameters.
    If the login is done via POST request, only JavaScript code can do it, browsers are not able to "post".
    Anyway, you cannot open a local .html file generated dynamically by your desktop app (see Dan's comment), but you can call your own web app to do many more things for you.

    And in order to get back to the desktop app there are needed three pieces of software:
    - (A) a server-side function of the website, which is able to receive a call from the website frontend, and a call the desktop app
    - (B) a function of the website frontend, which is calling (A) to notify it that the user is done with the website
    - (C) a function of the desktop app, which is polling periodically (A) in order to check, that the user is done with the website, or not yet

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Dan@21:1/5 to All on Thu Sep 22 19:19:31 2022
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all. >>>
    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...

    I think that to open the page with the browser is easy, but to interact
    with the page isn't. How to automagically compile the fields user/passw?
    Once the browser starts, you have no control on it, if not via OLE. The
    only thing I tried has been: open the page, print it, close. Not very
    much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a
    local page carefully crafted (=with a script that modifies the
    FRAME/IFRAME content). This is forbidden if the loaded page is not in
    the same domain of the local page (cross-domain policy). Years ago I
    studied the problem and tried some hacks, but to no avail. Google
    "script injection" if you are interested. Recent improvement in
    browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour),
    modify the HTML (now the page is simply a text file on your PC),
    injecting a script able to compile the controls (a bit less easy), then
    open in the browser the modified page that should result pre-compiled.
    Unsure, however. Never tried such a thing.

    Dan

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lailton Fernando Mariano@21:1/5 to All on Mon Sep 26 22:09:12 2022
    Em quinta-feira, 22 de setembro de 2022 às 11:11:56 UTC-7, Ella Stern escreveu:
    On Thursday, September 22, 2022 at 8:19:36 PM UTC+3, Dan wrote:
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are >>>> predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image, >> pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...
    I think that to open the page with the browser is easy, but to interact with the page isn't. How to automagically compile the fields user/passw? Once the browser starts, you have no control on it, if not via OLE. The only thing I tried has been: open the page, print it, close. Not very much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a
    local page carefully crafted (=with a script that modifies the FRAME/IFRAME content). This is forbidden if the loaded page is not in
    the same domain of the local page (cross-domain policy). Years ago I studied the problem and tried some hacks, but to no avail. Google
    "script injection" if you are interested. Recent improvement in
    browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour), modify the HTML (now the page is simply a text file on your PC),
    injecting a script able to compile the controls (a bit less easy), then open in the browser the modified page that should result pre-compiled. Unsure, however. Never tried such a thing.

    Dan
    If the login is done via GET request, the user and password are always URL parameters.
    If the login is done via POST request, only JavaScript code can do it, browsers are not able to "post".
    Anyway, you cannot open a local .html file generated dynamically by your desktop app (see Dan's comment), but you can call your own web app to do many more things for you.

    And in order to get back to the desktop app there are needed three pieces of software:
    - (A) a server-side function of the website, which is able to receive a call from the website frontend, and a call the desktop app
    - (B) a function of the website frontend, which is calling (A) to notify it that the user is done with the website
    - (C) a function of the desktop app, which is polling periodically (A) in order to check, that the user is done with the website, or not yet

    Using CURL you can do something like that, the unique point like said before is the captcha, I recommend you download capcha image and show it around
    fields that will request the user/password, then after you have it you can goto the next step.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to lai...@paysoft.com.br on Tue Sep 27 09:31:45 2022
    On Tuesday, September 27, 2022 at 10:39:13 AM UTC+5:30, lai...@paysoft.com.br wrote:
    Em quinta-feira, 22 de setembro de 2022 às 11:11:56 UTC-7, Ella Stern escreveu:
    On Thursday, September 22, 2022 at 8:19:36 PM UTC+3, Dan wrote:
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are >>>> predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...
    I think that to open the page with the browser is easy, but to interact with the page isn't. How to automagically compile the fields user/passw? Once the browser starts, you have no control on it, if not via OLE. The only thing I tried has been: open the page, print it, close. Not very much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a local page carefully crafted (=with a script that modifies the FRAME/IFRAME content). This is forbidden if the loaded page is not in the same domain of the local page (cross-domain policy). Years ago I studied the problem and tried some hacks, but to no avail. Google "script injection" if you are interested. Recent improvement in browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour), modify the HTML (now the page is simply a text file on your PC), injecting a script able to compile the controls (a bit less easy), then open in the browser the modified page that should result pre-compiled. Unsure, however. Never tried such a thing.

    Dan
    If the login is done via GET request, the user and password are always URL parameters.
    If the login is done via POST request, only JavaScript code can do it, browsers are not able to "post".
    Anyway, you cannot open a local .html file generated dynamically by your desktop app (see Dan's comment), but you can call your own web app to do many more things for you.

    And in order to get back to the desktop app there are needed three pieces of software:
    - (A) a server-side function of the website, which is able to receive a call from the website frontend, and a call the desktop app
    - (B) a function of the website frontend, which is calling (A) to notify it that the user is done with the website
    - (C) a function of the desktop app, which is polling periodically (A) in order to check, that the user is done with the website, or not yet
    Using CURL you can do something like that, the unique point like said before is the captcha, I recommend you download capcha image and show it around
    fields that will request the user/password, then after you have it you can goto the next step.

    emg, dan, ella, lai...@paysoft.com.br:

    forget about 'captcha'. are you gurus saying even 'userid, password' (variables from a .dbf) 'just cannot' be autofilled from within my app. ?
    (the user will type in the captcha)

    thanks.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lailton Fernando Mariano@21:1/5 to All on Tue Sep 27 14:24:16 2022
    Em terça-feira, 27 de setembro de 2022 às 09:31:46 UTC-7, timec...@gmail.com escreveu:
    On Tuesday, September 27, 2022 at 10:39:13 AM UTC+5:30, lai...@paysoft.com.br wrote:
    Em quinta-feira, 22 de setembro de 2022 às 11:11:56 UTC-7, Ella Stern escreveu:
    On Thursday, September 22, 2022 at 8:19:36 PM UTC+3, Dan wrote:
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...
    I think that to open the page with the browser is easy, but to interact
    with the page isn't. How to automagically compile the fields user/passw?
    Once the browser starts, you have no control on it, if not via OLE. The
    only thing I tried has been: open the page, print it, close. Not very much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a local page carefully crafted (=with a script that modifies the FRAME/IFRAME content). This is forbidden if the loaded page is not in the same domain of the local page (cross-domain policy). Years ago I studied the problem and tried some hacks, but to no avail. Google "script injection" if you are interested. Recent improvement in browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour), modify the HTML (now the page is simply a text file on your PC), injecting a script able to compile the controls (a bit less easy), then
    open in the browser the modified page that should result pre-compiled. Unsure, however. Never tried such a thing.

    Dan
    If the login is done via GET request, the user and password are always URL parameters.
    If the login is done via POST request, only JavaScript code can do it, browsers are not able to "post".
    Anyway, you cannot open a local .html file generated dynamically by your desktop app (see Dan's comment), but you can call your own web app to do many more things for you.

    And in order to get back to the desktop app there are needed three pieces of software:
    - (A) a server-side function of the website, which is able to receive a call from the website frontend, and a call the desktop app
    - (B) a function of the website frontend, which is calling (A) to notify it that the user is done with the website
    - (C) a function of the desktop app, which is polling periodically (A) in order to check, that the user is done with the website, or not yet
    Using CURL you can do something like that, the unique point like said before is the captcha, I recommend you download capcha image and show it around
    fields that will request the user/password, then after you have it you can goto the next step.
    emg, dan, ella, lai...@paysoft.com.br:

    forget about 'captcha'. are you gurus saying even 'userid, password' (variables from a .dbf) 'just cannot' be autofilled from within my app. ?
    (the user will type in the captcha)

    thanks.

    Yes, you can do that.

    simple way:
    http://www.pctoledo.com.br/forum/viewtopic.php?f=4&t=19242

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to timepro timesheet on Sun Oct 16 11:53:12 2022
    On Tuesday, September 27, 2022 at 10:01:46 PM UTC+5:30, timepro timesheet wrote:
    On Tuesday, September 27, 2022 at 10:39:13 AM UTC+5:30, lai...@paysoft.com.br wrote:
    Em quinta-feira, 22 de setembro de 2022 às 11:11:56 UTC-7, Ella Stern escreveu:
    On Thursday, September 22, 2022 at 8:19:36 PM UTC+3, Dan wrote:
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...
    I think that to open the page with the browser is easy, but to interact
    with the page isn't. How to automagically compile the fields user/passw?
    Once the browser starts, you have no control on it, if not via OLE. The
    only thing I tried has been: open the page, print it, close. Not very much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a local page carefully crafted (=with a script that modifies the FRAME/IFRAME content). This is forbidden if the loaded page is not in the same domain of the local page (cross-domain policy). Years ago I studied the problem and tried some hacks, but to no avail. Google "script injection" if you are interested. Recent improvement in browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour), modify the HTML (now the page is simply a text file on your PC), injecting a script able to compile the controls (a bit less easy), then
    open in the browser the modified page that should result pre-compiled. Unsure, however. Never tried such a thing.

    Dan
    If the login is done via GET request, the user and password are always URL parameters.
    If the login is done via POST request, only JavaScript code can do it, browsers are not able to "post".
    Anyway, you cannot open a local .html file generated dynamically by your desktop app (see Dan's comment), but you can call your own web app to do many more things for you.

    And in order to get back to the desktop app there are needed three pieces of software:
    - (A) a server-side function of the website, which is able to receive a call from the website frontend, and a call the desktop app
    - (B) a function of the website frontend, which is calling (A) to notify it that the user is done with the website
    - (C) a function of the desktop app, which is polling periodically (A) in order to check, that the user is done with the website, or not yet
    Using CURL you can do something like that, the unique point like said before is the captcha, I recommend you download capcha image and show it around
    fields that will request the user/password, then after you have it you can goto the next step.
    emg, dan, ella, lai...@paysoft.com.br:

    forget about 'captcha'. are you gurus saying even 'userid, password' (variables from a .dbf) 'just cannot' be autofilled from within my app. ?
    (the user will type in the captcha)

    thanks.

    ok, can this be programmed?
    from inside my app: open hpps://thewebsite.abc
    with the 'login' tab clicked. -something like SHELLEXECUTE( 0, 0, thewebsite/login, 0, 0, 1 ) -
    the user will then input the userid, password, captcha.

    tia

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lailton Fernando Mariano@21:1/5 to All on Tue Oct 18 06:56:38 2022
    Em domingo, 16 de outubro de 2022 às 15:53:13 UTC-3, timec...@gmail.com escreveu:
    On Tuesday, September 27, 2022 at 10:01:46 PM UTC+5:30, timepro timesheet wrote:
    On Tuesday, September 27, 2022 at 10:39:13 AM UTC+5:30, lai...@paysoft.com.br wrote:
    Em quinta-feira, 22 de setembro de 2022 às 11:11:56 UTC-7, Ella Stern escreveu:
    On Thursday, September 22, 2022 at 8:19:36 PM UTC+3, Dan wrote:
    Il 22/09/2022 17:33, timepro timesheet ha scritto:
    On Thursday, September 22, 2022 at 7:42:12 PM UTC+5:30, Dan wrote:
    Il 22/09/2022 13:07, Enrico Maria Giordano ha scritto:
    Il 22/09/2022 11:38, timepro timesheet ha scritto:

    2. auto-login with userid,password,'captcha' (userid, password are
    predefined)

    The problem is the point 2. I don't think it is so easy or possible at all.

    Agreed. How to decode a captcha? The only way is to download the image,
    pass it to an OCR and read the output. While I have a program that does

    something similar, captcha is made exactly to avoid such a solution: the
    OCR would be fooled by the messy image.
    So, no way to overcome it, IMHO.

    Dan
    enrico, dan thanks for the interest.

    so, if not for the captcha, (from inside my app) can it be coded to: 'open a website, auto-login with userid & password'. (website, userid, password picked from a .dbf field).
    the user could then manually type/validate the captcha. (on the open website page).
    on exiting the website, return to my app's billing screen.

    also, when enrico replied 'not possible', is it with xhb+wvw or with xhb+any lib...
    I think that to open the page with the browser is easy, but to interact
    with the page isn't. How to automagically compile the fields user/passw?
    Once the browser starts, you have no control on it, if not via OLE. The
    only thing I tried has been: open the page, print it, close. Not very
    much... And it worked only with IE.

    Oh, and don't think to load the page in a IFRAME (or FRAME) inside a local page carefully crafted (=with a script that modifies the FRAME/IFRAME content). This is forbidden if the loaded page is not in
    the same domain of the local page (cross-domain policy). Years ago I studied the problem and tried some hacks, but to no avail. Google "script injection" if you are interested. Recent improvement in browser's security make the thing even more difficult at present.

    One solution could be to download the page (quite easy with xHarbour),
    modify the HTML (now the page is simply a text file on your PC), injecting a script able to compile the controls (a bit less easy), then
    open in the browser the modified page that should result pre-compiled.
    Unsure, however. Never tried such a thing.

    Dan
    If the login is done via GET request, the user and password are always URL parameters.
    If the login is done via POST request, only JavaScript code can do it, browsers are not able to "post".
    Anyway, you cannot open a local .html file generated dynamically by your desktop app (see Dan's comment), but you can call your own web app to do many more things for you.

    And in order to get back to the desktop app there are needed three pieces of software:
    - (A) a server-side function of the website, which is able to receive a call from the website frontend, and a call the desktop app
    - (B) a function of the website frontend, which is calling (A) to notify it that the user is done with the website
    - (C) a function of the desktop app, which is polling periodically (A) in order to check, that the user is done with the website, or not yet
    Using CURL you can do something like that, the unique point like said before is the captcha, I recommend you download capcha image and show it around
    fields that will request the user/password, then after you have it you can goto the next step.
    emg, dan, ella, lai...@paysoft.com.br:

    forget about 'captcha'. are you gurus saying even 'userid, password' (variables from a .dbf) 'just cannot' be autofilled from within my app. ?
    (the user will type in the captcha)

    thanks.
    ok, can this be programmed?
    from inside my app: open hpps://thewebsite.abc
    with the 'login' tab clicked. -something like SHELLEXECUTE( 0, 0, thewebsite/login, 0, 0, 1 ) -
    the user will then input the userid, password, captcha.

    tia

    Yes, you can do that.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to All on Tue Oct 18 07:14:51 2022
    On Tuesday, October 18, 2022 at 7:26:39 PM UTC+5:30, lai...@paysoft.com.br wrote:
    Yes, you can do that.

    thanks for the revert.

    would you facilitate me with the syntax/function...
    -is it a 1 line statement/function/coding...

    wwwtax='httpS://einvoice1.gst.gov.in/login'
    i tried, but does not work: SHELLEXECUTE( 0, 0, wwwtax, 0, 0, 1 )

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lailton Fernando Mariano@21:1/5 to All on Tue Oct 18 07:18:21 2022
    Em terça-feira, 18 de outubro de 2022 às 11:14:52 UTC-3, timec...@gmail.com escreveu:
    On Tuesday, October 18, 2022 at 7:26:39 PM UTC+5:30, lai...@paysoft.com.br wrote:
    Yes, you can do that.
    thanks for the revert.

    would you facilitate me with the syntax/function...
    -is it a 1 line statement/function/coding...

    wwwtax='httpS://einvoice1.gst.gov.in/login'
    i tried, but does not work: SHELLEXECUTE( 0, 0, wwwtax, 0, 0, 1 )

    try:

    shellexecute(0,"open”,"https://einvoice1.gst.gov.in/login")

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From timepro timesheet@21:1/5 to All on Tue Oct 18 08:22:21 2022
    thanks for your effort.

    shellexecute(0,"open”,"https://einvoice1.gst.gov.in/login")
    this does not compile.

    i tried:
    wwweinvoice="https://einvoice1.gst.gov.in/login" shellexecute(0,"open",wwweinvoice)
    shellexecute(0,"open",wwweinvoice,0,0,1) shellexecute(0,0,"open",wwweinvoice,0,0,1)
    but, none works.

    this could be tried:
    -open einvoice1.gst.gov.in
    -right click on the 'login' tab.
    -view the 'page source'

    i too could, buy it's just beyond my 'pay grade'

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Lailton Fernando Mariano@21:1/5 to All on Tue Oct 18 08:42:55 2022
    Em terça-feira, 18 de outubro de 2022 às 12:22:23 UTC-3, timec...@gmail.com escreveu:
    thanks for your effort. shellexecute(0,"open”,"https://einvoice1.gst.gov.in/login")
    this does not compile.

    i tried:
    wwweinvoice="https://einvoice1.gst.gov.in/login" shellexecute(0,"open",wwweinvoice)
    shellexecute(0,"open",wwweinvoice,0,0,1) shellexecute(0,0,"open",wwweinvoice,0,0,1)
    but, none works.

    this could be tried:
    -open einvoice1.gst.gov.in
    -right click on the 'login' tab.
    -view the 'page source'

    i too could, buy it's just beyond my 'pay grade'

    If you have Skype add me and message me in there. or send me in private your number for Telegram/Whatsapp to my email lailton@paysoft.com.br

    Regards.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)