0.00.0100011NY5000Yadmin2007/04/09 10:47:14.000openvpmslocalhostMYSQLNativeopenvpms-setup3306openvpmsEncrypted 2be98afc86aa7f2e4a409ab7ec882a2c9IS_CLUSTEREDNMAXIMUM_POOL_SIZE10PORT_NUMBER3306STREAM_RESULTSYUSE_POOLINGNText file inputSelect FieldsYFilter rowsDummy (do nothing)YSelect FieldsFilter rowsYFilter rowsTransform Group NameYTransform Group NameSort rowsYSort rowsUnique rowsYUnique rowsProduct Group OutputYDummy (do nothing)DummyY1none322316YFilter rowsFilterRowsY1noneTransform Group NameDummy (do nothing)NNGROUP<>constantString""-1-1NNANDGROUPIS NOT NULL325153YProduct Group OutputOpenVPMSLoaderPluginY1noneopenvpmsGROUP<lookup.productGroup>nametruefalse<lookup.productGroup>codetruefalsefalsetrue1000827154YSelect FieldsSelectValuesY1noneGROUP5-2201148YSort rowsSortRowsY1none${java.io.tmpdir}sort10000NGROUPY547154YText file inputTextFileInputY1noneN,"NY11N1N800YNNNDOS${NETVET_DATA}\items.txtCSVNoneITEMIDString-1-1-1noneNCODEString-1-1-1noneNNAMEString-1-1-1noneNPRINTEDNAMEString-1-1-1noneNTYPEString-1-1-1noneNPCKDESString-1-1-1noneNPCKUNTString-1-1-1noneNUNTTYPString-1-1-1noneNDISVERBString-1-1-1noneNPCKCSTString-1-1-1noneNUNTCSTString-1-1-1noneNAVGCSTString-1-1-1noneNMARKUPString-1-1-1noneNDISFEEString-1-1-1noneNPRICE1String-1-1-1noneNPRICE2String-1-1-1noneNPRICE3String-1-1-1noneNPRICE4String-1-1-1noneNPRICE5String-1-1-1noneNPRICE6String-1-1-1noneNMINQTYString-1-1-1noneNMAXQTYString-1-1-1noneNCURQTYString-1-1-1noneNORDQTYString-1-1-1noneNSTTQTYString-1-1-1noneNDRGSTGString-1-1-1noneNGROUPString-1-1-1noneN0YYwarningerrorlineYen_au103151YTransform Group NameScriptValueModY1none0Script 1//Script here
var wordUtils = Packages.org.apache.commons.lang.WordUtils;
var NAME = GROUP.getString()
GROUP.setString(replace(upper(GROUP.getString()),"[^A-Z0-9]+",'_'))
NAMENAMEString-1-1431154YUnique rowsUniqueY1noneNGROUPY663155Y