Community Support Forums

Re: export users csv switch columns of custom fields

2011-06-14T01:15:43-05:00

s2Member Pro will export ALL Custom Fields, on a Per-User basis. That is, if a certain User has a Custom Field, it will be exported, even if it's empty. That being said, Cristián is also correct, because in the latest release of s2Member, if a User and/or an Administrator updates a User's Profile with a Custom Field empty, s2Member will NOT store any Custom Field that is completely empty. So depending on what version you are running, and depending the last time a User's Profile was updated, you may or may not receive empty fields in the export file.

We'll try to improve upon this in a future release. In fact, there are several things already being worked on that are related to Custom Field improvements overall.

Statistics: Posted by Jason Caldwell — June 14th, 2011, 1:15 am

Re: export users csv switch columns of custom fields

2011-06-11T23:26:35-05:00

Not that I know of as it is. I'll email Jason about this and see what he suggests.

Statistics: Posted by Cristián Lávaque — June 11th, 2011, 11:26 pm

Re: export users csv switch columns of custom fields

2011-06-11T07:07:19-05:00

well, that is not completely true, because many of the custom fields were exported empty in the first 60 rows. There is no solution to this other than to put something in the fields, to get them exported?

Statistics: Posted by kentlii — June 11th, 2011, 7:07 am

Re: export users csv switch columns of custom fields

2011-06-09T21:19:42-05:00

Only the custom fields with data will be in the export CSV file.

Statistics: Posted by Cristián Lávaque — June 9th, 2011, 9:19 pm

Re: export users csv switch columns of custom fields

2011-06-09T05:04:28-05:00

I can´t do it now. I filled out all empty field in the profiels with a - to make them appear. Not sure why they do not appear when the fields are empty. For the first 60 rows in the beginning it happend with the last to custom fields so I put 0 in those, then adding a new custom field it happend with that one as well. Now that we have passed 60 fields it happens with all custom fields after row 60. They do not appear in the csv unless there is some info in them. So putting a - in them solves it, but it is not the best way to go if we start gettting a lot of sign ups. We are still in beta phase.

Statistics: Posted by kentlii — June 9th, 2011, 5:04 am

Re: export users csv switch columns of custom fields

2011-06-08T17:29:45-05:00

