Loading Survey - survey_template svy_tpl

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

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

 

How to load a survey

 

 

 

 

 

bop_sinfo -dq svy_tpl

 

Factory svy_tpl < Survey_Template >

Attributes:

   id                   INTEGER UNIQUE

   producer_id          LOCAL STRING(20)

   persistent_id persid STRING(30)

   sym                  STRING(60) REQUIRED SKEY UNIQUE

   description          STRING(400)

   include_comment      INTEGER REQUIRED

   comment_label        STRING(80)

   conclude_text        STRING(400)

   delete_flag del      SREL -> actbool.enum REQUIRED

   last_mod_dt          DATE

   last_mod_by          SREL -> cnt.id TENANCY_UNRESTRICTED

   question_templates   QREL <- svy_qtpl {owning_survey = ? AND delete_flag = 0}

 

 

   submit_cycle         INTEGER

   tracking_flag        INTEGER

   tenant               SREL -> tenant.id

 

pdm_extract Survey_Template

TABLE Survey_Template

  comment_label conclude_text cycle_counter del description id include_comment   last_mod_by last_mod_dt persid submit_cycle sym tenant tracking_flag

 

pdm_load -v -i -f surveytemplate.txt

TABLE Survey_Template

  comment_label conclude_text cycle_counter del description id include_comment   last_mod_by last_mod_dt persid submit_cycle sym tenant tracking_flag

  { "" ,"" ,"" ,"0" ,"" ,"400001" ,"0" ,"F4C2A60100EA154695D233F90ABFFD21",   "06/18/2015 16:37:25" ,"svy_tpl:400001" ,"1" ,"SURVEY" ,"" ,"" }

 

MS SQL Querys

 

select * from survey_tpl

 

 

Keep going and load your question using the document

Loading Survey - Survey_Question_Template  - svy_qtpl

Loading Survey - Survey_Answer_Template  - svy_atpl

 

know_more.png

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