SQL XML Import: Difference between revisions

From eStream Software
Line 41: Line 41:
:::----------------------------------------------------------------------------------------------------------------------------------------------------
:::----------------------------------------------------------------------------------------------------------------------------------------------------
==Import Program==
==Import Program==
* Version (4.1.0.14) - 08 Apr 2015
* Version (4.1.0.15) - 15 Apr 2015
* http://www.estream.com.my/utility/SQLAccImportV4-setup.exe (Username & Password is sqlutility)
* http://www.estream.com.my/utility/SQLAccImportV4-setup.exe (Username & Password is sqlutility)


===History New/Updates/Changes===
===History New/Updates/Changes===
* Fixed Amount not correct if is Tax Inclusive is Tick.
* Fixed JE Import Access Violation.


==Useful tools==
==Useful tools==

Revision as of 10:41, 15 April 2015

Introduction

Is External Program which able to import master file & transactions to SQLAccounting in XML format.

Pros

  1. Can do action such as New & Edit.
  2. About 95% of modules is covered.
  3. Support GST
  4. Free of Charge for End User.

Cons

  1. Payment & Credit Note can't do Edit action.
  2. Can’t do Delete action.
  3. Not easy to generate.
  4. Is Batch update.

Guideline & Example

You can just go to the module you wanted to import Example for Sales Invoice

  1. Click Sales | Invoice...
  2. Select any Invoice
  3. Click Detail
  4. Right Click below empty Browse button
  5. Select Copy Invoice
  6. Open Notepad & paste it
  7. Save the filename as SL_IV.IV-00270.300-A0003.xml
  (Example IV No. IV-00270 & Customer code is 300-A0003)

SQLAcc-XMLImport-Example

----------------------------------------------------------------------------------------------------------------------------------------------------
Template.Tips-01.jpg Notes
1. FileName :=
   - BizObject.DocNo.CompanyCode.xml for AR, AP, SL & PH
   - BizObject.DocNo.xml for GL & ST
   - BizObject.Code.xml for Tools
2. 1 Record 1 xml file.
3. Please zip all the xml in 1 zip file, the zip filename can be anything &
   no folder in zip file.
----------------------------------------------------------------------------------------------------------------------------------------------------

Import Program

History New/Updates/Changes

  • Fixed JE Import Access Violation.

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

SQLXMLImport.Fig01.jpg


  1. Click Folder Icon button to select the zip file which content of XML file.
  2. Tick the Module to import.
  3. Click Verify button to check any conflict.
  4. Any Error or Conflict will be seen here
  5. In this Action user can change the option either is Import or Replace
  6. Tick this Option if wanted to set status on each document (only available if there is UDF Module with UDF_Status)
  7. Click Import to Post to Account (Only import it the Check box is Tick)
Description Properties
Import Action It will Insert the Record To SQL Accounting
Replace Action It will Call Edit & Update the Record
Action Button This button Allow user to batch Change the Action Column

See also

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