admin flat line
Forum rules
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/login_basics.html
http://www.wysiwygwebbuilder.com/login_tools.html
TIP:
A lot of information about the login tools can be found in the help/manual.
Also checkout the demo template that is include with the software.
PLEASE READ THE FORUM RULES BEFORE YOU POST:
viewtopic.php?f=12&t=1901
MUST READ:
http://www.wysiwygwebbuilder.com/login_basics.html
http://www.wysiwygwebbuilder.com/login_tools.html
TIP:
A lot of information about the login tools can be found in the help/manual.
Also checkout the demo template that is include with the software.
admin flat line
I made a register page with a series of custom fields.
If I go into Admin it show the basic stuff user name etc.
If I click on the edit it shows all the fields filled in etc, great so far but how do I download the information?
Cheers,
Lasa
If I go into Admin it show the basic stuff user name etc.
If I click on the edit it shows all the fields filled in etc, great so far but how do I download the information?
Cheers,
Lasa
Re: admin flat line
You cannot 'download' the information, but you can export the data from the database. This requires some MySQL knowledge.
Re: admin flat line
I would need the MySql to download the entered info, even if it flat line...?
Lasa
Lasa
Re: admin flat line
I assume you mean 'flat file'?
No, in that case you can download the database file directly from the server.
No, in that case you can download the database file directly from the server.
Re: admin flat line
Just enter the location of the file in the browser.
For example:
http://www.yourwebsite.com/usersdb.php
For example:
http://www.yourwebsite.com/usersdb.php
Re: admin flat line
Thanks Pedro, I was able to retrieve it but its pretty much unusable "as-is"
Is there anyway to have it issued to a csv format?
Cheers,
Lasa
Is there anyway to have it issued to a csv format?
Cheers,
Lasa
Re: admin flat line
The flat database is in CSV format.
However, it is not meant to be manually edited.
However, it is not meant to be manually edited.
Re: admin flat line
Do you know of any way to get the input data in a usable csv form? or another bit of software that might help me?
Does MySQL help?
Thanks,
Lasa
Does MySQL help?
Thanks,
Lasa
Re: admin flat line
What exactly do you want to do with the data?
Re: admin flat line
Just need to retrieve the data in a traditional way to feed a csv file for use with blanket email to send invitations to members.
Right now the information isn't very friendly...
Cheers,
Lasa
Right now the information isn't very friendly...
Cheers,
Lasa
Re: admin flat line
The database was not designed to be used this way. The purpose of the flat file is to store usernames/passwords so it can be easily read by the scripts.
If you have different requirements then you can implement this yourself.
If you have different requirements then you can implement this yourself.
Re: admin flat line
Thanks pablo,
any suggestions?
Cheers,
Lasa
any suggestions?
Cheers,
Lasa
Re: admin flat line
I'm sorry, I cannot help you customization the code.
Re: admin flat line
Lasa,
It sounds like you need a tool which will take the file and output what you need. It doesn't sound that hard to make.
If it's a CSV file, can you read it into Excel? I don't have one, so I don't know.
Alan
It sounds like you need a tool which will take the file and output what you need. It doesn't sound that hard to make.
If it's a CSV file, can you read it into Excel? I don't have one, so I don't know.
Alan
Re: admin flat line
.".take the file and output what you need. It doesn't sound that hard to make"... I like the sound of it but I don't know how?
Cheers,
Lasa
Cheers,
Lasa
Re: admin flat file
The flat File generated is:
Billie|c99f79ac8bb6452a553dd2e53b40bb11|billaart@gmail.com|Billy Jones|1|NA|BillDesign|18910 NW 111 Ave|Miami|Florida|37157|www.cnn.com|305-555-5555|none
Is there a way to arrange the order of the data?
anyway of separating the entries not just run on info.?
Cheers,
Lasa
Billie|c99f79ac8bb6452a553dd2e53b40bb11|billaart@gmail.com|Billy Jones|1|NA|BillDesign|18910 NW 111 Ave|Miami|Florida|37157|www.cnn.com|305-555-5555|none
Is there a way to arrange the order of the data?
anyway of separating the entries not just run on info.?
Cheers,
Lasa
Re: admin flat line
I suppose it depends if you want this to be an automated process.
The character that separates the fields is a pipe character (|) which is the one usually found above the backslash key.
This can be used as the field separator in a spreadsheet such as Excel.
EDIT:
You may be able to use the DataViewer extension.
The character that separates the fields is a pipe character (|) which is the one usually found above the backslash key.
This can be used as the field separator in a spreadsheet such as Excel.
EDIT:
You may be able to use the DataViewer extension.
Re: admin flat line
yeah the | separates the fields.. anyway to separate each entry so each registration stands separate...
I will take a look at the DataViewer extension... Is it in the WWB extensions?
Lasa
I will take a look at the DataViewer extension... Is it in the WWB extensions?
Lasa
Re: admin flat line
WWBman,
It looks like it would do what I'm trying to accomplish... have you ever used it?
I'll need to read more about it, what I did look at seemed a little over my head (ok maybe a lot) but I'll see if I can make heads or tails of it. The help looks detailed its my ability that's in question.
Any heads up on how to use it (them) would be welcome.
Lasa
It looks like it would do what I'm trying to accomplish... have you ever used it?
I'll need to read more about it, what I did look at seemed a little over my head (ok maybe a lot) but I'll see if I can make heads or tails of it. The help looks detailed its my ability that's in question.
Any heads up on how to use it (them) would be welcome.
Lasa
Re: admin flat line
Yes, I've used it before both with MySQL and a flatfile.
DataViewer can access the flatfile directly from the server, so no manual copying necessary.
Set the Data source to CSV (online) (End of Line), enter the full URL in the URL box and | in the Separator box.
DataViewer can access the flatfile directly from the server, so no manual copying necessary.
Set the Data source to CSV (online) (End of Line), enter the full URL in the URL box and | in the Separator box.
Re: admin flat line
WWBman,
You lost me at yes... I'm trying but it doesn't make sense to me.
Is there anyway you could send me a sample set up of your settings... I'm using the flatfile with the default data name.
I can reverse engineer better then follow instructions.
Is there a way to send you my email?
Cheers,
Lasa
You lost me at yes... I'm trying but it doesn't make sense to me.
Is there anyway you could send me a sample set up of your settings... I'm using the flatfile with the default data name.
I can reverse engineer better then follow instructions.
Is there a way to send you my email?
Cheers,
Lasa
Re: admin flat line
This is what the DataViewer properties should look like.
Change the Column headers to your preferences.
If you like you can upload your project (the .wbs file) to your server and I can download it from there and have a look at it.
Or upload it to one of the free websites such as www.mediafire.com
Just the page with the DataViewer should be enough.
Change the Column headers to your preferences.
If you like you can upload your project (the .wbs file) to your server and I can download it from there and have a look at it.
Or upload it to one of the free websites such as www.mediafire.com
Just the page with the DataViewer should be enough.
Re: admin flat line
I was looking at the wrong extension...now it makes sense what you had said about CSV (online) END of Line
Let me test this...
Lasa
Let me test this...
Lasa
Re: admin flat line
OK.
BTW ignore the character at the end of the URL, it's just the cursor!
BTW ignore the character at the end of the URL, it's just the cursor!
Re: admin flat line
I'm able to see the the data in a usable format with headings!
The column headings I made do not correspond to the fields input... is there a way to get them in the right order.
Also the space available per filed sometimes is too small... away to set these?
Cheers,
Lasa
The column headings I made do not correspond to the fields input... is there a way to get them in the right order.
Also the space available per filed sometimes is too small... away to set these?
Cheers,
Lasa
Re: admin flat line
Sorry, I don't think there is a way of reordering the fields.
I don't know how each column's width is calculated.
When I tried it on a test usersdb.php the columns if anything were too wide, not too narrow, so I have no idea why yours are too narrow.
There is an option in Appearance of Full width: true or false but I don't see what this does.
EDIT:
I think it calculates the column widths using the width allocated to the extension at design time.
So to make the columns wider you will have to expand the size you've given to the extension, i.e. make it wider.
I don't know how each column's width is calculated.
When I tried it on a test usersdb.php the columns if anything were too wide, not too narrow, so I have no idea why yours are too narrow.
There is an option in Appearance of Full width: true or false but I don't see what this does.
EDIT:
I think it calculates the column widths using the width allocated to the extension at design time.
So to make the columns wider you will have to expand the size you've given to the extension, i.e. make it wider.
Re: admin flat line
WWBman,
Thanks for helping me.
Have you ever used any of the DBTS extensions. They seem to fit the bill as well.
Cheers,
Lasa
Thanks for helping me.
Have you ever used any of the DBTS extensions. They seem to fit the bill as well.
Cheers,
Lasa
Re: admin flat line
Not for a while (except the DBTS Form Processor).
But yes, they look like they would be useful.
I can't remember the difference between the DBTS CSV List and the DBTS CSV View but they're definitely worth looking at.
EDIT:
I think DBTS CSV List might be the one to use.
You can specify which fields to include and the order you want to list them.
EDIT2:!
The DBTS CSV View extension is used in conjunction with the DBTS CSV List extension.
When it's used you can view a single entry (on a separate page) by clicking the view icon in the List.
The entry's fields are displayed vertically.
But yes, they look like they would be useful.
I can't remember the difference between the DBTS CSV List and the DBTS CSV View but they're definitely worth looking at.
EDIT:
I think DBTS CSV List might be the one to use.
You can specify which fields to include and the order you want to list them.
EDIT2:!
The DBTS CSV View extension is used in conjunction with the DBTS CSV List extension.
When it's used you can view a single entry (on a separate page) by clicking the view icon in the List.
The entry's fields are displayed vertically.
Re: admin flat line
Been away...Thank you so much helping me WWBman! I will give it the ol'try!
Re: admin flat line
Hi WWBman,
Thanks for your help.
The DBT CSV extensions are working well... still getting the feel for it, but i think it will do everything I need.
Thanks again for going the extra steps and helping me.
Lasa
Thanks for your help.
The DBT CSV extensions are working well... still getting the feel for it, but i think it will do everything I need.
Thanks again for going the extra steps and helping me.
Lasa