NetTalk Central

Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - MikeR

Pages: [1] 2 3 ... 18
1
Web Server - Ask For Help / WebLog File
« on: February 22, 2023, 12:36:27 AM »
which embed point can I use to change the name of the weblog file
I also want a new file each day
it seems to be creating one every 30 minutes my idle time out parameter setting

2
Web Server - Ask For Help / Re: Export to Excel
« on: December 02, 2021, 07:52:14 AM »
Is there no webinar today ?

3
Web Server - Ask For Help / Export to Excel
« on: November 30, 2021, 05:04:31 AM »
The Export to Excel is a great feature.
Excel seems to decide for itself how to format the cell.
for example :
I have a string 20 field in column 2
they all happen to be numberic but stored on the database as 0001 0002 0003
in excel they are numbers like 1 2 3 4
how do I ensure the row remains a string field in excel ?
 

4
Unknown identifier: S_WEB - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,60
Field not found: DATAPATH - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,87
Field not found: DEFAULTS - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,78
Field not found: _SITESQUEUE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,66
Field not found: TRACE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp002.clw:761,15
Unknown identifier: NET - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:198,9
Field not found: CONTENTTYPE - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:198,13
Unknown identifier: NET - C:\Users\MikeRichards\Documents\Clarion11\NetTalk11\LexCorp\Lexcorp003.clw:199,9


LOTS and LOTS of them.
I tried renumbering and regenerating all procedures ?

Please Help

5
Web Server - Ask For Help / Base64 Encode and Decode
« on: May 02, 2021, 12:36:03 AM »
I have two Nettalk WebServers.
WebServer1 calls WebServer2 using a POST with a JSON PostData String.
WebServer2 returns a file (any File could be txt or PDF)
I have defined the return parameter as type StringTheory in the Webserver2 api.
In Webserver2 I create the file and load it into the stringtheory object.
I also do a Base64Encode.
In Webserver1 the calling program I load the returned value into a stringtheory object and do a Base64Decode.
Then I save it to disk.
If the returned file is txt this works fine.
But my pdf files are corrupt.(They cant be opened by adobe on the webserver1 machine. )
But they are created correctly and can open on the webserver2 machine.
There seems to be something going wrong in the encode and decode step that I dont understand.
 

6
Web Server - Ask For Help / NetWebBrowse Sort Headers
« on: January 24, 2021, 03:21:34 AM »
I have a NetWebBrowse with sort headers
They all work Perfectly as expected,
However if you add a Column Condition to the Browse :
Obviously if the condition is not met the Column does not show
However if the Condition them becomes True ,
The Column Appears but the sort and filter functionality do not work
DebugView shows the sort order as the PrimaryKey , but it doesnt do that either.
Has anyone noticed this effect and if so how did you resolve it ?


7
How do I automatically refresh a memory form every x minutes ?

8
Web Server - Ask For Help / s_web._SitesQueue.Defaults.ExternalHttps = 1
« on: August 05, 2020, 04:50:46 AM »
Hi
I am setting this in embed point

  ! Start of "Override Default Server Settings"
  ! [Priority 5000]
  s_web._SitesQueue.Defaults.ExternalHttps = glo:ExternalHttps   
  ! End of "Override Default Server Settings"

It still doesnt work for testing api calls, they generate http:// requests 

9
Thanks Bruce ,
How do I get the deaults to show as "value" instead of value in the test api screen ?

10
when I do a xml post my api works
when I do a json post I get errors

the following inputs and outputs:
1 xml
Input
<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <apiRegister xmlns="">
      <ClientIn>
        <USERID>**value**</USERID>
        <PASSWORD>**value**</PASSWORD>
        <CLIENTGUID>**value**</CLIENTGUID>
        <MANUALCODE>**value**</MANUALCODE>
        <TITLE>**value**</TITLE>
        <INITIALS>**value**</INITIALS>
        <FIRSTNAMES>**value**</FIRSTNAMES>
        <SURNAME>**value**</SURNAME>
        <IDNUMBER>**value**</IDNUMBER>
        <IISVALIDSA>**value**</IISVALIDSA>
        <CELLPHONE>**value**</CELLPHONE>
        <EMAIL>**value**</EMAIL>
        <HOMETEL>**value**</HOMETEL>
        <WORKTEL>**value**</WORKTEL>
        <FAXNO>**value**</FAXNO>
        <POSTALADDRESS>**value**</POSTALADDRESS>
        <RESIDENTIALADDRESS>**value**</RESIDENTIALADDRESS>
        <LANGUAGE>**value**</LANGUAGE>
        <DATEOFBIRTH>**value**</DATEOFBIRTH>
        <SEX>**value**</SEX>
        <CELLPHONEVERIFIED>**value**</CELLPHONEVERIFIED>
        <EMAILVERIFIED>**value**</EMAILVERIFIED>
        <OCCUPATION>**value**</OCCUPATION>
        <PASSPORTNUMBER>**value**</PASSPORTNUMBER>
        <BROKERGUID>**value**</BROKERGUID>
        <CHANGEDBY>**value**</CHANGEDBY>
      </ClientIn>

    </apiRegister>
  </soap:Body>
