CasperVend 2/CSV Import: Difference between revisions

From CasperTech Wiki
Jump to navigation Jump to search
No edit summary
 
(28 intermediate revisions by 3 users not shown)
Line 2: Line 2:
   |__TOC__
   |__TOC__
   |}
   |}
 
[[File:German_flag.gif]] [[CasperVend 2/CSV Import/DE | Schaue hier in Deutsch!]] 
== '''<span style="color:#00528c">Data is Currently Exportable From</span>''' ==
== '''<span style="color:#00528c">Where to Download the BSM Sales Files</span>''' ==
::: ''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
 
== '''<span style="color:#00528c">E2V Transactions</span>''' ==
 
=== From Self-Hosted ===
----
: 1. You will need to contact DavidThomas to get a copy of the sales data from your webhost
: 2. Contact Casper to verify whether it's currently importable
 
=== From E2V servers ===
----
: See the '''[[CasperVend_2/EasyVend#E2V_Migration:_Exporting_Your_Data | EasyVend page]]''' for instructions
: Talk to DavidThomas Scorbal about getting even older data from the servers.
 
== '''<span style="color:#00528c">MD Vend Notes</span>''' ==
 
When importing sales from MD Vend, you must EXCLUDE the "Status" column (set it to " --- IGNORE ---").
 
If you don't do this, all your sales will be imported as "failed"!


:* SL Transaction History (.xml file)
== '''<span style="color:#00528c">SL Transactions / Sales Files</span>''' ==
:* XStreetSL (historical data)
:* SL Marketplace (.csv)
:* HippoVend (.csv)
:* BSM (.csv)
           
== '''<span style="color:#00528c">Where to Download the Sales Files</span>''' ==
    
    
:* '''SL Transaction History'''
:* '''SL Transaction History'''
:: 1) Go to: https://secondlife.com/my/account/transactions.php
:: 1) Go to: https://secondlife.com/my/account/transactions.php
:: 2) Click "Download XML" button
:: 2) Click '''"Download CSV"''' button
:: 3) Save the file when prompted
:: 3) Save the file when prompted
                      
                      
Line 21: Line 38:
:: 1) Go to: https://www.xstreetsl.com/modules.php?name=Marketplace&file=adminsales
:: 1) Go to: https://www.xstreetsl.com/modules.php?name=Marketplace&file=adminsales
:: 2) Log in if necessary
:: 2) Log in if necessary
:: 3) click "View CSV Output"  
:: 3) click '''"View CSV Output"'''
:: 4) On the new page/tab, click File > Save As  (or File > Save Page As)  
:: 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"
:: 5) On the save window, change .php to .csv, then click "save"
Line 27: Line 44:
:* '''SL Marketplace'''
:* '''SL Marketplace'''
:: 1) Under "My Marketplace" go to: Merchant Home > Reports > Orders
:: 1) Under "My Marketplace" go to: Merchant Home > Reports > Orders
:: 2) Change the report dates to cover all of your sales
:: 2) Change the report dates to cover the dates of all of your sales
:: 3) Click "Go"
:: 3) Click "Go"
:: 4) Wait for page to update
:: 4) Wait for page to update
:: 5) Click "Download CSV" link, and save when prompted
:: 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 ===
== Marketplace Notes ==
----
----
''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.''  
The .csv file you download '''must''' be the ORDERS .csv, not the transactions.  
 
'''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 65,000 in your range will actually be exported.


::  1) Log into HippoVend
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.
::  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


== '''<span style="color:#00528c">Importing Data to CasperVend</span>''' ==
== '''<span style="color:#00528c">Importing Sales Data to CasperVend</span>''' ==


:: 1) Log in to CasperVend website
:: 1) Log in to CasperVend website
Line 74: Line 65:
:: 4) Click that
:: 4) Click that
      
      
:: 5) On the next page, browse to the location of the sales file on your hard drive
:: 5) On the next page, you will see a button for "Start a New Import"
   
 
:: 6) Click "Upload"
:: 6) Click that
   
 
:: 7) The system will digest the file and then present you with how it interpreted the data
:: 7) The next page will give you the option to browse to a .csv file. READ THE WARNING!
   
 
::: ''This is the time to go over what it's showing you for accuracy!
:: 8) When you're ready, load the file, then click "UPLOAD".
           
 
:: 8) If all looks good, save and continue. You will be presented with a message that the import process is complete.  
:: 9) On the next page, you will see a variety of field names, and pulldown selectors next to each one.
       
 
::: ''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.
:: 10) If you have uploaded a .csv from a recognized source (any of the ones on this wiki page) then DO NOT CHANGE ANYTHING.
   
 
:: 9) Go back to the Overview page
:: 11) Click "VALIDATE NOW"
   
 
:: 10) At the top, you'll have an alert next to "3rd Party Sales Associations"  
:: 12) You will get a little black popup indicating that it is working on the file, and then present you with a table.
   
 
:: 11) Click that link to go to the product wizard
:: 13) If you do NOT get the little black popup, you need to enable javascript (not java, but java'''script''') for the site and reload the page.
   
 
:: 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.  
:: 14) You will be presented with information in a table. Click "PROCEED" if everything looks good.  
       
 
:: 13) When you're done associating all the products, the site will give you a completion message.  
:: 15) If you click "CANCEL" you'll be presented with a confirmation screen.  
       
 
:: 14) All set!
:: 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".
 
== '''<span style="color:#00528c">CSV Updates</span>''' ==
== '''<span style="color:#00528c">CSV Updates</span>''' ==
'''2013-Jul-03 '''From a notice by Casper Warden:  
'''2013-Jul-03 '''From a notice by Casper Warden:  
Line 103: Line 116:
::"'''''2013-Jul-01 20:11'''''"  
::"'''''2013-Jul-01 20:11'''''"  
:We've also expanded from "price" to include the "gross" , "net" and "received" columns."
:We've also expanded from "price" to include the "gross" , "net" and "received" columns."
== '''<span style="color:#00528c">Limitations</span>''' ==
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.


== '''<span style="color:#00528c">FAQ / Troubleshooting</span>''' ==
== '''<span style="color:#00528c">FAQ / Troubleshooting</span>''' ==

Latest revision as of 10:45, 15 July 2020

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

E2V Transactions

From Self-Hosted


1. You will need to contact DavidThomas to get a copy of the sales data from your webhost
2. Contact Casper to verify whether it's currently importable

From E2V servers


See the EasyVend page for instructions
Talk to DavidThomas Scorbal about getting even older data from the servers.

MD Vend Notes

When importing sales from MD Vend, you must EXCLUDE the "Status" column (set it to " --- IGNORE ---").

If you don't do this, all your sales will be imported as "failed"!

SL Transactions / 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.