Scott M Dulecki BravePoint Agenda Setting the Stage Basics Fifty Ways Final Thoughts Setting The Stage Me Scott M Dulecki Presenter at PCA and various user groups Board Member QAD Midwest Users Group ID: 474477
Download Presentation The PPT/PDF document "Fifty Ways To Dig Your Data" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Fifty Ways To Dig Your Data
Scott M. Dulecki
BravePointSlide2
Agenda
Setting the
Stage
Basics
Fifty Ways
Final ThoughtsSlide3
Setting The Stage: MeScott M. DuleckiPresenter at PCA and various user groups
Board Member, QAD Midwest Users Group
Board Member, QAD South & East Users Group
President, West Michigan Progress Users Group
Past President, VP Michigan Progress Users Group
PEG member 1998061901
Author of:
Back to Basics: Dump and Load
Safe Haven: Archiving in MFG/PRO
Safe Haven: MFG/PRO BasicsSlide4
Setting The Stage: YouDevelopers?
Trainers?
Here for the beer?Slide5
Agenda
Setting the Stage
Basics
Fifty Ways
Final ThoughtsSlide6
What Is Data Digger?Open-Source toolAvailable at the OpenEdge Hivehttp://www.oehive.org/project/DataDigger
Authored by Patrick
Tingen
patrick
(at)
tingen
(dot) netSlide7
Agenda
Setting the Stage
Basics
Fifty Ways
Final ThoughtsSlide8
Look At DatabaseView TablesView fields
View indexesSlide9
Filter DatabaseFilter DatabasesFilter Tables
Default sort by most queried tables
Include/hide hidden tables
Filter Fields
Filter IndexesSlide10
Selection CriteriaEnter 4GL codeUse drop-downs to fill WHERE
Click buttons to fill WHERE
Right-click data value to add to filter
Right-click indexes to enter filter
Copy WHERE to clipboard
Remember filters for the next timeSlide11
Look At DataView table contentsDouble-click table to launch browse
View actual values
Change display formats
See which formats you’ve changed
Set them back to what they wereSlide12
Prepare OutputSelect columnsHide columns
Unhide all columns
Enter selection criteria
Use selection wildcards
Sort by clicking column headersSlide13
Dump DataXML.d
Excel
HTML
.p
Entire table, browse, or selected recordsSlide14
Post-Dump Of DataCopy dumped data to clipboardBrowse directory
Open dump file
Browse last dump directory
Open last dump fileSlide15
Use existing database .pf filesUse titles in –param
Save preferred database configurations
Setup / Configuration
C:\dlc\bin\prowin32.exe
-
pf
c:\Prodv6.pf
-
ininame
c:\Prodv6.ini
-p
DataDigger.p
-
param
“Hi, PCA” Slide16
Custom EnvironmentUse multiple icons / colorsSlide17
I18n ThingsDefaults to European FormatsSupport DBE with second copySlide18
Database DefinitionsDump database .df file
Open file after dumpingSlide19
Guarded FunctionsAccess to Data DictionaryAccess to Progress Editor
Edit records in-lineSlide20
Questions Before Final Words??Slide21
Agenda
Setting the Stage
Basics
Fifty Ways
Final ThoughtsSlide22
WHAT????
WHAT???Slide23
Protect Against In-line EditingAdd –RO
to database .
pf
connections
Use
datareader.p
instead of
datadigger.p
Removes access to
dict
, editorSlide24
Some Other Neat Things
Double-click field to highlight in browse
Optionally display
rowid
/
recid
Filter tables by containing field name
Query tester built in (Ctrl-T,
xref
info)Slide25
Neat Things Post-Presentation!DataDigger will also access VSTs
Option to encrypt data
on entry
Enter data in list formatSlide26
For Further Information
For a copy of this presentation, leave me your business card with “50 Ways” on it
Scott M Dulecki
BravePoint
616/481-4313
sdulecki@bravepoint.comSlide27