Multi upload site/links

[softdevsalon]

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]

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.

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.

 

[softdevsalon]

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.

How to do it?

 

[Basti]

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

 

[softdevsalon]

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

In my csv I have only two columns, links and category? Is it ok?

 

[Basti]

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 - https://passwordsgenerator.net/md5-hash-generator/ 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

 

[softdevsalon]

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 - https://passwordsgenerator.net/md5-hash-generator/ 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

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