HelpScribble project file.
14
Nhqvb cvqrb _rcnve Pragre-18OP75
0
2




FALSE

D:\VDF11.1\Projects\dbImport\Help\Bitmaps,C:\VDF14.1\Projects\dbImport\Help\Bitmaps
1
BrowseButtons()
0
FALSE

FALSE
TRUE
16777215
0
16711680
8388736
255
FALSE
FALSE
FALSE
FALSE
1
FALSE
FALSE
Contents
%s Contents
Index
%s Index
Previous
Next
FALSE

11
10
Scribble10
dbImport 




Writing



FALSE
13
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;\red0\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 dbImport \cf0\b0\f1\fs20 
\par \cf2\{keepn\}
\par \cf3\f0 dbImport is a data import wizard style utility.  It will import flat or text files into DataFlex or DataFlex compatible files.\cf2\f1 
\par \cf0 
\par \f0 dbImport was written to be a companion utility to dbExport, a utility that comes with Visual DataFlex.  It will import most of the output formats of dbExport, but will not import line delimited files.
\par 
\par Another feature of dbImport is that it will either import data itself or write an IDE compatible program that can be modified as necessary.
\par 
\par If you look at the code, either for the wizard itself or generated code, it will be seen that all is backward compatible for earlier versions of VDF and earlier studio versions.
\par \f1 
\par }
20
Scribble20
The utility can...




Writing



