Application PD Tables are not updating with the Excel.

This forum allows users to post and respond to "How Do I Do ....." questions. The information contained in this forum has not been validated by K-Rise Systems and, as such, K-Rise Systems cannot guarantee the accuracy of the information.
Post Reply
rpathak
Posts: 7
Joined: August 24th, 2023, 9:25 am
Contact:

Application PD Tables are not updating with the Excel.

Unread post by rpathak »

Application PD Tables are not updating with the Excel:

When I tried to upsert/insert the data via Excel in DV, and QA environment it was working and db was successfully updated, but when I tried to do the same in PD as shown below:
image.png
Then a message popped up as DB Records Updated Successfully,
image.png
image.png (3.83 KiB) Viewed 4033 times
image.png
image.png (3.83 KiB) Viewed 4033 times
but in actuality, no records were upserted or inserted as shown:
image.png

I have tried both Upsert and Insert, but none of them worked for me.

NOTE: I am using Platform 4 service, and the link is https://platform4.krisesystems.com/IDE/ ... aseRecords
word count: 113
JustinVanRegenmorter
Posts: 574
Joined: August 26th, 2021, 9:56 am
Contact:

Re: Application PD Tables are not updating with the Excel.

Unread post by JustinVanRegenmorter »

Hello rpathak,

Please check that the sheet in the excel document is named sheet1. Excel documents can have multiple sheets and EASYProcess looks for and reads the sheet named sheet1.

Best Regards,
word count: 32
NathanL
Posts: 4
Joined: February 4th, 2022, 3:56 pm
Contact:

Re: Application PD Tables are not updating with the Excel.

Unread post by NathanL »

I tested myself in the same environment, but using one of the unused tables so it doesn't affect actual data. I also got the same issue

I enabled IDE logs. I found this exception in my testing:
ANE 1242 IDE logs.PNG
word count: 38
Post Reply