Actual Problems in Machine Building 2015 No. 2

Actual Problems in Machine Building. 2015. N 2 Innovative Technologies in Mechanical Engineering ____________________________________________________________________ 190 INTEGRATION THE DATABASES LOTSMAN: PLM AND 1C UPP FOR AUTOMATED PREPRODUCTION Semenova Ju. S. 1 , Ph.D. (Engineering), Associate Professor, e-mail: nahat@yandex.ru Plitenetsky D. A. 1 , Student, e-mail: denisalekseevich201191@gmail.com Egorychev A. V. 2 , Part-programming Engineer 1 Novosibirsk State Technical University, 20 Prospect K. Marksa, Novosibirsk, 630073, Russian Federation 2 LC “PKF Teplodar”, 125/1 Bogdana Khmelnitskogo st., Novosibirsk, 630027, Russian Federation Abstract The article describes how to automate the preparation of production with the use of VERTICAL, LOTSMAN: PLM and 1C:manufacturing in terms of production engineering. The possibility of merging databases 1C:manufacturing and LOTSMAN: PLM, automated mapping process and attaching them to the existing range of parts in the database 1C:manufacturing are also considered. An analysis of the used parameters for the two databases is made. Typical tasks associated with the ambiguity of the terms used in various software products are described. Problems of functional coordination of two databases are revealed. Possible errors leading to failures in joint program operation and affecting the correctness of the valuation of material costs and time for manufacturing a unit of product as well as errors affecting proper planning of equipment workload are considered. Keywords database LOTSMAN: PLM, database 1C: manufacturing, VERTICAL, automation, item, manufacturing process, SQL query.