This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Try the clean() function in excel It removes all non printing characters You can tell if it's done anything by checking the text string length with len ()
Sent from Samsung Mobile on O2
-------- Original message --------
From: "Pat Morrow pmorrow8@yahoo.com [MAXIMO]" <MAXIMO@yahoogroups.com>
Date: 24/09/2015 5:58 pm (GMT+00:00)
To: MAXIMO@yahoogroups.com
Subject: Re: [MAXIMO List] Question mark characters in Work Order Description Generated from PM
Try exporting your location description from the Locations table. If the initial description was done via a data load, there may be another character other than a space between the words. When it is copied over, since the mbo cannot parse the unknown character, it puts in a ?.
Simple answer if this is the issue - do a search and replace for all the unknown characters and replace with a space. Pat Morrow
pmorrow8@yahoo.com
From: "goolia13@yahoo.com [MAXIMO]" <MAXIMO@yahoogroups.com>
To: MAXIMO@yahoogroups.com
Sent: Thursday, September 24, 2015 10:31 AM
Subject: [MAXIMO List] Question mark characters in Work Order Description Generated from PM
I have generated work orders from a PM with a route attached. All the location descriptions are clean---none of them have the question mark characters in them. However, the work order descriptions all have question marks in the spaces of the work order description (which is the Location description) Even on the work orders themselves, the location description in the location description field appears normal. It's just the work order description field.
Example:
WO Description: SS?C01NSW?Beneva?Rd
Location Description: SS C01NSW Beneva Rd
#yiv2252607580 #yiv2252607580 -- #yiv2252607580ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2252607580 #yiv2252607580ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2252607580 #yiv2252607580ygrp-mkp #yiv2252607580hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2252607580 #yiv2252607580ygrp-mkp #yiv2252607580ads {margin-bottom:10px;}#yiv2252607580 #yiv2252607580ygrp-mkp .yiv2252607580ad {padding:0 0;}#yiv2252607580 #yiv2252607580ygrp-mkp .yiv2252607580ad p {margin:0;}#yiv2252607580 #yiv2252607580ygrp-mkp .yiv2252607580ad a {color:#0000ff;text-decoration:none;}#yiv2252607580 #yiv2252607580ygrp-sponsor #yiv2252607580ygrp-lc {font-family:Arial;}#yiv2252607580 #yiv2252607580ygrp-sponsor #yiv2252607580ygrp-lc #yiv2252607580hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2252607580 #yiv2252607580ygrp-sponsor #yiv2252607580ygrp-lc .yiv2252607580ad {margin-bottom:10px;padding:0 0;}#yiv2252607580 #yiv2252607580actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2252607580 #yiv2252607580activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2252607580 #yiv2252607580activity span {font-weight:700;}#yiv2252607580 #yiv2252607580activity span:first-child {text-transform:uppercase;}#yiv2252607580 #yiv2252607580activity span a {color:#5085b6;text-decoration:none;}#yiv2252607580 #yiv2252607580activity span span {color:#ff7900;}#yiv2252607580 #yiv2252607580activity span .yiv2252607580underline {text-decoration:underline;}#yiv2252607580 .yiv2252607580attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2252607580 .yiv2252607580attach div a {text-decoration:none;}#yiv2252607580 .yiv2252607580attach img {border:none;padding-right:5px;}#yiv2252607580 .yiv2252607580attach label {display:block;margin-bottom:5px;}#yiv2252607580 .yiv2252607580attach label a {text-decoration:none;}#yiv2252607580 blockquote {margin:0 0 0 4px;}#yiv2252607580 .yiv2252607580bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2252607580 .yiv2252607580bold a {text-decoration:none;}#yiv2252607580 dd.yiv2252607580last p a {font-family:Verdana;font-weight:700;}#yiv2252607580 dd.yiv2252607580last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2252607580 dd.yiv2252607580last p span.yiv2252607580yshortcuts {margin-right:0;}#yiv2252607580 div.yiv2252607580attach-table div div a {text-decoration:none;}#yiv2252607580 div.yiv2252607580attach-table {width:400px;}#yiv2252607580 div.yiv2252607580file-title a, #yiv2252607580 div.yiv2252607580file-title a:active, #yiv2252607580 div.yiv2252607580file-title a:hover, #yiv2252607580 div.yiv2252607580file-title a:visited {text-decoration:none;}#yiv2252607580 div.yiv2252607580photo-title a, #yiv2252607580 div.yiv2252607580photo-title a:active, #yiv2252607580 div.yiv2252607580photo-title a:hover, #yiv2252607580 div.yiv2252607580photo-title a:visited {text-decoration:none;}#yiv2252607580 div#yiv2252607580ygrp-mlmsg #yiv2252607580ygrp-msg p a span.yiv2252607580yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2252607580 .yiv2252607580green {color:#628c2a;}#yiv2252607580 .yiv2252607580MsoNormal {margin:0 0 0 0;}#yiv2252607580 o {font-size:0;}#yiv2252607580 #yiv2252607580photos div {float:left;width:72px;}#yiv2252607580 #yiv2252607580photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2252607580 #yiv2252607580photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2252607580 #yiv2252607580reco-category {font-size:77%;}#yiv2252607580 #yiv2252607580reco-desc {font-size:77%;}#yiv2252607580 .yiv2252607580replbq {margin:4px;}#yiv2252607580 #yiv2252607580ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2252607580 #yiv2252607580ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2252607580 #yiv2252607580ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2252607580 #yiv2252607580ygrp-mlmsg select, #yiv2252607580 input, #yiv2252607580 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2252607580 #yiv2252607580ygrp-mlmsg pre, #yiv2252607580 code {font:115% monospace;}#yiv2252607580 #yiv2252607580ygrp-mlmsg * {line-height:1.22em;}#yiv2252607580 #yiv2252607580ygrp-mlmsg #yiv2252607580logo {padding-bottom:10px;}#yiv2252607580 #yiv2252607580ygrp-msg p a {font-family:Verdana;}#yiv2252607580 #yiv2252607580ygrp-msg p#yiv2252607580attach-count span {color:#1E66AE;font-weight:700;}#yiv2252607580 #yiv2252607580ygrp-reco #yiv2252607580reco-head {color:#ff7900;font-weight:700;}#yiv2252607580 #yiv2252607580ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2252607580 #yiv2252607580ygrp-sponsor #yiv2252607580ov li a {font-size:130%;text-decoration:none;}#yiv2252607580 #yiv2252607580ygrp-sponsor #yiv2252607580ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2252607580 #yiv2252607580ygrp-sponsor #yiv2252607580ov ul {margin:0;padding:0 0 0 8px;}#yiv2252607580 #yiv2252607580ygrp-text {font-family:Georgia;}#yiv2252607580 #yiv2252607580ygrp-text p {margin:0 0 1em 0;}#yiv2252607580 #yiv2252607580ygrp-text tt {font-size:120%;}#yiv2252607580 #yiv2252607580ygrp-vital ul li:last-child {border-right:none !important;}#yiv2252607580
Thank you both! I suspected my MIF, but was confused because the Location descriptions appear fine, yet the WO descriptions do not. Much appreciated!
Thank you both! I suspected it had something to do with the MIF---but I didn't understand why the location description appeared to be fine, yet the WO description did not. Much appreciated!