Recent Posts

Pages: 1 ... 8 9 [10]
91
Loadmaster / Editing CSV files prior to import - a warning
« Last post by norman on July 02, 2018, 05:40:58 pm »
As a general rule DO NOT use Excel to manipulate CSV files - Use Notepad.

This is why.

Before a file went into Excel it looked like this :-

"123456789012345","ABC123","32, The Street","Anywhere"

After it was saved by Excel as a CSV file it looked like this :-

1.23457E+14,ABC123,"32, The Street",Anywhere

Long numbers get altered into Scientific notation and it removes formatting. This can cause all sorts of problems.

A worse case scenario would be :-

1.23457E+14,ABC123,32, The Street,Anywhere

This now has five fields when the original had four.

Norman
 ;)



92
Windows / Mapped drive available as Admin but not as a User
« Last post by norman on June 23, 2018, 07:01:14 pm »
This is the effect of the User Account control (UAC) which was added in Windows Vista in 2006. When you map drives at logon, they are mapped with the filtered token (standard rights). When you now run an application elevated (with full admin token) it can't see the mapped drives of the normal permissions.

When network shares are mapped, they are linked to the current logon session for the current process access token. This means that if a user uses the command prompt (cmd.exe) together with the filtered access token to map a network share, the network share is not mapped for processes that run with the full administrator access token.

To allow admin programs to see the normal mapped drives, enable the setting EnableLinkedConnections

Click Start, type Regedit in the Start programs and files box, and then press ENTER.

Locate and then right-click the registry subkey HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System.

Point to New, and then click DWORD Value.

Type EnableLinkedConnections and then press ENTER.

Right-click EnableLinkedConnections and then click Modify.

In the Value data box, type 1, and then click OK.

Restart the computer.

As a general guide, do not map drives under an Administrative account.

Norman
 ;)
93
TPN Invoicing / Error while decoding the response from the Webservice
« Last post by norman on June 22, 2018, 03:44:56 pm »
This simply means that the data coming from TPN cannot be deciphered. It can be due to two reasons -

1. TPN are restricting the download size from the server. Try to download again but choosing consignments only.

2. The data includes invalid characters which should not be present in the data.

It seems that the TPN Web Services currently do not handle multiple lines in Special Instructions nor do they deal with some non standard characters either.

They cause a malformed returned XML wrapper which cannot be decoded properly. So TPN SOAP will return an error as it cannot get a valid reply. It will also be wrong in other programs such as SOAPUI.

You will see something like this :-

Error at line 140 of Local Procedure GetAllRecords process.

Error while decoding the response from the Webservice:

The XML document has not been loaded.

System Error Details:

Row 4, Column 187536: xmlParseCharRef: invalid xmlChar value 2
Row 4, Column 190094: xmlParseCharRef: invalid xmlChar value 2
Row 4, Column 192655: xmlParseCharRef: invalid xmlChar value 2
Row 4, Column 195213: xmlParseCharRef: invalid xmlChar value 2


or another example :-

Error at line 140 of Local Procedure GetAllRecords process.

Error while decoding the response from the Webservice:

The XML document has not been loaded.

System Error Details:

Row 1, Column 324161: xmlParseCharRef: invalid xmlChar value 7
Row 1, Column 324183: xmlParseCharRef: invalid xmlChar value 7


Valid characters are normally from 32 to 126. In the text above we see 2 on the top example and 7 on the bottom.

In TPN Connect simply DO NOT enter text and press the Carriage Return key on the Special Instructions field or use non standard characters in other fields.

TPN are going to correct this but no date is scheduled.

Fixing requires finding the invalid characters and replacing them with valid ones.

The solution is to run SOAPGUI on the TPN Web Services procedure of GetConsignments. The response will be a single line of text rather than the formatted XML reply. Cut and paste this into Notepad and look for the indicated xmlChar which will be embedded in a short string starting with &#x. You will be able to see the consignment number and the field involved. Go to this record in TPN Connect and alter the text to remove the characters. This will resolve the issue.

Norman
 ;)

94
Sameday Express / Cannot choose my mapped drive as a data directory - red cross
« Last post by norman on June 21, 2018, 09:15:03 am »
This is the effect of the User Account control (UAC) which was added in Windows Vista in 2006. When you map drives at logon, they are mapped with the filtered token (standard rights). When you now run an application elevated (with full admin token) it can't see the mapped drives of the normal permissions.

When network shares are mapped, they are linked to the current logon session for the current process access token. This means that if a user uses the command prompt (cmd.exe) together with the filtered access token to map a network share, the network share is not mapped for processes that run with the full administrator access token.

To allow admin programs to see the normal mapped drives, enable the setting EnableLinkedConnections

Click Start, type Regedit in the Start programs and files box, and then press ENTER.

Locate and then right-click the registry subkey HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System.

Point to New, and then click DWORD Value.

Type EnableLinkedConnections and then press ENTER.

Right-click EnableLinkedConnections and then click Modify.

In the Value data box, type 1, and then click OK.

