child pages:
File Formats
File Processing Runs
Record Formats
page index:
batches - new business batch to see placements after fpr
debug file setup
Element Types
File Locks on Scripts - Removing
killing an infinite loop script
letters
null strings vs empty strings
Script & Scripting bugs in Artiva
Searching and Users Index use
Tables and Fields
Unpromotable Elements
parameter order in PREFACED document I created: | param name | data type | return value | default | optional |
parameter order in workstation: | param name | data type | default | return value | optional |
RM & HCX Schedule History:
System Management -> Night Job Management -> Workstation Schedule Maintenance -> Print Schedule History
RM Job Definitions and schedules:
System Management -> Night Job Management -> Workstation Schedule Maintenance -> Schedule Job Definitions
System Management -> Night Job Management -> Workstation Schedule Maintenance -> Job Scheduler
HCX Job Definitions and schedules:
System Management -> Night Job Management -> Workstation Schedule Maintenance -> Maintain Job Definitions
System Management -> Night Job Management -> Workstation Schedule Maintenance -> Artiva Schedule Manager
Run -> Run History click Start Date link
General -> Run History Files
General->Email to get new busines [sic] batch id
seach/command "# ess bal" finds " New Business Balance Report."
Help: Account Management > New Business > Balancing New Business Batches > How to Balance a New Business Batch
fDebugFile As syFile
fDebugPath as chr
fDebugFileName As Chr
set fDebugPath = "\\" ' NO TRAILING BACKSLASH
Set fDebugFileName = fDebugPath _ "\rbdebug_" _ SYNAMESPACE _ "_" _ $$FMTDATE($$TODAY(),"YYYYMMDD",6) _ "_" _$$FMTTIME($$NOW(),"HHMM") _ ".txt"
Call fDebugFile.Append(fDebugFileName)
Call fDebugFile.Write(SYCR_SYLF_ SYCR_SYLF_ SYCR_SYLF_ $$FMTTIME($$NOW(), "HH:MM:SS ") _ "STARTING [SYLBNAME] " _ SYCR_SYLF) 'FOR ARACID <"_ $$FILEPROC.GETKEY("ARACCOUNT")_ ">"_ SYCR_SYLF)
Call fDebugFile.Write($$FMTTIME($$NOW(), "HH:MM:SS ") _ "[message here]" _ SYCR _ SYLF)
table STELEMENT
SELECT
STELCODE
,STELDESC
,*
FROM STELEMENT
Studio crashed on me and now when I open the element I was previously working on it will only open as read only. Two Finvi tech support people don't know how to resolve it and are consulting with third Finvi person. Does anyone know if we can fix it ourselves or do we need to have them fix it?
To resolve: Go into the 'users in namespace' menu in Workstation find your process ids that are locks, then go to system status in Cache dashboard, pick the namespace, then terminate those process ids
Alternately, I think if you search Lock Table in Workstation you can find the window lock and remove it that way
~2023-08-10 accidently put the wrong variable name in a while loop and it went into an infinite loop
it was writing data to the hard drive at an alarming rate
I went to the Cache control panel and went to Processes but I couldn't figure out which was mine
Deandre helped me to determine which it was
filter the list by namespace
basically, finding the pid to kill is a process of elimination - rule out workflow stuff, etc
i think i can further narrow it down by searching for the ip address of my vdi
Deandre said it will be the one that has the fastest growing values for database references, etc.
validation letter (e.g. "G01") federally mandated by Consumer Financial Protection Board; bad debt collections letter before collections activities can start
goodbye letter is letter mandated in California by AB1020 to be sent out by a hospital before the validation letter alerting patient or debtor that charity care is sometimes available. This is the hospital's responsibility, but some pay us to do it. Others send us a letter package that we parse in a 3rd gen language that checks (maybe writes to?) the aracdocs table
Revspring is our vendor that does what I think of as the mail merge portion of letter creation. aka "link service". We can't only see the value of the fields that will be inserted in the letter, not the text of the letter itself as that is in Revspring's system and not Artiva
After requesting a letter in an account, search "letter" in workstation-> "Create Letter Batch". Enter "N" in "Batch" and hit tab to autoincrement. Select the letter of interest for "Letter Code" and today for "through date". Table and Letter Form have only one possible value. Save the batch, start the letter batch when prompted and prin the letter batch when prompted. At "select device" choose "file" then "report format" and enter a filename such as c:\temp\somefname where the file will be saved on the development server at ...\C$. The file contains the values that will be inserted in the mail merge.
' A STRING NEVER ASSIGNED A VALUE AND A STRING ASSIGNED TO "" ARE EQUAL IN ARTIVA
Begin Declare
sTemp As Chr
End Declare
Begin Main
Print "sTemp unassigned"
If (sTemp <> "") Then
Print "not equal is true, would write C"
Else
Print "not equal is false, would not write C"
End If
Set sTemp = "test"
Print "sTemp = test"
If (sTemp <> "") Then
Print "not equal is true, would write C"
Else
Print "not equal is false, would not write C"
End If
Set sTemp = ""
Print "sTemp = empty string"
If (sTemp <> "") Then
Print "not equal is true, would write C"
Else
Print "not equal is false, would not write C"
End If
End Main
2023-03-29 particularly hard to find because the query works in DBeaver but not in Artiva (at least in API we use to send commands from c#):
two c style comments in a row
SELECT TOP 1 ARACID
/* COMMENT 1 */
/* COMMENT 2 */
FROM ARACCOUNT
Use ARSQL for query on the fly (as opposed to SYQUERY for one that uses a system query)
Begin Declare
zzQuery As ARSQL 'syQuery syQuery is only to run system queries - use ARSQL if building SQL Statement on the fly
zzsQuery As Chr
zzQueryGetVal As Chr
End Declare
Begin Main
Set zzsQuery = "SELECT ARACID FROM ARACCOUNT WHERE ARACCLACCT= '" _ "THECLIENTREF" _ "'"
Call zzQuery.Execute(zzsQuery)
' DETERMINE IF ACCOUNT ID ALREADY IN TABLE AND BAIL IF SO
' DO NOT USE FOR ARSQL -> 'If (Not $$BLANK($$zzQuery.Next()) ) Then ' THIS IS WRONG FOR ARSQL AS .Next never returns BLANK
Call zzQuery.Next()
Set zzQueryGetVal = $$zzQuery.Get("ARACID")
If (Not $$BLANK(zzQueryGetVal) ) Then
Print "FOUND ACCOUNT"
Print "key is <" _ zzQueryGetVal _ ">"
Else
Print "DID NOT FIND ACCOUNT"
End If
End Main
' generalized from ZZFINDACCOUNT
MyIndex as syIndex.zzMyIndexName
Set MyIndex.ZZACCLTMASTERCLID = "field 1 value"
Set MyIndex.ARACCLACCT = "field 2 value"
Set MyIndex.ARACID = ""
While (Not $$(BLANK($$MyIndex.Next("ARACID"))))
Set AcctRec.ARACID = MyIndex.ARACID
End While
-- tables
SELECT
UFTABLE,
STTABLES.UTDESC AS TABLE_DESCRIPTION,
UFVAR,
UFDESC,
UFTYPE,
UFLEN,
UFKEY,
UFINDEX,
"REST ARE SPLAT",
*
FROM STUFLDS
JOIN STTABLES ON UDTABCD = UFTABLE
WHERE
UFTABLE LIKE "%%"
AND
-- WITH FINDTHIS IN THE FIELD NAME OR DESCRIPTION
UPPER(UFVAR) LIKE "%%"
-- INDEX OR KEY
--AND ((UFINDEX = "Y") OR (UFKEY = "Y"))
ORDER BY STUFLDS.UFTABLE,STUFLDS.UFVAR
incomplete list :
FSLOC | location |
? | file processing runs |
? file processing runs
last updated: Sun 2023-08-13 8:11 AM