opening locks ignored in excel batch import

Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal

Mark Hesketh
Guru Member
Posts: 365
Joined: Fri, Aug 25 2006, 9:12AM
Company Name: Paris Kitchens
Country: CANADA
Location: Paris, ontario

opening locks ignored in excel batch import

Postby Mark Hesketh » Mon, Jul 25 2016, 6:40AM

I have encountered an issue with the opening locks on partitions when importing a cabinet through the "import batch list from excel" button... it ignores the lock, yet says it is still active.

To mass-produce just the top and bottoms for some of our cabinets, I have created a model with everything turned off except for the back (which acts as our top/bottom), set to our 16mm case material. This way an excel batch can be created where the part sizes, length and width, match the height and width of the model (rather than using the top/bottom of a standard ecab model and having the length of the part as the case width and the width as the case depth). To cut the groove for the 4mm backer material, I added a partition with a full dado into the back, then locked the left opening, then turned the partition into a phantom part. playing around with the sizes in ecabs, the "partition" always remains at the locked 16mm from the left (back) edge of the part.

Now, after generating a batch excel list of a couple hundred parts, once that is imported all of the parts where the width has been altered have moved the partition... it does not remain locked at 16mm from the left edge (for instance, original model is 300mm wide, excel batch entry at 604mm wide moves the partition to 122.22mm from left edge)... but opening it up to check says that the opening lock is still "true".

Any ideas on where this is going wrong or what I can do to make it work?

Mark Hesketh
Guru Member
Posts: 365
Joined: Fri, Aug 25 2006, 9:12AM
Company Name: Paris Kitchens
Country: CANADA
Location: Paris, ontario

Re: opening locks ignored in excel batch import

Postby Mark Hesketh » Mon, Jul 25 2016, 12:42PM

Here is the part I created... it adjusts fine in ecabs, but ignores the opening lock when imported from excel.
Attachments
FLOOR1L0W.jpg
FLOOR1L0W.jpg (5.63 KiB) Viewed 1047 times

Mark Hesketh
Guru Member
Posts: 365
Joined: Fri, Aug 25 2006, 9:12AM
Company Name: Paris Kitchens
Country: CANADA
Location: Paris, ontario

Re: opening locks ignored in excel batch import

Postby Mark Hesketh » Mon, Jul 25 2016, 12:43PM

oops, here is the .hsf
Attachments
FLOOR1L0W.hsf
(172.02 KiB) Downloaded 43 times

Mark Hesketh
Guru Member
Posts: 365
Joined: Fri, Aug 25 2006, 9:12AM
Company Name: Paris Kitchens
Country: CANADA
Location: Paris, ontario

Re: opening locks ignored in excel batch import

Postby Mark Hesketh » Tue, Aug 02 2016, 8:15AM

Any chance someone at Thermwood, or someone who uses excel batch inports extensively, could take a look at this? Really need this to work in order to continue with the evolution of our processes in the shop (moving more of the production to the Thermwood), can't use it at all right now with this issue.
Thanks

Scott Marshburn
Guru Member
Posts: 744
Joined: Sat, Mar 05 2011, 7:29AM
Company Name: Heritage WoodWorks
Country: UNITED STATES
Location: Jacksonville Nc
Contact:

Re: opening locks ignored in excel batch import

Postby Scott Marshburn » Thu, Aug 04 2016, 8:36AM

Have you tried a pocket for the dado and then constrain it as needed in constraints manager?
Yes! Oh Yes! I Think We Are Going to make It!
https://www.youtube.com/user/ecabinetstips

Mark Hesketh
Guru Member
Posts: 365
Joined: Fri, Aug 25 2006, 9:12AM
Company Name: Paris Kitchens
Country: CANADA
Location: Paris, ontario

Re: opening locks ignored in excel batch import

Postby Mark Hesketh » Thu, Aug 04 2016, 8:48AM

pocket cuts are handled differently than dadoes on the machine... takes longer, extra passes.

I have come up with a work-around for this part by adding a phantom top and bottom and then placing a stretcher between them, full-dadoed into the back, and locked to the correct location. after some preliminary testing it seems to work the way it should.

Still don't know why the opening locks seem to work fine for everything except an excel batch import. Worried that it will similarly ignore the opening locks on the more complicated cabinet models I have once we get around to using those.

Rick Deskins
Thermwood Team
Posts: 837
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: opening locks ignored in excel batch import

Postby Rick Deskins » Thu, Aug 04 2016, 9:28AM

This issue will be fixed in the next release.
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900

Mark Hesketh
Guru Member
Posts: 365
Joined: Fri, Aug 25 2006, 9:12AM
Company Name: Paris Kitchens
Country: CANADA
Location: Paris, ontario

Re: opening locks ignored in excel batch import

Postby Mark Hesketh » Thu, Aug 04 2016, 9:35AM

Great. Thanks Rick!


Return to “eCabinet Systems Software”

Who is online

Users browsing this forum: No registered users and 12 guests