Computer program method and apparatus to recognize and normalize data pattern based information

TECHNICAL FIELD

[0001] This application claims the benefit of U.S. Provisional Application No. 60/378,414, filed on May 6, 2002, entitled “An Automated System for Recognizing and Normalizing Pattern Based Information”, whose disclosure is incorporated herein by reference.

[0002] The present invention relates to a method, system and article of manufacture for a computer program to recognize and normalize repeatable data pattern from a file, and more particularly wherein said method and apparatus can recognize and normalize the repeatable data patter automatically, with provision for increasing the accuracy of such recognition as usage increases.

[0003] This application incorporates by reference the files on a computer program listing appendix which is on a Compact Disc Recordable (CD-R) media, (of which two identical copies are submitted) each for operating under IBM-PC machine format and MS-Windows operating system. The files are for execution by any machine supporting a Java Virtual Machine (JVM) and are thus platform independent. The list of files contained on the CD-R media, including the names, sizes in bytes and dates of creation is as follows:

1DATESIZEFILE NAMESDirectory of com\agile\sandbox\pi05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:22a<DIR>admin05/06/2002 10:23a<DIR>database05/06/2002 10:23a<DIR>fma05/06/2002 10:23a<DIR>logger05/06/2002 10:23a<DIR>notification05/06/2002 10:23a<DIR>pm05/06/2002 10:23a<DIR>qa0 File(s)0 bytesDirectory of com\agile\sandbox\pi\admin05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:21a<DIR>cm05/06/2002 10:22a<DIR>eventhandlers05/06/2002 10:22a<DIR>events05/06/2002 10:22a<DIR>gui05/06/2002 10:22a<DIR>model05/06/2002 10:22a<DIR>reports05/06/2002 10:22a<DIR>tests05/06/2002 10:22a<DIR>util05/06/2002 10:22a<DIR>view0 File(s)0 bytesDirectory of com\agile\sandbox\pi\admin\cm05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a<DIR>eventhandlers05/06/2002 10:21a<DIR>events05/06/2002 10:21a<DIR>model05/06/2002 10:21a<DIR>translator05/06/2002 10:21a<DIR>util05/06/2002 10:21a<DIR>view0 File(s)0 bytesDirectory of com\agile\sandbox\pi\admin\cm\eventhandlers05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a5,232AgileExportEH.java05/06/2002 10:21a2,389AgileFieldsMapEH.java05/06/2002 10:21a1,709AgileImportEH.java05/06/2002 10:21a5,124AgileValidateProcessEH.java05/06/2002 10:21a3,108BomAmlDataEditAIIEH.java05/06/2002 10:21a3,788BomAmlDataEditEH.java05/06/2002 10:21a2,564CMParameterEH.java05/06/2002 10:21a3,065CmProfileEH.java05/06/2002 10:21a2,637CMProfileSearchEH.java05/06/2002 10:21a7,682CollectCMBomEH.java05/06/2002 10:21a3,098DataSourceEH.java05/06/2002 10:21a3,530EditCMModuleMapEH.java05/06/2002 10:21a3,365EditCMParameterEH.java05/06/2002 10:21a3,897EditPartyAliasEH.java05/06/2002 10:21a4,220MatchingProfileEH.java05/06/2002 10:21a2,314MPNMatchEditEH.java05/06/2002 10:21a3,959MPNMatchEH.java05/06/2002 10:21a3,529MPNMatchResultEH.java05/06/2002 10:21a1,574PartMatchingEH.java05/06/2002 10:21a3,832PartyAliasEH.java05/06/2002 10:21a3,351TranslateEH.java21 File(s)73,967 bytesDirectory of com\agile\sandbox\pi\admin\cm\events05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a1,282AgileExportEvent.java05/06/2002 10:21a2,165AgileFieldsMapEvent.java05/06/2002 10:21a3,336AgileImportEvent.java05/06/2002 10:21a7,746AgileValidateProcessEvent.java05/06/2002 10:21a6,750BomAmlDataEditAllEvent.java05/06/2002 10:21a10,707BomAmlDataEditEvent.java05/06/2002 10:21a3,029CMParameterEvent.java05/06/2002 10:21a6,254CmProfileEvent.java05/06/2002 10:21a2,607CMProfileSearchEvent.java05/06/2002 10:21a14,984CollectCMBomEvent.java05/06/2002 10:21a8,646DataSourceEvent.java05/06/2002 10:21a2,252EditCMModuleMapEvent.java05/06/2002 10:21a2,250EditCMParameterEvent.java05/06/2002 10:21a4,808EditPartyAliasEvent.java05/06/2002 10:21a3,774MatchingProfileEvent.java05/06/2002 10:21a6,769MPNMatchEditEvent.java05/06/2002 10:21a19,079MPNMatchEvent.java05/06/2002 10:21a11,058MPNMatchResultEvent.java05/06/2002 10:21a2,765PartMatchingEvent.java05/06/2002 10:21a4,529PartyAliasEvent.java05/06/2002 10:21a7,358TranslateEvent.java21 File(s)132,148 bytesDirectory of com\agile\sandbox\pi\admin\cm\model05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a1,988AgileExportInfo.java05/06/2002 10:21a1,753AgileExportResults.java05/06/2002 10:21a19,898AgileFieldsMapModel.java05/06/2002 10:21a6,497AgileImportModel.java05/06/2002 10:21a15,896AgileValidateProcessModel.java05/06/2002 10:21a7,790BomAmlDataEditAllModel.java05/06/2002 10:21a41,282BomAmlDataEditModel.java05/06/2002 10:21a13,466CMParameterModel.java05/06/2002 10:21a28,100CmProfileModel.java05/06/2002 10:21a15,794CMProfileSearchModel.java05/06/2002 10:21a27,510DataSourceModel.java05/06/2002 10:21a14,349EditCMModuleMapModel.java05/06/2002 10:21a10,641EditCMParameterModel.java05/06/2002 10:21a12,294EditPartyAliasModel.java05/06/2002 10:21a6,219MatchingProfileModel.java05/06/2002 10:21a10,708MPNMatchEditModel.java05/06/2002 10:21a27,856MPNMatchModel.java05/06/2002 10:21a45,900MPNMatchResultModel.java05/06/2002 10:21a6,379ParseProcess.java05/06/2002 10:21a41,646ParseValidateProcess.java05/06/2002 10:21a5,110PartMatchingModel.java05/06/2002 10:21a19,970PartyAliasModel.java05/06/2002 10:21a13,092TranslateModel.java23 File(s)394,138 bytesDirectory of com\agile\sandbox\pi\admin\cm\translator05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a9,343Translator.java1 File(s)9,343 bytesDirectory of com\agile\sandbox\pi\admin\cm\util05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a21,571BomRecord.java05/06/2002 10:21a51,569CMUtil.java05/06/2002 10:21a1,517TranslatePmObjectCopier.java05/06/2002 10:21a3,637UtilHSSFBuilder.java05/06/2002 10:21a159,182ValidatedBom.java5 File(s)237,476 bytesDirectory of com\agile\sandbox\pi\admin\cm\view05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a<DIR>web0 File(s)0 bytesDirectory of com\agile\sandbox\pi\admin\cm\view\web05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a<DIR>handler0 File(s)0 bytesDirectory of com\agile\sandbox\pi\admin\cm\view\web\handler05/06/2002 10:21a<DIR>.05/06/2002 10:21a<DIR>..05/06/2002 10:21a4,283CMRequestHandler.java1 File(s)4,283 bytesDirectory of com\agile\sandbox\pi\admin\eventhandlers05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:21a5,353AssignRelationshipEH.java05/06/2002 10:21a2,370BICReportEH.java05/06/2002 10:21a3,774CreateDashboardEH.java05/06/2002 10:21a2,662CreateFilterEH.java05/06/2002 10:21a3,298CreateMappingLookupEH.java05/06/2002 10:21a2,787CreateNodeCommandEH.java05/06/2002 10:21a2,526CreateNodeViewEH.java05/06/2002 10:21a2,739CreatePermissionEH.java05/06/2002 10:21a2,624CreateRoleEH.java05/06/2002 10:21a3,623CreateServicesSubscriptionEH.java05/06/2002 10:22a2,501CreateSupplierAliasEH.java05/06/2002 10:21a3,071CreateTailoredViewEH.java05/06/2002 10:21a7,421CreateTemplateEH.java05/06/2002 10:21a2,601DashboardSearchEH.java05/06/2002 10:21a3,940EditParserProfileEH.java05/06/2002 10:21a2,671EditTailoredViewEH.java05/06/2002 10:21a2,897ExceptionClassProfileEH.java05/06/2002 10:21a2,490FileTypeConversionEH.java05/06/2002 10:21a2,886FilterSearchEH.java05/06/2002 10:21a3,029MaintainParserProfileEH.java05/06/2002 10:21a2,825MapPermissionsEH.java05/06/2002 10:21a3,033MappingLookupSearchEH.java05/06/2002 10:21a2,354MapRolesEH.java05/06/2002 10:21a3,440MergeTestEH.java05/06/2002 10:21a2,978NodeCommandSearchEH.java05/06/2002 10:21a2,979NodeViewSearchEH.java05/06/2002 10:21a4,189OrganizationEH.java05/06/2002 10:21a3,708OrganizationSearchEH.java05/06/2002 10:21a3,509ParseBomAmlEH.java05/06/2002 10:21a8,847ParserProfileEH.java05/06/2002 10:21a3,287ParserProfileSearchEH.java05/06/2002 10:21a2,571ParserRecognitionTestEH.java05/06/2002 10:21a3,417ParseTestEH.java05/06/2002 10:21a2,749PartyRelationshipEH.java05/06/2002 10:22a3,185PartyRelationshipSearchEH.java05/06/2002 10:22a2,622PermissionSearchEH.java05/06/2002 10:22a3,745RecordMaintenanceEH.java05/06/2002 10:22a2,918RegularExpressionTestEH.java05/06/2002 10:22a2,393RemoveTestEH.java05/06/2002 10:22a2,505RoleSearchEH.java05/06/2002 10:22a2,704SearchTailoredViewEH.java05/06/2002 10:22a2,581SearchUserTypeEH.java05/06/2002 10:22a2,832ServicesSubscriptionSearchEH.java05/06/2002 10:22a2,494SupplierAliasMergeEH.java05/06/2002 10:22a2,949SupplierAliasSearchEH.java05/06/2002 10:22a3,288TemplateControlEH.java05/06/2002 10:22a2,697TemplateOptionEH.java05/06/2002 10:22a3,252TemplateSearchEH.java05/06/2002 10:22a2,003UserEH.java05/06/2002 10:22a2,957UserSearchEH.java05/06/2002 10:22a2,707UserTypeEH.java05/06/2002 10:22a2,278ViewSampleBomFileEH.java52 File(s)165,259 bytesDirectory of com\agile\sandbox\pi\admin\events05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a3,253AssignRelationshipEvent.java05/06/2002 10:22a2,626BICReportEvent.java05/06/2002 10:22a7,671CreateDashboardEvent.java05/06/2002 10:22a3,141CreateFilterEvent.java05/06/2002 10:22a7,433CreateMappingLookupEvent.java05/06/2002 10:22a5,053CreateNodeCommandEvent.java05/06/2002 10:22a3,965CreateNodeViewEvent.java05/06/2002 10:22a5,058CreatePermissionEvent.java05/06/2002 10:22a4,687CreateRoleEvent.java05/06/2002 10:22a5,496CreateServicesSubscriptionEvent.java05/06/2002 10:22a1,752CreateSupplierAliasEvent.java05/06/2002 10:22a4,798CreateTailoredViewEvent.java05/06/2002 10:22a11,043CreateTemplateEvent.java05/06/2002 10:22a2,188DashboardSearchEvent.java05/06/2002 10:22a2,571EditParserProfileEvent.java05/06/2002 10:22a3,313EditTailoredViewEvent.java05/06/2002 10:22a2,721ExceptionClassProfileEvent.java05/06/2002 10:22a6,131FileTypeConversionEvent.java05/06/2002 10:22a2,384FilterSearchEvent.java05/06/2002 10:22a5,457MaintainParserProfileEvent.java05/06/2002 10:22a2,628MapPermissionsEvent.java05/06/2002 10:22a2,489MappingLookupSearchEvent.java05/06/2002 10:22a3,370MapRolesEvent.java05/06/2002 10:22a5,504MergeTestEvent.java05/06/2002 10:22a2,392NodeCommandSearchEvent.java05/06/2002 10:22a2,414NodeViewSearchEvent.java05/06/2002 10:22a14,115OrganizationEvent.java05/06/2002 10:22a8,590OrganizationSearchEvent.java05/06/2002 10:22a14,814ParseBomAmlEvent.java05/06/2002 10:22a28,419ParserProfileEvent.java05/06/2002 10:22a2,901ParserProfileSearchEvent.java05/06/2002 10:22a3,802ParserRecognitionTestEvent.java05/06/2002 10:22a12,682ParseTestEvent.java05/06/2002 10:22a3,888PartyRelationshipEvent.java05/06/2002 10:22a3,556PartyRelationshipSearchEvent.java05/06/2002 10:22a2,203PermissionSearchEvent.java05/06/2002 10:22a3,979RecordMaintenanceEvent.java05/06/2002 10:22a3,957RegularExpressionTestEvent.java05/06/2002 10:22a2,789RemoveTestEvent.java05/06/2002 10:22a2,114RoleSearchEvent.java05/06/2002 10:22a2,522SearchTailoredViewEvent.java05/06/2002 10:22a2,232SearchUserTypeEvent.java05/06/2002 10:22a2,289ServicesSubscriptionSearchEvent.java05/06/2002 10:22a1,858SupplierAliasMergeEvent.java05/06/2002 10:22a2,008SupplierAliasSearchEvent.java05/06/2002 10:22a4,824TemplateControlEvent.java05/06/2002 10:22a2,814TemplateOptionEvent.java05/06/2002 10:22a2,780TemplateSearchEvent.java05/06/2002 10:22a18,398UserEvent.java05/06/2002 10:22a5,236UserSearchEvent.java05/06/2002 10:22a3,060UserTypeEvent.jaya05/06/2002 10:22a2,934ViewSampleBomFileEvent.java52 File(s)268,302 bytesDirectory of com\agile\sandbox\pi\admin\gui05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a2,032ParserConfiguration.java1 File(s)2,032 bytesDirectory of com\agile\sandbox\pi\admin\model05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a55,145AccessUnifyAdminDetails.java05/06/2002 10:22a25,793AssignRelationshipModel.java05/06/2002 10:22a7,974BICReportModel.java05/06/2002 10:22a45,694CreateDashboardModel.java05/06/2002 10:22a9,374CreateFilterModel.java05/06/2002 10:22a14,787CreateMappingLookupModel.java05/06/2002 10:22a19,508CreateNodeCommandModel.java05/06/2002 10:22a25,092CreateNodeViewModel.java05/06/2002 10:22a15,064CreatePermissionModel.java05/06/2002 10:22a16,985CreateRoleModel.java05/06/2002 10:22a57,977CreateServicesSubscriptionModel.java05/06/2002 10:22a6,939CreateSupplierAliasModel.java05/06/2002 10:22a26,383CreateTailoredViewModel.java05/06/2002 10:22a66,840CreateTemplateModel.java05/06/2002 10:22a10,345DashboardSearchModel.java05/06/2002 10:22a30,745EditParserProfileModel.java05/06/2002 10:22a22,820EditTailoredViewModel.java05/06/2002 10:22a14,132ExceptionClassesModel.java05/06/2002 10:22a17,870ExceptionClassProfileModel.java05/06/2002 10:22a11,991FileTypeConversionModel.java05/06/2002 10:22a12,019FilterSearchModel.java05/06/2002 10:22a2,795LoadTemplate.java05/06/2002 10:22a11,190MaintainParserProfileModel.java05/06/2002 10:22a21,983MapPermissionsModel.java05/06/2002 10:22a12,527MappingLookupSearchModel.java05/06/2002 10:22a33,696MapRolesModel.java05/06/2002 10:22a13,350MergeTestModel.java05/06/2002 10:22a22,470NodeCommandSearchModel.java05/06/2002 10:22a17,861NodeViewSearchModel.java05/06/2002 10:22a35,568OrganizationModel.java05/06/2002 10:22a34,229OrganizationSearchModel.java05/06/2002 10:22a25,135ParseBomAmlModel.java05/06/2002 10:22a10,835ParserLinePatternsModel.java05/06/2002 10:22a14,367ParserNameClassModel.java05/06/2002 10:22a8,378ParserProfileCustomModel.java05/06/2002 10:22a15,064ParserProfileDetailsModel.java05/06/2002 10:22a27,604ParserProfileExport.java05/06/2002 10:22a29,918ParserProfileImport.java05/06/2002 10:22a35,248ParserProfileModel.java05/06/2002 10:22a34,531ParserProfileSearchModel.java05/06/2002 10:22a10,155ParserRecognitionTestModel.java05/06/2002 10:22a27,337ParserTables.java05/06/2002 10:22a21,697ParseTestModel.java05/06/2002 10:22a18,519PartyRelationshipModel.java05/06/2002 10:22a35,359PartyRelationshipSearchModel.java05/06/2002 10:22a11,799PermissionSearchModel.java05/06/2002 10:22a17,345RecordMaintenanceModel.java05/06/2002 10:22a5,097RegularExpressionTestModel.java05/06/2002 10:22a5,609RemoveTestModel.java05/06/2002 10:22a19,710RoleSearchModel.java05/06/2002 10:22a9,789SampleBomFileAttachModel.java05/06/2002 10:22a16,756SearchTailoredViewModel.java05/06/2002 10:22a11,873SearchUserTypeModel.java05/06/2002 10:22a18,196ServicesSubscriptionSearchModel.java05/06/2002 10:22a6,469SupplierAliasMergeModel.java05/06/2002 10:22a12,915SupplierAliasSearchModel.java05/06/2002 10:22a2,291TemplateControl.java05/06/2002 10:22a25,855TemplateControlModel.java05/06/2002 10:22a2,587TemplateOption.java05/06/2002 10:22a13,627TemplateOptionModel.java05/06/2002 10:22a17,741TemplateSearchModel.java05/06/2002 10:22a65,529UserModel.java05/06/2002 10:22a32,169UserSearchModel.java05/06/2002 10:22a21,038UserTypeModel.java05/06/2002 10:22a4,470ViewSampleBomFileModel.java65 File(s)1,354,158 bytesDirectory of com\agile\sandbox\pi\admin\reports05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a7,716BICReport.java1 File(s)7,716 bytesDirectory of com\agile\sandbox\pi\admin\tests05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a2,044BomRecordTest.java05/06/2002 10:22a1,993TranslateTest.java2 File(s)4,037 bytesDirectory of com\agile\sandbox\pi\admin\util05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a2,788UtilCriteriaBuilder.java05/06/2002 10:22a2,522XMLEntityReference.java05/06/2002 10:22a4,809XMLParser.java05/06/2002 10:22a4,070XMLWriter.java4 File(s)14,189 bytesDirectory of com\agile\sandbox\pi\admin\view05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a<DIR>web0 File(s)0 bytesDirectory of com\agile\sandbox\pi\admin\view\web05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a3,210BBIDownload.java05/06/2002 10:22a<DIR>handler1 File(s)3,210 bytesDirectory of com\agile\sandbox\pi\admin\view\web\handler05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a5,668FileTypeConvertRequestHandler.java05/06/2002 10:22a4,236ImportParserProfileRequestHandler.java05/06/2002 10:22a7,569ParseBomAmlRequestHandler.java05/06/2002 10:22a6,181ParserProfileRequestHandler.java05/06/2002 10:22a3,796ParserRecognitionTestRequestHandler.java05/06/2002 10:22a7,118ParseTestRequestHandler.java6 File(s)34,568 bytesDirectory of com\agile\sandbox\pi\database05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:22a22,882BaseFmaAccessFields.java05/06/2002 10:22a25,646BaseFmaAccessFieldsPeer.java05/06/2002 10:22a23,960BaseFmaAccounts.java05/06/2002 10:22a25,897BaseFmaAccountsPeer.java05/06/2002 10:22a15,112BaseFmaBoms.java05/06/2002 10:22a18,913BaseFmaBomsPeer.java05/06/2002 10:22a24,336BaseFmaCustomFields.java05/06/2002 10:22a26,268BaseFmaCustomFieldsPeer.java05/06/2002 10:22a25,315BaseFmaDashboardDetails.java05/06/2002 10:22a26,940BaseFmaDashboardDetailsPeer.java05/06/2002 10:22a32,492BaseFmaDashboards.java05/06/2002 10:22a39,956BaseFmaDashboardsPeer.java05/06/2002 10:22a28,420BaseFmaDenyFields.java05/06/2002 10:22a24,472BaseFmaDenyFieldsPeer.java05/06/2002 10:22a45,000BaseFmaDepositDetails.java05/06/2002 10:22a69,562BaseFmaDepositDetailsPeer.java05/06/2002 10:22a47,578BaseFmaDeposits.java05/06/2002 10:22a41,726BaseFmaDepositsPeer.java05/06/2002 10:22a24,448BaseFmaErrorLogs.java05/06/2002 10:22a26,201BaseFmaErrorLogsPeer.java05/06/2002 10:22a52,998BaseFmaFieldTypes.java05/06/2002 10:22a19,218BaseFmaFieldTypesPeer.java05/06/2002 10:22a17,873BaseFmaFileLevelDenials.java05/06/2002 10:22a22,052BaseFmaFileLevelDenialsPeer.java05/06/2002 10:22a32,576BaseFmaFileTypes.java05/06/2002 10:22a19,715BaseFmaFileTypesPeer.java05/06/2002 10:22a24,353BaseFmaFilters.java05/06/2002 10:22a19,563BaseFmaFiltersPeer.java05/06/2002 10:22a45,109BaseFmaGroupDepositDetails.java05/06/2002 10:22a26,652BaseFmaGroupDepositDetailsPeer.java05/06/2002 10:22a21,439BaseFmaKeyValueLookup.java05/06/2002 10:22a23,551BaseFmaKeyValueLookupPeer.java05/06/2002 10:22a29,592BaseFmaLocations.java05/06/2002 10:22a26,896BaseFmaLocationsPeer.java05/06/2002 10:22a16,445BaseFmaMessages.java05/06/2002 10:22a19,612BaseFmaMessagesPeer.java05/06/2002 10:22a27,112BaseFmaMetricEvents.java05/06/2002 10:22a27,567BaseFmaMetricEventsPeer.java05/06/2002 10:22a17,046BaseFmaMetricsEventLogs.java05/06/2002 10:22a20,107BaseFmaMetricsEventLogsPeer.java05/06/2002 10:22a13,378BaseFmaMetricsFileLogs.java05/06/2002 10:22a18,516BaseFmaMetricsFileLogsPeer.java05/06/2002 10:22a21,818BaseFmaMetricsTypes.java05/06/2002 10:22a19,350BaseFmaMetricsTypesPeer.java05/06/2002 10:22a42,054BaseFmaNodeCommands.java05/06/2002 10:22a44,477BaseFmaNodeCommandsPeer.java05/06/2002 10:22a42,982BaseFmaNodeViews.java05/06/2002 10:22a40,574BaseFmaNodeViewsPeer.java05/06/2002 10:22a163,097BaseFmaParties.java05/06/2002 10:22a23,527BaseFmaPartiesPeer.java05/06/2002 10:22a27,695BaseFmaPartyAliases.java05/06/2002 10:22a25,061BaseFmaPartyAliasesPeer.java05/06/2002 10:22a82,410BaseFmaPartyRelationships.java05/06/2002 10:22a46,215BaseFmaPartyRelationshipsPeer.java05/06/2002 10:22a18,457BaseFmaPartyTypes.java05/06/2002 10:22a18,750BaseFmaPartyTypesPeer.java05/06/2002 10:22a53,237BaseFmaPermissions.java05/06/2002 10:22a24,524BaseFmaPermissionsPeer.java05/06/2002 10:22a54,937BaseFmaProcesses.java05/06/2002 10:22a22,658BaseFmaProcessesPeer.java05/06/2002 10:22a72,022BaseFmaProcessInstances.java05/06/2002 10:22a79,937BaseFmaProcessInstancesPeer.java05/06/2002 10:22a40,315BaseFmaProcessPartyRelMap.java05/06/2002 10:22a40,812BaseFmaProcessPartyRelMapPeer.java05/06/2002 10:22a29,996BaseFmaProfiles.java05/06/2002 10:22a22,758BaseFmaProfilesPeer.java05/06/2002 10:22a7,439BaseFmaProfileUpdate.java05/06/2002 10:22a15,914BaseFmaProfileUpdatePeer.java05/06/2002 10:22a22,798BaseFmaProperties.java05/06/2002 10:22a22,379BaseFmaPropertiesPeer.java05/06/2002 10:22a26,990BaseFmaRelationshipTypes.java05/06/2002 10:22a19,712BaseFmaRelationshipTypesPeer.java05/06/2002 10:22a23,801BaseFmaRoleFiletypeMap.java05/06/2002 10:22a39,408BaseFmaRoleFiletypeMapPeer.java05/06/2002 10:22a21,166BaseFmaRolePartyMap.java05/06/2002 10:22a24,879BaseFmaRolePartyMapPeer.java05/06/2002 10:22a21,721BaseFmaRolePermissionMap.java05/06/2002 10:22a25,381BaseFmaRolePermissionMapPeer.java05/06/2002 10:22a57,079BaseFmaRoles.java05/06/2002 10:22a20,359BaseFmaRolesPeer.java05/06/2002 10:22a21,055BaseFmaRoleUserMap.java05/06/2002 10:22a24,775BaseFmaRoleUserMapPeer.java05/06/2002 10:22a19,256BaseFmaTableSequenceMap.java05/06/2002 10:22a22,659BaseFmaTableSequenceMapPeer.java05/06/2002 10:22a24,481BaseFmaTemplateCtrlDetails.java05/06/2002 10:22a26,745BaseFmaTemplateCtrlDetailsPeer.java05/06/2002 10:22a80,596BaseFmaTemplateDetails.java05/06/2002 10:22a32,021BaseFmaTemplateDetailsPeer.java05/06/2002 10:22a62,459BaseFmaTemplates.java05/06/2002 10:22a19,212BaseFmaTemplatesPeer.java05/06/2002 10:22a48,282BaseFmaUsers.java05/06/2002 10:22a26,641BaseFmaUsersPeer.java05/06/2002 10:22a11,825BaseFmaVersions.java05/06/2002 10:22a17,665BaseFmaVersionsPeer.java05/06/2002 10:22a18,708BaseFmaWorkflowTasks.java05/06/2002 10:22a20,723BaseFmaWorkflowTasksPeer.java05/06/2002 10:22a63,246BasePmAlgorithmModuleMap.java05/06/2002 10:22a23,012BasePmAlgorithmModuleMapPeer.java05/06/2002 10:22a43,442BasePmAlgorithmModules.java05/06/2002 10:22a20,376BasePmAlgorithmModulesPeer.java05/06/2002 10:22a19,765BasePmAlgorithmParameters.java05/06/2002 10:22a22,965BasePmAlgorithmParametersPeer.java05/06/2002 10:22a22,110BasePmBomFileMaps.java05/06/2002 10:22a25,197BasePmBomFileMapsPeer.java05/06/2002 10:22a74,362BasePmBomFiles.java05/06/2002 10:22a39,624BasePmBomFilesPeer.java05/06/2002 10:22a81,039BasePmBomPartDetails.java05/06/2002 10:22a42,378BasePmBomPartDetailsPeer.java05/06/2002 10:22a16,892BasePmBomPartMaps.java05/06/2002 10:22a19,861BasePmBomPartMapsPeer.java05/06/2002 10:22a26,360BasePmBomPartMatchMap.java05/06/2002 10:22a40,727BasePmBomPartMatchMapPeer.java05/06/2002 10:22a42,905BasePmBomParts.java05/06/2002 10:22a26,009BasePmBomPartsPeer.java05/06/2002 10:22a25,110BasePmCleanseLogs.java05/06/2002 10:22a26,560BasePmCleanseLogsPeer.java05/06/2002 10:22a14,239BasePmFileFormats.java05/06/2002 10:22a18,757BasePmFileFormatsPeer.java05/06/2002 10:22a25,194BasePmMappingLogs.java05/06/2002 10:22a26,620BasePmMappingLogsPeer.java05/06/2002 10:22a26,719BasePmMappingLookups.java05/06/2002 10:22a24,182BasePmMappingLookupsPeer.java05/06/2002 10:22a44,260BasePmMasterPartFeatures.java05/06/2002 10:22a31,827BasePmMasterPartFeaturesPeer.java05/06/2002 10:22a19,552BasePmParserLinePatterns.java05/06/2002 10:22a22,836BasePmParserLinePatternsPeer.java05/06/2002 10:22a86,635BasePmPartMatches.java05/06/2002 10:22a50,489BasePmPartMatchesPeer.java05/06/2002 10:22a26,234BasePmPartUsageForecast.java05/06/2002 10:22a27,376BasePmPartUsageForecastPeer.java05/06/2002 10:22a74,472BasePmPartVendorMaps.java05/06/2002 10:22a44,253BasePmPartVendorMapsPeer.java05/06/2002 10:22a24,727BasePmRecognitionLogs.java05/06/2002 10:22a26,597BasePmRecognitionLogsPeer.java05/06/2002 10:22a41,056BasePmReportLogs.java05/06/2002 10:22a31,948BasePmReportLogsPeer.java05/06/2002 10:22a25,920BasePmStandardizeLogs.java05/06/2002 10:22a27,134BasePmStandardizeLogsPeer.java05/06/2002 10:22a28,314BasePmSubscriptions.java05/06/2002 10:22a41,587BasePmSubscriptionsPeer.java05/06/2002 10:22a32,025BasePmValidationErrors.java05/06/2002 10:22a54,138BasePmValidationErrorsPeer.java05/06/2002 10:22a27,678BasePmValidationErrorTypes.java05/06/2002 10:22a20,225BasePmValidationErrorTypesPeer.java05/06/2002 10:22a36,900BasePmValidationLogs.java05/06/2002 10:22a27,362BasePmValidationLogsPeer.java05/06/2002 10:22a25,662BasePmVendors.java05/06/2002 10:22a22,481BasePmVendorsPeer.java05/06/2002 10:22a528FmaAccessFields.java05/06/2002 10:22a667FmaAccessFieldsPeer.java05/06/2002 10:22a520FmaAccounts.java05/06/2002 10:22a659FmaAccountsPeer.java05/06/2002 10:22a512FmaBoms.java05/06/2002 10:22a651FmaBomsPeer.java05/06/2002 10:22a528FmaCustomFields.java05/06/2002 10:22a667FmaCustomFieldsPeer.java05/06/2002 10:22a536FmaDashboardDetails.java05/06/2002 10:22a675FmaDashboardDetailsPeer.java05/06/2002 10:22a524FmaDashboards.java05/06/2002 10:22a663FmaDashboardsPeer.java05/06/2002 10:22a524FmaDenyFields.java05/06/2002 10:22a663FmaDenyFieldsPeer.java05/06/2002 10:22a532FmaDepositDetails.java05/06/2002 10:22a671FmaDepositDetailsPeer.java05/06/2002 10:22a520FmaDeposits.java05/06/2002 10:22a659FmaDepositsPeer.java05/06/2002 10:22a522FmaErrorLogs.java05/06/2002 10:22a661FmaErrorLogsPeer.java05/06/2002 10:22a524FmaFieldTypes.java05/06/2002 10:22a663FmaFieldTypesPeer.java05/06/2002 10:22a536FmaFileLevelDenials.java05/06/2002 10:22a675FmaFileLevelDenialsPeer.java05/06/2002 10:22a522FmaFileTypes.java05/06/2002 10:22a661FmaFileTypesPeer.java05/06/2002 10:22a518FmaFilters.java05/06/2002 10:22a657FmaFiltersPeer.java05/06/2002 10:22a542FmaGroupDepositDetails.java05/06/2002 10:22a681FmaGroupDepositDetailsPeer.java05/06/2002 10:22a532FmaKeyValueLookup.java05/06/2002 10:22a671FmaKeyValueLookupPeer.java05/06/2002 10:22a522FmaLocations.java05/06/2002 10:22a661FmaLocationsPeer.java05/06/2002 10:22a520FmaMessages.java05/06/2002 10:22a659FmaMessagesPeer.java05/06/2002 10:22a528FmaMetricEvents.java05/06/2002 10:22a667FmaMetricEventsPeer.java05/06/2002 10:22a536FmaMetricsEventLogs.java05/06/2002 10:22a675FmaMetricsEventLogsPeer.java05/06/2002 10:22a534FmaMetricsFileLogs.java05/06/2002 10:22a673FmaMetricsFileLogsPeer.java05/06/2002 10:22a528FmaMetricsTypes.java05/06/2002 10:22a667FmaMetricsTypesPeer.java05/06/2002 10:22a528FmaNodeCommands.java05/06/2002 10:22a667FmaNodeCommandsPeer.java05/06/2002 10:22a522FmaNodeViews.java05/06/2002 10:22a661FmaNodeViewsPeer.java05/06/2002 10:22a518FmaParties.java05/06/2002 10:22a657FmaPartiesPeer.java05/06/2002 10:22a528FmaPartyAliases.java05/06/2002 10:22a667FmaPartyAliasesPeer.java05/06/2002 10:22a540FmaPartyRelationships.java05/06/2002 10:22a679FmaPartyRelationshipsPeer.java05/06/2002 10:22a524FmaPartyTypes.java05/06/2002 10:22a663FmaPartyTypesPeer.java05/06/2002 10:22a526FmaPermissions.Java05/06/2002 10:22a665FmaPermissionsPeer.java05/06/2002 10:22a522FmaProcesses.java05/06/2002 10:22a661FmaProcessesPeer.java05/06/2002 10:22a536FmaProcess Instances.java05/06/2002 10:22a675FmaProcessInstancesPeer.java05/06/2002 10:22a540FmaProcessPartyRelMap.java05/06/2002 10:22a679FmaProcessPartyRelMapPeer.java05/06/2002 10:22a520FmaProfiles.java05/06/2002 10:22a659FmaProfilesPeer.java05/06/2002 10:22a530FmaProfileUpdate.java05/06/2002 10:22a669FmaProfileUpdatePeer.java05/06/2002 10:22a524FmaProperties.java05/06/2002 10:22a663FmaPropertiesPeer.java05/06/2002 10:22a538FmaRelationshipTypes.java05/06/2002 10:22a677FmaRelationshipTypesPeer.java05/06/2002 10:22a534FmaRoleFiletypeMap.java05/06/2002 10:22a673FmaRoleFiletypeMapPeer.java05/06/2002 10:22a528FmaRolePartyMap.java05/06/2002 10:22a667FmaRolePartyMapPeer.java05/06/2002 10:22a538FmaRolePermissionMap.java05/06/2002 10:22a677FmaRolePermissionMapPeer.java05/06/2002 10:22a514FmaRoles.java05/06/2002 10:22a653FmaRolesPeer.java05/06/2002 10:22a526FmaRoleUserMap.java05/06/2002 10:22a665FmaRoleUserMapPeer.java05/06/2002 10:22a536FmaTableSequenceMap.java05/06/2002 10:22a675FmaTableSequenceMapPeer.java05/06/2002 10:22a542FmaTemplateCtrlDetails.java05/06/2002 10:22a681FmaTemplateCtrlDetailsPeer.java05/06/2002 10:22a534FmaTemplateDetails.java05/06/2002 10:22a673FmaTemplateDetailsPeer.java05/06/2002 10:22a522FmaTemplates.java05/06/2002 10:22a661FmaTemplatesPeer.java05/06/2002 10:22a514FmaUsers.java05/06/2002 10:22a653FmaUsersPeer.java05/06/2002 10:22a520FmaVersions.java05/06/2002 10:22a659FmaVersionsPeer.java05/06/2002 10:22a530FmaWorkflowTasks.java05/06/2002 10:22a669FmaWorkflowTasksPeer.java05/06/2002 10:22a<DIR>map05/06/2002 10:22a538PmAlgorithmModuleMap.java05/06/2002 10:22a677PmAlgorithmModuleMapPeer.java05/06/2002 10:22a534PmAlgorithmModules.java05/06/2002 10:22a673PmAlgorithmModulesPeer.java05/06/2002 10:22a540PmAlgorithmParameters.java05/06/2002 10:22a679PmAlgorithmParametersPeer.java05/06/2002 10:22a524PmBomFileMaps.java05/06/2002 10:22a663PmBomFileMapsPeer.java05/06/2002 10:22a518PmBomFiles.java05/06/2002 10:22a657PmBomFilesPeer.java05/06/2002 10:22a530PmBomPartDetails.java05/06/2002 10:22a669PmBomPartDetailsPeer.java05/06/2002 10:23a524PmBomPartMaps.java05/06/2002 10:23a663PmBomPartMapsPeer.java05/06/2002 10:23a532PmBomPartMatchMap.java05/06/2002 10:23a671PmBomPartMatchMapPeer.java05/06/2002 10:23a518PmBomParts.java05/06/2002 10:23a657PmBomPartsPeer.java05/06/2002 10:23a524PmCleanseLogs.java05/06/2002 10:23a663PmCleanseLogsPeer.java05/06/2002 10:23a524PmFileFormats.java05/06/2002 10:23a663PmFileFormatsPeer.java05/06/2002 10:23a524PmMappingLogs.java05/06/2002 10:23a663PmMappingLogsPeer.java05/06/2002 10:23a530PmMappingLookups.java05/06/2002 10:23a669PmMappingLookupsPeer.java05/06/2002 10:23a538PmMasterPartFeatures.java05/06/2002 10:23a677PmMasterPartFeaturesPeer.java05/06/2002 10:23a538PmParserLinePatterns.java05/06/2002 10:23a677PmParserLinePatternsPeer.java05/06/2002 10:23a524PmPartMatches.java05/06/2002 10:23a663PmPartMatchesPeer.java05/06/2002 10:23a536PmPartUsageForecast.java05/06/2002 10:23a675PmPartUsageForecastPeer.java05/06/2002 10:23a530PmPartVendorMaps.java05/06/2002 10:23a669PmPartVendorMapsPeer.java05/06/2002 10:23a532PmRecognitionLogs.java05/06/2002 10:23a671PmRecognitionLogsPeer.java05/06/2002 10:23a522PmReportLogs.java05/06/2002 10:23a661PmReportLogsPeer.java05/06/2002 10:23a532PmStandardizeLogs.java05/06/2002 10:23a671PmStandardizeLogsPeer.java05/06/2002 10:23a528PmSubscriptions.java05/06/2002 10:23a667PmSubscriptionsPeer.java05/06/2002 10:23a534PmValidationErrors.java05/06/2002 10:23a673PmValidationErrorsPeer.java05/06/2002 10:23a542PmValidationErrorTypes.java05/06/2002 10:23a681PmValidationErrorTypesPeer.java05/06/2002 10:23a530PmValidationLogs.java05/06/2002 10:23a669PmValidationLogsPeer.java05/06/2002 10:23a516PmVendors.java05/06/2002 10:23a655PmVendorsPeer.java296 File(s)4,888,079 bytesDirectory of com\agile\sandbox\pi\dataBase\map05/06/2002 10:22a<DIR>.05/06/2002 10:22a<DIR>..05/06/2002 10:22a5,014FmaAccessFieldsMapBuilder.java05/06/2002 10:22a5,179FmaAccountsMapBuilder.java05/06/2002 10:22a3,879FmaBomsMapBuilder.java05/06/2002 10:22a5,386FmaCustomFieldsMapBuilder.java05/06/2002 10:22a5,783FmaDashboardDetailsMapBuilder.java05/06/2002 10:22a5,288FmaDashboardsMapBuilder.java05/06/2002 10:22a4,326FmaDenyFieldsMapBuilder.java05/06/2002 10:22a7,613FmaDepositDetailsMapBuilder.java05/06/2002 10:22a6,130FmaDepositsMapBuilder.java05/06/2002 10:22a5,427FmaErrorLogsMapBuilder.java05/06/2002 10:22a4,082FmaFieldTypesMapBuilder.java05/06/2002 10:22a4,347FmaFileLevelDenialsMapBuilder.java05/06/2002 10:22a4,388FmaFileTypesMapBuilder.java05/06/2002 10:22a4,282FmaFiltersMapBuilder.java05/06/2002 10:22a5,595FmaGroupDepositDetailsMapBuilder.java05/06/2002 10:22a5,250FmaKeyValueLookupMapBuilder.java05/06/2002 10:22a7,300FmaLocationsMapBuilder.java05/06/2002 10:22a4,316FmaMessagesMapBuilder.java05/06/2002 10:22a6,222FmaMetricEventsMapBuilder.java05/06/2002 10:22a4,678FmaMetricsEventLogsMapBuilder.java05/06/2002 10:22a3,628FmaMetricsFileLogsMapBuilder.java05/06/2002 10:22a4,166FmaMetricsTypesMapBuilder.java05/06/2002 10:22a7,543FmaNodeCommandsMapBuilder.java05/06/2002 10:22a5,556FmaNodeViewsMapBuilder.java05/06/2002 10:22a5,233FmaPartiesMapBuilder.java05/06/2002 10:22a4,606FmaPartyAliasesMapBuilder.java05/06/2002 10:22a5,421FmaPartyRelationshipsMapBuilder.java05/06/2002 10:22a3,786FmaPartyTypesMapBuilder.java05/06/2002 10:22a5,915FmaPermissionsMapBuilder.java05/06/2002 10:22a4,722FmaProcessesMapBuilder.java05/06/2002 10:22a7,245FmaProcessInstancesMapBuilder.java05/06/2002 10:22a5,335FmaProcessPartyRelMapMapBuilder.java05/06/2002 10:22a6,247FmaProfilesMapBuilder.java05/06/2002 10:22a1,959FmaProfileUpdateMapBuilder.java05/06/2002 10:22a6,048FmaPropertiesMapBuilder.java05/06/2002 10:22a4,389FmaRelationshipTypesMapBuilder.java05/06/2002 10:22a4,841FmaRoleFiletypeMapMapBuilder.java05/06/2002 10:22a4,630FmaRolePartyMapMapBuilder.java05/06/2002 10:22a4,853FmaRolePermissionMapMapBuilder.java05/06/2002 10:22a4,754FmaRolesMapBuilder.java05/06/2002 10:22a4,589FmaRoleUserMapMapBuilder.java05/06/2002 10:22a4,725FmaTableSequenceMapMapBuilder.java05/06/2002 10:22a5,643FmaTemplateCtrlDetailsMapBuilder.java05/06/2002 10:22a8,974FmaTemplateDetailsMapBuilder.java05/06/2002 10:22a4,068FmaTemplatesMapBuilder.java05/06/2002 10:22a5,556FmaUsersMapBuilder.java05/06/2002 10:22a3,116FmaVersionsMapBuilder.java05/06/2002 10:22a5,067FmaWorkflowTasksMapBuilder.java05/06/2002 10:22a4,962PmAlgorithmModuleMapMapBuilder.java05/06/2002 10:22a4,843PmAlgorithmModulesMapBuilder.java05/06/2002 10:22a4,834PmAlgorithmParametersMapBuilder.java05/06/2002 10:22a4,650PmBomFileMapsMapBuilder.java05/06/2002 10:22a4,979PmBomFilesMapBuilder.java05/06/2002 10:22a17,030PmBomPartDetailsMapBuilder.java05/06/2002 10:22a4,490PmBomPartMapsMapBuilder.java05/06/2002 10:22a5,500PmBomPartMatchMapMapBuilder.java05/06/2002 10:22a5,321PmBomPartsMapBuilder.java05/06/2002 10:22a5,574PmCleanseLogsMapBuilder.java05/06/2002 10:22a3,790PmFileFormatsMapBuilder.java05/06/2002 10:22a5,608PmMappingLogsMapBuilder.java05/06/2002 10:22a7,283PmMappingLookupsMapBuilder.java05/06/2002 10:22a12,472PmMasterPartFeaturesMapBuilder.java05/06/2002 10:22a4,779PmParserLinePatternsMapBuilder.java05/06/2002 10:22a19,781PmPartMatchesMapBuilder.java05/06/2002 10:22a6,112PmPartUsageForecastMapBuilder.java05/06/2002 10:22a16,332PmPartVendorMapsMapBuilder.java05/06/2002 10:22a5,507PmRecognitionLogsMapBuilder.java05/06/2002 10:22a10,307PmReportLogsMapBuilder.java05/06/2002 10:22a5,838PmStandardizeLogsMapBuilder.java05/06/2002 10:22a5,874PmSubscriptionsMapBuilder.java05/06/2002 10:22a6,412PmValidationErrorsMapBuilder.java05/06/2002 10:22a4,748PmValidationErrorTypesMapBuilder.java05/06/2002 10:22a6,049PmValidationLogsMapBuilder.java05/06/2002 10:22a4,624PmVendorsMapBuilder.java74 File(s)434,799 bytesDirectory of com\agile\sandbox\pi\fma05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>common05/06/2002 10:23a<DIR>components05/06/2002 10:23a<DIR>controller05/06/2002 10:23a<DIR>custom05/06/2002 10:23a<DIR>eventhandlers05/06/2002 10:23a<DIR>events05/06/2002 10:23a<DIR>model05/06/2002 10:23a<DIR>repository05/06/2002 10:23a<DIR>transformation05/06/2002 10:23a<DIR>utils05/06/2002 10:23a<DIR>view05/06/2002 10:23a<DIR>workflow0 File(s)0 bytesDirectory of com\agile\sandbox\pi\fma\common05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a9,006AgileEHubServer.java05/06/2002 10:23a9,944ApplicationLifecycle.html05/06/2002 10:23a1,713ApplicationLifecycle.java05/06/2002 10:23a1,689ConfigProperties.java05/06/2002 10:23a229EHubException.java05/06/2002 10:23a4,591ErrorMsgs.java05/06/2002 10:23a14,086GlobalConstants.java05/06/2002 10:23a3,226Lookup.java05/06/2002 10:23a4,157Sequence.java05/06/2002 10:23a245SequenceException.java05/06/2002 10:23a942ShutdownApplication.java05/06/2002 10:23a2,338StartupApplication.java05/06/2002 10:23a4,686SystemConstants.java05/06/2002 10:23a<DIR>test13 File(s)56,852 bytesDirectory of com\agile\sandbox\pi\fma\common\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,549AgileEHubServerTest.java1 File(s)2,549 bytesDirectory of com\agile\sandbox\pi\fma\components05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>account05/06/2002 10:23a<DIR>collect05/06/2002 10:23a<DIR>epackage05/06/2002 10:23a<DIR>metrics0 File(s)0 bytesDirectory of com\agile\sandbox\pi\fma\components\account05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>dao05/06/2002 10:23a4,993User.java1 File(s)4,993 bytesDirectory of com\agile\sandbox\pi\fma\components\account\dao05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a13,275AccountDAO.java1 File(s)13,275 bytesDirectory of com\agile\sandbox\pi\fma\components\collect05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a13,143CollectTemplate.java05/06/2002 10:23a<DIR>dao05/06/2002 10:23a6,392PlatformCommands.java05/06/2002 10:23a13,313TailorViewTemplate.java05/06/2002 10:23a332Template.java05/06/2002 10:23a5,354ViewButton.java05/06/2002 10:23a10,593ViewTemplate.java6 File(s)49,127 bytesDirectory of com\agile\sandbox\pi\fma\components\collect\dao05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a36,304CollectDAO.java1 File(s)36,304 bytesDirectory of com\agile\sandbox\pi\fma\components\epackage05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a474CompletePackage.java05/06/2002 10:23a<DIR>dao05/06/2002 10:23a3,409HistoryItem.java05/06/2002 10:23a2,373PackageTerminator.java05/06/2002 10:23a2,691PackageView.java05/06/2002 10:23a3,180ViewFieldItem.java5 File(s)12,127 bytesDirectory of com\agile\sandbox\pi\fma\components\epackage\dao05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a67,799EpackageDAO.java05/06/2002 10:23a8,954EpackageDelegate.java2 File(s)76,753 bytesDirectory of com\agile\sandbox\pi\fma\components\metrics05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>dao05/06/2002 10:23a1,225FileMetricsLog.java05/06/2002 10:23a2,759MetricsLog.java05/06/2002 10:23a2,306MetricsUtil.java3 File(s)6,290 bytesDirectory of com\agile\sandbox\pi\fma\components\metrics\dao05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a5,029MetricsDAO.java1 File(s)5,029 bytesDirectory of com\agile\sandbox\pi\fma\controller05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,992EventController.java05/06/2002 10:23a438EventControllerException.java2 File(s)3,430 bytesDirectory of com\agile\sandbox\pi\fma\custom05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a11,246APWCustomCTFAlgorithm.java05/06/2002 10:23a9,184APWCustomSubCTFAlgorithm.java05/06/2002 10:23a5,830CustomDropDown.java05/06/2002 10:23a3,768CustomItem.java05/06/2002 10:23a8,966CustomSQLBasedDropDown.java05/06/2002 10:23a7,516SLRCustomCEAustList.java05/06/2002 10:23a7,516SLRCustomCECharList.java05/06/2002 10:23a7,561SLRCustomCEList.java05/06/2002 10:23a7,516SLRCustomCEMilpList.java05/06/2002 10:23a8,271SLRCustomCESiteList.java05/06/2002 10:23a6,497SLRCustomCustomerList.java05/06/2002 10:23a6,236SmartCustomCheckerList.java05/06/2002 10:23a8,554SmartCustomIdGenerator.java05/06/2002 10:23a10,177SmartCustomPartNumber.java05/06/2002 10:23a<DIR>test14 File(s)108, 838 bytes05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a3,771SLRCustomCESiteListTest.java1 File(s)3,771 bytesDirectory of com\agile\sandbox\pi\fma\eventhandlers05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a456AbsEventHandler.java05/06/2002 10:23a6,018ActivePackageEH.java05/06/2002 10:23a8,949CheckOutEH.java05/06/2002 10:23a5,803CollectEH.java05/06/2002 10:23a17,890CopyEH.java05/06/2002 10:23a1,063EventHandler.java05/06/2002 10:23a432EventHandlerException.java05/06/2002 10:23a4,658ForgotPasswordEH.java05/06/2002 10:23a11,209LaunchEH.java05/06/2002 10:23a12,373LaunchRequestEH.java05/06/2002 10:23a11,644ModifyEH.java05/06/2002 10:23a7,489ModifyRequestEH.java05/06/2002 10:23a3,179MultiFileLaunchEH.java05/06/2002 10:23a4,710PasswordUpdateEH.java05/06/2002 10:23a16,034PortalEH.java05/06/2002 10:23a4,618ReassignEH.java05/06/2002 10:23a38,783SearchEH.java05/06/2002 10:23a3,181SearchEHBase.java05/06/2002 10:23a12,080ServiceEH.java05/06/2002 10:23a26,159SimpleSearchEH.java05/06/2002 10:23a13,790SourceDestEH.java05/06/2002 10:23a2,956TabControllerEH.java05/06/2002 10:23a<DIR>test05/06/2002 10:23a7,421TodoEH.java05/06/2002 10:23a19,664ViewEH.java24 File(s)240, 559 bytes05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a5,450CopyEHTest.java05/06/2002 10:23a10,469SearchEHTest.java05/06/2002 10:23a9,938SimpleSearchEHTest.java3 File(s)25,857 bytesDirectory of com\agile\sandbox\pi\fma\events05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,343AbsEvent.java05/06/2002 10:23a806ActivePackageEvent.java05/06/2002 10:23a16,097CollectEvent.java05/06/2002 10:23a3,265CopyEvent.java05/06/2002 10:23a2,026DistributeEvent.java05/06/2002 10:23a2,127Event.java05/06/2002 10:23a2,111EventErrors.java05/06/2002 10:23a1,040ForgotPasswordEvent.java05/06/2002 10:23a2,224PasswordUpdateEvent.java05/06/2002 10:23a1,600PortalEvent.java05/06/2002 10:23a1,520ReassignEvent.java05/06/2002 10:23a14,145SearchEvent.java05/06/2002 10:23a1,601ServiceEvent.java05/06/2002 10:23a2,711SignInEvent.java05/06/2002 10:23a1,121SignOutEvent.java05/06/2002 10:23a4,322SimpleSearchEvent.java05/06/2002 10:23a1,039SourceDestEvent.java05/06/2002 10:23a718TabControllerEvent.java05/06/2002 10:23a1,176TodoEvent.java05/06/2002 10:23a1,118UploadEvent.java05/06/2002 10:23a3,470ViewEvent.java21 File(s)68,580 bytesDirectory of com\agile\sandbox\pi\fma\model05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a366AbsModel.java05/06/2002 10:23a4,221AutoItem.java05/06/2002 10:23a9,056CheckRadioItem.java05/06/2002 10:23a4,085ColumnHeader.java05/06/2002 10:23a8,951ControlTextItem.java05/06/2002 10:23a11,593CustomModel.java05/06/2002 10:23a2,298DashboardModel.java05/06/2002 10:23a3,037DateItem.java05/06/2002 10:23a5,181DropDownItem.java05/06/2002 10:23a2,300ErrorModel.java05/06/2002 10:23a5,736FileItem.java05/06/2002 10:23a2,037FileOthersItem.java05/06/2002 10:23a2,171ForgotPasswordModel.java05/06/2002 10:23a2,438HeaderItem.java05/06/2002 10:23a3,233HiddenItem.java05/06/2002 10:23a3,239HyperLinkItem.java05/06/2002 10:23a2,455InstructionsItem.java05/06/2002 10:23a724Model.java05/06/2002 10:23a2,513MultiFileItem.java05/06/2002 10:23a3,133OptionItem.java05/06/2002 10:23a1,484PageModel.java05/06/2002 10:23a3,405ParseFileItem.java05/06/2002 10:23a4,597PasswordUpdateModel.java05/06/2002 10:23a8,947SearchModel.java05/06/2002 10:23a5,614SelectItem.java05/06/2002 10:23a2,818SelectRowItem.java05/06/2002 10:23a1,748SimpleSearchResultsModel.java05/06/2002 10:23a3,453SourceDestModel.java05/06/2002 10:23a5,152SummaryModel.java05/06/2002 10:23a4,331TableModel.java05/06/2002 10:23a544TemplateItem.java05/06/2002 10:23a5,246TextAreaItem.java05/06/2002 10:23a4,950TextBoxItem.java05/06/2002 10:23a3,965TextItem.java05/06/2002 10:23a1,909UploadStatusModel.java35 File(s)136, 930 bytesDirectory of com\agile\sandbox\pi\fma\repository05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a9,277FileRepository.java05/06/2002 10:23a435FileRepositoryException.java2 File(s)9,712 bytesDirectory of com\agile\sandbox\pi\fma\transformation05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a6,682Formatter.java05/06/2002 10:23a546TransformationException.java2 File(s)7,228 bytesDirectory of com\agile\sandbox\pi\fma\utils05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a9,950BarChartGenerator.java05/06/2002 10:23a6,085ChartUtils.java05/06/2002 10:23a4,024DAOUtils.java05/06/2002 10:23a4,327PieChartGenerator.java05/06/2002 10:23a11,158PropertyManager.java05/06/2002 10:23a<DIR>test05/06/2002 10:23a3,812TimeManager.java05/06/2002 10:23a8,397Utilities.java7 File(s)47,753 bytesDirectory of com\agile\sandbox\pi\fma\utils\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a5,677PropertyManagerTest.java05/06/2002 10:23a4,066TimeManagerTest.java05/06/2002 10:23a2,746UtilitiesTest.java3 File(s)12,489 bytesDirectory of com\agile\sandbox\pi\fma\view05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a725DashboardException.java05/06/2002 10:23a34,154DashboardTable.java05/06/2002 10:23a9,362NavController.java05/06/2002 10:23a426NavControllerException.java05/06/2002 10:23a1,980RedirectException.java05/06/2002 10:23a1,125RedirectionController.java05/06/2002 10:23a2,873TableDescription.java05/06/2002 10:23a1,202View.java05/06/2002 10:23a11,164ViewController.java05/06/2002 10:23a429ViewControllerException.java05/06/2002 10:23a<DIR>web10 File(s)63,440 bytesDirectory of com\agile\sandbox\pi\fma\view\web05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a827ConfigurationException.java05/06/2002 10:23a7,128Download.java05/06/2002 10:23a<DIR>handler05/06/2002 10:23a1,868Help.java05/06/2002 10:23a10,554JReportWrapper.java05/06/2002 10:23a1,136Log4JController.java05/06/2002 10:23a4,565Main.java05/06/2002 10:23a13,929RedirectServlet.java05/06/2002 10:23a953RefreshQueryConfig.java05/06/2002 10:23a4,570Screen.java05/06/2002 10:23a30,778WebController.java10 File(s)76,308 bytesDirectory of com\agile\sandbox\pi\fma\view\web\handler05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a13,298CollectRequestHandler.java05/06/2002 10:23a9,336DefaultRequestHandler.java05/06/2002 10:23a3,217DistributeRequestHandler.java05/06/2002 10:23a31,845MultipartRequestHandler.java05/06/2002 10:23a3,512PortalRequestHandler.java05/06/2002 10:23a2,843ReassignRequestHandler.java05/06/2002 10:23a438RequestHandleException.java05/06/2002 10:23a1,496RequestHandler.java05/06/2002 10:23a5,423SearchRequestHandler.java05/06/2002 10:23a3,087ServiceRequestHandler.java05/06/2002 10:23a3,158SimpleSearchRequestHandler.java05/06/2002 10:23a731TodoRequestHandler.java12 File(s)78,384 bytesDirectory of com\agile\sandbox\pi\fma\workflow05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>common05/06/2002 10:23a<DIR>dwe05/06/2002 10:23a<DIR>test05/06/2002 10:23a<DIR>wlpi0 File(s)0 bytesDirectory of com\agile\sandbox\pi\fma\workflow\common05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a1,982Assignee.java05/06/2002 10:23a1,033DepositInfo.java05/06/2002 10:23a4,589PackageInfo.java05/06/2002 10:23a1,140PackagesCache.java05/06/2002 10:23a5,276PackagesSyncThread.java05/06/2002 10:23a2,475TaskInfo.java05/06/2002 10:23a735UnsupportedWorkflowException.java05/06/2002 10:23a2,077WflnstanceInfo.java05/06/2002 10:23a22,138WorkflowAdaptor.java05/06/2002 10:23a10,503WorkflowAdminAdaptor.java05/06/2002 10:23a389WorkflowBase.java05/06/2002 10:23a658WorkflowException.java05/06/2002 10:23a6,607WorkflowFactory.java05/06/2002 10:23a15,761WorkflowHandle.java14 File(s)75,363 bytesDirectory of com\agile\sandbox\pi\fma\workflow\dwe05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a9,491ActionDriver.java05/06/2002 10:23a2,249AssignTask.java05/06/2002 10:23a854DefaultAsynchTask.java05/06/2002 10:23a917DefaultSynchTask.java05/06/2002 10:23a9,838DWEEmail.java05/06/2002 10:23a36,682WorkflowAdaptorlmpl.java05/06/2002 10:23a16,546WorkflowAdminAdaptorlmpl.java05/06/2002 10:23a1,885WorkflowAttributeSetter.java8 File(s)78,462 bytesDirectory of com\agile\sandbox\pi\fma\workflow\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a5,212DWEWorkflowAdminTest.java05/06/2002 10:23a11,516DWEWorkflowTest.java05/06/2002 10:23a4,462WorkflowAdminTest.java05/06/2002 10:23a7,581WorkflowTest.java4 File(s)28,771 bytesDirectory of com\agile\sandbox\pi\fma\workflow\wlpi05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,400MessageSender.java05/06/2002 10:23a1,827PasswordUpdate.java05/06/2002 10:23a1,466WLPIDBUtils.java05/06/2002 10:23a4,378WLPIMessageSender.java05/06/2002 10:23a49,194WorkflowAdaptorlmpl.java05/06/2002 10:23a23,739WorkflowAdminAdaptorlmpl.java6 File(s)85,004 bytesDirectory of com\agile\sandbox\pi\logger05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a7,642DailyRollingFileAppender.java1 File(s)7,642 bytesDirectory of com\agile\sandbox\pi\notification05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>mail05/06/2002 10:23a376NotificationException.java05/06/2002 10:23a979Notifier.java2 File(s)1,355 bytesDirectory of com\agile\sandbox\pi\notification\mail05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a6,157Mailer.java1 File(s)6,157 bytesDirectory of com\agile\sandbox\pi\pm05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>agileimport05/06/2002 10:23a<DIR>cleanse05/06/2002 10:23a<DIR>cm05/06/2002 10:23a<DIR>mapping05/06/2002 10:23a4,687ProcessModule.java05/06/2002 10:23a1,095ProcessModuleAlgorithmBase.java05/06/2002 10:23a<DIR>recognition05/06/2002 10:23a<DIR>reports05/06/2002 10:23a<DIR>standardize05/06/2002 10:23a<DIR>test05/06/2002 10:23a<DIR>util05/06/2002 10:23a<DIR>validate2 File(s)5,782 bytesDirectory of com\agile\sandbox\pi\pm\agileimport05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,887AgileImport.java05/06/2002 10:23a48,480AgileImportBase.java05/06/2002 10:23a9,478AMLImport.java05/06/2002 10:23a14,317BOMImport.java05/06/2002 10:23a5,406MfrImport.java05/06/2002 10:23a6,122MfrPartImport.java05/06/2002 10:23a6,372PartImport.java05/06/2002 10:23a<DIR>test05/06/2002 10:23a<DIR>util7 File(s)95,062 bytesDirectory of com\agile\sandbox\pi\pm\agileimport\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,860AgileAPIConstants.java05/06/2002 10:23a2,447AgileSubClassID.java2 File(s)7,307 bytesDirectory of com\agile\sandbox\pi\pm\agileimport\util05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a1,358AgileAttributes.java05/06/2002 10:23a890AgileFieldsMap.java05/06/2002 10:23a57,865AgileImportUtil.java05/06/2002 10:23a3,051DefaultAttributesMap.java05/06/2002 10:23a5,923ManufacturerPartsAttributes.java05/06/2002 10:23a5,574ManufacturersAttributes.java05/06/2002 10:23a9,254PartsAttributes.java05/06/2002 10:23a3,038SiteImportPolicy.java05/06/2002 10:23a6,127SmartRules.java05/06/2002 10:23a<DIR>test9 File(s)93,080 bytesDirectory of com\agile\sandbox\pi\pm\agileimport\util\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a1,744AgileAttributesTest.java05/06/2002 10:23a8,068AgileImportUtilTest.java05/06/2002 10:23a3,235ManufacturerPartsAttributesTest.java05/06/2002 10:23a3,153ManufacturersAttributesTest.java05/06/2002 10:23a4,351PartsAttributesTest.java05/06/2002 10:23a1,857SmartRulesTest.java6 File(s)22,408 bytesDirectory of com\agile\sandbox\pi\pm\cleanse05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a6,631CharacterRemoval.java05/06/2002 10:23a7,485Cleanse.java05/06/2002 10:23a3,496CleanseAlgorithmBase.java05/06/2002 10:23a754CleanseException.java05/06/2002 10:23a4,830RefDesExpansion.java05/06/2002 10:23a22,223ReferenceDesignator.java05/06/2002 10:23a<DIR>test6 File(s)45,419 bytesDirectory of com\agile\sandbox\pi\pm\cleanse\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,594CharacterRemovalTest.java05/06/2002 10:23a2,689CleanseTest.java05/06/2002 10:23a28,396ReferenceDesignatorTest.java3 File(s)33,679 bytes05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a16,281BomValidationManager.java05/06/2002 10:23a23,130CMBase.java05/06/2002 10:23a688CMStandardAlgorithm.java05/06/2002 10:23a9,405ComponentManagement.java05/06/2002 10:23a4,070ComponentManagementAsync.java05/06/2002 10:23a<DIR>postprocessor05/06/2002 10:23a<DIR>preprocessor05/06/2002 10:23a<DIR>rule05/06/2002 10:23a<DIR>test05/06/2002 10:23a<DIR>util5 File(s)53,574 bytesDirectory of com\agile\sandbox\pi\pm\cm\postprocessor05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a994PostProcessorBase.java1 File(s)994 bytesDirectory of com\agile\sandbox\pi\pm\cm\preprocessor05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a5,844PartTranslator.java05/06/2002 10:23a1,013PreProcessorBase.java2 File(s)6,857 bytesDirectory of com\agile\sandbox\pi\pm\cm\rule05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a1,733PartMatchRule.java05/06/2002 10:23a3,955RuleBase.java2 File(s)5,688 bytesDirectory of com\agile\sandbox\pi\pm\cm\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,816BomValidationManagerTest.java05/06/2002 10:23a6,966CMTest.java05/06/2002 10:23a7,732PartyAliasManagerTest.java3 File(s)17,514 bytesDirectory of com\agile\sandbox\pi\pm\cm\util05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a298BomBlockData.java05/06/2002 10:23a15,601BomValidationManager.java05/06/2002 10:23a4,000BomValidationRow.java05/06/2002 10:23a33,860CMAlgorithmUtil.java05/06/2002 10:23a5,293CMProfileData.java05/06/2002 10:23a508DifferentialData.java05/06/2002 10:23a9,056PartyAliasManager.java7 File(s)68,616 bytesDirectory of com\agile\sandbox\pi\pm\mapping05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a3,227DepositPartNumberGenerator.java05/06/2002 10:23a3,792MapAlgorithmBase.java05/06/2002 10:23a730MapException.java05/06/2002 10:23a11,167MapInputCriteria.java05/06/2002 10:23a1,664MapOutput.java05/06/2002 10:23a4,833Mapping.java05/06/2002 10:23a8,172MapResultGenerator.java05/06/2002 10:23a4,368PartNumberGenerator.java05/06/2002 10:23a<DIR>test8 File(s)37,953 bytesDirectory of com\agile\sandbox\pi\pm\mapping\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a3,025DepositPartNumberGeneratorTest.java05/06/2002 10:23a10,738MapResultGeneratorTest.java2 File(s)13,763 bytesDirectory of com\agile\sandbox\pi\pm\recognition05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a11,154ParserRecognition.java05/06/2002 10:23a3,079RecognitionAlgorithmBase.java05/06/2002 10:23a10,012RecognitionData.java05/06/2002 10:23a667RecognitionException.java05/06/2002 10:23a4,342StandardRecognitionAlgorithm.java05/06/2002 10:23a<DIR>test5 File(s)29,254 bytesDirectory of com\agile\sandbox\pi\pm\recognition\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a6,804ParserRecognitionTest.java1 File(s)6,804 bytesDirectory of com\agile\sandbox\pi\pm\reports05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,372BBIReport.java05/06/2002 10:23a5,059BRCReport.java05/06/2002 10:23a2,395DellAMLReport.java05/06/2002 10:23a2,394DellBOMReport.java05/06/2002 10:23a17,531FileDiffReport.java05/06/2002 10:23a8,266getRptDescPage2.jsp05/06/2002 10:23a10,087JNIExcelCopier.java05/06/2002 10:23a8,420JReportAlgorithm.java05/06/2002 10:23a11,114JReportServer.java05/06/2002 10:23a6,302KludgeExactMatchReport.java05/06/2002 10:23a9,647OutputReport.java05/06/2002 10:23a20,791PartCountReport.java05/06/2002 10:23a2,364PDXReport.java05/06/2002 10:23a8,194ReportAlgorithmBase.java05/06/2002 10:23a778ReportException.java05/06/2002 10:23a3,551runReport2.jsp05/06/2002 10:23a<DIR>test16 File(s)119,265 bytesDirectory of com\agile\sandbox\pi\pm\reports\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,963BBIReportTest.java05/06/2002 10:23a2,258JNIExcelCopierTest.java05/06/2002 10:23a3,763OutputReportTest.java3 File(s)8,984 bytesDirectory of com\agile\sandbox\pi\pm\standardize05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a59,298CachedMergerAlgorithm.java05/06/2002 10:23a3,913CustomParserAlgorithm.java05/06/2002 10:23a71,251ParserAlgorithmBase.java05/06/2002 10:23a<DIR>postprocessor05/06/2002 10:23a<DIR>preprocessor05/06/2002 10:23a14,331Standardize.java05/06/2002 10:23a1,183StandardizeException.java05/06/2002 10:23a53,265StandardMergerAlgorithm.java05/06/2002 10:23a9,309StandardParser.java05/06/2002 10:23a19,889StandardParserAlgorithm.java05/06/2002 10:23a<DIR>submodule05/06/2002 10:23a<DIR>test05/06/2002 10:23a<DIR>util8 File(s)232,439 bytesDirectory of com\agile\sandbox\pi\pm\standardize\postprocessor05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a13,049BomLevelAssembler.java05/06/2002 10:23a12,108BomPartDetailMerger.java05/06/2002 10:23a4,441CharacterRemoval.java05/06/2002 10:23a4,177FieldAppender.java05/06/2002 10:23a446PostProcessorBase.java05/06/2002 10:23a3,692RefDesPostExpander.java6 File(s)37,913 bytesDirectory of com\agile\sandbox\pi\pm\standardize\preprocessor05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a3,325DocToTxtConverter.java05/06/2002 10:23a6,446ExcelToTxtConverter.java05/06/2002 10:23a3,781HSSFToTextConverter.java05/06/2002 10:23a2,285HtmlToTxtConverter.java05/06/2002 10:23a2,843NonBreakingSpaceConverter.java05/06/2002 10:23a2,518PdfToTxtConverter.java05/06/2002 10:23a6,294PdxToTxtConverter.java05/06/2002 10:23a2,284PreProcessorBase.java05/06/2002 10:23a5,288TLAHeaderMover.java9 File(s)35,064 bytesDirectory of com\agile\sandbox\pi\pm\standardize\submodule05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,004AvlFieldExtractor.java05/06/2002 10:23a3,129BomFieldDiverter.java05/06/2002 10:23a5,412BomFieldExtractor.java05/06/2002 10:23a3,999BomFieldReplacer.java05/06/2002 10:23a2,527DuplicatedVendorsRemover.java05/06/2002 10:23a3,487FieldMerger.java05/06/2002 10:23a3,421FieldMultiPatternExtractor.java05/06/2002 10:23a1,635FirstVPNAsPN.java05/06/2002 10:23a4,463ParserSubModuleBase.java05/06/2002 10:23a2,225PartNumberCleaner.java05/06/2002 10:23a4,990PreviousFieldRetriever.java05/06/2002 10:23a5,089QuantityCalculator.java05/06/2002 10:23a1,920QuantityUOMSplitter.java05/06/2002 10:23a3,606RefDesCleaner.java05/06/2002 10:23a1,943RefDesExpander.java05/06/2002 10:23a4,735RefDesFilter.java05/06/2002 10:23a7,271VendorDataCopierA.java05/06/2002 10:23a6,367VendorDataCopierB.java05/06/2002 10:23a2,475VendorDataDuplicater.java05/06/2002 10:23a1,969VendorDataMerger.java05/06/2002 10:23a9,272VendorDataSplitter.java05/06/2002 10:23a2,174VendorPartNumberReplacer.java22 File(s)86,113 bytesDirectory of com\agile\sandbox\pi\pm\standardize\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a7,627StandardizeTest.java05/06/2002 10:23a14,135StandardParserTest.java2 File(s)21,762 bytesDirectory of com\agile\sandbox\pi\pm\standardize\util05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a637BlockIndicatorData.java05/06/2002 10:23a1,233MergerProfileData.java05/06/2002 10:23a17,837ParserAlgorithmUtil.java05/06/2002 10:23a1,510ParserDifferenceData.java05/06/2002 10:23a2,911ParserErrorData.java05/06/2002 10:23a30,421ParserProfileData.java05/06/2002 10:23a1,336ParserSelectOneREVGlobalSeq.java05/06/2002 10:23a3,947PmBomPartDetailsClass.java05/06/2002 10:23a6,403PmObjectCopier.java05/06/2002 10:23a2,979PmObjectSaver.java05/06/2002 10:23a3,946PmPartVendorMapsClass.java05/06/2002 10:23a4,758TLA.java12 File(s)77,918 bytesDirectory of com\agile\sandbox\pi\pm\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a3,630pmTest.java1 File(s)3,630 bytesDirectory of com\agile\sandbox\pi\pm\util05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a1,760AlgorithmProfileData.java05/06/2002 10:23a4,452Base32.java05/06/2002 10:23a26,074BBIGenerator.java05/06/2002 10:23a2,881BBIToExcel.java05/06/2002 10:23a719BomBlock.java05/06/2002 10:23a8,246BOMPackage.java05/06/2002 10:23a781BOMPackageException.java05/06/2002 10:23a9,082Constants.java05/06/2002 10:23a2,376CSVStringlterator.java05/06/2002 10:23a<DIR>datasource05/06/2002 10:23a739DBSelectOneREVGlobalSeq.java05/06/2002 10:23a1,906DBUtils.java05/06/2002 10:23a14,468DellGenerator.java05/06/2002 10:23a2,506FileLocator.java05/06/2002 10:23a3,768FileTypeUtils.java05/06/2002 10:23a2,397FileUtils.java05/06/2002 10:23a14,575FrameworkUtils.java05/06/2002 10:23a10,624ParserUtils.java05/06/2002 10:23a15,487PDXGenerator.java05/06/2002 10:23a1,450PMErrorNotification.java05/06/2002 10:23a15,468ProcessorUtils.java05/06/2002 10:23a<DIR>test05/06/2002 10:23a757ThreadRunnable.java05/06/2002 10:23a3,813ThreadUtils.java05/06/2002 10:23a780VendorBlock.java23 File(s)145,109 bytesDirectory of com\agile\sandbox\pi\pm\util\datasource05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>arrow05/06/2002 10:23a11,515ArrowDataSource.java05/06/2002 10:23a1,395DataSourceBase.java05/06/2002 10:23a8,548DataSourceConfiguration.java05/06/2002 10:23a6,169JDBCDataSource.java05/06/2002 10:23a8,427ReferenceArrow.java05/06/2002 10:23a3,251ReferenceData.java05/06/2002 10:23a12,935ReferenceJDBC.java05/06/2002 10:23a4,681ReferenceSOAP.java05/06/2002 10:23a30,085SOAPDataSource.java9 File(s)87,006 bytesDirectory of com\agile\sandbox\pi\pm\util\datasource\arrow05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,768Exception.java05/06/2002 10:23a12,800Https_Arrow_Web_Service_ComBindingStub.java05/06/2002 10:23a535Https_Arrow_Web_Service_ComPortType.java05/06/2002 10:23a750Https_Arrow_Web_Service_ComService.java05/06/2002 10:23a4,738Https_Arrow_Web_Service_ComServiceLocator.java05/06/2002 10:23a3,904Manufacturer.java05/06/2002 10:23a7,967MarketInformationReqStructArrayItem.java05/06/2002 10:23a7,774MarketInformationRequestMoreParam.java05/06/2002 10:23a5,916MarketInformationResponse.java05/06/2002 10:23a6,852MarketInformationResStructArrayItem.java05/06/2002 10:23a10,662MarketPartInfoArrayItem.java05/06/2002 10:23a5,441PriceAvailInfo.java05/06/2002 10:23a4,017PriceBreakArrayItem.java05/06/2002 10:23a7,603RiskInfo.java05/06/2002 10:23a4,857UserAuth.java15 File(s)88,584 bytes05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,572BOMPackageTest.java05/06/2002 10:23a2,340DBUtilsTest.java05/06/2002 10:23a2,051FileUtilsTest.java05/06/2002 10:23a3,447FrameworkUtilsTest.java4 File(s)10,410 bytesDirectory of com\agile\sandbox\pi\pm\validate05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a29,188AgileFieldsValidation.java05/06/2002 10:23a5,833AgileValidationBase.java05/06/2002 10:23a2,087CreateItemCheck.java05/06/2002 10:23a2,856CreateMfrCheck.java05/06/2002 10:23a2,864CreateMfrPartCheck.java05/06/2002 10:23a4,648DuplicateFindNumber.java05/06/2002 10:23a6,799DuplicatePartNumber.java05/06/2002 10:23a5,564DuplicateRefDes.java05/06/2002 10:23a5,827DuplicateVPN.java05/06/2002 10:23a3,811IdenticalParentChild.java05/06/2002 10:23a4,385InvalidQuantity.java05/06/2002 10:23a3,397ItemRevisionCheck.java05/06/2002 10:23a3,339MissingDescription.java05/06/2002 10:23a3,280MissingLevel.java05/06/2002 10:23a3,324MissingPartNumber.java05/06/2002 10:23a3,300MissingQuantity.java05/06/2002 10:23a3,276MissingRefDes.java05/06/2002 10:23a3,276MissingUOM.java05/06/2002 10:23a3,360MissingVendorName.java05/06/2002 10:23a3,385MissingVendorPartNumber.java05/06/2002 10:23a3,641MissingVendorPartPreferredStatus.java05/06/2002 10:23a3,540MissingVendorPartRemarks.java05/06/2002 10:23a3,521MissingVendorPartStatus.java05/06/2002 10:23a3,966MissingVendorStatus.java05/06/2002 10:23a3,622ModifyItemCheck.java05/06/2002 10:23a3,696ModifyMfrCheck.java05/06/2002 10:23a3,876ModifyMfrPartCheck.java05/06/2002 10:23a5,593MultDescription.java05/06/2002 10:23a1,906MultipleItemRevisions.java05/06/2002 10:23a10,817MultipleItemsPerMfrPartCheck.java05/06/2002 10:23a3,487PendingECOCheck.java05/06/2002 10:23a3,596PendingMCOCheck.java05/06/2002 10:23a8,786QtyRefDesMismatch.java05/06/2002 10:23a2,503RecursiveBOMCheck.java05/06/2002 10:23a2,772RedLineAMLOnPrelimItemCheck.java05/06/2002 10:23a2,924RedLineOnPrelimItemCheck.java05/06/2002 10:23a1,902SimpleSQLValidateAlgorithmBase.java05/06/2002 10:23a1,707SQLValidateAlgorithmBase.java05/06/2002 10:23a<DIR>test05/06/2002 10:23a4,236UnusualPartNumber.java05/06/2002 10:23a4,988UnusualVendorPartNumber.java05/06/2002 10:23a13,364Validate.java05/06/2002 10:23a14,052ValidateAlgorithmBase.java05/06/2002 10:23a803ValidateException.java43 File(s)213,097 bytesDirectory of com\agile\sandbox\pi\pm\validate\test05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a3,362AgileFieldsValidationTest.java05/06/2002 10:23a2,655ValidateTest.java2 File(s)6,017 bytesDirectory of com\agile\sandbox\pi\qa05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a<DIR>browser05/06/2002 10:23a<DIR>common05/06/2002 10:23a<DIR>eventhandlers05/06/2002 10:23a<DIR>events05/06/2002 10:23a<DIR>fma05/06/2002 10:23a<DIR>model05/06/2002 10:23a<DIR>pm05/06/2002 10:23a3,143QAAlgorithmBase.java05/06/2002 10:23a4,341QACheck.java05/06/2002 10:23a<DIR>system05/06/2002 10:23a<DIR>util2 File(s)7,484 bytesDirectory of com\agile\sandbox\pi\qa\browser05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,317BrowserVersion.java05/06/2002 10:23a1,096QABrowserBase.java2 File(s)5,413 bytesDirectory of com\agile\sandbox\pi\qa\common05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a696QAConstants.java1 File(s)696 bytesDirectory of com\agile\sandbox\pi\qa\eventhandlers05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a1,614CreateModuleEH.java05/06/2002 10:23a2,332ModuleTestEH.java2 File(s)3,946 bytesDirectory of com\agile\sandbox\pi\qa\events05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,360ModuleTestEvent.java1 File(s)2,360 bytesDirectory of com\agile\sandbox\pi\qa\fma05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,257LostPackage.java05/06/2002 10:23a707QAFmaBase.java05/06/2002 10:23a17,423UserRoleSync.java05/06/2002 10:23a7,564UserTailoredView.java4 File(s)27,951 bytesDirectory of com\agile\sandbox\pi\qa\model05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a17,468CreateModuleModel.java05/06/2002 10:23a15,792ModuleTestModel.java2 File(s)33,260 bytesDirectory of com\agile\sandbox\pi\qa\pm05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a8,784ParserRecognition.java05/06/2002 10:23a691QAPmBase.java2 File(s)9,475 bytesDirectory of com\agile\sandbox\pi\qa\system05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a2,104DBConnect.java05/06/2002 10:23a5,833DiskSpace.java05/06/2002 10:23a3,261DpstDtlsSequenceValue.java05/06/2002 10:23a2,966DpstSequenceValue.java05/06/2002 10:23a3,154GrDpstDtlsSequenceValue.java05/06/2002 10:23a2,842JREMemory.java05/06/2002 10:23a3,088PrcInstSequenceValue.java05/06/2002 10:23a913QASystemBase.java8 File(s)24,161 bytesDirectory of com\agile\sandbox\pi\qa\util05/06/2002 10:23a<DIR>.05/06/2002 10:23a<DIR>..05/06/2002 10:23a4,136QAParams.java1 File(s)4,136 bytesTotal Files Listed:1113 File(s)11,292,983 bytes308 Dir(s)3,413,372,928 bytes free

