InfoToday Tools for Visual Rams
InfoToday Tools for Visual Rams
What's it all about
Who is InfoToday
Business needs addressed
What are the different tools provided
Who would use these tools
Where to next
InfoToday Rams Data Server (ITRDS)
What is the InfoToday Rams Data Server
How it Fits together
What the ITRDS is not
Why do we need the ITRDS
What does the ITRDS offer you
Why not just use ODBC or FoxPro ?
Supported Tables and Actions
SQL Server
Version covered by this Help File
Whats new in this version
Client Features
Example of the New Data View
ITQueries
Building COM DLLS for Crystal Reports
Importing Data using the ITRDS
Preparing your data
Importing using the Import Tool
Using the ITRDS via COM
Emedding the Import Form into other Applications
Examples of whats going on in the background when you import
Users Guide
Roadmap to getting started
Overview
COM Objects
Schematic of Data Flow and Communication
Data Validation
How the ITRDS Hooks into IT_DATA
IT_DATA::NEW
IT_DATA::SAVE
RP_DATACORE::VALIDATEFIELD
RP_DATACORE::PRESAVELOGIC
RP_DATACORE::POSTSAVELOGIC
IT_DATA::DELETE
RP_DATACORE::PREDELETE
RP_DATACORE::POSTDELETE
Programming with the ITRDS
Quick Example
Instantiating the ITRDS Object
Basic Object Model
Syntax Logic
Setting a Connection
Setting the Rams System to access
Checking for Errors
Loading a Record
Viewing Data Records
Editing Data
Saving Data
Creating New Records
Querying Data
Payments
Demo
Field Names
For FoxPro programmers
Utility methods
C++ Programmers
Sample Code
Container Tracking Explained
Overview
Setup Fields
Classes, Methods and Properties
Class Structure
Class rp_client
CursortoADORS
FoxCommand(tcCommand as String) as Variant
Reset as Boolean
SetConnection(tcNewVal as String) as Boolean
SetSystem(tcNewVal as String) as Boolean
oAsynchServer
oBatch
oBatchLog
oCharges
oComments
oCustomers
oInvoiceMembers
oInvoices
oProfilerExtra
oQueries
oRoute
oRoutes
oServiceLink
oSystem
oTable
oUtils
oWorkOrderCharge
oWorkOrderComment
oWorkOrderContainer
oWorkOrderDateTime
oWorkOrderlog
oWorkOrders
Class rp_data
Class rp_asynchserver
canceljob
getcprogress
getnprogress
gettimeremaining
logstatus
startjob
Class rp_batch
cbatchlockcode
cbatchpasscode
cbatchtype
lcreatenewbatch
lleavebatchlocked
Class rp_batchlog
lockbatch
unlockbatch
cbatchlockcode
cbatchtype
lcreatenewbatch
Class rp_charges
getassignedroutes
getnextndatesforroute
getnextnservices
Class rp_comments
Class rp_customers
isvalidaccount
laddstreetifnotfound
Class rp_invoicemembers
Class rp_invoices
isvalidinvoice
Class rp_queries
addparameter
runquery
cqueryparameters
lincludeallquerysystems
nrecordsreturned
oparameters
Class rp_route
Class rp_routes
getcyclesfordate
getnextndates
getrouteworkorders
isvalidroute
isvalidrouteday
Class rp_table
Class rp_utils
cancelscheduledservice
cancelworkorderservice
getnextnpossibleservicesbycontract
getnextnscheduledservicesbycontract
getscheduledservices
getservicesbyrouteandcycle
getworkorderservices
Class rp_workordercharge
Class rp_workordercomment
Class rp_workordercontainer
Class rp_workorderdatetime
Class rp_workorderlog
Class rp_workorders
advance
advancetoprocess
createforcontract
linsertcontractdetails
addfieldvalue
cleardata
createadata
createnewid
createorows
cursortoxml
delete
deletequery
foxcommand
foxstructuretostring
getblankrecord
getfieldvalue
getorowsitem
getparentpkvalue
getpkvalue
importfromtable
importfromxml
isvalid
load
loadtable
loginuser
makecdata
new
newrecord
open
opendatabase
opendatabaseexclusive
query
recordvalidate
reset
save
seterror
settable
submitasynchjob
validateexcludedfield
calias
casynchjobid
cblockreason
cconnectioncode
cdata
cdatabase
cdatadictionarypath
cdatapath
cdatatablestructure
cerrormsg
cfieldvalidationexcludelist
cfilename
cfilter
chookprogramfile
chttpmethod
chttpparameters
chttpservername
citpassword
cituserid
clastmodfield
clocaltablename
cparentqueryexpression
cparentvalue
cpassword
cpkexpression
cpkfield
cpkidtype
cpkqueryexpression
cpkvalue
cpropertiesreturnedonly
cpropertiestopassbothways
cpropertiestosendonly
cproxypass
cproxyserver
cproxyuser
cresultxml
csystemcode
ctable
ctablestructure
cuserid
lallowpkset
lallowwrite
lallowzlibcompression
lblocked
lcheckrequired
lcreateidonnew
lcreateidonsave
lcustomvalidation
ldocustompostdeletelogic
ldocustompostsavelogic
ldocustompredeletelogic
ldocustompresavelogic
ldopostdeletelogic
ldopredeletelogic
lerror
lfieldvalidate
lforcelogin
lgettablepropertiesonopen
lincludedeletedinquery
lincludefoxstructurefromquery
lisasynchprocess
lnoformatfields
lopenexclusive
lpostsavelogic
lposttounprocessed
lpresavehookserver
lpresavelogic
lpromatrixvalidate
lrecordvalidate
lstoreindexes
lstoretablestructure
lsubmitasasynchprocess
lusedefaultvalues
luseglobaldatasystem
luseproxy
luseseekandreplace
lusetransactions
lvalidateonsave
lzlibcompression
nhttptimeout
nvpmversion
nxmlschematype
odata
oparent
orows
vencoded
InfoToday Rams Asycnh Job Server
Import Routes Example
Step 1 - Create the XML file
Step 2 - Create an instance of the ITRDS
Step 3 - Submit the Import Job to the Job Server
Step 4 - Run the job server to process the job
Step 5 - Monitor the Jobs progress
Step 6 - Determining when a job is finished
Step 7 - To cancel a job
InfoToday Rams Application Server (ITRAS)
What is the InfoToday Rams Application Server
Why use the ITRAS
Embedded in Applications
One Reusable Visual Interface
Data Interface
Instead of data synchronising
Remote access
Ease of Integration - Sample Code
Connection condition
Screen Shot
User Guide
Roadmap to getting started
Programming with the ITRAS
Quick Example
Importing Data
InfoToday RAMS.NET Portal
Login
Login - What to do
Login - Behind the scenes
Login - Screen Shot
Customer Screen
Customer - What to do
Customer - Behind the scenes
Customer - Screen shot
Edit Contact Details
Edit - What to do
Edit - Behind the scenes
Edit - Screen shot
Logging an Issue
Issue - What to do
Issue - Behind the scenes
Issue - Screen shot
Book a service
Book - What to do
Book - Behind the Scenes
Book - Screen shot
Online Payments
Payment - What to do
Payment - Behind the Scenes
Payments - Screen Shot
Installation
Installing the ITRDS and ITRAS
Before Installing
Running Setup
Activation
Configuration
Application Settings
Server Configuration
HTTP Configuration
Client Configuration (Client only)
Windows 2000 Component Services
Installing in Component Services
Systems and Connections
What and Why
Systems
System Configuration
Connections
Connection Configuration
Local Connection
HTTP Connection
DCOM Connection
Updating
Update.exe