Importing and Exporting Data
 
The Import Dialog
 
Use Tools | Import data... to import data from a file or URL:
 
 
The URL can be specified using any of the protocols http, https, or ftp.  For example, to import a file from an FTP server, you can use a url of this form:
    ftp://(user)@(password):(host)/(file)
 
The three dot buttons are "chooser" buttons for the file and table boxes.  Use the "Append data" radio button to append data to an exisitng file, and use "Replace when key matches" to merge data into an existing file.
 
Entrance import supports these formats:  tab delimited, comma separated (CSV), space separated, colon separated, and simple lines of text.  
 
Space separated format  is an unusual Entrance feature:  use it when you need to break lines into tokens separated by one or more spaces.  It turns out to be very handy for reading text output from command line applications like "ls", for example.
 
The Export Dialog
 
 
The export dialog can be used to write files in tabbed, CSV, or HTML format.  You can use it to write complete tables or to filter them using the match box.  
 
To export a complete table, enter a table name in the table box or select one using the three dot chooser button.  The table must be in the current database, otherwise it will generate an error message.  Then select an output format and click OK.
 
To export a filtered table, open a table in Entrance, then enter a match pattern or WHERE clause in the match box.  Now when you open the export dialog you will see a message below the table box like this:
 
 
and only those rows that match what is in the where box will be exported.  This feature is designed to work well with "data painting", which you will read about later:  It makes it easy to export only the "blue" data points, for example.
 
 
 
Please note:  This web page and other Entrance documentation web pages are copyrighted material and have not been released under the terms of the GPL.
 
Copyright (c) 2007 dbEntrance Software, All Rights Reserved                        
 
Java and the Java Coffee Cup Logo are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.  Solaris is a trademark of Sun Microsystems, Inc.  MySQL is a registered trademark of MySQL AB in the United States, the European Union and other countries.  Windows is a trademark of Microsoft Corporation.  Macintosh and Apple Numbers are  trademarks of Apple Computer, Inc.