Exit Registry Editor, and then restart the computer.

Norman
 ;)
95
Loadmaster / Cannot choose my mapped drive as a data directory - red cross
« Last post by norman on June 21, 2018, 09:13:21 am »
This is the effect of the User Account control (UAC) which was added in Windows Vista in 2006. When you map drives at logon, they are mapped with the filtered token (standard rights). When you now run an application elevated (with full admin token) it can't see the mapped drives of the normal permissions.

When network shares are mapped, they are linked to the current logon session for the current process access token. This means that if a user uses the command prompt (cmd.exe) together with the filtered access token to map a network share, the network share is not mapped for processes that run with the full administrator access token.

To allow admin programs to see the normal mapped drives, enable the setting EnableLinkedConnections

Click Start, type Regedit in the Start programs and files box, and then press ENTER.

Locate and then right-click the registry subkey HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System.

Point to New, and then click DWORD Value.

Type EnableLinkedConnections and then press ENTER.

Right-click EnableLinkedConnections and then click Modify.

In the Value data box, type 1, and then click OK.

Exit Registry Editor, and then restart the computer.

Norman
 ;)
96
Sameday Express / Sameday Express - my data looks different to that of other users
« Last post by norman on June 20, 2018, 08:53:57 am »
This simply means that you are not looking in the same data directory!

This is usually associated with mapping drives and the mapping is different.

When you do a major update to Sameday Express which involves file structure changes then the system will backup the current data into a directory under the existing data directory.

The chances are that the computer that 'sees' the old data is mapped to a backup and not the data directory.

Make sure you have not set the mapped drive to 'Always available offline' . This will cause chaos.

Norman
 ;)
97
Loadmaster / Loadmaster - my data is looks different to other users
« Last post by norman on June 20, 2018, 08:52:26 am »
This simply means that you are not looking in the same data directory!

This is usually associated with mapping drives and the mapping is different.

When you do a major update to Loadmaster which involves file structure changes then the system will backup the current data into a directory under the existing data directory.

The chances are that the computer that 'sees' the old data is mapped to a backup and not the data directory.

DO NOT SET YOUR MAPPED DRIVE TO 'ALWAYS AVAILABLE OFFLINE'. You will see the old data until the folder syncs up and it will cause chaos!

Norman
 ;)
98
TPN Invoicing / Problems using of Outlook with TPN Invoicing
« Last post by norman on June 20, 2018, 08:37:39 am »
The 32 bit version of Outlook is compatible with TPN Invoicing up to and including 2016. TPN Invoicing uses Simple MAPI to send invoices and this is part of Outlook.

Outlook MUST be set as the default Mail handler in Default Programs. You should check that it is associated with MAPI.

If TPN Invoicing was working properly before you installed a new version of Outlook and you can no longer email invoices then the solution lies within Outlook. You should seek assistance from the original supplier. Recently Microsoft has been making extensive alterations to the Control Panel and Default Programs in Windows 10 and assistance may require expert advice. It seems that there are currently problems with the latest Outlook 2016 using MAPI to send emails which is reported by Sage, Quickbooks and myob. These concern a corrupted Registry entry key for Outlook and require that you run the Modification option in Office to attempt a repair.

You can also try to test TPN Invoicing by running Outlook as an Administrator then going into File and Options. Go into the Trust Centre. Click on the Programmatic Access link on the left. Click on the 'do not warn' option and Save. Now try the emailing again. The emails should appear in Sent Items and shows that the issue is to do with Windows security.

It is suggested that rather than emailing all the invoices you go into Reports/Invoicing/CSV data and put in an invoice number. On a temporary basis you can set the Account Email of the associated account to your own email address so that you can immediately and easily check this.

If the current oddities with Outlook 2016 are not resolved quickly enough by Microsoft then you can install an alternative Email Client, such as Thunderbird, set this up and then set your default Email Client in Default Programs to this. You can use Outlook as normal, but MAPI will run through Thunderbird instead. When this works it simply proves that the original problem lies in Outlook.

Norman
 ;)


99
Miscellaneous / Nokia 2520 - how to get into Diagnostics to repair
« Last post by norman on June 12, 2018, 09:00:31 am »
The Nokia 2520 runs the Windows RT operating system.

If the 2520 won't boot into a normal screen then :-

Turn on. When you see the word Nokia then power off. Do not let it finish the boot.

Repeat three times.

Norman
 ;)
100
Apple / MacBook - sudden power supply issues
« Last post by norman on May 24, 2018, 12:53:31 pm »
This has just occurred. 22nd May 2018.

Running a MacBook Pro with a non-Apple power supply which has been working happily for two years. All of a sudden it no longer works and will not charge or connect.

After a visit to an Apple repairer it seems that the requirement to use only Apple products has somehow been invoked. Replacing the PSU with the official Apple Magsafe 2 resulted in a restored system.

The non-Apple PSU works and will charge every so often, say 1 in 100 connection. But not good enough for our requirements.

Norman
 ;)

 
Pages: 1 ... 8 9 [10]