Geeklog Forums

I have created a tab delimited file. When I try to import, it is only importing the first line. If I delete the first line, and reimport, it then imports the next line.

I am on Geeklog 1.4.1, I do have the latest CAPTCHA but I disabled it and still the issue. I do not have custom registration enabled or configured.

Any ideas of what is going on? Perhaps a work around by manually creating a SQL script would also be a good work around for me for now.

---

--------------------
MuntadaNet, Inc.
Web Hosting

Could it be a problem with the line endings (DOS style vs. Unix style)?

User information will have to be written into several tables and some of that data depends on what's already in your database, so there's no easy way to create an SQL file to import.

bye, Dirk

I was thinking as much. I am doing this from my Mac. I built the file using MS Excel on Mac, tried modifying then with Word on Mac, and also tried with the Text Edit. Fortunately, I also have a Windows system to work on. I will try that.

---

--------------------
MuntadaNet, Inc.
Web Hosting

On my windows system, I am having success in part. I have a new issue. There is a username size limit. What is the best way to increase that. Should I do that through the field in the database or is there somewhere else I would have to lift the restriction. I am not necessarily concerned with the view size of any field for the username at the moment.

---

--------------------
MuntadaNet, Inc.
Web Hosting

You can make the tab delimited file just fine using your text editor. I was able to do this and have a working file run and input new user without a problem. If you hit the tab key on the keyboard once after each field and a simple line return at the end. Shouldn't have any problems. See code box.

That would be fine but I had way too many users to do that for. If I didn't have a windows machine, I think I may have resorted to using vi within the shell on the mac to get the format needed. Point is, a little bit too much humbug for a mac user to go through.

Also, for my other issue, I changed the username field in the database from something like 16 characters to 30 characters to accommodate the long usernames I had. I was then able to import easily. However, the form fields in the HTML will need some modification because they only accept a certain size. So I kind of need to know where to go to modify that.

---

--------------------
MuntadaNet, Inc.
Web Hosting

At a minimum you will need to modify these template files. Search the files for maxlength="16" and fix the number however you like. I doubt there is any code dependent on the max length of username but I could be wrong. You'll find out eventually.

public_html/layout/professional/admin/user/edituser.thtml
public_html/layout/professional/preferences/username.thtml
public_html/layout/professional/users/getpasswordform.thtml
public_html/layout/professional/users/loginform.thtml
public_html/layout/professional/users/newpasswordform.thtml
public_html/layout/professional/users/registrationform.thtml
system/memberdetail.thtml

Cool...That worked perfectly. Since I have a Linux server, I just used the following command to quickly replace the fields:

perl -p -i -e 's/maxlength="16"/maxlength="30"/g' *

---

--------------------
MuntadaNet, Inc.
Web Hosting