I export a user table from Access to a CSV file
select ; as field separator
selec " " as text separator
try to Upload a CSV file to User Import
see attachment bellow, the module doesnt recognize my fields

how you guys use this module btw ? =)

CommentFileSizeAuthor
error.jpg24.5 KBAlan Oliveira

Comments

robert castelo’s picture

robert castelo commented
Status: Active » Closed (won't fix)

Read the README.txt file of the module for info on CSV formats supported.

I don't know Access, but you may need to import the data into Excel and save it as a CSV file.

Alan Oliveira’s picture

Alan Oliveira commented

I have exported access to excel, and then save the excel file to csv, even so, dont work
and I'd also installed on sites/all/modules

but still, dont work, i got the same error, cant match the fields

robert castelo’s picture

robert castelo commented

Did you read the read the README.txt file and check you saved in the right format?

Alan Oliveira’s picture

Alan Oliveira commented

yap man, I read and tried, doesnt work as well

robert castelo’s picture

robert castelo commented

There's a sample csv file included with the module you could use to do a test import, if it doesn't work you'll know it's something to do with the set up of your system. If it does work you'll know it's the format your file is saved in that's the problem.

Alan Oliveira’s picture

Alan Oliveira commented

Your sample really works
then I try the follow

open Excel
open your sample.txt and use the Excel tools to make similar to a worksheet
save as csv
try to import the sample.csv within your module
and the attempt failed (similar to the jpg on the attachment above)

Alan Oliveira’s picture

Alan Oliveira commented

Yo man i figgured out how it works by seen your example file and I realized what

Since Im living on Brazil, the decimal separator here is ,
and on US, the decimal separator is .

I only export csv using ; and " "
now I change the access way of exporting to , and formating the databank to work proprerly... so far i fig that fields that contains comma on it (such on address) fails on export and mess with the import process... still work on that (using find and replace at will on access databank)

when i finish the tests i shall give a feedback for you (of a mass import among 5.000 users with dozens of profile fields)

Alan Oliveira’s picture

Alan Oliveira commented

#1 First Feedback of the morning

Man, some notices

Dates = doesnt work with cck dates =/
Combobox = work, but the text have to be one of the allowed values
áàâãäèéêëíìîïóòöôõùúûüñç " ' ª º - and others special characters = crop your text or missing some chars

still got more tests to do, but gonna continue tml

robert castelo’s picture

robert castelo commented

Use 5.x-2.0-beta4 instead, which has numerous bug fixes but needs testing.

Dates are not handled on either branch.

robert castelo’s picture

robert castelo commented

If you find any bugs check the issue queue to see if they've already been reported, if not open an issue for each bug (separate one per bug).

Alan Oliveira’s picture

Alan Oliveira commented

Here goes the first error

* warning: array_merge() [function.array-merge]: Argument #2 is not an array in C:\xampp\htdocs\cefe5\public_html\sites\all\modules\user_import\supported\nodeprofile.inc on line 28.
* One column of the csv file must be set as the email address.
* Database fields can only be matched to one column of the csv file.

the configuration saved settings doesnt work apropriatedly =/
the configuration saved doesnt work so far on dev.module... gotta shut back to normal module

robert castelo’s picture

robert castelo commented

why don't you just create new settings?

Alan Oliveira’s picture

Alan Oliveira commented

I'd done that too man...

Alan Oliveira’s picture

Alan Oliveira commented

Database fields can only be matched to one column of the csv file.

what a unstable module!! =/