CasperVend 2/CSV Import

Schaue hier in Deutsch!

Where to Download the BSM Sales Files

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

Where to Download the HippoVend Sales Files

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"

Splitting HippoVend's .CSV File Into Parts

---

NOTE: HippoVend caps exports in their .csv file at roughly 65,000 entries. It will seemingly let you download a higher number, however it will silently fail and only the first roughly 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) If you use adblockers or "no script" utilities, 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

Where to Download the SL Sales Files

• SL Transaction History

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

2) Click "Download CSV" 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

Marketplace Notes

---

The .csv file you download must be the ORDERS .csv, not the transactions.

It also must be from the english side, so if you natively use another language option, please change it to english BEFORE going to the orders page so that you download the english version.

Importing Sales 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, you will see a button for "Start a New Import"

6) Click that

7) The next page will give you the option to browse to a .csv file. READ THE WARNING!

8) When you're ready, load the file, then click "UPLOAD".

9) On the next page, you will see a variety of field names, and pulldown selectors next to each one.

10) If you have uploaded a .csv from a recognized source (any of the ones on this wiki page) then DO NOT CHANGE ANYTHING.

11) Click "VALIDATE NOW"

12) You will get a little black popup indicating that it is working on the file, and then present you with a table.

13) If you do NOT get the little black popup, you need to enable javascript (not java, but javascript) for the site and reload the page.

14) You will be presented with information in a table. Click "PROCEED" if everything looks good.

15) If you click "CANCEL" you'll be presented with a confirmation screen.

16) You'll arrive back at the main Third Party Import page

17) Here, you can "VIEW RECORDS", which will take you to a new page showing the import data.

18) If everything looks good, click the "FINALISE" button.

19) Click back to the OVERVIEW page.

20) Check the "System Status" box - you'll have a red link in there with "(number of) Issues" - click that

21) On the next page, you'll see a list of the imported products.

22) Click the "Associate" link to bring up a popup with a pulldown selector.

23) Select the appropriate product listing, and click "ASSOCIATE".

24) Product will immediately move to the "associated" list.

25) If you have demo items from Marketplace that you don't want associated to a product (because this determines whether it can be redelivered!) then click "Hide/Ignore"

26) You may unassociate by going to the "associated" list and clicking the red "x".

27) You may UNhide a product by going to the "hidden" list and clicking "Unhide".

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."

Limitations

The sales data import function of CasperVend will ONLY accept sales data. This function cannot accept data about product setup, profiles, vendor conversion or anything else beyond sales data.

DUPLICATE DETECTION: Duplicates can only be detected when they come from the same source. Times between imports from different systems (for example, between E2V and Marketplace) will be slightly different, and use different identifiers for the same transactions.

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.