CodePartners - Software Development - Dallas, Texas Software Development - Sage Accpac Customization - SageCRM Customization
Login
pay invoice online  |  remote assistance  |  
  • INTERNET APPLICATION DEVELOPMENT

    • Services
      • Web Application Development
      • Mobile Applications
      • Integration Solutions
      • Staff Augmentation
    • Technologies
    • How we work
    • About us
    • Success stories
    • Blog
  • MID MARKET ERP DEVELOPMENT

    • Intacct
    • Sage CRM
    • Sage
    • Sage Component Catalog
    • How We Work
    • About Us
    • Success Stories
    • Blog

Blog

CodePartners Blog

rss


Improve SQL Performance

by Derek Du

Recently, we were asked to improve the performance of some SQL queries that run for 15 seconds and 30 seconds. At first, we were not sure whether the performance could be improved, given that there were about 80 million data pieces in the database. I have to admit that SQL Server is really powerful as eventually we reduced the time to 2 seconds and 6 seconds!

During the proces...

Read More »

On April 30, 2015 in Development [Post:by] Comment 0
Tagged With: SQL performance, SQL Server, trouble shooting / 3870 Views

Sure, You Still Use Spreadsheets, But Are You Guilty of Creating …“SpreadWARE”?

Yes, we’ve all been using spreadsheets for years (some of us, for decades now…) for simple what-if scenarios, for profit/loss statements, for reconciling bank statements, even for complex risk-analyses.
While some industry pundits are extoling the virtues of a “spreadsheet-free&rdquo...
Read More »

On April 27, 2015 in Development, General [Post:by] Comment 0
Tagged With: automation, Intacct, customization / 4157 Views

Avoid Client Timeout on Web API Call

by Derek Du

If a WebAPI service takes a long time to complete, the caller -- the client side -- may timeout waiting for a response. There are several options to solve this issue, you can increase the timeout limit on the client side and web server side, or use a more persistent connection method like WebSocket and SignalR.

I propose a different way to avoid the timeout issue that all...
Read More »

On March 6, 2015 in Development, Web Development [Post:by] Comment 0
Tagged With: C#, loading animation, .NET, ASP.Net, REST, User experience / 6686 Views

Fixing the Issue “The request was aborted: Could not create SSL/TLS secure channel”

by Jacky Xu

Recently, our Intacct projects keep getting the error “The request was aborted: Could not create SSL/TLS secure channel” when the program request posts to Intacct web site. So, I searched for the solution from the website. Some blogs said, “Many companies have disabled SSLv3.” and “TLS is the standard protocol in .NET for a few years and SSLv3 is just us...
Read More »

On February 23, 2015 in Development [Post:by] Comment 0
Tagged With: user interface, Intacct / 11252 Views

Designing Error Messages

by Derek Du

