Articles

Create a View using SSMS Query Designer

When you install SQL Server Management Studio, it comes with a lot of very helpful database tools. The Query Designer is a way to build Select statements that can then be placed into custom views in your database. These views

Posted in Database, Technology

Common webstore issues and xpaths

Amazon webstore brings in orders with different fulfillment channels, AFN and MFN. Is there a way to split up the two? You must have two webstore templates for this. One where orders are only selected for AFN in one template,

Posted in Configuration, Technology, Web Store Integration

Source Values window – Xpath operators and functions

When adding a new xpath to the webstore configuration, you might need to do operations on values coming into that node. The following are some basic operators used under the “Select” section. Note that xpath is CASE SENSITIVE. It’s recommended

Posted in Configuration, Technology, Web Store Integration

Source Values window – Understanding Namespaces, Tables and Values

The Source values window under Webstore configuration has three sections which determines how the webstore xml file is structured, and how it comes in to Acctivate. Namespace Namespace is a way to define a scope for functions. By default URL

Posted in Add-On Modules, Technology, Web Store Integration

Webstore Configuration – Adding Xpaths

When importing in sales orders or customers from a webstore, Acctivate uses a query language called “XPath” to map information from a given XML file. When setting up a webstore template, these xpaths are generally predefined but there might be

Posted in Add-On Modules, Sales, Technology, Web Store Integration

Locating the Server with Acctivate’s Active Database

When using more than one server, there may come a time when Acctivate’s database is copied from one server to another one. This is especially true if you have undergone a server migration at some point in the past. While

Posted in Database, Installation, Technology

Install SQL Server 2016 Express Edition

The Acctivate Server (New/Full) Install package includes SQL Server Express Edition.  However, there are times when you may need to install SQL Server Express for Acctivate separately.  Please follow the instructions below to install and configure SQL Server 2016 Express Edition for

Posted in Installation, Microsoft, Other Applications, Technology

Search Operators

With improved look up functions, we’ve added the capability to search the values within Acctivate fields utilizing different search operators. By default, any value typed into the search field will be utilized as if you’re looking for something containing said

Posted in Technology

Multi Field Search

The look up windows in Acctivate have 2 different ways to search: Search multiple fields at one time Search within one Acctivate field at one time When the you don’t know the exact information to look for, it would be

Posted in Technology

Changing the user account for an application pool in IIS

Whenever a new application pool is created in IIS, it will use an account defined by IIS (usually it’s called “ApplicationPoolIdentity”) which is under the “Identity” section. Identities are similar to a “account” you would use to log into your

Posted in Mobile, Technology
Still need help?
Search all content on this site, contact support at 817-870-1311, or create a support ticket.