IMPORT BATCH LIST

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

Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

IMPORT BATCH LIST

Post by Zach Froble »

I am trying to import a batch list of panels from open office saved in xls format. I followed the help file, but still can't get it to work. Any hints or tricks to get this to work.

Thanks,
Zach
Attachments
STOUT,VAUN DOOR PANEL TEST.xls
Excel Batch Import
(8.5 KiB) Downloaded 443 times
Lyndan Designs
Machining and CAD Services
Scott G Vaal
Thermwood Team
Posts: 1740
Joined: Tue, May 17 2005, 12:44PM
Company Name: Thermwood Corporation
Location: Thermwood Corp: Dale, Indiana
Contact:

Re: IMPORT BATCH LIST

Post by Scott G Vaal »

Zach,

It works correctly for me if I create the directory named LD ACCESSORIES and save a cabinet named SKIN into it. Make sure your directory and cab name match (unmatched spellings or spaces will cause failure). Do you get any error message when you run it?
Regards,

Scott Vaal
-Thermwood/eCabinet Systems-
Dell Precision / Xeon E3-1240 / 8GB RAM /NVIDIA Quadro K2000
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

No error message nothing happens. I will double check the spelling and directories.

Thanks,
Zach
Lyndan Designs
Machining and CAD Services
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Scott,

I tried renaming the directories and cabinet name and still nothing. I am not getting any errors. Is there anything else that could be causing this?

Thanks,
Zach
Lyndan Designs
Machining and CAD Services
Rick Deskins
Thermwood Team
Posts: 857
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: IMPORT BATCH LIST

Post by Rick Deskins »

You mentioned you were using open office. If you do not have excel install on your pc, you need to install excel viewer. It puts the proper dll on your pc that will allow for excel imports.

http://www.microsoft.com/en-us/download ... aspx?id=10
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Rick,

That did it.

Thank you,
Zach
Lyndan Designs
Machining and CAD Services
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Rick,

I went to import a batch today and now I am getting nothing again. It worked after I installed the excel viewer, but now nothing.

Any insight to why this is causing so many problems. Should I get a copy of excel and not use open office?

Thanks,
Zach
Lyndan Designs
Machining and CAD Services
Rick Deskins
Thermwood Team
Posts: 857
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: IMPORT BATCH LIST

Post by Rick Deskins »

Can you post your excel file you are trying to import?
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Here is the file.
Attachments
DOOR PANEL TEST.xls
(10.5 KiB) Downloaded 443 times
Lyndan Designs
Machining and CAD Services
Rick Deskins
Thermwood Team
Posts: 857
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: IMPORT BATCH LIST

Post by Rick Deskins »

You have a space after the directory name. May try removing the trailing space.
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Rick,

I have tried renaming with and with out spaces still nothing is working. I have double checked spelling over and over, but still can't get it to work.
Lyndan Designs
Machining and CAD Services
Rick Deskins
Thermwood Team
Posts: 857
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: IMPORT BATCH LIST

Post by Rick Deskins »

Does this work for you?
Attachments
DOOR PANEL TEST.xls
(22.5 KiB) Downloaded 406 times
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Rick,

This time it gave me an error. "Error loading row 0 of c;\users\zach\downloads\door panel test.xls. Failed to load BEP.
Lyndan Designs
Machining and CAD Services
Zach Froble
Senior Member
Posts: 171
Joined: Tue, Jun 21 2005, 3:23PM
Location: Connellsville, PA

Re: IMPORT BATCH LIST

Post by Zach Froble »

Rick,

I double checked the file you posted and realized that I had renamed the LD ACCESSORIES directory while playing around and it does work now.
Lyndan Designs
Machining and CAD Services
Rick Deskins
Thermwood Team
Posts: 857
Joined: Tue, May 17 2005, 12:47PM
Company Name: Thermwood
Country: UNITED STATES
Location: Thermwood

Re: IMPORT BATCH LIST

Post by Rick Deskins »

Glad to hear that it worked. All I did to your xls file is remove the space at the end of "LD ACCESSORIES".
Rick Deskins
eCabinet Systems Programmer
Dell Precision / Xeon E3-1240 / 8GB RAM/ AMD FirePro V4900
Post Reply