Portal | Homepage | Blog

Export Selected Customer Data from RMS to a CSV


#1

To export your e-mail data, perform the following steps in RMS:

Open RMS Store Operations Administrator and connect to your database.
Select Query, then New (or press Ctrl+N).
Enter the following query:

select EmailAddress as "Email Address", FirstName as "First Name", LastName as "Last Name", Company as "Company Name", PhoneNumber as "Home Phone", Address as "Address Line 1", Address2 as "Address Line 2", City as "City", State as "State", Country as "Country", Zip as "Postal Code" from customer where len(EmailAddress) > 0
 
To run your query, select Query, then Run, or press F5. The query results will be displayed.
Select File, then Export. Save the file using the name customers.csv.

Next, to import this data into Constant Contact, perform the following steps:

  • Using your login credentials, sign into Constant Contact at http://www.constantcontact.com/login.jsp.
  • Select the Contacts tab.
  • On the My Contacts page that is displayed, select the Add/Import option.
  • Select the list into which you wish to import the RMS data, then click Next.
  • Select Import my list from a file on my computer, then click Next.
  • Click the Browse button and locate the customers.csv file on your computer.
  • Click the Submit Data button.
  • Read and confirm (by selecting the checkbox) the permission requirements.
  • Click Submit.
  • By viewing the Activity page, you can monitor the progress of your import, as well as see any errors that occur during the process.

#2

Is it possible to run a similar query to export Item Data from RMS to a CSV please?


#3

Open RMS Store Operations Administrator and connect to your database.
Select Query, then New (or press Ctrl+N).
Enter the following query:

select * from item

To run your query, select Query, then Run, or press F5. The query results will be displayed.
Select File, then Export. Save the file using the name item.csv.


#4

That’s brilliant thank you very much.
Just one small problem the Departments and Categories are coming up as numbers.
Is there any way to display these as the names please.
Many thanks


#5

Hi Rowan,

You’ll need to join the other table by linking the mentioned id’s to the id fields in those two respective tables.

I haven’t tested but I believe this should do the trick.

SELECT itemtable.*, dep.name as department_name, cat.name as category_name
FROM [item] itemtable
LEFT JOIN [department] dep ON itemtable.departmentid = dep.id
LEFT JOIN [category] cat ON itemtable.categoryid = cat.id


#6

Hi Andy
Another brilliant answer thank you - works a treat.
Just to confirm this adds two extra columns at the end with the named Department and Category.
Many thanks for your help.


#7

At the risk of being a pain, I also need to add the supplier name and barcode (alias) if at all possible.
Thanks
Rowan


#8

From memory it’s possible to have multiple suppliers per product so only the last supplier is stored/updated in the item table. If that’s all you need then this should do it.

SELECT itemtable.*, dep.name as department_name, cat.name as category_name, sup.suppliername, barcode.alias as barcode
FROM [item] itemtable
LEFT JOIN [department] dep ON itemtable.departmentid = dep.id
LEFT JOIN [category] cat ON itemtable.categoryid = cat.id
LEFT JOIN SUPPLIER sup ON itemtable.supplierid = sup.id
LEFT JOIN ALIAS barcode ON barcode.itemid = itemtable.id


#9

Thanks again Andy that’s great. I’ve just tested it and it works fine.
Many thanks again for sorting me out with this.
Regards
Rowan