RPOWER.Gift CSV File Specification

From RPOWERWiki

Jump to: navigation, search

Overview

Once upon a time, an order had been completed, the RPOWER.Gift pagelet generates a seriesof csv files to document the order. These files may then be emailed to any number of recipients.

For each order, the RPOWER.Gift pagelet generates 4 csv files:

Cards.csv 
a card level breakdown of the order
Items.csv 
an order level breakdown. Card Ranges are broken out by price, so if a range of cards was ordered for a recipient at $10.00 and another range of cards was ordered for the same recipient at $15.00, those would appear as two separate lines in this file.
Recipient.csv 
a recipient level breakdown of the order
Sender.csv 
a customer oriented view of the order

The name of each files starts with GiftCardOrder, then contains the date and time of the order, the ticket number, and then a suffix indicating the detail of the data in the file. For example, the file name GiftCardOrder-20061214-144832-06400010555-Cards.csv indicates that this order occurred on December 14th, 2006 at 2:48:32 pm, is ticket number 064000105555, and shows card detail information.

CSV Field Definitions

This list contains all the fields that might appear in the csv files generated by the RPOWER.Gift pagelet. However, each file might not contain all of these fields.

Card 
the number of the card issued to this recipient
CCNumber 
last 4-digits of the credit card number
Date / Time 
date and time of the order
High Card 
the number of the last (highest) numbered gift card purchased
Low Card 
the low card is the number of the first (lowest) numbered gift card purchased
Order Number 
an internal number used by RPOWER to track the gift card order
Price 
the price of each card ordered
Quantity 
the number of cards ordered
RAddress1 
recipient address line 1
RAddress2 
recipient address line 2
RCity 
recipient city
RComment 
a message for the recipient
REmail 
recipient email
RExt 
recipient phone extension
RFor 
who the card is for (not necessarily the same as the RName; could be a nickname or familiar name)
RFrom 
who the sender of the card is from (provided for nicknames or familiar names, perhaps)
RName 
the recipient name
RPhone 
recipient phone
RState 
recipient state
RZIP 
recipient ZIP Code (5 digit)
SAddress1 
sender address line 1
SAdderss2 
sender address line 2
SCompany 
sender company
SCity 
sender city
SEmail 
sender email address
SExt 
recipient phone extension
Shipping 
cost of shipping the card (this option can be set in the shipping.ini file)
SName 
sender name
SPhone 
sender phone
SState 
sender state
SZIP 
sender ZIP code (5 digit)
Total 
the total of the order
Views
Personal tools