We need to take 137 different lists and convert them into a standard csv format. We are looking to split up this list between 4 individuals. There is no standard format of the original list of files and so each would need a customized script to convert it into the format below.
MORE DETAILS BELOW...
## Deliverables
Supplier Import List Format
===========================
Order of CSV fields:
"Full Name","Company Name","Title","Email","Phone",<wbr />"Address #1","Address #2","City","Province","<wbr />Country","Postal Code","Website URL","Source","Source URL","Priority","<wbr />ProductCategories","Zones"
ProductCategories can include:
accent-tiles
arcade-games
bathroom-faucets
Bathroom-fixtures-accessories
bathroom-lightings
bio-fuel-fireplaces
brick-masonry-supplies
Brick-masonry-supplies-group
cabinetry
carpet-flooring
ceramic-tiles
concrete
concrete-group
custom-cabinetry
custom-shower-doors
decking-material
decking-material-group
decor-furniture
dining-furniture
drywall-supplies
drywall-supplies-group
electrical
electrical-fireplaces
electrical-group
electronics
electronics-group
engine-parts-4241817
exhaust-fans
exhaust-fans-group
exterior-lighting
exterior-lighting-group
fireplaces
flooring
furniture
games-room-equipment
gas-fireplaces
granite
granite-group
granite-tiles
hardwood-flooring
home-automation
home-automation-group
home-office-furniture
hot-tubs-saunas
hot-tubs-saunas-group
hvac-water-heater-tankless
hvac-water-heater-tanks
hvac-water-heaters
insulation
insulation-group
interior-lighting
interior-lighting-group
interlocking-stone
jukeboxes
kitchen-cabinets-accessories
kitchen-cabinets-accessories-<wbr />group
laminate-flooring
landscape-supplies
landscape-supplies-group
lumber
lumber-group
natural-stone-tiles
nurseries
nurseries-group
paint
paint-group
plumbing-parts-supply
plumbing-parts-supply-group
pool-tables
porcelain-tiles
prefab-cabinetry
prefab-sub-floor
prefab-sub-floor-group
roofing
roofing-group
rubber-stone
shower-doors
siding
siding-group
simulation-machines
skylights
skylights-group
sofas-seating
stamped-concrete-stone
steel
steel-group
stone
stucco
stucco-group
tile
toilets
trim-doors-interior
trim-doors-interior-group
vanities
vinyl-flooring
windows-doors
windows-doors-group
Multiple product categories are delimited using a semi-colon
e.g. "tiling;waterproofing;<wbr />windowsdoors"
Contractor Import List Format
=============================
Order of CSV fields:
"Full Name","Company Name","Title","Email","Phone",<wbr />"Address #1","Address #2","City","Province","<wbr />Country","Postal Code","Website URL","Source","Source URL","Priority","<wbr />JobCategories","Zones"
JobCategories can include:
general
additionsnewbuilds
basements
bricklayingmasonry
cabinetscountertops
carpentryjoinery
concrete
deckspatios
demolition
driveways
drywallplasterstucco
electricallighting
fences
flooringcarpeting
groundworkfoundations
heatingcooling
homeinspection
insulation
kitchens
landscapinggardening
paintingdecorating
plumbing
restorations
roofingsiding
soffitfasciaeavestroughscappin<wbr />g
tiling
waterproofing
windowsdoors
NOTE:
Zones can be left blank, unless we know the distribution area of suppliers or the work area of contractors.
* * *This broadcast message was sent to all bidders on Friday Jan 20, 2012 2:04:45 AM:
Please review the updated project description and let me know your thoughts on: * how quick the turnaround can be? * when can you start? * can you explain how you will perform this task? * how much is the cost? Thank you, Mario