1 / 10

Equipment

Equipment. BRIEF. Edited by COSCON BPS. Using Excel file submit EQP Event. Using Excel file submit EQP Event.

willa-mack
Download Presentation

Equipment

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Equipment BRIEF Edited by COSCON BPS

  2. Using Excel file submit EQP Event

  3. Using Excel file submit EQP Event Besides using the above functions, user can download a specially prepared excel file ( with macro ) to submit EQP event to Sybase. The download file can be assessed from the IEM main menu too.

  4. Using Excel file submit EQP Event • User need to have the following minimum • Hard/Software Requirement: 1.PC connected to Internet 2.Window 95 or above 3.Excel 95 or above 4.Internet Explore 4.0 or above

  5. IEM pull down menu locate next to Help menu 1 • This is the excel file layout user will see. • It is divided into 4 major part: • IEM pull down menu • User logon details • Row of input event • Action buttons Introduce Excel Marco File 2 4 3 3

  6. IEM pull down menu: • User need to enter at least his/her belonging facility code and press tab to activate the IEM pull • Down menu. • Go to IEM pull down menu and four functions are show, they are: • Creation / Termination • Container Movement • Stuff / Devan / Repack • Change Status 2 1 We will go through each of these four function one by one. Introduce IEM Pull Down Menu

  7. IEM Event Table

  8. Using Excel file submit EQP Event ---Submit event(s) to Sybase Before submission, user need to input facility code, login ID and password. For internal user, user need to input his/her email ID. For submit is by batch format of batch size of 20 event each time. 2.Submission is done by clicking the submit button. The status of the submitted event(s) will change to successful in case of successful submission. However, if the event fail for data validation, a error message will be returned.3. So, user is advised to use Data Validation first before Submission. 2 1 3

  9. Using Excel file submit EQP Event ---Submit event(s) to Sybase 4. User should be careful that not to mis-click the clear button. After a confirmation window for clear, all selected rows of event will be cleared without Undo. In this case, user need to re-do all event(s) again.5. User may also use the “Import File” function for huge amount of events. Details of input field specification please refer to separate sheet. 5 4

  10. - END -

More Related