Information Systems:ECU - Electronic Catalog Update
uniPHARM used to supply a PC program called EOB (Electronic Order Book) to customers. Every week, ECU would build a file of changes to the item master file (one for each price list, as the prices would be different for each), and email them to ?. We no longer have the EOB, but we continue building change files and full catalogues every week for the POS systems, and for Web Orders.
CL program ECUWEEKLY (weekly Electronic Catalog Update) runs from the Job Scheduler every Thursday at 9:30PM. It runs –
- Command ECUREGULAR calling auto run ‘WEEKLYCAT’. It builds a file of changes the item file in the last week, for each price list (because they will each have different prices). These files are emailed to pre-set addresses, and sent to our FTP server. It also builds a change file that can be accessed by Web Orders.
To see the details, go to Unity / Start uniPharm Extensions / VA Company / UWD Extensions / ECU -- Catalog Update / ECRIQ030 -- Show Auto Run Records.
3/16/16 11:53:08 uniPHARM -- PRODUCTION ECRIQ030/LISTCTL
ECU RUNNING ECU - Show Auto Run Master Records PRODUCTION 1.00
Display Order Field Test Values
NAME By Auto Run Nam
AND
AND
Date Range Status Timing
AD 00 00 00 00
MA=Main CP=Copy ST=Steps RU=Runs EX=Execute PU=Purge
Run Name and Description Ti PROGRAM START DATE END DATE
__ ECUFULLCAT FULL CATALOG -- SPECIAL RUN OR ECREX001 JAN 01 04 DEC 31 50
__ ECUPARTCAT PARTIAL CATALOG -- SPECIAL OR ECREX001 JAN 01 04 DEC 31 50
__ PROMONITE NIGHTLY PROMO EXTRACTS DY ECREX002 JAN 01 04 DEC 31 50
ST WEEKLYCAT WEEKLY CATALOG WK ECREX001 JAN 01 04 DEC 31 50
F21=Scrn Reset
F3=Exit F5=Refresh F6=Add F12=Previous F24=Scrn Save
Use option ST=Steps on run 'WEEKLYCAT'. You will have to page down to see all the steps.
3/16/16 11:59:15 uniPHARM -- PRODUCTION ECRIQ040/LISTCTL
ECU RUNNING ECU - Show Auto Run Steps PRODUCTION 1.00
Display Order Field Test Values
NASTP Name, Step #
Limit to: Name Type Status AND
WEEKLYCAT AND
Catalog Type/Sub Type
MA=Main CP=Copy PU=Purge RU=Runs
Step # and Description Type Sub Type RUN NAME PROGRAM STEP TYPE
100 CREATE BASE FILE REGUL *ALL WEEKLYCAT ECRUP010 BASE
101 CREATE WEEKLY CHANGE REGUL *ALL WEEKLYCAT ECRUP050 EXTR
120 CREATE WEEKLY PRICE REGUL *ALL WEEKLYCAT ECRUP055 PRICH
130 CHECK FOR ANY TRANSM REGUL *ALL WEEKLYCAT ECRUP060 TSIZE
150 CREATE BC SH PRICES REGUL SHARE-BC WEEKLYCAT ECRUP350 TFORM
200 CREATE BC NS PRICES REGUL NON-SH-BC WEEKLYCAT ECRUP350 TFORM
210 CREATE AB SH PRICES REGUL SHARE-AB WEEKLYCAT ECRUP350 TFORM
220 CREATE AB NS PRICES REGUL NON-SH-AB WEEKLYCAT ECRUP350 TFORM
225 CREATE PSC PRICES REGUL SHARE-PSC WEEKLYCAT ECRUP350 TFORM
230 CREATE PSC1 PRICES REGUL SHARE-PSC1 WEEKLYCAT ECRUP350 TFORM
235 CREATE YT SH PRICES REGUL SHARE-YT WEEKLYCAT ECRUP350 TFORM
250 SEND OUT WEEKLY BC S REGUL SHARE-BC WEEKLYCAT ECRUP700 TRANS
300 SEND OUT WEEKLY BC N REGUL NON-SH-BC WEEKLYCAT ECRUP700 TRANS
320 SEND OUT WEEKLY AB S REGUL SHARE-AB WEEKLYCAT ECRUP700 TRANS
340 SEND OUT WEEKLY AB N REGUL NON-SH-AB WEEKLYCAT ECRUP700 TRANS
350 SEND OUT WEEKLY PSC REGUL SHARE-PSC WEEKLYCAT ECRUP700 TRANS
360 SEND OUT WEEKLY PSC1 REGUL SHARE-PSC1 WEEKLYCAT ECRUP700 TRANS
370 SEND OUT WEEKLY YT S REGUL SHARE-YT WEEKLYCAT ECRUP700 TRANS
531 BUILD CHANGES FILE F REGUL *ALL WEEKLYCAT ECRUP360 BASE
601 COPY CHG FILES TO FT REGUL *ALL WEEKLYCAT ECCUP380 BASE
* END *
F21=Scrn Reset
F3=Exit F5=Refresh F6=Add F12=Previous F24=Scrn Save
- Command ECUFULLCAT calling auto run ‘ECUFULLCAT’ for each price list.
- Program ECRUP385 (ECU -- Generate and send full catalog files) calls ECCUP380 for each catalogue built by ECUFULLCAT. ECCUP380 send these catalogues to the FTP server.
- File ECUIBAP (ECU -- Item Base File) contains all the fields (except prices) included in the catalogue and change files, for every week this is run.
- File ECUIBPP (ECU -- Item Base Price File) contains all the item prices for every week this is run.
- File ECUCHGP (ECU -- Catalog Changes File) contains all the items that have had any changes in ECUIBAP, from one week to the next.
- File ECUCHPP (ECU -- Catalog Price Changes File) contains all the items that have had any changes in ECUIBPP, from one week to the next.
- File ECUOMDP (ECU -- Message Lines File) are the change and full catalogue files reformatted.
- File ECUOMHP (ECU -- Message Headers) header for each change and full catalogue file that has been add to ECUOMDP.
ECRUP050 () - compare current week base file to previous week's; and write differences to ECUCHGP.
WCRUP350 () - read changes file and write to ECUOMHP () and ECUOMDP ().