Paul Withington's Communities Activities

Adding one ESU to multiple type 3 streets.

Paul Withington — Tue, 16 Jun 2015 09:26:43 GMT

I am adding the Nation Cycle Route to my LSG but I’m getting an error “NET-0041:group type is exclusive and at least one element already exists in another group of this type”.

Details;

I have an ESU (03642720426438) that is part of a type one street (Pleasington Lane) and part of a type 3 (C619). This also needs to be part of another type 3 for the cycle route (NCR6).

I have created the type 3 describe as NCR6 but at the point of adding the ESU I get the error “NET-0041:group type is exclusive and at least one element already exists in another group of this type”.

Thanks

Paul

TMA attachments, change stored location

Paul Withington — Thu, 19 Jan 2017 08:20:39 GMT

The TMA attachments directory is an oracle directory (on the database server). Can this be changed to the app sever like other documents stored by document manager.

TMA, human error when inputting on PDA

Paul Withington — Tue, 19 May 2015 09:10:17 GMT

We have two inspectors that have got into bad habits. When doing street works sample inspection pass they have been selecting inapplicable instead of acceptable. This has now been addressed but we have a number of incorrect records.

Is there a clever way of changing the all the “passed” samples with a status type of 4 to 1 and resend the inspection notice?

The below select statement does give the expected results. Could it be a matter of changing the tili_status_type from 4 to 1 and setting the eton status to 1 (ready for sending). I have not tried to turn the below into an update because I believe oracle does not allow updating multiple tables in one query and I would always seek advice before making changes via SQL.

Select tire_eton_status, t2.tili_status_type
From tma_insp_results_all t1
inner join tma_insp_result_lines t2 on tire_inspection_id= tili_inspection_id
WHERE t1.tire_date > '01-JAN-2014' and t1.tire_inspector_name like 'example inspector' and t2.tili_status_type='4' and t1.tire_outcome_type='1'

How to print S81 (1901) defective apparatus notice. TMA 4.5.10.2

Paul Withington — Fri, 11 Apr 2014 08:46:47 GMT

Hoping there is a function I have not seen. We have a S81 that has been sent via Eton 6. The other end has a problem and can’t view the notice. Is there a print function for S81’s?

The Print notice button in TMA1810 is greyed out.

TMA inspection transactions pending send

Paul Withington — Wed, 13 Jan 2016 09:52:47 GMT

Background

We undertake inspections 2 year after the completion of a job on Exor mobile. The inspection loads without error and creates a 2600 notice for the undertaker. If a previous transaction has the status error the inspection remains a pending send. We catch these manually but would like them to go regardless of a previous error. The previous error may be on the notice caused by the undertaker or on an old inspection that has never been transmitted.

We did follow the logic that the old error should be fixed and resent however if the failed transaction is on our inspection it may now be out of date and render the inspection irrelevant. If the error is on the undertakers notice for example a duplicate full registration notice it would not need fixing.

Aim

We would like all inspections loaded or typed to be transmitted to the undertakers regardless of previous errors. Is there currently a way to achieve this?

There is a product option "HOLDPNDNG" (set at Y) for holding further transactions after a fail but this would apply to all transactions not just our inspections.

Thanks

Paul

State to code 5, Street adoption code 5

Paul Withington — Thu, 11 Jun 2015 08:46:00 GMT

I have a designated name for a terrace on an existing type one road. I want to set the street state to code 5 (Street for addressing purposes only) and Street adoption code 5 (type 61 Record – Street outside the scope of EToN). As section 6.7.3 of the Data Entry Conventions - March 2014. I can’t see these options, how do I do this?

In Arc Map TMA_Active_Phases only displays below 1:750

Paul Withington — Wed, 05 Mar 2014 09:45:42 GMT

In Arc Map (9.2) TMA_Active_Phases only displays below 1:750. There are no parameters set in the scale range on the display properties in Arc Map. Is there a pre-set scale range in GIS0020 or GIS0010. I cannot see one and there is no reference in the manual.

We are wanting to sort before the final data pump for our move from 4.3 to 4.5.10

Copy S81 (1901) defective apparatus notice. TMA 4.5.10.2

Paul Withington — Fri, 25 Apr 2014 14:48:55 GMT

In TMA1000 when inputting multiple S81 on the same street we attempted to use the Copy button next to the promoter box. The original one worked. The copied job successfully took all the detail onto a new job with a new Works Ref number. Unfortunately it was given a status of Created without a notice. As such will not allow us to create a notice type of 1901.

Daily printing of enquiries in PEM

Paul Withington — Fri, 22 May 2015 13:22:37 GMT

We would like to use DOC0160 for two departments to print new enquiries on a daily basis and update the status to AI (as per feature 2 in Status Codes - HIG9110). The enquiry class / type filters the records for the teams.

The report does not include the target date. Is there a way to add it?

The report also reprints already printed records. Is there a way to stop this e.g. only printing a specific status off?

Logging multiple similar enquiries

