ETL Manager : Location Data


Populating Location Database: Please wait....

    Preparing Data for Location Database
    --------------------------------------
    Loading data from forecast database....Successfull!

    1. Line item # 011303A-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 6, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 6, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    011303A-THD, added to location database.
    011303A-THD, already fulfilled. Part Removed. 2. Line item # 10MQS8Q000-ULTA Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 4, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 4, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    10MQS8Q000-ULTA, added to location database.
    10MQS8Q000-ULTA, already fulfilled. Part Removed. 3. Line item # 210-ACLJ-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 7, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 7, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    210-ACLJ-THD, added to location database.
    210-ACLJ-THD, already fulfilled. Part Removed. 4. Line item # 210-AFLX-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For HOLD : Good = 0, Rsvd = 0, Hold = 1, Bad = 0.
    For GOOD : Good = 3, Rsvd = 0, Hold = 1 , Bad = 0.
    TOTAL: GOOD:= 3, BAD= 0, HOLD= 1, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    210-AFLX-THD, added to location database.
    210-AFLX-THD, already fulfilled. Part Removed. 5. Line item # 210-AKMX-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 4, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 4, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    210-AKMX-THD, added to location database.
    210-AKMX-THD, already fulfilled. Part Removed. 6. Line item # 210-APOL-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For HOLD : Good = 0, Rsvd = 0, Hold = 1, Bad = 0.
    TOTAL: GOOD:= 0, BAD= 0, HOLD= 1, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    210-APOL-THD, added to location database.
    210-APOL-THD, already fulfilled. Part Removed. 7. Line item # 210-ASEV-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 1, Rsvd = 1, Hold = 0 , Bad = 0.
    For UPLIFT : Good = 0, Rsvd = 0, Hold = 0 , Bad = 2, MNUPLIFT = 2, Bad = 2.
    TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 2... Done.
    210-ASEV-THD, added to location database.
    210-ASEV-THD, already fulfilled. Part Removed. 8. Line item # 210-AVLS-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 1.
    For HOLD : Good = 0, Rsvd = 0, Hold = 6, Bad = 1.
    TOTAL: GOOD:= 0, BAD= 1, HOLD= 6, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    210-AVLS-THD, added to location database.
    210-AVLS-THD, already fulfilled. Part Removed. 9. Line item # 2KK103-003 Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 2.
    For HOLD : Good = 0, Rsvd = 0, Hold = 1, Bad = 2.
    For WARR : Good = 0, Rsvd = 0, MNWR = 16, Bad = 2.
    For GOOD : Good = 32, Rsvd = 0, Hold = 1 , Bad = 0.
    TOTAL: GOOD:= 32, BAD= 2, HOLD= 1, MNWR= 16, MNSCRAP= 0, MNUPLIFT= 0... Done.
    2KK103-003, added to location database.
    2KK103-003, already fulfilled. Part Removed. 10. Line item # BMO-E285-REV2 Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For WARR : Good = 0, Rsvd = 0, MNWR = 1, Bad = 0.
    For SCRAP : Good = 0, Rsvd = 0, Hold = 0 , Bad = 1, MNSCRAP = 1, Bad = 1.
    TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 1, MNSCRAP= 1, MNUPLIFT= 0... Done.
    BMO-E285-REV2, added to location database.
    BMO-E285-REV2, already fulfilled. Part Removed. 11. Line item # CITI-BR-IM1600 Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part....Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 7.
    For HOLD : Good = 0, Rsvd = 0, Hold = 2, Bad = 7.
    For GOOD : Good = 29, Rsvd = 0, Hold = 2 , Bad = 0.
    TOTAL: GOOD:= 29, BAD= 7, HOLD= 2, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    CITI-BR-IM1600, added to location database.
    CITI-BR-IM1600, already fulfilled. Part Removed. 12. Line item # KIT-R540CCTV-THD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For HOLD : Good = 0, Rsvd = 0, Hold = 1, Bad = 0.
    For GOOD : Good = 2, Rsvd = 0, Hold = 1 , Bad = 0.
    TOTAL: GOOD:= 2, BAD= 0, HOLD= 1, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    KIT-R540CCTV-THD, added to location database.
    KIT-R540CCTV-THD, already fulfilled. Part Removed. 13. Line item # M51J7 Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part....Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part.TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    M51J7, added to location database.
    M51J7, already fulfilled. Part Removed. 14. Line item # MD88F Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part....Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part.TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    MD88F, added to location database.
    MD88F, already fulfilled. Part Removed. 15. Line item # THD-210-AYVV Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part.TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    THD-210-AYVV, added to location database.
    THD-210-AYVV, already fulfilled. Part Removed. 16. Line item # THD-210-BKVZ Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part....Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 1, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 1, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    THD-210-BKVZ, added to location database.
    THD-210-BKVZ, already fulfilled. Part Removed. 17. Line item # TS-432PXU-2G-US Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 8, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 8, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    TS-432PXU-2G-US, added to location database.
    TS-432PXU-2G-US, already fulfilled. Part Removed. 18. Line item # WD-42C0060 Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part....Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part.TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-42C0060, added to location database.
    WD-42C0060, already fulfilled. Part Removed. 19. Line item # WD-4800-784-8G Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 10.
    For GOOD : Good = 99, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 99, BAD= 10, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-4800-784-8G, added to location database.
    WD-4800-784-8G, already fulfilled. Part Removed. 20. Line item # WD-90ACC0213 Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For GOOD : Good = 34, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 34, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-90ACC0213, added to location database.
    WD-90ACC0213, already fulfilled. Part Removed. 21. Line item # WD-9800IFE Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part.......Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For REPAIR : Good = 0, Rsvd = 0, Hold = 0 , Bad = 5.
    For GOOD : Good = 20, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 20, BAD= 5, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-9800IFE, added to location database.
    WD-9800IFE, already fulfilled. Part Removed. 22. Line item # WD-IBM-4800-C84-8G-SSD Fetching records and preparing data from forecast DB for Location....Done. Loading data from parts database....Done.
    Fetching and Assigning tech for the part..........Done. Loading data from inventory database....Done. Fetching and assigning data from inventory for the part. For BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 4.
    For GOOD : Good = 27, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 27, BAD= 4, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-IBM-4800-C84-8G-SSD, added to location database.
    WD-IBM-4800-C84-8G-SSD, already fulfilled. Part Removed.

    Location Database Updated!!



    NEXT STEP: Generate Location File


Notes

    If this step is unsuccessfull, please go to STEP1 and follow the instructions below:
  • Go to Clarify and export inventory file, then rename both FILENAME and SHEETNAME to "inventory", i.e, inventory.xlsx . This file must contain complete list of all good, bad and onhold inventory.
  • Download daily washburn forecast file you receive in your email from compucom, then rename both forecast FILENAME and SHEETNAME to "forecast". i.e, forecast.xlsx
  • Once renamed, you can drag & drop files from your computer in Step # 1.
  • Once you are done uploading the files, please go to the next step.

© Washburn Group

Developped by Shumon Anowar

© 2015 Washburn Computer Group