CSV - Database import
This feature permits you to create a catalogue quickly, by importing data from a database or from Excel.
You can insert images and the program can automatically generate thumbnails.
The function is accessible from the main menu, “File >Import from database / CSV”.
There are dozens of different database brands out there (Oracle, DB2, Microsoft Access, MySQL, Interbase, Paradox, Informix, Fulcrum, DBase, SQL server, FoxPro, Firebird, and much more...), so we chose to rely on CSV format (comma separated values), as any database (and also other programs such as Excel) can export to a CSV file.
This permits you to use any database.
Please see your database User’s Manual in order to learn how to export to a CSV text file - you may also use the HyperPublish user’s forum to exchange information with other users.
The fastest way to learn how the import works (and the meaning for the different sub-tabs) is to use a sample file supplied with the program, a file that works with the default settings.
Please just press the “Load CSV file” button on the first tab and choose the file “catalog_example_cat_and_subcat_ex1.txt”. As you may see this is a text file: you can open it with the MSWindows NotePad and you can use it as a sample of what you should obtain from your database.
The file relies on some images that are contained within the same folder (you may also choose another folder for images with the “Options” tab).
If you touch nothing, and you press the “Create” button on the bottom left, the program will ask you to choose a Template (from the Template tab). A template is simply a one-page AEH file saved within a particular folder. You can create infinite new templates - the layout of your catalogue is completely customizable. Within the template you may use some keywords, that will be replaced with live data. For example, $$title$$ will be replaced with the product title, $$image$$ with the product image. You find these special words listed on the
first tab.
Just press the Create button to see how it works. It will extract the data from the CSV file, create several pages, and then put you on the index page. You may see the other pages with CTRL+ and CTRL-.
In the
example provided, the products are audio CDs, the subcategories are music artists, the categories Rock, Country, etc.
Very quick and nice, isn’t it? It has created a main index, category pages, subcategory pages, and product pages.
You may experience some variations by using the various subtabs.
Please notice that your own file may have categories + subcategories, subcategories only, or products only - just check / uncheck the options on the right of the first tab.
Now, as usual within this visual manual, you may learn about the various option of the dialog with clicks on the image (you may click on the tabs in order to see the meaning for all the 5 tabs; the first page shows the first tab only!),
click here to see the dialog.
Other easy tools from Visual Vision:
HyperPublish is OK for for Antiques and Collectibles catalogs, CD and Web sites, Furniture, House and Household Items, Jewelry Beadwork and Watches and Accessories product catalogs, Military, Police and Weapons catalogs and Web sites, Paper, Pottery Modelmaking and China, CD and Web sites abour Textile Arts, Sewing, Fabric Crafts CD catalogs and Web sites, Toys Doll and Miniature-Making catalogs, Art, Architecture and Photography, Fashion, Design, Architects and Buildings, Artists and Photographers, Medical, Sports, Business and Money, Employment, Real Estate, Childrens, Baby and Preschool, Africana, Animals product catalog, Cooking and Food and Wine CD Web catalogs, Counting, Fiction movies and Literature catalogs, Games and Activities, Health Medicine Natural Healing Web and CD catalogs, Biotech, Beauty Nutrition and Grooming, Transportation, Travel catalogs, Computers, Hardware catalogs, Baking Desserts, Home and Hobbies product catalog software, creating Woodwork and Carving Web and CD, Gardening, flowers and decoration products catalog, Painting, Stamping and Stenciling, Glass and Metal product catalogs, Academic, school and educational CD software, Web sites, products catalog, Nature, Environment, Environmental, Ecology product catalog, Web sites and product catalogs, Family and Wedding products and Web sites, Pets, family Pregnancy product web sites and CD, Birds, Cats, Dogs, Fish, Horses, Mice, Rabbits, Pigs, making Reference, Almanacs, Maps, Consumer Guides, Dictionaries, Encyclopedias, Religion, building Spirituality CD and Web sites, Science, Engineering, Technical, Technology CD and product catalogs, Agricultural, Astronomy, Biology and Life, Chemical, Chemistry and Biochemistry documentation, collections, CD, Web sites, product catalogs program, Civil Structural Construction, Electrical and Electronic product, Industrial, Mechanical product CD catalogs software, Telecommunications, Folklore and Mythology, Aviation, cars, Motorcycles, Trains, Ships.
Create CDROM, Website, product catalog, multimedia CD, also with audio, video, animations, flash, mpeg... distribute documents, items, parts descriptions on CD / Web site; attach link to PDF, PowerPoint, Autocad, ZIP, any file. HyperPublish is the powerful all-in-one tool for creating product catalogs, either from scratch or populated by using database / DB source (Oracle, MySQL, Access, Interbase, SQL server, DB2, Paradox, Fulcrum, Sybase, Fox, DBF, Excel) in CSV format. You have a set of base fields and you can add some custom fields. It can create thumbnail images automatically. Each product may link to a datasheet and/or ZIP file with details and/or audio or video. Everything is fully editable (when using the CSV import you can still edit after the import), you can use and edit templates for product pages, and you can edit all product and categories / subcategories pages after the import. Powerful search feature automatically inserted on the selfinstalling CDROM; keyword search. HyperPublish is also a perfect professional "glue" tool: a program for assembling a rich Website or CD with multiple source documents. Affordable and productive.