Page 2 of 3

Re: admin flat line

Posted: Sun Aug 18, 2019 2:41 pm
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

Re: admin flat file

Posted: Sun Aug 18, 2019 4:02 pm
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

Re: admin flat line

Posted: Sun Aug 18, 2019 4:20 pm
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.

Re: admin flat line

Posted: Sun Aug 18, 2019 10:54 pm
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

Re: admin flat line

Posted: Sun Aug 18, 2019 11:02 pm
by WWBman
Yes.

Re: admin flat line

Posted: Mon Aug 19, 2019 1:28 pm
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

Re: admin flat line

Posted: Mon Aug 19, 2019 1:58 pm
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.

Re: admin flat line

Posted: Mon Aug 19, 2019 8:14 pm
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

Re: admin flat line

Posted: Mon Aug 19, 2019 9:08 pm
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

Re: admin flat line

Posted: Mon Aug 19, 2019 10:23 pm
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

Re: admin flat line

Posted: Mon Aug 19, 2019 10:29 pm
by WWBman
OK.
BTW ignore the character at the end of the URL, it's just the cursor!

Re: admin flat line

Posted: Mon Aug 19, 2019 11:50 pm
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

Re: admin flat line

Posted: Tue Aug 20, 2019 8:14 am
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.

Re: admin flat line

Posted: Wed Aug 21, 2019 7:05 pm
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

Re: admin flat line

Posted: Wed Aug 21, 2019 10:06 pm
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.