My Hobbysite Export

[deadone]

hi all..can any1 using the mhs inform me on how to export my list so its readable.
i make the normal backups but was wandering if i can export to something like text so its in order etc
when i do it text is all over the place

Mick

[metalbell]

If you go under your MySQL management you can export out the tables to .CSV or Excel

[deadone]

yeah i can do that.
its after i have exported it.the text is all over the place and not something i can use as a list

Mick

[sjmike]

If you export to a unicode CSV and then open it in excel, just delete the columns you don't need and concatenate other fields into a single column/field. Typically the setlist field is what it going to mess things up with all of its line breaks and color codes. Takes a little bit of work, but you can make it into a good looking list.

[deadone]

ok thank you mike,
ill try that out and see how it goes

Mick

[deadone]

hi mike, tried what you suggested but i have added a screenshot of what im talking about, its all over the place


upload photo

Mick

[forka2k]

Hey Mick, try to export from SQL as CSV for MS Excel and then it will open just fine.
Other option is to import this CSV file in Excel and then it will ask you a few questions select "Delimited" and then "Semicolon" and it should be fine.

[deadone]

Hey Mick, try to export from SQL as CSV for MS Excel and then it will open just fine.
Other option is to import this CSV file in Excel and then it will ask you a few questions select "Delimited" and then "Semicolon" and it should be fine.

the above screenshot was done using that method.
exported to CSV for MS Excel and thats how it came out.

Mick

[forka2k]

You can see that it work for me without problem, I don't know where is the problem:



Did you try to use import instead of open?

[deadone]

that could be my problem.
i didnt have an import option.
im using microsoft excel 2010

Mick