In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Updating configuration option labels with import scenario
I'm stuck here and I'm hoping someone has some insight!
I have an import scenario that I use frequently to make updates to Feature->Options on item configurations. I have an @@OptionLabel line in the import scenario mapping that targets the option label of the option I want to apply updates to, then I follow with mapping for the fields that need to be updated. This all works very well.
The issue arises when I need to update the name of the option label itself. For example, we changed what's included in an option and this necessitated changing the option label name.
The option label appears to be the only key field I can target for the update. Since the import scenario is holding on to that label to make sure it's updating the correct option, it seems like it loses the target when I try to give it the updated label name.
I've tried adding a new column to the data provider that holds the new value, like you can do to update inventory IDs. This still runs into the same issue of losing the target as soon as it tries to input the new value.
Any help would be appreciated.
If this isn't possible we may need to update the database directly.
Not quite clear on what you're trying to accomplish but are you able to do the same update yourself interactively? Whenever I'm stuck with an IS I always ensure that what I'm trying to do is possible by trying it manually first.
Sorry, I should have included a screen shot! Hopefully this image helps it make sense!
Yes, making the change in the UI is no problem, it's just not feasible to do it manually for hundreds or thousands of configurations when there is a change.