• State Not Answered
  • +2 person also asked this people also asked this
  • Replies 13 replies
  • Subscribers 10 subscribers
  • Views 9850 views
  • Users 0 members are here
Related Discussions
Home » Discussions » General

Trying to update CDT using Parse Excel to CDT smart service

soujanyac0001
A Score Level 1

I am trying to update my cdt using parse excel, but i am not getting any cdt values.

The inputs i have given are:

1.The excel doc from KC

2. cdt- i have given ={'type!{urn:com:appian:types:ABC}ABC_Employee'()}

The other fields i havent changed anything. Should we mention all the fields of the cdt in the excel sheet.

Could someone assist me with this.parseExcelData.xlsx

  Discussion posts and replies are publicly visible

Parents
  • 0
    Certified Lead Developer
    Hi Sojanya,

    I faced the same issue when I tried to use the excel to CDT smart service and I could finally make it work after some tweaks. What I found out was that his service is very particular about the data type of the fields being parsed. Excel tends to assign cell formats/data types based on the values in the cell which causes a problem when parsing to CDT as the CDT also has predefined data types defined for every column.
    Therefore what I would suggest is select all the cells of the excel and change the data type to General. This should minimise most of the parsing issues.

    Regards,
    Sunil Zacharia
Reply
  • 0
    Certified Lead Developer
    Hi Sojanya,

    I faced the same issue when I tried to use the excel to CDT smart service and I could finally make it work after some tweaks. What I found out was that his service is very particular about the data type of the fields being parsed. Excel tends to assign cell formats/data types based on the values in the cell which causes a problem when parsing to CDT as the CDT also has predefined data types defined for every column.
    Therefore what I would suggest is select all the cells of the excel and change the data type to General. This should minimise most of the parsing issues.

    Regards,
    Sunil Zacharia
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.