CasperVend 2/CSV Import

Data is Currently Exportable From

• SL Transaction History (.xml file)
• XStreetSL (historical data)
• SL Marketplace (.csv)
• HippoVend (.csv)
• BSM (.csv)

Where to Download the Sales Files

• SL Transaction History

1) Go to: https://secondlife.com/my/account/transactions.php

2) Click "Download XML" button

3) Save the file when prompted

• XstreetSL (for historical purposes)

1) Go to: https://www.xstreetsl.com/modules.php?name=Marketplace&file=adminsales

2) Log in if necessary

3) click "View CSV Output"

4) On the new page/tab, click File > Save As (or File > Save Page As)

5) On the save window, change .php to .csv, then click "save"

• SL Marketplace

1) Under "My Marketplace" go to: Merchant Home > Reports > Orders

2) Change the report dates to cover the dates of all of your sales

3) Click "Go"

4) Wait for page to update

5) Click "Download CSV" link, and save when prompted

• HippoVend

You MUST have a HippoVend vendor or product server out, "REGISTERED" with HippoVend website (use menu option) and with "ONLINE" status to continue! You don't need to have anything IN it, or products set up on the website - just a vendor or product server "registered" and in an "online" status. If an up-to-date product server will not connect, try any from 2009 or earlier and see if you have any better luck with the older ones.

1) Go to: http://www.hippo-tech-sl.com/secure/hippovend/sales.php

2) Log in

3) Click "Export to CSV" link on right side of page

4) On the new page/tab, click File > Save As (or File > Save Page As)

5) On the save window, change .php to .csv, then click "save"

• BSM (Bejambled Sales Monitor)

You may need to reactivate your account if it's currently inactive.

1) Go to https://www.bejamble.net/bsm_login.php and log in

2) Admin Menu > Import / Export > BSM Sales Data

3) This prompts you to save "MySalesExportBSM.csv"

4) Save to your hard drive

Splitting HippoVend's .CSV File Into Parts

---

NOTE: HippoVend caps exports in their .csv file at around 65,000 entries. It will seemingly let you download a higher number, however it will silently fail and only the first apx. 65,000 in your range will actually be exported.

You MUST have a HippoVend vendor or product server out, "REGISTERED" with HippoVend website (use menu option) and with "ONLINE" status to continue! You don't need to have anything IN it, or products currently set up on the website - just a vendor or product server "registered" and in an "online" status. If an up-to-date product server will not connect, try any from 2009 or earlier and see if you have any better luck with the older ones.

1) Log into HippoVend

2) Click "Sales Log" under "Vendors"

3) Make sure javascript (not java!) is enabled for hippo-tech-sl.com

4) On the right side, select "No grouping"

5) Click "Filter" button at the top of sales list

6) You'll be presented with a screen to select dates, products, etc.

7) Select the date range, and tick boxes as appropriate to include/exclude types of transactions

8) Click "OK"

9) Click "Export to CSV"

10) Save the resulting CSV page to your hard drive

Importing Data to CasperVend

1) Log in to CasperVend website

2) You should be on the Overview tab

3) Scroll down and look for the "Please use this form to upload your data" link

4) Click that

5) On the next page, browse to the location of the sales file on your hard drive

6) Click "Upload"

7) The system will digest the file and then present you with how it interpreted the data

This is the time to go over what it's showing you for accuracy!

8) If all looks good, save and continue. You will be presented with a message that the import process is complete.

The names portion of the import process will continue for a while as it resolves the name data that was sent and verifies it against actual usernames. You may see some blank or "unknown user" type entries on your statistics page while this is going on. THIS IS NORMAL and will resolve itself as names are matched up over the next several days.

9) Go back to the Overview page

10) At the top, you'll have an alert next to "3rd Party Sales Associations"

11) Click that link to go to the product wizard

12) Go through and verify each product it's showing you and make sure it is paired with the correct actual product. Change if necessary using the pulldown.

13) When you're done associating all the products, the site will give you a completion message.

14) All set!

CSV Updates

2013-Jul-03 From a notice by Casper Warden:

"Just an advisory to let you know that the format of the "CSV" file exportable from the CasperVend stats page has changed. The date has been changed to a format which is compatible with international versions of Excel, such as:

"2013-Jul-01 20:11"

We've also expanded from "price" to include the "gross" , "net" and "received" columns."

FAQ / Troubleshooting

Q. Sometimes my statistics say "Direct Delivery" and sometimes they say "SL Marketplace" - but I don't have a MagicBox. Why does it do this?

A. As of June 2013 forward, all Marketplace data will say "SL Marketplace" for the source, regardless of whether it's a CSV upload or ANS. All old data that said "Direct Delivery" should be converted over to read "SL Marketplace" instead. This is to make it easier for the duplicate checker to reconcile actual duplicates when uploading a .csv file.

Q1. The system I'm using isn't covered here. How can I import MY data file?

Q2. I do my own recordkeeping on my inworld sales. How can I get data from CasperVend to my system (or vice-versa)?

A. Talk to Casper Warden directly - if he's offline, send him an IM, wait a minute or two for an autoresponder link to come back, and then take THAT link to the website and fill out the webform. Put as many details as you can in the webform to make it easier for him to respond appropriately. Any arrangements that can be made, need to done with the assistance of Casper himself.

Q. I've got a bunch of sales from "Unknown / Banned User" entries in my statistics - wtf?

A. This just means that the names haven't been resolved yet. They should change from "Unknown / Banned" to an actual name within the next few days. It does not mean the user is banned from the system - if they were actually banned, the transaction would not complete.