11
rossweb
Re: members list db transfer
  • 2004/12/1 11:54

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Hi ajaxbr, thanks, interesting thread, I dumped my pn users and XOOPS users tables as excel csv files, loaded both into excel, cut and pasted the pn data into the XOOPS file under the relevant heading, padded out the missing data in the XOOPS file with copies of what was under the heading, saved as "xoops.csv". Opened that file in "crimson editor" and trimmed out the excess ","s put in by excel and ran it in my XOOPS db.
This might help someone else (if they can understand it )



12
rossweb
Re: members list db transfer
  • 2004/12/1 11:28

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Mikeh - spot on! I made a csv file in excel with "linkid" increasing by 1, "groupid" = 2 (members), and "uid" = members uid from "xoops_users", trimmed out the excess commas put in by excel, ran it in the db and Bingo, all users appeared in the "groups > users" at the bottom.
Many thanks for your help guys.



13
rossweb
Re: members list db transfer
  • 2004/12/1 9:32

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Thanks ajuden, they don't appear there, trying to figure out where to go from here.
This thread seems to be duplicated - can we use the other one please.



14
rossweb
Re: members list db transfer
  • 2004/12/1 9:27

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


No, they don't appear, only the ones I added through the "add user" page are there. Any idea on where to go from here please.

PS to list admin - This thread seems to be duplicated, can the replies be combined?



15
rossweb
members list db transfer
  • 2004/11/30 19:21

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Here's another for you guys 'n gals - I'm changing from postnuke to XOOPS and have manually transfered all my users from the pn database to the XOOPS one. All users show in my list of users with all the correct details, but whenever a user goes to log in they get the "thanks for looging in" page and the front page comes up with only the header - no menus, nothing! However, if I add the user using the same details through the "add user", it all works! Have I missed something in the user db? is there a flag somewhere that shows if a user has been entered through the site?



16
rossweb
members list db transfer
  • 2004/11/30 19:19

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Here's another for you guys 'n gals - I'm changing from postnuke to XOOPS and have manually transfered all my users from the pn database to the XOOPS one. All users show in my list of users with all the correct details, but whenever a user goes to log in they get the "thanks for looging in" page and the front page comes up with only the header - no menus, nothing! However, if I add the user using the same details through the "add user", it all works! Have I missed something in the user db? is there a flag somewhere that shows if a user has been entered through the site?



17
rossweb
Re: edit user page
  • 2004/11/30 19:11

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Thanks, but I can't find any reference to signature in that file????????



18
rossweb
edit user page
  • 2004/11/30 15:30

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Can anyone tell me how to remove the "Signature" box and caption and the "notification method" box and caption from user info, also which files need "doctored"?

Thanks



19
rossweb
Menu items arrangement
  • 2004/11/15 13:30

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Can anyone tell me why my menu lists have suddenly decided to go from a neat vertical arrangement to being one after the other horizontally? I went to my test site this morning and there it was, nothing had been un/installed, altered from when I was last there........weird.

Thanks



20
rossweb
Re:Cookies
  • 2004/11/15 13:18

  • rossweb

  • Just popping in

  • Posts: 22

  • Since: 2004/10/30


Many thanks, I think this'll do nicely.




TopTop
« 1 (2) 3 »



Login

Who's Online

123 user(s) are online (92 user(s) are browsing Support Forums)


Members: 0


Guests: 123


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: May 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits