YAFLogo

nazihaizzati
4 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: 4.0.0 rc 2
4 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?

Originally Posted by: nazihaizzati 

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

2. which format? with xml it should work

nazihaizzati
4 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?

Originally Posted by: tha_watcha 

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

2. which format? with xml it should work

Originally Posted by: nazihaizzati 

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
4 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: 4.0.0 rc 2
4 years ago

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

Failed to import: Import stream is not expected format

Originally Posted by: nazihaizzati 

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: 4.0.0 rc 2
4 years ago

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.

Originally Posted by: nazihaizzati 

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

nazihaizzati
4 years ago

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

Failed to import: Import stream is not expected format

Originally Posted by: tha_watcha 

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

Originally Posted by: nazihaizzati 

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: 4.0.0 rc 2
4 years ago

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

Failed to import: Import stream is not expected format

Originally Posted by: nazihaizzati 

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

Originally Posted by: tha_watcha 

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

Originally Posted by: nazihaizzati 

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
4 years ago

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

Failed to import: Import stream is not expected format

Originally Posted by: tha_watcha 

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

Originally Posted by: nazihaizzati 

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

Originally Posted by: tha_watcha 

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!

Originally Posted by: nazihaizzati 

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: 4.0.0 rc 2
4 years ago
As i write before. check the import data. Without seeing the data your trying to import i can't help you