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

Navaldesign · Post by **Navaldesign** » Sun Nov 06, 2011 9:13 pm

Extension updated.

What’s new:

1. Added ability for images and hyperlinks in the “View” object
2. Added ability to “Double quote” records. This allows you to use multiline
records or HTML code in the records.
3. Added ability to use the separator (in example semicolon or coma) in the
records content
4. Added ability to restrict page access using the WWB Login script tools or the
Single Page Protect tool.
5. Added ability to restrict user access to their records only.
6. Code improvements.

Fixes:
Fixed default sorting issue.

You can update through the Extension Manager or downloading the extensions from my site and manually installing them.

atb · Post by **atb** » Tue Dec 20, 2011 12:18 am

Hello,
using the CSV List I want to display an image in column 4 but I cant seem to get the image to display only the text of the data.

I enter in 'Parse as image columns' the number 4
Then in the CSV file what data do I need? the full URL (ie http://www.webpage.com/images/image.jpg) or just from the root (ie images/image.jpg)

for example the CSV file might contain this line-
Fred,Green,shoes,images/fred.jpg

so then in the 4th column of the list table the image file fred.jpg would be displayed?

what am I doing wrong?

also what image file formats work? will it work with a png file?

Many thanks
John

Navaldesign · Post by **Navaldesign** » Tue Dec 20, 2011 5:02 am

You must use the full URL: http://domainname.com/images/image.jpg

The script isn't at all interested in the type of image, it simply ads the necessar <img .... > tags so the browser will display it as image. So it supports whatever image type the browser supports.

Do you have the latest version of the extension ? Where can I see your pages ?

atb · Post by **atb** » Tue Dec 20, 2011 8:17 pm

Hello George,
I've been having a play and found out the problem....

I was trying to get the image in the last column - column 4

But....

The first column is numbered 0 not 1
so the 4th column is numbered 3!

so I changed the number in 'Parse as Image columns' to 3 and it worked!

so now its all sorted

thanks for your quick responce!
john

atb · Post by **atb** » Thu Dec 22, 2011 1:30 pm

Hello George
Another quick question about DBTS CSV List...

Is it possible to remove the column sort?
I dont want my web site users to be able to sort the columns.

dont know if this will be possible or not

Many thanks
John

(loving the DBTS extensions BTW)

Navaldesign · Post by **Navaldesign** » Thu Dec 22, 2011 6:01 pm

I'm afraid thi is currently only possible by manually editing the code on the file on the server.

WWBman · Post by **WWBman** » Fri Jun 01, 2012 9:14 pm

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

atb · Post by **atb** » Fri Jun 01, 2012 10:42 pm

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 · Post by **maxime** » Fri Sep 21, 2012 2:03 pm

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 · Post by **adex1** » Wed Dec 05, 2012 9:39 pm

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

Navaldesign · Post by **Navaldesign** » Wed Dec 05, 2012 10:55 pm

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.

adex1 · Post by **adex1** » Wed Dec 19, 2012 12:42 pm

Hi George,

Can I use standard form to save file as .CSV format and use DBTS view Record to view the datas?

Navaldesign · Post by **Navaldesign** » Sat Dec 29, 2012 7:17 am

This is the "List" extension. Click on the icons to see the View, Edit, Delete pages (with respective extensions).

jeff11214 · Post by **jeff11214** » Fri Jan 18, 2013 5:34 pm

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.

Navaldesign · Post by **Navaldesign** » Fri Jan 18, 2013 7:45 pm

It only works with CSVs. The extension name declares that...

Islander · Post by **Islander** » Fri Sep 05, 2014 12:50 pm

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

Navaldesign · Post by **Navaldesign** » Fri Sep 05, 2014 7:01 pm

How did you modify the code ? you most probably have made a mistake in the edited part.

Islander · Post by **Islander** » Sat Sep 06, 2014 6:50 am

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.

Navaldesign · Post by **Navaldesign** » Sat Sep 06, 2014 4:30 pm

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>';

bburgess · Post by **bburgess** » Tue Sep 16, 2014 2:13 am

I had not seen this one Navaldesign Thank you!! NICE!

atb · Post by **atb** » Thu Feb 25, 2016 10:43 pm

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

atb · Post by **atb** » Thu Feb 25, 2016 11:16 pm

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?

Navaldesign · Post by **Navaldesign** » Fri Feb 26, 2016 12:04 am

This is the only way.

atb · Post by **atb** » Fri Feb 26, 2016 8:24 am

Thanks

average2 · Post by **average2** » 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.

BaconFries · Post by **BaconFries** » Sat Feb 10, 2024 8:59 pm

@average2 You will probably not get a reply from Navaldesign (George) as he was Last active:Sun Jan 09, 2022 1:58 pm

WWBman · Post by **WWBman** » Sat Feb 10, 2024 10:13 pm

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 · Post by **average2** » Sun Feb 11, 2024 3:39 am

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 · Post by **WWBman** » Sun Feb 11, 2024 9:11 am

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 · Post by **WWBman** » Sun Feb 11, 2024 4:36 pm

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.

BaconFries · Post by **BaconFries** » 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.

WWBman · Post by **WWBman** » Sun Feb 11, 2024 6:59 pm

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 · Post by **average2** » Mon Feb 12, 2024 2:29 am

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 · Post by **average2** » Mon Feb 12, 2024 2:38 am

Also, it might help to know that the form is custom.. from Wizard, using the built-in PHP Form Processor.

WWBman · Post by **WWBman** » Mon Feb 12, 2024 9:31 am

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?

BaconFries · Post by **BaconFries** » Mon Feb 12, 2024 12:42 pm

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 · Post by **WWBman** » Mon Feb 12, 2024 3:19 pm

There is also the DataTables(Paid) extension which works fine.
Install the Demo version using the Extension Manager.

average2 · Post by **average2** » Mon Feb 12, 2024 5:52 pm

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.

WWBman · Post by **WWBman** » Mon Feb 12, 2024 6:15 pm

In that case there is also the CSV CRUD(Paid) extension which works fine.
Install the Demo version using the Extension Manager.

average2 · Post by **average2** » Mon Feb 12, 2024 6:24 pm

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 · Post by **bkjohns** » Mon Feb 12, 2024 8:10 pm

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 · Post by **average2** » Mon Feb 12, 2024 9:59 pm

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.