Manual Update Process For SBO Import Export

Page 1 of 3

Manual Update

Process For

CSA Retail Multi-Branch

SBO Import and Export

Table of Contents

Document Revisions

Overview

Important Directories/Files

Update Process from a Backup

Central Server Process

Store Process

Document Revisions

No / Edited By / Date / Reason
1 / Thomas Ellis / 2005.06.09 / Created

Overview

This document outlines the process of importing updates into a central system from backup created at a store.

Important Directories/Files

In order to import the update files it is necessary to have knowledge of the file/directory layout in order to ensure that imports are done correctly. All directories mentioned here are referenced from the base CSARetail directory unless specified otherwise, this directory is the directory that the program was originally installed into on the computer (ie. By default this is C:\ProgramFiles\CSARetail\ so if the directory is specified as {$CSARetail}\ExportImport it would be equivalent to C:\ProgramFiles\CSARetail\ExportImport).

{$CSARetail}\ExportImport

This is the base directory from which all exported files and to which all files to be imported are written.

{$CSARetail}\ExportImport\Incomming

This is the directory from which all updates are imported into the system whether those are sales import transactions at the central server or record update files at the stores. (NB Please note the spelling mistake in the word “Incomming” this was an error that has since been fixed but the directory structure at Lesotho Milling remains the same).

{$CSARetail}\ExportImport\UpToCentral

This directory is the export directory at each of the stores that holds the files that will be sent to the central server. Please note that this directory does not have any purpose at the central server.

{$CSARetail}\ExportImport\StoreX\Down

This directory is the export directory at each the central server that holds the files that will be sent down to the store specified by X. Please note that this directory does not have any purpose at the stores.

{$CSARetail}\Archive

This directory holds all the exported files that have been created as well as all files that have been imported on the system.

DOWN(SEQ00000003)(TBLSAP_OWGT)(TS050501161932).csv

These files are the record update files sent from the central server to the stores.

UP(ST2)(SEQ00008512)(TBLTXDETAILSPECIAL)(TS050529131952).csv

These files are the sales transaction files sent from the stores to the central server.

Update Process from a Backup

The basic process of importing files from a backup source is to eliminate the file transfer process in the middle. This can be done simply by copying the data from the store backup and running the import manually.

Central Server Process

Once the backup data from the stores has been received the process to import the data is as follows:

  1. Locate the CSARetail\Archive\C\Program Files\CSARetail\ExportImport\UpToCentral directory on the CD
  2. Copy the files from that directory to the {$CSARetail}\ExportImport\Incomming directory
  3. Open the SAPExportImport.exe located in the {$CSARetail} directory
  4. Click on the Export button
  5. Enter the User Name and Password(Default username = “admin” and password =””)

Store Process

Once the update data from the central server has been received at the store the process to import the data is as follows:

  1. Locate the CSARetail\Archive\C\Program Files\CSARetail\ExportImport\StoreX\Down directory on the CD
  2. Copy the files from that directory to the {$CSARetail}\ExportImport\Incomming directory
  3. Open the SAPExportImport.exe located in the {$CSARetail} directory
  4. Click on the Import button
  5. Enter the User Name and Password(Default username = “admin” and password =””)
  6. Click No to “Force update of all records?”

Created on 2005.06.09

Copyright © Computer Information System Technology (CISTECH)