|
Processing yesterday’s data using Visual Importer Pro 7.3.7 |
Consider the following scenarios.
• Every day we export data from our database and would like to save it into different file using current date as a part of the file.
• We would like to load yesterday’s data from the folder which has date part in the name
We can use functions in filenames to do it as follows
Note:
Only one {} pair is allowed.
GETSYSTEMVARIABLE('SYSTEM_DATE') will return current date in ‘YYYYMMDDHHNNSS’ format
If we want only part of date we can use LeftString(String,Count):String for example
LeftString(GETSYSTEMVARIABLE('SYSTEM_DATE'),8) will return only date part.
Now more complicated example for loading yesterday’s data;
LeftString(DecDateS(GETSYSTEMVARIABLE('SYSTEM_DATE'),'YYYYMMDDHHNNSS', 'DAY',1),8)
Note:
For complete reference of available functions please consult chapter 16 of documetation. |
|
|
Visual Importer Pro version 7.3.2 |
We are proud to annonce that Visual Importer Pro version 7.3.2 is available for download.
This version includes a lot of new features designed to make life of the end user easier.
Such as:
Extention of Ftp action functionality
Compare file size
Check file bits for example archive bit readonly etc
Merge files together (add one file to another)
It is now possible to to split Export files
Check Sql Data action
Change files bits for example reset readony bit etc
We would like to thank all our devoted users for giving us the most usefull feedback. |
|
|
Monitor your Oracle Database with Active Business Intelligence Portal |
We are proud to announce that Active Business Intelligence Portal version 3.1.8 is available for download. This version includes port of OraShap well know scrips library designed to make life of Oracle DBA easier.
"OraSnap (Oracle Snapshot) contains all the SQL scripts that most of us already have in our arsenal. The "twist" is the way the information is presented. All of the statistics are generated with HTML tags - which can then be viewed with a web browser. Each report has the source code used for the information and notes with relevant information about the statistics gathered. OraSnap currently has over 110 scripts that generate a multitude of information for v7, v8 and v9 databases." |
|
|
DEWizardX is available for download |
|
Now you can integrate power of Data Exchange Wizard into you own applications |
|
|
Data Exchange Wizard Documentation |
|
Data Exchange Wizard Documentation is available for download |
|
|
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>
|
