nazihaizzati
2020-01-06T05:11:36Z
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?
Sponsor
2020-01-06T12:04:39Z
Originally Posted by: nazihaizzati 

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?



1. Will be fixed in 2.30.6 you can see the changes here... https://github.com/YAFNE...ae0350186a2286f7664d22d1 

2. which format? with xml it should work

UserPostedImage
nazihaizzati
2020-01-07T00:43:29Z
Originally Posted by: tha_watcha 

Originally Posted by: nazihaizzati 

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?



1. Will be fixed in 2.30.6 you can see the changes here... https://github.com/YAFNE...ae0350186a2286f7664d22d1 

2. which format? with xml it should work


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.

nazihaizzati
2020-01-07T01:16:23Z
I trying import using xml format as u suggestions but its also error.

Failed to import: Import stream is not expected format
2020-01-07T08:32:37Z
Originally Posted by: nazihaizzati 

I trying import using xml format as u suggestions but its also error.

Failed to import: Import stream is not expected format



In that case your xml is not in the right format. If you click on export users you see the correct format.
UserPostedImage
2020-01-07T08:33:49Z
Originally Posted by: nazihaizzati 

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.



Are you getting duplicate users? This issue is hard to reproduce without the data. This will take some time to test.

UserPostedImage
nazihaizzati
2020-01-08T09:33:44Z
Originally Posted by: tha_watcha 

Originally Posted by: nazihaizzati 

I trying import using xml format as u suggestions but its also error.

Failed to import: Import stream is not expected format



In that case your xml is not in the right format. If you click on export users you see the correct format.



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".

2020-01-08T11:22:58Z
Originally Posted by: nazihaizzati 

Originally Posted by: tha_watcha 

Originally Posted by: nazihaizzati 

I trying import using xml format as u suggestions but its also error.

Failed to import: Import stream is not expected format



In that case your xml is not in the right format. If you click on export users you see the correct format.



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".



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!
UserPostedImage
nazihaizzati
2020-01-09T00:59:35Z
Originally Posted by: tha_watcha 

Originally Posted by: nazihaizzati 

Originally Posted by: tha_watcha 

Originally Posted by: nazihaizzati 

I trying import using xml format as u suggestions but its also error.

Failed to import: Import stream is not expected format



In that case your xml is not in the right format. If you click on export users you see the correct format.



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".



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!



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.
2020-01-09T15:48:51Z
As i write before. check the import data. Without seeing the data your trying to import i can't help you
UserPostedImage

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved