Good morning , I'm using the Excel Importer to upload vendor price lists. I have vendor accounts set up, and in my import template, I’ve mapped one column in the Excel file to the VendorPriceList_Vendor reference. So, for now, I'm including the vendor name as a column in the Excel file. This way, when the file is imported, each price list gets associated with the correct vendor based on the name provided. However, I’m not sure this is the best approach. I couldn’t find an option for a "Before Import Microflow" in the Excel Importer (I'm using Mendix 10.23), which I believe would have been a cleaner way to dynamically link the current logged-in vendor instead of relying on a name column in the file. If you're familiar with how the Before Import Microflow works or have a better suggestion for handling this, I’d really appreciate your guidance!
asked
Rishika Inamadugu
1 answers
0
I'd use a two step approach.
Import the data in a separate entity and then process the data to the pricelist.
As you have the user and therefore the vendor the processing of the data can use this information and there is no risk of adding data to the wrong vendor.