Forum: RangerMSP Software Discussion Forum (CCRM)
June 1st, 2022, 10:01 AM
|
|
Replies: 3
Solution if anyone ends up reading this thread: the default .net date format uses slashes dd/mm/yyyy. Something changed in the API recently and now dashes are required, dd-mm-yyyy.
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 31st, 2022, 09:50 AM
|
|
Replies: 3
The filterDate variable is a date-time type. Nothing has changed that I know of. Will send the logs.
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 31st, 2022, 08:56 AM
|
|
Replies: 3
An app that worked perfectly well for a long time is now throwing an exception no matter what date is specified.
This criteria:
qry.AddCriteria("FLDTKTOPENDATETIME",...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 18th, 2022, 10:57 AM
|
|
Replies: 1
I see that linked tickets are stored in a simple table with two ticket RecIDs. I'd like to be able to link tickets through the API but don't see a mechanism for doing that. Any ideas? Thanks!
--...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
January 19th, 2022, 11:40 AM
|
|
Replies: 1
We're planning to roll out price increases on all our MMS plans. We're hoping we can automate this via the API.
I see in the underlying database that the PriceLists table carries both account and...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
April 16th, 2021, 11:33 AM
|
|
Replies: 3
I got that namespace from the metadata. Included it for clarity.
Namespace ...
Public Class Contact
Inherits [Object]
...
I fixed this. I had neglected to initialize the API before...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
April 16th, 2021, 10:37 AM
|
|
Replies: 3
I am trying to add secondary contacts to accounts via the API. The following line fails with "Object reference not set to an instance of an object."
Dim c As New CommitCRM.Contact()
-- Craig
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
December 17th, 2020, 01:37 PM
|
|
Replies: 0
Am getting this error:
"1023 A newer API version was found. Please restart any applications that use the RangerMSP API and try again."
As far as I can tell, no apps are running with it. For sure...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
November 11th, 2020, 08:08 AM
|
|
Replies: 3
Thanks for the quick response. You folks are the best, really!
Got it: you have to repeat the AND portion for each OR. My filter is going to be pretty ugly (I included only a relevant portion) but...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
November 10th, 2020, 01:23 PM
|
|
Replies: 3
Does not seem to be a way to combine AND and OR in the same filter.
Example:
contract status = Active
and
contract type = (Block of Time, Block of Money)
and
(code includes NBP or code includes...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
October 15th, 2020, 09:09 AM
|
|
Replies: 2
Thanks for all those details. Pretty complicated stuff but you've laid it all out.
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
October 14th, 2020, 12:41 PM
|
|
Replies: 2
How are custom billing settings encoded in the contracts table? I need to find contracts that are using certain exceptions, or in other cases, missing exceptions.
Below is an example. I put each...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 16th, 2020, 11:52 AM
|
|
Replies: 12
Log files in a .zip are heading your way. The error occurred during an asset.Save() call if that helps narrow it down.
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 16th, 2020, 09:55 AM
|
|
Replies: 12
Success, I'm able to set assets with a specific contract to a series contract. This is based on running a series of single record test cases.
However, in a batch mode for some (not all) assets I get...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 15th, 2020, 01:58 PM
|
|
Replies: 12
I guessed that FLDBCTSEQID might be the name, based on experience with other objects. It's always blank. Argh -- now I am getting it, that field is not part of the default set of values that are...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 15th, 2020, 10:37 AM
|
|
Replies: 12
Got it, that makes sense.
Almost have this API code running but there's zero documentation on Contracts in the API references. I have successfully fetched a contract object and now need to extract...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 15th, 2020, 08:05 AM
|
|
Replies: 12
Sure, will give it a try. My concern is that the query below yields six records that are all part of this series, as expected. So clearly it's a legit SeqID
select * from bcontracts where seqid =...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 15th, 2020, 07:14 AM
|
|
Replies: 12
Thanks, I'll give this a try. My confusion here is that while I see the SeqID in the BContracts table and can get to it via the specific contract RecID, I cannot find the SeqID in the BContractSeries...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 14th, 2020, 01:02 PM
|
|
Replies: 12
Follow-up: I found I can do this --
asset.SetFieldValue("FLDASTCONTRACTID", contract.ContractID)
But that is setting it as a specific contract. What's the equivalent for series?
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
September 14th, 2020, 12:32 PM
|
|
Replies: 12
A large number of assets were created with a default contract as a specific contract and not as a series contract.
There is nothing in the API documentation about how to set this. Looking at an...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 26th, 2020, 12:55 PM
|
|
Replies: 3
I am pointing the app at the UserDev folder so that ought to be the latest.
Also, note that the app runs perfectly find from a command window on the SQL Server, so I assume it would get the same...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 22nd, 2020, 01:09 PM
|
|
Replies: 3
I have a .Net console .exe app that runs fine on a SQL Server server. It successfully connects to the CommitCRM API and does what it's supposed to do.
However, if I try the same thing from within a...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 18th, 2020, 01:12 PM
|
|
Replies: 2
Thanks for such a quick response. That's one variation I had not tried.
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
May 18th, 2020, 10:47 AM
|
|
Replies: 2
I'm a SQL Server guy and don't query Advantage DB directly very often so am weak on syntax subtleties. Am trying to fetch all charges between two dates and no matter what variations I try it's...
|
|
Forum: RangerMSP Software Discussion Forum (CCRM)
March 10th, 2020, 01:14 PM
|
|
Replies: 2
Thought it would be something like that! I didn't notice that FetchObjects() had that overload option.
The 190 contact case is now down to 10 seconds, that's tolerable.
Thanks so much for the quick...
|
