Hi Ben,
Good luck with getting such info!
A good few years ago we used to use this method but have since dispensed with it – we now use the Application Integration feature to generate an XML.
From my memory, we had a visual scripting program that identified and deleted irrelevant lines from the CSV leaving only the cabinetry information. The columns containing the cabinetry info remain the same all the time e.g. if you export the Item List, column B always contains the quantity, C always contains the cabinet UserCode, D the ManufCode and E the Description.
A lot of the lines however need to be dropped out and this is what the Visual Script did.
I would use the manufCode to match the cabinets as the UserCode can vary depending on the settings in the catalogue – our Usercode incorproates the cabinet width as part of it so when a cabinet width is changed by a designer, so does the usercode.
If you want to speak further, send me a personal email at mhl@ipprofessional.com.au
Share this Post