{"id":45,"date":"2012-05-19T20:16:22","date_gmt":"2012-05-19T17:16:22","guid":{"rendered":"http:\/\/optimalprograms.com\/blog\/?p=45"},"modified":"2012-07-26T11:08:41","modified_gmt":"2012-07-26T08:08:41","slug":"migrating-to-real-cut-1d-version-9","status":"publish","type":"post","link":"https:\/\/optimalprograms.com\/blog\/?p=45","title":{"rendered":"Migrating to Real Cut 1D version 9"},"content":{"rendered":"<p>In version 9 of the Real Cut 1D we have changed the order of columns for Demand parts. We did that in order to improve data exchange with Excel.<\/p>\n<p>If you previously saved your data in native files (with extension 1d) you dont have to do anything. Real Cut 1D knows how to load its own files.<\/p>\n<p>However, if you did saved your data in csv or excel files, you will have to modify them by reordering the columns.<br \/>\nHere is what you have to do:<\/p>\n<p>&#8211; open the csv or xls file in Excel.<br \/>\n&#8211; move the angle1 and angle 2 columns at the right of the existing columns.<br \/>\n&#8211; delete the empty columns 3 and 4 which have resulted as effect of moving columns with angles.<br \/>\n&#8211; exchange the height column with quantity column.<\/p>\n<p>Here is an example:<\/p>\n<p>&#8211; csv file from version 8 or less:<\/p>\n<p>Length;Height;Angle1;Angle2;Quantity;Material;Label<br \/>\n1000;0;90;90;5;wood;john<\/p>\n<p>2000;0;90;90;12;wood;mike<\/p>\n<p>in version 9 this becomes:<\/p>\n<p>Length;Quantity;Height;Material;LabelAngle1;Angle2<br \/>\n1000;5,0;wood;john;90;90<\/p>\n<p>2000;12;0;wood;mike;90;90<\/p>\n<p>Pay a special attention to list separator. In some regions the separator is &#8220;,&#8221;. In some others is &#8220;;&#8221;. If the separator is incorrectly set you will get an error.<br \/>\nYou may change the separator from menu Start | Control panels | Region and language | Additional settings| List separator of the Windows 7.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In version 9 of the Real Cut 1D we have changed the order of columns for Demand parts. We did that in order to improve data exchange with Excel. If you previously saved your data in native files (with extension 1d) you dont have to do anything. Real Cut 1D knows how to load its [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-45","post","type-post","status-publish","format-standard","hentry","category-real-cut-1d"],"_links":{"self":[{"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/45","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=45"}],"version-history":[{"count":3,"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions"}],"predecessor-version":[{"id":47,"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/45\/revisions\/47"}],"wp:attachment":[{"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=45"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=45"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/optimalprograms.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=45"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}