Topics

1

Web Server - Ask For Help / Call a related table update form (SOLVED)

« on: May 16, 2025, 03:11:42 AM »

Hi,

From a button on the update form of table A, I would like to call the update form of a related table B.
On the button > Client-Side > Send new value to server, I get the record of the related table B (and verifies with debugview++ that it is the correct record) but I have no luck with calling the related update form.

Have tried various variants of code hacked from table B's browse, but without success.  See code below:

Code: [Select]

    DO OpenFiles
    !Get record of table A
    Access:MobSagH.ClearKey(MSagH:KeyGUID)
    MSagH:GUID =  p_web.GSV('MSagH:GUID')
    NOMEMO(MobSagH)
    IF Access:MobSagH.TryFetch(MSagH:KeyGUID)
        !failed
    ELSE
        !Get record of table B
        Access:MobCustomers.ClearKey(MCus:KeyGUID)
        MCus:GUID =  MSagH:KundeGUID
        NOMEMO(MobCustomers)
        IF Access:MobCustomers.TryFetch(MCus:KeyGUID)
            !failed
        ELSE
            ds_outputdebugstring('RET KUNDEN - **OK**  MSagH:KundeGUID: ' & MSagH:KundeGUID)
            p_web.SSV('MCus:CUSTOMERNO', MCus:CUSTOMERNO)       

            !This doesn't work
            UpdateMobCustomers(p_web,Net:Web:Popup)  !Form Procedure
                   
        END
    END
    DO CloseFiles
What am I missing here?

tia
/Poul

2

Web Server - Ask For Help / Avoid downloaded file been served from browser cache (SOLVED)

« on: May 12, 2025, 12:32:44 AM »

Hi,

Using this to download a file:

Code: [Select]

p_web.HeaderDetails.ContentDisposition =  'attachment; filename="'& CLIP(Loc:DownloadFileName) &'"'
Works fine first time, but if user later downloads same file, it is being served from internet browsers cache, and therefore not the latest version af the file.

How can I avoid this?

tia
/Poul

3

Web Server - Ask For Help / How to set file upload filetypes (SOLVED)

« on: May 11, 2025, 10:49:39 PM »

Hi,

Where do I set the filetypes for the filepicker used in the File Upload on a NT form?

tia
/Poul

4

Web Server - Ask For Help / Changing theme has no effect (SOLVED)

« on: April 17, 2025, 02:27:20 AM »

In Webhandler - ParseRequestHeader I have:

Code: [Select]

GloTheme =  GETINI('KundeProg','Theme_' & p_web.GSV('CommandA') ,'redmond', clip(path()) & '\KundeProg.ini')
ds_outputdebugstring('In ParseRequestHeader - GloTheme: ' & GloTheme )

self.ChangeTheme( GloTheme )
but no change in theme is being done.
I have verified that the correct theme is picked from the ini-file.

Any hints?

tia
/Poul

5

Web Server - Ask For Help / Pass parameter in servercall? (SOLVED)

« on: April 14, 2025, 08:39:08 PM »

Hi,

I would like to pass a parameter to the NT server like this:
https://myntserver.com?a=x

And then read the value x into a session value in the webserver procedure.

How do I do this?

tia
/Poul

6

Web Server - Ask For Help / Custom icon for markers on NT Maps?

« on: April 07, 2025, 03:09:43 AM »

Hi,

NT Maps have marker icons that are located in /web/images and have filenames like marker-icon-aqua.png, marker-icon-blue.png etc.
The markers are defined in d:\Clarion11\accessory\libsrc\win\NetWeb\web\scripts\jquery.nt-maps.js

I would like to add my own icons like the ones with letters shown on attached screenshot from my desktop map.

Since I only use 4 colours I *could* modify the unused icons in the shipping set, but I would rather add my own custom icons.
Is it possible to add additional js code somewhere, without modifying the shipping jquery.nt-maps.js.  Something like this:

Code: [Select]

var myYellowVMarker = L.icon({
    iconUrl: '/images/marker-icon-yellowV.png',
    iconRetinaUrl: '/images/marker-icon-yellowV-2x.png',
    shadowUrl: '/images/marker-shadow.png',
    iconSize: [25, 41],
    iconAnchor: [12, 41],
    popupAnchor: [1, -34],
    shadowSize: [41, 41]
});
Cheers
/Poul

7

Web Server - Ask For Help / Maps on mobile have big left padding

« on: April 02, 2025, 11:04:43 AM »

Hi,

At the moment I have two procedures with the map. One for desktop and one for mobile.
The one shown is selected based on clients screenwidth, and this works fine.

On desktop the map is shown as expected with no left margin / padding, but on mobile there is a large left margin, that I *think* is due to a class called "nt-tab-inner".

How can I get rid of that, so the mobile map is all the way to the left edge of the screen?

PS:  I do inspect the page code in desktop browsers dev. tools with emulation set to Samsung S8.  Will this 100% represents what I will see on the mobile?

tia
/Poul

8

Web Server - Ask For Help / NT map: clickable markers does not work work on mobile

« on: March 29, 2025, 02:22:57 AM »

Hi,

