Some fields not importing

Permalink Browser Info Environment
I'm trying to figure out why some fields are not importing from the CSV. In particular the first name, last name and address filed. I'm not sure what to do to get them to map properly, but the field names in the spreadsheet seem to match the attributes. Can you please give me some direction on that? See attachment.

Also, when I re-import to fix that will it recognize duplicates and just update the current user information?

1 Attachment

Type: Pre-Sale
Status: Resolved
pixo
View Replies:
pixo replied on at Permalink Reply
pixo
Wanted to make sure you saw my previous support question.
ampersandapps replied on at Permalink Reply
ampersandapps
Hi,

Can you send me your CSV file and I can try to give you some direction?

And send me some screenshots of your attribute setups specifically?

Thanks.
pixo replied on at Permalink Reply
pixo
If you look at the screenshot in my first messages attachment you'll see the CSV file and a user profile.
pixo replied on at Permalink Reply
pixo
I think I might have recognized what I've done wrong while looking at my screen shot. I assume that the column titles should be the handles rather than the field names, correct?

Can you answer my second question as to how the add-on handles re-imports of data. When a duplicate is found does it just update the current record or will it try to add a new user?
ampersandapps replied on at Permalink Reply
ampersandapps
Yes, definitely use the handles.

As for the update. This add-on (since it's just an import) detects if the user exists in the system and if they do, it ignores them and moves on to the next user in the CSV.

Please let me know if you have more questions/issues.

Thanks!

concrete5 Environment Information

# concrete5 Version
Core Version - 8.4.3
Version Installed - 8.4.3
Database Version - 20180716000000

# concrete5 Packages
All In: The Advanced Member Import Add On by ampersandApps (1.0.4), Automatic Email Obfuscator (2.0.1), Epic (0.9), HTML+PHP Code Block (1.0.2), List files from set (1.0.13), Login/Logout Link (1.0), Membership Subscriptions (3.0.2), PDF Viewer (1.0.1), ProBlog (1.0.5), Responsive Embed (1.0.1), SVG Social Media Icons (0.9.9), Vivid Simple Accordion (1.0.1)

# concrete5 Overrides
None

# concrete5 Cache Settings
Block Cache - Off
Overrides Cache - Off
Full Page Caching - Off
Full Page Cache Lifetime - Every 6 hours (default setting).

# Server Software
Apache/2.4.35

# Server API
cgi-fcgi

# PHP Version
5.6.38

# PHP Extensions
bcmath, bz2, calendar, cgi-fcgi, Core, ctype, curl, date, dba, dom, ereg, exif, fileinfo, filter, ftp, gd, gettext, gmp, hash, iconv, imap, intl, json, ldap, libxml, mbstring, mcrypt, mhash, mssql, mysql, mysqli, mysqlnd, odbc, openssl, pcntl, pcre, PDFlib, PDO, pdo_mysql, pdo_pgsql, pdo_sqlite, pgsql, Phar, posix, pspell, Reflection, session, SimpleXML, soap, sockets, SPL, sqlite3, standard, sysvmsg, sysvsem, sysvshm, tidy, tokenizer, wddx, xml, xmlreader, xmlrpc, xmlwriter, xsl, zip, zlib

# PHP Settings
max_execution_time - 30
log_errors_max_len - 1024
max_file_uploads - 25
max_input_nesting_level - 64
max_input_time - 60
max_input_vars - 1000
memory_limit - 128M
post_max_size - 50M
sql.safe_mode - Off
upload_max_filesize - 50M
ldap.max_links - Unlimited
mssql.max_links - Unlimited
mssql.max_persistent - Unlimited
mssql.max_procs - Unlimited
mssql.textlimit - Server default
mysql.max_links - Unlimited
mysql.max_persistent - 10
mysqli.max_links - Unlimited
mysqli.max_persistent - Unlimited
odbc.max_links - Unlimited
odbc.max_persistent - Unlimited
pcre.backtrack_limit - 1000000
pcre.recursion_limit - 100000
pgsql.max_links - Unlimited
pgsql.max_persistent - Unlimited
session.cache_limiter - <i>no value</i>
session.gc_maxlifetime - 7200
soap.wsdl_cache_limit - 5

Browser User-Agent String

Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/70.0.3538.77 Safari/537.36

Hide Post Content

This will replace the post content with the message: "Content has been removed by an Administrator"

Hide Content

Request Refund

You may not request a refund that is not currently owned by you.