Using reports to buy doors, drawerfronts, and drawerboxes
Moderators: Jason Susnjara, Larry Epplin, Clint Buechlein, Scott G Vaal
Using reports to buy doors, drawerfronts, and drawerboxes
Who is able to just fax off (or email) the cut list or buy list to your suppliers, and have them use the info for all component size and quantity detail?
Not me. Not without a whole lotta massaging in MS Excel.
Why? Why not?
Not a rant about the eCabs software, really. It seems as if my supplier is stuck in a rut.
Examples:
I can order sizes in mm or fractional inches to 1/16\". Not 32nds. If my output says \"height 31 8/16\"\", they will not accept or acknowledge. I have to change it to read \"31 1/2\"\"
I can order to size in mm, but not to mm.m (mm to one decimal place). They'll do, however, a hinge bore to a 2.5mm cup offset. Go figure.
Not me. Not without a whole lotta massaging in MS Excel.
Why? Why not?
Not a rant about the eCabs software, really. It seems as if my supplier is stuck in a rut.
Examples:
I can order sizes in mm or fractional inches to 1/16\". Not 32nds. If my output says \"height 31 8/16\"\", they will not accept or acknowledge. I have to change it to read \"31 1/2\"\"
I can order to size in mm, but not to mm.m (mm to one decimal place). They'll do, however, a hinge bore to a 2.5mm cup offset. Go figure.
-
- Guru Member
- Posts: 459
- Joined: Tue, May 17 2005, 4:00PM
- Company Name: TBA
- Country: AUSTRALIA
- Location: ORANGE NSW AUSTRALIA every now and then between trips lol
I have suppliers that don't do 0.5 increments, all suppliers will not take orders on anything other than their own order forms, all of which are setout differently from each other. no-one does electronic ordering.
The one that masters this will get all my work I can tell you.
The one that masters this will get all my work I can tell you.
This message made from recycled electrons.
-
- Wizard Member
- Posts: 5852
- Joined: Thu, Jul 28 2005, 10:18AM
- Company Name: Dan Epps
- Country: UNITED STATES
- Location: Rocky Face GA
Yeah Gene, that is a chip-on-the-shoulder that suppliers seem to have...order it my way or not at all.
I guess what they are saying is that their order processors are good enough to do the conversions when the order is not in their exact preferred format.
You could write Excel macros to do the conversions and reformatting automatically. If your supplier has an Excel worksheet formatted to their specs you could also write macros to copy the exported cut list to the new format.
There are several folks on the forum that are good with Excel macros (I'm not one of them) that might be able to help if you need it.
I guess what they are saying is that their order processors are good enough to do the conversions when the order is not in their exact preferred format.
You could write Excel macros to do the conversions and reformatting automatically. If your supplier has an Excel worksheet formatted to their specs you could also write macros to copy the exported cut list to the new format.
There are several folks on the forum that are good with Excel macros (I'm not one of them) that might be able to help if you need it.
-
- Wizard Member
- Posts: 1896
- Joined: Wed, May 18 2005, 7:54PM
- Company Name: Milltech Millworks Ltd.
- Country: CANADA
- Location: Edmonton, Alberta
- Contact:
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
Sorry guys and gals but I agree with the \"chip\". If you were in their shoes and did the volume as they do in the office, the clerks would go bonkers over the many different formats they would have to interpret. I wouldn't do it not without charging extra for the interpreter.
In retrospect to that; it maybe a good idea to create a macro to change the data and align the feilds the way the vendors require. Just a suggestion.
In retrospect to that; it maybe a good idea to create a macro to change the data and align the feilds the way the vendors require. Just a suggestion.
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
-
- Guru Member
- Posts: 459
- Joined: Tue, May 17 2005, 4:00PM
- Company Name: TBA
- Country: AUSTRALIA
- Location: ORANGE NSW AUSTRALIA every now and then between trips lol
Michael, That's right I agree it would be a headache trying to sort through all the different formats, which is why they need to go to some form of electronic order so that we can write macros to go from eCabs output to their form. At present all that is available is format then print/view and fill in propriety order form by hand (prone to error).
What I'd like to see is a solution beneficial to both sides.
What I'd like to see is a solution beneficial to both sides.
This message made from recycled electrons.
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
I agree Glenn,
I also go through the same thing with vendors. There is no difference.
I especially dislike the measurement interpretation.
Maybe Thermwood programmers can do a \"make doors and drawer fronts round to nearest 1/16\" or something similar in metric.
I also go through the same thing with vendors. There is no difference.
I especially dislike the measurement interpretation.
Maybe Thermwood programmers can do a \"make doors and drawer fronts round to nearest 1/16\" or something similar in metric.
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
I am flying blind on this because I am not home, and haven't access to my eCabinets program from this \"on the road\" laptop, but can't we specify our measurements to be metric, and also that our mininum incremental door sizings (drawerfronts, too) be 1mm?
I don't believe the buy list can be exported to MS Excel, but the cut list can, right? If we specify doors as 5 piece make in house, then they appear on the cut list somewhere, right? With L in one field, and W in another?
I don't believe the buy list can be exported to MS Excel, but the cut list can, right? If we specify doors as 5 piece make in house, then they appear on the cut list somewhere, right? With L in one field, and W in another?
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
If I'm not mistaken Gene, the Conestoga doors have a minimum increment of 1/32\" but, we don't have the option to change it in the software.
However, the buy list can be exported if you right click in the buy list pop up window and select \"Export to Microsoft Excel\". A dialog will come up and you will need to click on the top check mark to select all the fields then click Import. Next, another dialog will pop up and just select OK again. That should do it...
However, the buy list can be exported if you right click in the buy list pop up window and select \"Export to Microsoft Excel\". A dialog will come up and you will need to click on the top check mark to select all the fields then click Import. Next, another dialog will pop up and just select OK again. That should do it...
- Attachments
-
- iviewcapture_date_06_12_2007_time_20_18_29.jpg (41.43 KiB) Viewed 7305 times
-
- iviewcapture_date_06_12_2007_time_20_17_53.jpg (81.8 KiB) Viewed 7305 times
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
The trouble with the buy list in getting something useful for actually purchasing doors and drawerfronts, is that the size of each is embedded in the description as text.
You can program in Excel to extract the numeric info you need, but it is far easier if height is in one field and width in another. I believe it is that way in the cut list.
For those components to appear in the cut list, though, they have to be defined as make in house.
Am I recalling the program outputs correctly?
You can program in Excel to extract the numeric info you need, but it is far easier if height is in one field and width in another. I believe it is that way in the cut list.
For those components to appear in the cut list, though, they have to be defined as make in house.
Am I recalling the program outputs correctly?
-
- Wizard Member
- Posts: 4722
- Joined: Mon, May 09 2005, 7:33PM
- Company Name: Double E Cabinets
- Country: UNITED STATES
- Location: Amarillo, TX
Gene,
I am all for making things more simple to order but eCabinets was set up to work with the original Cooperative door vendor Consestoga. It follows all of their rules. You can also get easy online electronic ordering for three other door vendors through the member store.
I run into the same problem because I build most of my own doors and I don't build to a 1/32\" increment.
It doesn't hurt to ask though.
Kerry
I am all for making things more simple to order but eCabinets was set up to work with the original Cooperative door vendor Consestoga. It follows all of their rules. You can also get easy online electronic ordering for three other door vendors through the member store.
I run into the same problem because I build most of my own doors and I don't build to a 1/32\" increment.
It doesn't hurt to ask though.
Kerry
-
- eCabinets Beta Tester
- Posts: 1740
- Joined: Tue, May 17 2005, 8:33PM
- Company Name: Timeless Cabinetry and Mantles
- Location: South East
Re:
The sizes are relative to the column "D" and are a part of the description if you choose in house. However, if you chose the alternate source for doors you will have the height and width in columns "E" and "F" respectively on the alternate door and drawer front sheet.Gene Davis wrote:The trouble with the buy list in getting something useful for actually purchasing doors and drawer fronts, is that the size of each is embedded in the description as text.
Yes, in the cut list as above, change to alternate source.You can program in Excel to extract the numeric info you need, but it is far easier if height is in one field and width in another. I believe it is that way in the cut list.
Yes, If you need the individual component sizes.For those components to appear in the cut list, though, they have to be defined as make in house.
Yes, just change to alternate source and this will provide you with a better environment to filter in excel.[/quote]Am I recalling the program outputs correctly?
Intel Core i7-5820K (6-Cores, 3.3GHz, 15MB Cache)
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650
32Gigs DDR4
NVIDIA GeForce GTX 960 4GB
SSD 840 256Gig, 2TB, 3TB, Samsung (2TB)
Corsair RM650