</soap:Envelope>

OutPut:
<?xml version="1.0"  encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
  <soap:Body>
    <apiRegister_response xmlns="">
      <ServiceErrors>
        <Error>
          <ErrorNumber>2</ErrorNumber>
          <ErrorPosition>apiClient</ErrorPosition>
          <ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
          <ErrorDescription>Invalid Title; **value**</ErrorDescription>
          <ErrorRecommendation/>
        </Error>
        <Error>
          <ErrorNumber>4</ErrorNumber>
          <ErrorPosition>apiClient</ErrorPosition>
          <ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
          <ErrorDescription>Invalid IdNumber: **value**</ErrorDescription>
          <ErrorRecommendation>SA ID Number must be a 13 digit numeric number</ErrorRecommendation>
        </Error>
        <Error>
          <ErrorNumber>8</ErrorNumber>
          <ErrorPosition>apiClient</ErrorPosition>
          <ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
          <ErrorDescription>Invalid Language: **value**</ErrorDescription>
          <ErrorRecommendation/>
        </Error>
        <Error>
          <ErrorNumber>9</ErrorNumber>
          <ErrorPosition>apiClient</ErrorPosition>
          <ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
          <ErrorDescription>Invalid Sex: **value**</ErrorDescription>
          <ErrorRecommendation>Must be Male or Female</ErrorRecommendation>
        </Error>
        <Error>
          <ErrorNumber>10</ErrorNumber>
          <ErrorPosition>apiClient</ErrorPosition>
          <ErrorRecordId>CLI_CLIENTGUID=**value**</ErrorRecordId>
          <ErrorDescription>Client with ID:**value** already Exists</ErrorDescription>
          <ErrorRecommendation/>
        </Error>
      </ServiceErrors>
    </apiRegister_response>
  </soap:Body>
</soap:Envelope>

This is an expected result
However
when I input Json

{
  "ClientIn" : {
    "USERID" : value,
    "PASSWORD" : value,
    "CLIENTGUID" : value,
    "MANUALCODE" : value,
    "TITLE" : value,
    "INITIALS" : value,
    "FIRSTNAMES" : value,
    "SURNAME" : value,
    "IDNUMBER" : value,
    "IISVALIDSA" : value,
    "CELLPHONE" : value,
    "EMAIL" : value,
    "HOMETEL" : value,
    "WORKTEL" : value,
    "FAXNO" : value,
    "POSTALADDRESS" : value,
    "RESIDENTIALADDRESS" : value,
    "LANGUAGE" : value,
    "DATEOFBIRTH" : value,
    "SEX" : value,
    "CELLPHONEVERIFIED" : value,
    "EMAILVERIFIED" : value,
    "OCCUPATION" : value,
    "PASSPORTNUMBER" : value,
    "BROKERGUID" : value,
    "CHANGEDBY" : value
  }
}

I get:

{
   "apiRegister_response" : {
      "ServiceErrors" : [
         {
            "ERRORNUMBER" : 9007,
            "ERRORPOSITION" : "apiRegister",
            "ERRORRECORDID" : "Input:Record",
            "ERRORDESCRIPTION" : "JSONClass.HandleChar: Unexpected literal (v) at position: 35 USERID\" : value,\n    \"PASSWORD\" : value,\n    \"CLIENTGUI",
            "ERRORRECOMMENDATION" : "Review JSON data and correct it."
         }
      ]
   }
}


