CSV Table Sort (Free) WWB8.2+

In this section you can share self-made extensions with other users of WYSIWYG Web Builder.

There are already more than 250 extensions available!
User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

CSV Table Sort (Free) WWB8.2+

Post by Adendum » Sun Jul 22, 2012 5:38 pm

A PHP and jQuery utility to convert a comma delimited CSV file into a standard HTML table with sorting and formatting options.

Requires your page to be PHP (therefore a server supporting PHP) and comma delimited CSV files. Built using EB4 and therefore only works with WWB8.2.1.

Demo using three tables on a page.

Please read the help file for full set up requirements and instructions on property syntax.

And a big thank you goes out to Jordan and Pascal (Crochepattes) for getting me over the last hurdle. :)
Last edited by Adendum on Fri Feb 27, 2015 3:54 pm, edited 2 times in total.
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
FX3D
 
 
Posts: 61
Joined: Sat Dec 17, 2011 5:52 pm

Re: CSV Table Sort (Free)

Post by FX3D » Sun Jul 22, 2012 8:22 pm

AWESOME work Adendum, maybe Naval can use this for an updated webshop ;) :P

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free)

Post by Adendum » Sun Jul 22, 2012 8:38 pm

FX3D

Thanks. I'm sure there will be a few users that will gain some benefit from this extension. No idea how or why Naval would want to incorporate this into his Webshop but he is more than welcome to take my Extension Builder file.
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
FX3D
 
 
Posts: 61
Joined: Sat Dec 17, 2011 5:52 pm

Re: CSV Table Sort (Free)

Post by FX3D » Mon Jul 23, 2012 3:39 pm

Just thinking of a product sort in the back end ? maybe I am asking for too much ;) :P

jordan
 
 
Posts: 838
Joined: Tue Jun 26, 2007 1:56 pm
Contact:

Re: CSV Table Sort (Free)

Post by jordan » Mon Jul 23, 2012 4:33 pm

yep yep rabbit outta hat, cuffed and tagged!
like a free script with a six digit number lock . :mrgreen: . goOd you finished it anyway Paul
+ of course TNX for your index update mail

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free)

Post by Adendum » Mon Jul 23, 2012 4:36 pm

lol
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free) ** UPDATED **

Post by Adendum » Wed Jul 25, 2012 2:53 pm

25/07/12 : Updated to allow use of CSV files already on the server, such as FORM data CSV files (as long as they are comma delimited).

I have noted several users trying to view form data with the data viewer extension and not having much luck so I have amended this extension to give users the option of uploading a local CSV file or to use an existing CSV file that is already on the server.

A local file is always uploaded to the /csvtablesort/data/ folder but as an existing CSV file could be anywhere on the server you will need to enter a relative location. The default setting provided is ././formdata.csv which assumes your CSV file (formdata.csv) is in the root folder.

I have tested this using one of my own forms (uses DBTS Forms Processor) and the results were successful.
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free) ** UPDATED **

Post by Adendum » Thu Jul 26, 2012 1:52 pm

26/07/12 : Updated to allow styling to the header font (family and colour)

Live example.
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
FX3D
 
 
Posts: 61
Joined: Sat Dec 17, 2011 5:52 pm

Re: CSV Table Sort (Free)

Post by FX3D » Thu Jul 26, 2012 5:15 pm

Adendum wrote:26/07/12 : Updated to allow styling to the header font (family and colour)

Live example.
Good work this extension just keeps getting better :D and FREE :P

thnx again

FX

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free)

Post by Adendum » Thu Jul 26, 2012 6:09 pm

Free but I am happy to take donations (added the feature a couple of weeks ago)!! :)
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free)

Post by Adendum » Mon Jul 30, 2012 6:46 pm

Keith,

If there is a way to get a hyperlink into a CSV file I haven't found one. I've tried lots of different methods but nothing sticks. The only thing I can think of (someone else may have some ideas) is to place a graphic or image map at the right hand side of the table and link from those.
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free)

Post by Adendum » Sat Aug 04, 2012 1:17 pm

Adendum wrote:If there is a way to get a hyperlink into a CSV file I haven't found one. I've tried lots of different methods but nothing sticks. The only thing I can think of (someone else may have some ideas) is to place a graphic or image map at the right hand side of the table and link from those.
Ta Da!!!!!!!!

I just worked out how to make a link in a CSV file that translates when using CSV Tablesort (previous attempts had too few or too many " marks). If you visit the demo page and scroll down to the third table with Formula 1 data and skip to the last record you will see that the Lotus Renault team for Karun Chandhok is now a hyperlink to the Lotus Renault F1 team site.

The syntax used in the CSV file is :-

"28 ","Karun Chandhok ","Indian ",<a title="Lotus Renault" target="_blank" href="http://www.lotusf1team.com">Lotus Renault</a>,0
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

dsl225
 
 
Posts: 33
Joined: Sun Feb 06, 2011 12:10 pm

Re: CSV Table Sort (Free) WWB8.2+

Post by dsl225 » Thu Nov 01, 2012 1:26 am

Thanks for this, but I really can't replace commas by semi-colons in texts!
Hope you'll find a solution anytime soon because the extension is really worth.

jrudasill
 
 
Posts: 32
Joined: Tue Oct 20, 2015 8:29 pm

Re: CSV Table Sort (Free) WWB8.2+

Post by jrudasill » Wed Feb 03, 2016 6:29 pm

I've installed this extension from Adendum and have created a table from a csv file. The table displays, but I don't see any of the sort arrows to the right side in each of the headers. Also I think there should be some way to set the number of rows to display initially, which I assumed would be dictated by the first number of items in the page box at the end of the table.

Here is a link to the page that I created that shows the issue: http://www.pcsiwebsite.com/page4.php

Any assistance with this extension would be greatly appreciated.

Thanks,
John

*** This extension is provided by Adendum and not Pablo Software Solutions*** (Baconfries)
Last edited by BaconFries on Wed Feb 03, 2016 6:38 pm, edited 2 times in total.
Reason: Post modified to show correct developer of the extension

User avatar
Adendum
 
 
Posts: 743
Joined: Fri Apr 22, 2011 4:50 pm
Location: London, UK
Contact:

Re: CSV Table Sort (Free) WWB8.2+

Post by Adendum » Wed Feb 03, 2016 7:00 pm

John,

Sort Arrows will appear if [a] you selected a sortable option n the settings and you upload everything created by the extension - I'd suggest a local publish first - to a XAMPP or WAMP set up.

You can set the number of rows seen by editing 04-Paging
Aditerum - No longer supporting WWB extensions - refer to CJS.
Aditerum - No longer supporting WWB templates - refer to CJS.


WWB 9.4; Ext Builder 4.2; Windows 10 64bit; Intel Core i7-3770 Processor 3.40Ghz; 16.0Gb RAM
Death to Internet Explorer!

Post Reply