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.
ECU Calendar
Go to Unity / Start uniPharm Extensions / VA Company / UWD Extensions / ECU -- Catalog Update / ECRIQ010 -- Show Calendar.
3/16/16 16:11:10 uniPHARM -- PRODUCTION ECRIQ010/LISTCTL
ECU RUNNING ECU - Show Calendar Master File PRODUCTION 1.00
Display Order Field Test Values
DATEA DATE AND TIME A
Date Range Week Status AND
ST MAR 10 16 00 00 AND
Period
RH=Run History WK
MA=Main TR=Transmissions BA=Base File CH=Changes PR=Promo
Reference Week St Start/End Dates SCHED DATE PRICE DATE ADDED DATE
FU20160310 9725 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
FU20160310 9726 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
FU20160310 9727 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
FU20160310 9728 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
FU20160310 9729 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
FU20160310 9730 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
FU20160310 9731 FI MAR 10 16 DEC 31 50 MAR 10 16 MAR 11 16 MAR 10 16
MAR11 2016 1263 FI MAR 12 16 MAR 18 16 MAR 11 16 MAR 11 16 JUL 08 09
MAR18 2016 1264 NP MAR 19 16 MAR 25 16 MAR 18 16 MAR 18 16 JUL 08 09
MAR25 2016 1265 NP MAR 26 16 APR 1 16 MAR 25 16 MAR 25 16 JUL 08 09
APR01 2016 1266 NP APR 2 16 APR 8 16 APR 01 16 APR 01 16 JUL 08 09
APR08 2016 1267 NP APR 9 16 APR 15 16 APR 08 16 APR 08 16 JUL 08 09
APR15 2016 1268 NP APR 16 16 APR 22 16 APR 15 16 APR 15 16 JUL 08 09
F21=Scrn Reset
F3=Exit F5=Refresh F12=Previous F24=Scrn Save
This shows two things. Lines with a date formatted as MMMDD YYYY in the 'reference' column are prebuilt to control the 'change' files that are created every week. The 'Week' is the sequentially numbered week since the EOB started. The last line shows, for example, that a file will be built using prices as of April 15th, to be in effect April 16th to April 22nd. Although these dates are all Fridays, we actually build the files Thursday evenings (through the job scheduler), so they will be available no matter how early stores or POS vendors want them. When command ECUREGULAR is run, it uses the first calendar record at status 'NP - not processed' - not the entry for the actual date. Which means if it is not run at all, the entry will have to manually flagged as 'FI - Finished'. Or if runs twice, another entry will have to added.
When the command ECUFULLCAT is run, a record is added to this file, with a reference starting with 'FU', then the date formatted as YYYYMMDD. The 'week' number is a sequential number that started at 7000. Around December 2016 it should reach 10000. This should not be a problem as the field is 5 digits long; but the 'Show Calendar' programs only uses 4, so may not work correctly.
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 (ECU -- Generate chg or full catalog files for FTP)
- Reads ECUOMHP and ECUOMDP, then writes ECUFTP. Then FTP's to our mail server for stores or POS vendors to pick up.
ECRUP385 (ECU -- Generate and send full catalog files)
- Calls ECCUP380 for the latest full catalogue files created.
ECRUP700 (ECU -- Transmit or retransmit a transmission)
- Reads data from ECUOMHP and ECUOMDP and writes it to the OMS files (OMSMHDP, OMSLINP, OMSADRP, and OMSQUEP) to be emailed.
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 ECUCHGLOG (ECU -- Catalog Change Log File for Web Inquiry) contains all base and price changed, can be queried and displayed in Web Orders.
- 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 ECUFTP (ECU -- changes file to send to FTP server) temporary file of records to be FTP'ed.
- 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.
- File OMSADRP (OMS-Outbound Message Address File) the email address extracted from the catalogue distribution file, based on full or regular, and price list.
- File OMSLINP (OMS-Outbound Message Lines File)
- File OMSMHDP (OMS-Outbound Message Header File)
- File OMSQUEP (OMS-Outbound Message Queue File) contains the status of the OMS email.