|
 Folder
Scanner - with Valentina v3 Trial - written in REALbasic 2007 r2
- Trial - for Windows XP
sp2
NOTE: This zip does NOT contain Valentina binary objects
for running the database in any form. You must
install the Valentina Database first.
Anyone interested in
Valentina should start here:
http://www.valentina-db.com/en/support
Installing
Valentina v3 VDK for REALbasic on WinXP
This
version of Folder Scanner has been built around the
Valentina v3 DB.
This release includes a few nice updates and I feel a faster database.
I've just been informed by another Valentina user that
the bigger the database the faster the difference.
After trialing a number of automated drive indexing utilities
(Like Google Desk Top and Windows XP Indexing)
that seemed to use far too many of my CPU resources and
seemed to slow my computer down.
I was spending more time making sure they were NOT
running than actually using them.
I also wanted to have a fair go at discovering:
How far I can
could get with REALbasic 2007 r2
How intuitive is the interface.
How we use existing databases and com objects.
How stable is the REALbasic IDE.
How close the REALbasic language is to VB6.
How the help files interacted. Including the Quick
Start, Users Guide, and Users Manual.
How regular are the product releases.
How much does REALbasic cost.
How good is the support from REAL Software and the
Community Forums.
Additionally:
I wanted to see how far I could get with a Database
other than MSAccess.
Valentina is reported to be very fast.
This is my
second application in REALbasic.
I started from
the original FolderScanner 4 days ago. i.e. Knowing nothing about
Valentina v3.
I've been working on this app and researching
Valentina
part time.
Specifically, NOT 8 hours a day.
Yes, things will be missing and I'm sure everything
can be executed in a more efficient manner.
All will come as a matter of time and experience with
REALbasic.
I just
wanted to prove how much I could accomplish in a relatively short amount of
time.
My Overall
Experience with Valentina so far:
Overall,
I'm very pleased again with the outcome. Despite
the issues outlined below.
Valentina was easier for me to learn and constructively
use, I believe, coming from a MSAccess
background.
I have to write that I found the support site for
Valentina hard to follow and convoluted.
The support I received from the REALbasic community for
Valentina was faster than the support I received from
Valentina.
Some of the support documentation mentioned by
Valentina couldn't be found for download.
I believe I could have and should have come up to speed
much faster.
And would have with a better support structure.
I had far far too many "Segment Map Corrupted" errors.
And as yet haven't had time to sort out the cause or the
fix.
( i.e. You can't just stop the
application in mid run or allow the trial timers to run
out.
Or the database will return "Segment Map Corrupted".)
The support is NOT in a community format.
Its in a form of lists. To report errors.
And in a form of group emails for support.
(Now that I've finished working with Valentina I seem to
be getting responses from my email submissions.
So it does seem to be working.)
The page that attempts to explain this is, in my
opinion, a mess.
Valentina should seriously consider changing this to a
proper community forum.
As there are far too many very professional looking and
free community forums available.
To put Valentina products into proper perspective have a good read thru
these pages:
http://www.paradigmasoft.com/en/products
http://www.valentina-db.com/dokuwiki/doku.php?id=paradigma:public:en:licensing:adk_vs_vdn_chart
I think
the Details Comparison Chart explained it best.
SMB -
Small to Medium Business - Larger than a small
office-home office (SOHO)
ADK - Application Developer Kit
VDN - Valentina Developers Network
- Physical
Database
- Interface Tools
- Software Developers -
Stand Alone Solutions
-
Client-Server / multi-user access Applications
--------
I've created a working application that could be useful
to any who care to investigate and use.
And have been able to contribute additionally to the
REALbasic community and in some part to the Valentina
community.
I just hope Valentina take my suggestions and improve.
I offer
the source in good faith as a starting point only.
Feel free to use my code and layout as you see fit.
Feel free to change the app and please be sure to share
enhancements and code with the rest of us in
the REALbasic and Valentina world.
Finally, be sure to give credit where credit is due and DON'T
claim this exact application as your own.
Contains example of:
This is a coding sample for the
following:
Controls:
Window, TabPanel, ListBox, StaticText, PushButton,
EditField, and Thread.
Includes form resizing.
Coding:
Subroutines, Functions, Database Connectins and SQL
Queries, Classes, Properties, Methods, and Modules.
FolderItem, Item and TrueItem, SelectFolderDialog,
Threading, Shelling, Error Trapping, Do Loops,
Constants, and Enums.
Valentina Database, SELECT
statement and SELECT LIKE statement criteria is
formatted differently with embedded EscapeStrings
- watch out! - These two Valentina Select Statements are
NOT the same criteria formats!
You must initialize the Valentina DB as well as close it
properly. Otherwise your app will crash with a
Windows error.
i.e. You can't just stop the application in mid run.
Or the database will return "Segment Map Corrupted".
To use Valentina v3 Database with REALbasic 2007
r2 on WinXP
- you must have a copy of the V4RB_3 folder
and it contents under the
C:\Program Files\REAL
Software\REALbasic 2007r2\Plugins folder.
You must restart
REALbasic to load the drivers
To remove Valentina v3 Database requirements from Future REALbasic
application
- you MUST remove or V4RB_3 folder and its content from
under the
C:\Program Files\REAL
Software\REALbasic 2007r2\Plugins folder.
You must restart
REALbasic to unload the drivers
Deploying Valentina Desktop
- just the contents of VComponents_Win_VC
- not the folder Name
- WORKS as expected - May 09 2007.
Snap on the left is the VComponents_Win_VC folder
contents.
The
snap on the right is my distribution .zip folder.
I've only added the FolderScanner.exe with the 4
dbFolderScanner.* Valentina DB files.
All Compressed into 9 megs.
This is
just an unzip/drag-n-drop installation. - Brilliant!
Congratulations REALbasic and Valentina creators for
making distribution so easy! Well Done!
Folder
Scanners with Valentina Initial Graphical User Interface
A screen shot of the initial Folder
Scanner Graphical User Interface where you can:
Choose Folder and Start - Opens a
Select Folder dialog where you can select a single
folder.
Once the folder is selected Folder Scanner will begin
scanning the folder and sub folders for files
and write each File Path and File Name to its database.
You'll be able to watch its progression as the the
Folder and File Names and File Count is displayed.
Use the clear button to clear the list box.
You'll also be able to stretch the form at any time.
Folder
Scanners with Valentina Search Database Tab.
A snapshot of Folder Scanners Search
Database tab where you will be able to:
You can enter search criteria for the
Folder Path and the File Name.
Use the * buttons to clear the text box contents.
Use the Search DB button to begin searching the
database.
Use the SQL text box to copy the
Valentina
Database SQL query into the clipboard.
View the results of the query in the list box.
Use the Clear button to clear the list box.
Use the Open Containing Folder to open the files folder
in Windows Explorer and highlight the file for action.
Folder
Scanners FolderScanner with Valentina.zip download file contents.
Please be sure to run ANY download from ANYWHERE
thru your virus protection software.
Some virus protection software is automated, some are
not.
Place
nice constructive comments here
These are some nice comments about what I've learned
over the last five days of REALbasic 2007 r2
research.
Some
ideas regarding future enhancements
These are some nice comments about what I could add
to the Folder Scanner Project.
|
