ETL Manager : Location Data


Populating Location Database: Please wait....

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

    1. 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 UPLIFT : Good = 0, Rsvd = 0, Hold = 0 , Bad = 4, MNUPLIFT = 4, Bad = 5.
    For HOLD : Good = 0, Rsvd = 0, Hold = 4, Bad = 5.
    TOTAL: GOOD:= 0, BAD= 1, HOLD= 4, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 4... Done.
    210-AVLS-THD, added to location database.
    210-AVLS-THD, already fulfilled. Part Removed. 2. 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 = 15.
    For GOOD : Good = 10, Rsvd = 0, Hold = 0 , Bad = 0.
    For WARR : Good = 0, Rsvd = 0, MNWR = 45, Bad = 15.
    For SCRAP : Good = 0, Rsvd = 0, Hold = 0 , Bad = 2, MNSCRAP = 2, Bad = 17.
    For HOLD : Good = 0, Rsvd = 0, Hold = 5, Bad = 17.
    TOTAL: GOOD:= 10, BAD= 15, HOLD= 5, MNWR= 45, MNSCRAP= 2, MNUPLIFT= 0... Done.
    2KK103-003, added to location database.
    2KK103-003, already fulfilled. Part Removed. 3. 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.
    TOTAL: GOOD:= 0, BAD= 0, HOLD= 0, MNWR= 1, MNSCRAP= 0, MNUPLIFT= 0... Done.
    BMO-E285-REV2, added to location database.
    BMO-E285-REV2, already fulfilled. Part Removed. 4. 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 GOOD : Good = 2, Rsvd = 0, Hold = 0 , Bad = 0.
    For HOLD : Good = 0, Rsvd = 0, Hold = 2, Bad = 0.
    TOTAL: GOOD:= 2, BAD= 0, HOLD= 2, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    CITI-BR-IM1600, added to location database.
    CITI-BR-IM1600, already fulfilled. Part Removed. 5. 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. 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-AYVV, added to location database.
    THD-210-AYVV, already fulfilled. Part Removed. 6. 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 BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 2.
    For HOLD : Good = 0, Rsvd = 0, Hold = 3, Bad = 2.
    TOTAL: GOOD:= 0, BAD= 2, HOLD= 3, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    TS-432PXU-2G-US, added to location database.
    TS-432PXU-2G-US, already fulfilled. Part Removed. 7. 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 = 7.
    For GOOD : Good = 141, Rsvd = 1, Hold = 0 , Bad = 0.
    For HOLD : Good = 0, Rsvd = 0, Hold = 1, Bad = 7.
    TOTAL: GOOD:= 140, BAD= 7, HOLD= 1, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-4800-784-8G, added to location database.
    WD-4800-784-8G, already fulfilled. Part Removed. 8. 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 BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 6.
    For GOOD : Good = 28, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 28, BAD= 6, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-90ACC0213, added to location database.
    WD-90ACC0213, already fulfilled. Part Removed. 9. 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 BAD : Good = 0, Rsvd = 0, Hold = 0 , Bad = 1.
    For GOOD : Good = 36, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 36, BAD= 1, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-9800IFE, added to location database.
    WD-9800IFE, already fulfilled. Part Removed. 10. Line item # WD-CISCO2960-24TTL-SER 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 = 12, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 12, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-CISCO2960-24TTL-SER, added to location database.
    WD-CISCO2960-24TTL-SER, already fulfilled. Part Removed. 11. 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 = 1.
    For GOOD : Good = 19, Rsvd = 1, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 18, BAD= 1, 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. 12. Line item # WD-WS-C2960X-24PS-L-SER 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 = 20, Rsvd = 0, Hold = 0 , Bad = 0.
    TOTAL: GOOD:= 20, BAD= 0, HOLD= 0, MNWR= 0, MNSCRAP= 0, MNUPLIFT= 0... Done.
    WD-WS-C2960X-24PS-L-SER, added to location database.
    WD-WS-C2960X-24PS-L-SER, 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