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,
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
Application PD Tables are not updating with the Excel.
-
- Posts: 7
- Joined: August 24th, 2023, 9:25 am
- Contact:
Application PD Tables are not updating with the Excel.
word count: 113
-
- Posts: 574
- Joined: August 26th, 2021, 9:56 am
- Contact:
Re: Application PD Tables are not updating with the Excel.
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,
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
-
- Posts: 4
- Joined: February 4th, 2022, 3:56 pm
- Contact:
Re: Application PD Tables are not updating with the Excel.
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:
I enabled IDE logs. I found this exception in my testing:
word count: 38