Paul Withington — Mon, 27 Apr 2015 14:42:50 GMT

In the past we have been able to duplicate Enquires using Record > Duplicate but we now get the error “HWAYS-0125: Function not available here”

Has this function been removed?

--------------------------------------------------------

Exor version 4.5 FIX 4

Form DOC0150, Version 4.5.0.0, "$Revision:: 5.3 $"

MAI Inspections for Sections or Street

Paul Withington — Mon, 23 Mar 2015 09:03:29 GMT

I am currently writing the processes for mobile working with the aim to use Bentley’s new MapCapture software. We have been using maintenance manager for 10 years as a text system without using the mapping interface. We no longer use Structures Manager, UKPMS or Schemas Manager.

Our inspectors will be given a zone to inspect containing a list of streets. Ideally I would like a level 3 style structure for the inspectors same as the street works system. The defect may be linked to the actual section but does not need to be seen by the inspector or the insurance reports.

Currently – inspections against sections of a street

The below green street would be split into 6 sections all due for inspection.

Advantages	Disadvantages
Any missed sections would be easily identified.	Issuing one zone of 80 streets would become a zone of 400 section based on 5 sections per street. This becomes a much larger administration task and confusing for all involved.
	When producing S58 defence due to not having a no defects found for the entire street one would be needed for each section.
	Building a program of inspections becomes much more difficult due to the increase in sections.

Aim - Inspections against a level 3 street

Much like the street works side the works are displayed at street level not section (ESU).

Advantages	Disadvantages
Simple view for mobile device
Easy to build discoverer reports for late inspections by street
Simplifies insurance defence paperwork
Existing inspections program can continue to be used.

Best practice for logging multiple enquiries in PEM

Paul Withington — Mon, 09 Feb 2015 10:47:29 GMT

I am posting the below to get the point of view of other users and the point of view of the software provider.

Scenario

Carriageway defect on a principle road gets reported by five people. Two of which state they are going to put a claim in.

Possibilities as I understand them

From the first call an enquiry record is created. Each subsequent record an extra contact is added to the existing enquiry.
1. Positives
  1. Reduces likely hood of two inspectors getting the job to inspect
  2. All contacts are captured as this may be requested should a claim materialise
  3. A choice can be made when reports are designed to show number of enquiries as 1 (one incident) or 5 (five enquiries for the one incident)
2. Negatives
  1. The date and time of each caller would not be logged on the enquiry (although the history would show the time updated)
  2. If different responses are required (based on MP response etc.) tracking this may be difficult.
  3. At a glance it may be missed that there are multiple enquirers
  4. If reports are not set to capture this the first contact may be the only seen
  5. Only one contact can be specified as the primary contact should alerts be in place
The first enquiry is logged and the following four people get told it’s already logged and will be dealt with in due course.
1. Positives
  1. Reduces likely hood of two inspectors getting the job to inspect
2. Negatives
  1. Only the first enquirer is offered a response
  2. Not all contacts are captured as this may be requested should a claim materialise
  3. Reports will only show one enquiry
Each enquiry is logged linking the records via associations
1. Positives
  1. All contacts are captured as this may be requested should a claim materialise
  2. Duplicate record function can be used to reduce logging time
  3. Reports would show five enquiries and one defect as association
  4. All the enquirers can have individual logged response if required IE letter, email etc. and dates inc. target are logged
  5. Links between enquiries shows it’s the same defect
2. Negatives
  1. Extra administration time once inspected each enquiry requires update with defect association and comments(Once associated to a defect the five records will update and complete in line with the defect)
  2. Links between the enquiries don’t give any extra functionality
Other recommendations?

TMA attachments from file name

Paul Withington — Mon, 09 Feb 2015 11:47:45 GMT

I have a number of files that have been uploaded via TMA to send the Statutory undertakers. The undertaker has responded saying they can’t access certain files. After investigating, the files have no size. There must have been an error uploading them.

Is there a way to see from the attachment URL which notice is linked?

I have looked in “Document” (DOC0100) as I would if this was a PEM or Asset attachment. None of the TMA attachments are registered here. I could look at all sent items in Monitor web services but without going into each one I would not know which have attachments.

PEM Tracker for the public

Paul Withington — Fri, 16 Jan 2015 13:21:34 GMT

We currently use Exor PEM (4.5) to manage our public enquiries. This is good tool that interacts with the other modules we use.

Is there any current solution to view the status of an enquiry on external devices? As an example an iPAD tracker app or some form of web reporting much like discoverer but with a more user friendly GUI aimed at the public?

I am Aware there is an API for taking records into Exor PEM but is there a way of getting information back out?

Locator layers displayed by default

Paul Withington — Mon, 02 Feb 2015 09:07:33 GMT

I have a base map for drainage assets for the flood risk team. Base map name “DRAINASS”.

I want to set a number of the available layers as displayed by default. I’m sure this use to be an option in the layers tool but in Exor 4.5 I can’t see it.

I am launching Locator (NM0572) direct from Favourites.