QFQ Merge » History » Version 7
Enis Nuredini, 24.06.2024 14:27
1 | 1 | Enis Nuredini | h1. QFQ Merge |
---|---|---|---|
2 | |||
3 | {{toc}} |
||
4 | |||
5 | h2. Installation |
||
6 | |||
7 | QFQ Merge feature should be installed automatically with new QFQ Version 24.3.x |
||
8 | If the automatic upgrade wasnt successful, here are some important points: |
||
9 | |||
10 | h3. SQL Function and Procedure |
||
11 | |||
12 | QFQ should deliver one sql function and one procedure called: |
||
13 | * build_dynamic_columns |
||
14 | * auto_insert_merge_rules |
||
15 | |||
16 | 2 | Enis Nuredini | If one of these is missing then take these SQL statement to import it: |
17 | 1 | Enis Nuredini | attachment:build_dynamic_columns.sql |
18 | attachment:auto_insert_merge_rules.sql |
||
19 | 3 | Enis Nuredini | |
20 | h3. Grp Table |
||
21 | |||
22 | Check if the table 'Grp' exists in database. |
||
23 | Table should have following columns: |
||
24 | * id |
||
25 | * grId |
||
26 | * name |
||
27 | * reference |
||
28 | * value |
||
29 | * value2 |
||
30 | * value3 |
||
31 | * value4 |
||
32 | * comment |
||
33 | * enabled |
||
34 | * modified |
||
35 | * created |
||
36 | |||
37 | 4 | Enis Nuredini | SQL structure: attachment:Grp.sql |
38 | |||
39 | 3 | Enis Nuredini | In this table two records with following references should already exist: |
40 | * qfq_merge_rule |
||
41 | * qfq_merge_query |
||
42 | 5 | Enis Nuredini | |
43 | SQL Merge Records: attachment:Grp_merge_data.sql |
||
44 | 6 | Enis Nuredini | |
45 | h3. QFQ Merge Page |
||
46 | |||
47 | Create for the merge tool a new page in Typo3 backend if not already done. |
||
48 | 7 | Enis Nuredini | Create a new qfq tt-content on that page with following content (http://docs.qfq.io/en/master/Report.html#merge-tool): |
49 | 6 | Enis Nuredini | <pre> |
50 | file=_mergeData |
||
51 | </pre> |