SQL Text Import: Difference between revisions

From eStream Software
No edit summary
Line 10: Line 10:
# Maintain Stock Item not covered.
# Maintain Stock Item not covered.
# Is Batch update.
# Is Batch update.
# Only Sales & Purchase Part support GST (GST Exclusive Only) - 18 Oct 2014
# There is a cost for End User and Dealer.
:::----------------------------------------------------------------------------------------------------------------------------------------------------
::::{|
|-
| [[File:Template.Tips-01.jpg|60px]]|| '''Notes'''
1. FileName can be any name.
2. 1 DocType/BizObject 1 txt file.
|}
:::----------------------------------------------------------------------------------------------------------------------------------------------------


==Guideline & Example==
==Guideline & Example==
[http://www.estream.com.my/document/SQLLink/SQLAcc-TextImport-Guide.pdf SQLAcc-TextImport-Guide.pdf] <br>
[http://www.estream.com.my/document/SQLLink/SQLAcc-TextImport-Guide.pdf SQLAcc-TextImport-Guide.pdf] <br>
[http://www.estream.com.my/document/SQLLink/Example-Text.zip SQLAcc-TextImport-Example]
[http://www.estream.com.my/document/SQLLink/Example-Text.zip SQLAcc-TextImport-Example]
==Useful tools==
* http://www.diffnow.com/


==Installation==
==Installation==

Revision as of 03:33, 10 January 2015

Introduction

Is External Program which able to import master file & transactions to SQLAccounting in Text or CSV format.

Pros

  1. Easy to generate.
  2. About 80% of modules is covered.

Cons

  1. Only can do New/Insert action.
  2. Maintain Stock Item not covered.
  3. Is Batch update.
  4. Only Sales & Purchase Part support GST (GST Exclusive Only) - 18 Oct 2014
  5. There is a cost for End User and Dealer.
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg Notes
1. FileName can be any name.
2. 1 DocType/BizObject 1 txt file.
----------------------------------------------------------------------------------------------------------------------------------------------------

Guideline & Example

SQLAcc-TextImport-Guide.pdf
SQLAcc-TextImport-Example

Useful tools

Installation

  1. Install sqlaccounting
  2. Create Sample Data
  3. Login (username & password is Admin)
  4. Install the Import Program
  5. Run the Import Program

Steps

SQLTxtImport.Fig01.jpg


  1. Set the Range to Import (Useful if the list too long & only available for Registred version)
  2. Click Get File button to select the Txt or csv file
  3. Click Verify To Check any duplicate or Valid Maintenance Code (eg Area, Agent, etc)
  4. Click the Dropdown List (see below pic) to see all the error
  5. Click Post To A/c to Post (Only Tick with Status show ok will post)


SQLTxtImport.Fig02.jpg

This is example error on the drop down status