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

Re: admin flat line

Post by Lasa » Sun Aug 18, 2019 2:41 pm

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

Re: admin flat file

Post by Lasa » Sun Aug 18, 2019 4:02 pm

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

Re: admin flat line

Post by WWBman » Sun Aug 18, 2019 4:20 pm

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

Re: admin flat line

Post by Lasa » Sun Aug 18, 2019 10:54 pm

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

Re: admin flat line

Post by WWBman » Sun Aug 18, 2019 11:02 pm

Yes.

Lasa
 
 
Posts: 371
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa » Mon Aug 19, 2019 1:28 pm

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

Re: admin flat line

Post by WWBman » Mon Aug 19, 2019 1:58 pm

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

Re: admin flat line

Post by Lasa » Mon Aug 19, 2019 8:14 pm

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

Re: admin flat line

Post by WWBman » Mon Aug 19, 2019 9:08 pm

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

Re: admin flat line

Post by Lasa » Mon Aug 19, 2019 10:23 pm

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

Re: admin flat line

Post by WWBman » Mon Aug 19, 2019 10:29 pm

OK.
BTW ignore the character at the end of the URL, it's just the cursor!

Lasa
 
 
Posts: 371
Joined: Sat Oct 06, 2018 3:08 pm

Re: admin flat line

Post by Lasa » Mon Aug 19, 2019 11:50 pm

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

Re: admin flat line

Post by WWBman » Tue Aug 20, 2019 8:14 am

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

Re: admin flat line

Post by Lasa » Wed Aug 21, 2019 7:05 pm

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

Re: admin flat line

Post by WWBman » Wed Aug 21, 2019 10:06 pm

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.

Post Reply