|
For your
security, this function is only available to CRYPTOCard
users.
The Batch Transfer
function allows e-Bullion® account holders to upload a file with
a list of transactions to be completed all at one time. The
purpose of this tool is to save time and effort for e-Bullion® users
who periodically make payments to a large number of accounts.
How
to do multiple (batch) transfers
1. Enter your transfer
data into your saved or downloaded
spreadsheet. Double-check the accuracy of the account numbers
and amounts.
The form fields are not
case sensitive. "Gold" works as well as "GOLD" or "gold",
etc.
If you have a long list
of transfers it may be helpful to print your list out so you can
refer to it in step 4.
2. SAVE THE FILE AS A CSV
FILE. To do this, click File >
Save As and change the file type to CSV (it is in the
drop down menu). Save the file on your hard drive where you can
easily find it. (NOTE: Remember that the
first row is assumed to be column headings and not included in the
transfer.)
3. Log into your e-Bullion®
account and click the "Batch Process" link. Next to the box that
says File to upload you can click the Browse
button to search your hard drive and select the CSV
file that you saved. You should see the path and name of your file
in the form box.
4. Click the button to
Preview This Transfer. You will be shown a list of all your
transfers with the name on each account and the amount. Please
check all your entries before you compete the transaction.
Each batch transfer
may take up to five (5) minutes to complete and display a Transaction
Successful page. NOTE: Please
be patient and do not resubmit the same request multiple times. |
IMPORTANT NOTES:
All transactions are
final and non-reversible. If you make a mistake you can NOT undo
it.
The Batch Transfer function
is limited to 1,000 transfers per file. If you have more than 1,000
transfers to do then you will need to break your list up into blocks
of 1,000 or less.
How
to create a CSV file from scratch
In order to make Batch
Transfers, you must first create a CSV file with all of the required
information for each transaction. (CSV means "Comma Separated Values"
and is a list of data fields with a comma separating each field.)
It is simple to make a CSV file using the Microsoft Excel spreadsheet
program (or any other office spreadsheet program).
STEP 1
Open a new file in Excel. Go to FILE> NEW> WORKBOOK
STEP 2
You will need to make five (5) columns:
Name Column A: To-Account
Name Column B: Metal/e-Currency
Name Column C: Unit
Name Column D: Amount
Name Column E: Memo
STEP 3
Save your file. Click >Save As. Name the file and
under Save as type: choose CSV (Comma delimited) (*.csv)
STEP 4
Enter your transfers
Column A: Enter the destination account number of the transfer.
Column B: Enter the metal/e-Currency® that you are transferring.
Valid choices:
gold, Gold, silver, Silver, e-currency, ecurrency.
Column C: Enter unit of transfer. Valid choices for precious metals:
USD$, Troy Oz, Grams, toz, g.
Valid choices for e-Currency®:
USD$.
Column D: Enter the amount. Omit
commas and dollar signs. (Example: 1250.00)
Column E: Enter memo of your choice relating to the transaction. Do not include commas in your memo.
STEP 5
Save your file (with a new name). Click Save As and
under Save as type: choose CSV (Comma delimited) (*.csv)
Note: if you are using Excel, it will automatically try to save
the file in Excel format (*.xls). The file must be saved in .csv
format only to upload correctly. You now have a ready-to-use file
for all your batch transfers.
EXAMPLE of spread sheet layout:
| |
A |
B |
C |
D |
E |
| 1 |
To-Account |
Metal/ e-Currency |
Unit |
Amount |
Memo |
| 2 |
A40253 |
GOLD |
USD$ |
2450.00 |
for payment of invoice #0012345 |
| 3 |
A50045 |
silver |
TROY OZ |
3 |
for purchase on 02/28/03 |
| 4 |
A64526 |
GOLD |
GRAMS |
1 |
gift transfer |
| 5 |
A64526 |
e-currency |
USD$ |
100 |
For Bob |
|