Loading Survey - Survey_Question_Template  - svy_qtpl

Document created by TMACUL Champion on Dec 1, 2015Last modified by TMACUL Champion on Dec 1, 2015
Version 2Show Document
  • View in full screen mode

o0pxssu24gm-fwmavkzyl9ps9s1nya4ieyklwlonisypqhfrrjcwir0lnzzy7mflvdqiv_0e3ne4q3oxnspdly8bgmfnywprha1txpvfns6qscaxcdvenvzgwcbversh7wp1cwnypvqqrtay_drat14o5msrjhpek0xjwui-45bwnb_gq1xub7oonr9hwy0h6jhayzoypzfq7m4njk82rvrmrbswxmoj.jpg?itok=nsYvwLdA

 

 

How to load a Survey Question?

 

 

 

 

 

bop_sinfo -dq svy_qtpl

 

 

Factory svy_qtpl < Survey_Question_Template >

Attributes:

   id                   INTEGER UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id persid STRING(30)

   text txt             STRING(400)

   sequence             INTEGER REQUIRED

   owning_survey        SREL -> svy_tpl.id REQUIRED

   delete_flag del      SREL -> actbool.enum REQUIRED

   last_mod_dt          DATE

   last_mod_by          SREL -> cnt.id TENANCY_UNRESTRICTED

   answer_templates     QREL <- svy_atpl {owning_survey_question = ? AND delete_flag = 0}

   resp_required        INTEGER

   include_qcomment     INTEGER

   mult_resp_flag       INTEGER

   qcomment_label       STRING(80)

   tenant               SREL -> tenant.id

 

 

 

 

 

 

pdm_extract Survey_Question_Template

TABLE Survey_Question_Template

        del id include_qcomment last_mod_by last_mod_dt mult_resp_flag owning_survey

 

pdm_load -v -i -f Survey_Question_Template.txt

TABLE Survey_Question_Template

  del id include_qcomment last_mod_by last_mod_dt mult_resp_flag owning_survey   persid qcomment_label resp_required sequence tenant txt

  { "0" ,"400001" ,"0" ,"",   "" ,"0" ,"400001" ,"svy_qtpl:400001" ,"" ,"0" ,"10" ,"" ,"What is your own question?" }

 

MS SQL Querys

 

select * from survey_qtpl

 

 

Loading Survey - survey_template svy_tpl

Loading Survey - Survey_Answer_Template  - svy_atpl

 

know_more.png

Loading Survey - survey_template svy_tpl

Carga Estados Brasileiros / Brazilian State load - ca_state_province

CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg

Category.xlsx Schema - CA Service Desk Manager Load Category using pdm_load - pcat - Prob_Category - Prob_Ctg

CA SDM Load department using pdm_load - dept - ca_resource_department

DEREF - pdm_deref - Everthing do you need know

CA SDM::. position - ca_job_title

CA SDM carregando contatos ca_contact/usp_contact usando pdm_load

 

CA SDM Loading contacts pdm_load

CA SDM Loading groups pdm_load

CA SDM Loading group members pdm_load

 

Root Cause - rootcause - rc / Causa raiz - 根本原因 -

Resolution Method - usp_resolution_method - resomethod - Método de resolução - Resolución - 解決

Resolution Code - usp_resolution_code - resocode - Código de resolução - Resolución - 解決

 

CA SDM how to delete location?

MS SQL - Turn upper case for first letter/character on phrase

CA SDM caractere inválido na carga - pdm_load -  Invalid character

CA SDM pdm_load 537  Invalid character encountered in input - error

 

 

 

useful.jpg

Was this information helpful? Leave a comment.

Attachments

    Outcomes