Category: Support | Downloads

Import / export excel, text, csv from settings.

At EMDI in addition to the ability to import data from sales, customers,inventory  we can also import data through the settings. First we  open the settings and we choose the field which we  want to import or export data. In the example above  I use the sub-category items field to import some categories in this […]

Last modified.: 29/08/2018 Data Import

Importing data from a file into pricing.

EMDI offers the ability to import text, csv or excel products into pricing. The file that can be imported into EMDI must be in Microsoft Excel 97-2003 format (.xls) or plain text delimited by a character (.csv). It must be a Microsoft Excel worksheet or export to Excel or csv. The steps to import into [...]
Last modified.: 29/08/2018 Data Import

Change unwanted language – keyboard layout (windows 10)

Set your preferred input language. Open Powershell with administrator rights. Run this command to get a list of installed languages:

If your preferred language is US English, run this command and hit Enter:

Finally run this command to set the order of installed input languages:

The issue should be fixed.

Last modified.: 31/07/2018 Windows general issues

Import an SQL file using the command line in MySQL – Centos linux

Use the following:

If your database has errors and you want to import it anyway, use the –force (-f) flag. Rather than stopping on the offending statement, MySQL will continue and just log the errors to the console:


Compress folder recursively using TAR – Centos linux

You can compress recursively a folder keeping ownership and permissions using the following example


Compress folder recursively using ZIP – Centos linux

You can compress recursively a folder using the following example


LogonUser to remote machine fails with error 1326

LogonUser to remote machine fails with error 1326. Just try to login to the remote via explorer and when you asked for credentials don’t forget to click save.

Opencart SSL & SEO issue fix

There is an Opencart issue because base href tag is not properly setup when using SSL and static assets are loaded with the wrong path. To fix this, edit catalog/controller/common/header.php and replace


After you make this change, refresh Opencart modifications, clear vqmod’s cache (if you have vqmod installed) and your issue […]

Setup SIP account – Zoiper


Avoid changing date on data import

Each time we import data from a file into EMDI, the date on each line imported, being modified. To avoid this, when selecting the fields to be inserted, in a blank column, we assign the Modify field. So because the field is empty it will not be affected and therefore the date will remain as […]

Last modified.: 03/11/2017 Data Import
1 2 3 4 12