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

[Navaldesign]

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

[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

[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]

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]

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]

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]

Hi George,

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

[Navaldesign]

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

[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.

[Navaldesign]

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

[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

[Navaldesign]

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

[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.

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

[bburgess]

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

[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

[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?

[Navaldesign]

This is the only way.

[atb]

Thanks

[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.

[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]

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]

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]

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]

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]

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]

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]

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]

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

[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?

[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]

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

[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.

[WWBman]

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

[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]

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]

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.