11
Web Server - Ask For Help / Re: MultipleActiveResultSets
« on: May 11, 2020, 11:30:17 AM »
Thanks for the reply Guys.
How do I turn trace on ?
How do I look at the Trace ?
I did have MARS_Connection=Yes at the end of my connection string .
I changed it to /MULTIPLEACTIVERESULTSETS=TRUE as per FM3 documentation it puts it in the driver string of the GsmsSQL file that it users to open that table in the sqlconnect procedure before any other table is opened .

12
Web Server - Ask For Help / MultipleActiveResultSets
« on: May 09, 2020, 11:28:43 PM »
in My FM3 extention template
Auto Up SQL Driver String  I have:
/BUSYHANDLING=2 /MULTIPLEACTIVERESULTSETS=TRUE
exactly as the line above

In my webserver window procedure I check the following
        s_web.trace('JMR about to check busy handling')
        s_web.trace('JMR BusyHandling:' & company{PROP:BusyHandling})
        s_web.trace('JMR BusyRetries:' & company{PROP:BusyRetries})   
        s_web.Trace('JMR MARS:' & SEND(company,'/MULTIPLEACTIVERESULTSETS' ))

The JMR MARS trace displays FALSE

Does this send statement reset the MARS to False ?
How do I check that MARS is On ?
 

 

13
Web Server - Ask For Help / NetwebServer SQL Errors
« on: November 28, 2019, 01:03:30 AM »
Im Starting a new Thread when I come into Webserver
Its getting these SQL Errorrs when calling other procedures
Any Help from anyone using SQL will be greatly appreciated
Im using the following Driver string connection settings on filemanager
MARS_Connection=Yes;BUSYHANDLING=2



2019-11-27,03:01:15 PM, 0:00:00,Auto,1,Record Retrieval Error,Error: (Connection is busy with results for another command (S1000)) attempting to access a record from the dbo.documents file.  Returning to previous window.,BatchProcessor,Lexcorp.exe,
2019-11-27,03:01:15 PM, 0:00:00,Auto,1,Record Insert Error,An error was experienced during the creation of a record.|File: dbo.LogFile|Error: Connection is busy with results for another command (S1000).,BatchProcessor,Lexcorp.exe,
2019-11-27,03:01:15 PM, 0:00:00,Auto,1,Record was not updated,An error (Record Not Available (33)) was experienced when making changes to the dbo.Policy file.,BatchProcessor,Lexcorp.exe,
2019-11-27,03:01:25 PM, 0:00:00,Auto,1,Record Retrieval Error,Error: (Invalid cursor state (24000)) attempting to access a record from the dbo.documents file.  Returning to previous window.,BatchProcessor,Lexcorp.exe,
2019-11-27,03:01:25 PM, 0:00:00,Auto,1,Record was not updated,An error (Record Not Available (33)) was experienced when making changes to the dbo.Policy file.,BatchProcessor,Lexcorp.exe,
2019-11-27,03:05:55 PM, 0:00:00,Auto,1,Record Insert Error,An error was experienced during the creation of a record.|File: dbo.TransactionLog|Error: Connection is busy with results for another command (S1000).,BatchProcessor,Lexcorp.exe,
2019-11-27,03:05:55 PM, 0:00:00,Auto,1,Record was not updated,An error (Record Not Available (33)) was experienced when making changes to the dbo.Policy file.,BatchProcessor,Lexcorp.exe,
2019-11-27,03:05:55 PM, 0:00:00,Auto,1,Record Insert Error,An error was experienced during the creation of a record.|File: dbo.Client|Error: Connection is busy with results for another command (S1000).,BatchProcessor,Lexcorp.exe,
2019-11-27,03:05:55 PM, 0:00:00,Auto,1,Record Insert Error,An error was experienced during the creation of a record.|File: dbo.NedbankDaily|Error: Connection is busy with results for another command (S1000).,BatchProcessor,Lexcorp.exe,

14
Web Server - Ask For Help / edactor HTML Editor
« on: November 21, 2019, 03:58:01 AM »
In a netwebForm for a Table when you define a tablefield as text and use redactor as the editor It all works lekker (South African Slang)
However on a netwebform that is a memory form if you use a localvariable as the text field It initailizes the redactor editor correctly but you cant get the new contents back into the session value. Even if you set send new value to server that code does not execute. HELP ???

15
Hi I changed a form from table to div mode
It has a browse procedure (tablemode) , as one of its fields, which has a procedure as a child to show bottom left
The child for that browse now shows next to it not bottom left
if I change back to table mode all works well again.

Pages: [1] 2 3 ... 18