If Firebird stopped (and emdi displaying a message that says it was terminated because one of the following database-related problems arose), we can go from the Windows control panel and restart by pressing the Start button. If we can’t start Firebird Server Manager on the control panel, another way is to go to the Windows […]
Category: Support | Downloads
Import voucher status from excel
Courier companies usually send an excel file with the status of orders which includes delivery date. This date can be imported in EMDI: In Settings give a name for Custom field 1: In Documents list right click and select the custom field for the column to appear: Select the document and click on the menu (at […]
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 […]
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 [...]
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:
1 | Get-WinUserLanguageList |
If your preferred language is US English, run this command and hit Enter:
1 | $1 = New-WinUserLanguageList en-US |
Finally run this command to set the order of installed input languages:
1 | Set-WinUserLanguageList $1 |
The issue should be fixed.
Import an SQL file using the command line in MySQL – Centos linux
Use the following:
1 | mysql -u database_username -p database_name < database_file.sql |
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:
1 | mysql -u database_username -p -f -D database_name < database_file.sql |
Compress folder recursively using TAR – Centos linux
You can compress recursively a folder keeping ownership and permissions using the following example
1 | tar cvpzf myfolder.tar.gz /home/myfolder |
Compress folder recursively using ZIP – Centos linux
You can compress recursively a folder using the following example
1 | zip -r myfolder.zip /home/myfolder/ |
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 2.2.0.0 SSL & SEO issue fix
There is an Opencart 2.2.0.0 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
1 | $server = $this->config->get('config_ssl'); |
with
1 | $server = str_replace('http:', 'https:', $this->config->get('config_url')); |
After you make this change, refresh Opencart modifications, clear vqmod’s cache (if you have vqmod installed) and your issue […]
