I am actually able to see the excel files in the import folder on the server but they are not imported on the UI. Please help to resolve i need to import a lot of excel data.i have converted excel to .csv format with UTF-8 already

[root@localhost etc]# cd /var/www/html/i-doit/imports
[root@localhost imports]# ls
2018_09_24__Server (1).csv 2.txt.csv 2.xml.csv ExportList.xml PZ_ndinf-pvvcs001_VM_List.csv qcw
2018_09_24__Server.csv 2.xls.csv 3.csv HCE_VM_List_ExportList(NOT A COMPLETE LIST DUE TO PERMISSION ISSUE).csv PZ_ndinf-pvvcs001_VM_List.xml scripts
2018_09_25__Client.csv 2.xml ExportList.csv pune-nyadav01-1031405.xml PZ_svinf-pvvcs001_VM_List.csv
[root@localhost imports]#

i am also facing the same issue.it's not actually taking the xml that i have exported from i-do it itself.still waiting for i-do it team to reply ..Regards,
Nandlal

Hi Sha,

please raise an issue in our help center. There are some tricks I wouldn't like to post them here.

Benjamin

@franknagel Thanks, this fixed the issue.

Good to know that! I will send an email. Thank you for your input.

Hi,

PHP version >7.1 is not supported yet. Please see the system requirements under https://kb.i-doit.com/display/en/System+Requirements#SystemRequirements-LAMPStack.

Kind Regards,
Christian

Double posting 😞

...yep! 😃

Please make sure, that you have the package php-mysqlnd installed instead of php-mysql.

Hi Angel,

please try to clear the browser and the i-doit cache.

Follow the steps to clear i-doit cache:

go to the administration menu then go to the "system tools" -> "cache / database" menu push the button "clear complete cache" and "renew properties"

0_1524821766374_Bildschirmfoto 2018-04-27 um 11.35.24.png

0_1524821783498_Bildschirmfoto 2018-04-27 um 11.35.50.png

Give me a feedback please!

Best regards,
jsemere

Hi Zikhan,

I'm sorry but adding/deleting/changing custom category fields is currently not supported by the API.

Hi,

that is a feature we are planning to release in 2018.

Hi and welcome,

Are you using i-doit pro or open? It is only available in i-doit pro.

Kind Regards,
Christian

Hi,

we currently do not support grouping. It's a feature that is actually being developed. It will be added in i-doit 1.11 (Mid 2018).

Hi,

you could define service filters that filter out specific types of relationships.

Thank you for your feedback !

Hi,

what you have to do is the following (in this order!):

Go to the i-doit admin center and navigate to tenants. Write down the username for each tenant in the Mysql section. Change the password for each MySQL user in the admin center GUI.

Open a mysql client and change the MySQL password for the users that you just identified (matching the passwords you entered in the admin center). Don't forget to commit a 'flush privileges;' command.

Try to login to i-doit. If you can still login, go on and change the system user password.

Open the file /[idoit_webroot]/src/config.inc.php and look at the
        $g_db_system = array(
        …
        "user" => "xxx",
        "pass" => "yyy
        ...
part. Change the password to a new password in the file and save it.

Open a mysql client and change the MySQL password for the user mentioned in the config.inc.php file. Don't forget to commit a 'flush privileges;' command.

Login to i-doit

Additional expert hint: The tenant database passwords are set in the 'idoit_system' database in table 'isys_mandator'.

In the i-doit Knowledge Base we provide two articles which might help you through the upgrade process:

Update of i-doit open 1.4.8 to 1.8

Migration from Windows to Linux

Good luck!