Differences

This shows you the differences between two versions of the page.

--- addons:bulk_uploader:format_tips [2012/01/16 16:41]
matt created
+++ addons:bulk_uploader:format_tips [2015/10/28 22:01] (current)
geomatt
@@ Line 1: / Line 1: @@
-=====Bulk Uploader Formatting Tips=====
+======Bulk Uploader Formatting Tips======
 Certain fields in the Bulk Upload process require their data to be entered in specific ways that are not always immediately obvious. This page should help to document those:
-===Price===
+====="List" Keyword=====
+When the word "List" is used in a column name in the bulk uploader (as in "Images List" or "Locations (Terminal Regions) [List]"), it indicates that field accepts a comma-delimited list of multiple values. Note that item order within a **List** field is preserved (e.g. the ultimate Display Order of images added via **Image List** will match the order in which they appear in the **List**)
+=====Price=====
 The **price** field is **numeric-only**, and its numbers should be entered in American-style syntax and without a thousands separator. In other words, "$15564.85" and "15,564.85" are both **incorrect** -- the value in that case should simply read "15564.85"
@@ Line 12: / Line 16: @@
-===Category Name/ID===
+=====Category Name/ID=====
 When uploading to multiple categories from a single file, you must specify the category for each listing. This must be in a single column, and can take the format of either the category name or ID number.
@@ Line 19: / Line 23: @@
-===Date-type Optional Fields===
+=====Date-type Optional Fields=====
 Optional Fields of type "date" should have their date specified in the format YYYYMMDD. January 16, 2012, for instance, would be 20120116
