Data in separate columns when exporting

Resolved wolfdesigndk
(@wolfdesigndk)

4 months, 1 week ago

Hello

I would like to export some data on my users. I have figured out how to set the system so that it only exports what I need.

Where the problem comes is after export where all the data is in the same column. All the data is in column A, when you open it in Excel, where I would like to have the Registration date in column A, First name in column B Last name in column C etc. So it gives the possibility to sort the data for example by date

I have use this setup Indmeldelsesdato=>Indmeldelsedato,”Medlemsnummer “=>Medlemsnummer,Fornavn=>Fornavn,Efternavn=>Efternavn,

I have also tried with dobbelt colon ::

Because when I look at your example the data is divided, but I must be doing something wrong regards Maria

The page I need help with: [log in to see the link]

Viewing 14 replies - 1 through 14 (of 14 total)

Plugin Author Javier Carazo
(@carazo)

4 months ago

First of all, as you may have read in the plugin and here in this forum, I recommend NOT using Microsoft Excel to work with CSV files.

In GNU/Linux, I simply cannot use Excel, but I can tell you that in other operating systems where you do have a choice, Excel may be a good choice for other uses, but it causes problems like the one you mention when handling CSV data.

You should try opening the file with LibreOffice Calc or OpenOffice Calc.
Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago
```
Hello and thank you very much for your answer.

I can easily see that those programs can easily split the files as they look on your preview.. But I also found a way to do it in Excel, so it shows the same thing. It just needs a little data processing :)

I have another question. I would like to get the following data from my members, Member ID, First name, Last name, Address, Zip code and city.

I have the following data columns set up:

Indmeldelsesdato,
"Medlemsnummer",
Fornavn,
Efternavn,
E-mail,
Adresse,
Postnr.,
"By ",
Telefonnr.,
" Fødselsdato",
Land,
Region,
"Passager 1 fornavn ",
"Passager 1 efternavn",
"Passager 2 fornavn",
"Passager 2 efternavn",
"Passager 3 fornavn",
"Passager 3 efternavn",
"Om medlemmet ",
"Goldwing model ",
"Betalt år",
Betalingsmetode,
"Kontingent beløb",
"PBS nr ",
" Landekode",
Titel,
"Titel medlemskort",
bp_group_id,
bp_member_type,

and I do the search:

user_nicename=>Medlemsnummer,Fornavn=>Fornavn,Efternavn=>Efternavn,Adresse=>Adresse,Postnr.=>Postnr.,"By "=>By,

All other data is included, but not city (by).

If I download a full datasheet, all data is included, but in a specific column search I can't get that data to appear

What am I doing wrong? can you see it?
```
Plugin Author Javier Carazo
(@carazo)

4 months ago

Which kind of data is city? A standard metadata? If yes, this should work.

Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago

It is text data and i have added it to the system the same way as postnummer and adress and they are working and that is why i do not understand why it is not working with city, i have also tried it with Medlemsnummer there is a number, i could not get that to work as well.

Any idear what i can do, because i need this to mu customer 🙂

Plugin Author Javier Carazo
(@carazo)

4 months ago

So this is not a standard metadata, how did you add this?

Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago

You would guess that you would call this normal meta data.

These areas are added as extra profile fields, which I can see that the system can retrieve because some of them are listed on the page.

That’s also what makes it a bit strange 🙂

Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago

Would you like to have access to the site so you can see how things are structured there?

Plugin Author Javier Carazo
(@carazo)

4 months ago

Please delete your last comment. In this type of forum, NEVER offer access. It is a very serious security issue.

Regarding your problem, it is not normal metadata; it seems that you are using something like BuddyPress or similar to create the fields.

And indeed, the plugin does not yet offer support for exporting numeric data in this way when listing fields like the ones you use.

I will work to make it available in the future.

Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago

The ones I’ve found I have problems with from the list are the ones with “” around them, like

“Medlemsnummer”, – number
“By “, – text

I can’t quite understand that you say I use a different system, because inside your plugin many of them are shown how to write them. Too bad I can’t show you on a screenprint

The others are made in exactly the same way

Fornavn, – text
Efternavn, – text
E-mail, – text
Adresse, – text
Postnr., – numbers

And I can easily get something from those. It’s the ones with “” that won’t. Does that help you in any way

Plugin Author Javier Carazo
(@carazo)

4 months ago

So that’s the problem, that’s right, I never imagined that anyone could use a character like that in a field.

Surely in some filtering I do on the strings (necessary for security reasons, by the way) that character is lost when you use it, and that’s why it doesn’t work.

The solution is to reformulate the fields and use names without strange characters.

Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago

I agree that the “” should not be the lines, but they came by themselves. I did not name them. I just wrote City and Member Number when I named them. That’s why I’m wondering 🙂

Could it be due to spaces or other invisible characters that they appear on some and not others?

Plugin Author Javier Carazo
(@carazo)

4 months ago

Try changing those names where you created them. You probably copied and pasted them from somewhere else, and that’s where the problem originated.

Thread Starter wolfdesigndk
(@wolfdesigndk)

4 months ago

No, they are not copy pasted.. I have experienced that too many times that it causes problems.

I’ll see what I can do. Because the strange thing is that the data comes in so well if I ask it to fetch everything, but when I want to make a specification, it doesn’t come.

Plugin Author Javier Carazo
(@carazo)

4 months ago

Yes, I told you why. When you made a specification you have to send variables. Those variables have to be managed and the security filters remove all strange characters (because of SQLi) so as you are using bad characters inside names, it does not work.

Viewing 14 replies - 1 through 14 (of 14 total)

You must be logged in to reply to this topic.