Login tools + DBTS CSV List

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
User avatar
alex4orly
 
 
Posts: 632
Joined: Mon Jan 20, 2014 8:17 am
Location: Australia
Contact:

Login tools + DBTS CSV List

Post by alex4orly »

Hello folks,

I have experimented for a couple of days with those two topics, eventually I got Maxime to say something that went on Chi-Ching and the coin dropped... Thanks Maxime for helping me figure it out. I will describe the steps I did

1) Created a set of pages using, Login, Administrator, Edit Profile etc...
2) Then, added some custom fields to the Admin object of WWB, all worked fine
BUT - the original records created by our club registrar had in them only the initial Admin fields (Flat file CSV) and members who logged in and updated their records caused those records to have in them all the other fields in the database.
3) So, the end result was a database file with inconsistent record layout, some records had 6 fields, some had 21 fields...
4) When trying to use DBTS CSV List module, it was able to handle and show the report of the fields I wanted correctly, but when presented with an irregular file / record format - it was all jumbled....

So, if you are facing the same issue - make sure all records in the file have exactly the same number of fields / columns

All the best
Post Reply