+===== Multi-Level Fields =====
+With multi-level fields you only need to include the lowest level value within the csv data.  For example if you had a multi-level field for Make and Model of cars.  The first level would be Make and the second level would be model.  So if you had data like this:
+  Chevrolet (make) > Impala (model)
+You only need to include "Impala" within the  csv data and assign that field to the multi-level field.  If for instance you happen to include make in one column and model in another column of your csv data just assign the column that contains the model to the multi-level field in the bulk upload configuration and the software will assign "Impala" at the "model level" and auto assign "Chrevrolet" at the make level.
+=====Youtube Video List=====
+See the notes on the **List** keyword above. Data to this field may be in any format supported by the front-end video uploader. E.g., both "http://www.youtube.com/watch?v=dQw4w9WgXcQ" or simply "dQw4w9WgXcQ" are acceptable inputs.
+=====Locations (Terminal Regions) [List]=====
+You may use the bulk uploader to specify regions for each listing, for use with the Geographic Navigation addon. To do so, specify the lowest-level region for each listing. You can specify either the Region ID number (shown next to each region in the Geographic Setup > Regions page) or the name of the region in text form. If your site has multiple regions with identical names, it is recommended to use ID numbers instead of names, to ensure exactly the correct regions are used.
+This can be used to set a primary Region, as well as Additional Regions, and will preserve the order of entered data. For example, given the data point "Dallas, Forth Worth, Waco" the listing's primary Region will be Dallas, while it will have Fort Worth and Waco as Additional Regions.
+=====Category-Specific Checkbox List=====
+The "Checkbox List" will appear as an option during Step 2, in the Category Questions dropdown.
+This is a quick way to set multiple "checkboxes" in a listing to true. You will need to know the internal ID number of each checkbox you want to set. This number appears in (parenthesis) after the Name of each question on the Category Questions admin page.
+The Checkbox List accepts a comma-separated list of questions that should be marked as on. For example, if you're using the default questions packaged with the Automobiles category, and you want to upload a car that has GPS, OnStar Technology, and Air Conditioning, you could enter "152,153,166" in the Checkbox List field.
+=====Storefront Category ID#=====
+You can specify which of a user's storefront categories a bulk uploaded listing should go into. This requires the use of that category's ID number. The ID number may be found in the URL of the given category's page on the front-end. For instance, with a URL of **http://example.com/index.php?a=ap&addon=storefront&page=home&store=50&category=379**, you would enter "379" in the bulk upload source file.
+=====Cost Options=====
+====Option Group #: Group Name====
+This should be a single text string containing the name of an option group
+e.g. To add user selections for shirt size, enter:
+**Shirt Size**
+<tip c n>Tip: for the next four fields, be sure to use a consistent order within each field. To help illustrate this point, we'll demonstrate a single set of options throughout.</tip>
+====Option Group #: Option Names====
+A comma-separated list of names for each option in this group, in the correct display order
+e.g. To add Small, Medium, and Large as choices for shirt sizes, enter:
+**Small,Medium,Large**
+====Option Group #: Option Costs====
+A comma-separated list of added costs for each option in this group, in the correct display order. Numbers only -- do not include precurrency or postcurrency symbols
+e.g. To add no cost to the buyer for choosing a Small or Medium shirt, and $0.50 for choosing Large, enter:
-===Images===
+**0.00,0.00,0.50**
-==Image List==
+====Option Group #: Option File Slots====
-This is a comma-delimited list of all the image URLs to use for each listing. This functions the same as using each of the "Image URL #" columns, but combines them into one column. For example, this column's data for a given listing might read:
+A comma-separated list of file slots for each option in this group, in the correct display order. Integers only.
-"http://mysite.com/images/mypic1.jpg,http://mysite.com/images/mypic2.jpg,http://mysite.com/images/mypic3.jpg"
+e.g. To associate image 1 with Small shirts, image 2 with Medium shirts, and image 3 with Large shirts, enter:
-You can further shorten the required data by using one of the "Base Image Path" settings (see below).
+**1,2,3**
-==Youtube Video List==
+====Option Group #: Option INDIVIDUAL Quantities====
-This works exactly like the Image List, but for videos. The data may be in any format supported by the front-end video uploader. E.g., either "http://www.youtube.com/watch?v=dQw4w9WgXcQ" or simply "dQw4w9WgXcQ"
+A comma-separated list of quantities for each option in this group, in the correct display order. Integers only.
+e.g. If you have 5 Small shirts, 2 Medium shirts, and 16 Large shirts, enter:
-==Base Image Path (Step 1) vs. Base Image URL (Step 2)==
+**5,2,16**
-You can specify a "base" path to your images in one of two locations. **DO NOT USE THEM BOTH.** Those places are either the "Base Image Path" setting on Step 1 of the upload process, or by setting a column of the upload data to be the "Base Image URL" on Step 2. The Step 1 path setting applies to EVERY listing in the source file, while the Step 2 base url setting may be different for each listing. Here are some examples of ways the two settings can both be useful:
+====COMBINED Quantity Sets====
+This one can be a bit tricky. It accepts a comma-separated list in this format: **option name 1**+**option name 2**=**quantity of 1 and 2**
-<tip c h>
+To give an example, if adding 3 small, black shirts; 5 large, red shirts; and 7 large, black shirts, you would use this expression:
-  * Base Image Path (Step 1): "http://mysite.com/images/"
-  * Listing 1 "Base Image URL": **NONE!**
-  * Listing 1 "Image List:" "mypic1.jpg,mypic2.jpg,mypic3.jpg"
-  * Listing 2 "Base Image URL": **NONE!**
-  * Listing 2 "Image List:" "mypic4.jpg,mypic5.jpg,mypic6.jpg"
-</tip>
+**small+black=3,large+red=5,large+black=7**
-<tip c h>
+You are not limited to pairs of options. I.e., **small+black+smelly=1** would work (though we don't recommend selling "smelly" shirts in the first place... ;) )
-  * Base Image Path (Step 1): **NONE!**
-  * Listing 1 "Base Image URL": "http://mysite.com/images/"
-  * Listing 1 "Image List:" "mypic1.jpg,mypic2.jpg,mypic3.jpg"
-  * Listing 2 "Base Image URL": "http://yoursite.com/media/pictures/"
-  * Listing 2 "Image List:" "yourpic24.jpg,yourpic67.jpg,yourpic48.jpg"
-</tip>
+===== Automatic Title from Other Fields =====
-==Valid Image Paths==
+If you use the [[startup_tutorial_and_checklist:feature_configuration:field_configuration:site_wide_optional_fields:automatic_listing_titles|automatic title field from other fields feature as described here]] in the software you can still do that within the bulk uploader feature within a specific upload.
-The surest way to bulk upload an image is to give the uploader its fully-qualified, public URL (e.g. "http://mysite.com/images/mypic1.jpg"). If the image is already uploaded to the local server **AND** you are using the "Better Quality" (not "Faster") image upload method, you also have the option to specify the local path instead (e.g. "/var/www/html/images/mypic1.jpg")
+You would do field matching as normal through the second step to the bulk upload process and then set the fields to use for the title within step 3 of the bulk upload process.  So if you use site wide optional field 1, 2 and 3 to create your title you will need to populate those fields within step 2 of the upload process and then set those fields to populate the title within step 3 of the bulk upload process.  Look for the following within the step 3 page of the bulk upload process:
+{{ :addons:bulk_uploader:bulk_upload_config2.png?500 }}
-===Geographic Navigation===
+and then click the **add a field** button to start setting up each field to populate the title and you will end up with something like the following if you used site wide optional field 1, 2 and 3 to populate the title field:
-You may use the bulk uploader to specify a geographic region for each listing. Note, however, that the Geographic Navigation addon uses the core software's built-in "country" and "state" fields for the first two levels of Geographic Navigation. That means that if you are not using greater resolution than the first two levels, you do NOT need to specify a geographic region, but DO need to use the correct country and state locations
+{{ :addons:bulk_uploader:bulk_upload_config3.png?500 }}
-If you're using a location resolution three levels or deeper, you need to set the region ID of the terminal region in the bulk uploader. You can find that ID number by going to the front-end page for the given region and looking at the URL. For instance, if you would browse listings in a given region at the URL http://example.com/index.php?region=region42, then you would specify that region to the bulk uploader with simply "42"
-===Storefront Category ID#===
-You can specify which of a user's storefront categories a bulk uploaded listing should go into. This requires the use of that category's ID number. The ID number may be found in the URL of the given category's page on the front-end. For instance, with a URL of **http://cytael.dyndns.org/geo/index.php?a=ap&addon=storefront&page=home&store=50&category=379**, you would enter "379" in the bulk upload source file.

Geodesic Solutions Community Wiki

User Tools

Site Tools

Differences

Page Tools