{"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":"2024-04-16T14:48:18","modified_gmt":"2024-04-16T13:48:18","slug":"import-compounds","status":"publish","type":"post","link":"https:\/\/fastseal.eu\/blog\/import-compounds\/","title":{"rendered":"Import compounds"},"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\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

name,description,reference,material,type,inside,outside,insideUseful,outsideUseful,length,price,usefulLength,reference1,profit,polygonFaces,stockQuantity,stockDesired,stockAutomatic
\"All\",\"internal use only\",,,,,,,,,,,,,,,,
\"FastSeal\",\"Default HPU brand\",\"HPU Red Premium\",\"HPU Red | FDA\",\"PU\",\"0\",\"25.2\",\"0\",\"25\",\"150\",\"2.89\",\"120\",\"0.25.150\",\"200\",\"0\",\"3.2\",\"4\",\"1\"
\"FastSeal\",\"Default HPU brand\",\"HPU Red Premium\",\"HPU Red | FDA\",\"PU\",\"0\",\"46\",\"0\",\"46\",\"150\",\"25.5\",\"120\",\"0.46.150\",\"50\",\"0\",\"1.4\",\"30\",\"1\"<\/pre>\n\n\n\n
The columns description are:<\/p>\n\n\n\n
Column number<\/td>Description<\/td><\/tr>
1 – name<\/td>Brand<\/strong> name, for example “FastSeal” – affects the brand table<\/td><\/tr>
2 – Description<\/td>Brand<\/strong> description, for example “Good brand” – affects the brand table<\/td><\/tr>
3 – Reference<\/td>User designation of a product, for example “HPU Red Premium” – affects the products<\/strong> table<\/td><\/tr>
4 – Material<\/td>Brand designation, for example “HPU Red | FDA” – affects the products<\/strong> table<\/td><\/tr>
5 – Type<\/td>Must be one of the following words: PU, RUBBER, PTFE or PLASTIC – affects the products<\/strong> table<\/td><\/tr>
6 – inside<\/td>Tube measured inside dimension (mm). Must be equal or smaller than inside useful – Materials table<\/td><\/tr>
7 – outside<\/td>Tube measured outside dimension (mm). Must be equal or greater than outside useful – Materials table<\/td><\/tr>
8 – inside useful<\/td>Tube inside useful dimension (mm) normally matches the sticker on the tube – Materials table<\/td><\/tr>
9 – outside useful<\/td>Tube outside useful dimension (mm) normally matches the sticker on the tube – Materials table<\/td><\/tr>
10 – length<\/td>Tube length (mm) – Materials table<\/td><\/tr>
11 – price<\/td>Cost of tube in local currency – Materials table<\/td><\/tr>
12 – useful length<\/td>Tube useful length (mm). Must be smaller than the tube length – Materials table<\/td><\/tr>
13 – reference1<\/td>Material reference – Materials table<\/td><\/tr>
14 – profit<\/td>Required profit in % (50 means 50%) – Materials table<\/td><\/tr>
15 – polygonFaces<\/td>Number of faces (metal items). For seals leave as 0 – Hidden<\/td><\/tr>
16 – 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<\/td><\/tr>
17 – stockDesired<\/td>Integer value that represents the number of tools that is the desired stock.<\/td><\/tr>
18 – 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