(→Steps) |
|||
| Line 59: | Line 59: | ||
==Steps== | ==Steps== | ||
[http://www.sql.com.my/video/sqlacc_tutorial/Text_Import.mp4 SQLAcc-TextImport-Video] <br> | [http://www.sql.com.my/video/sqlacc_tutorial/Text_Import.mp4 SQLAcc-TextImport-Video] <br> | ||
[[File:SQLTxtImport.Fig01.jpg|650px|center]] | |||
<br> | <br> | ||
# Set the Range to Import (Useful if the list too long & only available for Registred version) | # Set the Range to Import (Useful if the list too long & only available for Registred version) | ||
Revision as of 05:34, 31 October 2015
Introduction
Is External Program which able to import master file & transactions to SQLAccounting in Text or CSV format.
Pros
- Easy to generate.
- About 80% of modules is covered.
- Support GST
- FREE import for Master file.
Cons
- Only can do New/Insert action.
- Maintain Stock Item not covered.
- Is Batch update.
- Not support Unicode.
- There is a cost for End User and Dealer. Only Free if each file record less then 100.
- ----------------------------------------------------------------------------------------------------------------------------------------------------
Notes 1. FileName can be any name. 2. 1 DocType/BizObject 1 txt file.
Wanted FREEWARE?...Try Generate each Text file max to 100 records
- ----------------------------------------------------------------------------------------------------------------------------------------------------
Guideline & Example
Import Program
- Version (4.3.0.9) - 10 Sep 2015
- http://www.estream.com.my/downloadfile/Fairy/SQLAccTxtImp-setup.exe
History New/Updates/Changes
--Build 9--
- Upgrade to Version 4.3.
- Add Application Version at Statusbar.
- Extended trial limit to 100 records.
- Remove limit for Master File Import.
--Build 8--
- Fix Unable Compare Long Address in Register Form.
--Build 7--
- Fix Unable import SL_CS if SQL Acc Tax is Inclusive.
- Enable support Nonrefundable.
Useful tools
Installation
- Install sqlaccounting
- Create Sample Data / Login to the Database wanted to import
- Login (username & password is Admin)
- Install the Import Program (Username & Password is sqlutility)
- Run the Import Program
Steps
- Set the Range to Import (Useful if the list too long & only available for Registred version)
- Click Get File button to select the Txt or csv file
- Click Verify To Check any duplicate or Valid Maintenance Code (eg Area, Agent, etc)
- Click the Dropdown List (see below pic) to see all the error
- Click Post To A/c to Post (Only Tick with Status show ok will post)
This is example error on the drop down status