© 1999-2013 EMS Database Management Solutions, Ltd.
Advanced Data Import VCL
User's Manual
All rights reserved.
This manual documents EMS Advanced Data Import VCL
No parts of this work may be reproduced in any form or by any means - graphic, electronic, or mechanical, including
photocopying, recording, taping, or information storage and retrieval systems - without the written permission of the
publisher.
Products that are referred to in this document may be either trademarks and/or registered trademarks of the
respective owners. The publisher and the author make no claim to these trademarks.
While every precaution has been taken in the preparation of this document, the publisher and the author assume no
responsibility for errors or omissions, or for damages resulting from the use of information contained in this
document or from the use of programs and source code that may accompany it. In no event shall the publisher and
the author be liable for any loss of profit or any other commercial damage caused or alleged to have been caused
directly or indirectly by this document.
Use of this documentation is subject to the following terms: you may create a printed copy of this documentation
solely for your own personal use. Conversion to other formats is allowed as long as the actual content is not altered
or edited in any way.
Document generated on: 25.10.2013
Advanced Data Import VCL
User's Manual
© 1999-2013 EMS Database Management Solutions, Ltd.
Advanced Data Import Component Suite for Delphi and C++ Builder - User's Manual3
© 1999-2013 EMS Database Management Solutions, Ltd.
Table of Contents
Part I Welcome to EMS Advanced Data Import!
10
...........................................................................................................................................10Suite Overview
...........................................................................................................................................11What's new
...........................................................................................................................................12Installation
...........................................................................................................................................14Registration
...........................................................................................................................................15How to register Advanced Data Import
...........................................................................................................................................16Version history
...........................................................................................................................................20Other EMS Products
Part II Advanced Data Import Component Suite
27
...........................................................................................................................................28TQImport3
.................................................................................................................................................................. 28TQImport3 Reference
.................................................................................................................................................................. 29Properties
.......................................................................................................................................................................... 30AddType
.......................................................................................................................................................................... 31AutoTrimValue
.......................................................................................................................................................................... 32Canceled
.......................................................................................................................................................................... 33CommitAfterDone
.......................................................................................................................................................................... 34CommitRecCount
.......................................................................................................................................................................... 35DataSet
.......................................................................................................................................................................... 36DBGrid
.......................................................................................................................................................................... 37ErrorLog
.......................................................................................................................................................................... 38ErrorLogFileName
.......................................................................................................................................................................... 39ErrorRecs
.......................................................................................................................................................................... 40Errors
.......................................................................................................................................................................... 41FieldFormats
.......................................................................................................................................................................... 42FileName
.......................................................................................................................................................................... 43Formats
.......................................................................................................................................................................... 44GridCaptionRow
.......................................................................................................................................................................... 45GridStartRow
.......................................................................................................................................................................... 46ImportDestination
.......................................................................................................................................................................... 47ImportedRecs
.......................................................................................................................................................................... 48ImportMode
.......................................................................................................................................................................... 49ImportRecCount
.......................................................................................................................................................................... 50KeyColumns
.......................................................................................................................................................................... 51LastAction
.......................................................................................................................................................................... 52ListView
.......................................................................................................................................................................... 53Map
.......................................................................................................................................................................... 54Rew riteErrorLogFile
.......................................................................................................................................................................... 55Show ErrorLog
.......................................................................................................................................................................... 56StringGrid
.................................................................................................................................................................. 57Methods
.......................................................................................................................................................................... 58Cancel
.......................................................................................................................................................................... 59Execute
.......................................................................................................................................................................... 60ImportToCSV
Advanced Data Import Component Suite for Delphi and C++ Builder - User's Manual4
© 1999-2013 EMS Database Management Solutions, Ltd.
.......................................................................................................................................................................... 61LoadConfiguration
.......................................................................................................................................................................... 62SaveConfiguration
.................................................................................................................................................................. 63Events
.......................................................................................................................................................................... 64OnAfterImport
.......................................................................................................................................................................... 65OnAfterPost
.......................................................................................................................................................................... 66OnBeforeImport
.......................................................................................................................................................................... 67OnBeforePost
.......................................................................................................................................................................... 68OnDestinationLocate
.......................................................................................................................................................................... 69OnImportCancel
.......................................................................................................................................................................... 70OnImportError
.......................................................................................................................................................................... 71OnImportRecord
.......................................................................................................................................................................... 72OnImportRow Complete
.......................................................................................................................................................................... 73OnNeedCommit
.......................................................................................................................................................................... 74OnUserDefinedImport
...........................................................................................................................................75TADO_QImport3Access
.................................................................................................................................................................. 75TADO_QImport3Access Reference
.................................................................................................................................................................. 76Properties
.......................................................................................................................................................................... 77SkipFirstRow s
.......................................................................................................................................................................... 78SourceType
.......................................................................................................................................................................... 79SQL
.......................................................................................................................................................................... 80TableName
...........................................................................................................................................81TQImport3ASCII
.................................................................................................................................................................. 81TQImport3ASCII Reference
.................................................................................................................................................................. 82Properties
.......................................................................................................................................................................... 83Comma
.......................................................................................................................................................................... 84Encoding
.......................................................................................................................................................................... 85SkipFirstRow s
.......................................................................................................................................................................... 86Map
.......................................................................................................................................................................... 87Quote
.................................................................................................................................................................. 88Events
...........................................................................................................................................89TQImport3DataSet
.................................................................................................................................................................. 89TQImport3DataSet Reference
.................................................................................................................................................................. 90Properties
.......................................................................................................................................................................... 91GoToFirstRecord
.......................................................................................................................................................................... 92SkipFirstRow s
.......................................................................................................................................................................... 93Source
...........................................................................................................................................94TQImport3DBF
.................................................................................................................................................................. 94TQImport3DBF Reference
.................................................................................................................................................................. 95Properties
.......................................................................................................................................................................... 96SkipDeleted
.......................................................................................................................................................................... 97SkipFirstRow s
.......................................................................................................................................................................... 98Map
.................................................................................................................................................................. 99Events
...........................................................................................................................................100TQImport3Docx
.................................................................................................................................................................. 100TQImport3Docx Reference
.................................................................................................................................................................. 101Properties
.......................................................................................................................................................................... 102Map
.......................................................................................................................................................................... 103SkipFirstRow s
.......................................................................................................................................................................... 104NeedFillMerge
.......................................................................................................................................................................... 105TableNumber
.................................................................................................................................................................. 106Events
Advanced Data Import Component Suite for Delphi and C++ Builder - User's Manual5
© 1999-2013 EMS Database Management Solutions, Ltd.
...........................................................................................................................................107TQImport3HTML
.................................................................................................................................................................. 107TQImport3HTML Reference
.................................................................................................................................................................. 108Properties
.......................................................................................................................................................................... 109Map
.......................................................................................................................................................................... 110SkipFirstRow s
.......................................................................................................................................................................... 111TableNumber
.................................................................................................................................................................. 112Events
...........................................................................................................................................113TQImport3ODS
.................................................................................................................................................................. 113TQImport3ODS Reference
.................................................................................................................................................................. 114Properties
.......................................................................................................................................................................... 115Map
.......................................................................................................................................................................... 116SkipFirstRow s
.......................................................................................................................................................................... 117SheetName
.......................................................................................................................................................................... 118NotExpandMergedValue
.................................................................................................................................................................. 119Events
...........................................................................................................................................120TQImport3ODT
.................................................................................................................................................................. 120TQImport3ODT Reference
.................................................................................................................................................................. 121Properties
.......................................................................................................................................................................... 122Map
.......................................................................................................................................................................... 123SkipFirstRow s
.......................................................................................................................................................................... 124SheetName
.......................................................................................................................................................................... 125UseComplexTables
.................................................................................................................................................................. 126Events
...........................................................................................................................................127TQImport3Wizard
.................................................................................................................................................................. 127TQImport3Wizard Reference
.................................................................................................................................................................. 128Properties
.......................................................................................................................................................................... 129AddType
.......................................................................................................................................................................... 130Allow edImports
.......................................................................................................................................................................... 131AutoChangeExtension
.......................................................................................................................................................................... 132AutoLoadTemplate
.......................................................................................................................................................................... 133AutoSaveTemplate
.......................................................................................................................................................................... 134CloseAfterImport
.......................................................................................................................................................................... 135CommitAfterDone
.......................................................................................................................................................................... 136CommitRecCount
.......................................................................................................................................................................... 137ConfirmOnCancel
.......................................................................................................................................................................... 138CSVView erRow s
.......................................................................................................................................................................... 139DataSet
.......................................................................................................................................................................... 140DBGrid
.......................................................................................................................................................................... 141ErrorLog
.......................................................................................................................................................................... 142ErrorLogFileName
.......................................................................................................................................................................... 143ExcelMaxColWidth
.......................................................................................................................................................................... 144ExcelView erRow s
.......................................................................................................................................................................... 145FieldFormats
.......................................................................................................................................................................... 146FileName
.......................................................................................................................................................................... 147Formats
.......................................................................................................................................................................... 148GoToLastPageAfterLoadTemplate
.......................................................................................................................................................................... 149GridCaptionRow
.......................................................................................................................................................................... 150GridStartRow
.......................................................................................................................................................................... 151ImportDestination
.......................................................................................................................................................................... 152ImportMode
.......................................................................................................................................................................... 153ImportRecCount
.......................................................................................................................................................................... 154KeyColumns