Uncategorized

Joomla
Joomla
,
Magento
Magento
,
XLSJuice
XLSJuice

Table Manager quick guide

With this link you can download the quick guide of Table Manager extension.    Quick guide   This guide will give you an overview of the main functions, please check further... Continue reading

CalcBuider Quick Guide

With this link you can download the quick guide of CalcBuilder extension.    Quick guide   This guide will give you an overview of the main functions, please check further... Continue reading

List Manager Quick Guide

With this link you can download the quick guide of List Manager extension.    Quick guide   This guide will give you an overview of the main functions, please check further... Continue reading

XSLPrice - Magento - Quick guide

Moonsoft XLSPrice Calculator - Overview  Show dynamic pricing for your products configured using an excel file. You will have available for creating your calculations all user inputs for the... Continue reading

Configuring the excel sheet

Once you have your Magento products created with your preferred custom fields added, it's time to configure the calculator using an excel sheet. The rules are simple: You will have the... Continue reading

First steps: Installation

First of all you must install package. It will install component, modules and plugin. Troubleshooting: Failed to load this file in server This new version of the extension contains a heavy... Continue reading

First steps:Simple Calculator

In order to build a calculator, you need to follow these simple steps: - Configure your input fields - Create your input form - Write down your calculations - Create your output/result section -... Continue reading

First steps: Field types

For our first example we have used the most common field type to be handled in a calculator, the numeric type. But you can include several other types at your input form as well. These are all field... Continue reading

Building a tabbed form

The module loads by default a library used to create tabs in an easy way. To create a form with several tabs user can navigate, you only have to configure a custom layout using a naming convention to... Continue reading

Preferences, export and email options (+ Mailchimp integration)

You can configure the following parameters for each of your calculators: Hide calculate button: enable this option to hide the default calculate button. Each time an input field is changed, the... Continue reading

Statistics

At statistics section you will find different charts created with data used at the calculators on your site. You will find the number of requests your calculators are receiving, the distribution... Continue reading

Matrix

Sometimes you may need to store some auxiliary data that you need to use at your code section. You can store data in form of tables (matrix) that you can recover at any point of your calculation. In... Continue reading

Sections

A section is a part of the form that we want the user to add several times with the same structure. Each section contains its own layout and set of fields included. To configure a new section go... Continue reading

Using scripts

If you need to include any kind of script at your form, to perform dynamic actions, you can enter your script at javascript events tab. There you can place any javascript code needed, with different... Continue reading

Calcbuilder extended: How to build your calculator from Excel

If you already have an excel with all your formulas of your calculator and you need to convert it to a working form on your site, you can use the excel mapping function of CalcBuilder extended... Continue reading

Code tip: Add custom validation to form fields

Simple validations (required fields, max and min values for a numeric input..) can be configured at your input field properties, the form will add the needed validation functions and messages. You... Continue reading

Calcbuilder extended: HikaShop integration

In order to link the results of your calculator with hika shop cart you only need to add some extra lines at the end of your calculator code: //Modify these parameters according to your product... Continue reading

Calcbuilder extended: Virtuemart integration

If you want to use your calculator results to calculate prices and/or quantities of your VirtueMart products before adding them to the cart, you need to configure the VirtueMart options tab. · Use... Continue reading

First steps - Installation

First of all you must install package. It will install component, modules and plugin. Troubleshooting: Failed to load this file in server This new version of the extension contains a heavy... Continue reading

First steps:Create List

You can create a new list in several ways: Using the 'new' button of the toolbar in order to configure a new list from scratch. Selecting one of your existing lists and using 'copy' option. This... Continue reading

How to create the fields(columns) of your list

After selecting a title for your list and a general description you can access the 'fields' tab in order to configure your columns. Click 'Add Field' for each of the columns you need to add to your... Continue reading

Configuring the acl (permissions) table

Click 'configure access control' option of your list in order to access to this page: Here you can configure access rights for joomla groups to the list. You can check if the different groups... Continue reading

Access configuration to manage general settings of the list

Configuration option will allow you to configure general parameters over several tabs: Main config - Save historic access: Enables/disables the saving of the user actions over your list that... Continue reading

Configuring layouts

Form layout: This layout is the one that will be shown containing the form you want to use for add/edit records from the front end. You can freely create your form with the html editor, using... Continue reading

Loading records

You have several ways to load records to your recently created list. You have the option to introduce data manually (from the backend or from the front-end form), or, load a set of existing records... Continue reading

How to publish your list

