Page 1 of 1

Application PD Tables are not updating with the Excel.

Posted: March 1st, 2024, 7:00 am
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 4034 times
image.png
image.png (3.83 KiB) Viewed 4034 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

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

Posted: March 1st, 2024, 3:12 pm
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,

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

Posted: March 20th, 2024, 9:22 am
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