BACKGROUND OF THE INVENTION

[0004] Many systems rely on interpreting, parsing, and normalizing information from sources that have variable data patterns, formats, and notations for the information. In such cases, new programs have to be written on a case-by-case basis to interpret the information. Parsers, specific to the data patterns in the file, have to be written. In general cases, a new parser has to be written to interpret the same information if any aspect of the pattern is changed. For example, if the information in a new file is separated by a comma instead of a tab, a new parser will have to be written. In case of mission-critical business processes and system, this places a severe constraint and risk on the system. These modules are written in time constraints, hence the quality of the module is always of a concern. More importantly, these modules cannot even take a slight variation in the format (a new parser will have to be written). In addition, in a general case, human intervention is required to determine which module can interpret the given pattern of information. As a result, vast amount of resources are consumed. This is especially true for Enterprise Resource Planning (ERP) systems where a vendor has to accept Bill Of Materials (BOMS), which is an aggregation of part information, in multiple formats from different vendors. In such cases, processing the same information but in variable formats becomes a bottleneck in providing the service.

[0005] The manufacturing bill of material (BOM) files contains various information such as part number, revision, reference designator. Usually they are generated from computers. They come with various format, such as excel file, plain text file, pdf file, and xml file. These files can all be converted to plain text file. Further, these files also contains various discernible repeated structure. We call these structure as blocks. But different files from different sources may or may not have the same block structure. In order to process these files efficiently, we need to get pieces of information from these files, and save them into database. Current practice is to write a separate BOM parser for each new type of BOM file. This results in high cost of parser development and maintenance.

