search

wpsharks / s2member-kb

The s2Member® and s2Member® Pro Knowledge Base
9 stars 4 forks source link

Advanced Import/Export Tools #121

Open jaswrks opened 9 years ago

jaswrks commented 9 years ago
KB Article Creation Checklist

Additional TODO list items go here.

Markdown File: http://wsharks.com/1x3rLLA Published KB Article: http://s2member.com/kb-article/advanced-importexport-tools/

rockindoublej commented 9 years ago

Hi Jason,

I don't see anywhere in s2member where it says "Advanced Export". It would be most helpful if you would define what advanced export is in s2member so we know we are using the right tool.

I see user/member csv exportation and s2member options import/export but no advanced export?

I did eventually find the advanced import/export but not until after I failed with the regular import procedure, then I failed with the advanced import several times before getting it to work finally. It still did not import their user level even though it is in the csv with the proper heading. That is all corrected now but I can't help but feel clearer instructions to start with would have helped me cut down the learning curve.

jaswrks commented 9 years ago

@rockindoublej Thanks for the feedback :-)

HughSarjeant commented 6 years ago

Custom Fields w/ Array Values: Advanced Import/Export Tools

You say "... If you don’t escape double quotes your CSV file will be corrupted. ..." This would seem to provide quite a penalty if you get it wrong. But in relation to e.g. "... one of your Custom Field columns in the export file contains something like: ["Fishing", "Sports", "Computers"], this is three separate values that form a simple array in JSON format.", an example of such JSON would be very helpful.

E.g. what comes out of Export, for an array variable, such as a:1:{i:0;s:3:"Man";} does not look like JSON as illustrated by e.g. http://www.csvjson.com/csv2json [ { "album": "The White Stripes", "year": 1999, "US_peak_chart_post": "-" },