FALSE
15
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}{\f2\fnil\fcharset0 Times New Roman;}{\f3\fnil\fcharset2 Symbol;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 The utility can...\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \pard{\pntext\f3\'B7\tab}{\*\pn\pnlvlblt\pnf3\pnindent0{\pntxtb\'B7}}\fi-200\li200\tx200\f2\fs24 Data can be imported into VDF native or compatible data files by one of three ways with this utility. In addition, code may be generated that will perform the same functions. 
\par {\pntext\f3\'B7\tab}Both the utility and the code that's generated use BPOs and a generic data dictionary to perform the import. 
\par {\pntext\f3\'B7\tab}The data file may be zeroed prior to the import.
\par {\pntext\f3\'B7\tab}An entire record - all fields - may be read, or individual data fields may be selected, in any order.
\par {\pntext\f3\'B7\tab}Header records in delimited and fixed field formats can be included, but will be ignored.
\par {\pntext\f3\'B7\tab}Text and binary fields may be imported in HEX or ASCII.
\par {\pntext\f3\'B7\tab}Generated code is IDE compatible and can be added to Abdata by the wizard.
\par {\pntext\f3\'B7\tab}Recnum is never imported, all records should start with a field greater than 0
\par \pard 
\par \f1\fs20 
\par }
30
Scribble30
The utility can not...




Writing



FALSE
10
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}{\f2\froman\fcharset0 Times New Roman;}{\f3\fnil\fcharset2 Symbol;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 The utility can not......\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \pard{\pntext\f3\'B7\tab}{\*\pn\pnlvlblt\pnf3\pnindent0{\pntxtb\'B7}}\fi-200\li200\tx200\f2\fs24 Line delimited formats are not read.
\par {\pntext\f3\'B7\tab}Fixed Field Length formats and XML generated by dbExport can not be imported
\par {\pntext\f3\'B7\tab}XML will not currently read attributes
\par {\pntext\f3\'B7\tab}Recnum is assumed to never be in the import file, all records should start with a field # greater than 0
\par {\pntext\f3\'B7\tab}Only one file at a time can be imported, related files are not considered
\par }
40
Scribble40
File Format Notes




Writing



FALSE
33
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}{\f2\froman\fcharset0 Times New Roman;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 File Format Notes\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \pard\sb100\sa100\b\f2\fs24 1. Delimited
\par \pard\li240\sb100\sa100\b0\'b7 Data may be separated by comma, semicolon, tilde, asterisk or almost any other single character. Tab delimiting is not supported.
\par \'b7 Double quotes around strings are ignored
\par \pard\sb100\sa100\b 2. XML \b0 
\par \pard\li260\sb100\sa100 The general XML format is as follows
\par  <FILENAME>
\par \pard\fi300\li260\sb100\sa100  <Row>
\par \pard\li1120\sb100\sa100 <CATEGORY>Batch Claims</CATEGORY> 
\par <SUB_POSITION>3</SUB_POSITION> 
\par <ACTIVATION>Activate_servedi_rpt</ACTIVATION> 
\par \pard\li560\sb100\sa100 </Row>
\par \pard\li540\sb100\sa100 <Row>
\par \pard\li1100\sb100\sa100 <CATEGORY>Batch Claims</CATEGORY> 
\par <SUB_POSITION>3</SUB_POSITION> 
\par <ACTIVATION>Activate_ContractEDI_rpt</ACTIVATION> 
\par \pard\li540\sb100\sa100 </Row>
\par \pard\li260\sb100\sa100 etc.
\par Cdata sections may also be read without any changes, if used.
\par \pard\sb100\sa100\b 3. Fixed Field Length 
\par \pard\li260\sb100\sa100\b0 The file format is NOT the same as the one exported by dbExplor, so do not try and read a file generated by dbExplor. 
\par It is expected that each new data field will start at the end of the previous. For example, 
\par \pard\fi-20\li540\sb100\sa100\b Length \tab Start \tab Position
\par \pard\li560\sb100\sa100\b0 Field1 \tab 6 \tab 1
\par Field2 \tab 8 \tab 7
\par Field3 \tab 2 \tab 15
\par Field4 \tab 1 \tab 17
\par etc.
\par \pard\li560\f1\fs20 
\par }
50
Scribble50
Operation




Writing



FALSE
6
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 Operation\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par 
\par }
60
Scribble60
Workspace Selection




Writing



FALSE
14
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 Workspace Selection\cf0\b0\f1\fs20 
\par \cf2\{keepn\}
\par \cf0\f0 Fire up the wizard.  The first page is simply some criteria or rules that that wizard operates under.  Click Next...
\par \f1 
\par \f0 Select the workspace you want to import files from.  
\par 
\par If you eventually choose to generate code rather than import directly through the wizard, the source directory of this workspace is where the code will be written.  
\par 
\par \cf2\{bmc Workspaces.bmp\}
\par 
\par \cf0 Click Next...\f1 
\par }
70
Scribble70
File or Table Selection




Writing



FALSE
10
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 File or Table Selection\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \f0 Select the table you want to import the flat file into - Only one checkbox can be selected at a time.
\par 
\par \cf2\{bmc FileSelection.bmp\}
\par 
\par \cf0 Click Next...\f1 
\par }
80
Scribble80
Field or Column Selection




Writing



FALSE
17
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}{\f2\fnil\fcharset2 Symbol;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 Field or Column Selection\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \f0 There are two major choices on this page.  
\par 
\par \pard{\pntext\f2\'B7\tab}{\*\pn\pnlvlblt\pnf2\pnindent0{\pntxtb\'B7}}\fi-200\li200\tx200 Check the "Are the data fields..." checkbox at the top to select all fields other than Recnum or the RecID, in the "normal" order they are in the file.
\par {\pntext\f2\'B7\tab}Uncheck the checkbox to make the two lists available so that you can pick the fields you want.
\par \pard 
\par \cf2\{bmc FieldSelection.bmp\}\cf0 
\par 
\par If selecting individual fields, select in any order, and only the ones you need - these should match the flat file being imported.   Click "Start Over" to initialize the screen and clear all selections.
\par \f1 
\par \f0 If you have columns in the flat file being imported that you do not want to import, check the corresponding "Ignore Text" checkbox on the right. This choice will be written to the output code should you make that selection.\f1 
\par 
\par \f0 Click Next...\f1 
\par }
90
Scribble90
Miscellaneous




Writing



FALSE
20
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 Miscellaneous\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \f0 First, select the file type to be imported.
\par 
\par \b Zero file before importing\b0  - A Zerofile will be performed on the file you are importing into.  All users will need to be out of that file.
\par 
\par \b Is there a header Row?\b0  - Excel and other products will export a file with the first row being column headers or names.  Checking this will cause the first row to be ignored.
\par 
\par \b Import Text & Binary from Hex?\b0  - If the text and/or binary fields in the import file are in Hex, they will be converted.
\par 
\par \b Data Delimiter\b0  - Select or enter another delimiter.  Choices are Comma, Tilde, Semicolon or Asterisk.  "Other" is any visible ASCII character, TAB is not valid.
\par 
\par \b Import File Name\b0  - A file name must be entered or selected whether you are importing with the wizard or generating code.  
\par 
\par \cf2\{bmc ExportFileType.bmp\}
\par 
\par \cf0 Click Next...\f1 
\par }
100
Scribble100
Import or Generate Code




Writing



FALSE
13
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 Import or Generate Code\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \f0 Select what you want to do.
\par 
\par If generating code, you have the option to add your application to the IDE files in the workspace you initially selected.  This is useful if you want to edit the view for some reason.  The generated code is IDE compatible.
\par 
\par \cf2\{bmc ImportOrCode.bmp\}
\par 
\par \cf0 Click Next...
\par \f1 
\par }
110
Scribble110
Finally...




Writing



FALSE
8
{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}{\f1\fnil Arial;}}
{\colortbl ;\red0\green0\blue255;\red128\green0\blue0;}
\viewkind4\uc1\pard\cf1\b\fs32 Finally...\cf0\b0\f1\fs20 
\par \cf2\{keepn\}\cf0 
\par \f0 The last screen is a summary of your choices.  Click next to either import your file or generate code.
\par \f1 
\par \cf2\{bmc FinishUp.bmp\}\cf0 
\par }
0
0
0
11
1 dbImport 
2 The utility can...=Scribble20
2 The utility can not...=Scribble30
2 File Format Notes=Scribble40
1 Operation
2 Workspace Selection=Scribble60
2 File or Table Selection=Scribble70
2 Field or Column Selection=Scribble80
2 Miscellaneous=Scribble90
2 Import or Generate Code=Scribble100
2 Finally...=Scribble110
6
*InternetLink
16711680
Courier New
0
10
1
....
0
0
0
0
0
0
*ParagraphTitle
-16777208
Arial
0
11
1
B...
0
0
0
0
0
0
*PopupLink
-16777208
Arial
0
8
1
....
0
0
0
0
0
0
*PopupTopicTitle
16711680
Arial
0
10
1
B...
0
0
0
0
0
0
*TopicText
-16777208
Arial
0
10
1
....
0
0
0
0
0
0
*TopicTitle
16711680
Arial
0
16
1
B...
0
0
0
0
0
0