Application PD Tables are not updating with the Excel.

[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:

Then a message popped up as DB Records Updated Successfully,

image.png (3.83 KiB) Viewed 181 times

image.png (3.83 KiB) Viewed 181 times

but in actuality, no records were upserted or inserted as shown:

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

[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,

[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: