DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****

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
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****

Post by Navaldesign » Fri Sep 04, 2009 11:14 pm

DBTS CSV Manager Extension is DB Technosystems' third application for WB6 after the Webshop Plus and the DBTS Form Processor.

List Object Automatically Created table:

Image

View Object Automatically created table:

Image


Edit Object Automatically created form:

Image

Delete Object Automatically created form:

Image


The extension allows you to read data from any grid formatted file and will display them in your pages. It can read not only CSV's but also any other grid formatted file, even with the extension .php. So it can read and display files created by the WB6 built in form processor, by the WB6 Members Login System, by the WB6 guestbook, by the DBTS Form Processor, by Excel and by any other software that creates such (grid formatted) type of files.

It consists in the following extensions:
CSV List Object extension: allows you to display the file content in your pages.
CSV View Object extension: allows you to view the detailed page of a record
CSV Edit Object extension: allows you to edit a record
CSV Delete Object extension: Allows you to delete a record after requiring confirmation.
CSV Search Object extension: allows you to search for specific content among the file records.

At the moment all objects exept the Search Object are released and tested.

The extension suite has been planned in order to provide a tool that will allow users to take advantage of the ability of the WB6 built in Form Processor, and even more, of the DBTS Form Processor to create csv files containing the data submitted by forms.

Possible applications:

1. Flat file Administration Interfaces for use by the webmasters.
2. Displaying in your pages a specific record. This way you can create, in example, members profile pages.
3. Allowing your members to self edit their own profile (or part of it)
4. Displaying in your pages Price lists created with Excel
and more.
5. Allow your visitors to search through a file and display the results.
6. Create listing directories
7. Create searchable product catalogs with images

The visual output of the objects is highly customizable through in page css

You can see the demos and download the extension at
http://www.dbtechnosystems.com/wb6/DBTS_CSV_Manager

License:

The PHP code used in this extension has been developed by DB Technosystems.com . The extension is freely available to all WB users, and can be embedded in any work, personal or commercial. You are not allowed to redistribute or sell this extension. Please address to our download page anyone interested in using this extension:
http://www.dbtechnosystems.com/wb6/DBTS_CSV_Manager/

This software is delivered AS IS. By installing and using it, you agree that Pablo Software Solutions or DB Technosystems will not be held liable for ANY damage, of ANY type, caused by the use of this software. Installing and using this software implies that you fully and unconditionally accept these terms. USE AT YOUR OWN RISK. Please fully test before using it.
Last edited by Navaldesign on Sun Oct 11, 2009 12:48 pm, edited 4 times in total.
www.dbtechnosystems.com

User avatar
me.prosenjeet
 
 
Posts: 1385
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet » Sat Sep 05, 2009 12:34 am

Naval,
Wow! Wow! Wow! Wow!
However, I feel a layman language explanation of this extension would be appreciated for all the newbies.

User avatar
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign » Sat Sep 05, 2009 12:38 am

me.prosenjeet wrote: However, I feel a layman language explanation of this extension would be appreciated for all the newbies.
Not sure which part you refer to, can you plese be more explicit ?
www.dbtechnosystems.com

User avatar
me.prosenjeet
 
 
Posts: 1385
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet » Sat Sep 05, 2009 3:21 am

Navaldesign wrote:
me.prosenjeet wrote: However, I feel a layman language explanation of this extension would be appreciated for all the newbies.
Not sure which part you refer to, can you plese be more explicit ?
What I meant was like:

1) What it does (simple blunt explaination)?
2) To use this extension what we need to have(other associated extensions, if any)?

User avatar
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign » Sat Sep 05, 2009 3:30 am

The extension suite has been planned in order to provide a tool that will allow users to take advantage of the ability of the WB6 built in Form Processor, and even more, of the DBTS Form Processor to create csv files containing the data submitted by forms.

CSV List Object extension: allows you to display the file content in your pages.
www.dbtechnosystems.com

User avatar
me.prosenjeet
 
 
Posts: 1385
Joined: Mon Dec 24, 2007 1:50 pm
Location: Lucknow
Contact:

Post by me.prosenjeet » Sat Sep 05, 2009 3:36 am

Navaldesign wrote:
The extension suite has been planned in order to provide a tool that will allow users to take advantage of the ability of the WB6 built in Form Processor, and even more, of the DBTS Form Processor to create csv files containing the data submitted by forms.

CSV List Object extension: allows you to display the file content in your pages.
Naval, no offense, I understand what that means and how to use that but somehow feel, new users who has just bought the software will they get that? My point was a more simplified explanation....otherwise it is OK :lol:

User avatar
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign » Sat Sep 05, 2009 4:08 am

Well, to be honest, i believe that anyone that will need this extension is advanced enough to understand, from my original post, what the extension does. At least i think so....
Maybe i'm getting old....

Since, however, i do accept suggestions, i will add a line or two to make it clearer.
www.dbtechnosystems.com

User avatar
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

DBTS CSV Manager Extension - View Object Released - Bugs Fix