[0006] Thus, there is a need to automate the process to recognize, parse and normalize data pattern based information.

SUMMARY OF THE INVENTION

[0007] In the present invention, a method of recognizing and normalizing repeatable data pattern from a file using a computer executing a computer program comprises receiving the file. The program then recognizes the data pattern of the file based upon a profile selected from a plurality of profiles from a library. The file is parsed into a plurality of data fields based upon the profile selected. The parsed data is then stored in a database. The present invention also relates to an article of manufacturing comprising a computer usable medium having computer readable program code embodied therein configured to perform the foregoing described method. Finally, the present invention comprises a computer system with a computer and a computer program to execute the foregoing method.

[0008] The present invention also relates to a method of dynamically increasing the accuracy of recognizing and normalizing repeatable data pattern from a file using a computer executing a computer program. The file is received. The data pattern is recognized based upon a profile selected from a plurality of profiles from a library. The file is parsed into a plurality of data fields in the event the data pattern of the file is recognizable based upon the profile selected. In the event the computer program is unable to recognize the data pattern based upon any of the plurality of profiles from the library, then a user is notified. The computer program receives a new profile of the file into the library based upon manually inputted profile. The present invention also relates to an article of manufacturing comprising a computer usable medium having computer readable program code embodied therein configured to perform the foregoing described method. Finally, the present invention comprises a computer system with a computer and a computer program to execute the foregoing method.

