Avatar
Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
Lost password?
sp_Feed sp_TopicIcon
Cutlist + Import
Avatar
Stefan

Forum Posts: 898
Subscriber Since:
November 8, 2013
Thanked 139 times in 898 posts
Reputation: 7975
sp_UserOfflineSmall Offline
3
October 9, 2014 - 9:44 am
sp_Permalink sp_Print

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...

Avatar
terry

Forum Posts: 253
Subscriber Since:
January 14, 2014
Thanked 19 times in 253 posts
Reputation: 1749
sp_UserOfflineSmall Offline
2
October 6, 2014 - 7:46 pm
sp_Permalink sp_Print

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

Avatar
mark nichols

Forum Posts: 157
Subscriber Since:
May 18, 2014
Thanked 40 times in 157 posts
Reputation: 1794
sp_UserOfflineSmall Offline
1
October 6, 2014 - 9:12 am
sp_Permalink sp_Print

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......export.swf

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

Stefan
Forum Timezone: Europe/London
Most Users Ever Online: 256
Currently Online: LUIZ ALBERTO DOS SANTOS, ahmed ibrahim, John williams, Obedience Kgwete, Dim Dom, Guillermo Angeli
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
terry: 253
mark nichols: 157
Tom Cleaver: 150
Kerf Works: 143
Conor Devoy: 132
Duayne Naugle: 129
brendan kavanagh: 112
jimbouk: 105
Syslab Corp: 103
Stu Robertson: 102
Newest Members:
Hanan Muhammed
Hanan Muhammed
Juozas Martinkus
Emil Dan
patrick nedzlek
Aron barta
Tobias Ludwig
nelly chango
Anton Karpat
Julien Mounien
Forum Stats:
Groups: 2
Forums: 7
Topics: 1861
Posts: 10247

 

Member Stats:
Guest Posters: 4
Members: 153017
Moderators: 0
Admins: 12
Administrators: Ness, Stefan, Michel, Carole, Alex, admin, Laly, ipatrick, Fatima, Crystal, Jem Turner, Darren