Search found 569 matches

by aaronw
May 18th, 2023, 9:35 am
Forum: Synchronization
Topic: How to use POWER BI to extract data on CSWeb?
Replies: 5
Views: 6678

Re: How to use POWER BI to extract data on CSWeb?

CSWeb uses a MySQL server, so I searched for a video that walks through connecting Power BI to MySQL Server . However, before doing this you'll need to run a command line tool that converts dictionary data into a relational database. See processing cases here https://www.csprousers.org/help/CSWeb/da...
by aaronw
May 17th, 2023, 11:08 am
Forum: Other
Topic: Sync Cspro data to cloud server
Replies: 9
Views: 31912

Re: Sync Cspro data to cloud server

The code looks fine. Make sure the two devices are paired.
by aaronw
April 3rd, 2023, 5:21 pm
Forum: Tools
Topic: Re: Can't Upload Errors to CSPro
Replies: 1
Views: 2867

Re: Can't Upload Errors to CSPro

If you want to install one of the applications you developed for the first time, then you do in fact need to use the Deploy Applications tool. When you deploy the application with the tool the application will be zipped up and uploaded to CSWeb. You can verify it's there by looking for it under the ...
by aaronw
March 13th, 2023, 11:38 am
Forum: Entry
Topic: Logic to lookout in a number of previous response variable if No answer is choosen
Replies: 3
Views: 2863

Re: Logic to lookout in a number of previous response variable if No answer is choosen

You could use a roster and min to query whether an activity has been performed. Occurrence labels are used to make the CAPI text dynamic. This application will show the last question if the activity was ever performed, otherwise the question is skipped.
survey.zip
(2.9 KiB) Downloaded 149 times
by aaronw
March 13th, 2023, 9:30 am
Forum: Entry
Topic: Calculate Area using gps
Replies: 3
Views: 2874

Re: Calculate Area using gps

To see an example take a look at the examples that gets installed with CSPro. There is one called geometry under data entry that I think you will find helpful.
by aaronw
February 23rd, 2023, 6:13 pm
Forum: Android
Topic: Use Enter Key
Replies: 3
Views: 3692

Re: Use Enter Key

Under Options > Data Entry do you have "Automatically advance on selection" ticked?
automatic-advance.PNG
automatic-advance.PNG (14.08 KiB) Viewed 3461 times
by aaronw
February 23rd, 2023, 4:43 pm
Forum: Other
Topic: OLD DICTIONARY TO NEW DICTIONARY
Replies: 4
Views: 4395

Re: OLD DICTIONARY TO NEW DICTIONARY

One option would be to open the CSDBs and save them as DAT files. Then you can open the old dictionary and update the dictionary names. Then rerun the reformat tool pointing to the corresponding dictionaries and DAT files. Then convert back to a CSDB.
by aaronw
February 14th, 2023, 1:28 pm
Forum: Other
Topic: Sync Cspro data to cloud server
Replies: 9
Views: 31912

Re: Sync Cspro data to cloud server

The only difference I see is where the server is located. In my case, my server is on a shared host. The CSWeb setup is the same. Any differences would be specific to that shared host, OS, network, etc.
by aaronw
February 13th, 2023, 4:10 pm
Forum: Feature Requests
Topic: HTML report
Replies: 2
Views: 9225

Re: HTML report

I made a few modifications to the existing report in the CAPI Census example. Here's a snippet of the report code. <!-- Report content --> <table class="table table-striped table-bordered"> <thead> <tr> <th>Name</th> <th>Relationship</th> <th>Sex</th> </tr> <? do numeric ctr = 1 while ctr ...
by aaronw
February 2nd, 2023, 8:27 am
Forum: Synchronization
Topic: Synchronisation
Replies: 1
Views: 3315

Re: Synchronisation

The issue here is case id management. You need to make sure that the devices are making unique keys. If you create an interview with id "1" on device #1 and then create an interview with id "1" on device #2 you will have to have a duplicate on the server when you sync. My suggest...