Home 
 1. Hardware Requirements 
 Database Server 
 Application Server (Temporary) 
 Application Server 
 Client Workstation 
 2. Software Requirements 
 Database Server 
 Application Server (Temporary 
 Application Server 
 Client Workstation 
 3. Software 
 Software used during installat...  
 Software installed for day-to-...  
 4. Working layout 
 5. Installation DB-Server 
 pdm_database.sql 
 pdm_tablespace.sql 
 pdm_user.sql 
 all_ix_ext.sql 
 alter_storage.sql 
 6. Installation of temporary appl...  
 Operating System 
 Preparation soft 
 DB-Drivers 
 USD 5.5.1 
 7. Adaptations on Application Ser...  
 Applying SP1 to USD Server 
 Applying patches to USD Server 
 Running PDM_Configure 
 Preparing data 
 Tools for importing data 
 Importing Data 
 Creation of "Form-groups" 
 USD Security 
 8. Installation Application Serve...  
 Operating system 
 Preparation soft 
 DB Drivers 
 USD 5.5.1 
 9. Adaptations on Application Ser...  
 Applying SP1 to USD Server 
 Applying patches to USD Server 
 Running PDM_Configure 
 Preparing data 
 Tools for importing data 
 Importing Data 
 Creation of "Form"-groups 
 USD Security 
 10. Installation Workstations 
 Operating System 
 Preparation soft 
 USD 5.5.1 
 11. Adaptations on Workstation 
 Applying SP1 to USd Workstatio...  
 Applying patches to USD Workst...  
 12. Database Customization 
 Specific procedures 
 Implemented changes on databas...  
 13. Import data in New Database 
 Procedure setup 
 Import Manufactures 
 Import Vendors 
 Import Models 
 Import Assets 
 14. Web interface 
 The four webinterfaces 
 Customizing Web Pages 
 Using the sitemods Directory o...  
 15. User management inside USD 
 New users 
 Modified Users - Part 1 
 Modified Users - Part 2 
 Usage of the "Check_Names" Uti...  
 Explanation of check "check_na...  
 Explanation of check "check_vm...  
 Explanation of check "check_se...  
 16. Asset Management 
 Installation of Workstation 
 Import new assets 
 Import New Assets (Bulk) 
 Inventory 
 Working on the Access file ASS...  
Import Models
Data transfer layout
graphic

Query
SELECT AHD_man.id AS Manuf, dbo_equipement!type+' '+dbo_equipement!modele AS Mod, dbo_equipement.part_number, dbo_equipement.categorie, dbo_equipement.sous_categorie
FROM AHD_man RIGHT JOIN dbo_equipement ON AHD_man.sym = dbo_equipement.constructeur
GROUP BY AHD_man.id, dbo_equipement!type+' '+dbo_equipement!modele, dbo_equipement.part_number, dbo_equipement.categorie, dbo_equipement.sous_categorie, dbo_equipement.constructeur
ORDER BY dbo_equipement.constructeur, dbo_equipement!type+' '+dbo_equipement!modele DESC;
Import text header
TABLE Manufacturer_Model
     mdl_mfr_id, mdl_sym
Top