WikiAdmin: 1 revision imported

2023-07-14T13:00:35Z

1 revision imported

← Older revision

Revision as of 13:00, 14 July 2023

Intra>Chanson: Created page with "Copying forms from company to company is easy. ==Archiving Forms with Query Export== Simply Select your form data:

 Select FORM_ID,FORM_TYPE,FORM_NAME,COMPANY_ID,USER_ID..."

2018-11-02T21:16:02Z

Created page with "Copying forms from company to company is easy. ==Archiving Forms with Query Export== Simply Select your form data: <PRE> Select FORM_ID,FORM_TYPE,FORM_NAME,COMPANY_ID,USER_ID..."

New page

Copying forms from company to company is easy.

==Archiving Forms with Query Export==
Simply Select your form data:
<PRE>
Select FORM_ID,FORM_TYPE,FORM_NAME,COMPANY_ID,USER_ID,IP_ADDRESS,FORM_DATA,MEMO,LAST_CHANGE_DATETIME,LAST_CHANGE_USER,ACTIVE_FLAG FROM CCTFORM
cctform where form_id = 'ARSTM'
</PRE>

and Export it to a .csv or excel file. It will archive all form data but not image data.

*When you run the query it will just show the word "(Memo)" in the data cell. Don't worry, it the data is all there.

==QueryGen to Update/Create Forms==
Select:
<PRE>
Select FORM_ID,FORM_TYPE,FORM_NAME,COMPANY_ID,USER_ID,IP_ADDRESS,FORM_DATA,MEMO,LAST_CHANGE_DATETIME,LAST_CHANGE_USER,ACTIVE_FLAG FROM CCTFORM
cctform where form_id = 'ARSTM'
</PRE>

Model Query to Update:
<PRE>
/* ============================================================ */
UPDATE CCTFORM SET FORM_DATA=
'{FORM_DATA}'
WHERE FORM_ID='{FORM_ID}';

INSERT INTO CCTFORM
( FORM_ID, FORM_TYPE, FORM_NAME, COMPANY_ID, USER_ID, IP_ADDRESS, FORM_DATA, MEMO, LAST_CHANGE_DATETIME, LAST_CHANGE_USER, ACTIVE_FLAG)
SELECT
'{FORM_ID}', '{FORM_TYPE}', '{FORM_NAME}', '{COMPANY_ID}', '{USER_ID}', '{IP_ADDRESS}', '{FORM_DATA}', '{MEMO}', CAST('TODAY' AS TIMESTAMP), 'HIT', '{ACTIVE_FLAG}'
from artloc where loc_id=0 and not EXISTS (SELECT 'A' FROM CCTFORM WHERE FORM_ID= '{FORM_ID}' );

</PRE>
'''Notes:'''
*This is designed to update an existing form and then insert it if missing.
*When you run the query it will just show the word "(Memo)" in the data cell. Don't worry, it the data is all there.

QueryGen Case: Replicating Forms - Revision history

WikiAdmin: 1 revision imported

Intra>Chanson: Created page with "Copying forms from company to company is easy. ==Archiving Forms with Query Export== Simply Select your form data:
Select FORM_ID,FORM_TYPE,FORM_NAME,COMPANY_ID,USER_ID..."