Send COOP Gazette messaging

[lmcclung]

TO DO:

Create FTP flat file similar to the existing one generated by home team.

• [ ] Work with David Roberts to capture what is in that flat file
• [ ] Registries entities team will replace the current cooperatives flat file with a new version with same file name and header information. Advise QP when this will happen.
• [ ] Once this is in place QP will process the first few files and share in test environment so Registries can verify information is correct.
• [ ] Add a job to the existing jobs that @stevenc987 has

Contacts:
David Roberts or Bob Bowles re current file Alex Strudwick - Queens Printer

[thorwolpert]

From David Roberts

Here are the formats for the 4 files we send for the Gazette. My goal was to make no changes from the Mainframe version so that QP would not have to make any changes. However, we could standardize the date format, corp_num format, lengths, padding etc.

Change of Name

  to_char(f.effective_dt,'MON dd, yyyy')

||';'

||decode(corp_typ_cd,'CP' ,'CP' ||substr(c.corp_num,6,4)||'    '

                    ,'XCP','XCP'||substr(c.corp_num,7,4)||'   ')

||';'

||rpad(substr(old.corp_nme,1,52),52)

||';'

||' to '

||';'

||rpad(substr(new.corp_nme,1,58),58)

Dissolution

  to_char(f.effective_dt,'yyyymmdd')

||';'

||decode(corp_typ_cd,'CP' ,'CP '||substr(c.corp_num,3,7)

                    ,'XCP','XCP'||substr(c.corp_num,4,7))

||';'

||rpad(n.corp_nme,150)

||';'

||decode(f.filing_typ_cd,'OTDIS','1'

                        ,'OTVLQ','2'

                        ,'OTVDS','3')

||rpad(' ',27)

Incorporation

  to_char(c.recognition_dts,'MON dd, yyyy')

||';'

||decode(corp_typ_cd,'CP' ,'CP' ||substr(c.corp_num,6,4)||'    '

                    ,'XCP','XCP'||substr(c.corp_num,7,4)||'   ')

||';'

||rpad(corp_nme,150)

||rpad(' ',59)

Restoration

  ' ' -- do we need this?

||to_char(f.effective_dt,'yyyymmdd')

||';'

||decode(corp_typ_cd,'CP' ,'CP    '||substr(c.corp_num,6,4)

                    ,'XCP','XCP   '||substr(c.corp_num,7,4))

||';'

||rpad(n.corp_nme,112)

[sienna-oldaccountdontuse]

@stevenc987 if you have any questions, please reach out to David Roberts. Also reach out to @pwei1018 for the FTP stuff (we already did that for the CAS implementation)

[lmcclung]

@stevenc987 how is this report coming along?

[stevenc987]

@lmcclung I have sent the public key to someone to implement it on drive.qp.gov.bc.ca. It was implemented. However, there is issue for communication between our site to the destination drive.qp.gov.bc.ca. It seems this is a public key setting or firewall issue. I am trying to figure it out.

[jinghualicgi]

@thorwolpert Can you please review the code for this? Thanks (PR#1330) CC: @pwei1018

[stevenc987]

@rarmitag @thorwolpert @lmcclung This was assigned to Thor for review. It seems he was busy. If you can help to review the codes, that would be great. Thank you!

[jinghualicgi]

Richard has reviewed, will move to test soon for QA Waiting Entities's QA to verify this @riyazuddinsyed CC: @lmcclung

[jdyck-fw]

QA completed - moving to ready for release in SRE

[jinghualicgi]

Thanks, we will discuss with Patrick for SRE's next release when he is back on Monday.

[stevenc987]

Just got an email from David Roberts that we need to update it to correspond with CP100 before we move it to production.

[lmcclung]

Existing coop file names: COOP_GAZETTE_INCORPORATION_20220111.TXT COOP_GAZETTE_RESTORATION_20210706.TXT COOP_GAZETTE_DISSOLUTION_20211130.TXT COOP_GAZETTE_CHANGEOFNAME_20211214.TXT

[lmcclung]

Discussed with Steven & David R.

Steven will

• [ ] change the names of the files he's created so that they match what is currently run in COLIN/CPRD.
• [ ] remove the benefit company type from this
• [ ] Stop work on this ticket

Decision (RAID board #51)

Because we are using the same file names but only have BC Coop data; not EP Coop data this will cause problems on the Queens Printer side. We will wait until we have EP Coops before we create a new ticket to leverage this work and create a CRON job and push to Production after testing.

[stevenc987]

The requirement on Jan 14, 2022 was implemented and the codes had been merged into github. We need to rebuild the image and create a cronjob when it is time for this project to run.

[jinghualicgi]

Any suggestions on this ticket? Can we close this one? @pwei1018 @stevenc987

[stevenc987]

@jinghualicgi @pwei1018 It seems Linda said this one needs to wait till some other tickets are done. Can you please confirm it with her?

[jinghualicgi]

@lmcclung @Mihai-QuickSilverDev Any comments on this ticket? Still some dependencies and we have to wait?

[jinghualicgi]

@lmcclung @Mihai-QuickSilverDev Any comments on this ticket? Still some dependencies and we have to wait?

[Mihai-QuickSilverDev]

Closing this ticket for now, as per this comment from Linda: I’ve decided to put the replacement on hold until we import Extraprovincial Cooperatives into our new database later this year.

Thanks for your help to date and your patience while we go through the bumps of modernization.

Linda McClung

[jinghualicgi]

@pwei1018 Do we want to add this in our coming release?