Skip to main content

Text Import Utility Guide

Text Import Step​

  1. Download SQLAccXLSnMDBImp-setup.exe in your pc.

  2. Run and Install the setup file.

  3. Log on to your correct database

    1

  4. Double click the following icon

    2

  5. Makesure the top is show the database you choose

    • Choose the transaction you want to import, eg. customer-maintain customer

      3

  6. Open the patch file you save

    4

  7. Invalid status...

    1. Go into SQL to add the status which are not in the database

      5

    2. Example :

      6

    3. So now, you go into your SQL, add the agent code

      7

      8

  8. Go back to the Text Import, VERIFY again.

    1. If the status show invalid again, go to the SQL and add in.

    2. After add in, get the file and verify again.

    3. For this example, go to Tools --> Maintain Area

      9

    4. The status will shown “ OK ” once you complete.

      10

    5. Once you post to A/C, go to SQL ...... Customer -–> Maintain Customer

    6. Log out and log in again, the new customer name will automatically shown in the customer list.

      11

FAQ​

Do the text import Description3 support multi line?​

Yes if you using the Version 5 & above. All you had to do is to set each line using #13

DETAIL;POS4;;;----;----;"SALES - Foods";;"Line 1#13# Line 2#13Line 3#13#13B#13C";50;UNIT;0;21.20;25/12/2016;;SR;60;1000;T;500-000;T;;;1;;

Result

Line 1
# Line 2
Line 3

B
C

My Data had Special Character/Symbol (eg Ø) how to handle it?​

If you had special Character/Symbol, try convert it to UTF-8 before you export out to text file