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 is a dedicated section for commercial extensions.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

I'm afraid thi is currently only possible by manually editing the code on the file on the server.
www.dbtechnosystems.com
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

I think I had a similar problem (but I can't find the thread) and I seem to remember it was something to do with the "Columns to Include" and the "Column Labels" parameters. I could be mistaken but try filling in these parameters and see what happens. Worth a try
User avatar
atb
 
 
Posts: 33
Joined: Tue Jan 19, 2010 10:18 pm

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

Post by atb »

you could see if you can get it working with a very basic csv file first, like....

Name;Age
Tom;12
Bill;10
Frank:14

use notepad to make it.

and start from there.
if that works then take a look at your original csv file and work out whats wrong with it.
maxime
 
 
Posts: 117
Joined: Sat Apr 02, 2011 6:15 pm
Contact:

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

Post by maxime »

i am waiting for this good extension with the update who fix issues.

and i wish there is one day an extension like this but using a msql database.

And yes, i am willing to pay for it.
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

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

Post by adex1 »

Which one of the form can I use to save as csv format and what happen to this link?

http://www.dbtechnosystems.com/wb6/DBTS ... st_new.php
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

You can use any form you like.

Thank you for pointing out the issue with my page, probably a corrupted file on the server. I will investigate and fix it.
www.dbtechnosystems.com
adex1
 
 
Posts: 167
Joined: Fri Apr 01, 2011 1:13 pm

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

Post by adex1 »

Hi George,

Can I use standard form to save file as .CSV format and use DBTS view Record to view the datas?
Buy Automation Shopping Cart for CMS WEBSHOP + 2.2 Using WB10!
- Use secure gateway to buy using PAYPAL website.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

This is the "List" extension. Click on the icons to see the View, Edit, Delete pages (with respective extensions).
www.dbtechnosystems.com
jeff11214
 
 
Posts: 59
Joined: Sat Oct 28, 2006 4:22 pm

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

Post by jeff11214 »

When I use DBTS CSV List I can get a .csv file to show, but I can't get a .xls file to show.
Does it work with .xls? If so, what am I doing wrong? I tried each of the Separators.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

It only works with CSVs. The extension name declares that...
www.dbtechnosystems.com
User avatar
Islander
 
 
Posts: 54
Joined: Tue Jan 12, 2010 4:03 pm
Location: Mauritius
Contact:

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

Post by Islander »

Hello Navaldesign,

I'm using the CSV list extension to display a list of Names, addresses and websites. I really need to get the hyperlink to open in a second browser tab. I've tried to add "<a title="Webpage" target="_blank" href="http://www.website.com">website.com</a> This shows 2 links of which one does open the link in another tab. But there's a few codes that appear still before the link. Is there a way to get only the website hyperlink to appear in that cell?

http://www.mtius.biz/test/page2.php
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

How did you modify the code ? you most probably have made a mistake in the edited part.
www.dbtechnosystems.com
User avatar
Islander
 
 
Posts: 54
Joined: Tue Jan 12, 2010 4:03 pm
Location: Mauritius
Contact:

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

Post by Islander »

Instead of entering simply "mauritius360.com" in the column parsed as hyperlink, I've entered "<a title="WEBSITE" target="_blank" href="http://www.mauritius360.com">WEBSITE</a>". The rendered data in the page csv table shows as"WEBSITE" class="csv_link">WEBSITE".

The second WEBSITE text opens the link in a second tab correctly. I just need to omit "WEBSITE" class="csv link"> from the rendered part. Any idea how to do this?

I've just gave a try to this code in view of getting the link to open in another tab as compared to the default functionality of the csv list extension where all hyperlinks open in the same browser tab.
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

The only way to acheive what you want is to modify the page code AFTER you have published, from

$data_array[$i] = '<a href="http://www.'.$data_array[$i].'" class="csv_link">'.$data_array[$i].'</a>';

to

$data_array[$i] = '<a href="http://www.'.$data_array[$i].'" class="csv_link" target="_blank">'.$data_array[$i].'</a>';
www.dbtechnosystems.com
User avatar
bburgess
 
 
Posts: 129
Joined: Mon May 13, 2013 5:05 am
Location: Australia

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

Post by bburgess »

I had not seen this one Navaldesign Thank you!! NICE!
KISS is the key!
User avatar
atb
 
 
Posts: 33
Joined: Tue Jan 19, 2010 10:18 pm

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

Post by atb »

Hello George
I have a problem similar to above.....

with the DBTS List I would like to have a hyperlink that directs to something like www.mywebsite.co.uk/news.php
but on the screen the link text shows as just News

if it was html it would be something like this - <a href="www.mywebsite.co.uk/news.php">News</a>

does that make sense?

How would that be possible? if at all?

Thanks
John
User avatar
atb
 
 
Posts: 33
Joined: Tue Jan 19, 2010 10:18 pm

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

Post by atb »

I may have just answered my own question....

I've stopped the column being parsed as a hyperlink and changed the entry in the data file to <a href="news.php">News</a>
which seems to work.

Is this the best/only way to do it or is there a better way?
User avatar
Navaldesign
 
 
Posts: 862
Joined: Sat Mar 01, 2008 8:08 pm
Location: Italy
Contact:

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

Post by Navaldesign »

This is the only way.
www.dbtechnosystems.com
User avatar
atb
 
 
Posts: 33
Joined: Tue Jan 19, 2010 10:18 pm

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

Post by atb »

Thanks :)
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

