I am trying to set the flat file database to use "," instead of "|" separator between the fields.
I changed all the relevant PHP files accordingly (including loginadmin.php), but the list comes up jumbled in the administrator's list view
Is there anything hard coded to look for vertical bar field separator?
I want to use the datafile renamed to .csv for handling in Excel, which doesn't recognize the vertical bar as field seprator
Login objects
Re: Login objects
You also need to modify the admin script: loginadmin.php
Re: Login objects
OK, is that script generated for my specific form or is it generic in WWB?
Re: Login objects
The script is generated based on your settings.
Re: Login objects
OK, clear
Thanks
Thanks
Re: Login objects
M888888 Excel does recognize the Vertical Bar | but you must manually insert it in the Other field via:alex4orly wrote: ↑Thu Apr 06, 2017 6:14 am I am trying to set the flat file database to use "," instead of "|" separator between the fields.
I changed all the relevant PHP files accordingly (including loginadmin.php), but the list comes up jumbled in the administrator's list view
Is there anything hard coded to look for vertical bar field separator?
I want to use the datafile renamed to .csv for handling in Excel, which doesn't recognize the vertical bar as field seprator
Data Tab > From Text > text import wizard will appear > choose file type Delimited radio button > Next > under the Delimiters tick boxes choose Other > insert | into the field > Finish.
Hope that helps if your still having trouble.
Cheers
KISS is the key!
Re: Login objects
Thanks very much, works fine
Cheers
Cheers