Next step is to create a list manager module or a menu component that will work as frontend management. Go to Module Manager and create a new Module of type 'List Manager'. If you want to add a new... Continue reading

Using Views

In addition to the default configuration of your list, you can also create views from it. A view is based on the same list, but with some changes from the default configuration. This allows you... Continue reading

Historic access

With this option you can check the log of actions made by your users at front-end. You can filter the information by action, user, or free text. Selecting one of the actions and pressing 'View'... Continue reading

Copy list/backup

Using 'Export List (backup)' option you can download a file (.xml) containing a backup of your list (structure and data) that you can store and keep in case you need to recover, make a duplicate of... Continue reading

Export data

Once your records are properly loaded inside your list, you may want to make a copy of your data, and/or allow your users to export and store the information, so you have several options to achieve... Continue reading

Enabling Bulk updates

When one or more fields are marked as suitable for bulk update (fields configuration) and the user accessing the list has permission to use this option (acl), each row can be selected using a... Continue reading

Translations

List manager uses default joomla language files system. It will load the language selected for front or backend according to your joomla main configuration. If you have your site configured for... Continue reading

Advanced modules (form/filter/search/compare)

Form module This module allows you to display an input form in order to add new records to any list from any other page of your website. Just configure the module selecting the destination list... Continue reading

Installation-troubleshooting

First of all you must install the component at your joomla backend. Troubleshooting: Failed to load this file in server This new version of the extension contains a heavy library, regarding... Continue reading

Table Manager: basic steps

The first backend view when you access Table Manager menu link is the existing list of names and their associated tables. You can use the first options to manage data from your database... Continue reading

Creating/Managing tables of your database

If you have already your database tables created, you can skip this step. Please note you can also create your database tables from any other database manager, Table Manager will be able to handle... Continue reading

Creating table manager

Once you have available your database tables, you can link your new tables (or previously existing ones) to lists ready to be shown and managed from the front-end. Click 'New' to manage a database... Continue reading

Configuration

You have available different tabs with several configuration parameters. Pager: This tab configures the front-end pagination of your data. Set how many options you want to see at the 'show'... Continue reading

Publishing the component

This is a basic step, just create a new menu item and select component table manager as its type, setting the list required at the basic parameters tab and you will have your front-end manager ready... Continue reading

Front end management

Your data table will be shown according to your back-end configuration. Users can use the tool bar and filters to search inside the records, use the pager to navigate through the record set,... Continue reading

Video Tutorials

This is a set of video tutorials showing how to build calculators using Calcbuilder and Calcbuilder extended. Build a calculator from excel-(CB extended) First... Continue reading

Use case: Create links dynamically using calculated column

At this tutorial we'll show how to configure a calculated column to create a working link to an url that is stored at that field. As a first step, we'll create a new database table that will... Continue reading

Calcbuilder extended: Price/qty calculator integrated in Hikashop product/use of CBPlugin

We are going to configure Calcbuilder extended to work inside a Hikashop product page. The input form for this case will be the one built with Hikashop custom fields, the calculator will use these... Continue reading

Calcbuilder extended:calculator integrated in Hikashop product:using and saving product parameters

Following with our last post which showed how to integrate a calculator inside a Hikashop product page using the CB Price Calculator plugin, this tutorial will explain how you can access to the... Continue reading

Working with sections: inputs and inline results

We're going to work with sections, which is a feature that allows users to add 'rows' of inputs/outputs dynamically to your form, we'll explain how to get the inputs from inside these sections so you... Continue reading

Calcbuilder extended + Virtuemart integration:calculator inside product page/use of CBforVM plugin

You can use your calculators to configure complex calculations for price depending on your product custom fields. We'll build an example of one product with two comboboxes, the combination of the... Continue reading

Code tip: Adding a google address field

With this code tip we'll show you how to transform a default text input field into a google helper field that will search valid addresses and show options while users are typing, as if they were... Continue reading

Code tip: Adding a google reCAPTCHA to your form

The calcbuilder form already includes an invisible spam filter to avoid robots from sending your calculator forms, but if you want to increase security you may want to add a google reCAPTCHA field.... Continue reading

Code tip: accesing Joomla user data

Sometimes our calculators are only available for logged in users. It's a good idea to show at the calculator form or results some data that we have already available, instead of asking again user... Continue reading

Code tip: Working with dates, sum 30 days, 10 working days ...

When you build quote calculators you may need to show automatically some dates relative to the date the calculator is executed. We'll learn how to use the JFactory Date class in order to get... Continue reading

Our clients' feedback