Is there an easy way to export an excel file into a data entity?

关注

eeortega

• 2020年05月04日 05:15

I tried converting the file to xml and in JSON format but always receive an error , any recommendations?

0

• 

  sysberry GmbH

  • 2020年05月04日 06:51

  Hi,

  can you try Read Excel Acttivity and then in Loop Create Record for Data entity?

  Regards

  Alexey

  0

  评论操作 固定链接
• 

  eeortega

  • 2020年05月04日 18:10

  Thanks! I tried that but after certain number of records the process gets suspended maybe because of a suspicious infinite loop.

  0

  评论操作 固定链接
• 

  sysberry GmbH

  • 2020年05月04日 18:15

  This is default behaviour of AgilePoint to suspend the workflow after 50 iterations. If you click on process canvas somewhere and then in the ribbon to agile properties, then on the right something like session number. There you can put another number of iterations that are ok for the process. Be careful with infinite to avoid infinite loops.

  Regards
  Alexey

  0

  评论操作 固定链接
• 

  AgilePoint NX Support

  • 2020年05月04日 19:08

  Hi,

  Instead of looping, you can make use of Upsert Multiple Entity records Activity. Documentation for Upsert Multiple Entity Records below. 

  https://documentation.agilepoint.com/00/appbuilder/cloudenvShapeUpsertMultipleRecords.html 

  Alternatively, you can increase the session loop count at your process level. 

  https://documentation.agilepoint.com/00/appbuilder/cloudenvPropertiesMaxSessionAllowedConfigWin.html?hl=session

  Request you to try out the above options. 

  Thanks & Regards,

  AgilePoint Support

   

  0

  评论操作 固定链接
• 

  eeortega

  • 2020年05月05日 05:26

  Hi, thanks for the information , I tried that but after some rows the process get suspended as well on the upstert activity.

  I will atach some infomation of the workflow. I am using agilepoint in the cloud version and for that I cant 

  configure a maximum session allowed

  

  

  0

  评论操作 固定链接
• 

  sysberry GmbH

  • 2020年05月05日 05:48

  Can you please share the error message? You can find it in manage -> runtime management -> your process -> process data tab -> ErrorMessage.

  Regards
  Alexey

  0

  评论操作 固定链接
• 

  eeortega

  • 2020年05月05日 15:02

  For some reason, It cant show it , it goes like this permanently

  

  0

  评论操作 固定链接

请先登录再写评论。