admin flat line

Issues related to the Login tools of WYSIWYG Web Builder.
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.
Post Reply
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

admin flat line

Post by Lasa »

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
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

You cannot 'download' the information, but you can export the data from the database. This requires some MySQL knowledge.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

I would need the MySql to download the entered info, even if it flat line...?
Lasa
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

I assume you mean 'flat file'?

No, in that case you can download the database file directly from the server.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

Any clue how?
Lasa
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

Just enter the location of the file in the browser.

For example:
http://www.yourwebsite.com/usersdb.php
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

The flat database is in CSV format.
However, it is not meant to be manually edited.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

What exactly do you want to do with the data?
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

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.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

Thanks pablo,
any suggestions?
Cheers,
Lasa
User avatar
Pablo
 
Posts: 21571
Joined: Sun Mar 28, 2004 12:00 pm
Location: Europe
Contact:

Re: admin flat line

Post by Pablo »

I'm sorry, I cannot help you customization the code.
alan_sh
 
 
Posts: 1681
Joined: Tue Jan 01, 2019 5:50 pm

Re: admin flat line

Post by alan_sh »

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
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

.".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
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat file

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

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.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

Yes.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

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.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

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.
Image
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

OK.
BTW ignore the character at the end of the URL, it's just the cursor!
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

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.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

WWBman,
Thanks for helping me.
Have you ever used any of the DBTS extensions. They seem to fit the bill as well.
Cheers,
Lasa
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

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.
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

Been away...Thank you so much helping me WWBman! I will give it the ol'try!
Lasa
 
 
Posts: 482
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa »

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
WWBman
 
 
Posts: 916
Joined: Fri Jan 08, 2010 6:10 pm

Re: admin flat line

Post by WWBman »

You’re welcome.
Post Reply