Post by Navaldesign » Tue Sep 08, 2009 6:40 am

The extension has been updated. A few bugs in the code have been fixed, and the View object released.

Whoever uses the extension, please download and install again. Your settings will be preserved.
www.dbtechnosystems.com

brassnugget
 
 
Posts: 39
Joined: Sun Feb 22, 2009 1:59 am

Post by brassnugget » Wed Sep 23, 2009 3:05 am

Haven't tested yet but looks brilliant! Have been puzzling over how I'm going to create unique member pages with editable content, sounds like this will do the trick.

Thanks very much!

brassnugget
 
 
Posts: 39
Joined: Sun Feb 22, 2009 1:59 am

Post by brassnugget » Thu Dec 10, 2009 10:09 am

Can understand that you've put in a lot of time to the development of this extension and a shame that other WB users don't grasp the potential and uses for this extension - but would be great for the rest of us if we could get the completed package!

For my 2 cents worth it would be HUGELY helpful for my current project if the extension included the seach function, as I need to link a search with the login details on file.

Thanks for all your hard work to date!

RonHills
 
 
Posts: 13
Joined: Wed Apr 23, 2008 7:02 pm
Location: Johnson City, NY USA
Contact:

Will this work with mySQL?

Post by RonHills » Tue Dec 15, 2009 4:47 am

Hello again, George;

I just discovered this extension and it looks like it could be very useful with our DVD database (http://www.theracereport.tv/dvd.html )

I want to convert our current DVD inventory from a WB table displayed in an iframe to a database so that customers can view a specific group of DVD's (example: only DVD's of "Afton Speedway" , or: only DVD's from 2008.

I am leaning toward a mySQL database instead of Excel or Access. Will this extension help achieve this goal?

Thanks again for all you do for WB users!
Ron Hills
Johnson City, NY USA

www.TheRaceReport.TV
www.sal-pa.org
www.sal-pa-dist15.org
www.panelsert.com

User avatar
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign » Tue Dec 15, 2009 6:46 am

Hi Ron,
This extension is based on a csv file created either in Excel or directly by a form. For your needs you probably need a MySQL system. However, you have, from what I see, additional requirements, like paypal buttons displayed in the table etc.
If
I think you need something like this: http://www.irishhorsemarkets.com/adverts/list.php or http://www.jerryoconnorcars.com/list.php with obvious differences. These applications require rather specific scripts instead of generic ones though.
www.dbtechnosystems.com

RonHills
 
 
Posts: 13
Joined: Wed Apr 23, 2008 7:02 pm
Location: Johnson City, NY USA
Contact:

What solution would you recommend?

Post by RonHills » Tue Dec 15, 2009 7:42 am

Each racing season we add about 150 new DVD titles, so eventually the table length (and corresponding page length) that customers will have to scroll through will get out of hand.

With the current system it is very simple to copy & paste the PayPal code from one table cell to the next and then make the necessary changes to the item description. I don't know if the PayPal script will execute correctly from a mySQL table cell, but it seems like it should.

Is there a mySQL script that could be adapted for our application, or would a custom script be needed?

Is it something you would be interested in writing for us? If yes, you can send the info to

Thanks for the info!
Last edited by RonHills on Tue Dec 15, 2009 10:34 am, edited 1 time in total.
Ron Hills
Johnson City, NY USA

www.TheRaceReport.TV
www.sal-pa.org
www.sal-pa-dist15.org
www.panelsert.com

User avatar
Navaldesign
 
 
Posts: 1170
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

Post by Navaldesign » Tue Dec 15, 2009 8:54 am

Hi Ron,

Yes, of course, this is my job (writing DB driven scripts for such applications)

In my aplications, you don't need to create anything, the info (like title, price, item code etc) are all fed into the database. The script then creates the catalog automatically. And, the list is displayed in pages, so the page height doesn't get out of control (see links I posted). Even the PayPal button is autocreated by the info fed in the DB. In most cases, jobs like yours, offer also a downloadable version of the product, in which case this script should be combined with an in-your-site cart, that will, after payment, allow for instant download.

I suffest that you remove your email address from the above post or it will (sooner or later) get cought by spam bots.

I will email you.
www.dbtechnosystems.com

FredericP
 
 
Posts: 78
Joined: Thu Apr 26, 2007 5:10 pm
Location: Bourges (France)
Contact:

Post by FredericP » Tue Feb 16, 2010 8:34 am

Hi Nav and congratulations for your work !

I have a problem with the list object. It only shows the label line. And if i switch to "no" the "first line is label" option, i get an error : "No records found in this file!".
Of course, there is more than one line in the file.
You can view the problem hre :
http://peyronnin.fr/_FreD/Test1.php?pag ... =Ascending

And the file can be wiew here : http://peyronnin.fr/_FreD/formdata.csv

Where i am doing wrong please ?
[url]http://Peyronnin.fr[/url]

Post Reply

Who is online

Users browsing this forum: No registered users and 8 guests