Could you show me the CSV file please? (x'ing out private info)

Statistics: Posted by Cristián Lávaque — June 8th, 2011, 5:29 pm

Re: export users csv switch columns of custom fields

2011-06-08T05:04:49-05:00

New problem.
I updated the s2member and s2member pro. Do not think this is the cause of the problem, but just so you know.
I have added an extra custom field and this seems to be cause some problems. It is the same problem as before with the points fields. If the field does not have any info it does not appear when exporting. So this means that some columns are moved because the custom field is not there.
Also after row 60 none of the custom fields appear unless there is information in them, so this completely messes up the csv.

Statistics: Posted by kentlii — June 8th, 2011, 5:04 am

Re: export users csv switch columns of custom fields

2011-05-13T13:08:10-05:00

Great! Bien hecho.

Statistics: Posted by Cristián Lávaque — May 13th, 2011, 1:08 pm

Re: export users csv switch columns of custom fields

2011-05-13T13:04:53-05:00

Ok, I finally found a solution. I also posted in an excel forum and the solution was pretty simple. I changed the regional settings on my computer to English-United States instead of Spanish-Spain, now it exports perfectly.

Statistics: Posted by kentlii — May 13th, 2011, 1:04 pm

Re: export users csv switch columns of custom fields

2011-05-13T03:39:12-05:00

I use excel 2007 to open the files.
I was asking in an excel forum about this too, because I suspect that there are some settings that have changed from one computer to another.
I changed the extension to .txt and opened it in excel and I am able to do "text to columns" and it is done correctly, but then when I save it as csv I am not able to import it again.

Statistics: Posted by kentlii — May 13th, 2011, 3:39 am

Re: export users csv switch columns of custom fields

2011-05-13T01:41:19-05:00

Thanks for reporting this important issue.
~ and thanks for bringing this to my attention Cristián.

kentlii wrote:
this is how it was exported.
The places there are double quotes I believe is where the info is not filled out.
But the problem is that for some users it puts all info in column A and for others it puts it in column A-E.

The columns are going to be out of whack in that file you attached, because ( as Cristián mentioned ), the file is corrupted with too many double quotes nested into each other. I know you've said, "that's how s2Member exported it", but actually, this is not how s2Member's export routine works.

My guess is that whatever application you used to open the CSV file, added those in there by default, so it appears that it's s2Member's fault, but I suspect it's not.

Please correct me if I've missed something though.

In the mean time, try exporting your Users with s2Member, and open the CSV file with a plain text editor like Notepad. That way you can see what the raw data looks like. Opening a CSV file with an editor like Excel or OpenOffice works fine too, but the application settings must be configured properly, as is the case with any CSV file. In other words, you need to configure delimiters and encapsulation when you open the file with Excel or OpenOffice. s2Member uses comma delimiters and double quote encapsulation.

Statistics: Posted by Jason Caldwell — May 13th, 2011, 1:41 am

Re: export users csv switch columns of custom fields

2011-05-11T13:33:53-05:00

Thank you. OK, you're up-to-date with those. I'll notify Jason of this problem then.

Statistics: Posted by Cristián Lávaque — May 11th, 2011, 1:33 pm

Re: export users csv switch columns of custom fields

2011-05-11T12:41:24-05:00

version 3.5.8 and pro module v1.5.8
wordpress 3.1.2

Statistics: Posted by kentlii — May 11th, 2011, 12:41 pm

Re: export users csv switch columns of custom fields

2011-05-11T12:05:33-05:00

That is really weird.

This is what you have and how it should be (just the first few values of one row):

Code:: "9,""jayer"","""",""Francisco Javier"",""S Ocho"",""Francisco Javier"",""xxx@hotmail.com"","""",""subscriber"","""",""03/18/2011"","""", "9","jayer","","Francisco Javier","S Ocho","Francisco Javier","xxx@hotmail.com","","subscriber","","03/18/2011","",

What versions of WordPress, s2Member and s2Member Pro are you running?

Statistics: Posted by Cristián Lávaque — May 11th, 2011, 12:05 pm

Re: export users csv switch columns of custom fields

2011-05-11T03:27:52-05:00

this is how it was exported.
The places there are double quotes I believe is where the info is not filled out.
But the problem is that for some users it puts all info in column A and for others it puts it in column A-E.

Statistics: Posted by kentlii — May 11th, 2011, 3:27 am

Re: export users csv switch columns of custom fields

2011-05-10T16:43:39-05:00

Thank you.

The format of your CSV file is wrong, that's why Office or OpenOffice are confused when parsing it.

You have double double quotes, and not quotes at the beginning, for example. Is that how s2Member exported it or did you have this happen after editing and saving it?

Statistics: Posted by Cristián Lávaque — May 10th, 2011, 4:43 pm

Re: export users csv switch columns of custom fields

2011-05-10T16:18:44-05:00

Here is an example. I have changed the info of course, but the columns, titles etc. are the same. As you see with the one in row 3 there is only info in column A and in the one in row 2 there is info in several columns and some of the info is pushed into other columns.
Row 2 is at level 1 and row 3 is at level 0 in the s2member levels.

Statistics: Posted by kentlii — May 10th, 2011, 4:18 pm

Re: export users csv switch columns of custom fields

2011-05-10T16:01:39-05:00

Thanks for trying it and reporting back.

Could you share one row that doesn't have the problem and at least one other that does? xxxx'ing out any personal information, of course.

Statistics: Posted by Cristián Lávaque — May 10th, 2011, 4:01 pm

Re: export users csv switch columns of custom fields

2011-05-10T15:56:37-05:00

Tried openoffice and it creates the same problem

Statistics: Posted by kentlii — May 10th, 2011, 3:56 pm

Re: export users csv switch columns of custom fields

2011-05-10T15:33:30-05:00

I will try, but this problem has been there before if you check out the earlier posts.

Statistics: Posted by kentlii — May 10th, 2011, 3:33 pm

Re: export users csv switch columns of custom fields

2011-05-10T15:06:32-05:00

I'm not familiar with Office, but I use OpenOffice and haven't had this problem. When I import CSV data, I'm asked what the delimiter is and am shown a preview before it opens the file into columns properly. Why don't you try it and see if that solves your problem?

Statistics: Posted by Cristián Lávaque — May 10th, 2011, 3:06 pm

Re: export users csv switch columns of custom fields

2011-05-10T14:56:09-05:00

Now I have the problem again.
Changed to a new computer. I have the same version of office but when I export and open the excel document most of the data is in column A and just comma delimited in the same cells, but the accounts that have been upgraded to a higher level than level 0 cause problems. In the rows some of the data is pushed to row B,C,D and E. So if I do "text to column" to separate the data into different columns this meses up the account where there is data in other columns than column A. I do not quite get why only for some accounts it puts data in other columns and for some accounts it only puts data in column A.
So not sure what to do here. It is beginning to be a lot of work to do all the accounts manually.
Not sure if it is possible to export where the data is separated into the different columns when I do the export, this was how it did it before. Maybe some settings in excel that can be changed? Use office 2007.

Statistics: Posted by kentlii — May 10th, 2011, 2:56 pm

Re: export users csv switch columns of custom fields

2011-04-08T13:11:45-05:00

Great to hear that.
Thanks for reporting back on this. I really appreciate it.

Statistics: Posted by Jason Caldwell — April 8th, 2011, 1:11 pm

Re: export users csv switch columns of custom fields

2011-04-08T03:54:56-05:00

The problem was that some columns were still being pushed one to the left and there was one column that only showed up if there was data in the column.
I found a way around it though. We have two points columns one for current month and one for last month and these columns seemed to cause some problems, but everyone who had no points we set to 0 instead of leaving them empty and this seemed to fix the problem.
I thought it was the payment column that was the problem, but it does not seem to be the case, because if was fixed with this little trick.

Statistics: Posted by kentlii — April 8th, 2011, 3:54 am

Re: export users csv switch columns of custom fields

2011-04-07T07:51:09-05:00

Thanks for reporting back on this.
s2Member Pro creates the "First Payment Time" column for all Members during exportation; even if it's blank. So if you're using an application that reads CSV Column Headers, values for a specific entry inside your export file should have no impact on the readability of the remaining data rows.

Or are we missing something?

Statistics: Posted by Jason Caldwell — April 7th, 2011, 7:51 am