Last updated PBMH 14-Apr-2012 - TO BE REVISITED
The web site is comprised of various modules:
Marc Coulombe (built the web site) or someone else (Ray Murrell, Jobe Groot?) may be able to help out for the immediate purpose and recommend someone for the Data Manager position. This should be a person very familiar with Microsoft Access and with managing data. Marc (for example) should go through these instructions and then, if not going to do the work on a regular basis, should provide training to a less experienced person. Anyone else can have a go but should NOT spend a lot of time trying to figure something out – call for help so as not to waste time and get frustrated.
The Data Assistant should be able to provide background information to the data.
Review the Tasks database to see many of the tasks that have to be done on a regular and frequent basis.
G:\DATA DEPARTMENT\HIPOINT_IMPORTS is the main folder.
G:\DATA DEPARTMENT\Top List Analysis is for sales analysis.
This is done through DempseyCommerce > List Pop’n (pwd: letmein).
Instructions are on the pop-up form.
First column name: ProductCode
Second column name: SortOrder (if you don’t want them to sort alphabetically)
The data you are importing has to be the first tab in specific_list.xls, which means you need to move the worksheets and save the file AND CLOSE IT before importing. I have found that if you do not follow this protocol the import will fail or import the incorrect data.
Top Lists are refreshed every month. They are based on sales over the preceding two months and you should update them on the last day of a month or the first day of the next month, whenever the home page is renewed. The lists are the default view when a User selects from the menu items at the top of the web site:
Module | Has Top List |
Books | Yes |
Audio | Yes |
Listening Stations | No |
Music | Yes |
Decks/Sets | Yes |
Calendars | Sometimes |
DVDs | Yes |
Sidelines | Yes |
Chimes | Yes, but not the first page |
From HiPoint:
In G:\DATA DEPARTMENT\Top List Analysis:
In TopListAnalysis.mdb:
The queries look at sales for the previous two months and remove Indigo and Ten Thousand Villages sales. You can also remove specific quantities by entering a negative value in TopLists.AdjustOut – this would be for special orders for courses etc that don’t properly represent regular industry sales.
frmExportLists allows you to repopulate a table with query names, and then select which queries you want to export. You must supply an export file name. The file goes to G:\DATA DEPARTMENT\HIPOINT_IMPORTS\.
WARNING: Do not select all queries at the same time otherwise it may hang, or at least tie everything up for a long time. See the web site for the standard lists: Books, Audio, Music, etc.
Use this tool when creating specific lists as discussed elsewhere. It sorts by sales ranking.
See Importing Titles to Web Site Lists (above).
Periodically update all the lists on the website using this tool.
These lists are on menu=3 on the website. They show all titles for a particular month, based on the mmyy code in the Dirty Title as identified in DataDeptTools_app.mdb qryWhatsNew_1_Month.
Using DataDeptTools_app, DempseyCommerce and specific_list.xls
This list appears in the same module as New Releases on the web site. It is based on the backorders for NYP titles, coming at any time in the future.
In DataDeptTools_app
In TopListAnalysis
This needs to be done by someone with HTML and CSS experience. Here are some quick notes for Marc or whoever has the first go at it. Read through them all before diving in!
div class="slides_container"
The Data Assistant will prepare a Word document JomePage_yymm_mmm.doc with all the relevant codes. This is where the rotating images go.
div class="WoodstockLogo_1205_MAY"
Barbara will decide what gets featured here.
table id="IndividualsIn_1205_MAY"
This is where the individual images and quotes go.
Everything from the first <tr> to the last </tr> get copied to login_yymm_mmm.aspx into <table id="IndividualsLogin_1204_APR">.
These are a world unto themselves but are largely set up for the year each January.
Appendix 1
Fiscal periods are based on y/e July 31
August =1
September = 2
October = 3
November = 4
December = 5
January = 6
February = 7
March = 8
April = 9
May = 10
April = 11
June =12
Leave a Reply