BRIEF DESCRIPTION OF THE DRAWINGS

[0009]
FIG. 1 is a flow chart of the method of the present invention.

[0010]
FIG. 2 is an example of a first type of BOM file having data pattern information which the present invention is able to recognize and normalize.

[0011]

FIGS. 3

a
and 3b is an example of a second type of BOM file having data pattern information which the present invention is able to recognize and normalize.

[0012]

FIGS. 4

a
and 4b is an example of a third type of BOM file having data pattern information which the present invention is able to recognize and normalize.

[0013]
FIG. 5 is an enlarged view of a portion of the second type of BOM file shown in FIGS. 3a and 3b showing how the recognition and parsing portion of the method of the present invention operates.

[0014]
FIG. 6 is an example of a database with associated information for a particular profile to determine the location of the data pattern where the information can be extracted.

DETAILED DESCRIPTION OF THE INVENTION

[0015] Referring to FIG. 1 there is shown a flow chart 10 of the method of the present invention. In the preferred embodiment, the present invention is embodied as a computer program whose program files are set forth on a computer program listing appendix which is on a Compact Disc Recordable (CD-R) media which is incorporated by reference herein. The present invention is a method, as well as an article of manufacturing comprising a computer usable medium having computer readable program code embodied therein configured to perform the method. Finally, the present invention also comprises a computer system with a computer (not shown) and a computer program (as set forth in the CD-R) to execute the method.

