Difference between revisions of "SQL Text Import"

From eStream Software
Jump to: navigation, search
(Import Program)
Line 27: Line 27:
  
 
==Import Program==
 
==Import Program==
* Version (4.2.0.4) - 14 Feb 2015
+
* Version (4.2.0.5) - 04 Apr 2015
 
* http://www.estream.com.my/utility/SQLAccTxtImp-setup.exe (Username & Password is sqlutility)
 
* http://www.estream.com.my/utility/SQLAccTxtImp-setup.exe (Username & Password is sqlutility)
  
 
===History New/Updates/Changes===
 
===History New/Updates/Changes===
* Upgraded to Version 4.2.
+
* Fixed TaxAmt <> TaxAmt in Text File.
* Add TaxInclusive & Batch for Sales & Purchase Module.
 
* Find tunning on Verify.
 
* Auto set to ---- for Area, Agent, Project & Location if empty.
 
* Change GL_OR, GL_PV, AR_IV, AR_DN, AP_PI AP_SD, AR_CN, AP_SC, AR_Customer & AP_Supplier import format.
 
* Fix Verify UOM error.
 
  
 
==Useful tools==
 
==Useful tools==

Revision as of 09:54, 4 April 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.
  3. Support GST

Cons

  1. Only can do New/Insert action.
  2. Maintain Stock Item not covered.
  3. Is Batch update.
  4. There is a cost for End User and Dealer. Only Free record less then 50.
----------------------------------------------------------------------------------------------------------------------------------------------------
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

Import Program

History New/Updates/Changes

  • Fixed TaxAmt <> TaxAmt in Text File.

Useful tools

Installation

  1. Install sqlaccounting
  2. Create Sample Data / Login to the Database wanted to import
  3. Login (username & password is Admin)
  4. Install the Import Program (Username & Password is sqlutility)
  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

See also

  1. SQL Accounting Linking
  2. SDK Live
  3. SQL XML Import