Search found 1799 matches

by Gregory Martin
May 1st, 2024, 3:27 pm
Forum: Editing
Topic: Function to return the count of categories
Replies: 3
Views: 132

Re: Function to return the count of categories

You can use the working storage dictionary to create an item, e.g., Categories. Then, in post-calc logic, you can set the value of that cell to relationshipHashMap.length(). Here is some reading that may help you do this: https://www.csprousers.org/help/CSPro/table_logic_tablogic.html https://www.cs...
by Gregory Martin
May 1st, 2024, 3:07 pm
Forum: Tools
Topic: relative paths in production runner
Replies: 4
Views: 2808

Re: relative paths in production runner

I haven't used the Production Runner in many years, but when I created it, it was supposed to work with relative or absolute paths. When it looks for a file, the algorithm: 1) Checks if the file exists as an absolute path. If so, it uses it. 2) If not, it calculates a relative path based on the file...
by Gregory Martin
May 1st, 2024, 2:41 pm
Forum: Tabulation
Topic: Save tables in excel format
Replies: 2
Views: 65

Re: Save tables in excel format

This may not help you much, but you can export the first table in a .tbw file to .html from the command line: "C:\Program Files (x86)\CSPro 8.0\TblView.exe" input.tbw /EXPT /HTML output.html On my machine, I can open this file using: "C:\Program Files\Microsoft Office\root\Office16\EX...
by Gregory Martin
May 1st, 2024, 2:21 pm
Forum: Editing
Topic: set records to blank
Replies: 1
Views: 16

Re: set records to blank

Have you tried to use the "group" name instead of the record name? That is, delete SECTION_101_EDT instead of SECTION_101. Although the error message says that you should be able to delete a record, the record modification functions (insert/delete/sort/etc.) should generally be used on the...
by Gregory Martin
May 1st, 2024, 1:59 pm
Forum: Entry
Topic: CSDB to SQL Database
Replies: 2
Views: 59

Re: CSDB to SQL Database

The CSPro DB file is a SQLite file, so you can open that file in a program such as DB Browser for SQLite and then export the database. (In that tool, you select File -> Export -> Database to SQL file.) Then you should be able to import that SQL file in MariaDB.
by Gregory Martin
April 24th, 2024, 8:14 am
Forum: Editing
Topic: Function to return the count of categories
Replies: 3
Views: 132

Re: Function to return the count of categories

One option is to use a HashMap to keep track of your values, and then count the number of keys in the HashMap, which will tell you how many unique values were added. For example: HashMap relationshipHashMap; PROC PROGRAM_FF errmsg ( "There were %d relationship codes" , relationshipHashMap....
by Gregory Martin
April 23rd, 2024, 3:07 pm
Forum: Entry
Topic: LoadCase
Replies: 2
Views: 62

Re: LoadCase

If the two IDs you have are the first two IDs, you could use use find with startswith. For example, this would tell you if there is an ID that starts with "AB":
if find(MY_DICT, startswith, "AB") then
by Gregory Martin
April 23rd, 2024, 3:02 pm
Forum: Android
Topic: Checkbox
Replies: 6
Views: 522

Re: Checkbox

You can use the negation operator:
if not ischecked("A", LANGUAGES_SPOKEN) then
by Gregory Martin
April 19th, 2024, 5:43 pm
Forum: Android
Topic: Horizontal Radio Button
Replies: 2
Views: 207

Re: Horizontal Radio Button

At the moment, CSPro does not have a built-in capture type that allows you display radio buttons in a horizontal manner.

If you really want this layout, you can try designing a HTML dialog and use HTML/JavaScript to display your options:

https://www.csprousers.org/help/CSPro/h ... ction.html
by Gregory Martin
April 17th, 2024, 7:56 pm
Forum: Entry
Topic: gps distance calculation
Replies: 2
Views: 231

Re: gps distance calculation

Based on your description, my guess is that you are executing this in the preproc of either LAT2 or LON2? If so, you have to use visualvalue for the PROC that you're on. If you're doing this in LON2, you would have to do:
gps(distance, LAT1, LON1, LAT2, visualvalue(LON2))