YAFLogo

nazihaizzati
3 years ago
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

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
3 years ago
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?



https://github.com/YAFNET/YAFNET/commit/21f52e53ffb55adeae0350186a2286f7664d22d1 

2. which format? with xml it should work
nazihaizzati
3 years ago
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?



https://github.com/YAFNET/YAFNET/commit/21f52e53ffb55adeae0350186a2286f7664d22d1 

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
3 years ago
I trying import using xml format as u suggestions but its also error.

Failed to import: Import stream is not expected format
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
3 years ago
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.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
3 years ago
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.
nazihaizzati
3 years ago
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".

tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
3 years ago
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!
nazihaizzati
3 years ago
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.
tha_watcha
  • tha_watcha
  • 100% (Exalted)
  • YAF.NET Project Lead 🤴 YAF Version: 3.0.3
3 years ago
As i write before. check the import data. Without seeing the data your trying to import i can't help you
YAF Logo Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved
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