Category: Support | Downloads
Importing data from a file into pricing.
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 […]
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 […]
Assign OnKeyDown event on TAdvDBFormPanel (Delphi)
This is an easy way to assign onkeydown event in all edit controls created by TAdvDBFormPanel:
1 2 3 4 5 6 7 8 9 10 | var i:integer; editp:TDBAdvEdit; begin for i:=0 to AdvDBFormPanel1.layout.Items.Count - 1 do if AdvDBFormPanel1.layout.Items.Items[i].DataControl = dcedit then begin editp:=(AdvDBFormPanel1.layout.Items.Items[i].EditCtrl as TDBAdvEdit); editp.OnKeyDown:=Edit1KeyDown; end; |