SQL Acc Michelin Export: Difference between revisions

From eStream Software
Line 43: Line 43:
09. Set the Start in(optional) path to the Exe folder (eg. ''C:\eStream\Utilities\SQLAccMichelinExport'') & Click Next
09. Set the Start in(optional) path to the Exe folder (eg. ''C:\eStream\Utilities\SQLAccMichelinExport'') & Click Next
[[File:SQLAccMichelin-04.jpg|center]]
[[File:SQLAccMichelin-04.jpg|center]]
10. Tick the option ''Open the Properties dialog for this task when I click Finish''
10. Tick the option ''Open the Properties dialog for this task when I click Finish''<br />
11. Click Finish
11. Click Finish
[[File:SQLAccMichelin-05.jpg|center]]
[[File:SQLAccMichelin-05.jpg|center]]

Revision as of 04:20, 13 June 2016

Introduction

Is External Shareware Program which Export Daily Sales for Michelin System.
Document Type Export

  • Sales Invoice
  • Sales Cash Sales
  • Sales Debit Note
  • Sales Credit Note

Limitation

  • 1 Computer only can export 1 Company Database only

Export Program

History New/Updates/Changes

--Build 0--

Steps

Export Program

SQLAccMichelin-01.jpg

01. Enter the Server Name or IP Address
02. Click the button & select the Database to be export out.
03. Select the Output Path
04. Select the Start Date to export (ONLY for 1st time use)
05. Click Test Connection to make sure is successfully Connected.

Windows Schedule

01. Open Windows Control Panel | Administrative Tools | Task Scheduler

Scheduler.Task1.jpg

02. Click Action | Create Basic Task...

SQLAccMichelin-02.jpg

03. Enter Task Name (eg SQL Acc Michelin Export) & Click Next

Scheduler.Task3.jpg

04. Select Daily & Click Next

Scheduler.Task4.jpg

05. Set the Start Date & Time to Start
06. Set 1 for Recur every field & Click Next

Scheduler.Task5.jpg

07. Select Start a program & Click Next

SQLAccMichelin-03.jpg

08. Click Browse button & find the SQLAccMichelinExportSchedule.exe (Default at C:\eStream\Utilities\SQLAccMichelinExport)
09. Set the Start in(optional) path to the Exe folder (eg. C:\eStream\Utilities\SQLAccMichelinExport) & Click Next

SQLAccMichelin-04.jpg

10. Tick the option Open the Properties dialog for this task when I click Finish
11. Click Finish

SQLAccMichelin-05.jpg

See also