Documentation
How to upgrade from version 1.2 to version 2.0 without losing data - METHOD 2
Written by Hristo Genev Tuesday, 01 December 2009 13:20
The second method (whichВ I find easier) is also devided into 3 steps. It does not include any file deletion, but you will have to do some database manipulations. We are going to copy apoll 1.2 table and convert it into a apoll 2.0 compatible one. Then we are going to do a normal uninstall/install.
Requirements:
- Installed Apoll 1.2
- Access to your database via phpMyAdmin or other tool for database administration.
- Downloaded Apoll version 2.0
Step 1: BACKUP! BACKUP! BACKUP! Backing up your site database is very important in case something goes wrong;
Step 2: For this example we're going to use phpMyAdmin;
1.1 Download this sql script file;
1.2 Find out what is the prefix of your database. By default Joomla uses the 'har_' prefix, but it could be any other. If your db prefix is 'har_' you may skip the next step;
1.3 If your database prefix is not 'har_', open the downloaded file - upgrade-to-2-0.zip, extract it and open it using any text editor. Replace each occurrence of 'har_' with the prefix of your database. Save it as a *.sql file;
1.4 Go to phpMyAdmin - Import and browse for the file upgrade-to-2-0.sql which you just saved. When you find select it and hit "Go".
The script should create Apoll 2.0 database fields and import old polls. If you get "Import has been successfully finished, 8 queries executed." that means that everything was ok. Your apoll database is copied and ready to use by the new version of the component.
Step 3: Uninstall Apoll 1.2 the way you normally uninstall components and install Apoll v. 2.0;
How to upgrade from version 1.2 to version 2.0 without losing data METHOD 1
Written by Hristo Genev Monday, 30 November 2009 14:46
If you want to make and upgrade from Apoll version 1.2 to 2.0 without loosing your created polls, you must do a little more work than usually. It's easy and it should not take you more than 3 minutes.
Both versions have significant changes in database schema, that's why they are not compatible, and uploading the new files over the old ones won't do the job.
Fortunately we have included a script which will import the polls from the 1.2 database tables and recreate them for use in the v. 2.0. The execution of the script will be triggered when you try to install v. 2.0, but only if it finds database tables left from Apoll 1.2. In other words you need to get rid of Apoll 1.2, without dropping its database tables. The normal component uninstall process will delete the Apoll 1.2 files, and will also drop the Apoll database tables, so we are not going to do a regular uninstall. We'll just delete all Apoll files and install version 2.0. Then the script will take care of everything else.
So here is the process in 3 steps. First we are going to make a backup!!! Then we are going to delete some old files, and last we are going to install the new component.
Requirements:
Apoll v. 1.2 installed on your joomla site.
Access to your files via ftp client, web file manager or etc.
Version 2.0 of Apoll downloaded
Step 1 - The backup:
1.1: BACKUP your database. (If you have a database backup, and you don't like the end result you can always go back)
1.2: BACKUP your site. (Its very important to backup all your files, since we are going to delete some. You don't wanna have that strange look if you accidentally delete something else.)
Step 2 - The deletion (Total: 2 folders and 11 files):
2.1: Make sure you delete the following 2 folders (with all files being inside):
your_site/administrator/components/com_apoll
your_site/components/com_apoll
and the following files:
2.2: 2 files from the administrator/languages/en-GB folder:
your_site/administrator/language/en-GB/en-GB.com_apoll.ini
your_site/administrator/language/en-GB/en-GB.com_apoll.menu.ini
2.3: 1 file from the your_site/language/en-GB folder:
your_site/language/en-GB/en-GB.com_apoll.ini
2.4: 4 files from the your_site/media/system/js folder:
2.5: your_site/media/system/js/jquery.colorpicker.js
2.6: your_site/media/system/js/jquery.js
2.7: your_site/media/system/js/jquery.tablednd.js
2.8: your_site/media/system/js/reorder.js
2.9: 3 files from your_site/media/system/images folder:
your_site/media/system/images/add.png
your_site/media/system/images/remove.png
your_site/media/system/images/apoll-arrow.gif
2.10: 1 file from media/system/swf folder:
your_site/media/system/swf/open-flash-chart.swf
Step 3: The installation
Download Apoll version 2.0 and install it the way you normally install components. If you have deleted all the files from the old component you should get no errors and see the congratulation message "Apoll component 2.0 successfully installed", together with messages for the successful import of the old datase.
FAQ
HELP! I get an error "JInstaller::install: There is already a folder called ..." - this undoubtedly means that you have not deleted all files mentioned in the list above, and some of them are not replaced by the new ones. No problem, uninstall Apoll 2.0 (you will not loose your created polls, because the database will not be dropped by default) and install it again.
Should you have any questions don't hasitate to use the forum.
How to install Apoll
Written by Hristo Genev Saturday, 14 March 2009 08:35
Apoll component installation is an easy job. Just download the necessary files from here - the component and the module and install it through the joomla installer. Make sure you have installed a flash player plugin for you browser and your site is running on a PHP version 5.2.8, MySQL version 5.0 (Not checked, maybe it works on earlier versions of PHP/MySQL - homework for me)
After the successful installation of both component and module go to
- Components -> Apoll and create your new Poll. Make ajustments to the parameters. Don't forget to publish it.В
- Extensions -> Module Manager -> Apoll Module; Choose the poll you'd like to display and publish it in the desired position.
- Optionally you can make a new menu link pointing to a certain poll or to the list of active polls (default view).
What is Apoll?
Written by Hristo Genev Tuesday, 10 March 2009 09:18
Apoll is a component and module for Jommla 1.5, that displays the vote results as an animated pie chart. (Click here to view the demo). Basically it is an upgrade of the joomla default poll component. Here are some of the enhancements that Apoll has to offer:
Back end enhancements:
- drag and drop reordering of the poll options;
- choose how to display the results - with a pie chart flash graphic or the joomla default way;
- assigns color to each option /works even if you choose to display the results with the joomla default way);
- defining parameters (pie width, pie height, color of slices);
- show background logo or image under the flash pie chart
Front end enhancements:
- view pie results as animated pie chart or as joomla default way;
- view all published polls in a table, with number of options and voters for each one;
- sort the polls by name, voters or number of options
Module enhancements:
- Does not show poll options if you have already voted (according to the lag setting);
Of course the future development of this project will continue. Here are some of the planned /to-be-developed/ features.В
Future enhancements:
- Ajax-based voting module;
Apoll component files
Written by Hristo Genev Friday, 27 February 2009 14:11
In order to do its job in the backend Apoll voting component uses - JQuery javascript library and its TableDnD plugin. During installation the files jquery.js, jquery.tablednd.js and reorder.js are extraxted to the media/system/js folder.
For drawing the flash pie chart Apoll voting component usesВ Open Flash Chart. http://teethgrinder.co.uk/open-flash-chart/
Version 1.0 consist of 25 files and directories.
jQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript.
The TableDnD plugin allows the user to reorder rows within a table, for example if they represent an ordered list (tasks by priority for example). Individual rows can be marked as non-draggable and/or non-droppable (so other rows can’t be dropped onto them). Rows can have as many cells as necessary and the cells can contain form elements.
Do you like it?
If you like this component please support it with a small donation and keep it allive.
aPoll
Powered by Mpire
We host at:
