Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Cutlist + Import
October 9, 2014
9:44 am
Avatar
Stefan

Forum Posts: 591
Member Since:
November 8, 2013
Thanked 118 times in 591 posts
Reputation: 5910
sp_UserOfflineSmall Offline

Thanks, Mark, it’s great to have a video explaining Polyboard and Cut List Plus integration. It would be interesting to do a detailed analysis that compares the optimization results of Cut List, OptiCut and some of the other leading brands. I’ve made a note…

October 6, 2014
7:46 pm
Avatar
terry

Forum Posts: 253
Member Since:
January 14, 2014
Thanked 19 times in 253 posts
Reputation: 1745
sp_UserOfflineSmall Offline

Mark thank you for taking the time to do this and yes it is very helpful.

Ive finally automated things properly from polyboard to supplier.

Thanks for the email today and I’ve sent a more in depth reply to your email.

 

Many Thanks

 

terry

October 6, 2014
9:12 am
Avatar
mark nichols


Forum Posts: 119
Member Since:
May 18, 2014
Thanked 36 times in 119 posts
Reputation: 1499
sp_UserOfflineSmall Offline

Hi Terry.

This small video is to explain how to export from polyboard and then import into Cutlist +

You will have to watch without sound and I will try to put explanation below to follow as I could not get sound to work on the screencast.

But here goes in order anyway.

1) You need save the project, Well you dont need to but it makes the name easy to spot when importing.

2) You will need to set up the cutlist options as shown in video, I know i covered this before, but just check they are the same.

3) Perform ASCII export as shown. The save name will be used or anything else you choose.

4) Make sure its saved as a .TXT file

5) Open a blank sheet in excel and go to file, open, your file location, and select .txt files. Choose your file and open.

6) It should open up a import dialog. Choose ‘delimited’, and on next page or choice ‘semicolon’ as the delimiter. This should show a nicely arranged set of columns. On last page or choice, choose ‘general’ and click finish.

7) You should now have an imported list with all the details on. This could be used directly to send to Cutwrights or another panel cutting service direct from here.

8) You can now select and copy the sheet. no changes needed and no heading required.

9) Now open up Cutlist and go. Edit, import form clipboard. You will be presented with a blankish import menu.

10) Make sure you follow exactly what it looks like on the video. You wil need to check the ‘first row has headers’ is not selected, unless you want to put column titles on the spreadsheet.

Also the only selection that will not come over from polyboard is the material type and so you will need to set a default as ‘sheet good’

Save this as a ‘new filter’ when happy and it will be used every time you import. Later you can set up a separate filter for ‘bars’ ect.

Click finish and it will import the list and show a dialogue of import amounts.

11) Finally. It will use the material names from polyboard and therefor for simplicity, you should set up the sheet materials in Cutlist to be an exact match and they will seamlessly integrate.

Hopefully this should cover the basics.

Mark

https://dl.dropboxusercontent.com/u/19922571/Customer%20visuals%20folder/Terry_cutlist_export.swf

The following users say thank you to mark nichols for this useful post:

Stefan
Forum Timezone: Europe/London

Most Users Ever Online: 64

Currently Online: Tolga Aksoy
12 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

terry: 253

mark nichols: 119

jimbouk: 105

Christopher Paré: 97

Jack Travis: 66

Peter Brown: 62

Rafal Meckovski: 58

Duayne Naugle: 57

Thusitha Karunatilake: 52

Antony S Brighton: 47

Member Stats:

Guest Posters: 2

Members: 84196

Moderators: 4

Admins: 3

Forum Stats:

Groups: 2

Forums: 8

Topics: 908

Posts: 5426

Newest Members:

Tolga Aksoy, Gerard O'Driscoll, chris bain, George Saad, Héctor Pinto, Dominick Hewitt, Ana Mangasarovi, Predrag Mizdrakovic, mihaela cojocariu, Mark Brown

Moderators: michel melon: 235, D-Alexandre: 86, admin: 0, urbanelement: 0

Administrators: Ness: 1636, Stefan: 591, Carole Bosy: 17