Reset Password · YAF.NET Support Forum

Welcome Guest! To enable all features please Login or Register

Posted by: nazihaizzati - Monday, 6 January 2020 06:11:36
Hi watcha, 1. the dialog box on "User and Roles">"User">"Import User(s)" not appear the file name. How can I change the code and see the file name? 2. I tried using the import function in "User and Roles">"User">"Import User(s)" and want to import 5000++ users, unfortunately it have an error "Failed to import: Input array is longer than the number of columns in this table" 3. I want to tried using the import function in "User and Roles">"User">"Import User(s)", When i tried to import user with 50 users data and I sync All membership users, the data become 1194 users. What error cause on that?

Posted by: nazihaizzati - Monday, 6 January 2020 06:11:36

Hi watcha, 1. the dialog box on "User and Roles">"User">"Import User(s)" not appear the file name. How can I change the code and see the file name? 2. I tried using the import function in "User and Roles">"User">"Import User(s)" and want to import 5000++ users, unfortunately it have an error "Failed to import: Input array is longer than the number of columns in this table" 3. I want to tried using the import function in "User and Roles">"User">"Import User(s)", When i tried to import user with 50 users data and I sync All membership users, the data become 1194 users. What error cause on that?

Posted by: tha_watcha - Monday, 6 January 2020 13:04:39
[quote=nazihaizzati;72322]Hi watcha, 1. the dialog box on "User and Roles">"User">"Import User(s)" not appear the file name. How can I change the code and see the file name? 2. I tried using the import function in "User and Roles">"User">"Import User(s)" and want to import 5000++ users, unfortunately it have an error "Failed to import: Input array is longer than the number of columns in this table" 3. I want to tried using the import function in "User and Roles">"User">"Import User(s)", When i tried to import user with 50 users data and I sync All membership users, the data become 1194 users. What error cause on that? [/quote] 1. Will be fixed in 2.30.6 you can see the changes here... https://github.com/YAFNET/YAFNET/commit/21f52e53ffb55adeae0350186a2286f7664d22d1 2. which format? with xml it should work

Posted by: tha_watcha - Monday, 6 January 2020 13:04:39

[quote=nazihaizzati;72322]Hi watcha, 1. the dialog box on "User and Roles">"User">"Import User(s)" not appear the file name. How can I change the code and see the file name? 2. I tried using the import function in "User and Roles">"User">"Import User(s)" and want to import 5000++ users, unfortunately it have an error "Failed to import: Input array is longer than the number of columns in this table" 3. I want to tried using the import function in "User and Roles">"User">"Import User(s)", When i tried to import user with 50 users data and I sync All membership users, the data become 1194 users. What error cause on that? [/quote] 1. Will be fixed in 2.30.6 you can see the changes here... https://github.com/YAFNET/YAFNET/commit/21f52e53ffb55adeae0350186a2286f7664d22d1 2. which format? with xml it should work

Posted by: nazihaizzati - Tuesday, 7 January 2020 01:43:29
[quote=tha_watcha;72326][quote=nazihaizzati;72322]Hi watcha, 1. the dialog box on "User and Roles">"User">"Import User(s)" not appear the file name. How can I change the code and see the file name? 2. I tried using the import function in "User and Roles">"User">"Import User(s)" and want to import 5000++ users, unfortunately it have an error "Failed to import: Input array is longer than the number of columns in this table" 3. I want to tried using the import function in "User and Roles">"User">"Import User(s)", When i tried to import user with 50 users data and I sync All membership users, the data become 1194 users. What error cause on that? [/quote] 1. Will be fixed in 2.30.6 you can see the changes here... https://github.com/YAFNET/YAFNET/commit/21f52e53ffb55adeae0350186a2286f7664d22d1 2. which format? with xml it should work [/quote] 2. I am using csv separate comma format. 3. How about no 3? I have trying not import any files, just sync all the membership. Unfortunately, the data keep the appear the same 1194 users.

Posted by: nazihaizzati - Tuesday, 7 January 2020 01:43:29

[quote=tha_watcha;72326][quote=nazihaizzati;72322]Hi watcha, 1. the dialog box on "User and Roles">"User">"Import User(s)" not appear the file name. How can I change the code and see the file name? 2. I tried using the import function in "User and Roles">"User">"Import User(s)" and want to import 5000++ users, unfortunately it have an error "Failed to import: Input array is longer than the number of columns in this table" 3. I want to tried using the import function in "User and Roles">"User">"Import User(s)", When i tried to import user with 50 users data and I sync All membership users, the data become 1194 users. What error cause on that? [/quote] 1. Will be fixed in 2.30.6 you can see the changes here... https://github.com/YAFNET/YAFNET/commit/21f52e53ffb55adeae0350186a2286f7664d22d1 2. which format? with xml it should work [/quote] 2. I am using csv separate comma format. 3. How about no 3? I have trying not import any files, just sync all the membership. Unfortunately, the data keep the appear the same 1194 users.

