Нужна помощь

pavelipavel
Дата: 16.03.2012 23:12:54
Необходима помощь в создании запросов для TECDOC. Помощь будет оплачена 8)
ICQ - 55420218, 377499370
skype: bushalin
pavelipavel
Дата: 18.03.2012 21:25:05
Какие таблицы надо экспортировать в mysql?

TB_AD_AD
TB_AD_ADADDTEXT_TXT
TB_AD_ADQUANTITY
TB_AD_ADQUANTITY_TXT
TB_AD_ADVALUE
TB_AD_ADVALUE_TXT
TB_AD_TYPEVALUECOL
TB_AD_VALUECOUNTRYRESTRICTION
TB_APPLICATION_PARAMETER
TB_APPLICATION_TEXT_TXT
TB_COO_FINISH
TB_COO_QUALCOL_RULES
TB_FINISHEDTYPE
TB_IMAGE
TB_IMAGES
TB_IMAGE_TXT
TB_ITEMMPID_GENART
TB_LT_COUNTRYFACTOR
TB_LT_KOR_TXT
TB_LT_LT
TB_LT_LTCBODETAILS
TB_LT_LTCBOTYPE
TB_LT_LTEXCLUDECOUNTRY
TB_LT_LTEXCLUDEPARTITEM
TB_LT_LTEXCLUSIVE
TB_LT_LTINCLUSIVE
TB_LT_WORKPOS
TB_MD_ASSOCITEMS
TB_MD_FORMATS
TB_MD_TEXTITEMMP
TB_MD_WORKADDON
TB_PART_PART
TB_QUAL_QUAL_TXT
TB_SEARCHQUALCOLGR_TXT
TB_SEARCHQUALCOLID_QUALID
TB_SEARCH_QUALID_TXT
TB_TM_AUTOTYPEMANUALS
TB_TM_BLOCKCONTENT
TB_TM_ERRORCODETABLECONTENT
TB_TM_FORMATS
TB_TM_FUELTYPEID
TB_TM_LTCONTENT
TB_TM_MANUAL
TB_TM_MANUALLANGUAGES
TB_TM_PANELS
TB_TM_TABLECONTENT
TB_TM_TABLES
TB_TM_TEXTS
TB_TM_TEXTS_TXT
TB_TM_TYPEMANUALS
TB_TOPIC_ITEMLT_ITEMAD
TB_TOPIC_ITEMLT_ITEMADFILL
TB_TOPIC_ITEMLT_ITEMADSPEC
TB_TOPIC_ITEMLT_ITEMTM
TB_TOPIC_ITEMMP
TB_TOPIC_ITEMMPMANUFACTURER
TB_TOPIC_ITEMMP_TXT
TB_TOPIC_MAINGR
TB_TOPIC_MAINGRSUBGR
TB_TOPIC_MAINGR_TXT
TB_TOPIC_MANUFACTURER
TB_TOPIC_STOCKITEMS
TB_TOPIC_SUBGR
TB_TOPIC_SUBGRITEM
TB_TOPIC_SUBGR_TXT
TB_TOPIC_VISIBLEFORMODUL
TB_TREEADDINFO
TB_TREEADDINFODCR
TB_TREEADDINFOKEY
TB_TREEADDINFOTEXT
TB_TREECLASSADDINFO
TB_TREECLASSES
TB_TREECOUNTRY
TB_TREECOUNTRY_TXT
TB_TREEEXTTCDREFERENCE
TB_TREELANGUAGES
TB_TREELANGUAGES_TXT
TB_TREEMAKE
TB_TREEMAKETEXT
TB_TREERANGE
TB_TREERANGETEXT
TB_TREERESTRICTION
TB_TREETYPE
TB_TREETYPECOMPONENT
TB_TREETYPETEXT
TB_TREE_BUILDYEARVINPATTERN
TB_TREE_BUILDYEARVINPATTERNTOLERANCE
TB_TREE_COMPONENTVINPATTERN
TB_TREE_MAKEVINPATTERN
TB_TREE_RANGEVINPATTERN
TB_TREE_TYPEVINBUILDINFO
TB_TREE_TYPEVINPATTERN
TB_TREE_VINPATTERN
TB_VEHICLE_DATA
DUAL
TOF_ACCESSORY_LISTS
TOF_ACL_COUNTRY_QUANTITIES
TOF_ACL_CRITERIA
TOF_ALI_COORDINATES
TOF_ALI_COUNTRY_QUANTITIES
TOF_ARTICLES
TOF_ARTICLES_NEW
TOF_ARTICLE_CRITERIA
TOF_ARTICLE_INFO
TOF_ARTICLE_LISTS
TOF_ARTICLE_LIST_CRITERIA
TOF_ARTICLE_USER_NOTES
TOF_ARTICLE_USER_NOTES_IMP
TOF_ART_COUNTRY_SPECIFICS
TOF_ART_LOOKUP
TOF_AXLES
TOF_AXLES_HISTORIES
TOF_AXL_BRAKE_SIZES
TOF_AXL_WHEEL_BASES
TOF_BRANDS
TOF_CAB_COUNTRY_SPECIFICS
TOF_CONNECTIONS
TOF_CONST_PATTERN_LOOKUP
TOF_COUNTRIES
TOF_COUNTRY_DESIGNATIONS
TOF_CRITERIA
TOF_CV_CABS
TOF_CV_MARKS
TOF_CV_SECONDARY_TYPES
TOF_DESIGNATIONS
TOF_DES_TEXTS
TOF_DOC_TYPES
TOF_ENGINES
TOF_ENGINE_HISTORIES
TOF_ENG_COUNTRY_SPECIFICS
TOF_ENG_LOOKUP
TOF_ERR_TRACK_KEY_VALUES
TOF_FILTERS
TOF_GENERIC_ARTICLES
TOF_GRAPHICS
TOF_GRA_DATA_0
TOF_GRA_DATA_1
TOF_GRA_DATA_10
TOF_GRA_DATA_11
TOF_GRA_DATA_12
TOF_GRA_DATA_13
TOF_GRA_DATA_14
TOF_GRA_DATA_15
TOF_GRA_DATA_16
TOF_GRA_DATA_17
TOF_GRA_DATA_18
TOF_GRA_DATA_19
TOF_GRA_DATA_2
TOF_GRA_DATA_20
TOF_GRA_DATA_21
TOF_GRA_DATA_22
TOF_GRA_DATA_23
TOF_GRA_DATA_24
TOF_GRA_DATA_25
TOF_GRA_DATA_26
TOF_GRA_DATA_27
TOF_GRA_DATA_28
TOF_GRA_DATA_29
TOF_GRA_DATA_3
TOF_GRA_DATA_30
TOF_GRA_DATA_4
TOF_GRA_DATA_5
TOF_GRA_DATA_6
TOF_GRA_DATA_7
TOF_GRA_DATA_8
TOF_GRA_DATA_9
TOF_HELP_MAPPINGS
TOF_KEY_VALUES
TOF_LANGUAGES
TOF_LA_CRITERIA
TOF_LA_INFO
TOF_LINK_ART
TOF_LINK_ART_GA
TOF_LINK_CAB_TYP
TOF_LINK_GA_CRI
TOF_LINK_GA_STR
TOF_LINK_GRA_ART
TOF_LINK_GRA_LA
TOF_LINK_LA_AXL
TOF_LINK_LA_AXL_NEW
TOF_LINK_LA_ENG
TOF_LINK_LA_ENG_NEW
TOF_LINK_LA_MRK
TOF_LINK_LA_MRK_NEW
TOF_LINK_LA_TYP
TOF_LINK_LA_TYP_NEW
TOF_LINK_SHO_STR
TOF_LINK_SHO_STR_TYPE
TOF_LINK_TYP_AXL
TOF_LINK_TYP_ENG
TOF_LINK_TYP_MRK
TOF_MANUFACTURERS
TOF_MODELS
TOF_MOD_TYP_LOOKUP
TOF_NATCODES_AUSTRIA
TOF_NATCODES_CH
TOF_NUMBERPLATES_NL
TOF_NUMBERPLATES_S
TOF_PARAMETERS
TOF_PRICES
TOF_PRICES_IMPORT
TOF_RETAIL_FILTERS
TOF_RETAIL_FILTER_IMPORT
TOF_SEARCH_HISTORIES
TOF_SEARCH_TREE
TOF_SEARCH_TREE_FILTERS
TOF_SHOPPING_BASKETS
TOF_SHOPPING_BASKET_AUDACON
TOF_SHOPPING_LISTS
TOF_SHOPPING_LISTS_IMP
TOF_SHORTCUTS
TOF_STR_FAMILY_TREE
TOF_STR_LOOKUP
TOF_SUPERSEDED_ARTICLES
TOF_SUPPLIERS
TOF_SUPPLIER_ADDRESSES
TOF_SUPPLIER_LOGOS
TOF_SUPPRESSED_MESSAGES
TOF_TECSEL_DEALERS
TOF_TECSEL_LINK_USER_SALE
TOF_TECSEL_PRICES
TOF_TECSEL_PRICE_IMPORT
TOF_TECSEL_SALE_ADDRESSES
TOF_TEXT_MODULES
TOF_TEXT_MODULE_TEXTS
TOF_TRANS_CONTROLS
TOF_TRANS_IS_PART_OF
TOF_TRANS_TERMS
TOF_TRANS_TRANSLATIONS
TOF_TRANS_UNITS
TOF_TRANS_USED_TRANSLATION
TOF_TYPES
TOF_TYPE_NUMBERS
TOF_TYP_COUNTRY_SPECIFICS
TOF_TYP_SUSPENSIONS
TOF_TYP_VOLTAGES
TOF_TYP_WHEEL_BASES
TOF_USER_ERROR_REPORTS
TOF_USER_ERROR_REPORTS_IMP
TOF_USER_SETTINGS
TOF_USER_UPDATES
TOF_UTILITY_DIRECT
TOF_VEHICLE_HISTORIES
TUP_PACKAGE_LOG
TUP_STEP_LOG
TUP_SUBSTEP_LOG
Злой Бобр
Дата: 18.03.2012 22:21:03
pavelipavel,

Воспользуйся поиском по форуму. Тут есть предложения экспорта в несколько форматов. )))
iscrafm
Дата: 18.03.2012 23:49:56
pavelipavel
Какие таблицы надо экспортировать в mysql?

с 8-й по 2-ю
pavelipavel
Дата: 19.03.2012 11:07:53
iscrafm
с 8-й по 2-ю


Это прикол такой?
pavelipavel
Дата: 19.03.2012 11:10:41
Злой Бобр
Воспользуйся поиском по форуму. Тут есть предложения экспорта в несколько форматов. )))


Экспортировать я могу в любой формат. Я написал программу на DELPHI, которая делает экспорт в любой формат и вытаскивает фотографии.

У меня вопросы по дальнейшему использованию данных. Как сформировать запросы, чтобы получить схему вида:

Производитель - модель - модификация - рубрикатор запчастей - запчасть - номер - неоригинальные номера.