Hello George,
I appreciate the work and dedication that you have put into the DBTS Extensions. Currently I’m experiencing trouble getting the CSV List Management Extension to display in my browser(Chrome). I keep getting a HTTP ERROR 500 stating “This page isn’t working…www.example.com is currently unable to handle this request”. I’m using WB18; I set file permission to 755 and then 777, all to no avail. The CSV List extension is in the same folder as the csv file and form. What am I missing as to why my List View will not display? I set the preliminary parameters, as ascribed by the manual, still nothing. Any help would be greatly appreciated.
User avatar
BaconFries
 
 
Posts: 5362
Joined: Thu Aug 16, 2007 7:32 pm

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

Post by BaconFries »

@average2 You will probably not get a reply from Navaldesign (George) as he was Last active:Sun Jan 09, 2022 1:58 pm
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

average2 wrote: Sat Feb 10, 2024 8:40 pm Hello George,
I appreciate the work and dedication that you have put into the DBTS Extensions. Currently I’m experiencing trouble getting the CSV List Management Extension to display in my browser(Chrome). I keep getting a HTTP ERROR 500 stating “This page isn’t working…www.example.com is currently unable to handle this request”. I’m using WB18; I set file permission to 755 and then 777, all to no avail. The CSV List extension is in the same folder as the csv file and form. What am I missing as to why my List View will not display? I set the preliminary parameters, as ascribed by the manual, still nothing. Any help would be greatly appreciated.
I may be able to help if you share your project (.wbs file) and if possible the CSV file.
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

I appreciate your time....without setting Error Reporting….I’m using the DBTS CSV List Management Extension to output simple form data to a CSV file ‘memdata.csv’. Here is the link to the mockup site that I am using. www.howieshipp.com/memcont/m_index.php you may register and then attempt to Edit Profile and you will get the Column Count Error. What I have tried….. I have loaded the DBTS CSV List object to my page and filled in the preliminary settings (as described in the manual), and loaded the page to the host site. When I run the page I get a blank screen, so I then come back and fill in the perimeters of Columns to be View, Column Labels, Sort Column, etc..etc. I have also tried to add the Date and IP to my column count without any success…..I still receive the Column count error that you see. I have exhausted my limited knowledge on what to do. Your replies are greatly appreciated. Thank you in advance.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

I get the same result as you.
But I need the project file (.wbs) to see what you have done.

How to share a project:
viewtopic.php?f=10&t=82134
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

I've dug up a test project I used years ago and although I don't get your error when I run it I don't get any output either.
I can't see why it doesn't work or even if it ever did work!

I now think it would be better to use the DataViewer extension which definitely works fine.
User avatar
BaconFries
 
 
Posts: 5362
Joined: Thu Aug 16, 2007 7:32 pm

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

