Giving individual clients access to only their listing after importing large database via CSV

Discussion in 'GeoCraft WordPress Theme' started by molatin, Feb 6, 2013.

  1. molatin

    molatin Member

    Joined:
    Aug 11, 2012
    Messages:
    558
    Likes Received:
    19
    I want to populate my directory via CSV import, which means there will be hundreds of listings added at once.

    I also want each business listed to check it's own listings entry and add their own images.

    How can I easily give them login access to only their own listing without having to do it one by one?

    I need to automate this....
     
  2. Nitesh

    Nitesh Support Staff

    Joined:
    Oct 19, 2012
    Messages:
    5,165
    Likes Received:
    160
    For this you need to create users account manually and send them login detail, Then check user id and add that id in the "post_author" and upload it.
    It will provide separate dashboard to user. Where user can see all his listings.

    Follow process given below to assign author id in csv file.

    [​IMG]

    [​IMG]

    [​IMG]
     
  3. aliounn

    aliounn Member

    Joined:
    Dec 7, 2012
    Messages:
    136
    Likes Received:
    6
    Hi Nitesh,

    Can we upload the CSV file first with the admin id ? after that create acounts and change listings author ?
    if yes , what is the admin id ? It dont appear at the left bottom of the screen.

    Thank you.
     
  4. aliounn

    aliounn Member

    Joined:
    Dec 7, 2012
    Messages:
    136
    Likes Received:
    6
    Hi Molatin,

    This is a good idea. how do you plan to contact your customers ? did you inform them before about your site ? are they free listings ?
    thanks
     
  5. molatin

    molatin Member

    Joined:
    Aug 11, 2012
    Messages:
    558
    Likes Received:
    19
    aliounn, I have a partner in this project who has a large database that we will import - potentially 5-10k listings.

    They will get a free listing for a month, then the option to pay - that is why I need the automated listings log in I asked for above.

    I really don't want to have to do any of this manually!!!

    Nitesh - thank you. There must be many other users who want this automated and there must be a way to do it somehow that is not complicated. What needs to happen to work out a bteer solution?
     
  6. tobyb

    tobyb Active Member

    Joined:
    Dec 28, 2011
    Messages:
    256
    Likes Received:
    31
    Location:
    World Wide
    I agree, this is a very important item in creating a new directory. Would there not be a way to go into the database tables and change the user id and passwords? yet this too would be a manual operation and take hours for a large listing base, preferably a designed csv file or other to upload into the database which would have several users new login details, after they were asked to create an account and forward details to the accounts as they claimed the business listing. This would still be quicker and should be possible to create such a file or form for programers.
     
  7. molatin

    molatin Member

    Joined:
    Aug 11, 2012
    Messages:
    558
    Likes Received:
    19
    I've been thinking about this....

    I'm not a programmer , but what if there was a way to generate random usernames & passwords for the CSV before upload which would then be linked to the URL created for a specific listing profile.

    That way, all the required date would be in the CSV
    - listing info (and also add the unique URL created for that listing)
    - username
    - password
    - contact email

    This info could then be extracted from the resulting CSV and used to email out each businesses listing URL, username & password...
     
  8. Nitesh

    Nitesh Support Staff

    Joined:
    Oct 19, 2012
    Messages:
    5,165
    Likes Received:
    160
    There is no automated way to create users in WordPress.
    You can follow any one process.

    First process
    Create user account. collect it's id (as shown in image posted above),
    Add that id in "post_author" field in csv and then upload that csv file.

    Second process
    Upload csv with same "post_author" (for example: 1)
    Then manually change author from dashboard.
    Check image for reference.

    [​IMG]
     

Share This Page