[0016] In the preferred method of the present invention, a file, such as a Bill of Materials (BOM) file or an Approved Vendor List (AVL) file (also known as an Approved Manufacturer List (AML) file) is received, in block 12. All of these types of files are characterized by a data pattern having repeatable information. Collectively, hereinafter, all of these files will be referred to as BOM files. Further, because these BOM files are generated from different sources, e.g. sources using different computer programs, the type of file and the nature of the data pattern will differ. Thus, files can be generated as text files (with extension of TXT), or as spread sheet file (with extension of XLS) or Adobe Portable Document File (with extension of PDF), or HyperText Mark-up Language (with extension of HTML), the received BOM file is first converted into a TXT file, if needed. Further, even if files were generated with the same extension, the delimiter, or marker which separates the data pattern into repeatable sections may differ. Thus, one source may use a delimiter of a tab while another source may use a delimiter of a space with in an XLS file.

[0017] Referring to FIG. 2 there is shown a first example of a type of BOM file that is created by a first source, and can be processed by the present invention. In this example, the simplest example, the BOM file is in TXT or text format. Further, the BOM file begins with a header portion designated 20 which indicates the type of data which is repeated. The header is a portion of a characteristic of a file called a “profile”. Thus, the header 20 consists of ““Level”, “Parent”, “Parent Rev” etc. ending with “Vendor Part Number2”. Further, the delimiter is the symbol “|”. In this example, the data identified as “Part Number” is the fourth entry in the header field 20. For the data that corresponds to “Part Number”, these would be the data entries of “123” (2nd entry) in the first line after the header 20, “21TM7PA0042” in the second line after the header 20, and “31TM7 MB0014” in the third line after the header 20, etc.

