Introduction

The EZ DR Importer (Data Report Importer), can be used at any time to import Data Reports into the EZ-MES Application. 

Installation and Source Code

ClickOnce Installation is used to install the executable onto your computer. 

Installation Link

Source Code is downloadable via our Repository.  A username and password is required to access this.  It is available by request only.  

Source Code Link

Importable Attributes

For the most part, any attribute that is contained on our Data Report form can be imported from within the DR Importer Application.  As of now, the current set of importable attributes are as follows:

• "Name" (sDRName)
• "Rev" (sDRRev)
• "Number" (sDRNumber)
• "Description" (sDRDescr)
• "Type" (sDRType)
• "Status" (CurrentStatus)
• "User" (Initiator)
• "Category" (sDRCG)
• "SetReportDefaultsYN" (sDRbDefault)
•  
• "Report23ClearCacheYN" (sDR23bClearCache)
• "Report23ShowPartDataYN" (sDR23bShowPartData)
• "Report23DetailsRepeatYN" (sDR23bDetailsRepeat)
• "Report23ShowPartsYN" (sDR23bShowParts)
• "Report23RecordsInfoYN" (sDR23bRecordsInfo)
• "Report23ConfigInfoYN" (sDR23bConfigInfo)
• "Report23StepHeadersYN" (sDR23bStepHeaders)
• "Report23CreateInfoYN" (sDR23bCreateInfo)
• "Report23ShowStatsYN" (sDR23bShowStats)
• "Report23ShowAllStepBlocksYN" (sDR23bShowAllStepBlocks)
• "Report23ReverseStepsYN" (sDR23bReverseSteps)
• "Report23ReverseStepBlocksYN" (sDR23bReverseStepBlocks)
• "Report23CompressedStepBlocksYN" (sDR23bCompressedStepBlocks)
• "Report23LongBarCodeYN" (sDR23bLongBarCode)
• "Report23NVValueWidth" (sDR23iNVValueWidth)
•  
• "Report24DetailsRepeatYN" (sDR24bDetailsRepeat)
• "Report24ConfigInfoYN" (sDR24bConfigInfo)
• "Report24ShowArNVYN" (sDR24bShowArNV)
• "Report24ShowArSDDescrYN" (sDR24bShowArSDDescr)
• "Report24ShowArEquipmentNVYN" (sDR24bShowArEquipmentNV)
• "Report24ShowArDCYN" (sDR24bShowArDC)
• "Report24HierarchyYN" (sDR24bHierarchy)
• "Report24StepHeadersYN" (sDR24bStepHeaders)
• "Report24IOsYN" (sDR24bIOs)
• "Report24VPGoal" (sDR24VPGoal)
•  
• "Report25DetailsRepeatYN" (sDR25bDetailsRepeat)
• "Report25ShowCostYN" (sDR25bShowCost)
• "Report25ShowItemCommentsYN" (sDR25bShowItemComments)
•  
• "Report26SortBy" (sDR26SortBy)
• "Report26TotalBy" (sDR26TotalBy)
• "Report26InputDate" (sDR26iInputDate)
• "Report26ShowEmptyPartsYN" (sDR26bShowEmptyParts)
• "Report26ShowPartsYN" (sDR26bShowParts)
• "Report26HideArchDelPDPartsYN" (sDR26bHideArchDelPDParts)
•  
• "Report27RequestInformationYN" (sDR27bRequestInformation)
• "Report27DisplayBarcodesYN" (sDR27bDisplayBarcodes)
• "Report27ApprovalDocumentYN" (sDR27bApprovalDocument)
• "Report27ReadyPackColumnsYN" (sDR27bReadyPackColumns)
• "Report27WOInfoYN" (sDR27bWOInfo)
•  
• "Report28Start" (sDR28iStart)
• "Report28End" (sDR28iEnd)
• "Report28Span" (sDR28Span)
• "Report28FDSelect" (sDR28FDSelect)
• "Report28GroupBy" (sDR28GroupBy)
• "Report28Outs" (sDR28Outs)
• "Report28ShowPartUIDYN" (sDR28bPR)
•  
• "Report29ClearCacheYN" (sDR29bClearCache)
• "Report29DetailsRepeatYN" (sDR29bDetailsRepeat)
• "Report29ShowBlogsYN" (sDR29bShowBlogs)
• "Report29ShowParentsYN" (sDR29bShowParents)
• "Report29AllStepsYN" (sDR29bAllSteps)
• "Report29ShowAllStepBlocksYN" (sDR29bShowAllStepBlocks)
• "Report29CompressedStepBlocksYN" (sDR29bCompressedStepBlocks)
• "Report29ReverseStepsYN" (sDR29bReverseSteps)
• "Report29ReverseStepBlocksYN" (sDR29bReverseStepBlocks)
• "Report29ShowGenealogyYN" (sDR29bShowGenealogy)
•  
• "Report30FDSelect" (sDR30FD)
• "Report30GroupBy" (sDR30GroupBy)
• "Report30ShowPartUIDYN" (sDR30bPR)
• "Report30ShowObjPrefixYN" (sDR30bShowPrefix)
• "Report30JSONInput" (sDR30JSONInput)
•  
• "Report32Start" (sDR32iStart)
• "Report32End" (sDR32iEnd)
• "Report32Span" (sDR32Span)
• "Report32Action" (sDR32Action)
• "Report32ObjType" (sDR32ObjType)
• "Report32RepeatHeaderYN" (sDR32bRepeatHeader)
•  
• "Report33Start" (sDR33iStart)
• "Report33End" (sDR33iEnd)
• "Report33Span" (sDR33Span)
• "Report33PDSelect" (sDR33PDSelect)
• "Report33LCSelect" (sDR33LCSelect)
•  
• "Report34JSONInput" (sDR34JSONInput)
•  
• "Report35Start" (sDR35iStart)
• "Report35End" (sDR35iEnd)
• "Report35Span" (sDR35Span)
• "Report35ShowPartUIDYNN" (sDR35bPR)
• "Report35ReportType" (sDR35ReportType)
•  
• "Report36JSONInput" (sDR36JSONInput)

Keys During Import

sDRNumber and sSDRev are the keys

Settings Configuration

After the clickOnce installation is complete you will need to configure the Settings.  To access Settings go to >File, >Settings

• Soap User: This is the Username you use to log into EZ-MES
• Soap Key: This is the Passkey that is generated within EZ-MES.  If you dont have one: Generate a New PassKey
• Web-Service URL: This is the URL used to access EZ-MES.  You will need to add the '/eazywebservice.asmx' at the end.  

Use the Test Passkey button on the upper left to verify your settings are configured correctly.  After the settings are completed successfully close this form.  You should not have to re-enter this for future uses.

DR Importer Usage

After you have completed the settings you can now begin importing your Data Report contained in your Excel File.  See our sample Excel File that demonstrates how it can look.  Your excel file can vary with the column headers because you will be required to match them up to the EZ-MES Attributes after you import the file.

Selecting file

Click the Excel Icon to Choose the file.

Matching Column Headers

 After the file is selected and imported, you will now be tasked with matching up the Colums in Excel to the EZ-MES Attribute.  

Noticed my example has a Column that is irrelevant to EZ-MES.  This is okay, but I must select 'Ignore' from the pulldown.  Any blank fields will not allow for execution of the import.

Execution of Import

After the file is selected and you have the Column Headers matched up, the Execution Icon will become active.  You can now use it to run the import.  

Messages will be displayed in the Status Window.  If the import is successful, you should now log into your application and verify the results.  

EZ DR Importer Icons.

Although these are subject to change, the goal will be to keep them intuitive.