Import Member Fields

[Josiah Wallingford]

When importing members, what fields can you import into IPB through a CSV?

• Username
• First Name
• Last Name
• Billing Address

Any of those? Any others?

[Josiah Wallingford]

43 minutes ago, Josiah Wallingford said:

When importing members, what fields can you import into IPB through a CSV?

• Username
• First Name
• Last Name
• Billing Address

Any of those? Any others?

I figured it out.

[Josiah Wallingford]

Anybody know how the address field needs to be formatted for member importing?

My CSV is setup with these as separate columns:

• Country
• Address 1
• Address 2
• City
• State
• Zip

Do I need to combine them all into one column on import? If so, what order to I put them in?

[Adriano Faria]

Yes, it’s a json value column. You will need a PHP script to make it. See how it is stored:

{"lat":-15.8111977,"long":-48.0657197,"addressLines":["16 Setor e Norte Qne 18"],"city":"Taguatinga","region":"Distrito Federal","country":"BR","postalCode":"72125-180"}