Posted by: nazihaizzati - Tuesday, 7 January 2020 02:16:23
I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format

Posted by: tha_watcha - Tuesday, 7 January 2020 09:32:37
[quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.

Posted by: tha_watcha - Tuesday, 7 January 2020 09:33:49
[quote=nazihaizzati;72329]How about no 3? I have trying not import any files, just sync all the membership. Unfortunately, the data keep the appear the same 1194 users.[/quote] Are you getting duplicate users? This issue is hard to reproduce without the data. This will take some time to test.

Posted by: nazihaizzati - Wednesday, 8 January 2020 10:33:44
[quote=tha_watcha;72331][quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.[/quote] It hard for me to export using the xml export format because i have almost 6000 users. Is there other way to import the users? using csv is better approach but I just can import until 1125 users until the error come out "Failed to import: Input array is longer than the number of columns in this table".

Posted by: nazihaizzati - Wednesday, 8 January 2020 10:33:44

[quote=tha_watcha;72331][quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.[/quote] It hard for me to export using the xml export format because i have almost 6000 users. Is there other way to import the users? using csv is better approach but I just can import until 1125 users until the error come out "Failed to import: Input array is longer than the number of columns in this table".

Posted by: tha_watcha - Wednesday, 8 January 2020 12:22:58
[quote=nazihaizzati;72334][quote=tha_watcha;72331][quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.[/quote] It hard for me to export using the xml export format because i have almost 6000 users. Is there other way to import the users? using csv is better approach but I just can import until 1125 users until the error come out "Failed to import: Input array is longer than the number of columns in this table". [/quote] Without seeing the data i can help you. If your data is incorrect you need to correct it. i would guess that there is a comma to much in row 1125 of your csv data. Remove the line that causes the error and then try to import again!

Posted by: tha_watcha - Wednesday, 8 January 2020 12:22:58

[quote=nazihaizzati;72334][quote=tha_watcha;72331][quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.[/quote] It hard for me to export using the xml export format because i have almost 6000 users. Is there other way to import the users? using csv is better approach but I just can import until 1125 users until the error come out "Failed to import: Input array is longer than the number of columns in this table". [/quote] Without seeing the data i can help you. If your data is incorrect you need to correct it. i would guess that there is a comma to much in row 1125 of your csv data. Remove the line that causes the error and then try to import again!

Posted by: nazihaizzati - Thursday, 9 January 2020 01:59:35
[quote=tha_watcha;72335][quote=nazihaizzati;72334][quote=tha_watcha;72331][quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.[/quote] It hard for me to export using the xml export format because i have almost 6000 users. Is there other way to import the users? using csv is better approach but I just can import until 1125 users until the error come out "Failed to import: Input array is longer than the number of columns in this table". [/quote] Without seeing the data i can help you. If your data is incorrect you need to correct it. i would guess that there is a comma to much in row 1125 of your csv data. Remove the line that causes the error and then try to import again! [/quote] The only data that I want to import is username, display name and email. As I checking my csv seperate comma file doesn't have extra comma. Meaning in my database right now I have 1125 users data. Then I try to import 2 users data using the csv separate comma format, that how the error coming. previously, I can import 500 users data using the same csv separate format and no error at all.

Posted by: nazihaizzati - Thursday, 9 January 2020 01:59:35

[quote=tha_watcha;72335][quote=nazihaizzati;72334][quote=tha_watcha;72331][quote=nazihaizzati;72330]I trying import using xml format as u suggestions but its also error. Failed to import: Import stream is not expected format[/quote] In that case your xml is not in the right format. If you click on export users you see the correct format.[/quote] It hard for me to export using the xml export format because i have almost 6000 users. Is there other way to import the users? using csv is better approach but I just can import until 1125 users until the error come out "Failed to import: Input array is longer than the number of columns in this table". [/quote] Without seeing the data i can help you. If your data is incorrect you need to correct it. i would guess that there is a comma to much in row 1125 of your csv data. Remove the line that causes the error and then try to import again! [/quote] The only data that I want to import is username, display name and email. As I checking my csv seperate comma file doesn't have extra comma. Meaning in my database right now I have 1125 users data. Then I try to import 2 users data using the csv separate comma format, that how the error coming. previously, I can import 500 users data using the same csv separate format and no error at all.

Posted by: tha_watcha - Thursday, 9 January 2020 16:48:51
As i write before. check the import data. Without seeing the data your trying to import i can't help you

Important Information: