FREE TECDOC TAF CONVERTOR

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”.

Description Tecdoc Data Format
Go to CLIENT AREA
More info about tool for convert
Ask about integrate converted data in your shop

GENERAL DATA

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).

DATA UPDATES (DELTAS)

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.

Tool for convert "Tecdoc TAF Data" to CSV|SQL format. Addiitonal services for work with 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 ?

And here everyone is faced with several ways

- 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 :)

What can we offer you ? For example : ***

FREE web service for convert binary Tecdoc TAF files in CSV (Excel file) or SQL format (for import to Mysql)
Go to CLIENT AREA
FREE and Full automatization way to move, prepare and convert binary Tecdoc files in necessary CSV|SQL format

Converting tool "TAFConvertor" for own use. For convert Tecdoc TAF files to CSV or MYSQL format
*** - some products in our offer list use two different prices. In this case can will difference in pay with help PayPal (higher price) or simple payment with help Credit|Debit Card (lower price). You can choose any necessary for you payment way, as result order will same product(s)
API use tool BUY tool [200 EUR] BUY tool [250 EUR - PayPal]
Included with the program are : INI-files tables structure, SQL script for create tables in Mysql database, CMD-script with menu for automatically convert files, CMD-script for automatization import converted data to Mysql, CMD-script for unzipping PIC|DOC-files and moving in necessary folders.
Note : functionality "FREE web service" working on based this tool.

INI-files with short description structure tables that use with tool "TAFConvertor"
FREE download
Files with short description of tables structure. Files use with convertor "TAFConvertor"

Tables structure for MySql
*** - some products in our offer list use two different prices. In this case can will difference in pay with help PayPal (higher price) or simple payment with help Credit|Debit Card (lower price). You can choose any necessary for you payment way, as result order will same product(s)
BUY file [50 EUR] BUY file [75 EUR - PayPal]

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';

Additional services for work with Tecdoc TAF data for MySQL
*** - some products in our offer list use two different prices. In this case can will difference in pay with help PayPal (higher price) or simple payment with help Credit|Debit Card (lower price). You can choose any necessary for you payment way, as result order will same product(s)
- Help in prepare queries for work with TAF data
BUY description common queries [100 EUR] BUY description common queries [150 EUR - PayPal]
You will get file with description all necessary queries for create catalog on e-shop

Kit queries included :

1. Selecting the desired language
2. Selecting the desired region or country (in case available divided regions in your data)
3. Work with cars
3.1. Choosing a manufacturer of car (with the possibility of separation on year, passenger, truck, motocycle and commercial vehicle)
3.2. Choosing a model of car
3.2. Choosing a type of car
3.3. Show info about selected car
3.4. Searching by Ktype and get Ktype value regarding value KBA, TypeMine, LicensePlate [Swiss, Netherland, Swedish, Austrian] (in case available those tables in your data)
3.5. Seraching by code engine (list vehicles where use engine)
3.6. Show info about engine
4. Work with products
4.1. Show available suppliers
4.2. Search by artnumber - checking name of brands that use this search number
4.3. Main info of product
4.4. Cryteries of product
4.5. Additional info of product
4.6. Cross reference for product (own info from supplier)
4.7. Cross reference for product (advanced view - searching regarding own oe-numbers for search product and searching other products where use search product)
4.8. Applicability to vehicles
4.9. Terms of use product for vehicle
4.10. Images and other links for product
4.11. Specification kit products or searching entry into kits
4.12. Accessories that need use for product (list products that not included in main product, but products that need or preferably for use parallel)
5. Creating catalog
5.1. List type of vehicles where use product
5.2. List products that use for selected vehicle
5.3. Generate tree categories for selected vehicle
5.4. List products according selected category in tree categories for selected vehicle
5.5. Generate list trade groups for selected vehicle
5.6. List products according selected trade group for selected vehicle

	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

GENERATOR TecDoc TAF 2.4 files for own products
Go to CLIENT AREA BUY|EXTEND use web service [xxx UER]
Web service for possibility generate binary files according Tecdoc TAF 2.4 structure for suppliers that are not available in Tecdoc. Need only prepare table with columns

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.