Loading Survey - Survey_Answer_Template  - svy_atpl

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

ca_1c_242446.jpg

 

 

How to load a Survey Answer?

 

 

 

 

 

bop_sinfo -dq svy_atpl

 

 

 

 

Factory svy_atpl < Survey_Answer_Template >

Attributes:

   id                                INTEGER UNIQUE

   producer_id                 LOCAL STRING(20)

   persistent_id persid      STRING(30)

   text txt                       STRING(400)

   sequence                    INTEGER REQUIRED

   owning_survey_question <own_srvy_question> SREL -> svy_qtpl.id REQUIRED

   delete_flag del            SREL -> actbool.enum REQUIRED

   last_mod_dt               DATE

   last_mod_by              SREL -> cnt.id TENANCY_UNRESTRICTED

   tenant                        SREL -> tenant.id

 

 

 

 

 

 

 

pdm_extract Survey_Answer_Template

TABLE Survey_Answer_Template

  del id last_mod_by last_mod_dt owning_survey_question persid sequence tenant  txt

     

pdm_load -v -i -f Survey_Answer_Template.txt

TABLE Survey_Answer_Template

  del id last_mod_by last_mod_dt owning_survey_question persid sequence tenant txt

  { "0" ,"400001" ,"F4C2A60100EA154695D233F90ABFFD21", "06/18/2015 16:38:25" ,"400001" ,"svy_atpl:400001" ,"10" ,"" ,"Ótimo" }

 

MS SQL Querys

 

select * from survey_atpl

 

 

 

Loading Survey - survey_template svy_tpl

Loading Survey - Survey_Question_Template  - svy_qtpl

 

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