Microsoft C360 - Manuals - manualsarea.com

Page 2 - Table of Contents

Table of Contents Introduction ............................................................................................................................... ....................................... 3 Features ....................................................................................

Page 5 - “ImportManager

Finally, if you want to be able to import more than 10 lines at a time, make sure you have a license and refer to the final chapter in this section on how to deploy this license. Requirements ImportManager 2008 requires a Windows Server 2003 OS with .NET 2.0 installed. Furthermore it is important th...

Page 13 - “Next”

16. Confirm. Now the installer has gathered all the necessary information to install the Import Manager 2008 Client. Simply click “Next” . 17. Installing. Please wait while the installer progresses through the installation.

Page 24 - Setting up the Data Source:; Right click

Simple Import The Simple Import guides covers a simple bare bones import when using either a text file or a SQL (ODBC) data source. Text Source Follow the guide in this chapter step by step if you want to setup a simple import from a text file. This guide will not cover dynamic fields, transformatio...

Page 27 - Click

5. Text File Settings. Make sure that the settings for the chosen file are correct. You can select a file under the file name drop down menu, select whether this file has a header row or not, choose the Separator, if there's any quotation and finally what encoding the file uses. The Separator is use...

Page 28 - Setting up the Package:

6. Done. The Data Source has now been created. If you select it in the tree, by expanding "Data Sources" and s the particular data source, you can view and change settings. Setting up the Package: 7. New Package. Right click "Package" in the left tree menu and select "New" . ...

Page 33 - icon in the menu bar in the top.

12. Matching. It's possible to change settings for the Data Source here, as well as create Dynamic Fields, but for this simple import we will go straight to matching. Click the "Matching" icon in the menu bar in the top.

Page 35 - Right click the newly created filter and select

14. Add Conditions. Right click the newly created filter and select "Add Condition..." .

Page 44 - SELECT * FROM Contacts

3. ODBC Settings. You need to give ImportManager 2008 a connection string to the ODBC Source to which you want to connect. In our example we wish to connect to a SQL Server 2005 Database and so we need the following connection string: Driver={SQL Native Client};Server=myServerAddress;Database=myData...

Page 45 - To finish, simply click

To finish, simply click "OK" . You can find alternative connection strings to suit your setup on the following homepage: www.connectionstrings.com Setting up the Package: 4. Create Package. Right click "Package" in the tree structure in the left side and select "New" as seen ...

Page 52 - fast and efficient manner.

FAQ and Common Errors In this chapter you will find a mixture of frequently asked questions and common errors. These have been divided into sub chapters, to allow you to identify locate your problem or question in a fast and efficient manner. Installation and Setup Here you will find a list of commo...

Page 53 - Unable to connect to remote server.; “local”; The request failed with an empty response.

2. Unable to connect to remote server. This error message will likely pop up when the wrong port number is provided during login. 3. The remote name could not be resolved: ‘local. This error message will show when the wrong server name is provided – in this case the name “local” . 4. Client found re...