NT Maps (Esri - but that does not matter) have points/markers that when clicked opens an update form.
This works great on the PC, but nothing happens on the smartphone.

Any ideas?

tia
/Poul

9

Web Server - Ask For Help / Wrong encoding of text on maps

« on: March 13, 2025, 12:10:59 AM »

Hi,

In Webserver procedure, Webserver settings, General I have this to correctly work with the tables in the database that is shared with a desktop app:
Charset: utf-8
Store data as: Scandinavian (windows 1252)

But on the map, the tooltip text is wrong.  See attached image.

The table containing the points are dynamically filled, so I thought I could encode the textfield there, so it would show properly.  But no luck so far.

Any ideas most welcome.

tia
/Poul

10

Web Server - Ask For Help / NT Maps - update calling different table/record (SOLVED)

« on: March 12, 2025, 12:50:11 AM »

Hi,

I fill the points table to be shown in a NT map dynamically.
When user clicks a pointer on the map, I need to update a record from a related table, and not the point record itself.

Is this possible?

tia
/Poul

11

Web Server - Ask For Help / How to fill map data before showing HERE map

« on: March 07, 2025, 10:20:13 AM »

Hi,

I am trying to show a number of points on a HERE map using a NetWebForm (memory).
The points are added to the table when called (after deleting old points).
I have looked closely at example web76, but cannot get any map to show at all in my app.

The desktop version of the app works as expected.

There may be more issues, but I would like to find the ideal point where I am deleting old and adding new points to the table.
At the moment this is done at the NetWebForm Procedure Setup embed, but this means that the table is processed three times!

How can I avoid this, so it is process only once?

tia
/Poul

12

Web Server - Ask For Help / Global template: Secret 1 / 2

« on: March 06, 2025, 10:45:04 PM »

Hi,

What is the purpose of the two settings in NT Global template / Advanced:
Secret 1 and Secret 2 ?

I cannot locate the info for Global template in the extensive NT docs.

tia
/Poul

13

Web Server - Ask For Help / LE error: Unable to get certificate - Challenge was invalid

« on: January 25, 2025, 11:01:16 PM »

Hi

Trying to use Letsencrypt but it fails with this message:
Unable to get certificate - Challenge was invalid

Debugview log:

Code: [Select]

[ 1/26/25- 7:37:36]  Setting Folders for Domain [mobil1.domain.org]
[ 1/26/25- 7:37:36]  Created C:\pstellar7\MariSoft\certificates\mobil1.domain.org.csr.der
[ 1/26/25- 7:37:36]  Setting Folders for Domain [mobil1.domain.org]
[ 1/26/25- 7:37:36]  C:\pstellar7\MariSoft\certificates\mobil1.domain.org.crt does not exist
[ 1/26/25- 7:37:36]  Time to update the certificate mobil1.domain.org
[ 1/26/25- 7:37:40]  Registering Account MarisoftWeb1 at  https://acme-staging-v02.api.letsencrypt.org/acme/new-acct
[ 1/26/25- 7:37:41]  Authorize Request mobil1.domain.org
[ 1/26/25- 7:37:43]  Get Authorize mobil1.domain.org
[ 1/26/25- 7:37:44]  HTTP Challenge will be used
[ 1/26/25- 7:37:44]  Challenge Token Saved C:\pstellar7\MariSoft\web\.well-known\acme-challenge\LcML2B1oQ1Dia0N1kH0gxnNjdgRJbpVeiQf1n7q0UtI
[ 1/26/25- 7:37:44]  LE Server will now fetch http://mobil1.domain.org:80/.well-known/acme-challenge/LcML2B1oQ1Dia0N1kH0gxnNjdgRJbpVeiQf1n7q0UtI
[ 1/26/25- 7:37:44]  Notify Server Challenge is Ready: https://acme-staging-v02.api.letsencrypt.org/acme/chall/181883304/15838799894/c_rB6g
[ 1/26/25- 7:37:45]  Checking Status
[ 1/26/25- 7:37:46]  Get Authorize mobil1.domain.org
[ 1/26/25- 7:37:47]  Status: "invalid"
[ 1/26/25- 7:37:47]  Unable to get certificate - Challenge was invalid
[ 1/26/25- 7:37:47]  Hostname resolved to: 192.236.999.230

What should I be looking at?

This is NT 14.29

/Poul

14

Web Server - Ask For Help / All themes up to date?

« on: January 17, 2025, 08:25:40 AM »

Hi,

Are all current distributed themes up to date?
NT 14.29

I have no issues, just wanted to know   

tia
/Poul

15

Web Server - Ask For Help / Form field - Lookup using two keys

« on: December 28, 2024, 01:47:33 AM »

Hi,

This is a form where user - a mobile service technician - is entering items used on the job in question.
I need to validate a form field with the SKU number when it is accepted.
But the user can enter either SKU number or EAN number (entered from a barcode scanner) and I therefore need to validate this manually, ie. not using the normal wizarded lookup settings tab.

In the windows application I simply do this in the fields accepted embed, but how do I do this in NT?
The Routine  Validate --> Field does not fire at this point, but when the form is saved.

tiua
/Poul