Messages

16

Web Server - Ask For Help / Re: How to allow file upload in an NT8 Webservice

« on: July 07, 2014, 06:36:20 AM »

Thanks Bruce and Djordje.  With the explanation Bruce gave in the user group meeting #25 I got it worked out!

Thanks
Debra 

17

Web Server - Ask For Help / Task Panel display issue NT 8.17

« on: July 05, 2014, 09:15:45 AM »

Hi Bruce,
In NT 8.17 the task panel menu has the text overlapping the arrow icons.  See screen shot for the example.

Thanks,
Debra

[attachment deleted by admin]

18

Web Server - Ask For Help / WebService - Access to XML.AssignField procedure

« on: July 05, 2014, 07:08:26 AM »

Hi Bruce
I have a web service that returns a view.  In my view is a date, I would like to format this date before it is sent.  I do not seem to have access to the xml.AssignField procedure to do this though.  Any way I can do this?

Thanks
Debra

19

Web Server - Ask For Help / How to allow file upload in an NT8 Webservice

« on: July 02, 2014, 12:31:06 PM »

Hi All,

How can I upload a picture or file to a WebServiceMethod?  Ideally I would like to be able to upload more than one file at a time, but not required. 

It does not have to be done via a WebServiceMethod, but I am a little confused by this post http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=5150.0
The part that confuses me is using the web page, so do I create by own form in a routine? And if so how do I access the values and file upload from the form?

Thanks

Debra

20

Web Server - Ask For Help / Re: WebService Content Length Error

« on: July 02, 2014, 10:53:45 AM »

Thanks for the explanation, makes sense.   I was having an issue on my client side but it turned out to be unrelated

Thanks again

Debra

21

Web Server - Ask For Help / WebService Content Length Error

« on: July 01, 2014, 11:30:21 AM »

Hi Bruce

In NT 8.17, I have a webservice that returns a view.  If I have more than 2 records that return my Content Length is wrong in my header.  Here is an example of what I mean, the below XML is 1769 characters long, the content length in the header says its 491.  

This does not seem to be data specific, it appears I can use any combination of records, so long as it is less than 3.  If I have 1 or 2 records the content length is correct.

I attached the CLW, let me know if you still need an example app.

Code: [Select]

