Uploaded image for project: 'PUBLIC - Liferay Portal Community Edition'
  1. PUBLIC - Liferay Portal Community Edition
  2. LPS-83612

After upgrade, DDM Template change xsd data to json but don't update language

    Details

      Description

      Description

      The customer has noticed an issue where, after upgrading from Liferay 6.2 to Liferay DXP 7.1, the format for DDL Form templates they created changed in the database from XSD to JSON. However, the language column still says XSD before and after the upgrade.

      Steps to reproduce

      1. Start a clean Liferay 6.2 bundle installed with hotfix-26818
      2. Go to Content --> Dynamic Data Lists --> Manage Data Definitions and add a new data definition, using the attached structure
      3. Select the created Data Definition --> Manage Templates and create a form template using the attached template
      4. Verify in the database on the tables "DDMStructure" and "DDMTemplate" that the Script is in XML and the Language is in xsd
      5. Upgrade the database to Liferay DXP 7.1 and start Liferay DXP 7.1 on it
      6. Examine the database tables "DDMStructure" and "DDMTemplate"

      Results of Testing

      Expected Results: For the template you created, script has been changed to be formatted in json, and Language reflects this by saying json.

      Actual Results: For the template you created, script has been changed to be formatted in json, but the Language still says xsd. This is unlike in the Structure table, which has been formatted to json, and the StorageType reflects this. New Template format is seen below.

      {"availableLanguageIds":["es_ES"],"successPage":{"body":{},"title":{},"enabled":false},"defaultLanguageId":"es_ES","fields":[{"dataType":"string","predefinedValue":{"es_ES":"  "},"readOnly":false,"label":{"es_ES":" 1. Título del viaje exploratorio "},"type":"text","required":true,"showLabel":true,"nestedFields":[{"dataType":"date","predefinedValue":{"es_ES":"  "},"readOnly":false,"label":{"es_ES":" Fecha del viaje exploratorio "},"type":"ddm-date","required":false,"showLabel":true,"fieldNamespace":"ddm","indexType":"keyword","repeatable":false,"name":"Date_of_the_Survey_Trip","localizable":true,"tip":{"es_ES":"  "}}],"indexType":"keyword","repeatable":false,"name":"1__Survey_Trip_Title","localizable":true,"tip":{"es_ES":"  "}},{"dataType":"string","predefinedValue":{"es_ES":" [\"\"] "},"readOnly":false,"label":{"es_ES":" 2. Tipo de Investigación "},"type":"radio","required":false,"showLabel":true,"indexType":"keyword","repeatable":false,"name":"2__Types_of_Research","options":[{"label":{"en_GB":" Library Research ","es_ES":" Investigación teórica "},"value":"value 1"},{"label":{"en_GB":" Face to Face interviews ","es_ES":" Entrevistas cara a cara "},"value":"value 2"},{"label":{"en_GB":" Windshield Survey w/Video ","es_ES":" Observación de campo c/video "},"value":"value 3"}],"localizable":true,"tip":{"es_ES":"  "}},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"3__Name_of_the_researchers","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" 3. Nombre de los investigadores "},"type":"textarea","required":true,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"4__Goals_of_Research","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" 4. Objetivos de la investigación "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"5__Assumptions__Situation_on_the_ground____of_Churches__Economic_strength_of_an_area_","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" 5. Suposiciones (Situación general, # de Iglesias, estado de la economía) "},"type":"textarea","required":false,"showLabel":true},{"dataType":"string","predefinedValue":{"es_ES":"  "},"readOnly":false,"label":{"es_ES":" 6. Lugares investigados (Centros de Población p.ej. ciudades/regiones): "},"type":"textarea","required":true,"showLabel":true,"nestedFields":[{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"a__Results_of_Interview__Boundaries__Ethnic_groups__Western_workers_tend_to_stay_in__local_believers_do__total_population__population_by_ethnic_group__Bible__audio_resources__main_routes__economic_strength__etc__","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" a) Resultados de la investigación (Límites, grupos étnicos, los trabajadores occidentales tienden a permanecer en , los creyentes locales hacen, población total, población por grupo étnico, escrituras?, recursos de audio?, rutas principales, fuerza económica, etc) "},"type":"textarea","required":false,"showLabel":true}],"indexType":"keyword","repeatable":false,"name":"6__Places_surveyed__Population_Center_e_g__cities_regions_","localizable":true,"tip":{"es_ES":"  "}},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"7__Observations_regarding_Religion__Minorities__majorities__main_groups_by_area__schools__believers_presence__workers_activity_do_they_speak_the_language_","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" 7. Observaciones acerca de la religión (Minorías, mayorías, los grupos principales de la zona, las escuelas, presencia de creyentes, actividad de obreros [hablan la lengua]) "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"8__Observations_regarding_Economy__Productive_areas__market_areas__Food__Consumer_Goods_and_Service_Sales__ports__bus_stations__airports__transportation__education__restaurants__government_projects__agriculture__technologies__fun_business__tourism__perspective_to_westerns_business_man__exports__cruise__tours__hospitals__weather___roads_condition___infrastructure__hotels__prices__foods__electricity_","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" 8. Observaciones acerca de la economía (Áreas productivas, áreas de mercado, alimentos, bienes de consumo y de servicios de ventas, puertos, estaciones de autobuses, aeropuertos, transporte, la educación, los restaurantes, proyectos del gobierno, la agricultura, las tecnologías, que se hace para divertirse, el turismo, la perspectiva de los extranjeros hombre de negocios, exportaciones, cruceros, tours, los hospitales, el tiempo, condición carreteras, infraestructura, hoteles, precios, alimentos, electricidad) "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"9__Observations_regarding_Economy__Productive_areas__market_areas__Food__Consumer_Goods_and_Service_Sales__ports__bus_stations__airports__transportation__education__restaurants__government_projects__agriculture__technologies__fun_business__tourism__perspective_to_westerns_business_man__exports__cruise__tours__hospitals__weather___roads_condition___infrastructure__hotels__prices__foods__electricity_","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" 9. Resumen e hipótesis (Idiomas, perspectiva sobre los extranjeros, las actividades económicas, actividades religiosas, culturales, etc) "},"type":"textarea","required":false,"showLabel":true},{"predefinedValue":{},"readOnly":false,"label":{"es_ES":" 10. Investigación adicional (Universidades, la atención médica, el gobierno, la corrupción, procedimientos para la obtención de visados, permisos de trabajo, compra de terrenos, grupos abiertos a hacer divulgación) "},"type":"ddm-paragraph","required":false,"showLabel":true,"nestedFields":[{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto6501","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" a) ¿Qué nacionalidad se adapta mejor a residir en la región? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto9099","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" b) ¿Qué nacionalidad sería menos apta para residir en la región? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto8587","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" c) ¿Qué idiomas son de uso común? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto8075","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" d) ¿Existen recursos locales (iglesias , instituciones educativas, etc.) que se puedan movilizar para el ministerio? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto7563","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" e) ¿Pueden residir en estas áreas los extranjeros? "},"type":"textarea","required":false,"showLabel":true}],"fieldNamespace":"ddm","indexType":"keyword","repeatable":false,"name":"10__Investigación_adicional__Universidades__la_atención_médica__el_gobierno__la_corrupción__procedimientos_para_la_obtención_de_visados__permisos_de_trabajo__compra_de_terrenos__grupos_abiertos_a_hacer_divulgación_","localizable":true,"tip":{}},{"predefinedValue":{},"readOnly":false,"label":{"es_ES":" 11. Preguntas específicas: "},"type":"ddm-paragraph","required":false,"showLabel":true,"nestedFields":[{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto10034","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" a) Potencial de proximidad: Cualquier obrero que trabaje en este grupo? o ha estado allí? Hay algún grupo cristiano cerca que pueda ser adecuado para alcanzar este grupo étnico/ centro de población? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto10336","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" b) Movimientos cercanos: ¿Movimiento en una ciudad cercana? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto10638","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" Otras ubicaciones: ¿en qué otros lugares donde se encuentra este grupo? ¿otros países? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto10940","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" d) Recursos de comunicación: Videos, fotos, radio, etc. "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"Caja_de_Texto11242","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" e) Correcciones: ¿Hay correcciones que se pueden realizar en la base de datos existente (lista) de PG nombre, la población, idioma, etc? "},"type":"textarea","required":false,"showLabel":true},{"indexType":"keyword","repeatable":false,"dataType":"string","predefinedValue":{"es_ES":"  "},"name":"f__Other_information_","localizable":true,"readOnly":false,"tip":{"es_ES":"  "},"label":{"es_ES":" f) Otra información: "},"type":"textarea","required":false,"showLabel":true}],"fieldNamespace":"ddm","indexType":"keyword","repeatable":false,"name":"11__Preguntas_específicas_","localizable":true,"tip":{}}]}
      

      Errors/Logs

      None

      Master

      Reproduced - 126d2e429dccb62796fcbf7491a8e456633abf18

        Attachments

          Activity

            People

            • Assignee:
              joyce.wang Joyce Wang
              Reporter:
              samuel.ziemer Sam Ziemer
              Participants of an Issue:
              Recent user:
              Csaba Turcsan
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:
                Days since last comment:
                2 years, 1 week, 2 days ago

                Packages

                Version Package
                7.0.0 DXP FP57
                7.0.0 DXP SP9
                7.0.X
                7.1.X
                Master