WE OFFER FREE SERVICE FOR CONVERT YOUR TECDOC DATA IN FORMAT CSV TABLES OR MYSQL SCRIPTS
Tecdoc Data Format
The collection and processing of vehicle and product data for the automotive market is the core business of TecAlliance. They get the data from the spare parts manufacturers in the sector. Every quarter they review and evaluate all the supplied data according to defined criteria. The results are fed back to the parts manufacturers for continuous quality improvement. Those data suppliers who meet the appropriate requirements at a very high level are awarded the “TecAlliance Certified Data Supplier” seal of quality. The TecDoc data suppliers provide high-quality spare parts data in a uniform format using our global “TecDoc Standard”.
Kit all tables (according to customer subscription with Tecdoc). Kit divided on two parts : Reference data (data of vehicles, axles, engines and other reference data) and Product data (data that providing suppliers data).
Kit tables that include only updated data are placed in separate folders with data for tables that is changed relatively previous version data. In this case delta tables have additional column "DELTA" where can will values 0/1 :
0 => need delete this line in your previous converted data (when was that in previous version data was errror in this line or this line was wrong), 1 => data this line need change for previous converted data (according new data) or this line is new relatively previous version data.
If you owner subscription in TecAlliance to update TecDoc TAF 2.4 data that is hundreds or even thousands of binari files (depending on the number of brands in your subscription), 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 ?
- Hire a programmer who is partners with TecAlliance in integrating their data. The most expensive way. You can try to contact partners directly,
but 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 from development companies. The most difficult way when the programmer has not yet worked with Tecdoc data. Then he will be faced with many tasks and questions in working with such data, which will take some time and your finances. First, he will have to find a way to convert the data to the desired format, for which he will need to study the structure of the tables from the documentation, create these tables in the database and create his own conversion tool. After filling in the tables, new questions will begin - how to work with these 103 tables.
- Hire a programmer to own staff. The most longest way :)
SQL script for create 103 tables (tables structure are according documentation Tecdoc) in Mysql database. All fields and tables use description.
Sample query for create table `001`
CREATE TABLE IF NOT EXISTS `001` ( `DLNR` smallint(4) NOT NULL COMMENT 'Data Supplier Number Constant (-> 100)', `SA` smallint(3) NOT NULL DEFAULT '1' COMMENT 'Data Table Constant = 001 ', `DATA_RELEASE` smallint(4) NOT NULL COMMENT 'Version (Data Release) in the format xxyy', `DATUM` int(8) NOT NULL COMMENT 'Version date in the format YYYYMMDD', `KZVOLL` tinyint(1) NOT NULL DEFAULT '0' COMMENT '‘1’ when complete delivery, otherwise ‘0’', `KHERNR` mediumint(6) NOT NULL COMMENT 'Vehicle Manufacturer Number ', `MARKE` varchar(20) NOT NULL COMMENT 'Brand (specified by TecDoc)', `REFERENZDATEN` mediumint(4) NOT NULL COMMENT 'Reference data version in the format xxyy', `VORVERSION` mediumint(4) DEFAULT NULL COMMENT 'If a delta-delivery, the Data Release to which the delta refers.', `FORMAT` varchar(3) NOT NULL DEFAULT '2.4' COMMENT 'Constant “2.4”', `LOSCH_FLAG` tinyint(1) NOT NULL DEFAULT '0' COMMENT '1 = Delete all data records of the brand, otherwise ‘0’', PRIMARY KEY `DLNR` (`DLNR`), KEY `KHERNR` (`KHERNR`), KEY `MARKE` (`MARKE`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='List suppliers with header stating version and date';
SAMPLE QUERY FROM FILE -- SHOW INFO PASSANGER CAR SET @SPRACHNR=4; -- SELECTED ID LANG (ENGLISH) SET @KTYPNR=23150; -- SELECTED TYPE CAR "VOLVO V70 III (BW) 2.5 T [200708 - 200912]" SELECT T120.KTYPNR AS `KTYPNR`, GET_LBEZNR(T100.LBEZNR, @SPRACHNR) AS MANUFACTURER, -- NAME MANUFACTURER GET_LBEZNR(T110.LBEZNR, @SPRACHNR) AS MODEL, -- NAME MODEL GET_LBEZNR(T120.LBEZNR, @SPRACHNR) AS TYPE, -- NAME TYPE T120.BJVON AS `BJVON`, IFNULL(T120.BJBIS, 'to now') AS `BJBIS`, IFNULL(T120.KW, '') AS `KW`, IFNULL(T120.PS, '') AS `PS`, IFNULL(T120.CCMSTEUER, '') AS `CCMSTEUER`, IFNULL(T120.CCMTECH, '') AS `CCMTECH`, IFNULL(T120.LIT, '') AS `LIT`, IFNULL(T120.ZYL, '') AS `ZYL`, IFNULL(T120.TUEREN, '') AS `TUEREN`, IFNULL(T120.TANKINHALT, '') AS `TANKINHALT`, IFNULL(T120.SPANNUNG, '') AS `SPANNUNG`, IFNULL((CASE WHEN T120.ABS = 0 THEN 'NO' WHEN T120.ABS = 1 THEN 'YES' WHEN T120.ABS = 2 THEN 'OPTIONAL' WHEN T120.ABS = 9 THEN 'UNKNOWN' ELSE NULL END), '') AS `ABS`, IFNULL((CASE WHEN T120.ASR = 0 THEN 'NO' WHEN T120.ASR = 1 THEN 'YES' WHEN T120.ASR = 2 THEN 'OPTIONAL' WHEN T120.ASR = 9 THEN 'UNKNOWN' ELSE NULL END), '') AS `ASR`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(80, T120.MOTART, @SPRACHNR), '') AS `MOTART`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(97, T120.KRAFTSTOFFAUFBEREITUNGSPRINZIP, @SPRACHNR), '') AS `KRAFTSTOFFAUFBEREITUNGSPRINZIP`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(82, T120.ANTRART, @SPRACHNR), '') AS `ANTRART`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(83, T120.BREMSART, @SPRACHNR), '') AS `BREMSART`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(84, T120.BREMSSYS, @SPRACHNR), '') AS `BREMSSYS`, IFNULL(T120.VENTILE_BRENNRAUM, '') AS `VENTILE_BRENNRAUM`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(182, T120.KRSTOFFART, @SPRACHNR), '') AS `KRSTOFFART`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(89, T120.KATART, @SPRACHNR), '') AS `KATART`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(85, T120.GETRART, @SPRACHNR), '') AS `GETRART`, IFNULL(GET_BEZNR_FOR_KEY_TABLE(86, T120.AUFBAUART, @SPRACHNR), '') AS `AUFBAUART`, IFNULL((SELECT GROUP_CONCAT(DISTINCT T155.MCODE SEPARATOR ', ') FROM `125` AS T125 JOIN `155` AS T155 ON T155.MOTNR = T125.MOTNR WHERE T125.KTYPNR = T120.KTYPNR), '') AS LISTENGINES FROM `120` AS T120 JOIN `110` AS T110 ON T110.KMODNR = T120.KMODNR JOIN `100` AS T100 ON T100.HERNR = T110.HERNR WHERE T120.KTYPNR = @KTYPNR;- Personal help for work with Tecdoc TAF data Ask HELP
OWN_BRAND_NAME - name brand for new product OWN_ARTNUMBER - artnumber for new product TECDOC_BRAND (or OE_BRAND) - name brand for product that is analog for new product (aftermarket brand or original brand) TECDOC_ARTNUMBER (or OE_NUMBER) - artnumber analog product DOC_PATH(S) - URL path to image(s) or other file(s) for new product. In case several URLs need use separator ";"and our service automaticaly find necessary data which will substitute all necessary info for new products. In this case if you use on own e-shop the base Tecdoc TAF 2.4 data then will no problems for import products new brand that not available in Tecdoc catalog.