IFNULL(GET_BEZNR_FOR_KEY_TABLE(80, T120.MOTART, '') AS `MOTART`, IFNULL(T120.TANKINHALT, '') AS `TANKINHALT`, IFNULL(T120.CCMSTEUER, '') AS `CCMSTEUER`, GET_LBEZNR(T120.LBEZNR, AS TYPE, - NAME TYPE GET_LBEZNR(T110.LBEZNR, AS MODEL, - NAME MODEL GET_LBEZNR(T100.LBEZNR, AS MANUFACTURER, - NAME MANUFACTURER SET - SELECTED TYPE CAR "VOLVO V70 III (BW) 2.5 T " List products according selected trade group for selected vehicle Generate list trade groups for selected vehicleĥ.6. List products according selected category in tree categories for selected vehicleĥ.5. Generate tree categories for selected vehicleĥ.4. List products that use for selected vehicleĥ.3. List type of vehicles where use productĥ.2. Accessories that need use for product (list products that not included in main product, but products that need or preferably for use parallel)ĥ.1. Specification kit products or searching entry into kitsĤ.12. Cross reference for product (advanced view - searching regarding own oe-numbers for search product and searching other products where use search product)Ĥ.11. Cross reference for product (own info from supplier)Ĥ.7. Search by artnumber - checking name of brands that use this search numberĤ.6.
Tecdoc code#
Seraching by code engine (list vehicles where use engine)Ĥ.2. Searching by Ktype and get Ktype value regarding value KBA, TypeMine, LicensePlate (in case available those tables in your data)ģ.5. Choosing a manufacturer of car (with the possibility of separation on year, passenger, truck, motocycle and commercial vehicle)ģ.4. Selecting the desired region or country (in case available divided regions in your data)ģ.1. You will get file with description all necessary queries for create catalog on e-shopĢ. Help in prepare queries for work with TAF dataīUY description common queries BUY description common queries ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List suppliers with header stating version and date' Īdditional services for work with Tecdoc TAF data for MySQL `LOSCH_FLAG` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = Delete all data records of the brand, otherwise ‘0’', `FORMAT` varchar(3) NOT NULL DEFAULT '2.5' COMMENT 'Constant “2.5”', `VORVERSION` mediumint(4) DEFAULT NULL COMMENT 'If a delta-delivery, the Data Release to which the delta refers.', `REFERENZDATEN` mediumint(4) NOT NULL COMMENT 'Reference data version in the format xxyy', `MARKE` varchar(20) NOT NULL COMMENT 'Brand (specified by TecDoc)', `KHERNR` mediumint(6) NOT NULL COMMENT 'Vehicle Manufacturer Number ', `KZVOLL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '‘1’ when complete delivery, otherwise ‘0’', `DATUM` int(8) NOT NULL COMMENT 'Version date in the format YYYYMMDD', `DATA_RELEASE` smallint(4) NOT NULL COMMENT 'Version (Data Release) in the format xxyy', `SA` smallint(3) NOT NULL DEFAULT '1' COMMENT 'Data Table Constant = 001 ', `DLNR` smallint(4) NOT NULL COMMENT 'Data Supplier Number Constant (-> 100)', SQL script for create 103 tables (tables structure are according documentation Tecdoc) in Mysql database. You can choose any necessary for you payment way, as result order will same product(s)īUY file BUY file In this case can will difference in pay with help PayPal (higher price) or simple payment with help Credit|Debit Card (lower price). *** - some products in our offer list use two different prices. The most longest way :) What can we offer you ? For example : ***
Tecdoc how to#
Of the tables from the documentation, create these tables in the database and create his own conversion tool.Īfter filling in the tables, new questions will begin - how to work with these 103 tables. Then he will be faced with many tasks and questions in working with such data, which will take some time and your finances.įirst, he will have to find a way to convert the data to the desired format, for which he will need to study the structure The most difficult way when the programmer has not yet worked with Tecdoc data. Hire a programmer from development companies. You can try to contact partners directly,īut not all countries have regional partners, and also after a request, you can fall in a long line for the opportunity to fulfill your tasks and needs. Hire a programmer who is partners with TecAlliance in integrating their data. Then you have a question about - how to convert these files into a format that is easy to view as like CSV or MYSQL formats ? And how to integrate this data into an existing or new e-store ? And here everyone is faced with several ways
Tecdoc update#
If you owner subscription in TecAlliance to update TecDoc TAF 2.6(include 2.4 and 2.5) data that is hundreds or even thousands of binari files (depending on the number of brands in your subscription), Tool for convert "Tecdoc TAF Data" to CSV|SQL format.
0 kommentar(er)
