Knowledgebase
Meadows Publishing Solutions Support > Meadows Support > Knowledgebase

Search help:


Where do AutoPrice™ and DesignMerge® store ODBC SQL Fragment files on my system?

Solution

ODBC SQL Fragment files are individual text files which hold a single ODBC query statement. SQL Fragment files are used by AutoPrice and DesignMerge to query ODBC-compatible databases and retrieve data elements that are then used to update the document.

The instructions below detail how to get to the DesignMerge or AutoPrice SQL Fragments folder.

 

FINDING THE MEADOWS FOLDER

 

The SQL Fragments are stored inside of the Meadows folder, which is inside of your Adobe InDesign Preferences folder. Follow the instructions in the link below to get to the Meadows folder on your system:

 

http://meadowsps.hesk.com/knowledgebase.php?article=128

 

Once you have located the Meadows folder, the SQL Fragments will all be located in a folder titled "ODBC", which should be located inside of the Meadows folder.

 

 

ABOUT MEADOWS DESIGNMERGE® PRO SOFTWARE

 

DesignMerge® Pro is a powerful suite of variable-data printing and data publishing software for Adobe InDesign or QuarkXPress that provides the ability to automatically produce any type of variable data output. The software is used by thousands of customers worldwide.

 

Anything can be variable, including variable text and pictures, articles, and even complete layouts, and built-in suport is provided for variable USPS Intelligent Mail Bar Codes.

 

Other major features of DesignMerge include automatic copy-fitting, advanced conditional programming (Rules), and multi-up imposition support. DesignMerge supports all of the major variable data output formats, including PostScript, PPML, PDF/VT, and Creo VPS and is compatible with printers from every major vendor.

 

In addition, DesignMerge can also be extended to produce variable 2D Bar Codes (QR Codes, PDF417, and Data Matrix) and other types of Linear Bar Codes (Code 128, UPC, Code 39, etc.). DesignMerge is great for creating personalized publications such as invitations, business cards, certificates, custom catalogs, etc.

 

For more information about DesignMerge, go to http://www.designmerge.com.

 

 

ABOUT MEADOWS AUTOPRICE™ SOFTWARE

 

AutoPrice, available as plug-ins for Adobe InDesign or XTensions for QuarkXPress, helps to streamline the production and versioning of catalogs, price lists, retail flyers and financial documents.

AutoPrice provides sophisticated linking of InDesign or QuarkXPress documents to any external database of information (either flat-file, or ODBC). AutoPrice is great for performing price, picture, or text updates for any type of information that can be referenced by a “key value” such as product number (SKU).

  • Saves time by automatically updating information from any flat-file or ODBC-compliant database. No more manual price changes.
  • Allows last-minute revisions so published information is always current & consistent.
  • Reduces errors and speeds proofing.
  • Includes helpful reporting features for the AutoPrice tagged content in your documents.
  • Allows you to instantly swap out product pictures, logos or any type of graphic image.
  • Automate versioning: spin off multiple catalog versions from a single original.
  • Extend AutoPrice with the optional AutoPrice Exporter Pro software to extract data from a QuarkXPress or InDesign document to a database file, which can then be used to populate Web, e-commerce or digital content databases .
  • Extend AutoPrice with the optional AutoPrice PDF Exporter software to produce PDFs that contain hyperlinks based on the AutoPrice Links in your documents.
  • Extend AutoPrice with the optional Meadows 2D Bar Code software to place updatable 2D Bar Codes (QR Codes, PDF417, and Data Matrix) in your documents.

For more information about AutoPrice, go to http://www.meadowsps.com/autoprice.

 

 

ABOUT MEADOWS INDEX BUILDER™ SOFTWARE

 

Index Builder is a software module for Adobe InDesign or QuarkXPress that provides a very powerful set of tools for creating catalog indexes. Unlike standard indexing products, MPS Index Builder was designed to serve the special needs of catalogers, with a number of unique features that make the product ideal for catalog workflows.

You may use Index Builder to automate building both Product and Manufacturer Indexes. Index entries can be up to four levels deep and can be attached to any box or group of boxes (“Product Block”) in your catalog pages. Each tagged box or group can contain up to 10 distinct entries, and the entries are permanently stored with the document content. In addition, if you are one of our many AutoPrice customers, you will also be able to extract SKU information to include in your final index.

The Meadows Index Builder software includes the Meadows Index Tagger™ feature which provides an easy interface to tag the boxes or groups in your documents with index entries. You may enter index entries into Index Tagger by hand at any time, or you may import index entries from a tab-separated text file. Since most catalogers already have a hand-built index from the last catalog, it is quite easy to import the old index, make changes, and start tagging for the future. Index entries can also be saved, exported and shared by any other workstation.

Many catalogers create their catalog as separate pages, spreads, or sections, requiring that the index span across hundreds of individual documents. The built-in batch processing feature of MPS Index Builder will process any number of individual QuarkXPress or InDesign documents in a single session. A complete index can be created within minutes and can be updated at any time.

Imagine, querying a database application for SKU information, dragging a fully-formatted product block onto your QuarkXPress or InDesign page, automatically updating pricing or other information within the block, and then cranking out a catalog index. All this is possible using the Meadows suite of catalog software!

For more information about Index Builder, go to http://www.meadowsps.com/indexbuilder.

 

 

Copyright © Meadows Information Systems, LLC d/b/a Meadows Publishing Solutions. All rights reserved worldwide.

DesignMerge is a registered trademark of Meadows Information Systems, LLC.

AutoPrice is a trademark of Meadows Information Systems, LLC.

Index Builder and Index Tagger are trademarks of Meadows Information Systems, LLC.

Adobe and InDesign are registered trademarks of Adobe, Inc.

Quark, QuarkXPress and XTensions are registered trademarks of Quark, Inc.

 

Article details
Article ID: 129
Category: Knowledgebase
Date added: 2014-01-09 11:08:34
Views: 483

 
« Go back

Copyright (c) 2013 by Meadows Information Systems, LLC d/b/a Meadows Publishing Solutions. All rights reserved worldwide.
The Meadows Publishing Solutions product names mentioned on this website are registered trademarks or service marks of Meadows Publishing Solutions, Inc. and may be registered in certain jurisdictions. Other company and brand, product and service names are for identification purposes only and may be trademarks or registered trademarks of their respective holders. Data subject to change without notice.