Data Flask 1.1 Data Flask 1.1
C|Net Screenshots and Download. (3/11/2007 -
1.1, Build 5)
New in version 1.1: Sql Scripting
DDL Script menu pick.
All Data definition and modification can now be routed to an SQL Script window. From there it can be reviewed and run.
CreateTable.sql DDL Script
SQL syntax will change based on the data source (supported providers). DML limits updates to rows where there are differences between the spreadsheet and the data store.
Sample SQL migration Script: ProductsMsSql.sql (text) (NWind.Products (mdb) to MS SQL Express).
New in version 1.1: Update Preview
UPDATE, APPEND and DELETE preview spreadsheets. Review differences between the .dfg grid and the data store.
New in version 1.1: Blank, Nothing, Null.
Metadata for Zero
Cell values can be set to Blank, Null, or Nothing (Default on append, Ignore on update).
Data Flask .dfg spreadsheets hold both cell value and type information. Non-text types such as float, date, timestamp and blob are held native.
Data Flask copies and disconnects from the data store, remaining disconnected during editing.
New columns, keys, indexes and connection strings can be added to the .dfg spreadsheet in-memory. All of these can be applied to the store with a single Write Data command.
Update Previews are available to allow you to compare differences between your .dfg spreadsheet and existing data. Both grid and SQL previews are available.
Visual Basic Script (VBS) is tightly integrated and available for macros, a command line, and as the spreadsheet formula language.
Easy to use and no Bull. The Data Flask installer is small at 4M and copies files into a single directory. The uninstaller will remove every file it installs. No nags. No timeouts.
Table loaded from an Access .mdb Database.
Information imported into a Flask Grid File (*.dfg) becomes an independent, disconnected copy of the data from the source. Data from a wide variety of sources is supported, ranging from text files to SQL databases.
Data Updates are performed directly through the client drivers, or into SQL Script. Update previews allow you to compare differences between the data and the spreadsheet before writing data. Separate windows for Update, Append and Delete are created.
The application retains column type, primary key identifiers, indexes and data link information. These can be edited or migrated to other sources. Holding metadata in the .dfg file allows for a highly optimized return of information to the source; Keys are automatically discovered, and only modified cells are updated. These features allow the application to perform as a disconnected front end.
Table editing features include sorts, groups, joins and in-memory updates. These are performed internally, independent of data source capabilities or restrictions.
Data Flask integrates Visual Basic Script, using it for formulas, in a command line, and script macros. Editing activity is recorded to the command line, so that it may be repeated there, or copied into the script editor. Intellisense features are supported in the command line, formula, and script editors.
Data Flask's presentation and reporting features are almost non-existent. The program's focus is on data, type and source.
Please visit the online documentation: http://dataflask.com/docs.
The general version of the software is free. If you register (
$49.95),
formula debugging and
create package features are activated. If you decide not to
continue using the software, the uninstaller is thorough, and hassle free.
All versions, Help file, Contents:
Download Page (3/11/2007 - 1.1, Build 5)
| File extensions | ||
|---|---|---|
| Text (*.txt) | *.txt | Desktop Agent |
| Htm as Text (*.htm) | *.htm | Desktop Agent |
| Html as Text (*.html) | *.html | Desktop Agent |
| Comma delimited (*.csv) | *.csv | Desktop Agent |
| Tab delimited (*.tsv) | *.tsv | Desktop Agent |
| Space delimited (*.prn) | *.prn | Desktop Agent |
| Binary (*.bin) | *.bin | Desktop Agent |
| Access (*.mdb) | *.mdb | OleDb Agent |
| Excel Worksheet (*.xls) | *.xls | OleDb Agent |
| SQLite (*.db) | *.db | OleDb Agent |
| FoxPro Tables (*.dbf) | *.dbf | OleDb Agent |
| FoxPro Database (*.dbc) | *.dbc | OleDb Agent |
| XML Simple Provider (*.xml) | *.xml | OleDb Agent |
| Data Link (*.udl) | *.udl | save, create, open |
| VBS Script (*.vbs) | *.vbs | script editor and debugger |
| Prepared Data Sources | ||
| Microsoft Access | *.MDB | |
| Microsoft Excel | *.XLS | |
| Microsoft FoxPro, dBase | *.DBF, *.DBC | |
| My SQL | ||
| Microsoft SQL Server | *.MDF | |
| Oracle | ||
| Postgre SQL | ||
| SQLite | *.DB | |
| Xml (read only) | *.XML | (Osp) |
| Text Format | ||
| Unicode 8 bit | (UTF-8) | Desktop Agent |
| Unicode 16 bit PC | UTF-16/UCS-2 little endian | Desktop Agent |
| Unicode 16 bit Mac | UTF-16/UCS-2, big endian | Desktop Agent |
| Unicode 32 bit PC | UTF-32/UCS-4 little endian | Desktop Agent |
| Unicode 32 bit Mac | UTF-32/UCS-4, big endian | Desktop Agent |
| Embedded Binary | [hh], [hhhh], [hhhhhhhh] | Desktop Agent |
| File Protocol | ||
| file:// | Standard file access | Desktop Agent |
| ftp:// | File Transfer Protocol | Desktop Agent |
| http:// | Hypertext Transfer (Read) | Desktop Agent |
Sylads, AutoCAD, and Interscape
Consulting please contact here.
© 2006 Interscape. Data Flask(tm) Interscape. Excel(r), Visual FoxPro(r),
Visual Basic(r), Intellisense(tm), Windows(r) Microsoft. MySQL(r) AB.
Oracle(r). Paradox(r) Corel.