Page 1 of 3

admin flat line

Posted: Mon Jul 29, 2019 7:50 pm
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

Re: admin flat line

Posted: Mon Jul 29, 2019 8:52 pm
by Pablo
You cannot 'download' the information, but you can export the data from the database. This requires some MySQL knowledge.

Re: admin flat line

Posted: Mon Jul 29, 2019 9:36 pm
by Lasa
I would need the MySql to download the entered info, even if it flat line...?
Lasa

Re: admin flat line

Posted: Tue Jul 30, 2019 6:39 am
by Pablo
I assume you mean 'flat file'?

No, in that case you can download the database file directly from the server.

Re: admin flat line

Posted: Wed Jul 31, 2019 2:14 am
by Lasa
Any clue how?
Lasa

Re: admin flat line

Posted: Wed Jul 31, 2019 6:35 am
by Pablo
Just enter the location of the file in the browser.

For example:
http://www.yourwebsite.com/usersdb.php

Re: admin flat line

Posted: Wed Jul 31, 2019 10:35 am
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

Re: admin flat line

Posted: Wed Jul 31, 2019 10:48 am
by Pablo
The flat database is in CSV format.
However, it is not meant to be manually edited.

Re: admin flat line

Posted: Wed Jul 31, 2019 1:44 pm
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

Re: admin flat line

Posted: Wed Jul 31, 2019 1:54 pm
by Pablo
What exactly do you want to do with the data?

Re: admin flat line

Posted: Wed Jul 31, 2019 8:26 pm
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

Re: admin flat line

Posted: Wed Jul 31, 2019 9:01 pm
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.

Re: admin flat line

Posted: Wed Jul 31, 2019 10:17 pm
by Lasa
Thanks pablo,
any suggestions?
Cheers,
Lasa

Re: admin flat line

Posted: Thu Aug 01, 2019 6:52 am
by Pablo
I'm sorry, I cannot help you customization the code.

Re: admin flat line

Posted: Thu Aug 01, 2019 12:27 pm
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