|
Bulk Ads Import |
In addition to individual ads posting at out
classified we offer Ads Import (bulk upload) service to
our customers. We can insert multiple ads into classified
database from a Microsoft Excel Workbook which you may prepare
and send us. There are 2
methods of importing ads - Ads Import and Ads Import
Plus.
|
|
Ads Import |
Ads Import Plus |
|
Ads Import allows bulk ads upload
attached to a single user account.
Each template may hold up to 1000 ads. Lines over 1000 limit
would be ignored during Import. If you have more than 1000
ads to import please create multiple templates with up to 1000 ads in
each.
|
Ads Import Plus allows bulk ads upload
with each ad attached to a created on the fly user account.
Each ad within the Import list requires a unique email address.
Each template may hold up to 500 ads. If you have more than 500 ads
to import please create multiple templates with up to 500 ads in
each. |
|
General Instructions |
- Click "Download Ads Import .." for the selected method
below and save template to your local drive.
- Open it with MS Excel
- Click "Template Fields Reference"
- Fill necessary data within downloaded template according to
specifications from fields reference
- One row in Excel Workbook should correspond to one ad data.
- If you have VBA installed with MS Office you may facilitate
common data entering to some degree using macro modules
- When finished send us prepared data template. If selected
Ads Import method, then let us know the time length you are
planning to run your ads for. If images would be attached to
your ads, then pack all image attachments into a .zip file and
send along with template.
|
Download "Ads Import" data template
Download "Ads Import" XL
Macro * |
Download "Ads Import Plus" data template
Download "Ads Import Plus"
XL Macro * |
|
Template Fields
Reference
|
|
* Working with Macros |
Downloaded Excel Macros designed to facilitate data entering process
to some degree. To utilize macros, the MS Office must have Visual
Basic for Application (VBA) installed as an option.
When installed, macros would help to enter common data into the
fields. For instance: if you have a "phone" field common for all
imported ads, then instead of copy/pasting the phone number for each
ad or group of ads, you may enter it once, then run macro and have
the "phone" field filled with common phone number for each ad.To
install macros do the following:
- Download respective to the Import method template and macro
from links above and save them to the local drive. Unzip macro
.bas module.
- Open template in MS Excel.
- Hit Alt+F11. The Microsoft Visual Basic window would be
opened.
- Next, in the "Project - VBAProject" column right mouse click
at "Sheet1" and then "Import File..."
- Browse the respective Macro .bas file and select it.
- Close Visual Basic window
Using macros:
- Macros replicate data entered into the first row (not
counting header row) into all other respective rows for the
column. For "Import" method a 1000 rows would be filled. For
"Import Plus" - 500.
- Example: You need to enter http://www/yourdomain.com into
all rows for a "website" field. Type this URL address under
"website" header (you would be typing at row 2 and column
D). Next hit Alt+F8, select "website" macro from the list and
click "Run". Entire Column D with header "website" should be
filled with specified URL address.
- If you need to enter different values for a specific column,
then arbitrary use macro for pasting the most common value and then
manually change those, which should be different.
- Macro fills first 1000 rows for "Import" method and 500 for
"Import Plus" method. If you have fewer ads to import, then at
the end, when you finish entering data you may simply select and
delete in one shot unwanted rows from the bottom of the template.
- Note: Not all fields would have a respective
macro. Some fields such as "subject", "description" are not
included due to the fact that the data would most likely be
different for each ad record.
|
