Word on the Street
Employee Performance Criteria
Just so we can start the New Year off on the right foot: Performance Details
|
Setting up SRCA with QBO3 and QDS
There are a few moving parts to this but the process is pretty straight forward. Credientials.config - get username and password from QDS <Credential UriPrefix=" https://uatmilitary.quandis.net/ " AuthType="Basic" Username="" Password="" Domain="" /> New Statement SCRASelect - this will pull the same data from the contact as a select but will unmask the ssn. I added it into configuration Entry table. Needs to be a DataReader <Statement Name="Select" Query="SELECT * FROM Contact WHERE ContactID IN ({Where.IdList})"/> Copy and paste the below into Contact.config <Service Name="SCRASearch" Type="qbo.Service.HTTP.HttpExchange, qbo.Service.HTTP" ReturnType="Object" RequestTransform="Templates/Contact/SCRARequest.xslt" RequestMethod="Contact/Select?ID={ID}" ImportFileTemplate="QDS.OrderRequest.Response.SCRA"> <Steps> <!--Process to invoke when QDS response is returned--> <Step Name="Product" Type="qbo.Service.HTTP.HttpExchange, qbo.Service.HTTP" Method="" Parameters="" Listeners="" ImportFileTemplate="QDS.Product.SCRA" CompleteStep="true" ResponseMethod="ImportFile/Result?ID={ImportFileID}"/> </Steps> </Service> Set up several IFTs:
These should be just pulled from the templates directory in source. Ensure the template is set up properly SCRARequest.xslt Ensure that QDS is posting responses to the correct url and has a login. |
Passing Dates in Report Method Statements
So you create a great query ( Loan.ashx/AwesomeReport ) and like most reports you have a StartDate and EndDate. You go ahead and create the ReportQuery and pass in some default values say Loan/AwesomeReport?StartDate=3/1/2013&EndDate=3/15/2013 When you go to run this you end up getting String cannot be converted to DateTime error. The reason is that URL Method parsing splits on the / character so you are actually trying to put 3 into StartDate. If you change this to:Loan/AwesomeReport?StartDate=3-1-2013&EndDate=3-15-2013 It works great. Just an FYI. |
Removing multiple ASP.NET development server processes
Sometimes when you are running QBO and debugging by attaching to process you will end up with a dozen or so ASP.NET development server processes. The way to stop this from occurring from the start is changing the properties in the Web Tier projects. The value Always Start When Debugging needs to be set to false as explained in this article. So if you do a fresh pull from source or just forget to set them to false you have several instances of it running. You can go to the tray icons and remove them by right clicking or you do the following:
|
Quandis Intellectual Property
Uniform Appraisal Dataset
The GSE (Fannie Mae, Freddie Mac) are implementing new standards for appraisals. |
Extending Javascript Classes
Javascript classes can be extended or overridden while maintaining prototypical inheritance. This allows you to:
without a complete override of the class. If the base class is later extended within qbo.Core(Web), your class will inherit those extensions unless they conflict directly with your extensions. Example A: Extend qbo.DebtObject to implement a custom FinancialDetailXhtml method qbo.DebtObject.implement('FinancialDetailXhtml', function() { new Request.HTML({ url: '/DtaWeb/DebtService.asmx/FinancialDetail', method: 'post', update: this.Element.id, evalScripts: true, data:{ debtID: this.Get('DebtID'), xsltUrl: this.Get('XsltUrl', '/Templates/Debt/DebtFinancialDetail.xslt') }, onRequest: this.Working.bind(this), onSuccess: this.Display.bind(this), onFailure: this.Error.bind(this) }).send(); }); Example B: Extend qbo.Offer to implement extended columns qbo.OfferObject.implement('Columns', ["OfferID", "Offer", ..., "MyCustomLedgerItemA", "MyCustomLedgerItemB"]); |
Read only FTP hosting via CloudBerry
Eric's previous post shows how to set up Cloudberry to simulate a FTP site. This post shows how to restrict the client to read only access of the files while restricting their view to their own bucket. First I created a bucket at the root level called x-wandw-ort-quandis-com I then created an AIM account called WandWViewOnly as described in Eric's post. Everything works fine, but the W&W users can see the two other root buckets ort-quandis-com and uat-ort-quandis-net and any other bucket at the root level. To restrict their access to their own bucket I created the AIM policy WilliamsReadOnly listed below { "Statement": [ { "Effect": "Allow", "Action": "s3:Get*", "Resource": "arn:aws:s3:::x-wandw-ort-quandis-com/*", "Condition": {} }, { "Effect": "Allow", "Action": "s3:ListBucket", "Resource": "arn:aws:s3:::x-wandw-ort-quandis-com", "Condition": {} } ] } This works, but an extra step is needed in CloudBerry so that tha the W&W users can see the bucket. After the W&W user connects via Cloudberry their list of buckets will emtpy, they need to create an external bucket. This is done by clicking on the green cube and then specifying the bucket name, in my case x-wandw-ort-quandis-com Once they do this then can then drill into the x-wandw-ort-quandis-com bucket to see their files. This type of configuration is explained in more detail here |
FTP Hosting for QBO Clients and Vendors
QBO clients frequently ask if we provide FTP sites for integration with their clients and vendors. We can provide this using existing Amazon S3 account and an FTP-like client called CloudBerry Explorer. To set up an "FTP Site" for a third party:
Note that QBO systems can be configured to read from these dedicated buckets, so that automated processing of files from the QBO site can be configured. |
DTA successfully split from CoreLogic
Our FASLO friends have split into two companies: CoreLogic ADV (run by Brett Benson), and DTA (run by Jason Pinson). DTA is now hosted in the Quandis Data Center (Irvine), and ADV remains running in the CoreLogic data center. Thanks to Kevin Foley, Tamara Pinson, and of course the DTA team for making this difficult transition. DTA is focused on debt collections, and will be able to leverage a lot of the newer features of QBO. We should see them benefit from the VIP Collect concepts we rolled out for Cerno, and can expect them to provide some good real-world feedback to help us improve our Debt and SkipTrace modules. Cerno is in part run by Ted Cassell, who once worked for Jason Pinson at FASLO/CoreLogic. Cerno and DTA will be working together, so we can expect some QBO-QBO integrations between them. |