Please find here a link to a new case study to promote our bespoke development services. The case study was conducted with one of our longest standing customers – Craigdon Business Gifts.
Posts Tagged ‘bespoke development’
BLOG: bespoke development services case study released
Thursday, September 10th, 2009SSRS: an answer to rsReportParameterValueNotSet error
Wednesday, September 2nd, 2009An answer to SQL Server Reporting Services (SSRS) rsReportParameterValueNotSet – “This report requires a default or user-defined value for the report parameter. To run or subscribe to this report, you must provide a parameter value” error.
CONNECTIT: ConnectIT-Sage v1.10.1 released
Thursday, May 14th, 2009This new release of ConnectIT-Sage QuoteWerks to Sage 50 Accounts link includes the following updates and bug fixes:
UPDATE: replaced the files for the SDO (Sage Data Objects) which allow ConnectIT to integrate with Sage 50 Accounts 2009 for the revised ones released by Sage 12/5/2009. This revision allows up to 6 simultaneous SDO connections without the need to purchase additional Sage licenses.
FIXED: discrepencies seen in the Tax on Sage Purchase Order line items – ConnectIT was using the selling price tax value, not the cost price tax value when writing Purchase Order information to Sage.
FIXED: a tax amount for Carriage may show on a Purchase Order even though the ConnectIT Configuration had the Purchase Document Carriage Tax Code set as “T0″ – ConnectIT was ignoring this setting when creating Purchase Order documents, the QuoteWerks document tax rate was always applied to Purchase Order carriage.
FIXED: Conversion from string “” to type ‘Boolean’ is not valid error when running ConnectIT – this could occur if the user had not opened ConnectIT Configuration to check the new settings added in version 1.10.0 and pressed “Save”.
After more than 2 years of having no bugs in a production release, the ConnectIT development team were mortified to find out that a bug had been found in the software. As is stereotypically the case, the ConnectIT software development team have a love for fast food (second only to their love for programming!). By way of self-inflicted punishment for the bug (which was ultimately a school boy error in the code) they are banning themselves from fast food for 1 month!!! (I just hope they survive! – Ed.)
For more information on ConnectIT-Sage and the other products in the ConnectIT suite of time and labour saving products, please see the ConnectIT website here, contact your QuoteWerks / ConnectIT reseller or email info@connectit-online.co.uk
DEVELOPMENT: Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI” for linked server
Friday, May 8th, 2009Running a query from SQL Server 2008 over a linked server connection to a SQL Server 2000 server causes the following error:
OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “Unspecified error”.
OLE DB provider “SQLNCLI10″ for linked server “mylinkedserver” returned message “The stored procedure required to complete this operation could notbe found on the server. Please contact your system administrator.”.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider interface, but returns a failure code when it is used.
Or
The stored procedure required to complete this operation could not be found on the server. Please contact your system administrator.
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO” for OLE DB provider “SQLNCLI” for linked server “
Firstly, SQL Server 2000 SP4 (service pack 4) must be installed.
Then the system stored procedures must be manually upgraded.
Note that when manually upgrading the system stored procedures, we used SQL Server Authentication mode which requires the syntax:
osql -U [adminlogin]-P [adminpassword]-S [linkedservername]-i [location]\instcat.sql
We first entered the line as:
osql -U sa -P myPassword -S myServer -i C:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql
But this just bought up the osql help /? list of parameters. To avoid this, make sure that the -i path is in speech marks!
osql -U sa -P myPassword -S myServer -i “C:\Program Files\Microsoft SQL Server\MSSQL\Install\instcat.sql“
Note that the manual upgrade takes a couple of minutes to run and there are a whole bunch of message and numbers displayed in the command window as it executes. If the process is successful, then the last but one line will read “instcat.sql completed successfully”.
In our experience, the SQL Service did not need to be restarted, the fix worked immediately and we were able to query the SQL Server 2000 server from SQL Server 2008 over the link immediately:
SELECT COUNT(*)
FROM myLinkedServer.myDatabase.dbo.myTable
We hope that this tip helps others new to SQL Server 2008 development!
Please see our website for more information on our software development services and software development resources.
Business Development Manager wanted (Stoke-on-Trent)
Friday, May 1st, 2009A new full time position is available for a sales person selling computer software products and services. This is an excellent opportunity to join a small, ambitious, highly motivated and positive team of individuals in a growing business and offers excellent career prospects for the successful candidate.
DEVELOPMENT: Google launches API for Google Analytics
Wednesday, April 22nd, 2009Google has announced the release of an API for Google Analytics. This means developers will be more tightly integrate information into users back office, web and mobile applications.
Announcement Headline: A Google Analytics API has long been one of our most widely anticipated features. Today we’re pleased to announce that the Google Analytics Data Export API beta is now publicly available to all Analytics users!
What’s so exciting about an API? The API will allow developers to extend Google Analytics in new and creative ways that benefit developers, organizations and end users. Large organizations and agencies now have a standardized platform for integrating Analytics data with their own business data. Developers can integrate Google Analytics into their existing products and create standalone applications that they sell. Users could see snapshots of their Analytics data in developer created dashboards and gadgets. Individuals and business owners will have opportunities to access their Google Analytics information in a variety of new ways.
For the full announcement, please see the Google Analytics Blog post.
For more information on Hilltops IT’s software development services and to speak with one of our development team about the possibilities for integrating Google Analytics information into your business support systems, please contact us by phone on +44(0) 1782 564252 or by email: development@hilltopsit.co.uk
CONNECTIT: ConnectIT-MAS90 QuoteWerks to Sage MAS90 and MAS200 v1.1.1 released
Friday, March 13th, 2009ConnectIT-MAS90 QuoteWerks to Sage MAS90 and MAS200 v1.1.1 has been released today – Friday 13th March 2009.
This new release wraps up several enhancements which ConnectIT users and partner resellers have requested as follows:
UPDATE: transfer the Contact name selected for the Address fields from QuoteWerks to the Confirm To field in the Sage MAS document
UPDATE: support for names and descriptions, etc in QuoteWerks that are longer than those in Sage MAS. ConnectIT will now trim the QuoteWerks field to match on just the left ‘x’ characters, allowing a match to be found.
UPDATE: new ConnectIT icons
Existing users with current UMP: download your copy from here – http://www.connectit-online.co.uk/download.aspx?p=CITMAS90
New customers or users without UMP: please contact your ConnectIT / QuoteWerks reseller or email sales@connectit-online.co.uk for further information.
To request new features that would help your business process run more effectively, please email development@connectit-online.co.uk
For more and up-to-date information on the ConnectIT suite of products, please see the website here: http://www.connectit-online.co.uk/
DEVELOPMENT: tips for developing applications for “the cloud”
Wednesday, March 11th, 2009Cloud computing, which involves accessing applications and services on hosted servers over the Internet, certainly has become the hot tech trend for 2009. The volume of cloud applications can only be expected to grow, and this fact brings both new benefits and responsibilities for developers.
While cloud deployments can save developers from having to deal with infrastructure issues, there are some new nuances they must deal with as well. These include changes in how developers work with databases, an emphasis on stateless applications, and dealing with different frameworks.
for more information, see the article from here: http://www.infoworld.com/archives/emailPrint.jsp?R=printThis&A=/article/09/03/11/10NF-cloud-app-dev_1.html
CONNECTIT: ConnectIT-Sage QuoteWerks to Sage 50 Accounts v1.9.0 released
Monday, March 2nd, 2009ConnectIT-Sage QuoteWerks to Sage 50 Accounts v1.9.0 has been released today – Monday 2nd March 2009.
This new release wraps up several enhancements which ConnectIT users and partner resellers have requested as follows:
ADDED: the ability to select which Suppliers Purchase Orders are created for.
ADDED: the ability to transfer Comment lines into Sage as Message lines.
ADDED: the ability to transfer Group (Bundle) Header lines as Comments into Sage as Message lines.
ADDED: a check on whether a customer or suppliers credit limit has been exceeded. The prompt can be suppressed by ticking the Configuration Advanced “Suppress prompts that Customers or Suppliers Balance exceeds their Credit Limit” tick box.
ADDED: the ability to transfer a value into the Sage document line item Comment 1 and 2 fields
UPDATE: if the “Override Product Tax” field is ticked in the Sage Supplier record, then use the Default Tax Code and corresponding Tax Rate from Sage on all lines when creating Purchase Order documents (works for all supported versions of Sage 50 Accounts). Note that the user must be using the “Supplier Address information is maintained in Sage not QuoteWerks” Configuration option.
UPDATE: if the “Override Product Nominal” field is ticked in the Sage Supplier record, then use the Default Nominal Code and Department number from Sage on all lines when creating Purchase Order documents (works for version 14 – 2009 – of Sage 50 Accounts only, this option is not available in earlier versions). Note that the user must be using the “Supplier Address information is maintained in Sage not QuoteWerks” Configuration option.
UPDATE: include all Document Header fields in the Configuration Customer Account Reference, Documents Sales Doc Number, Purchase Doc Number and Creation Date field drop down selectors
UPDATE: new ConnectIT icons
Existing users with current UMP: download your copy from here – http://www.connectit-online.co.uk/download.aspx?p=CITSAGE50
New customers or users without UMP: please contact your ConnectIT / QuoteWerks reseller or email sales@connectit-online.co.uk for further information.
To request new features that would help your business process run more effectively, please email development@connectit-online.co.uk
For more and up-to-date information on the ConnectIT suite of products, please see the website here: http://www.connectit-online.co.uk/
DEVELOPMENT: Fortnightly digest – what’s happening at Hilltops IT and the world of software development
Friday, February 20th, 2009Development Team Diary
Most of the effort this last couple of weeks has been on some of our own software products in the ConnectIT suite. With last weeks ConnectIT-WebCart prototype release and a new beta release of ConnectIT-Sage QuoteWerks to Sage 50 Account link out today.
