I am not a fan of using excel lookups from the configurator, I have gotten better performance by using a UD table and in E9 there is pc configurator tables that is very helpful. A simple "find in" is all it takes to get the data, the table is always backed up, no worries about an excel sheet going missing, benefit of indices, etc. You can populate the Epicor table with the data from the excel sheet using paste insert or write a simple import routine so you use the excel sheet to organize your data while getting the benefits of the database.
Jim Kinneman
Encompass Solutions, Inc
Jim Kinneman
Encompass Solutions, Inc
--- In vantage@yahoogroups.com, "beverlykerby" <bscanlan@...> wrote:
>
> I am trying to write a rule that will do an Excel Lookup and populate a placeholder part with a part number from the excel sheet. I have listed the rules written so far below:
>
> Store P01_Cmb_LGTH in MtgBodyColumn1 (taking user input and storing it)
> Store P01_Cmb_MTG in MtgBodyRow1 (taking second user input and storing it)
> Store String ((ExcelLookup("\\192.1.1.250\Epicor\mfgsys803\Server\ud\RML.xls","BODY", MtgBodyColumn1, MtgBodyRow1))) in BodyType
>
> I then had a Set field rule for the part number. However, when testing the rules, the first two store methods are populating correctly but 'BodyType' is coming up blank from the ExcelLookup.
>
> I am not sure that I have the language correct however we have had success in doing this except with Integers. The part number I am trying to bring from Excel is in the format EB-0456-01.
>
> If anyone has any suggestions on how to make this work it would be greatly appreciated.
>
> Thanks,
> Beverly Scanlan
>