SQL Text Import: Difference between revisions

From eStream Software
Line 31: Line 31:
[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]
===Special Character===
{| class="wikitable" style="margin: 1em auto 1em auto;"
|-
! User Input !! Text Output
|-
| SalesOrder || SalesOrder
|-
| Sales Order 5' 12" || "Sales Order 5' 12"""
|-
| SalesOrder6'13" || "SalesOrder6'13"""
|-
| SalesOrder6" x 13" || "SalesOrder6"" x 13"""
|-
| Sales Order || "Sales Order"
|}


==Import Program==
==Import Program==

Revision as of 09:58, 8 January 2016

Introduction

Is External Shareware 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
  4. FREE import for Master file.

Cons

  1. Only can do New/Insert action.
  2. Maintain Stock Item not covered.
  3. Is Batch update.
  4. Not support Unicode.
  5. Same DocNo for Different Supplier not cover
  6. There is a cost for End User and Dealer. Only Free if each file record less then 100.
----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg Notes
1. FileName can be any name.
2. 1 DocType/BizObject 1 txt file.
Template.Tips-01.jpg Wanted FREEWARE?...Try Generate each Text file max to 100 records
----------------------------------------------------------------------------------------------------------------------------------------------------

Guideline & Example

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

Special Character

User Input Text Output
SalesOrder SalesOrder
Sales Order 5' 12" "Sales Order 5' 12"""
SalesOrder6'13" "SalesOrder6'13"""
SalesOrder6" x 13" "SalesOrder6"" x 13"""
Sales Order "Sales Order"

Import Program

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

  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

SQLAcc-TextImport-Video

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

Video

See also