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.
weekly Electronic Catalog Update
CL program ECUWEEKLY 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.
- Command ECUFULLCAT calling auto run ‘ECUFULLCAT’ for each price list.
- Program ECRUP385 (ECU -- Generate and send full catalog files) calls ECCUP380 (ECU -- send change files to FTP server) for each catalogue built by ECUFULLCAT.
Detail Process
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 CHANGES FILE REGUL *ALL WEEKLYCAT ECRUP050 EXTR
120 CREATE WEEKLY PRICE CHANGES REGUL *ALL WEEKLYCAT ECRUP055 PRICH
130 CHECK FOR ANY TRANSMIT LIMITS 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 SH REGUL SHARE-BC WEEKLYCAT ECRUP700 TRANS
300 SEND OUT WEEKLY BC NS REGUL NON-SH-BC WEEKLYCAT ECRUP700 TRANS
320 SEND OUT WEEKLY AB SH REGUL SHARE-AB WEEKLYCAT ECRUP700 TRANS
340 SEND OUT WEEKLY AB NS 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 SH REGUL SHARE-YT WEEKLYCAT ECRUP700 TRANS
531 BUILD CHANGES FILE FOR WEB REGUL *ALL WEEKLYCAT ECRUP360 BASE
601 COPY CHG FILES TO FTP SERVER REGUL *ALL WEEKLYCAT ECCUP380 BASE
* END *
F21=Scrn Reset
F3=Exit F5=Refresh F6=Add F12=Previous F24=Scrn Save
Repeat for run 'ECUFULLCAT'.
3/16/16 12:33:25 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
ECUFULLCAT AND
Catalog Type/Sub Type
MA=Main CP=Copy PU=Purge RU=Runs
Step # and Description Type Sub Type RUN NAME PROGRAM STEP TYPE
10 CREATE WEEKLY CHANGES FILE REGUL *ALL ECUFULLCAT ECRUP050 EXTR
12 CREATE WEEKLY PRICE CHANGES REGUL *ALL ECUFULLCAT ECRUP055 PRICH
15 CREATE SHAREHOLDER PRICES FULL *RUN ECUFULLCAT ECRUP350 TFORM
25 SEND OUT TO INTERNAL MAIL LIST FULL *RUN ECUFULLCAT ECRUP700 TRANS
* END *
F21=Scrn Reset
F3=Exit F5=Refresh F6=Add F12=Previous F24=Scrn Save
Programs
ECRUP010 (ECU -- Generate regular base files)
- Read active items from the ASW files, write to ECUIBAP, then call ECRUP011. (Note that this uses the status field in SROPRG; perhaps it should use XXITEMP?)
ECRUP011 (ECU -- Generate base prices for base item)
- Read CCP files to calculate current prices, and write to ECUIBPP.
ECRUP050 (ECU -- Generate weekly regular changes file)
- Compare current week base file (ECUIBAP) to previous week's; and write differences to ECUCHGP.
ECRUP055 (ECU -- Generate weekly price changes file)
- Compare current week base prices file (ECUIBPP) to previous week's; and write differences to ECUCHPP.
ECRUP060 (ECU -- Defer records if transmit limit exceeded)
- The limit is currently 30,000 (set up in table UX ECUTRMLIMI); so this is unlikely to happen.
ECRUP350 (ECU -- Generate OMS data for a regular cat. chg)
- Read change files (ECUCHGP and ECUCHPP) and write to ECUOMHP and ECUOMDP.
ECRUP360 (ECU -- Generate item change file to display on WEB)
- Read base files (ECUIBAP and ECUIBPP) and change files (ECUCHGP and ECUCHPP), and write to ECUCHGLOG; which is used by the Web Orders program UW_CHG01 (Changed Item Inquiry).
ECCUP380 (ECU -- send change files to FTP server)
- sets up temporary input and output FTP files, then calls ECRUP380.
ECRUP380 ()
-
ECRUP385 ()
-
ECRUP700 (ECU -- Transmit or retransmit a transmission)
-
Files
- 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.