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.


Topics - MyBrainIsFull

Pages: [1] 2 3
1
Web Server - Ask For Help / DDesktop Question
« on: April 19, 2016, 12:01:28 PM »
Disconnected Desktop question
With Net Talk 9-07  
Using Capesoft examples of Server & Desktop

I delete a table from the DCT   - LinkCountriesShippers
When I compile the desktop it throws an error that the SYNCSERVER proc cant find that table to sync
thats reasonable

But does anyone know WHERE to set the tables that the syncServer will sync?
I thought it was under the extensions in the older version of NT9

2
Web Server - Ask For Help / Disconnected Desktop - reminder for Bruce
« on: March 29, 2016, 07:59:49 PM »
Re NTUG-93  Alejandro had an issue with the disconnected desktop
I have compiled the Capesoft example with 9.06 and it still has the bug, if you delete the servers data and do a sync it is not inserting  or updating

The bug

in PrimeParameters  routine    using JSON  the SyncCloud_Action  is set to 'insert'   but the lines below
   If json.GetPropertyValue('SyncCloud_Action',1) <> ''
      SyncCloud_Action = json.GetPropertyValue('SyncCloud_Action',1)     !!! sets it back to 'sync'
--------------

then AutoService:SyncCloud  is called where  sync is not part of the case statement. ie no insert




3
Web Server - Ask For Help / Disconnected Web issue
« on: February 27, 2016, 10:08:25 PM »
With two desktop browsers and a mobile phone connected to the lan via wifi

I start a desktop Firefox session and browse shippers, but none of the records from the suppliers.tps come over, like FedEx  ups etc
I enter one shipper in Firefox (upper half image 1)
I enter one shipper in Chrome (lower half image 1)
I cant get the browser to sync
Nothing I do with the browser will hit the NT server.

If I force the url to 127.0.0.1 I can see the server take the request, but still no sync.
I then ask for suppliers or customers, nothing.

using a phone that has NO cache, i hit the server on 192 168 0 101-88 and it gets no records (img 2)

Is there some bug / setting in the examples that prevents the sync happening? 
Is there any way to force it to sync?

Image 3 shows suppliers.tps

4
Web Server - Ask For Help / Disconnected Desktop issues
« on: February 27, 2016, 09:41:28 PM »
Using the Capesoft example, with a server running
and two desktops running (D1 & D2) in separate folders - ie they hold individual data when disconnected.

Issue 1
if you hit insert on D1 the form opens, lets say it shows Invoice=1 ,  your user looks at the form for a while (makes coffee for 1 min - sync occurs)  and decides not to do this and hits cancel.
Look at D2 (refresh invoices) it now has an empty record with Invoice=1
Is there a way to stop this happening ?

Issue 2
In the example - the update invoice form has no range limit (by table) set, but even when you fix this

The Invoice has a child browse of Line Items
If you enter any, these items dont get updated.  

Is this a "to-do"   - or is the sync of children the programers responsibility, and if so, is it correct procedure to call the Sync LineItems ?

Using NT 906 / J Files 119 / String 243 / X 277

5
Web Server - Ask For Help / PHP MS Sql connection error
« on: February 24, 2016, 08:15:11 PM »
Hi all
I have 3 pcs on my network
A - MS Sql server
B - a MS Server 2008 SP2 with IIS & PHP installed
C - a MS Server 2008 with no iis - but has NTalk server

both B & C have a desktop app that can read the Ms Sql data on "A", so firewall is OK

I can get B & C to do simple php things, so php works,  and  with phpinfo.php  I can see a section for "SQLSRV"   so I believe the MS driver is installed on both as php_sqlsrv_54_nts.dll  in the ext folder,  and extension set in php.ini for this path.

But I cant access the MsSql data from either B or C  using simple connection strings I have Googled to test the connection,  I get a an error "Connection could not be established"

Has anyone been able to connect to MS Sql ?   Any hints would be appreciated.
Thanks

                             PLEASE NOTE
