search

meridianww / M4PLBase

0 stars 1 forks source link

Import Meridian Vendor Profile #489

Open nmfujimoto opened 3 years ago

nmfujimoto commented 3 years ago

Using the attached file, import and store vendor data for delivery days and fan run are for a given postal code. The data is related to a vendor location so it can be used across all customers that the vendor location services.

The data will require a new database table to store the information and an update to the API to retrieve the information based upon the postal code and site code of the job.

The file can be imported more than once, if the existing postal code and Vendor Location Code exist, update the current record else create a new record.

nmfujimoto commented 3 years ago

Meridian Vendor Profiles.xlsx

nmfujimoto commented 3 years ago

image

nmfujimoto commented 3 years ago

Updated file with Saturday and Sunday.

Meridian.Vendor.Profiles.xlsx

nmfujimoto commented 3 years ago

[Uploading Meridian Vendor Profile (Updated).xlsx…]()

prashantaggarwal1999 commented 3 years ago

@nmfujimoto we have made the changes to Mark the StatusId as 3 for the old records when uploaded the new one. Please confrim if this is correct Behaviour

prashantaggarwal1999 commented 3 years ago

Meridian.Vendor.Profiles (1).zip

The sample File for the upload is this. @nmfujimoto changes are deployed on staging with this sample file. Please check. API is available on the URL: https://m4pl-dev.meridianww.com/M4PLAPI/Help/Api/GET-api-VendorProfile-GetVendorProfile_locationCode_postalCode

Madhusmi commented 3 years ago

@nmfujimoto testing completed in Staging environment and verified from Database also and it is working as expected.