Exporting points from Sebenza Points Redemption Manager

[lesliekirk]

The Sebenza Points Redemption Manager has the ability to import points but I need to export the points from the live store into the dev store that is almost ready to go live. Does anyone have a method to export the points?

The import file needs to contain two fields - users login name and the numerical value for the points.

I've also opened a support ticket with Sebenza but I thought I'd check here too.

Leslie

[Nerd Boy Inc]

Re: Exporting points from Sebenza Points Redemption Manager

Dear Leslie,

Use PHPmyadmin to make a dump of the Table and build a file from it.

Or, I could write quick script to Export it for you.

[Dan - Glendale Designs]

Re: Exporting points from Sebenza Points Redemption Manager

Variation of the example provided on Sebenza's site: https://sebenza.freshdesk.com/suppor...y-for-customer

SELECT
    s01_Customers.login,
    s01_SS_POINTS_cust.total
FROM
    s01_Customers
INNER JOIN
    s01_SS_POINTS_cust
ON
    s01_Customers.id = s01_SS_POINTS_cust.cust_id