Trying to write 5 test Excel Rows to Entity Table

Follow

Derek Guillory

• July 14, 2020 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

• 

  Alexey Shmelkin (sysberry-absc.com)

  • July 14, 2020 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

  Comment actions Permalink
• 

  Derek Guillory

  • July 14, 2020 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

  Comment actions Permalink
• 

  Vinutha C

  • August 13, 2020 13:23

  Hi Derek,

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

  Thanks.

  0

  Comment actions Permalink

Please sign in to leave a comment.