Status
200 OK Show explanation Loading time: 1370
Request headers
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_3) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/35.0.1916.153 Safari/537.36
Origin: chrome-extension://hgmloofddffdnphfgcellkdfbfbjeloo
Content-Type: application/x-www-form-urlencoded
Accept: */*
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cookie: SESSIONID=Hx813QeEf4MuXbnHcKtNA4Yhz6yltR
Response headers
Date: Tue, 01 Jul 2014 19:19:59 GMT
Server: NetTalk-WebServer/8.17
Content-Length: 491
Content-Encoding: gzip
Content-Type: text/xml
Connection: keep-alive
X-Frame-Options: sameorigin

Code: [Select]

<?xml version="1.0"?>
<DriversTickets_response>
  <Tickets>
    <IMP_CALLNO>141</IMP_CALLNO>
    <IMP_CUSTID>CASH</IMP_CUSTID>
    <IMP_INVNO>A000-141</IMP_INVNO>
    <IMP_OWNERNAME>John Samuels</IMP_OWNERNAME>
    <IMP_CALLBACK>6057161298</IMP_CALLBACK>
    <IMP_LOCATION>605 E St Anne St.</IMP_LOCATION>
    <IMP_TOWED_TO>1107 Silver St.</IMP_TOWED_TO>
    <IMP_LOCATIONCITY>Rapid City</IMP_LOCATIONCITY>
    <IMP_TOWED_TOCITY>Rapid City</IMP_TOWED_TOCITY>
    <IMP_COMMENT/>
    <IMP_GUID>$$280KFlKgeMisnT</IMP_GUID>
    <VTAT_TOW_STATUS>On-Scene</VTAT_TOW_STATUS>
    <VTAT_RELATE_EMPLOYEE_GUID>A0000K9FDtj7Q5EH</VTAT_RELATE_EMPLOYEE_GUID>
  </Tickets>
  <Tickets>
    <IMP_CALLNO>148</IMP_CALLNO>
    <IMP_CUSTID/>
    <IMP_INVNO>A000-148</IMP_INVNO>
    <IMP_OWNERNAME/>
    <IMP_CALLBACK>4168799999</IMP_CALLBACK>
    <IMP_LOCATION>23 Creditstone rd</IMP_LOCATION>
    <IMP_TOWED_TO>140 doughton rd</IMP_TOWED_TO>
    <IMP_LOCATIONCITY>concord</IMP_LOCATIONCITY>
    <IMP_TOWED_TOCITY>concord</IMP_TOWED_TOCITY>
    <IMP_COMMENT/>
    <IMP_GUID>$$530KGDNCzoLX4A</IMP_GUID>
    <VTAT_TOW_STATUS>En-Route</VTAT_TOW_STATUS>
    <VTAT_RELATE_EMPLOYEE_GUID>A0000K9FDtj7Q5EH</VTAT_RELATE_EMPLOYEE_GUID>
  </Tickets>
  <Tickets>
    <IMP_CALLNO>150</IMP_CALLNO>
    <IMP_CUSTID/>
    <IMP_INVNO>A000-150</IMP_INVNO>
    <IMP_OWNERNAME/>
    <IMP_CALLBACK/>
    <IMP_LOCATION>33 peeler rd</IMP_LOCATION>
    <IMP_TOWED_TO/>
    <IMP_LOCATIONCITY>Concord</IMP_LOCATIONCITY>
    <IMP_TOWED_TOCITY/>
    <IMP_COMMENT/>
    <IMP_GUID>$$930KGEDs2085Nz</IMP_GUID>
    <VTAT_TOW_STATUS>En-Route</VTAT_TOW_STATUS>
    <VTAT_RELATE_EMPLOYEE_GUID>A0000K9FDtj7Q5EH</VTAT_RELATE_EMPLOYEE_GUID>
  </Tickets>
  </DriversTickets_response>
[attachment deleted by admin]

22

Web Server - Ask For Help / Re: WebServices Errors

« on: June 17, 2014, 12:06:41 PM »

Thanks Bruce!  I will keep you posted if I find any others.

23

Web Server - Ask For Help / WebServices Errors

« on: June 15, 2014, 07:07:55 AM »

Hello!
When I create a webservice over a table that has a date group I get the below errors.  Attached is an example.
NT 8.16
StringTheory 2.07
xFiles 2.53

Thanks,
Debra


Expected: <ID> & CLASS GROUP INTERFACE QUEUE  - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1494,28
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1554,10
Must specify identifier - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1555,64
Must specify identifier - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1555,61
Must specify identifier - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1555,45
Must specify identifier - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1555,24
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1555,14
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1605,10
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1606,7
Field not found: PAY_PAYID - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1606,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1607,7
Field not found: PAY_TYPE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1607,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1608,7
Field not found: PAY_ACCTNO - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1608,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1609,7
Field not found: PAY_DATE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1609,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1610,7
Field not found: PAY_TENDOR - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1610,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1611,7
Field not found: PAY_EXPDATE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1611,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1612,7
Field not found: PAY_CHECKNO - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1612,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1613,7
Field not found: PAY_AMOUNT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1613,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1614,7
Field not found: PAY_NOTE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1614,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1615,7
Field not found: PAY_LASTUPDATEDBY - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1615,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1616,7
Field not found: PAY_SETRELEASEDDATETOSTRING - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1616,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1617,7
Field not found: PAY_SETRELEASEDDATETOGROUP - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1617,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1618,7
Field not found: PAY_SETRELEASEDDATETO - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1618,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1619,7
Field not found: PAY_SETRELEASEDDATETO_TIME - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1619,17
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1620,7
Field not found: PAY_ - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1620,17
No matching prototype available - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1621,8
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1633,27
Invalid structure as first parameter - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1634,10
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1638,27
Invalid structure as first parameter - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1639,10
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1644,27
Invalid structure as first parameter - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1645,10
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1657,15
Field not found: PAY_PAYID - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1657,25
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1658,14
Field not found: PAY_TYPE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1658,24
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1659,16
Field not found: PAY_ACCTNO - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1659,26
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1660,14
Field not found: PAY_DATE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1660,24
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1661,16
Field not found: PAY_TENDOR - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1661,26
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1662,17
Field not found: PAY_EXPDATE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1662,27
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1663,17
Field not found: PAY_CHECKNO - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1663,27
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1664,16
Field not found: PAY_AMOUNT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1664,26
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1665,14
Field not found: PAY_NOTE - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1665,24
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1666,23
Field not found: PAY_LASTUPDATEDBY - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1666,33
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1667,33
Field not found: PAY_SETRELEASEDDATETOSTRING - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1667,43
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1668,32
Field not found: PAY_SETRELEASEDDATETOGROUP - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1668,42
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1669,27
Field not found: PAY_SETRELEASEDDATETO - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1669,37
Unknown identifier: Q:PAYMENT - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1670,32
Field not found: PAY_SETRELEASEDDATETO_TIME - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1670,42
Unknown identifier: PAY: - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1671,3
Field not found: PAY_ - c:\Clarion-8-Versions\ExamplesForHelp\WebServices\WebService003.clw:1671,20

[attachment deleted by admin]

24

Web Server - Ask For Help / Re: Basic Filtering

« on: June 12, 2014, 08:29:23 AM »

`yes you can do that.  I think you can see examples of similar fuctions in the HotDates example with the calendar.
Basically you are going to create a NetWebForm with the source being Memory, not a table. 
1) Create 2 local variables on the page that are your start and end date. Say they are named loc:StartDate and loc:EndDate.
2) Add to the form your Browse using the Procedure control type.
3) Add a button to execute the filter and refresh the browse... on the Client-Side tab of the button, add the browse control to the reset list
4) Save that, and go to your browse
5) On the filter tab of the browse, you can add a conditional filter for being a Child of the Form you created above, and for the filter do something like this

Code: [Select]

'MyDate >= '&p_web.gsv('loc:StartDate')&' and MyDate <= '&p_web.gsv('loc:EndDate')6) Make sure to call your new memory form rather than the browse directly

Hope that helps,
Debra

25

Web Server - Ask For Help / Re: Google drive?

« on: June 10, 2014, 04:52:14 AM »

Nick
I have the oAuth2 side of things working, just not ready to share the example publicly yet.  But if you need it sooner rather than later, PM me and I will help get you going. 
Once the have the authentication side done, its no big deal to implement the calls to the API.

Debra

26

Web Server - Ask For Help / Re: Mobile Mode 'Cancel' Button Bug

« on: May 30, 2014, 05:32:37 AM »

Hi Trent,
Make sure that the form is not asking to confirm a cancel...  the messages for cancel and delete do not work in mobile and prevent the app from performing the task requested.

Hope that helps!
Debra

27

Web Server - Ask For Help / Re: json Support?

« on: May 23, 2014, 04:11:41 AM »

Thanks Bruce, my vote is the sooner the better    My project would be sooo much easier with a utility. 

28

Web Server - Ask For Help / json Support?

« on: May 22, 2014, 04:02:04 PM »

Hi Bruce

What support for json parsing does NetTalk (or any other utility) have?   I need reading of json more than writing...  here is an example of some data that I need to parse

Code: [Select]

Content-Type: application/json
{
"totalCount":25,
"offSet":0,
"limit":10,
"results":[
    {
        "comments":null,
        "statusHistory":null,
        "serviceType":"Tow",
        "coverage":null,
        "dispatchRequestNumber":"463798552",
        "urgency":null,
        "referenceNumber":null,
        "poNumber":"245711363",
        "problem":null,
        "equipment":
            {
                "type":"Light Duty Flatbed",
                "equipmentId":null
            },
        "receivedTime":"2013-11-11T16:14:59Z",
        "acceptedTime":"2013-11-11T16:14:57Z",
        "currentStatus":
           {
               "code":"0",
               "description":"UNASSIGNED",
               "eta":0,
               "reason":null,
               "reasonCode":0,
               "source":null,
               "extJobId":null,
               "latitude":0.0,
               "longitude":0.0,
               "statusTime":"0001-01-01T00:00:00",
               "driverId":0,
               "reportedBy":"USER"
             },
        "vehicle":
           {
               "vin":null,
               "year":"2011",
               "state":null,
               "make":"All Wheel Drive Equip.",
               "mileage":0,
               "model":"NULL",
               "color":"Unknown",
               "plate":null,
               "VehicleType":null,
               "driveTrainType":null,
               "fuelType":null
            },
        "disablementLocation":
            {
               "contactInfo":
                    {
                       "callbackNumber":null,
                       "name":"HOME 1",
                       "phone":null
                    },
                "dropInstructions":null,
                "garageClearanceHeight":null,
                "garageLevel":null,
                "isDriverWithVehicle":true,
                "nightDropOff":false,
                "parked":false,
                "address1":"422 North St",
                "address2":null,
                "crossStreet":null,
                "landmark":null,
                "locationType":null,
                "city":"Randolph",
                "poi1":null,
                "poi2":null,
                "state":"MA",
                "postalCode":"02368",
                "lat":42.1758751377985,
                "lng":-71.0348727425857
            },
        "towDestination":
            {
                "contactInfo":
                   {
                       "callbackNumber":null,
                       "name":"TOW TO",
                       "phone":""
                    },
                "nightDropOff":false,
                "address1":null,
                "address2":null,
                "crossStreet":null,
                "landmark":"",
                "locationType":"Dealership",
                "city":"DEDHAM",
                "poi1":null,
                "poi2":null,
                "state":"MA",
                "postalCode":null,
                "lat":42.24903717041,
                "lng":-71.176467895508
            },
        "assignedDriver":null,
        "eta":"2013-11-11T17:14:57",
        "etaInMinutes":60,
        "revisedEta":"2013-11-11T17:29:57",
        "revisedEtaInMinutes":15,
        "etaRevisionCount":1,
        "responseTimeExtCount":0,
        "dispatcherContactNumber":null,
        "signatures":null
    }, .
       .
       .
       .
]
}

Thanks
Debra

29

Web Server - Share Knowledge / Re: oAuth v1 - Connecting to QuickBooks Online example

« on: May 19, 2014, 04:18:49 AM »

You're welcome, and feel free to include any examples you wish based in this example.  Web Apps that can connect to other services helps us all, and oAuth is the standard for now... so more examples only helps us all out 

30

Web Server - Ask For Help / Compile Errors when creating new controls NT 8.11

« on: May 18, 2014, 07:22:11 AM »

Hi All
When I create a new control in a page using NT 8.11 I am getting compile errors.  Here is an example of the code that it is failing on.  How do I resolve " = p_web.MakeWebRelative()"?  Attached is the clw

Code: [Select]

 ! tab = 4
      If not (p_web.gsv('qbResult')='')
        loc:InvalidTab += 1
        do ValidateValue::btnAddAll
        If loc:Invalid then exit.
         = p_web.MakeWebRelative()
        do ValidateValue::BrowseQB_Items
        If loc:Invalid then exit.
         = p_web.MakeWebRelative()
      End
  ! tab = 2
Errors:

No matching prototype available - c:\Project\PTOM_Online332.clw:1963,33
Expected: <statement> <INT> <REAL> <DECIMAL> <STRING> <LINEBREAK> ( ; ACCEPT ASSERT CHOOSE ELSE ELSIF END INCLUDE OMIT RAISE TRY SECTION COMPILE BEGIN PRAGMA  - c:\Project\PTOM_Online332.clw:1963,10
No matching prototype available - c:\Project\PTOM_Online332.clw:1966,33
Expected: <statement> <INT> <REAL> <DECIMAL> <STRING> <LINEBREAK> ( ; ACCEPT ASSERT CHOOSE ELSE ELSIF END INCLUDE OMIT RAISE TRY SECTION COMPILE BEGIN PRAGMA  - c:\Project\PTOM_Online332.clw:1966,10
No matching prototype available - c:\Project\PTOM_Online332.clw:1973,33
Expected: <statement> <INT> <REAL> <DECIMAL> <STRING> <LINEBREAK> ( ; ACCEPT ASSERT CHOOSE ELSE ELSIF END INCLUDE OMIT RAISE TRY SECTION COMPILE BEGIN PRAGMA  - c:\Project\PTOM_Online332.clw:1973,10

And yes, I am on StringTheroy 2.05

[attachment deleted by admin]