[0018] Referring to FIG. 3(a&b), there is shown a second example of a type of BOM file that is created by a second source and which can be processed by the present invention. In the example shown in FIG. 3(a&b), the BOM file is in XLS or spread sheet format. The BOM file starts with a portion 30 which is not repeated data pattern, and is deemed “Junk”. The header 20 consists of “title” to the columns of data. In the example shown in FIG. 3(a&b), the spread sheet extends over 21 columns, starting with the column entitled “Component” (in FIG. 3a) and ending with the column entitled “Sole Source” (in FIG. 3b). Because this is an XLS file, the delimiter can be a tab, or any other character, depending upon how the file was created. The data pattern “fills” a number of rows. Thus, the first repeated data pattern fills 7 rows, while the second repeated data pattern fills 1 row. Each of such repeated data pattern is termed a “block”. Thus, a block is identified by coordinates, such as upper left column, lower left column, and number of columns.

[0019] Referring to FIG. 4(a&b), there is shown a third example of a type of BOM file that is created by a third source and which can be processed by the present invention. In the example shown in FIG. 4(a&b), the BOM file again is in TXT or text format. However, the BOM file, similar to the example shown in FIG. 3(a&b) begins with a large portion which is “junk” 30 and is not repeated data pattern. The header 20 comprises two nested headers 20a and 20b. Header 20a comprises the heading “Components” “Level1” “Item Seq” etc. This is repeated in FIGS. 4a and 4b. The header 20b is nested within the header 20a, and it comprises “Vendor Name”, “Vendor Item Number”, “Status”, and “Vendor Remarks.” The delimiter can be a space or a tab.

