{"id":591,"date":"2022-06-01T11:42:49","date_gmt":"2022-06-01T10:42:49","guid":{"rendered":"https:\/\/www.fastseal.eu\/blog\/?p=591"},"modified":"2026-11-09T15:07:15","modified_gmt":"2026-11-09T15:07:15","slug":"import-compounds","status":"publish","type":"post","link":"https:\/\/fastseal.eu\/blog\/import-compounds\/","title":{"rendered":"Import compounds\/materials"},"content":{"rendered":"\n

It is possible to import components directly to the components database from a CSV file, that is a standard approach for interchanging data between systems. The import\/export functions are located on the components database:<\/p>\n\n\n

\n
\"\"<\/figure>\n<\/div>\n\n\n

In order to use the import function the input file must follow some rules as the import data must match what is expected to be received.<\/p>\n\n\n\n

Example of a valid CSV to import:<\/p>\n\n\n\n

BrandName,BrandDescription,UserDesignation,BrandDesignation,Type,SubTypeID,inside,outside,insideUseful,outsideUseful,length,price,usefulLength,reference,profit,polygonFaces,stockQuantity,stockDesired,stockAutomatic
\"FastSeal\",\"\",\"POM\",\"POM\",\"Plastic\",\"1\",\"18\",\"155\",\"20\",\"150\",\"155\",\"100\",\"140\",\"20.150.155\",\"50\",\"0\",\"0.925357142857143\",\"1\",\"1\"
\"FastSeal\",\"\",\"POM\",\"POM\",\"Plastic\",\"1\",\"25\",\"207.9\",\"30\",\"180\",\"155\",\"100\",\"140\",\"30.180.155\",\"50\",\"6\",\"1\",\"1\",\"1\"
\"FastSeal\",\"\",\"EPDM 85ShA\",\"EPDM 85ShA\",\"Rubber\",\"5\",\"3\",\"155\",\"5\",\"150\",\"155\",\"100\",\"140\",\"5.150.155\",\"50\",\"0\",\"0.905028571428571\",\"3\",\"1\"
\"FastXRing\",\"FastXRing - sub company of FastSeal\",\"LPU\",\"LPU\",\"PU\",\"4\",\"36\",\"63\",\"37\",\"62\",\"155\",\"24\",\"140\",\"37.62.155\",\"20\",\"0\",\"40\",\"5\",\"0\"<\/pre>\n\n\n\n
The columns description are:<\/p>\n\n\n\n
n<\/td>Column<\/td>Description<\/td><\/tr>
1<\/td>BrandName<\/td>Brand<\/strong> name, for example “FastSeal” – affects the brand table<\/td><\/tr>
2<\/td>BrandDescription<\/td>Brand<\/strong> description, for example “Good brand” – affects the brand table. If more than one description is set for the same brand, only the first occurrence will be taken in account.<\/td><\/tr>
3<\/td>UserDesignation<\/td>User designation of a product, for example “HPU Red Premium”. Should correspond to the name that the product is known on your company – affects the products<\/strong> table<\/td><\/tr>
4<\/td>BrandDesignation<\/td>Brand designation, for example “HPU Red | FDA”. Should correspond to the name that your supplier calls to this product – affects the products<\/strong> table<\/td><\/tr>
5<\/td>Type<\/td>Must be one of the following words: PU, RUBBER, PTFE, PLASTIC or METAL- affects the products<\/strong> table<\/td><\/tr>
6<\/td>SubTypeID<\/td>The sub type ID that matches the ID present on the material types window Compounds database \u2013 subtypes<\/a>. If the sub type does not exist it will not be set (will remain without a subproduct)<\/td><\/tr>
7<\/td>inside<\/td>Tube measured inside dimension (mm). Must be equal or smaller than inside useful – affects Materials<\/strong> table<\/td><\/tr>
8<\/td>outside<\/td>Tube measured outside dimension (mm). Must be equal or greater than outside useful – affects Materials<\/strong> table<\/td><\/tr>
9<\/td>inside useful<\/td>Tube inside useful dimension (mm) normally matches the sticker on the tube – affects Materials<\/strong> table<\/td><\/tr>
10<\/td>outside useful<\/td>Tube outside useful dimension (mm) normally matches the sticker on the tube – affects Materials<\/strong> table<\/td><\/tr>
11<\/td>length<\/td>Tube length (mm) – affects Materials<\/strong> table<\/td><\/tr>
12<\/td>price<\/td>Cost of tube in local currency – affects Materials<\/strong> table<\/td><\/tr>
13<\/td>useful length<\/td>Tube useful length (mm). Must be smaller than the tube length – affects Materials<\/strong> table<\/td><\/tr>
14<\/td>reference<\/td>Raw material reference (normally describes the useful dimensions) – affects Materials<\/strong> table<\/td><\/tr>
15<\/td>profit<\/td>Required profit in % (50 means 50%) – affects Materials<\/strong> table<\/td><\/tr>
16<\/td>polygonFaces<\/td>Number of faces. 0 for rods and tubes, 4 for squares, 6 for hexagons and 8 for octagonal shapes – affects Materials<\/strong> table<\/td><\/tr>
17<\/td>stockQuantity<\/td>Numeric value that reflects the quantity in stock (integer or decimals numbers are possible). For example 1.2; 0.3; 0.33332; 4 are all valid numbers – affects Materials<\/strong> table<\/td><\/tr>
18<\/td>stockDesired<\/td>Integer value that represents the number of tools that is the desired stock – affects Materials<\/strong> table<\/td><\/tr>
19<\/td>stockAutomatic<\/td>This column can only have the value 0 or 1. Set to 1 if the software will manage this stock quantity or set to 0 if no change on the stock will be made by the software<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
Rules:<\/p>\n\n\n\n