I have a simple import scenario that I am using as a test that is being used to populate customer contact records. In the import scenario I am using the =PadLeft([PostalCode],5,’0’) to pad out any of postal codes that have a leading zero so that they will pass validation. When I run the import scenario it looks like the code isn’t even running. I am not sure if I am doing something wrong or if I am missing a small detail that is preventing the code from running. The code passes the validation test so I don’t think it is a syntax issue. I have attached the data provider, the excel spreadsheet and the import scenario. Any help would be greatly appreciated.
Solved
PadLeft function not working on Import Scenario
Best answer by mtcook
I figured it out. I was under the mistaken assumption that the code would update the data in the grid once Prepare was run, and show the postal code padded out. From what I have been able to determine the Prepare grid shows just the raw data from the data provider and not with the transformation that the code would provide. When I ran the import scenario the postal codes did go into the contact screens padded out.
I figured it out. I was under the mistaken assumption that the code would update the data in the grid once Prepare was run, and show the postal code padded out. From what I have been able to determine the Prepare grid shows just the raw data from the data provider and not with the transformation that the code would provide. When I ran the import scenario the postal codes did go into the contact screens padded out.
Thank you for sharing your solution with the community
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.