Ga naar hoofdinhoud

Migrate from 1.7.1 to v1.8.0

Samenvatting​

Stappen om een module te upgraden van 1.7.1 naar 1.8.0 of hoger

  1. Eventueel: in database in tabel jnxt_modules hernoem module naar nieuwe naam van de module
  2. In module: Tenant Settings instellen
  3. In module: List Settings:
    1. group by van 1 naar 0
    2. Enable list info: Ja
    3. Enable responsive table: Ja
  4. Eventueel: Elements:
    1. Voeg tenant_id toe als 'tenant'
    2. Verander id van 'number' naar 'ID'
    3. Verander created_by van 'number' naar 'created_by'
    4. Verander modified_by van 'number' naar 'modified_by'

Welke sites moeten worden geüpdatet?​

tenant_id tenant_name database

49632062 Stichting Jos Moubis moubis_prod_j4 93765032 Vereniging van aannemers in de petrochemie vap_prod_j4 56306620 Jobmanager - SAB job_sab_prod_j4 76328700 Oudheidkundige kring De Vier Ambachten vierambachten_dev_j4 67802654 Kari's Crackers karis_dev_j4

job_sab_prod_j4 en vierambachten_dev_j4 hanteren al de goede database: ib_dev_j4.

VAP​

Daar zijn maar 7 IB-modules actief van vier modellen:

  • Organisaties
  • Personen
  • Landen
  • Lidmaatschappen

Implement xml-views​

Vijf views:

  • xml_v01_edi_template_categories
  • xml_v01_wfm_item_types
  • xml_v01_wfm_item_subtypes
  • xml_v01_wfm_process_processes
  • xml_v01_wfm_process_states

xml_v01_edi_template_categories​

SELECT * FROM jnxt_jne_edi_template_categories e

Tabel jnxt_jne_edi_template_categories moet aanwezig zijn. Deze is alleen aanwezig in database ib_dev_j4. Hoeft dus niet te worden gesynct.

Status: klaar

xml_v01_wfm_item_types​

SELECT * FROM jnxt_jne_wfm_item_types it

Deze tabel is geschikt om te worden gesyncd over de relevante db's.

Status: in beeld gebracht welke types hernummerd moeten worden.

xml_v01_wfm_item_subtypes​

SELECT ist.id AS id, ist.tenant_id AS tenant_id, ist.item_type_id AS item_type_id, it.item_type_name_nl_NL AS item_type_name_nl_NL, ist.item_subtype_name_nl_NL AS item_subtype_name_nl_NL, CONCAT(it.item_type_name_nl_NL, ' - ', ist.item_subtype_name_nl_NL, ' - ', ist.id) AS id_item_subtype_name_nl_NL, ist.object_status_id AS object_status_id, os.gen_object_status_active_nl_NL AS gen_object_status_active_nl_NL FROM ((jnxt_jne_wfm_item_subtypes ist JOIN jnxt_jne_gen_object_statuses os ON ((os.gen_object_status_value = ist.object_status_id))) JOIN jnxt_jne_wfm_item_types it ON ((it.id = ist.item_type_id))) ORDER BY ist.item_type_id , ist.ordering

xml_v01_wfm_process_processes​

SELECT * FROM jnxt_jne_wfm_process_processes p

Deze tabel is geschikt om te worden gesyncd over de relevante db's.

xml_v01_wfm_process_states​

SELECT ps.id AS id, ps.tenant_id AS tenant_id, pso.ordering AS ordering, ps.process_id AS process_id, pp.process AS process, pp.process_nl_NL AS process_nl_NL, pp.process_owner_id AS process_owner_id, u.name AS process_owner_name, pp.object_status_id AS process_object_status_id, ps.process_state_option_id AS process_state_option_id, pso.process_state_option AS process_state_option, pso.process_state_option_nl_NL AS process_state_option_nl_NL, CONCAT(pp.process_nl_NL, ' - ', pso.process_state_option_nl_NL) AS process_process_state_option_nl_NL, ps.object_status_id AS object_status_id, os.gen_object_status_active AS gen_object_status_active, os.gen_object_status_active_nl_NL AS gen_object_status_active_nl_NL FROM ((((jnxt_jne_wfm_process_states ps JOIN jnxt_jne_wfm_process_state_options pso ON ((pso.id = ps.process_state_option_id))) JOIN jnxt_jne_wfm_process_processes pp ON ((pp.id = ps.process_id))) JOIN jnxt_jne_gen_object_statuses os ON ((os.object_status_id = ps.object_status_id))) JOIN jnxt_users u ON ((u.id = pp.process_owner_id))) ORDER BY pp.process_nl_NL , ps.ordering

Complex:

  • Veel tabellen die een soort van in-sync moeten zijn.
  • jnxt_users: vraagt om filter op tenant_id.

call ib_dev_j4.ten_v01_update_tenant_id_in_table('karis_dev_j4', 'jnxt_jne_org_salesfunnel_status'); call ib_dev_j4.ten_v01_update_tenant_id_in_table('moubis_prod_j4', 'jnxt_jne_org_salesfunnel_status'); call ib_dev_j4.ten_v01_update_tenant_id_in_table('vap_prod_j4', 'jnxt_jne_org_salesfunnel_status');

Aanpassingen instellingen IB​

Noodzakelijk​