190 / 460
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.ruPlitenetsky D. A.
1
, Student, e-mail:
denisalekseevich201191@gmail.comEgorychev 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.