THERE IS BEER AVAILABLE TO WHOEVER SOLVES THIS


-------[ Using SqlSrv_connect()  shows echo 2 then throws error...
-------[ Using MsSql_connect()  DOES NOT show echo 2 - it just plain dies

<?php
$serverName = "192.168.0.121,1433";        
//$serverName = "s2003";         //serverName\instanceName

$connectionInfo = array( "Database"=>"BCDS_WMS", "UID"=>"sa", "PWD"=>"password");

 // $conn = mssql_connect( $serverName, $connectionInfo);
$conn = sqlsrv_connect( $serverName, $connectionInfo);

echo " <br> 2..";

if( $conn ) {
     echo "Connection established.<br />";
}else{
     echo "Connection could not be established.<br />";
     die( print_r( sqlsrv_errors(), true));
}
?>

==================[ UPDATE ]=========
Following the Googles I read it might need odbc installed, so I did and using odbc_connect( )   - this works OK  - but still cant connect with sqlsrv_connect( )    which I need to use (to use customers php code)

<?php
$virtual_dsn = 'DRIVER={SQL Server};SERVER=s2003;DATABASE=BCDS_Wms';
$connection = odbc_connect($virtual_dsn,'sa','password') or die('ODBC Error:: '.odbc_error().' :: '.odbc_errormsg().' :: '.$virtual_dsn);

if ($connection){     echo "Good <p>" }

# query the users table for name and surname
$query = "SELECT id,barcode FROM Asset";

# perform the query
$result = odbc_exec($connection, $query);

# fetch the data from the database
while(odbc_fetch_row($result) ){
  $id    = odbc_result($result, 1);
  $bcd = odbc_result($result, 2);

  print("id=$id   barcode $bcd<br>"); $x+=1;
}
# close the connection
odbc_close($connection);
?>

6
Web Server - Ask For Help / not able to force into mobile mode
« on: February 01, 2016, 09:09:26 PM »
Hi anyone seen a phone not being forced into mobile mode?
NT 8-65

IMAGE 1
This is a Samsung S4 being mirrored onto a pc
The menu is tiny
the ?_mobile_=1 does not force a large menu to appear.
phone stays in desktop mode

Testing   p_web.IsMobile()  returns a zero   not a one


Images 2&3
On an old app I made, the exe is making the correct menu, but the login screen after this is blank
This is the bug my customer is experiencing, blank screens on mobile

Duplicated the error on an iPhone

UPDATE
Image 4 shows another app that DOES show the mobile menu, and IsMobile = 1
Its screen is the same as my customers bug - that is - the login screen is missing  - here the image shows the phone on top half of image with a login button but no entry fields
the desktop is shown below,  as expected

7
Web Server - Ask For Help / NT9 Apps - DCT cannot convert data
« on: January 27, 2016, 09:41:07 PM »
Anyone else seeing this ?  Img attached.

Simple Dct using the NT9 Apps required columns and keys
I changed the category name from 30chrs to 50 chrs while there are 7 records in the TPS file
when I go to convert the data structure with out backup, I get a cannot build file error 40 and it clears the tps file.

This happens on both my tables.  Its due to the GUID key

Any work around anyone ?



8
Web Server - Ask For Help / NT9 Apps - sending data
« on: January 27, 2016, 06:08:11 PM »
Hi Bruce, I am looking at NT9 Apps
you said the device (phone) can only have a small amount of data, so give Bruce North, and give Kevin South

so i make a sub set of data from my server's database in say an imdb "Bruce"
How do I get it to the device?
Can I make a Sql Lite db and send that to the device?
Do you have provision for this?

the sql db on the phone must have a login, even when disconnected
Is the sql db on the phone password protected?  ie, I have a sql viewer on my phone, I can now see all the passwords.

As well as a sync of my database, can I also send the device an updated html page and maybe a new jpg?

9
Web Server - Ask For Help / Build error Apps 902
« on: January 27, 2016, 06:55:59 AM »
Hi, anyone seen this ?  IMG below  NT Apps 9-02
This is the Capesoft example Basic Mobile

Using mBuild it chugs away for a while pulling resources from the server but generates an error on PIE.htc,  which is a url in nettalk-ui.css

It looks like poor little mBuild thinks this is a real url maybe ?  causes a 404 on it.

This stops the zip from being uploaded to phone build, but manually uploading it the zip makes a valid apk which runs.


10
Web Server - Ask For Help / Redactor Bug
« on: November 17, 2015, 03:00:24 AM »
Using NT 8-65
until proven otherwise, I think this is a bug

Using redactor I wanted to add a hyperlink, pressing the link button throws up the appropriate screen (below)

But I could not type in either of the entry fields,   in fact Bruce, the first time it opened and I pasted the URL into the top entry box, but it put the URL in the main body - that is the main text body under the popup entry form.



[attachment deleted by admin]

11
Web Server - Ask For Help / Another CURL problem - Paypal
« on: October 13, 2015, 09:15:35 PM »
Hi Bruce, as per Richards question on show 71, I have a similar problem, unable to send data to Pay Pal.  Using Build 8-62

*** UPDATE *** 8.42 works as in it makes an Authorization component in the heading,  Although Paypal still rejects it.- testing other versions now.  852 works too

Their doco is very good and they offer an example in CURL which works OK.
Using the Net Talk Demo (8.62) - Web Client  I tried to do the same, but get a very stubborn error that wont go away.
As per show 71 I set up the server on 127.0.0.1 and pointed CURL to it,  this gave me the desired result.

However, when I point a Net Talk WebClient at it, some fields are missing.  See long image below.  
Looks like the  Authorization does not appear in the output ?

1.    shows the Clients setup, Note the Authentication tab  (which does not generate anything in the output)  holds my paypal login and password.
2.    shows the log for the POST, it is missing the content length and the Authorization
3.    shows the server side
4.    shows the Net Talk Server when CURL sends the request.



[attachment deleted by admin]

12
Web Server - Ask For Help / My Parent has two heads
« on: September 23, 2015, 07:52:33 PM »
Hi Bruce, dont bother answering this till October,  I just want to understand what is happening here

I have a page that holds a parent (ORDER) and child (OrderLINE) browse, works great.  See Image ONE  and as its part of the checkout I named it ViewTrolley instead of BrowseOrder

Then I added EIP so the shopper can change the qty in a shopping cart, and the child updates the parents total.
But clicking the spinner for Qty does not do anything, so I trapped the event   'rowclicked'  in  "TakeEvent Routine"  and called my own total routine

In there I calc the line items $Extended = Qty * UnitPrice    update the variables as p_webSSV( etc )  

To get the parent to show the updated total I pushed an event "child updated" to tell the parent to update itself
          p_web.PushEvent('childupdated')
          do AlertParent   ! propogate event up
          p_web.PopEvent()  

BUT the child browse then generates a third list box above itself - no code involved - see image two -
I am guessing the three lines above triggers the child to "guess" its parent to be BrowseOrder and put that in for me.

ie the top list box is ViewTrolley with a single child of BrowseOrderLines as the bottom box, which magically generates BrowseOrder as the second box.


[attachment deleted by admin]

13
Web Server - Ask For Help / help with spanning columns In a browse
« on: September 16, 2015, 04:23:57 PM »
Hi all, I must be missing something obvious, maybe someone an point it out to me ?

In a browse I have a long text string
I am trying to span it over a couple of columns to make the column wider  see img 1

Maybe my first step is the error, I added a dummy column to the right of my text and set the the text header and column to span 2 columns  Img 2
Error 1 - The header of the table drops its blue background and shows white
Error 2 - the data does not span into the second column
My settings are in img 3 & 4 for the header and data

Thanks
K

[attachment deleted by admin]

14
Web Server - Share Knowledge / Hint - How to float text over an image
« on: September 15, 2015, 09:07:51 PM »
Hi, hope this helps someone.
I have students course, when they pass I want to show them a pretty page "well done"

Its easy to make graphic nowerdays, I made a HUGE one and wanted to position the text for students name / course name etc  EXACTLY in the right position  AND control the font.

See Image 1 & 2  you will notice this image is 800 x 640

By making a html page I can call this up from server side code as
p_web.script(  p_web.WindowOpen( 'webpages/endofcoursepass.htm' ) )  from my WebPages folder.

The htm is included here, basically you load your image - here its CpePass.gif
Then when you want text you can position a <div> to be in absolute postion - that is absolute to the page !   And you can have plain text like "Mary had a little lamb" or ANY variable from your server,  or a list box etc.

In the section bellow I have the students name <!-- Net:s:LoggedInAs --> in nice bold letters, then I drop the font size for line two the course name and drop it again for the date.  And for all those wondering about 16/9/2015  this is how the civilised world does it. <grin>

Image one is the GIF by itself,   two shows the page without the GIF so you can see the text the server is drawing from its session variables and three is the page as the student sees it.
___________________________________________________________
ENDOFCOURSEPASS.HTM

<!-- NetWebServer -->
<Html>
<Head><!-- Net:c:Head -->     <Title>MyCpe Pass</Title></Head>
<Body BGcolor="#ffffff">

    <Img Src="CpePass.gif" UseMap="#map1" Border="0">

<DIV STYLE="position:absolute; top:120px; left:50px; width:500px; height:55px; font-family: Verdana;">
<CENTER><FONT SIZE="+4" COLOR="0000"><!-- Net:s:loggedinas --></FONT></CENTER>
</DIV>

<DIV STYLE="position:absolute; top:250px; left:70px; width:500px; height:45px; font-family: Verdana;">
<CENTER><FONT SIZE="+3" COLOR="0000"><!-- Net:s:Cou:Name --></FONT></CENTER>
</DIV>

<DIV STYLE="position:absolute; top:300px; left:90px; width:500px; height:45px; font-family: Verdana;">
<CENTER><FONT SIZE="+2" COLOR="0000">on &nbsp; &nbsp; &nbsp;<!-- Net:d:today --></FONT></CENTER>
</DIV>
<!--Net:c:BodyEnd -->
</Body>
</Html>
_______________________________________________________________
For anyone interested the graphics is from an old (1998) version of Image Styler
Took 12 mins to do a pass and fail page,  anyone wants the .ist  pleas email me.

____________________________________ Added
this is the same concept where a table is positioned in absolute terms
Image four,  has a browse box positioned nicely around the graphics and a html button with js rollover to take the user back to the site. 
Using <a Href="http://<!-- Net:s:RequestHost -->/indexPage"   but could go anywhere.



[attachment deleted by admin]

15
Web Server - Share Knowledge / Hint - making a Browse column wider
« on: September 01, 2015, 06:01:58 PM »
Hint for newbies
In a browse you will see the WIDTH of the column is limited by the words in the header
You might set a display of 30 characters but they all bunch up - see Img (1)
so you add a bunch of white space at the end of the "Name"  and maybe add a full stop to force the Name to be 20 chrs long  like this  -> "Name      ."

But it dont work, multiple spaces are reduced to one space by html

The setting Img (2)  of String 30 chrs only sets how much data is set in the column display

One easy answer to this is to force the column header to be wider by adding spaces that html cannot reduce, these are the 'non breaking space' characters  &nbsp;  which you can add to the end of any string to force spaces to be written by html.

Go to you Header tab for the cell  Img (3)   and click to allow xHTML
Then change your Header name from "Name"  to
"Name &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"

The result is shown in Img (4)
Hope this helps someone
K

PS - i just needed to tidy up a form so that multiple fields on a line line up. see image two
where same technique is used to position the entry field by adjusting the prompt size

[attachment deleted by admin]

Pages: [1] 2 3