Trying to write 5 test Excel Rows to Entity Table

关注

Derek Guillory

• 2020年07月14日 15:13

I'm new to AgilePoint just went online last week. Attempting to import test Excel Rows into a Data Entity. I've read so many articles on using Next/Loop and Reading Excel examples in documentation.  My Excel file is stored in SharePoint and I've tried using both the "Excel Read" in utilities section and the "Excel Read" in SharePoint utilities section and nothing works.  At least the "Excel Read" in Utilities gets me the first record whereas SP Utility Read gets me 0 records into data entity.

I've tried everything and I'm guessing my mapping is screwed up.  Need Help . I made sure my Excel Columns used the "NAMED" formula.  Why am I only reading the 1st record and stopping?

0

• 

  sysberry GmbH

  • 2020年07月14日 15:22

  Hi Derek,

  you need to map the root node from Excel to AgilePoint on your 5th screenshot those are "Cell" and "SalesInfo". Be sure, that SalesInfo is repeatable.

  Regards

  Alexey

  0

  评论操作 固定链接
• 

  Derek Guillory

  • 2020年07月14日 15:43

  Alexey, I just did your steps and still only reading first record. I ran it twice so you will see 2 records in Data Entity that are the same.

   

  

  0

  评论操作 固定链接
• 

  Vinutha C

  • 2020年08月13日 13:23

  Hi Derek,

  Please can you send us a sample excel template you are using in read excel activity. 

  Thanks.

  0

  评论操作 固定链接

请先登录再写评论。