[0020] Referring back to FIG. 1, as previously stated, in the present invention the BOM file is first received by Block 12, and is converted into a TXT file, if needed by block 14, designated hereinafter as a “converted” BOM file.

[0021] The “converted” BOM file is then scanned to determine if the header 20 in the “converted” BOM file matches the header 20 from a library of profiles 16, by a recognition engine 18. This process is accomplished by attempting to match each of the headers 20 stored in the library 16 with the text scanned in the “converted” BOM file. Thus, for example, if the received file is the second example shown in FIG. 3(a&b), the recognition engine 18 retrieves each of the headers stored in the library 16 and compares the header from the library 16 with the header scanned by the engine to the second example. For example, one of the headers stored in the library 16 might be the header consisting of “Level|Parent|Parent Rev|Part Number . . . ” from the header shown in FIG. 2. This header is compared to the text from the “converted” BOM file to attempt to find a match. Clearly in this case, if the “converted” BOM file is the second example shown in FIG. 3(a&b), there would not be a match. Another header that might be stored in the library 16 is the header consisting of “Component” “Risk Ratio” “Lead Time” etc. Matching this header to the “converted” BOM file, one would find a match between the second example shown in the FIG. 3(a&b) and the header from the library 16.

[0022] Because initially the library 16 may have only a few well known and used headers, there is a good chance that there might not be a match between the header from the library 16 and the “converted” BOM file. In that event, there would be an inability by the recognition engine 18 to find a match between the header of the “converted” BOM file and any of the headers from the library 16. In the event the recognition engine 18 is unable to find a match at block 40, the administrator is notified at block 42 and is prompted to enter a new profile (which as will be explained, consists of header information and other information) which represents the profile of the “converted” BOM file. The new profile is entered into the library 16.

