Multi upload site/links

Discussion in 'General Help' started by softdevsalon, Feb 8, 2019.

  1. softdevsalon
    • Licensed

    softdevsalon Member

    Hi admin, I just want to ask if I can upload many links or sites?
    Example, I have a links in csv file and inside are links and category , I want to put it or upload it in bulk. Can I do it? do we have a functionality like that?

    If I need to do it manually , how to do it?

    Thank you.
    cajkan likes this.
  2. cajkan
    • Licensed

    cajkan Active Member

    Hello there, best would be to use PHP and then insert all data into database.

    I'm sure @Basti or @Mark can do this for you, if you get stuck I can do it not a big deal.
  3. softdevsalon
    • Licensed

    softdevsalon Member

    How to do it?
  4. Basti
    • Staff

    Basti Administrator Staff Member

    If you have a csv, you can import directly into phpmyadmin

    1) First off, to make sure nothing gets broken, copy the VL_sites table
    - To do so, you click on VL_sites table and click the Operations tab
    - In there you have an option to copy the table. Name it whatever, its just to test the hole thing

    2) On the test table, click the tab Import
    - Select your csv file
    - In there you see a select dropdown with format, select CSV
    - In the part which shows up after selecting, make sure the inputs match your structure in your csv. Define separators, columns etc

    3) That's about it. So make sure it works in the test table. Once it does, do the same on the real table and delete the test one

    4) Copy your csv file delete anything but the username
    - import this into VL_stats
  5. softdevsalon
    • Licensed

    softdevsalon Member

    In my csv I have only two columns, links and category? Is it ok?
  6. Basti
    • Staff

    Basti Administrator Staff Member

    No, you need more than that.

    username - is used to query user data, so absolute must have. Used practically everywhere
    owner - same value as username. Used for security inside user panel
    password - you could use the same on all if you wish
    title - also absolute must have
    url - you already have
    short_url - is the same as url but without www. and no trailing slash or anything after it, so just scheme and domain. This is needed to prevent double url signups later on.
    email - required
    join_date - could use default string today in format YYYY-MM-DD h:i:s ( eg. 2019-02-09 19:00:00 )
    banner_url - use your default banner as in button_config.php
  7. softdevsalon
    • Licensed

    softdevsalon Member

    Ok let me try doing this. I will update this thread if I have concerns. Thank you.

Share This Page