DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
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:
View Object Automatically created table:
Edit Object Automatically created form:
Delete Object Automatically created form:
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.
List Object Automatically Created table:
View Object Automatically created table:
Edit Object Automatically created form:
Delete Object Automatically created form:
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
- me.prosenjeet
-
- Posts: 1267
- Joined: Mon Dec 24, 2007 1:50 pm
- Location: Lucknow
- Contact:
Naval,
Wow! Wow! Wow! Wow!
However, I feel a layman language explanation of this extension would be appreciated for all the newbies.
Wow! Wow! Wow! Wow!
However, I feel a layman language explanation of this extension would be appreciated for all the newbies.
Check the new Chat GPT and Malware detect extensions at the link below
Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
- me.prosenjeet
-
- Posts: 1267
- Joined: Mon Dec 24, 2007 1:50 pm
- Location: Lucknow
- Contact:
What I meant was like:Navaldesign wrote:Not sure which part you refer to, can you plese be more explicit ?me.prosenjeet wrote: However, I feel a layman language explanation of this extension would be appreciated for all the newbies.
1) What it does (simple blunt explaination)?
2) To use this extension what we need to have(other associated extensions, if any)?
Check the new Chat GPT and Malware detect extensions at the link below
Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
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
- me.prosenjeet
-
- Posts: 1267
- Joined: Mon Dec 24, 2007 1:50 pm
- Location: Lucknow
- Contact:
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 OKNavaldesign 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.
Check the new Chat GPT and Malware detect extensions at the link below
Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
Check my WB Extensions
Check my WB Templates
---------------------------------------------------------
www.Lucknowwebs.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
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.
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
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
DBTS CSV Manager Extension - View Object Released - Bugs Fix
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.
Whoever uses the extension, please download and install again. Your settings will be preserved.
www.dbtechnosystems.com
Will this work with mySQL?
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!
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
Johnson City, NY USA
www.TheRaceReport.TV
www.sal-pa.org
www.sal-pa-dist15.org
www.panelsert.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
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.
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
What solution would you recommend?
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!
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
Johnson City, NY USA
www.TheRaceReport.TV
www.sal-pa.org
www.sal-pa-dist15.org
www.panelsert.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
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.
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
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 ?
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]
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Thx nav, i have copied the php file in a text file :
http://peyronnin.fr/_FreD/Test1.txt
Hope it can help.
http://peyronnin.fr/_FreD/Test1.txt
Hope it can help.
[url]http://Peyronnin.fr[/url]
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Hello Navaldesign.
Thanks for the work you do to provide extensions and help WB users.
I'm having a problem getting the DBTS CSV Manager to work. I have created a form with WB6 that seems to working properly and adding records to formdata.csv.
I've brought the created CSV back to my computer and verified that there are records in the file.
The form is at http://www.sagegolf.org/application.php
Now I've tried to get your CSV Manager to list the records on a page at
http://www.sagegolf.org/list.php
I've carefully read your documentation several times and tried to correctly configure the CSV Manager but keep getting the error message
"No records found in this file!"
Your help solving my problem will be very much appreciated.
Thanks in advance.
Thanks for the work you do to provide extensions and help WB users.
I'm having a problem getting the DBTS CSV Manager to work. I have created a form with WB6 that seems to working properly and adding records to formdata.csv.
I've brought the created CSV back to my computer and verified that there are records in the file.
The form is at http://www.sagegolf.org/application.php
Now I've tried to get your CSV Manager to list the records on a page at
http://www.sagegolf.org/list.php
I've carefully read your documentation several times and tried to correctly configure the CSV Manager but keep getting the error message
"No records found in this file!"
Your help solving my problem will be very much appreciated.
Thanks in advance.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Thanks. It seems to be working now.
You might want to review the language in your documentation where it says:
5. Separator: The separator used in your file. The extension allows for four
different separators: “;”, “,”, chr(02) “ ” and chr(380) “ |”.
The WB6 Login system file and the csv created by the WB6 form processor
both use |, the guestbook uses chr(02) “ ” . The DBTS Form Processor
extension uses the Excel type csv separator “;”.
I took it from this that since I had created the datafile with the WB6 form processor that the separator was chr(380).
Thank you again for the work you did to create this great extension.
You might want to review the language in your documentation where it says:
5. Separator: The separator used in your file. The extension allows for four
different separators: “;”, “,”, chr(02) “ ” and chr(380) “ |”.
The WB6 Login system file and the csv created by the WB6 form processor
both use |, the guestbook uses chr(02) “ ” . The DBTS Form Processor
extension uses the Excel type csv separator “;”.
I took it from this that since I had created the datafile with the WB6 form processor that the separator was chr(380).
Thank you again for the work you did to create this great extension.
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Good morning George
I wonder if you could help with your extension please as I can't see the wood for the trees in what I am doing wrong.
I have a file on my server called introd.csv
This data in this file is from a form using your other (excellent) form processing extension.
All the forms says is:
Name
Tel
Email
Company
... and I wish to display those parameters in the CSV file.
I drag and drop the DBS CSV extension onto the page, set the page to php.
CSV filepath is introd.csv, separator is ; - first line labels "yes" other parameters are blank apart from the preselected ones (eg Ascending etc)
I upload but I don't get a nicely formated table, nor do I get the parameters from the form - eg Name, tel etc. I get other things like IP address, stamp, submission date etc. I have tried using the columns to include, and have set, separating with commas, 1,2,3,4 - but still no properly formated table.
Also, I can't edit or delete the records.
Sorry if I have misunderstood something simple - I just can't work this one out.
Your guidance is appreciated and very welcome.
Thank you
Darren
I wonder if you could help with your extension please as I can't see the wood for the trees in what I am doing wrong.
I have a file on my server called introd.csv
This data in this file is from a form using your other (excellent) form processing extension.
All the forms says is:
Name
Tel
Company
... and I wish to display those parameters in the CSV file.
I drag and drop the DBS CSV extension onto the page, set the page to php.
CSV filepath is introd.csv, separator is ; - first line labels "yes" other parameters are blank apart from the preselected ones (eg Ascending etc)
I upload but I don't get a nicely formated table, nor do I get the parameters from the form - eg Name, tel etc. I get other things like IP address, stamp, submission date etc. I have tried using the columns to include, and have set, separating with commas, 1,2,3,4 - but still no properly formated table.
Also, I can't edit or delete the records.
Sorry if I have misunderstood something simple - I just can't work this one out.
Your guidance is appreciated and very welcome.
Thank you
Darren
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Though the "edit" link seems correct, it takes me to the folder index page, so I can't actually see anything.
Is the "editalgob.php" page published ? If yes, why this redirect ?
Is the "editalgob.php" page published ? If yes, why this redirect ?
Last edited by Navaldesign on Tue Aug 24, 2010 11:10 am, edited 1 time in total.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Not really sure what you mean. A link to the page pls ? (unedited)
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Please install again, I edited the <head> section (don't even know how it got messed!). Check and let me know.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
I believe all this is fixed in the current version.Just looking at the source of edit.php and the stray tags are still there:
</style> <link rel="stylesheet" type="text/css" href="csvmanager_includes/css_1.css"></script></head>
Also in edit.php, the trailing semi colon still exists:
$display .= '<td align="left" valign="middle" width="500"; class="csv_values">'.$values[$labels[$columns[$i]]].'</td>
</tr>';
on the width attribute.
That closing style tag on the left shouldn't exist at all and the closing script tag on the right shouldn't exist.
Not sure what you mean.On the main view page the closing head tag is still chopped?
But there is such a hidden field that controls the script behavior, both in the Edit and the Delete objects.There is one other problem in addition to the 3 or 4 little things I noted earlier.
For Page Protection, if you use the single page protect on the "edit" page, both the page protection and your code are reacting on a submission based on
if ($_SERVER['REQUEST_METHOD'] == "POST")
so if you land on the page, type in the password, it just zips through the entire script and goes to the success page and you never see the content.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Are you downloading from my website (which is not updated) or through the extension manager ?
Current versions are 2.4.0.1 but are only loaded on the WYSIWYG Extensions Database: http://extensions.wysiwygwebbuilder.com/
Or, directly, through the WB7 extension manager.
And, I have tested them thoroughly with WB7 this is why I don't understand it. Even the code you mentioned actually is:
if ($_SERVER['REQUEST_METHOD'] == "POST" and $_POST['formid'] == "csveditform") {
So I suppose that you are downloading from my site, which only has the old versions.
In the new versions (List object) I have also enabled the "Parse as Image", "Parse as Email" and "Parse as Hypwerlink" features that were disabled in the previous version.
Current versions are 2.4.0.1 but are only loaded on the WYSIWYG Extensions Database: http://extensions.wysiwygwebbuilder.com/
Or, directly, through the WB7 extension manager.
And, I have tested them thoroughly with WB7 this is why I don't understand it. Even the code you mentioned actually is:
if ($_SERVER['REQUEST_METHOD'] == "POST" and $_POST['formid'] == "csveditform") {
So I suppose that you are downloading from my site, which only has the old versions.
In the new versions (List object) I have also enabled the "Parse as Image", "Parse as Email" and "Parse as Hypwerlink" features that were disabled in the previous version.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Not sure why you have issues downloading, but pls follow these steps:
1. in WB enter the extension Manager. Uninstall all 4 extensions.
2. Click on Available and allow WB to retrieve the lates versions.
3. Click on the Forms category, and they should appear.
4. Install through the extension manager, directly from the site
Then Close Down WB and Start it again. Check to see.
1. in WB enter the extension Manager. Uninstall all 4 extensions.
2. Click on Available and allow WB to retrieve the lates versions.
3. Click on the Forms category, and they should appear.
4. Install through the extension manager, directly from the site
Then Close Down WB and Start it again. Check to see.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
I'm sorry but I can NOT reproduce this issue. My Own demo pages are clean and the </head> tag is just fine.
A link to the page pls ?
A link to the page pls ?
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
I can't even see the css stylesheets in your page code!
There is definately something wrong, though I can't know why.
Can you please post the page code (as it appears on the WB Page HTML) ?
There is definately something wrong, though I can't know why.
Can you please post the page code (as it appears on the WB Page HTML) ?
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
The extension ads stylesheets to the List page itself. I don't see it in your page.
Furthermore, the extension ads code in the "Between Head" tag of the page, so there is ABSOLUTELY NO REASON why the extension would break the </head> tag. I wouldn't be able to do it even if I wanted to!
Furthermore, the extension ads code in the "Between Head" tag of the page, so there is ABSOLUTELY NO REASON why the extension would break the </head> tag. I wouldn't be able to do it even if I wanted to!
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Ok, here is what I believe you have done:
You have "cut" the stylesheets code from the WB page and you have pasted them in the ballots.css file (though I don't understand why)
Here is the css code as I have retrieved it from your site:
Doing this, you have also "cut" the </ part of the head closing tag.
The you uploaded the rest of the code manually on the website.
I'm sorry to say but you have changed the page code yourself and you have misled me to search for issues with the script
You have "cut" the stylesheets code from the WB page and you have pasted them in the ballots.css file (though I don't understand why)
Here is the css code as I have retrieved it from your site:
Code: Select all
div#container
{
width: 920px;
position: relative;
margin-top: 0px;
margin-left: auto;
margin-right: auto;
text-align: left;
}
body
{
text-align: center;
margin: 0;
background-color: #FFFFFF;
background-image: url(images/back6.jpg);
background-attachment: fixed;
background-repeat: no-repeat;
background-position: center top;
color: #000000;
}
.ThemeMenuBar1Menu,
.ThemeMenuBar1SubMenuTable
{
font-family: Lucida Sans Unicode;
font-size: 19px;
font-weight: normal;
color: #FFFFFF;
text-align: center;
padding: 0;
cursor: pointer;
}
.ThemeMenuBar1MenuOuter
{
border: 0;
}
.ThemeMenuBar1SubMenu
{
position: absolute;
visibility: hidden;
border: 0;
padding: 0;
border: 0;
}
.ThemeMenuBar1Menu td
{
padding: 0;
}
.ThemeMenuBar1SubMenuTable
{
color: #000000;
text-align: left;
background-color: #FFFFCC;
font-weight: normal;
font-style: normal;
text-decoration: none;
}
.ThemeMenuBar1SubMenuTable td
{
white-space: nowrap;
}
.ThemeMenuBar1MainItem,
.ThemeMenuBar1MainItemHover,
.ThemeMenuBar1MainItemActive,
.ThemeMenuBar1MenuItem,
.ThemeMenuBar1MenuItemHover,
.ThemeMenuBar1MenuItemActive
{
white-space: nowrap;
}
.ThemeMenuBar1MainItem
{
background: url(images/img0116.gif);
width: 150px;
padding-right: 0px;
height: 30px;
background-repeat: no-repeat;
}
.ThemeMenuBar1MainItemHover,
.ThemeMenuBar1MainItemActive
{
background: url(images/img0116.gif);
width: 150px;
height: 30px;
padding-right: 0px;
background-repeat: no-repeat;
}
.ThemeMenuBar1MainItemHover,
.ThemeMenuBar1MainItemActive
{
color: #FFFFFF;
font-weight: normal;
font-style: normal;
text-decoration: none;
}
.ThemeMenuBar1MenuItemHover,
.ThemeMenuBar1MenuItemActive
{
color: #000000;
background-color: #EFF6FF;
font-weight: normal;
font-style: normal;
text-decoration: none;
}
.ThemeMenuBar1MenuFolderLeft,
.ThemeMenuBar1MenuFolderRight,
.ThemeMenuBar1MenuItemLeft,
.ThemeMenuBar1MenuItemRight
{
padding: 0px 0px 0px 0px;
}
td.ThemeMenuBar1MainFolderText,
td.ThemeMenuBar1MainItemText
{
padding: 0px 0px 0px 0px;
width: 150px;
height: 30px;
padding-right: 0px;
}
.ThemeMenuBar1MenuFolderText,
.ThemeMenuBar1MenuItemText
{
padding: 3px 5px 3px 5px;
}
.ThemeMenuBar1MenuItem .ThemeMenuBar1MenuFolderText,
.ThemeMenuBar1MenuItem .ThemeMenuBar1MenuItemText
{
border: 1px solid transparent;
}
.ThemeMenuBar1MenuItemHover .ThemeMenuBar1MenuFolderText,
.ThemeMenuBar1MenuItemActive .ThemeMenuBar1MenuFolderText,
.ThemeMenuBar1MenuItemHover .ThemeMenuBar1MenuItemText,
.ThemeMenuBar1MenuItemActive .ThemeMenuBar1MenuItemText
{
border: 1px solid #000000;
}
td.ThemeMenuBar1MenuSplit
{
overflow: hidden;
background-color: inherit;
}
div.ThemeMenuBar1MenuSplit
{
height: 1px;
margin: 0px 0px 0px 0px;
overflow: hidden;
background-color: inherit;
border-top: 1px solid #FFFFFF;
}
.ThemeMenuBar1MenuVSplit
{
display: block;
width: 1px;
margin: 0px 2px 0px 2px;
overflow: hidden;
background-color: inherit;
border-right: 1px solid #FFFFFF;
}
.csv_table
{
background-color: #AFEEEE;
border: 1px #000000 default;
}
.csv_labels
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
color: #000000;
background-color: #C0C0C0;
padding: 2px;
border: 1px #000000 default;
}
.csv_values
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
text-decoration: none ;
color: #000000;
background-color: #E6E6FA;
padding: 2px;
border: 1px #000000 default;
}
.csv_values1
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
text-decoration: none ;
color: #000000;
background-color: #D2B48C;
padding: 2px;
border: 1px #000000 default;
}
.csv_footer
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
text-decoration: none ;
color: #000000;
background-color: #C0C0C0;
padding: 2px;
border: 1px #000000 default;
}
a.csv_footer_link:link
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_footer_link:visited
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_footer_link:hover
{
color: #FF0000;
font-weight: bold;
text-decoration: none;
}
a.csv_link:link
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_link:visited
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_link:hover
{
color: #FF0000;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link:link
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link:visited
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link:hover
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link_active:link
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link_active:visited
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link_active:hover
{
color: ;
font-weight: bold;
text-decoration: none;
}
</
Doing this, you have also "cut" the </ part of the head closing tag.
The you uploaded the rest of the code manually on the website.
I'm sorry to say but you have changed the page code yourself and you have misled me to search for issues with the script
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
What you are saying is impossible.
WB creates css global files only from the styles you create within WB itself, not from css styles that are added by extensions. It doesn't even "see" it at all!
Unless you have added other code, on your own, that causes an issue with WB .
The page code should be:
The part that starts with <style.....
.csv_table
{
etc, is added by the extension, WB doesn't even "see" it in order to remove it and add it in the css file!
If you have not modified it yourself, I suggest that you publish again the page, ALL FILES and see if maybe there was a conflict with the broken extension code that you had installed previously.
WB creates css global files only from the styles you create within WB itself, not from css styles that are added by extensions. It doesn't even "see" it at all!
Unless you have added other code, on your own, that causes an issue with WB .
The page code should be:
Code: Select all
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<title>Country Hearth - View Ballots</title>
<meta name="description" content="Country Hearth and Chimney Inc. is a NextEnergy authorized GeoThermal Dealer and offers a full range of sales, service and installation neeeds.">
<meta name="keywords" content="geo thermal, next energy, heating, cooling, cobourg, port hope, peterborough, bancroft, hvac, geo exchange, wett inspections">
<meta name="author" content="Gerry Freymann - Interpool Development - www.interpool.ca">
<meta name="generator" content="WYSIWYG Web Builder - http://www.wysiwygwebbuilder.com">
<link rel="stylesheet" href="./ballots.css" type="text/css">
<link rel="stylesheet" href="./Country_Hearth.css" type="text/css">
<script type="text/javascript" src="./jscookmenu.js"></script>
<style type="text/css">
.csv_table
{
background-color: #AFEEEE;
border: 1px #000000 default;
}
.csv_labels
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
color: #000000;
background-color: #C0C0C0;
padding: 2px;
border: 1px #000000 default;
}
.csv_values
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
text-decoration: none ;
color: #000000;
background-color: #E6E6FA;
padding: 2px;
border: 1px #000000 default;
}
.csv_values1
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
text-decoration: none ;
color: #000000;
background-color: #D2B48C;
padding: 2px;
border: 1px #000000 default;
}
.csv_footer
{
font-family: Arial;
font-size: 13px;
font-weight: normal;
font-style: normal;
text-decoration: none ;
color: #000000;
background-color: #C0C0C0;
padding: 2px;
border: 1px #000000 default;
}
a.csv_footer_link:link
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_footer_link:visited
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_footer_link:hover
{
color: #FF0000;
font-weight: bold;
text-decoration: none;
}
a.csv_link:link
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_link:visited
{
color: #000000;
font-weight: normal;
text-decoration: none;
}
a.csv_link:hover
{
color: #FF0000;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link:link
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link:visited
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link:hover
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link_active:link
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link_active:visited
{
color: ;
font-weight: bold;
text-decoration: none;
}
a.csv_labels_link_active:hover
{
color: ;
font-weight: bold;
text-decoration: none;
}
</style>
</head>
etc............
.csv_table
{
etc, is added by the extension, WB doesn't even "see" it in order to remove it and add it in the css file!
If you have not modified it yourself, I suggest that you publish again the page, ALL FILES and see if maybe there was a conflict with the broken extension code that you had installed previously.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
The other pages retrieve the css file that the extension creates itself. You can see it in this line:
<link rel="stylesheet" type="text/css" href="csvmanager_includes/css_1.css">
The list page instead, which is the "core" of the extension, SHOULD have the css code added in the page itself as I posted above.
The broken </head> tag causes the text "head>" to appear in your page.
-Generate external CSS style sheets for page specific styles
-Generate single CSS style sheet for global styles
Should not be both checked as this is meaningless! I usually use the second.
<link rel="stylesheet" type="text/css" href="csvmanager_includes/css_1.css">
The list page instead, which is the "core" of the extension, SHOULD have the css code added in the page itself as I posted above.
The broken </head> tag causes the text "head>" to appear in your page.
-Generate external CSS style sheets for page specific styles
-Generate single CSS style sheet for global styles
Should not be both checked as this is meaningless! I usually use the second.
www.dbtechnosystems.com
- BaconFries
-
- Posts: 5648
- Joined: Thu Aug 16, 2007 7:32 pm
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Evening Naval sorry to be a pain but is this stiull available for download?? I have tried but get directed to a 404! Just needing to download as lost this when had PC crashed at New Year...again thanks for everything...
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Of course it is available:
1. Through the Extensions site (category forms)
2. Through the Extensions Manager of Wb (forms category)
3. Through my site http://www.dbtechnosystems.com/wb6/DBTS_CSV_Manager/
This last one resulted in 404 due to a mistake of mine, sorry and thanks for letting me know.
1. Through the Extensions site (category forms)
2. Through the Extensions Manager of Wb (forms category)
3. Through my site http://www.dbtechnosystems.com/wb6/DBTS_CSV_Manager/
This last one resulted in 404 due to a mistake of mine, sorry and thanks for letting me know.
www.dbtechnosystems.com
- BaconFries
-
- Posts: 5648
- Joined: Thu Aug 16, 2007 7:32 pm
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
Your welcome just wanted to try and get eveyting backed up again after loss this year...looking forward to the new extension your working on....
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 11/09/2009 UPDATE ****
You can use the same form that you used to create the CSV. Or build one if the CSV was built in Excel. The form can be processed either the built in form processor or the DBTS Form Processor.
This is the reason why there is no "Add" object.
This is the reason why there is no "Add" object.
www.dbtechnosystems.com
- Navaldesign
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
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.
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.
www.dbtechnosystems.com
Re: DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
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
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
-
- Posts: 862
- Joined: Sat Mar 01, 2008 8:08 pm
- Location: Italy
- Contact:
Re: DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
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 ?
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 ?
www.dbtechnosystems.com
Re: DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
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
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
Re: DBTS CSV Manager Extension **** 06/11/2011 UPDATE ****
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)
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)