Search found 1916 matches

by josh
September 14th, 2019, 2:27 pm
Forum: Tools
Topic: Concatenate with duplicate keys
Replies: 1
Views: 32

Re: Concatenate with duplicate keys

It isn't possible with the concatenate data tool. It is possible by creating a batch application with no logic and choosing multiple input files. Pick all the files you want to concatenate as input files and they will all be combined in the output file.
by josh
September 11th, 2019, 7:11 am
Forum: Synchronization
Topic: csweb failed to connect database
Replies: 2
Views: 60

Re: csweb failed to connect database

Googling that error message brought up this result that recommends changing the MYSQL authentication method: https://stackoverflow.com/questions/52364415/php-with-mysql-8-0-error-the-server-requested-authentication-method-unknown-to The path to files directory depends on where you installed CSWeb on...
by josh
September 10th, 2019, 7:00 am
Forum: Entry
Topic: ProductionRunner failed to run
Replies: 7
Views: 255

Re: ProductionRunner failed to run

Try browsing to C:\Program Files (x86)\CSPro 7.3 and double click on the executable CSProProductionRunner.exe. If that doesn't work please tell us what error message you see.
by josh
September 6th, 2019, 8:40 am
Forum: Entry
Topic: New released cspro version 7.3
Replies: 11
Views: 631

Re: New released cspro version 7.3

You can use the diagnostics function to get the version number from logic: https://www.csprousers.org/help/CSPro/d ... ction.html
by josh
September 6th, 2019, 7:00 am
Forum: Entry
Topic: New released cspro version 7.3
Replies: 11
Views: 631

Re: New released cspro version 7.3

Also in version 7.3 you can use the new pff object to avoid writing out pff files entirely. https://www.csprousers.org/help/CSPro/pffs.html
by josh
September 6th, 2019, 6:37 am
Forum: Entry
Topic: New released cspro version 7.3
Replies: 11
Views: 631

Re: New released cspro version 7.3

Sorry to hear that the 7.3 release took you by surprise. To avoid this in the future we highly recommend that anyone with surveys in the field disable automatic updates on their Android devices: https://www.csprousers.org/posts/2018-01-08/disabling-automatic-updates-on-android.html. This way you won...
by josh
August 25th, 2019, 6:48 pm
Forum: Synchronization
Topic: Visible only bluetoothnames of a Team to a Supervisor
Replies: 1
Views: 59

Re: Visible only bluetoothnames of a Team to a Supervisor

It is not possible to filter the list of Bluetooth devices. If you know the name of the device you want to connect to you can connect directly without displaying the list by passing the device name in the call to synconnect(). So if you know the names of the devices of the team members you could dis...
by josh
August 23rd, 2019, 9:20 am
Forum: Entry
Topic: Count Partially Saved Cases
Replies: 8
Views: 1240

Re: Count Partially Saved Cases

You can just do something like this:

setfile(LFLISTING_DICT, concat("..\..\106_Ext_Data\LFL-", edit("9999999",Pro_Code),"-",Enu_Code, ".txt"));
incompleteHouseholds = countcases(LFLISTING_DICT);

Then you don't need all the closing and opening of the file.
by josh
August 22nd, 2019, 7:18 am
Forum: Entry
Topic: Getting a year from a given date
Replies: 3
Views: 674

Re: Getting a year from a given date

Just divide by 10,000 to shift the year to the right by four places and then truncate:

YearBirth = int(DOB/10000)

int(20130623/10000) = int(2013.0632) = 2013
by josh
August 21st, 2019, 7:26 am
Forum: Entry
Topic: Getting a year from a given date
Replies: 3
Views: 674

Re: Getting a year from a given date

Use the dateadd function.

dateadd(MYDATE, -1, "Y")

https://www.csprousers.org/help/CSPro/d ... ction.html