Displaying error message is one of the most basic functions of an application, but it also can be overlooked easily because we often focus on the core functions of the application. There are many ways to present error messages, but in my opinion there are basically three objectives we want to achieve with error message and as long as the design can fulfill those, it is a ...

      Read More »

      On February 19, 2015 in Development, Web Development [Post:by] Comment 0
      Tagged With: user experience, Best practices, UI design / 2734 Views

      Paging Data for SQL Server

      by Jacky Xu

      Before a new version of SQL server is released, we always implement data paging through the transact-SQL function “ROW_NUMBER” and it always needs a nested SQL script. Microsoft released new scripts “OFFSET” and “FETCH” for data paging functions. Here are two sample queries for different SQL server version paging function.

      First, we query all dat...
      Read More »

      On February 9, 2015 in Development [Post:by] Comment 0
      Tagged With: offset script, fetch script, Microsoft, SQL server / 2727 Views

      How Flexible Should a System Be?

      by Derek Du

      Flexibility has a real cost

       
      It is common for people to ask UI designers to design a system as flexible as possible. People believe that it is always better for something to be flexible. They think the more flexible the system is, the better the overall experience of the system. However, this is not always true. When we say this design is more flexible than the other one, we ar...

      Read More »

      On February 6, 2015 in Development, Web Development [Post:by] Comment 0
      Tagged With: usability, Flexibility, system design, UI design, UX design / 2921 Views

      OperationContext.Current Is Full

      by Derek Du

      Today, I tried to run a previous WCF project and it refused to work. The error message was: OperationContext.Current is null. The project uses a third-party written WCF custom encoder that enables SOAP with Attachment, so it made that much harder to debug the issue. After struggling with it the whole day, I was surprised to find that the issue was becaus...
      Read More »

      On January 21, 2015 in Development, Success Stories [Post:by] Comment 0
      Tagged With: Operation Context, SOAP with attachment, Troubleshooting, WCF, WS-Addressing / 2549 Views

      Integrating Sage 300 ERP with a Document Mangement System

      by Emma Tsai

      Recently, I worked on an interesting integration project between doc-link and Sage 300 ERP. doc-link is a document management and workflow solution the client uses to address their paper intensive process for Accounts Payable. After we reviewed their business process and identified the gap, we proposed an integration solution that imports voucher data from doc-link into Sage 300 ERP...
      Read More »

      On January 19, 2015 in Development, Integration [Post:by] Comment 0
      Tagged With: doc-link, Sage 300 ERP / 3616 Views

      How to use soapUI 5.0 to post JSON to REST Service

      by Derek Du

      I wrote an article on the same topic but with version 4.5.1 soapUI back in 2013. To post JSON with an 4.5.1 version soapUI, you almost have to trick the application by explicitly typing in the media type "application/json," and there are also a few settings that don’t make sense. I always forget the steps and have to go back to check my blog post.

      Since then, I tried newer v...
      Read More »

      On January 16, 2015 in Development [Post:by] Comment 0
      Tagged With: app development, user design, JSON / 3493 Views
      12345678910...1516Next

      Search

      Categories

      • General (166) rss
      • Development (158) rss
      • Success Stories (40) rss
      • Products (29) rss
      • Uncategorized (18) rss
      • BTerrell Group (5) rss
      • Project Management (22) rss
      • Web Development (57) rss
      • Web application (33) rss
      • Integration (19) rss
      • Mobile Development (7) rss

      Archives

      • 2015
        • January (5)
        • February (7)
        • March (6)
        • April (5)
        • May (2)
      • 2014
        • January (13)
        • February (12)
        • March (13)
        • April (12)
        • May (11)
        • June (12)
        • July (11)
        • August (13)
        • September (10)
        • October (8)
        • November (6)
        • December (4)
      • 2013
        • April (73)
        • May (22)
        • June (20)
        • July (20)
        • August (22)
        • September (19)
        • October (13)
        • November (12)
        • December (7)

      Tags

      .NET Accpac app development application customization application development automation Azure C# cloud components Crystal Reports customization development ERP general ledger HTML5 Intacct Intacct Platform Services integration JQuery load balancer mass update mobile development OCR Order Entry outsourcing PO pricing product development project management REST Sage 300 ERP Sage CRM software integration trigger user interface Visual Studio web application web development website development Workforce Go! .NET ACA accpac Ajax Amazon AP invoices application development Arxis ASP.NET automation Axure BTerrell Group C# Cloud computing CodePartners Constant Contact credit card processing CRM crystal reports custom software Customer Service Customization Delete team project design phase Development doc-link DRILLDWNLK ERP event Excel GLAFS Intacct Intacct Advantage Intacct Platform Services Integration Java script JavaScript jQuery Kerr Consulting LinkedIn Microsoft MSSQL Offshoring outsourcing payroll PCI compliance PCI-DSS Pivot PJC project management sage Sage 300 Sage 300 ERP Sage Accpac ERP Sage CRM Smart Rule social media software testing SQL SQL Query SQL Server staff augmentation sub-ledger success success story TFS Trouble shooting UI design Visual Studio WCF Web API web application web design web development Webinar website Windows Windows Azure XML
      ABOUT US / CONTACT US / NEWS & EVENTS
      CodePartners / 17250 Dallas Parkway, Ste. 225 / Dallas, Texas 75248 / Phone: 214-647-2611 / Toll Free: 866-647-2611 / Fax: 214-647-2612 / info@codepartners.com
      © 2006 - 2015 codepartners.com All Rights Reserved.