Login tools + DBTS CSV List
Posted: Wed Apr 19, 2017 12:07 am
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
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