Pligg Support

Can i add category's in bulk
i need to add all the categories to make an perfect website listing directory on

can any one help me with it...

thanks ;)

Possible Answers

    I think you can but I suspect it might be just as much hard work. If you have phpmyadmin on your server then you can look at the structure of the MySQL database that powers your Pligg website. There is a table called pligg_categories, which holds all the details of the catergories that make up your website. If you create an excel file with one line entry (row) for each of your catergories and a column equivalent to each of the fields (columns) in the table, populate it with the relevant data, save the file as a csv file - hint don't include any commas in your catergory titles - then you can import the file into your pligg database using the import command. You should be able to work out some of the field contents fairly easy; for example the catergory_parent field by looking at the field contents for the records you already have. The are 2 fields; rgt and lft, which I think are to do with the sort order of the catergories in a dropdown menu list. I haven't worked out how these 2 fields work yet. You could try importing with these blank and see what happens then if the import doesn't work, just go back into phpmyadmin and delete the records (rows). If you haven't used phpMyAdmin before don't be put off by what you see, look at it logically and you will see the structure there. I'm guessing you've already customised some of the pligg code to get your site to the point where it currently is. You will just have to get your hands dirty.

    Good luck


    | Posted 797 days ago | Permalink | Hide Replies

Who Upvoted this Story's Support area is where you can ask questions and get answers. Just getting started with the Support area? This section describes tips for participating.

Submitting a Question or Comment

By taking a minute to research previous posts you may receive an answer much faster than waiting for a response to a new question. Begin by searching the support section for an answer. Sometimes you may even want to extend your search to the entire domain.

If you are unable to find a relevant answer, submit a new question or comment here. Please provide a detailed description and, when necessary, debugging information such as your server environment (a link to a <?php phypinfo(); ?> .php page would be very helpful), your web browser, and any steps necessary to reproduce your issue.

Submitting an Answer

If you have an answer or useful response that you would like to add to a post, you can submit it as a comment which other users will then vote on. Answers are sorted by most popular to least, allowing the best information to climb to the top of the page.

Please read and vote for existing answers before submitting your own, as there may already be an acceptable answer provided. You can use the "Reply" link found within an answer to submit a response to it, in case you want to expand or comment on someone else's contribution.

Including Files or Code

Sometimes it is necessary for you to attach a file or include a snippet of code for others to reference in your response. In most cases, you can .zip up files and attach them to a question or answer using Pligg's file manager. At times though this may fail, and in these circumstances we recommend using a third party host. Below we are including a list of recommended websites where you can share easily share file uploads (or snippets of code) through the web.