Post by BaconFries »

Just a stab in the dark here...I haven't ever used the extension one possible reason why it may not be working is it using MySQL and not MySQLi as may servers now use or require.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

BaconFries wrote: Sun Feb 11, 2024 6:44 pm Just a stab in the dark here...I haven't ever used the extension one possible reason why it may not be working is it using MySQL and not MySQLi as may servers now use or require.
It’s only using a text csv file, no MySQL involved.
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

Hello WWBman,
I hate to be such a bother and I appreciate your time…..Here’s what I got ; I have uploaded the complete WBS site to www.howieshipp.com …. You may click the Member Home button. There you can Register New Purchase…you will get a product registration success page… return to Member Home page and attempt to Edit Purchases…..you will get a blank screen…Let me explain… I did not go back and create the second config for the CSV List Management Extension (Column Count, etc…etc) because I wanted you to see this behavior. Here’s what I noticed when I access the page source code on the blank page….the end tags are all missing “</body>”, “</div>”, and “</html>” as far as I can tell. Now I know that the page will not display properly (if at all), if these are missing; but I don’t know why they are missing.
Secondly, if you go ahead and config the CSV List Management Extension, the second time and upload it with the Column Count and the rest of its configuration, and attempt to run the script again, you will get the Column Count error that I explained in the previous post. I did not do the second configuration because it might help you in figuring out what might be happening, that the script will not work. I hope that I have included enough of the web site to be useful.
Thank you for your attentiveness.
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

Also, it might help to know that the form is custom.. from Wizard, using the built-in PHP Form Processor.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

I ran my own old project and I get the same blank page as you get.
I checked my server for any error_log entries and there were none.
This usually indicates there were no php errors.
So I wonder now if I ever had my old project working.

Have you tried the DataViewer extension?
User avatar
BaconFries
 
 
Posts: 5362
Joined: Thu Aug 16, 2007 7:32 pm

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

Post by BaconFries »

Something may have changed over time with servers (taking a guess) if you go to the following url you will see a "Demos" The only person that could really say is Navaldesign (George) himself to why it not working. Note that the site did have a manual to view but uses "Flash" now deprecated so you can't view. Without sounding rude average2 I think it time to move on and try another extension to meet your needs.

http://www.dbtechnosystems.com/wb6/DBTS_CSV_Manager/

DBTS CSV Manager WB Extension: The CSV List Object
http://www.dbtechnosystems.com/wb6/DBTS ... /demo1.php
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

There is also the DataTables(Paid) extension which works fine.
Install the Demo version using the Extension Manager.
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

Thanks Guys, I appreciate the time. I have tried the other two extensions that you mention; but neither will give me the functionality that I require. My members need to be able to update, add, or delete their individual records and just their records. I was trying to avoid MySql database, as it would increase my overhead as compared to a CSV file.
Last edited by average2 on Mon Feb 12, 2024 6:18 pm, edited 1 time in total.
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

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

Post by WWBman »

In that case there is also the CSV CRUD(Paid) extension which works fine.
Install the Demo version using the Extension Manager.
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

The extensions that you mention are fine; but they do not offer record selectivity. I need it to work for a logged in user. These extensions bring back all records, which will not fulfill my needs. If I could add this functionality....they would be great! I also noticed that My DBTS Form Processor would only give errors now as well. It worked perfectly before I went to the lastest version .... WB18.
bkjohns
 
 
Posts: 293
Joined: Wed Nov 14, 2018 5:54 pm

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

Post by bkjohns »

I don't know how many members you are expecting in the system but if you haven't looked at the protected page(s) system within WWB there are several included .php files that would allow a logged in user to edit their personal info. It works with a text database or MySQL, which you said you want to avoid. It would be a little of a rewrite but might do what you want.
average2
 
 
Posts: 10
Joined: Tue Jan 30, 2024 7:56 pm

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

Post by average2 »

Thanks BK, I might look into that. I had tried the protected page before...might try it in another scenario and see what I get. CSV Management List tool is the ideal platform that I need.
Post Reply