close panorama

Excel 2 krpano xml
by Arthur van den Enk - virtualtuur@gmail.com

Description

Not really a plugin. I would call it an Add-On, or extention.
With this script you can use excel to control your tour data. There are 2 different versions.

1. The first version i would call 'vars'. It uses just 2 columns per sheet. The first column holds the variable name and the second column the variable value. You can build your own cms now.
A small example would be: Call the sheet colors. Give the first column a variable name like: bg. Give the second column a value, for example: ff0000 or 0xff0000. Now you can call from your code for example, <layer name="controlbar" ... bgcolor="calc:'0x'+colors.bg" ..
(colors.bg = sheetname.variablename)
You could use the other columns to add some comments about the variable if you like.

Of course you can do this also with text (could be very conveniant, also for the client), sizes, settings, etc etc



The 'output' of the script is like:

<colors
      bg="ff0000"
      border="ffff00"
      etc etc
/>
Similar like the 'skin_settings' in the 'default' krpano interface.



2. The second version is the array version. Here you can put a whole line of variables that belong together. For example appartments.



Now these values are available like: specs.status_1 etc.. The value is sold in this case.

The 'output' of the script is like:

<specs
     type_1="large" size_1="300" price_1="500.000,-" lot_nr_1="1a-L" status_1="sold"
     type_2="medium" size_2="200" price_2="400.000,-" lot_nr_2="2" status_2="free"
     type_3="small" size_3="100" price_3="295.000,-" lot_nr_3="3" status_3="option"
/>

It is possible to use both versions together in the same tour.
In quite some cases i find it very conveniant to use to make things more visible, also for the client.

Details

The package works with php 5 and with php 7.
Offline you should use a local server to make it work, like MAMP. Online you need php 5 / 7 support on your domain.

For conveniance a little upload script is included. You could put that online as well and let a client go there and let him upload the changed excel file to the right location.

The package will be licensed to your Krpano license. You need to fill-in this info during the ordering process. When you order/buy the package you get the 3 simple examples. Within 48 hours, or at least as soon as possible i will send you the missing files/folder, most often with 'Wetransfer'.

Buy the Excel 2 Krpano xml HERE:
Make sure you don't select the Backup CD or Extended download options!!!
The price is €39,- exclusive VAT/taxes and costs. That means that the full price depends on in which country you live.







Disclaimer

This plugin/add-on is offered as a commercial plugin. It is provided "As Is" without warranty of any kind, either express or implied, including any warranty of quality, merchantability, or fitness for a particular purpose. In no event will the author of the plugin be liable for loss of data, costs of procurement of substitute goods or services or any special, consequential or incidental damages, under any cause of action and regardless of whether or not the plugin author have been advised of the possibility of such damage. This limitation will apply notwithstanding any failure of essential purpose of any limited remedy provided herein. In any event the plugin author will have no liability arising out of this agreement.