Home

Data Import for Interbase/Firebird

1. 000 Corporate Hi null 105 1 000 000 01 Monterey 408 555 12 100 Sales and M 000 85 2 000 000 01 San Francise 415 555 12 1600 Engineering O00 2 1 100 000 01 Monterey 408 555 12 900 Finance 000 46 400 000 00 Monterey 408 555 12 180 Marketing 100 null 1 500 000 01 San Francise 415 555 12 L 620 Software Prc 600 null 1 200 000 01 Monterey 408 555 12 Database DIOMED R71 Gafhaare Me RAN muli ANA NANA Mantere ANA 555 17 YA Table TESTER DEPARTA 4 M a To remove a correspondence select the field in the New fields list and press the Xx Clear Field Ranges button To remove all correspondences press the _ e Clear All Ranges button If your OpenDocument Spreadsheet file contains several sheets you are able to set different mapping for each sheet Click the Next button to proceed to the Setting base data formatsf 501 step of the wizard O 1999 2014 EMS Database Management Solutions Ltd a Data Import for Interbase Firebird User s Manual 2 1 5 12 ODT The OpenDocument format is used by Mobile Office as well as other well known desktop applications such as OpenOffice StarOffice and KOffice ODT stands for OpenDocument Text odt Specify ranges in the grid for the target and source fields e select a field of the target Interbase Firebird table in the New fields list e proceed to the Table grid click a column to assign the column to the selected target table field e the selected column of the source fi
2. database You should register the user with the proper login and password on your server Scroll to topl137 If you still have any questions contact us at Support Center O 1999 2014 EMS Database Management Solutions Ltd 16 Data Import for Interbase Firebird User s Manual 1 7 Other EMS Products Quick navigation YY r ow A MySQL T Microsoft SQL PostgreSQL InterBase Oraclel 1 IBM DB2 Tools amp 1 1 FireBird 1 209 components 21 MySQL S9 SQL Management Studio for MySQL EMS SQL Management Studio for MySQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for MySQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for MySQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for MySQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for MySQL Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to MySQL Data Generator for MySQL Generate test data for databas
3. 1 Year Maintenance EMS Data Import for Interbase Firebird Non commercial license 2 Year Maintenance EMS Data Import for Interbase Firebird Non commercial license 3 Year Maintenance EMS Data Import for Interbase Firebird Trial version Download Now EMS Maintenance Program provides the following benefits e Free software bug fixes enhancements updates and upgrades during the maintenance period e Free unlimited communications with technical staff for the purpose of reporting Software failures e Free reasonable number of communications for the purpose of consultation on operational aspects of the software 1999 2014 EMS Database Management Solutions Ltd 11 Data Import for Interbase Firebird User s Manual e Access to personalized sqlmanager net account e online speed through maintenance renewal e Advanced and exclusive notification of software promotions e Maintenance Owner ONLY product promotions After your maintenance expires you will not be able to update your software or get technical support To protect your investments and have your software up to date you need to renew your maintenance You can easily reinitiate renew your maintenance with our online speed through Maintenance Reinstatement Renewal Interface After reinitiating renewal you will receive a confirmation e mail with all the necessary information See also How to register Data Import 121 1999 2014 EMS Database
4. XML file type Select the type of xm file from which you are importing data Auto Detect file type will be detected automatically whether it is XML MS Access or XML data packet file XML MS Access select this option if your xm file has the same structure as files exported from MS Access XML Data Packet select this option if your xm file has data representation format used by Embarcadero XML Doc File select this option to map fields of a Generic XML document 41 manually 2 1 5 Step 4 Mapping fields This step of the wizard allows you to set correspondence between columns of the source file and fields of the target Interbase Firebird table according to the source data format MS Excel mappingi MS Excel 2007 mapping 33 MS Word 2007 mapping 3e MS Access mappingl 37 DBF _mapping 38 XML mappingl 0 XML Document mapbpingl 1 TXT _mapping 43 CSV _mapping 44 HTML Document 46 ODS mappingl 7 1999 2014 EMS Database Management Solutions Ltd 32 Data Import for Interbase Firebird User s Manual e ODT mappingi 49 To get more information about the file formats see the Supported file formatsls3 page When you are done press the Next button to proceed to the next stepf501 2 1 5 1 MS Excel Select the needed source file from the list Then specify ranges in the grid for the target and source fields e select a field of the target Interbase Firebird table in the Fields list e proc
5. step of the Wizard Please note that loading a template is only available at the Getting started 24 and the Setting connection properties 25 steps of the Wizard If necessary you can reopen a template at any step of the wizard using the corresponding popup menu item of the Tools menu Load Template lo Preferences Reopen Template C EMS docs TestTemplate itm C EMS docs HR_import itm C EMS docs DEMO itm 1999 2014 EMS Database Management Solutions Ltd e Data Import for Interbase Firebird User s Manual See also Working with wizard application 2A Setting program preferences 69 1999 2014 EMS Database Management Solutions Ltd e Data Import for Interbase Firebird User s Manual 2 3 Setting program preferences Data Import for Interbase Firebird provides full customization of the program interface by setting various options within the Preferences dialog This chapter is intended to inform you how to use all these options Setting general options 6 These options define general behavior of Data Import for Interbase Firebird Selecting program languagel7 This page allows you to select a language to be applied for your copy of Data Import for Interbase Firebird Setting data fonti Allows you to adjust font settings for the data displayed in the application Setting Excel options 73 Allows you to adjust Excel data representation settings Defining interface style
6. 38 Wrong identification of Integer type fields Fixed now yyyy mm ddThh nn ss format was recognized incorrectly Fixed now HTMLI 481 When importing from HTML file with the links the application froze Fixed now Other improvements and bugfixes See also Version history 1999 2014 EMS Database Management Solutions Ltd Ez Data Import for Interbase Firebird User s Manual 1 2 System requirements System requirements for Data Import for Interbase Firebird e 300 megahertz MHz processor 600 megahertz MHz or faster processor recommended e Microsoft Windows NT4 with SP4 or later Microsoft Windows 2000 Microsoft Windows 2000 Server Microsoft Windows XP Microsoft Windows 2003 Server Windows 2008 Server Microsoft Windows Vista Microsoft Windows 7 Microsoft Windows 8 Microsoft Windows 8 1 e 64MB RAM or more 128MB or more recommended e 20MB of available HD space for program installation Super VGA 800x600 or higher resolution video adapter and monitor Super VGA 1024x768 or higher resolution video adapter and monitor recommended Microsoft Mouse or compatible pointing device Interbase Firebird client Possibility to connect to any local or remote Interbase Firebird server Supported InterBase and Firebird server versions InterBase up to 2007 Firebird up to 2 1 1999 2014 EMS Database Management Solutions Ltd 9 Data Import for Interbase Firebird User s Manual 1 3 Installat
7. Ltd Data Import for Interbase Firebird User s Manual Pressing this button clears the on screen log area removing all messages If necessary you can save a templatels7 for future use Click the Finish button to start the import process O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 2 2 Using data import configuration files Data Import for Interbase Firebird allows you to store its configuration settings in external itm template files if you need to perform the data import process repeatedly You can load previously saved configuration settings to the application wizardl2s if you need to make some changes before data comparison or you can run it with the console application 771 for quicker data import Data Import templates are saved loaded within the Save template options Load template dialog To open this dialog press the Tools button and select the Save template Load template popup menu item ha Save Template File name When saving template specify the template file name and select its location using the ta button which calls the Save As dialog Save template options E3 File name C EMS docs TestTemplate itm ta Cancel Help If you need to repeat data importing process with the same or similar settings later it is reasonable to save all the settings you entered on the Start of data import process 65
8. Ltd e Data Import for Interbase Firebird User s Manual Import all records Specifies that all records of the source file will be imported 9 Import only record s Specifies the number of records to be imported Y Import empty rows If this option is checked then empty records are imported Y Auto trim values Check this function to remove all leading and trailing white space characters from all imported records Y Save Result SQL Script to File This option allows you to save the result SQL script of the import operation to an external sql file on your disk drive Specify the script file name and select its location using the ta button which calls the Save As dialog Files Commit Ed COUNTAY xls Commit when done CUSTOMER mdb JA DEPARTMENT ods a Commit after each 1000 records E DISCOUNTS odt E ET E EMPLOYEE xlsx a J0B csv Record Count 2 PAYMENT xml ry PROJECT dbf Import all records f E SALES html er E STORES txt 2 CITY xml WF FILM docx Auto trim values v Save result SQL sc C EMS docs COUNTRY sal he Database DIOMED A Table TESTER COUNTA SKP this step WI Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalls9 section of the Preferences e dialog O 1999 2014 EMS Database Management Solutions Ltd e Data Import
9. What is the difference between the Import feature of SQL Manager for Interbase Firebird and the Data Import for Interbase Firebird utility A First of all Data Import for Interbase Firebird works faster as it is a considerably lighter application Besides it provides additional features for query building namely e import data to several tables simultaneously e import data to tables selected from different databases e the command line version of the utility to import data using the configuration template file with all import settings automatically creates table structure 1999 2014 EMS Database Management Solutions Ltd m Data Import for Interbase Firebird User s Manual Q Are there any limitations implied in the trial version as compared with the full one A Actually the trial version of the utility only allows you to import 20 of records into each table With this limitation you can test all the features implemented in Data Import for Interbase Firebird within the 30 day trial period Note There is a 100 records instead of 20 limitation when importing from CSV TXT or MS Access files Q What is the easiest way to configure the template files for the Data Import console application A You can configure the template files for each table visually using the Data Import Wizard application Set the required options and select the Tools Save Template menu item All the options will be saved to the template fil
10. mistake If the execution succeeds you see the message box with the result as it is shown on the picture below O Test run succeeded Result Tchaikovsky Piotr For more information about JScript see http msdn microsoft com en us library x85xxsf4 aspx 1999 2014 EMS Database Management Solutions Ltd s Data Import for Interbase Firebird User s Manual Quotation Left quotation Set a character or a number of characters to denote quoting in the imported string Right quotation Set a character or a number of characters to denote unquoting in the imported string Quotation action You can select the Add item to add quotation marks to the imported string the Remove item to remove all the quotation marks from the imported string or the None item to save the original quotation marks String conversion Char case Set the case of the imported string As Is keeps the original string unchanged Upper sets the whole string to the upper case Lower sets the whole string to the lower case UpperFirst sets the first character of the string to the upper case UpperFirstWord sets the first character of each word to the upper case Char set Set the char set of the imported string to ANSI or OEM As Is saves the original character set of the string The Replacements area allows you to set the text you need to be replaced during data import into the selected field Press the Add Replacement Lae button to specify a
11. 2 1 5 9 CSV Set correspondence between the target table fields and the source CSV file columns e select the Delimiter and Quote characters for CSV files using the corresponding drop down lists of the CSV Parameters group e select a field of the target Interbase Firebird table in the Fields list e proceed to the source grid viewer area click a caption to assign the colurm to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process 1999 2014 EMS Database Management Solutions Ltd as Data Import for Interbase Firebird User s Manual The source file character set can be defined at the Encoding field If the source file and the destination Interbase Firebird table have the same order of columns you can use the Auto Fill Columns mode default to set correspondence between them automatically If source file and destination Interbase Firebird table have different order of columns but identical names you can use the Auto Fill by Captions mode to set the correspondence based on name s identity When you import data to a newly created table the Analyze button appears Use this button for automatic field creation If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit The number of the column which correspondence is set for are displayed at the G
12. 2014 EMS Database Management Solutions Ltd as Data Import for Interbase Firebird User s Manual Click the Next button to proceed to the Setting base data formats s01 step of the wizard 2 1 5 8 TXT Set correspondence between the source text file columns and the target Interbase Firebird table fields e select a field of the target Interbase Firebird table in the Fields list e double click in the text viewer area to add vertical separators delimiting the source column bounds e click the area between the separators to assign the column to the selected target table field the selected source column gets black highlight e repeat the operation for all the fields you need to be included in the import process The Fields list also allows you to view the following values P represents the starting point of your selection S displays the width of the selected area You can change these parameters manually or by moving the slider in the grid If necessary you can choose to skip a defined number of the source file lines using the Skip lines spin edit If the source text file and the destination Interbase Firebird table have the same order of columns you can use the 9 Autofill Columns button to set correspondence between them automatically The source file character set can be defined at the Encoding field V Autoscroll This option scrolls the document automatically when you switch to the next field for mapping When y
13. 7 This branch contains several pages with a number of options allowing you to customize the application interface style according to your liking z gt Load Template t Preferences Reopen Template See also Working with wizard application 244 Using data import configuration files 67 2 3 1 General General Y Confirmation on exit Enables disables confirmation upon exiting the program VI Skip intermediate steps This option determines the behavior of the Next and Back buttons When this option is disabled clicking the Next button leads to sequential passing through the list of imported objects When this option is enabled the steps checked in the Skipped steps group will O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual be skipped Key columns reminder Use this option to enable disable prompts to define key columns Languages Data Font Excel Options Interface Confirmation on exit Skip intermediate steps Key columns reminder Remember password Show field types Show number of created tables Show number of mapped columns Use first row as caption fields yse 100 rows JSS SS O E E E A Import to views Keep options at steps Default min length for new string field A 110 2 Ss O 7 Allow script execution Remember password Setting this option allows you to save passwor
14. Data Import for Interbase Firebird to the operating system after performing the latest task 0 successful completion 1 error s occurred during task performing 2 fatal error occurred The task was not performed See also Working with wizard application 241 Configuration file format 7A 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 3 2 Configuration file format The configuration file is divided into several sections Connection This section contains parameters for connecting to the server Host Port tunneling settings Login Password encrypted These parameters are obligatory PREFERENCES This section contains the general settings of the utility ImportToViews 1 enabled 0 disabled The following sections are unique for each imported file and contain the appropriate postfix FILE_00 FILE_01 FILE_02 etc In these sections the import options for each particular file are stored FILE_00 In the main file section the following parameters are used Database destination database name Table destination table FileName the source file name ImportType Indicates the format of the source file O stands for MS Excel 1 for MS Access 2 DBF 3 TXT 4 CSV 5 XML 6 MS Excel 2007 7 MS Word 2007 8 HTML 9 XML Document 10 ODS 11 ODT The next section is specific to the file format and is named correspondingly e g FILE_00_X
15. K SALES html y Ed rental rate DOUBLE En STORES txt Ed length VARCHAR 10 CITY xmil EX replacement cost DOUBLE Sees A Be 41 FILM docx Skip ine s 1 Table 1 film_id title release year language id original_lang rental_durati rentalrate length 1 ACADEMY 2006 1 null 6 0 99 86 2 ACE GOLDF 2 006 1 null 3 4 99 48 3 ADAPTATIC 2 006 1 null 7 2 99 50 4 AFFAIR PRE 2 006 1 null 5 2 99 117 5 AFRICAN EL 2 006 1 null 6 2 99 130 6 AGENT TRL 2 006 1 null 3 2 99 169 Database DIOMED 7 SIRPLANE H FNNA 1 muli R 499 R x New table TESTERFILM Li m 3 To remove a correspondence select the field in the New fields list and press the x Clear Field Ranges button To remove all correspondences press the _ e Clear All Ranges button Click the Next button to proceed to the Setting base data formatsf 501 step of the wizard MS Access Set correspondence between the source MS Access fields and the target Interbase Firebird table fields e select a field of the target Interbase Firebird table in the Table fields list e select the corresponding field of the source MS Access table in the Access Fields list click the Add button to set correspondence between the selected fields the pair of fields appears in the list below repeat the operation for all the fields you need to be included in the import process If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be cre
16. Shea ae ea aaah aid Sie ela ai een 37 A 38 MEAN AE AA Ma ais 40 E A NN 41 VA A A nac 43 OSM A a i PAA ere ones 44 A NAO 46 OO A a 47 ODA A de 49 step 5 Setting base data formats civic cette 50 Format Specifier Saarani ei AA AA AA AAA A A ia etal 52 Step 6 Settings data formats for each field a 55 Step 7 Specifying iM Port MOE nnmmncicccnnininniiniasianirirrirrrrrrnr 59 Step 8 Selecting key COlMUMOS oi snceeces snessuaeccansaes ecd auencudneveneneccees 61 Step 9 Setting COMMON OPTIONS cc ccssceseeeeseeseeeneesneeeesesneeseensnessnenneesnaesuaesneeseaesnecsnensnersneuseeseeenseesneeeseess 62 Step 10 Defining SCriptS nmnicnnicnininnninanaianarrrrrrrrri naea S nma san Kavi CASSE APRES P ENEN eNi Cir ua pep Eanos nasira EaES 64 Step 11 Start of data import procesS wasusia nuna wi kunzia zi aanse ann nene 65 Using data import configuration files ooooccccononanonanananonononononononononononnnnnnnnnn nono nono anno nnnnnnnnnns 67 Setting program preferences m ccccococococococococononononononnnnonononononononononononononononononnnncnnnnnnnnnnnnnnona 69 CO A A a ziwa 69 AUS AA AAA AA AA ssoeaee 71 AAA E ais etdctaav MANA E E TN 72 A O 73 dora A A i 74 O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual Part Ill Console application 77 Working with console application ccccccccccccccccocococcnnnnonononononononononononononononononnnnnnnono
17. Update Delete I EMPLOYEE xlsx 21 CUSTOMER mdb 9 Insert new 5 Update or insert 5 Delete or insert E SALES html D STORES txt 9 Native mode 5 Universal mode Import Native mode kind for Ya InterBase Single commands Firebird 3 External file name C Program Files EMS Data Import for Intera f Database employee OR Table COUNTRY Bip hisp Help Tools lr lt lt Back Next gt gt Close If the Update value is selected for Import Mode then you need to specify the Primary Key field s that will serve for data identification of your source file with the data of the target table The source file must contain the column s that will correspond to the Primary Key field of the target table If the target table contains a record in which the value of the primary key field coincides with the value of the corresponding column of the source table the data stored in this table record will be updated You can specify the field s which will be used for identification at Step 7 61 of the wizard This field s will only serve for identification and will not be imported O 1999 2014 EMS Database Management Solutions Ltd st Data Import for Interbase Firebird User s Manual Native Universal mode The Native mode uses the Single Commands method or the External table insert method First method serves to generate and execute single SQL commands on the server The second mode should be used if the server i
18. can be set in the field Date Time Date amp Time Long File Name Short File Name Script Press the button to add edit the script in the Script Editor 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual NAME Piotr Tchaikovsky The result of script execution corresponds to the value of the last variable The example shows how you can get field value convert it to a number incremented by the number value of the current month To run the example input Field Value For Testing in text editor and uncomment the following three lines R NAME var D new Date k parseInt R D getMonth var re pattern w s w var input String NAME result input string replace re pattern 2 1 lala 17 53 Insert cancel Use the Script Editor window to enter the script for the field processing Here you can use all features of the MS JScript The picture above shows the example of the Jscript use for the field Name processing The entered code converts the XXXX YYYY string to the YYYY XXXX one for example Piotr Tchaikovsky gt Tchaikovsky Piotr If you want to test your code and see the result of its execution then enter the test field value in the Field Value For Testing box and click the Test Run button If the execution fails you see the message box with the description of an occurred
19. files for the Data Import console application 1A e I work behind a firewall router Can EMS Data Import connect to a remote Interbase Firebird server hA e Why cannot I connect to the local InterBase Firebird Server 13 e Why cannot I connect to a remote InterBase Firebird server fa Question answer list Q What is EMS Data Import for Interbase Firebird A EMS Data Import for Interbase Firebird is a powerful tool to import your data quickly from MS Access MS Excel DBF TXT CSV XML MS Excel 2007 MS Word 2007 HTML ODF files to Interbase Firebird tables It provides adjustable import parameters including source data formats for all the fields and destination data formats for the selected fields commit options number of records to skip etc Data Import includes a wizard which allows you to set all the import options for different files visually and a command line utility to execute import in one touch Q What do I need to start working with EMS Data Import for Interbase Firebird A First of all you must have a possibility to connect to some local or remote Interbase Firebird server to work with Data Import You can download Interbase Firebird database server from http www codegear com interbase the latest commercial version of InterBase server or Firebird client and server from http www firebirdsql org Besides you need your workstation to satisfy the system requirements 8 for Data Import for Interbase Firebird Q
20. for Interbase Firebird User s Manual When you are done press the Next button to proceed to the next stepfe 2 1 11 Step 10 Defining scripts This step of the wizard allows you to define scripts to be executed before and after import process for each database Select a database to define the script for Type the text of the script to be executed before the import operation in the Before Import Script area the script to be executed after the import operation in the After Import Script area Select another database and add scripts for it if necessary You can also save and load Before Import and After Import scripts using the corresponding Save Script and Load Script buttons Specify the script that will be executed BEFORE data import After import script Specify the script that will be executed AFTER data import Skip this step Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalls section of the Preferencesle dialog O 1999 2014 EMS Database Management Solutions Ltd ss Data Import for Interbase Firebird User s Manual When you are done press the Next button to proceed to the last steples 2 1 12 Step 11 Start of data import process This step of the wizard is intended to inform you that all import options have been set and you can start the import process If everythi
21. it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields 85 if needed Use the corresponded context menu item to Add Edit Drop field 33 Add field Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual Fies 5369 e Ed COUNTAY xls Y CUSTOMER mdb Grid C a DEPARTMENT ods ii BB PO NUMBER VARCHAR 8 1 JE DISCOUNTS ot ST_NO INTEGER 1 sl Ed EMPLOYEE xlsx Y EX JOB csy Y 8 ORDER STATUS VARCHAR 7 4 ke PAYMENT xml ORDER DATE TIMESTAMP 0 PROJECT dbf Y 3 SHIP_DATE TIMESTAMP 0 dEl SALES html v 3 DATE_NEEDED TIMESTAMP 0 STORES tet Bl PAID VARCHAR 1 29 CITY xml Ez OTY ORDERED INTEGER py i FILM docx stiptinets o E PO_NUMBE CUST_NO SALES REF ORDER_ST ORDER_DA SHIP_DATE DATE_NEEIPAID _ VOIEO210 1004 11 shipped 04 03 1991 1 05 03 1991 1 nul y 3 V92E0340 1004 11 shipped 115 10 19921 16 10 19921 17 10 19921 y 3211003 1010 61 ship
22. new replacement options using the Add Replacement dialog Define the text to replace and the value to replace with in the appeared dialog window Check the Ignore Case option to make replacement case insensitive ha Replacement a Text to find ITman Replace with IT Manager OK Cancel To remove a replacement select it in the list and click the Delete Replacement button 1999 2014 EMS Database Management Solutions Ltd s Data Import for Interbase Firebird User s Manual WI Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalls9 section of the Preferencesl 9 dialog When you are done press the Next button to proceed to the next step 59 2 1 8 Step 7 Specifying import mode This step of the wizard allows you to define the records processing mode as Insert All Insert New Update Update or Insert Delete Delete or Insert mode e Insert all all records from the source file are inserted into the tables irrespective of whether any records exist in the destination table or not e Insert new already existing records are skipped and new records are inserted into the destination table Update all existing records are updated from the source file Update or insert already existing records are updated and new records are inserted into the destination table Delete already existing
23. of the source file rows or columns using the Skip lines or Skip cols spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x 1999 2014 EMS Database Management Solutions Ltd 35 Data Import for Interbase Firebird User s Manual re hafe Li Le Le dhs aSa ata uth Ed COUNTRY xls v 121 CUSTOMER mdb w Fields a Ranges JA DEPARTMENT ods Ee EMP_NO SMALLINT Ed sheet1 C1 COLFINISH 2 DISCOUNTS odt FIRST_NAME VARCHAR 15 EP EMPLOYEE xlsx w LAST NAME VARCHAR 20 ET JOB csv Y 8 PHONE_EXT VARCHAR 4 2 PAYMENT xml HIRE_DATE TIMESTAMP 0 Wi PRODUCT docx DEPT_NO VARCHAR 3 E PROJECT dbf Y JOB_CODE VARCHAR 5 E SALES html v JOB_GRADE SMALLINT STORES txt 38 JOB COUNTRY VARCHAR TT lt 2 CITY xml Skip row s 0 Skip col s 0 2 FIRST_NAN LAST NAMI PHONE EX HIRE DATE DEPT NO JOB CODE JOB Robert Nelson 250 0 00 00 600 VP 2 Bruce Young 233 0 00 00 621 Eng 2 Kim Lambert 22 0 00 00 130 Eng 2 Leslie Johnson 410 0 00 00 180 Mktg 3 4 4 mw b Database DIOMED To select the column dick its header To select the row dick its number To select several cells at once dick Table TESTER EMPLOY the right cell and the last cell holding the Shift button To remove a correspondence select the field in the Fields lis
24. or rows using the Col s and Row s spin edits 1999 2014 EMS Database Management Solutions Ltd 33 Data Import for Interbase Firebird User s Manual Files ap a Ed COUNTRY xls Y ER x lali ES ul Bc 121 CUSTOMER mdb w eds is e JA DEPARTMENT ods if COUNTRY VARCHAR 15 Sheet 1 B COLFINISH DISCOUNTS odt cee nee ees EF EMPLOYEE xlsx y FLAG BLOB 1 EX JOB csv Y e PAYMENT xml II PRODUCT docx PROJECT dbf Y E SALES html v FS STORES txt CITY Skip row s 1 Skip col s 0 Sheet 1 A i D E F G H lz 1 COUNTRY CURRENCY 2 USA Dollar 3 England Pound 4 Canada CdnDir 5 Switzerland SFranc L 6 Japan Yen Database DIOMED 7 llan Lira s Table TESTER COUNTE 1 L y If your spreadsheet file contains several sheets you are able to set different mapping for each sheet To clear ranges for a field select the field in the Fields list and press the ES Clear Field Ranges button To clear all ranges specified for the target table fields press the ED Clear All ranges button To set a range of datals7 to be imported from the file use the Add range button To remove a range use the Delete range button Using the Le Move Up and the 9 Move Down buttons you can change the order of ranges applied to data Click the Next button to proceed to the Setting base data formatsf 501 step of the wizard 2 1 5 2 MS Excel 2007 Select the need
25. records are deleted Delete or insert existing records are deleted and new records are inserted into the destination table Here is an example of some import modes offered by Data Import utility DB Table Source file 21D DATA All import modes except for the Insert All mode are based on primary key values information In order to perform import operations with these modes used you need to have matches between the source file primary key column s and the destination table primary key column s Insert Insert all Insert new Update mode Result 1D gt DATA 3 1D y DATA y 21D w DATA w gt A he E A E zA IO m el 2 b 3e alt 21d alt 3 e alt O 1999 2014 EMS Database Management Solutions Ltd 60 Data Import for Interbase Firebird User s Manual Insert Update or insert Delete Delete or insert mode Result 4f It is applied to all other import modes except for the Insert all mode For all these modes except for the Insert all mode it is obligatory to select the primary key fields This field or fields is used as key field to identify specific data in the target database The key columns for these operations are defined at the Selecting key columnsf611 step of the wizard Ex Data Import for InterBase and Firebird EBA Step 6 of 10 Select import mode Files Import mode 31 COUNTRY xls Insert al
26. should enter Interbase Firebird port to connect through in the Port field Afterwards you should specify authorization settings Login and Password The default superuser name is SYSDBA and the default password is masterkey You also need to specify the path to the Client library and the path to the Database file gdb for InterBase or fdb for Firebird in the corresponding fields For successful 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual connection to the server it is crucial to use the appropriate client library the one that is compatible with the server you are using gds32 dll for InterBase and fbclient dll for Firebird Please note that the client library file must be located on your local machine e g in the directory where the utility is installed Bear in mind that the path to the database file should be set relatively to the Interbase Firebird server file system ES Data Import for InterBase and Firebird Loa Step 1 of 11 Set InterBase and Firebird server connection options Connection Properties Host doom server y Authentication Login SYSDBA Port 3050 la Password Data Network Protocol TCPAIP Import sent E Role for Client library C gds32 dl B InterBase T Library for InterBase Server 7 1 0 131 Client charset NONE Firebird Database file C Program Files Firebird Firebird_2_1 exame y Don t use tunneling gt Connect throug
27. 1 COUNTRY xls w E LAST UPDATE TIMESTAMP PAYMENT_ID Integer CUSTOMER mdb vw CUSTOMER_ID Integer DEPARTMENT ods y A Integer DISCOUNTS odt ap RENTAL_ID Integer EMPLOYEE xlsx Y AMOUNT Float JOB cs Y Remove Ed PAYMENT_DATE DateTime 2 PAYMENT snl LAST_UPDATE DateTime PROJECT dbf v El SALES html w L 5 STORES txt Encoding Windows default 7 2 CITY xml 100 FILM docx Table fields XML fields Ed PAYMENT ID INTEGER PAYMENT_ID Integer E CUSTOMER ID INTEGER CUSTOMER_ID Integer 38 STAFF ID INTEGER STAFF_ID Integer 3 RENTAL_ID INTEGER RENTAL ID Integer 3 AMOUNT DOUBLE AMOUNT Float Gi PAYMENT DATE TIMESTAMP PAYMENT_DATE DateTime Database DIOMED New table TESTER PAYME To remove a correspondence select the pair of fields in the list below and press the Remove button To remove all correspondences press the Clear button Click the Next button to proceed to the Setting base data formats 501 step of the wizard 2 1 5 7 XML Document In order to set mapping of a Generic XML document you should first select the desired XML Document in the Files list then press the Build Tree button to get the tree like structure of source document in the area located to the right from the New fields list Select a node in the tree to get its relative path or type the path manually in the editor below the path must be specified in the XPath format Upon pressing the Fill gri
28. A group of up to four O characters can immediately follow the E E e or e to determine the minimum number of digits in the exponent The E and e formats cause a plus sign to be output for positive exponents and a minus sign to be output for negative exponents The E and e formats output a sign character only for negative exponents Date Time format O 1999 2014 EMS Database Management Solutions Ltd 53 Data Import for Interbase Firebird User s Manual c Displays the date using the format using the Short Date Format followed by the time using the Long Time Format The time is not displayed if the date time value indicates midnight precisely d Displays the day as a number without a leading zero 1 31 dd Displays the day as a number with a leading zero 01 31 ddd Displays the day as an abbreviation Sun Sat using the strings of the Short Day Names dddd Displays the day as a full name Sunday Saturday using the strings of the Long Day Names ddddd Displays the date using the Short Date Format dddddd Displays the date using the Long Date Format e Displays the year in the current period era as a number without a leading zero Japanese Korean and Taiwanese locales only ee Displays the year in the current period era as a number with a leading zero Japanese Korean and Taiwanese locales only g Displays the period era as an abbreviation Japanese and Taiwanese locales only gg
29. CSV MS Word 2007 Open Document Format and HTML Importing data to one or several tables or views from different databases Automatically creates table structure Special batch insert commands allow to import data at the maximum possible speed A number of import modes Insert All Insert New Insert or Update and others Secure Shell SSH tunneling support Adjustable import parameters for each source file Saving all import parameters set on current wizard session Command line utility to import data using the configuration file Powerful visual options module User friendly localisable wizard interface Product information Homepage http www sqlmanager net en products ibfb dataimport Support Ticket http www sqlmanager net support System Register online at http www sglmanager net en products ibfb dataimport bu O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 1 1 What s new Version Release date Data Import for Interbase Firebird 3 7 June 09 2014 What s new in EMS Data Import Import rate is increased due to use of multithreading XML 30 Added the possibility of manual and automated identification of the type of the imported XML file Now logf 68 contains information about the string number where the error occurred When importing from several files their logsf651 are located at different tabs while the main log contains general information about these processes DBF
30. Date Null values Null Est JOB csw a PAYMENT xml Time PROJECT dbf dE SALES html Date formats E STORES tet aene uwa al CITY xml Date dd MM yyyy y Wi FILM docx Time h mm y Database DIOMED AA ee Table TESTER COUNTA SK this step Separators Decimal Thousand Date Time Decimal Set a character to delimit the decimal parts of the imported numbers Thousand Set a character to separate the digit groups in the imported numbers Date Set a character to separate the year month and day parts of date values Time Set a character to separate the hour minute and second parts of time values Constants Boolean True Set one or more variants of TRUE value representation in the imported table e g Yes or Use a new line for each additional variant Boolean False Set one or more variants of FALSE value representation in the imported table e g No or Use a new line for each additional variant Null Values Set one or more variants of NULL value representation in the imported table e g Null 1999 2014 EMS Database Management Solutions Ltd 52 Data Import for Interbase Firebird User s Manual Use a new line for each additional variant Date Time formats Use these edit fields to set the date and time formats Date Time For more information refer to the Format specifiers 52 page W Skip this step Check this option to skip the current step in the future To edit the list of skipped s
31. Displays the period era as a full name Japanese and Taiwanese locales only m Displays the month as a number without a leading zero 1 12 If the m specifier immediately follows an h or hh specifier the minute rather than the month is displayed mm Displays the month as a number with a leading zero 01 12 If the mm specifier immediately follows an h or hh specifier the minute rather than the month is displayed mmm Displays the month as an abbreviation Jan Dec using the strings given of the Short Month Names mmmm Displays the month as a full name January December using the strings of the Long Month Names 1999 2014 EMS Database Management Solutions Ltd sa Data Import for Interbase Firebird User s Manual yy Displays the year as a two digit number 00 99 yyyy Displays the year as a four digit number 0000 9999 h Displays the hour without a leading zero 0 23 hh Displays the hour with a leading zero 00 23 n Displays the minute without a leading zero 0 59 nn Displays the minute with a leading zero 00 59 s Displays the second without a leading zero 0 59 ss Displays the second with a leading zero 00 59 Z Displays the millisecond without a leading zero 0 999 ZZZ Displays the millisecond with a leading zero 000 999 t Displays the time using the Short Time Format tt Displays the time using the Long Time Format am pm Uses the 12 hour clock for the preced
32. ER mdb w New fields Grid Column JA DEPARTMENT ods v 28 DISCOUNTTYPE VARCHAR 17 B 2 DISCOUNTS odt STOR ID VARCHAR 10 B EMPLOYEE xlsx v a LOWQTY VARCHAR 10 c Eb JOB csv w E5 HIGHQTY VARCHAR 10 D El PAYMENT xml DISCOUNT DOUBLE E PROJECT dbf Y E SALES html v STORES txt J CITY xml SAA 41 FILM docx Skip line s 1 E DISCOUNTTYPE 5 CALOWQTY HIGHOTY DISCOUNT E Initial Customer null null null 10 50 Volume Discount null 100 1 000 6 70 Customer Discount 8042 null null 5 00 Database DIOMED New table TESTER DISCOUN ya To remove a correspondence select the field in the Fields list and press the x Clear Field Ranges button To remove all correspondences press the e Clear All Ranges button If your OpenDocument Text file contains several tables you are able to set different mapping for each table Click the Next button to proceed to the Setting base data formatsf 501 step of the wizard 2 1 6 Step 5 Setting base data formats This step of the wizard provides a number of options for setting base formats for each source data file The specified format should match the source data representation O 1999 2014 EMS Database Management Solutions Ltd 51 Data Import for Interbase Firebird User s Manual Files Separators Constants EH COUNTAY xls Decimal Boolean true True CUSTOMER mdb DS les DEPARTMENT ods Thousand 160 Boolean false False A DISCOUNTS odt Ed EMPLOYEE xlsx
33. LS In this section the following specific file type options are set FILE_00_XLS SkipRows SkipCols the number of rows and columns in the source file to be skipped on import FILE_00_Access SourceType This option indicates the Access source type Table or query 0 stands for table and 1 for query TableName and query these options set the source Access table name to import from if source type is 0 and the source query text if the source type is 1 FILE_00_TXT SkipRows the number of rows in the source file to be skipped on import FILE_00_CSV SkipRows the number of rows in the source file to be skipped on import CSVDelimiter CSVRightQuot CSVLeftQuot these options are used on reading the source CSV file they store options for delimiting columns and the quotation marks The next section is FILE_XX_MAP It is also specific to the file type but is obligatory for all file types In this section correspondence between the source file columns and the destination table fields is set O 1999 2014 EMS Database Management Solutions Ltd s Data Import for Interbase Firebird User s Manual If the source file is an Excel file then the map is set in the following format lt DB_FieldName gt CellIndex Use semicolon to separate multiple cells You can define an Excel row or column as a range of cells e g Fieldi A1 A4 A6 A9 B1i F1 If the source file is an Access or DBF file then the mapping is set in
34. Languages amp Data Font 4 Excel Options a Interface Scheme name Officel1 Sample text edit j Sample button Sample check box Sample button edit Sample combo box Item 1 Item 2 ltem 3 Sample text memo edit 9 Sample radio button Sample group 4 Sample check box 1 E Sample check box 2 _ Sample check box 3 E Tree list item 1 Tree list item 2 Tree list item 3 For your convenience the previews illustrating the changes are displayed in the Sample Group area See also Setting general optionsf 691 Selecting program language 71 Setting data font 7A Setting Excel options 73 O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 3 Console application Additionally to the GUI version which is implemented in the form of a wizard application the installation package of Data Import for Interbase Firebird includes the console version which is intended for being run from Windows command line with a template file name used as the execution parameter C Program Files EMS Data Import for InterBase gt IbImportc exe Data Import for Interbase Firebird command line utility is intended for quick and powerful data import to Interbase Firebird tables Working with console application 7e Configuration file format 79 See also Wizard Application 23 1999 2014 EMS Databa
35. Management Solutions Ltd 12 Data Import for Interbase Firebird User s Manual 1 5 How to register Data Import To register your newly purchased copy of EMS Data Import for Interbase Firebird perform the following e receive the notification letter from Share it with the registration info e enter the Registration Name and the Registration Key from this letter e make sure that the registration process has been completed successfully check the registration information at the startup pagel 24 Register Data Import for InterBase and Firebird m Please enter the registration information you received when purchasing Data Import for InterBase and Firebird Registration Name Registration Key Bete ee ae See also How to buy Data Import ho 1999 2014 EMS Database Management Solutions Ltd 13 Data Import for Interbase Firebird User s Manual 1 6 EMS Data Import FAQ Please read this page attentively if you have questions about Data Import for Interbase Firebird Table of contents What is EMS Data Import for InterBase Firebird 13 e What do I need to start working with EMS Data Import for InterBase Firebird 13 e What is the difference between the Import feature of SQL Manager for InterBase Firebird and the Data Import for InterBase Firebird utility HA e Are there any limitations implied in the trial version as compared with the full one HA What is the easiest way to configure the template
36. NO INTEGER CUST_NO Number Ei CUSTOMER VARCHAR 25 CUSTOMER Text 25 Es CONTACT FIRST VARCHAR 15 CONTACT FIRST Text 15 CONTACT LAST VARCHAR 20 CONTACT LAST Text 20 PHONE NO VARCHAR 20 PHONE NO Text 20 Es ADDRESS LINE1 VARCHAR 30 ADDRESS LINE1 Text 30 Ex ADDRESS_LINE2 VARCHAR 30 ADDRESS_LINE2 Text 30 Database DIOMED Table TESTER CUSTO To remove a correspondence select a pair of fields in the list below and press the Remove button To remove all correspondences press the Clear button Click the Next button to proceed to the Setting base data formatsf 501 step of the wizard DBF Set correspondence between the source DBF columns and the target Interbase Firebird table fields e select a field of the target Interbase Firebird table in the Table Fields list 2 1 5 5 O 1999 2014 EMS Database Management Solutions Ltd 3 Data Import for Interbase Firebird User s Manual select the corresponding column of the source DBF table in the DBF Fields list click the Add button to set correspondence between the selected fields the pair of fields appears in the list below repeat the operation for all the fields you need to be included in the import process If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields ss if needed Use the corresponded c
37. SOL Manager net EMS Database Management Solutions zm Data Import for Interbase Firebird User s Manual 1999 2014 EMS Database Management Solutions Ltd DCHA oe G Be Data Import for Interbase Firebird User s Manual O 1999 2014 EMS Database Management Solutions Ltd All rights reserved This manual documents EMS Data Import for Interbase Firebird 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 accompanyit In no event shall the publisher and the author be liable for anyloss 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 oth
38. Set the appropriate font and the preferable charset using the corresponding drop down lists 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual v General yA Data Font Languages y Data Font Excel Options Interface Font amp MS Sans Seti y Charset DEFAULT_CHARSET Note that neither font nor character set changes can be applied to TXTMMA files See also Setting general options 691 Selecting program language 71 Setting Excel options 73 Defining interface style 7A 2 3 4 Excel Options The Excel Options page allows you to set the Max Col Width parameter which defines the maximum colunm width for Excel data grid O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual v General 3 A Excel Options Languages Data Font Excel Options Max Col Width 64 amp Interface See also Setting general options 6s Selecting program language 71 Setting data font 7A Defining interface stylel74 2 35 Interface This page allows you to customize the application interface style to your liking Use the Scheme name drop down list to select an interface scheme according to your liking Classic Office XP style Windows XP native style etc O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual General 9
39. Share it is a global e commerce provider for software and shareware sales via the Internet Share it accepts payments in US Dollars Euros Pounds Sterling Japanese Yen Australian Dollars Canadian Dollars or Swiss Franks by Credit Card Visa MasterCard EuroCard American Express Diners Club Bank Wire Transfer Check or Cash If you have ordered EMS software online and would like to review your order information or if you have questions about ordering payments or shipping procedures please visit our Customer Care Center provided by Share it Please note that all of our products are delivered via ESD Electronic Software Delivery only After purchase you will be able to immediately download the registration keys or passwords and download links for archives of full versions Also you will receive a copy of registration keys or passwords by e mail Please make sure to enter a valid e mail address in your order If you have not received the keys within 2 hours please contact us at salesOsqlmanager net To obtain MORE INFORMATION on this product visit us at http sqlmanager net en products ibfb dataimport Product distribution EMS Data Import for Interbase Firebird Business license 1 Year Maintenance EMS Data Import for Interbase Firebird Business license 2 Year Maintenance EMS Data Import for Interbase Firebird Business license 3 Year Maintenance EMS Data Import for Interbase Firebird Non commercial license
40. a gt gt L lt lt lt buttons or drag and drop operations to move the fields from one list to another O 1999 2014 EMS Database Management Solutions Ltd 62 Data Import for Interbase Firebird User s Manual Files Available columns Selected columns EP COUNTRY xls Ed FIRST NAME E EMP_NO 21 CUSTOMER mdb Ed LAST NAME JA DEPARTMENT ods PHONE_EXT DISCOUNTS odt Ed HIRE_DATE Ed EMPLOYEE xlsx DEPT_NO E JOB csv Ea JOB_CODE 2 PAYMENT xml Ed JOB_GRADE PROJECT dbf J0B COUNTRY E SALES html SALARY 15 STORES txt Ed FULL_NAME al CITY xml 1 FILM docx Database DIOMED ES Table TEsTER EMPLOY SKP this step WI Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generalls section of the Preferences s dialog When you are done press the Next button to proceed to the next stepf 62 2 1 10 Step 9 Setting common options Using this step of the wizard you can set final import options Commit Commit when done Check this option to commit the transaction after all records are imported Commit after each records These control allows you to define the number of records in each block to be supplemented with the COMMIT statement Rollback on error Check this option to rollback the transaction if an error occurred Record Count O 1999 2014 EMS Database Management Solutions
41. age maintenance tasks monitor their performance schedule frequency and the last execution result SQL Manager for SQL Server Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for SQL Server Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for SQL Server Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for SQL Server Migrate from most popular databases MySQL PostgreSQL Oracle DB2 InterBase Firebird etc to Microsoft SQL Server Data Generator for SOL Server Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for SQL Server Compare and synchronize the structure of your databases Move changes on your development database to production with ease DB Extract for SQL Server Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for SQL Server Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for SQL Server Compare and synchronize t
42. ated automatically You can manage destination table fieldsfs51 if needed Use the corresponded context menu item to Add Edit Drop field O 1999 2014 EMS Database Management Solutions Ltd 3 Data Import for Interbase Firebird User s Manual ES Add field ES Edit field Ei Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x If you choose a query as the data source you also can load a SQL query froma sq file or save the current query text to a file using the Load from File and the Save to File buttons correspondingly Use the Autofill button to set correspondence between the source and target fields automatically on the basis of their order Files Select import source COUNTRY xls Y 0 Access table CUSTOMER y 121 CUSTOMER mdb Y E hy DEPARTMENT ods y Pa b F DISCOUNTS odt a Ed EMPLOYEE xlsx Y A EL JOB csv Y PAYMENT ml a E i a an PROJECT dbf v Ms Th LA SALES tim y Ee CITY VARCHAR 25 EE CONTACT_LAST Text 20 STATE_PROVINCE VARCHAR 15 Autofill TA PHONE NO Text 20 J a loci ER COUNTRY VARCHAR 15 o ADDRESS_LINE1 Text 30 2 Z EX POSTAL_CODE VARCHAR 12 518 ADDRESS_LINE2 Text 30 W FILM docx ER ON_HOLD VARCHAR 1 E CITY Text 25 e El STATE PROVINCE Text i5 __ Table fields Access fields Esa CUST
43. cessary fields Use the corresponded context menu item to manage fields 85 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 33 Add field Edit field 3 Drop field Note If table was propery created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x Click the Next button to proceed to the Setting base data formats s01 step of the wizard 2 1 5 10 HTML Set correspondence between the target table fields and the source HTML file columns e select a field of the target Interbase Firebird table in the New fields list e proceed to the source grid viewer area click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination Interbase Firebird table have the same order of columns you can use the L y Auto Fill Columns mode default to set correspondence between them automatically If source file and destination Interbase Firebird table have different order of columns but identical names you can use the y Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use
44. d button the grid gets filled with Sub Nodes Text or Attributes values of the selected node Note if the source XML document contains huge amount of data building the tree may take a long time Set correspondence between the source XML file columns and the target Interbase Firebird table fields e select a field of the target Interbase Firebird table in the Fields list e proceed to the source grid viewer area click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process O 1999 2014 EMS Database Management Solutions Ltd 42 Data Import for Interbase Firebird User s Manual You can use the Autofill button to set correspondence between the source and target fields automatically according to their order mapping is started from the first attribute value in this case When you import data to a newly created table the Analyze button appears Use this button for automatic field creation The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well If necessary you can choose to skip a defined number of the source file lines using the Skip Lines spin edit Fies hag ha Le Bud tree Ed COUNTRY xIs Y 121 CUSTOMER mdb v New
45. development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for Oracle Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for Oracle Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for Oracle Migrate from most popular databases MySQL PostgreSQL MySQL DB2 InterBase Firebird 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual etc to Oracle Data Generator for Oracle Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters Sl DB Comparer for Oracle Compare and synchronize the structure of your databases Move changes on your development database to production with ease g DB Extract for Oracle Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for Oracle Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more 4 Data Comparer for Oracle Compare and synchronize the contents of your databases Automate your data migrations from develo
46. dit box to set the field name Note that the name of the field must be unique among all the field names in the table The Type tab defines the type of the field data Size Defines the size of the field value Scale For numeric and decimal types you need to define the number of decimal to the right of the decimal point Default value Define this option value if you need inserted records to get specified value Define character set and collation at the appropriate fields 1999 2014 EMS Database Management Solutions Ltd ss Data Import for Interbase Firebird User s Manual Y Not NULL Check this option to prevent the entry of NULL or unknown values in column O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 44 Add Edit Range To set a range of datals7 to be imported from the file use the Add range L button To remove a range use the Delete range za button To edit an existing range double click it in the Ranges list The Range dialog allows you to set a number of options for the range being edited Range Range Type TS Col A x Start Finish From Data Starting While Data Exists Start Row 1 Finish Row Direction Down Up Sheet Default Sheet Custom Sheet Sheet Number 9 Sheet Name Sheet 1 Iv Cancel Select Range Type from the corresponding drop down list Then specify the column row or cell number whose rang
47. ds used for access to the databases automatically upon closing the application Please note that checking this option saves the latest password used for connection to the database including the SSH server password Y Show field types Hides displays field type description in the field list Y Show number of created tables Use this option to allow disallow appearance of the correspondent information window Y Show number of mapped columns Displays the number of mapped fields on proceeding to Step 3 31 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 2 3 2 WlUse first row as caption fields Enable this option to use first rows as captions when mapping fields Analyse N rows Define the amount of rows used for source data analysis before table creation This analysis allows the program to define the destination table field type v Import to Views By setting this option on you can import data to views they will appear in the list of available tables at the Step 2 24 of Wizard Application 23 Vi Keep options at steps If this option is checked all your import settings will remain the same the next time the program is started Vi Allow script execution If this option is checked then the script entered on the Step 5 551 is always executed Skipped Steps Use this option group to define the Wizard application 23 steps to be skipped See also Selecting program la
48. e is to be defined Start and Finish section allows you to set the range of the values to be imported from the specified row or column Use the From Data Starting and While Data Exist options to automatically define the range of the values If neither start row column nor finish row column was specified you need to set range direction Down or 2 Up for column range and Right or Left for row range Use Sheet section to define the location of the row column for which the row was specified You can select either Default sheet or Custom Sheet For custom sheet you need to select Sheet Number or Sheet Name from the appropriate drop down list Note If Cell was set as Range Type the only thing you can specify at this dialog is its number O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual Credits Software Developers Alex Paclin Alexey Butalov Michael Kuzevanov Alexey Saybel Technical Writers Semyon Slobodenyuk Dmitry Doni Olga Ryabova Cover Designer Tatyana Mak urova Translators Anna Shulkina Serge Fominikh Team Coordinators Alexey Butalov Alexander Chelyadin Roman Tkachenko O 1999 2014 EMS Database Management Solutions Ltd
49. e testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for MySQL Compare and synchronize the structure of your databases Move changes on your development database to production with ease w dada DB Extract for MySQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for MySQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for MySQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database wA Scroll to top 16 O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual Microsoft SOL ES ia o dd B a Y 4 SQL Management Studio for SQL Server EMS SQL Management Studio for SQL Server is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before EMS SOL Backup for SQL Server Perform backup and restore log shipping and many other regular maintenance tasks on the whole set of SQL Servers in your company SOL Administrator for SQL Server Perform administrative tasks in the fastest easiest and most efficient way Man
50. e which can be used by the console application Q I work behind a firewall router Can EMS Data Import connect to a remote Interbase Firebird server A If due to the security policy accepted in your corporate network or by your host provider you cannot connect to your PostgreSQL server directly through TCP IP for example a firewall prevents this you can use SSH or HTTP tunneling feature of SQL Manager to fulfill your task Q Why cannot I connect to the local InterBase Firebird server A There are several reasons why you cannot connect to the local database If during connection you get the error Connection failed Server is stopped or unproper client library is used to establish connection to the server SQLCode 904 IB Error Number 335544375 then you should check if the port or service used for server connection is set correctly and if a local server is running To check if the service is launched open Control Panel gt Administrative Tools gt Services and find service InterBase Guardian if you use InterBase or Firebird Guardian if you use Firebird In case you find it run it with the Start button or use Start item in the context menu If you cannot launch this service then probably your server is installed incorrectly and you need to reinstall it Another possible reason for this error is that the client library version does not coincide with the server version If you get the error like Your user name and password are no
51. ed source file from the list Then specify ranges in the grid for the target and source fields e select a field of the target Interbase Firebird table in the Fields list e proceed to the Sheet grid click a column to assign the column to the selected target O 1999 2014 EMS Database Management Solutions Ltd 34 Data Import for Interbase Firebird User s Manual table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination Interbase Firebird table have the same order of columns you can use the 9 y Auto Fill Columns mode default to set correspondence between them automatically If source file and destination Interbase Firebird table have different order of columns but identical names you can use the 3 y Auto Fill by Captions mode to set the correspondence based on name s identity Note The number of the column for which correspondence was set is displayed at the Col control You can use it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fieldsles if needed Use the corresponded context menu item to Add Edit Drop field EH Add field Edit field 3 Drop field If necessary you can choose to skip a defined number
52. eed to the Sheet grid click a column caption to select the whole column or click the row number to select the whole row the selected column row of the source file gets green highlight and a new range indicating the source and target fields correspondence appears in the Ranges list e repeat the operation for all the fields you need to be included in the import process If the source file and the destination Interbase Firebird table have the same order of columns you can use the ly Auto Fill Columns mode default to set correspondence between them automatically If source file and destination Interbase Firebird table have different order of columns but identical names you can use the Auto Fill by Captions mode to set the correspondence based on name s identity You can also use the Late fill Rows to set the correspondence between destination table fields and source file rows If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fieldsles if needed Use the corresponded context menu item to Add Edit Drop field 33 Add field Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x If necessary you can choose to skip a defined number of the source file columns and
53. er formats is allowed as long as the actual content is not altered or edited in any way Document generated on 05 06 2014 3 Data Import for Interbase Firebird User s Manual Table of Contents Part Welcome to EMS Data Import utility 6 What s Te we a an 7 System require MENS cccccccccccccococonononononononononononononononononononononononononononcnnnnnonnnnnnnnnnnnnononnnnnnnns 8 installation Ino O A 9 How to buy Data Import cccccnmnccncncncncconnnnnnnnnanonnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnennnnnss 10 How to register Data IMpoOrt cococococonononononononononononononononnnnnnnn nono nono conc snis anno nn nn cnn nn nn nnnnnnnnannnnns 12 EMS Data Import FAQ ccsssseseeeeceesceacsssenseeseeeeeacaassnneeseeeeeacauseseenseseeeacaasesseneeseeeacaasssnenees 13 Other EMS Products wi cease ceeds Secateccaviczedacccacscgeasccedecscadascnssatecdsacedcenetscueceasencussgeccestees 16 Part Il Wizard application 23 Working with wizard application ccccccccccccccccccccccccnncnnnocononononononononononononononononononnnononononona 24 COTINO SM ii A n 24 Step 1 Setting connection properties mnmmniicicninnininiiinainananarrarnarr rr 25 Step 2 Selecting files to iMport o nnnnninninnoniciinininranari arica 27 Step 3 Setting XML file type AKAA HAI rr 30 Step 4 Mapping fields dt 31 MSC Oleole AA ee eit 32 MS Excel 2007 Vi AA AAA hee vas 33 MS Word 2007 pinra leet A ai pee eee iene 36 MS ACC A teu A
54. fields Grid Col xsi noNamespaceSchemaLocation JA DEPARTMENT ods Y city_id DOUBLE 3 av DISCOUNTS odt city VARCHAR 21 4 dty id EMPLOYEE xlsx v country_id DOUBLE 5 2 P Ed JOB csy Y last_update VARCHAR 15 6 last apela E 4 PAYMENT xml I PROJECT dbf Y K SALES html v dataroot CITY STORES txt Sub Nodes Text Fill grid 2 CITY xml uE Wi FILM docx Skip line s 0 z Node name Text city id city country id last update CITY 10000004 1 000000 A Corua La 87 000000 15 02 2006 E CITY 2 0000004b 2 000000 Abha 82 000000 15 02 2006 CITY 3 0000004b 3 000000 Abu Dhabi 101 000000 15 02 2006 CITY 4 0000004c 4 000000 Acua 60 000000 15 02 2006 CITY 5 0000004d 5 000000 Adana 97 000000 15 02 2006 CITY 6 000000Ad 6 000000 Addis Abebe 31 000000 15 02 2006 CITY 7 0000004d 7 000000 Aden 107 000000 15 02 2006 Databases DIOMED CITY 8 0000004d 8 000000 Adoni 44 000000 15 02 2006 New table TESTER CITY CITY 9 0000004h 9 000000 Ahmadnaga 44 000000 15 02 2006 dd To remove all correspondences press the e Clear All Ranges button If you choose to import data to the newly created table at this step you need to create necessary fields Use the corresponded context menu item to manage fields s5 ES Add field Edit field SS Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occurs during table creation this table will be marked with a cross x 1999
55. h the Secure SHell SSH tunnel or ey file e maja Please note that you need to have sufficient privileges to be able to write to the destination database on Interbase Firebird server Tunneling settings To setup the connection via SSH tunnel input the following values in the corresponding fields e SSH host name is the name of the host IP address where SSH server is running e SSH port indicates the port where SSH server is activated default is 22 e SSH user name stands for the user on the machine where SSH server is running Note it is a Linux Windows user not a user of Interbase Firebird server e SSH password is the Linux Windows user password Use Private Key for authentication If the SSH encryption is enabled on the SSH server a user can generate a pair of cryptographic keys the Private key and the Public key The Public key is placed on the SSH server and the Private key is the part you keep secret inside a secure box that can only be opened with the correct passphrase or an empty string as the passphrase When you wish to access the remote system you open the secure box with your passphrase if any and use the private key to authenticate yourself with the Public key 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual on the remote Linux computer SSH Key file Specify the location the secure box of the Private key file on your local machine Su
56. he contents of your databases Automate your data migrations from development to production database Scroll to top AN 1999 2014 EMS Database Management Solutions Ltd 18 Data Import for Interbase Firebird User s Manual PostgreSQL S9 SQL Management Studio for PostgreSQL EMS SQL Management Studio for PostgreSQL is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for PostgreSQL Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for PostgreSQL Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for PostgreSQL Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for PostgreSQL Migrate from most popular databases MySQL SQL Server Oracle DB2 InterBase Firebird etc to PostgreSQL Data Generator for PostgreSQL Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters DB Comparer for PostgreSQL Compare and synchronize the structure of your databases Move changes on yo
57. ing h or hh specifier and displays am for any hour before noon and pm for any hour after noon The am pm specifier can use lower upper or mixed case and the result is displayed accordingly a p Uses the 12 hour clock for the preceding h or hh specifier and displays a for any hour before noon and p for any hour after noon The a p specifier can use lower upper or mixed case and the result is displayed accordingly ampm Uses the 12 hour clock for the preceding h or hh specifier and displays the contents of the TimeAMString global variable for any hour before noon and the contents of the TimePMString global variable for any hour after noon O 1999 2014 EMS Database Management Solutions Ltd 55 Data Import for Interbase Firebird User s Manual Displays the date separator character using the Date Separator Displays the time separator character using the Time Separator XX XX Characters enclosed in single or double quotes are displayed as is and do not affect formatting 2 1 7 Step 6 Settings data formats for each field This step of the wizard allows you to set formats for each imported field separately in case additional formatting is required Select a field in the list and use the Field Customization group to adjust format options that will be applied to this field only generator value generator step constant value NULL value default value function script left right quotation quotation act
58. ion If you are installing Data Import for Interbase Firebird for the first time on your PC e download the Data Import for Interbase Firebird distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped run IbImportSetup exe from the local directory and follow the instructions of the installation wizard after the installation process is completed find the Data Import shortcut in the corresponding group of Windows Start menu Installation FAQs If you want to upgrade an installed copy of Data Import for Interbase Firebird to the latest version e download the Data Import for Interbase Firebird distribution package from the download page available at our site e unzip the downloaded file to any local directory e g C unzipped e close Data Import application if it is running e run IbImportSetup exe from the local directory and follow the instructions of the installation wizard See also System requirements 8 O 1999 2014 EMS Database Management Solutions Ltd 10 Data Import for Interbase Firebird User s Manual 1 4 Howto buy Data Import To make it easier for you to purchase our products we have contracted with share it registration service The share it order process is protected via a secure connection and makes online ordering by credit debit card quick and safe The following information about share it is provided for your convenience
59. ion character case character set Generator value Use this field to set the initial value of the autoincrement field Generator step Set the step of the autoincrement field If it is O or if the field is of Identity one then the value of the generator will be ignored Constant value Use this field to set a constant value for the field Null value Set the value which will be considered as NULL to set the default value Default value Set the default value of the NULL field 1999 2014 EMS Database Management Solutions Ltd s Data Import for Interbase Firebird User s Manual Files Field Field Customization Ed COUNTRY xls TE EMP_NO SMALLINT Generator value 0 El CUSTOMER mdb FIRST NAME VARCHAR 15 Generator step 0 s JA DEPARTMENT ods LAST_NAME VARCHAR 20 2 DISCOUNTS odt PHONE_EXT VARCHAR 4 o HIRE DATE TIMESTAMP 0 Null value JOB csw DEPT_NO VARCHAR 3 Default value 2 PAYMENT xml JOB_CODE VARCHAR 5 E PROJECT dbf JOB_GRADE SMALLINT daa a SALES html JOB_COUNTRY VARCHAR 15 Script I STORES txt SALARY DECIMAL 10 2 eae 2 CITY xml E FULL NAME VARCHAR 37 WP FILM docx ns Quotation action None y Char case As Is y Char set As Is y Replacements Text to Find Replace With Ignore Case dp a Database DIOMED oe Table TESTER EMPLOYE CSKP this step Function Use the drop down list to select one of the function return values that
60. le gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination Interbase Firebird table have the same order of columns you can use the y Auto Fill Columns mode default to set correspondence between them automatically If source file and destination Interbase Firebird table have different order of columns but identical names you can use the L y Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields 85 if needed Use the corresponded context menu item to Add Edit Drop field 33 Add field ES Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x 1999 2014 EMS Database Management Solutions Ltd so Data Import for Interbase Firebird User s Manual Fies L x JLo COUNTRY xls v 121 CUSTOM
61. mation on this issue please visit http openssh org SSH tunneling feature of SQL Manager is a means of ensuring secure connection to Interbase Firebird servers when working over insecure connection channels You can also use SSH tunnel to get access to the remote Interbase Firebird servers when the default port is closed for external connections due to some reasons The connection over SSH tunnel works in the following way First a connection is established and the process of authentication between SSH client built in SQL Manager and remote Interbase Firebird server is performed Then all incoming and outgoing information between the program and Interbase Firebird server is transmitted through SSH server with the help of a communication port usually it is 22 and SSH server transfers this information directly to Interbase Firebird server 1999 2014 EMS Database Management Solutions Ltd ss Data Import for Interbase Firebird User s Manual 4 3 Add Edit field When you import data with destination table creation you can manage this table s fields Use the context menu to Add Edit Drop a field 53 Add field Edit field 3 Drop field Selecting Add field or Edit field context menu item opens the field editor that allows you to view edit the properties of the destination table fields ES Edit Field Column NAME Type VARCHAR Size 50 Scale Default value Character set Collation Caneel Use the Column e
62. move all correspondences press the Clear button Click the Next button to proceed to the Setting base data formats 501 step of the wizard 2 1 5 6 XML Set correspondence between the source XML columns and the target Interbase Firebird table fields e select a field of the target Interbase Firebird table in the Table Fields list e select the corresponding column of the source XML table in the XML Fields list e click the Add button to set correspondence between the selected fields e the pair of fields appears in the list below e repeat the operation for all the fields you need to be included in the import process If new table creation was selected at the previous stepi then fields needed for the import procedure will be created automatically You can manage destination table fields 8s1 if needed Use the corresponded context menu item to Add Edit Drop field ER Add field ES Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x Use the Autofill button to set correspondence between the source and target fields automatically on the basis of their order Encoding Use this field to select the file encoding 1999 2014 EMS Database Management Solutions Ltd a Data Import for Interbase Firebird User s Manual Files New fields XML fields 3
63. mportAllRows 1 enabled 0 disabled SaveResultSQL 1999 2014 EMS Database Management Solutions Ltd er Data Import for Interbase Firebird User s Manual 1 enabled 0 disabled ResultSQLFile The path to the result sq file Im portKind 0 Universal Mode 1 Native Mode TruncateLongString 1 enabled 0 disabled RollbackIfError 1 enabled 0 disabled ImportMode 0 Insert All 1 Insert New 2 Update 3 Update or Insert 4 Delete 5 Delete or Insert ImportAddType 1 enabled 0 disabled AllowDuplicates 1 enabled 0 disabled NativeModeKind 0 Single Commands 1 Batch insert General This section stores information about the product name and its major version See also Working with console application 78 1999 2014 EMS Database Management Solutions Ltd es Data Import for Interbase Firebird User s Manual 4 Appendix 4 1 Supported file formats MS Excel The most popular e table format used by Microsoft Excel x ls The result files are fully compatible with Microsoft Excel versions 97 2000 2003 and XP MS Access File of Microsoft Access format mdb with an ADO connection used HTML Hyper Text Markup Language file format html htm complete compatibility with HTML 4 0 specification Text file Plain text file format txt o CSV file Comma Separated Value file format csv Note all the text formats i
64. n Delphi or C Builder Advanced Query Builder Advanced re Builder is a powerful component suite for Borland Delphi and C Builder intended for visual building SQL statements for the SELECT INSERT UPDATE and DELETE clauses Advanced Excel Report for Delphi is a powerful band oriented generator of template based reports in MS Excel gt Advanced Excel Report Advanced Localizer Advanced Localizer is an indispensable component suite for Delphi for adding multilingual support to your applications Source Rescuer mba EMS Source Rescuer is an easy to use wizard application for Borland Delphi and C Builder which can help you to restore your lost source code Scroll to tope 1999 2014 EMS Database Management Solutions Ltd 23 Data Import for Interbase Firebird User s Manual 2 Wizard application Data Import for Interbase Firebird wizard application provides easy to use wizard interface to set all data import parameters visually Working with wizard application 2A Using configuration files s7 Setting program preferencesfes ES Data Import for InterBase and Firebird Lo J O lees Welcome to Data Import for InterBase and Firebird This Wizard helps you to import data from XLS XLSx MDB DBF TXT CSV XML DOCx HTML ODS and ODT files to InterBase Fe and Firebird database tables Click Next to start working with the wizard Data Product Information Import Ne Tor Develo
65. ncluding Text file CSV are usually used as working or interchange formats XML A markup language for documents containing structured information xm 9 DBF Database file format dbf used by dBASE and a number of xBASE applications MS Excel 2007 The contemporary e table format used by Microsoft Excel 2007 xlsx The result files are fully compatible with Microsoft Excel 2007 MS Word 2007 The contemporary text processing format used by Microsoft Word 2007 docx The result files are fully compatible with Microsoft Word 2007 ODF Spreadsheets OASIS Open Document Format for Office Applications open document file format for spreadsheets ods used by a number of applications including OpenOffice org and KOffice ODF Text OASIS Open Document Format for Office Applications open document file format for word processing odt documents used by a number of applications including OpenOffice org and KOffice 1999 2014 EMS Database Management Solutions Ltd e Data Import for Interbase Firebird User s Manual 4 2 SSH tunneling options SSH Secure Shell Host protocol is used to heighten computer security when working with Unix systems on the Internet SSH uses several encryption algorithms of different reliability The spread of SSH is also connected with the fact that a number of Linux like OS s for example FreeBSD include SSH server in their standard integration To learn more infor
66. ng is correct press the Import button to start the process If you want to change something you can return to any of the wizard steps using the Back button Y Continue if before import e4 script is executed with errors Check this option to ignore errors in Before Script execution during import Y Close progress when done If this option is selected the child window indicating the import progress is closed automatically when the import process is completed Parallel execution Check this option to perform several files import process simultaneously Eg Data Import for InterBase and Firebird hoe Step 11 of 11 Click the Import button to start data import process V Continue if before import script is executed with errors E Close progress when done F Parallel execution 38 04 020 Import from C EMS Data Export for InterBase amp Firebird COUNTRY odt Data l into C Program Files Firebird Firebird_1_5 examples MySecure employee fdb COUNTRY is started Import 15 rows processed from C EMS Data Export for InterBase amp Firebird COUNTRY odt for 2 rows inserted InterBase 13 rows updated Firebird 12 38 04 383 Import process finished successfully Save log to file Clear log ob Cra Save log to file This button calls the Save file dialog which allows you to save the on screen log to a file Clear log 1999 2014 EMS Database Management Solutions
67. nguage 71 Setting data font 72 Setting Excel options 73 Defining interface style 7 Languages The Languages page is provided for managing Data Import localization files You can create your own Ing files similar to those available in the Yoprogram directory Yo Languages folder add them to the list of available languages and set the new language as the program interface language The table lists all the languages available for localization and the corresponding Ing files O 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 2 3 3 General e Data Font Excel Options Interface i C Program Files EMS Data Import for InterBase amp FirebirdLanguages C Program Files EMS Data Import for InterBase amp Firebird Languages C Program Files EMS Data Import for InterBase amp Firebird Languages C Program Files EMS Data Import for InterBase amp Firebird Languages File Name Language Directory j C Program Files EMS Data Import for InterBase Firebird Languages J Language Directory Use the ellipsis L button to specify the directory where the Ing files are stored by default See also Setting general optionsles Setting data fontl7 Setting Excel options 73 Defining interface stylel741 Data Font The Data Fonts page is provided for setting up the fonts for displaying data in Data Import for Interbase Firebird
68. nonononons 78 Configuration file format omomononononnnnnnnnnnnnnnnannnnnnanananananananannnannnnnn nn 79 Part IV Appendix 83 Supported file formats IIIA AIKA AKANA nnne 83 SSH tunneling Options cccccccccccccocccncoconncncnonononononononononononononononononononononononononnnnnnnnnnnnnnnnnnnons 84 Add Edit field cccccccccccccccccococncncncncoconononnconononnnnnnnnnnonononononononononononononnnonononononononnnnnnnononononona 85 Add Edit Range m cccccccccccccncncncncnononononononononononononononononononononononononononnnononononononononnnnnannnnnnnnnnnnns 87 O 1999 2014 EMS Database Management Solutions Ltd 6 Data Import for Interbase Firebird User s Manual 1 Welcome to EMS Data Import utility EMS Data Import for Interbase Firebird is a powerful program to import your data quickly from MS Excel Excel 2007 MS Word 2007 MS Access DBF TXT CSV Open Document HTML files to Interbase Firebird tables It provides adjustable import parameters including source data formats for all the fields and destination data formats for the selected fields commit options number of records to skip etc Data Import for Interbase Firebird includes a wizard which allows you to set all the import options for different files visually and a command line utility to execute import in one touch Visit our web site http www sqlmanager net for details Key features e Import from most popular formats MS Excel 97 2007 MS Access XML DBF TXT
69. o set correspondence between them automatically If source file and destination Interbase Firebird table have different order of columns but identical names you can use the 3 Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields s51 if needed Use the corresponded context menu item to Add Edit Drop field 33 Add field Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x 1999 2014 EMS Database Management Solutions Ltd Data Import for Interbase Firebird User s Manual 2 1 5 4 Fie Ep E Ex COUNTRY xls Y 121 CUSTOMER mdb Y New fields Grid Column A JA DEPARTMENT ods Y film id VARCHAR 10 1 A DISCOUNTS odt Ed title E EMPLOYEE xlsx wv i El JOB csv w El language id VARCHAR 10 a PAYMENT xm Ed original language id VARCHAR 10 PROJECT dbf i EX rental duration VARCHAR 10
70. of columns but identical names you can use the 9 y Auto Fill by Captions mode to set the correspondence based on name s identity The number of the column which correspondence is set for are displayed at the Grid Column column You can use it for setting the fields correspondence as well O 1999 2014 EMS Database Management Solutions Ltd as Data Import for Interbase Firebird User s Manual If new table creation was selected at the previous stepl27 then fields needed for the import procedure will be created automatically You can manage destination table fields 8s if needed Use the corresponded context menu item to Add Edit Drop field ER Add field 33 Edit field 3 Drop field If necessary you can choose to skip a defined number of the source file rows using the Skip lines spin edit Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x fies yx Ju Ed COUNTRY xls Y 121 CUSTOMER mdb w Fields IA DEPARTMENT ods Y Ed DEPT_NO VARCHAR 3 DISCOUNTS odt e a VARCHAR 25 EP EMPLOYEE xlsx v j E JOB csv Y Ed MNGR_NO SMALLINT 2 PAYMENT xml Ed BUDGET DECIMAL 12 2 PROJECT dbf w Fa LOCATION VARCHAR 15 VE SALES html Y a PHONE_NO VARCHAR 20 EF STORES txt 2 CITY xml 13 FILM docx o E Sheet1 DEPT_NO DEPARTME HEAD DEP MNGR_NO BUDGET LOCATION PHONE_NO
71. ontext menu item to Add Edit Drop field Sy Add field ES Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x Use the Autofill button to set correspondence between the source and target fields automatically on the basis of their order Charset Use this field to specify the source file character set Skip deleted rows Use the option to exclude records marked as deleted in source DBF file Files Fields F fields COUNTRY xls w a PRODUCT VARCHAR 12 EG PROJ_ID Char 5 21 CUSTOMER mdb Y 3 PROJ NAME Char 20 JA DEPARTMENT ods Y Autofil Ed PROJ_DESC Memo DISCOUNTS odt i TEAM LEADE Number 11 0 EMPLOYEE xlsx Y Ei PRODUCT Char 12 E JOB csv Y z PAYMENT xml PROJECT dbf Y VE SALES html Y STORES txt lt one mi 3 CITY xml WE FILM docx Table fields DBF fields ER PROJ ID VARCHAR 5 PROJ ID Char 5 Ex PROJ NAME VARCHAR 20 PROJ NAME Char 20 BB PROJ_DESC LONG VARCHAR PROJ_DESC Memo TEAM_LEADER SMALLINT TEAM LEADE Number 11 0 Database DIOMED Table TesTERPROJEC Peer O 1999 2014 EMS Database Management Solutions Ltd 4 Data Import for Interbase Firebird User s Manual To remove a correspondence select the pair of fields in the list below and press the Remove button To re
72. ou import data to a newly created table the Analyze button appears Use this button for automatic field creation O 1999 2014 EMS Database Management Solutions Ltd a Data Import for Interbase Firebird User s Manual Fies L Jx 4 ET COUNTRY xls 121 CUSTOMER mdb JA DEPARTMENT ods DISCOUNTS odt Ed EMPLOYEE xlsx E JOB csv 2 PAYMENT xml PROJECT dbf E SALES html I STORES txt 2 CITY xml New fields Pos Le E STOR NAME VARCHAR 39 4 39 Fneedng Windows default Js E STOR ADDRESS VARCHAR 43 22 V Auto scroll ES CITY VARCHAR 32 65 32 ES ST ZIP VARCHAR 19 97 19 4 54 S44 STOR_ADDRESS 788 Catamaugus Ave 567 Pasadena Ave 577 First St 24 A Avogadro Way 89 Madison St 679 Carson St Database DIOMED New table TESTER STORES Double click in the text viewer area to add remove vertical separator To remove all correspondences press the Ax Clear All Ranges button If you choose to import data to the newly created table at this step you need to create necessary fields Use the corresponded context menu item to manage fields 85 EH Add field ES Edit field 3 Drop field Note If table was properly created or already exist it will be marked with a tick Y If an error occur during table creation this table will be marked with a cross x Click the Next button to proceed to the Setting base data formats s01 step of the wizard
73. ped 26 07 1992 1 04 08 1992 1 15 09 1992 1 y v9a2004 1010 118 shipped 130 10 19931 02 12 19931 15 11 19931 y v33 3100 1010 118 shipped 20 08 1993 1 20 08 1993 1 null y V92F3004 1012 11 shipped 115 10 19921 16 01 19931 16 01 19931 y vaaraose 1012 134 shipped 27 08 19931 08 09 1993 1 null n Database DIOMED V93F2030 1012 134 open 12 12 1993 null null y v Table TESTER SALES m To remove all correspondences press the Me Clear All Ranges button Click the Next button to proceed to the Setting base data formats s01 step of the wizard 2 1 5 11 ODS The OpenDocument format is used by Mobile Office as well as other well known desktop applications such as OpenOffice StarOffice and KOffice ODS stands for OpenDocument Spreadsheet o0ds Specify ranges in the grid for the target and source fields e select a field of the target Interbase Firebird table in the New fields list e proceed to the Sheet grid click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination Interbase Firebird table have the same order of columns you can use the La Auto Fill Columns mode default to set correspondence between them automatically If source file and destination Interbase Firebird table have different order
74. pers Alex Paclin Dmitry Schastlivtsev Paul Leonov InterBase Homepage http www sqlmanager net products ibfb dataimport Firebird A Support Ticket System http www sqlmanager net support Version 3 7 0 build 43387 Registered to EMS Business license Enter Registration Code Help Tools M lt lt Back Close See also Console Application 7A 1999 2014 EMS Database Management Solutions Ltd 2a Data Import for Interbase Firebird User s Manual 2 1 Working with wizard application Follow the steps of the wizard to import data to Interbase Firebird tables for your needs Getting started 24 Step 1 Setting connection properties 25 Step 2 Selecting files to impot hA Step 3 Setting XML file type 30 Step 4 Mapping fields 31 Step 5 Setting base data formats 50 Step 6 Setting data formats for each field 551 Step 7 Specifying import models Step 8 Selecting key columns to exclude from import processle1 Step 9 Setting commit optionsl 2 Step 10 Defining scripts to execute before and after import Isa Step 11 Start of data import processles See also Using data import configuration files 67 Setting program preferences eg 2 1 1 Getting started This is how Data Import for Interbase Firebird wizard application looks when you first start it This page allows you to view registration information If you have not registered Data Impor
75. pment to production database al Scroll to tope DB2 SQL Management Studio for DB2 EMS SQL Management Studio for DB2 is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before SQL Manager for DB2 Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways Data Export for DB2 Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Data Import for DB2 Import your data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for DB2 Migrate from most popular databases MySQL PostgreSQL Oracle MySQL InterBase Firebird etc to DB2 Data Generator for DB2 Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters H B DB Comparer for DB2 Compare and synchronize the structure of your databases Move changes on your development database to production with ease O 1999 2014 EMS Database Management Solutions Ltd 21 Data Import for Interbase Firebird User s Manual DB Extract for DB2 Create database backups in the form of SQL scripts sa
76. port for InterBase Firebird JOB xls C employee fdb Insert into existing table ES DEPARTMENT a ES DISCOUNTS EMPLOYEE ES EMPLOYEE_PROJECT ES EMPLOYEE_UPD ES EMS_FAVORITES_STORAGE ES IFM REPORTS ES ILLUSTRATION ES INVENTORY aa WS ES JOB NEW ES JOBS ES LLUSTRATION ER DAMA EMT m Create new table OK Cancel File name field displays the selected file name and its location Database field allows you to specify the target database 9 Insert into existing table Select this option to import data to the existing table Tables area contains the list of tables in the selected database You can refresh the list by clicking the Refresh button 9 Create new table Use this option to create import destination table To change the target Interbase Firebird table that has been already assigned to a source data file select the table in the list and press the ellipsis L button to call the Select Table dialog again When you are done press the Next button to proceed to the next stepI31 2 1 4 Step 3 Setting XML file type This step appears if you have selected xml file for importing data from O 1999 2014 EMS Database Management Solutions Ltd 31 Data Import for Interbase Firebird User s Manual Files XML file 2 HR__DEPARTMENT_ mdt a oa la HR_EMPLOYEE xml Auto Detect XML MS Access XML Data Packet XML Doc File Database DemoDB Tables HR EMPLOYEE
77. pported Private Key file formats are OpenSSH Putty SSH com Note that you need to trust your local machine not to scrape your passphrase or a copy of your Private key file while it is out of its secure box Passphrase dialog Please enter the passphrase for the key Cancel If you get any difficulties connecting to the database it can be useful to look through FAQs 13 When you are done press the Next button to proceed to the next step 2 Step 2 Selecting files to import At this step you should select source file s to be imported Click the Add File button to select the source file name using the Open file dialog Repeat this operation to add more source files if necessary You can choose among the following types of the source data file e MS Excel MS Excel 2007 MS Word 2007 MS Access DBF TXT CSV HTML KML Data Packet KML MS Access KML Doc ODS ODT The open file dialog allows you to set a filter on the source file format If you have selected the file of a format that is not supported the Select Import Type dialog appears O 1999 2014 EMS Database Management Solutions Ltd 28 Data Import for Interbase Firebird User s Manual f Select Import Type l File name C EMS docs film dbt Import Type f MS Excel 2007 MS Access MS Word 2007 DBF HTML TXT XML Document csv ODS XML ODT Associate Extension OK Cancel Here you can select
78. rid Column column You can use it for setting the fields correspondence as well Files 8 Je LJ e COUNTRY xls Y o 21 CUSTOMER mdb y Fields Grid Column Delimiter y JA DEPARTMENT ods y JOB CODE VARCHAR 5 1 Quote r A DISCOUNTS oat 3 JOB_GRADE SMALLINT 2 i E EMPLOYEE xlsx Y 3 JOB COUNTRY VARCHAR 15 3 Encoding El JOB csv E JOB_TITLE VARCHAR 25 4 Windows default E PAYMENT xml 8 MIN_SALARY DECIMAL 10 2 PROJECT dbf v 3 MAX_SALARY DECIMAL 10 2 E SALES html vY 2 JOB_REQUIREMENT LONG VARC Em STORES txt ES LANGUAGE REO VARCHAR 91 a CITY xml Wi FILM docx Skipline s 1 E Column_1 Column_2 Colum 3 Colum 4 Colum 5 Column_6 Column_ Columrn 8 JOB CODE J0B_GRADI JOB_COUN JOB TITLE MIN_SALAF MAK SALAF JOB_REQUI LANGUAC CEO 1 USA Chief Execul 130 000 00 250 000 00 No specific null CFO 1 USA Chief Financ 85 000 00 140 000 00 15 years in null VP 2 USA Vice Preside 80 000 00 130000 00 No specific null Dir 2 USA Director 75 000 00 120 000 00 5 10 years e null Mngr 3 USA Manager 60 000 00 100000 00 BA BS requ null Mnar 4 USA Manager 30000 00 60000 00 5 years offi null Database DIOMED Admin 4 USA Administratiy 35 000 00 55 000 00 3 5 years ex null X Table TESTER JOB SLY WJ tas To remove all correspondences press the Clear All Ranges button If you choose to import data to the newly created table at this step you need to create ne
79. s installed on your local machine In this case the defined in the External file name field file is created with the necessary data and then this data is copied to the created table be means of the server With the help of the Native mode your data can be imported dozen times faster as compared to the Universal mode which is used for backward compatibility If you have chosen Universal mode and the import mode is set to Insert new Update or insert Delete or insert then the ZI Allow duplicates option can be set If it is chosen then on inserting a record in a table it will be inserted even if it coincides with an existing one but the key fields differ v Truncate Long Strings If this option is enabled the long strings are truncated This option is available only in the Universal mode v Skip this step Check this option to skip the current step in the future To edit the list of skipped steps use the Skipped Steps group available in the Generall s section of the Preferencesl 9 dialog When you are done press the Next button to proceed to the next steple1 2 1 9 Step 8 Selecting key columns This step of the wizard allows you to select the fields of the table to be used as the key fields for the import process This step is not available if the Insert all option has been selected on the previous step TSA To select a field you need to move it from the Available Columns list to the Selected Columns list Use the ki
80. se Management Solutions Ltd Data Import for Interbase Firebird User s Manual 3 1 Working with console application All the import options are set in template itm files A template can be also used in the Console version of Data Import for Interbase Firebird To create a template file follow the instructions below e start Data Import Application wizard 231 e set all the required options in all steps of the wizard e test the import process at the last step e save all import options in the template s7 Console application also generates the log file that contains information about the import operation completion The easiest way to start Data Import for Interbase Firebird console application is to double click the generated itm template The other way is to enter the command line and type the appropriate command Usage lt path to Data Import for Interbase Firebird console application gt 11bImportC exe TemplateFile datafile lt source file name gt B datafile Indicates the source file for data import TemplateFile Stands for the itm template file to be used as the console version execution parameter B Use this parameter in the command line to run the console version of Data Import for Interbase Firebird in the background mode Example C Program Files EMS Data Import for InterBase amp Firebird IbImportC exe C EMS DataImport Templatel itm B Note The following exit codes can be returned by
81. t and press the x Clear Field Ranges button To remove all correspondences press the Clear All Ranges button If your spreadsheet file contains several sheets you are able to set different mapping for each sheet To clear ranges for a field select the field in the Fields list and press the Clear Field Ranges Lx button To clear all ranges specified for the target table fields press the Clear All ranges ES button To set a range of datals7 to be imported from the file use the Add range button To remove a range use the Delete range Le button Using the Move Up Le and the Move Down Le buttons you can change the order of ranges applied to data Click the Next button to proceed to the Setting base data formats 50 step of the wizard 1999 2014 EMS Database Management Solutions Ltd 36 Data Import for Interbase Firebird User s Manual 2 1 5 3 MS Word 2007 Specify ranges in the grid for the target and source fields e select a field of the target Interbase Firebird table in the New fields list e proceed to the Table grid click a column to assign the column to the selected target table field e the selected column of the source file gets gray highlight e repeat the operation for all the fields you need to be included in the import process If the source file and the destination Interbase Firebird table have the same order of columns you can use the L y Auto Fill Columns mode default t
82. t defined Ask your database administrator to set up a Firebird login SQL Code 902 IB Error Number 335544472 then the reason for this is that the registration data you enter are absent in your server security database You should register the user with the proper login and password on your server Q Why cannot I connect to a remote InterBase Firebird server A There could be several possible reasons that prevent you from successful connection to remote database If the error message says Connection failed Server is stopped or unproper client library is used to establish connection to the server SQLCode 904 IB Error Number 335544375 then probably you should check the correctness of port and host name you ve entered and also if the remote server is run It often happens that the port through which the connection is set with InterBase Firebird server normally it s 3050 is closed for the security reasons by local firewall corporate firewall or remote server firewall Please check this with your system administrator or ISP In order to avoid this limitation you can use SSH tunnel 50 55 1999 2014 EMS Database Management Solutions Ltd 15 Data Import for Interbase Firebird User s Manual If the error message says Your user name and password are not defined Ask your database administrator to set up a Firebird login SOL Code 902 IB Error Number 335544472 then the reason is that the user doesn t have permission to access the
83. t for Interbase Firebird yet you can do it by pressing the Register button and entering your registration information 121 O 1999 2014 EMS Database Management Solutions Ltd 25 Data Import for Interbase Firebird User s Manual ES Data Import for InterBase and Firebird kajta Welcome to Data Import for InterBase and Firebird This Wizard helps you to import data from XLS XLSx MDB DBF TXT CSV XML DOCx HTML ODS and ODT files to InterBase and Firebird database tables Click Next to start working with the wizard pas Product Information mp Developers Alex Paclin Dmitry Schastlivtsev Paul Leonov for InterBase Homepage http www sqlmanager net products ibfb dataimport Firebird Support Ticket System http www sqlmanager net support Version 3 7 0 build 43387 Registered to EMS Business license Enter Registration Code Help Tools N Back Press the Next button to proceed to Setting connection properties 251 See also How to buy Data Import ho Step 1 Setting connection properties At this step you should specify necessary settings to establish connection to the target Interbase Firebird database Connection settings For connection you should enter Interbase Firebird host name in the Host field and specify the preferable Network protocol TCP IP NetBEUI Novel SPX The Host drop down list contains the list of already registered hosts For both types you
84. teps use the Skipped Steps group available in the Generall s section of the Preferencesl 9 dialog When you are done press the Next button to proceed to the next stepf551 2 1 6 1 Format specifiers The following format specifiers are supported in the format string Float Integer format 0 Digit place holder If the value being formatted has a digit in the position where the O appears in the format string then that digit is copied to the output string Otherwise a O is stored in that position in the output string Digit placeholder If the value being formatted has a digit in the position where the appears in the format string then that digit is copied to the output string Otherwise nothing is stored in that position in the output string Decimal point The first character in the format string determines the location of the decimal separator in the formatted value any additional characters are ignored TA Thousand separator If the format string contains one or more characters the output will have thousand separators inserted between each group of three digits to the left of the decimal point The placement and number of characters in the format string does not affect the output except to indicate that thousand separators are wanted E Scientific notation If any of the strings E E e or e are contained in the format string the number is formatted using scientific notation
85. the following format lt DB_FieldName gt lt Source_Field_Name gt If the source file is a TXT file the mapping looks in the following way lt DB_FieldName gt lt Position gt lt Size gt This means that you should provide the starting position and the size of the source file column for each destination field To set mapping for a CSV file provide a column number for each destination field e g Field1 1 Field2 4 etc The properties that are set in sections FILE_XX_BASE_FORMATS and FILE_XX_IMPORT_OPTIONS correspond to those set on the Base Formats and the Options tabs The values that stand for BOOLEAN TRUE and BOOLEAN FALSE values are set in sections FILE_XX_BOOLEAN_ TRUE and FILE_XX_BOOLEAN_FALSE The NULL values are set in section FILE_XX_NULL_ VALUES Data formats that are set for each destination field separately are stored in sections named in the following way FILE_XX_DATA_FORMATS_ lt FIELD_NAME gt e g FILE 00 DATA FORMATS FIELDI The properties within these sections also correspond to the properties set on the Data Formats tab of the Settings data formatsf 551 step for each field FILE_00_IMPORT_OPTIONS This section contains parameters that define import options specified on Steps 6 9 of the wizard CommitAfterDone 1 enabled 0 disabled CommitRecCount The number of records in each block to be supplemented with the COMMIT statement ImportRecCount 1 enabled 0 disabled I
86. ur data from MS Access MS Excel and other popular formats to database tables via user friendly wizard interface Data Pump for InterBase Firebird Migrate from most popular databases MySQL SQL Server Oracle DB2 PostgreSQL etc to InterBase Firebird ES Data Generator for InterBase Firebird Generate test data for database testing purposes in a simple and direct way Wide range of data generation parameters sz DB Comparer for InterBase Firebird lt Compare and synchronize the structure of your databases Move changes on your development database to production with ease El DB Extract for InterBase Firebird Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SOL Query for InterBase Firebird Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more ER Data Comparer for InterBase Firebird Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to toph Oracle 89 SQL Management Studio for Oracle EMS SQL Management Studio for Oracle is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before Ei SQL Manager for Oracle Simplify and automate your database
87. ur development database to production with ease o dd B DB Extract for PostgreSQL Create database backups in the form of SQL scripts save your database structure and table data as a whole or partially SQL Query for PostgreSQL Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more 4 Data Comparer for PostgreSQL Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top 5 InterBase Firebird gt SQL Management Studio for InterBase Firebird EMS SQL Management Studio for InterBase and Firebird is a complete solution for database administration and development SQL Studio unites the must have tools in one powerful and easy to use environment that will make you more productive than ever before ER SOL Manager for InterBase Firebird Simplify and automate your database development process design explore and maintain existing databases build compound SQL query statements manage database user rights and manipulate data in different ways O 1999 2014 EMS Database Management Solutions Ltd to Data Import for Interbase Firebird User s Manual 5 Data Export for InterBase Firebird Export your data to any of 20 most popular data formats including MS Access MS Excel MS Word PDF HTML and more Ca Data Import for InterBase Firebird Import yo
88. ve your database structure and table data as a whole or partially ES SQL Query for DB Analyze and retrieve your data build your queries visually work with query plans build charts based on retrieved data quickly and more Data Comparer for DB2 Compare and synchronize the contents of your databases Automate your data migrations from development to production database Scroll to top 16 Tools 8 components Advanced Data Export Component Suite for Borland Delphi and NET will allow you to save your data in the most popular office programs formats pr Advanced Data Export Advanced Data Export NET E Advanced Data Export NET is a component suite for Microsoft Visual Studio NET 2003 2005 2008 and 2010 that will allow you to save your data in the most popular data formats for the future viewing modification printing or web publication You can export data into MS Access MS Excel MS Word RTF PDF TXT DBF CSV and more There will be no need to waste your time on tiresome data conversion Advanced Data Export will do the task quickly and will give the result in the desired format Advanced Data Import Component Suite for Delphi and C Builder will allow you to import your data to the database from files in the most popular data formats pal Advanced Data Import 1 12 Advanced PDF Generator f Advanced PDF Generator for Delphi gives you an opportunity to create PDF documents with your applications written o
89. which import type for supported file formats should be applied to import the selected file To delete a file from the list select it and click the ig Remove File button You can also change the order of the source files in the list using the Up e and the Down he buttons O 1999 2014 EMS Database Management Solutions Ltd 2 Data Import for Interbase Firebird User s Manual de Add file g Remove file e a File Table SH C EMS docs COUNTRY xls DEMODB HumanResources COUNTRY 21 C EMS docs CUSTOMER mdb DEMODB HumanResources CUSTOMER E C EMS docs DEPARTMENT ods DEMODB HumanResources DEPARTMENT E CAEMSAdocsiDISCOUNTS odt DEMODB HumanResources DISCOUNTS Ed C EMS docs EMPLOYEE xlsx DEMODB HumanResources EMPLOYEE 2 C EMS docs JOB csv DEMODB HumanResources JOB 2 C NEMS docs PAYMENT xml DEMODB HumanResources PAYMENT E DEMODB HumanResources PRODUCT 4 C SEMS docs PROJECT dbf DEMODB HumanResources PROJECT Note For the spreadsheet files if you need to import data from different sheets into different tables you are to include that multi sheet spreadsheet file into the list several times equal to the number of sheets to be imported to different tables When a file is selected the Select Table dialog appears 1999 2014 EMS Database Management Solutions Ltd 30 Data Import for Interbase Firebird User s Manual Select Table ES File name C EMS Data Ex

Data Import for Interbase/Firebird

Contents

Download Pdf Manuals

Related Search

Related Contents