Skip to Content
0
Former Member
Aug 02, 2017 at 09:45 PM

How to export customer details on the basis of the email ids present in a CSV

237 Views

Hi, my problem statement is - to fetch the uid and name on the basis of uids(A CSV which has a list of uids) that I input.
Now this can be done by following query:
"#% impex.setTargetFile( ""Customer.csv"" );" insert_update Customer;uid[unique=true];name; "#% impex.exportItemsFlexibleSearch( ""select {pk} from {Customer} where {uid} in ('testcustomer1@gmail.com','testhello1@gmail.com')"");"
The result in csv will be the following:
# uid;name
testcustomer1@gmail.com;Test1|Customer1
testhello1@gmail.com;Test|Hello

But, the issue is that for 2 uids its easy, for 600k customers if to fetch out of 1200k is tough. I have a CSV of email ids from which I wish to refer here so that the list can be used directly somehow instead of manually adding 600k customers.
Kindly provide a solution for the same.
Thanks in advance.