[0023] As can be seen by this method, as new headers are encountered which are not known from the library 16, by inputting and storing the new profiles into the library, the library and the program of the present method becomes more knowledgeable and intelligent. Thus, the method of the present invention is a neural engine that can process with increasing intelligence the more it is used.

[0024] Assuming now that the recognition engine 18 is able to find a match between the header from the library 16 and the header 20 of the “converted” BOM file, the profile associated with the header that is a match is retrieved from the library 16 and is used to parse the “converted” BOM file at block 44. Referring to FIG. 5, there is shown an enlarged view of a portion of the BOM file shown in FIG. 3a. The profile of the BOM file shown in FIG. 5 would indicate to the parser that the junk 30 consists of information in a block consisting of columns A-E and Rows 1-8. Further, the header is contained in row 9, and the delimiter is a tab.

[0025] The parsing engine parses the “converted” BOM file based upon the profile from the library 16 and populates the data so extracted into a database, such as any of the well known databases, such as Oracle, Access, etc. As used herein, the term “database” merely refers to data in a defined pattern, such that queries and sorts can be performed. It can be stored in a Hard Disc Drive (HDD) or it can exist temporarily in the memory of a computer. The parsing engine 44 consists of two parts: an exceptions classes parser 45a, and a generic parser 45b. The exceptions classes parser 45a receives the exceptions from the library of profiles 16 depending upon the profile selected. For example, one exception might be to replace all non-breaking spaces (ASCII code 160) by white spaces (ASCII code 32).

[0026] Referring to FIG. 6 there is shown an example of a portion of a profile to extract the “converted” BOM file shown in FIG. 5. In the entry designated “Rev:” shown in FIG. 6, the data is “8,1”. This indicates that the data for the “Rev” portion is found in column 8, and is in 1 row. Looking at FIG. 5, indeed one finds that the data for “Rev” is in column H or column 8, and is contained in one row. Similarly, the entry designated “Qty:” shown in FIG. 6 has the data of “7,1”. This indicates that the data for the “Qty” portion is found in column 7, and is in 1 row. Looking at FIG. 5, one finds that the data for “Qty” is in column G or column 7, and is contained in one row. As for the data for the “Part Number” which has the entry of “1,0,1”, the first “1” indicates that the data for the “Part Number” is found in column 1, or column A in FIG. 5. The “0” is the field or the amount of indent where the data begins. The final “1” indicates the number of rows. From the data shown in FIG. 6, the data from the “converted” BOM file is then extracted and placed into a database by block 46.

[0027] In the event the recognition engine 18 is unable to match the header from the library of profiles 16 with the header of the “converted” BOM file, the administrator must also input the profile information as exemplified by the data shown in FIG. 6. In addition, the administrator must enter the block information, i.e. the location of the boundaries for each block within a BOM file. Thus, the profile information consists of: header information; exceptions classes, if any; the location of data to be extracted, as exemplified by the table shown in FIG. 6; and the block information.

[0028] Once the data is placed in a database, it is “cleaned” if need be at block 48. By cleaning it is meant that certain unusual characters, such as apostrophe, semi-colon, dash, and space, are eliminated from the database. Thus, the program re-scans the data in the database to eliminate these characters.

[0029] Thereafter, the database is tested and validated in block 50. By testing and validation, it is meant that the database is tested so that it “makes sense”. For example, under the heading of “Qty” it is assumed that there must be a numerical entry. Further, the quantity cannot be an invalid amount, such as a very large number. Further, data for “Part Number” must be present. The absence of a “Part Number” data indicates an error. Other “common sense” or “reality checks” that can be tested include data entry for “Level”, “Description” and “Reference Designator”

[0030] Finally, in the event the result of testing validation of the database results in an error, then an error report is generated and the customer who generated the BOM file is notified at block 52.

[0031] The error report may also be used by the administrator to “correct” any of the profiles in the library 16.

[0032] It should be recognized that the present invention is not limited to the embodiment(s) described above and illustrated herein, but encompasses any and all variations falling within the scope of the appended claims.

Computer program method and apparatus to recognize and normalize data pattern based information

Information

Publication Number

Date Filed

Date Published

Inventors

CPC

US Classifications

International Classifications

Abstract

Description

Claims

Provisional Applications (1)