Installation

Installation Guide

This is the installation wiki guide. There are a number of key steps.

1) Make sure you have the pre-requisits. The installer will download some.
2) Install uShop
3) Configure uShop

Prerequisites

• Sage 50 (Tested with 2012, but should work with 2010 onwards)
• SQL Express 2008 or SQL Server 2008
• .NET Framework 4

Installation

Should just be the case of running the setup file once unzipped.

Configuration

You will find a file called config.xml that controls key elements of uShop.

This looks something like...

<DBstrings>
<L50>Dsn=SageLine50v18;uid=manager</L50>
<SQL>Data Source=.\SQLEXPRESS;AttachDbFilename="D:\USHOP\USHOP\USHOP.MDF";Integrated Security=True;Connect Timeout=30;User Instance=False</SQL>
<InvPath>c:\tmp\</InvPath>
<zPath>c:\tmp\</zPath>
<xlst>D:\ushop\ushop\</xlst>
<sageuser>manager</sageuser>
<sagepwd/>
</DBstrings>

This can be explained as:
L50 :- This is the ODBC string for the Sage 50 interface.
SQL :- This is the connection string for SQL 2008.
InvPath :- This is where Invoices will be saved.
zPath :- This is where ZReadings and XReadings will go.
xlst :- This is where the XLST that controls Invoice layout will go.
sageuser :- Username used for sdata interface
sagepwd :- Password for the sage user.