 |
 |
FAQ Questions
FAQ Answers
| ID | Configuration FAQ | |
|---|---|---|
| C1 | What is a Merge Definition? | ^ |
| A Merge Definition defines the configuration settings required to generate a Merge Document or Workbook from data stored in a MS Access Database or MS Excel Workbook. Define a Merge Definition for each merged Document / Workbook you wish to generate. You may group common Merge Definitions in the same myPM Merge Data File. (*.mmu) | ||
| C2 | When browsing for fields, myPM Merge does not display the correct field description. Why? | ^ |
| myPM Merge extracts field descriptions located in the row immediately above the First Row, as defined on the Merge Source Tab. Ensure the First Row is set to the first row in the Worksheet that contains data. | ||
| C3 | What is the Primary Key Field? | ^ |
| The Primary Key Field is a field in the Data Source used by myPM Merge to determine which records to process. Records containing a blank Primary Key Field value are ignored by myPM Merge. The Primary Key Field should be set to a Data Source field that contains a value for each Data Source record. | ||
| C4 | How can I configure myPM Merge to ignore duplicate records. | ^ |
| Enable the Ignore Duplicate Primary Key Records option, located on the Merge Source Field. If two or more Data Source records contain the same primary key field value, only the first record is processed by myPM Merge. | ||
| C5 | Can myPM Merge save each merged file to a different folder? | ^ |
| Yes. To achieve this, define the path for each file in the Data Source field containing the save filename. (eg. Folder_A\File_01.doc, Folder_B\Folder_C\File_02.doc, etc.) |
||
| C6 | What is a Merge Map? | ^ |
| The Merge Map defines the relationship between Data Source fields and Template BookMarks or Cells. Use the Merge Map to define which Data Source record fields should be inserted in the Template. | ||
| C7 | Do I need to enter a description in the Merge Map for each entry? | ^ |
| No. The Description Field is provided so that you can enter a meaningful description for the Data Source field. It is not used by myPM Merge, and thus can be left blank. |
||
| C8 | How do I insert the same Data Source field more than once in a MS Word document? | ^ |
| Method A. Insert MS Word fields at the second and subsequent locations where the Data Source field value is to be inserted. The field code should be set to: REF BOOKMARK, where BookMark is the name of the BookMark that defines the location where the first Data Source field value is to be inserted. Method B. Define multiple BookMarks for each location where the Data Source field value is to be inserted. An entry for each of these additional BookMarks will need to be defined in the Merge Map. |
||
| C9 | How do I insert the same Data Source field more than once in a MS Excel workbook? | ^ |
| Method A. Define a formula in the second and subsequent Cells where the Data Source field value is to be inserted. The formulae should be set to: =A1, where A1 is the name of the Cell where the first Data Source field value is to be inserted. Method B. Define multiple entries in the Merge Map, one for each Cell where the Data Source field value is to be inserted. |
||
| C10 | What is a Merge Filter? | ^ |
| The Merge Filter determines which Data Source records should be processed by myPM Merge. Only Data Source records that meet the defined Merge Filter criteria are processed. |
||
| C11 | How do I configure the Merge Filter to ignore blank field values? | ^ |
| Select the "Is not blank" comparison for the appropriate Data Source field in the Merge Filter. Only records that contain a value for the defined field will be processed by myPM Merge. |
||
| C12 | What is a Merge Preview? | ^ |
| The Merge Preview defines which Data Source record fields are displayed in the Merge Preview Dialogue. Select appropriate fields that enable you to easily select which records to merge. |
||
| C13 | Do I need to enter a description for each Merge Preview item? | ^ |
| No. If you do not enter a description, myPM Merge will display the Data Source field name in the Merge Preview Dialogue. | ||
| C14 | After configuring myPM Merge, the Start Button remains disabled. Why? | ^ |
| The Start Button remains disabled until all mandatory fields have been entered in the various Configuration Tabs. Mandatory fields are shown in red. In addition, you must select to either print and/or save the merged document or workbook, the Merge Map must contain at least one valid entry, and the Merge Preview must also contain at least one valid entry. Once all the required data has been entered, the Start Button will be enabled. | ||
| ID | General FAQ | |
| G1 | Why does myPM Merge fail to recognise MDAC version 2.6 or higher is installed? | ^ |
| If MDAC version 2.6 or higher is installed and working, this error may be caused by myPM Merge being unable to access the MS Windows Registry. To resolve this error, log in to MS Windows using an Administrator Account, and try running myPM Merge again. |
||
| G2 | Why does myPM Merge fail to recognise one or more MS ACE or JET OLE DB Providers are installed? | ^ |
| If one or more MS ACE or JET OLE DB Providers are installed, this error may be caused by myPM Merge being unable to access the MS Windows Registry. To resolve this error, log in to MS Windows using an Administrator Account, and try running myPM Merge again. |
||
| G3 | Why does myPM Merge fail to recognise MS Excel (97, 2000, xp, 2003, 2007) is installed and working? | ^ |
| If MS Excel (97, 2000, XP, 2003, 2007) is installed and working, this error may be caused by myPM Merge being unable to access the MS Windows Registry. To resolve this error, log in to MS Windows using an Administrator Account, and try running myPM Merge again. |
||
| G4 | Why does myPM Merge fail to recognise MS Word (97, 2000, xp, 2003, 2007) is installed and working? | ^ |
| If MS Word (97, 2000, XP, 2003, 2007) is installed and working, this error may be caused by myPM Merge being unable to access the MS Windows Registry. To resolve this error, log in to MS Windows using an Administrator Account, and try running myPM Merge again. |
||
| G5 | Why doesn't myPM Merge process all the records in the Data Source? | ^ |
| If myPM Merge is not registerd, only the first ten (10) records in the Data Source are processed. To process all records contained in the Data Source, register myPM Merge. If the Merge Filter is enabled, ensure at least one or more Data Source records meet the defined criteria. | ||
| G6 | Why can't I run two or more copies (instances) of myPM Merge at the same time? | ^ |
| Only one instance of myPM Merge can be active at any one time. This prevents possible corruption of the MS Windows Registry and / or myPM Merge Data File (*.mmu). | ||
| G7 | How do I terminate myPM Merge if it freezes? | ^ |
| myPM Merge may freeze while communicating with the MS ACE or JET OLE DB Provider, MS Excel, or MS Word. If this happens, use the Windows Task Manager (CTRL + ALT + DEL) to terminate the myPM Merge application / process. You may also need to use the Windows Task Manager to terminate MS Excel, and MS Word. | ||
| ID | Installation FAQ | |
| I1 | Does MS Access (97, 2000, xp, 2003, 2007) have to be installed prior to installing myPM Merge? | ^ |
| No. However, MDAC version 2.6 or higher, and a MS ACE or JET OLE DB Provider must be installed if you intend to use MS Access Database Data Sources. myPM Merge uses MDAC and a MS ACE or JET OLE DB Provider to integrate with MS Access. MDAC and the MS ACE or JET OLE DB Provider are usually installed when installing MS Access. | ||
| I2 | How do I know if MDAC is installed on my computer? | ^ |
| If MDAC is not installed properly on your computer, myPM Merge will generate a warning message on start up. | ||
| I3 | How do I know which version of MDAC is installed on my computer? | ^ |
| After starting myPM Merge, click on the Help menu located on the Main User Interface, and select About.... This will display the myPM Merge About Dialogue, which indicates the version of MDAC installed. |
||
| I4 | How do I install the latest version of MDAC on my computer? | ^ |
| Download the latest MDAC version from the Microsoft web site: www.microsoft.com. Follow the instructions provided by Microsoft to install MDAC on your computer. |
||
| I5 | How do I know if a MS ACE or JET OLE DB Provider is installed on my computer? | ^ |
| Download the latest MDAC version from the Microsoft web site: www.microsoft.com. Follow the instructions provided by Microsoft to install MDAC on your computer. |
||
| I6 | How do I know which MS ACE or JET OLE DB providers are installed on my computer? | ^ |
| After starting myPM Merge, select the Options Tab. A list of installed MS ACE and JET OLE DB Providers is displayed in the OLE DB Provider Drop Down List. If more than one MS ACE or JET OLE DB Provider is displayed, select the highest version. | ||
| I7 | How do I install the latest MS ACE or JET OLE DB provider on my computer? | ^ |
| Download the latest MS ACE or JET OLE DB Provider from the Microsoft web site: www.microsoft.com. Follow the instructions provided by Microsoft to install the MS ACE or JET OLE DB Provider on your computer. |
||
| I8 | Does MS Excel (97, 2000, xp, 2003, 2007) have to be installed prior to installing myPM Merge? | ^ |
| No. However, MS Excel (97, 2000, XP, 2003, 2007) must be installed and operating correctly prior to using myPM Merge if you intend to use MS Excel Workbook Data Sources and / or Template. | ||
| I9 | Does MS Word (97, 2000, xp, 2003, 2007) have to be installed prior to installing myPM Merge? | ^ |
| No. However, MS Word (97, 2000, XP, 2003, 2007) must be installed and operating correctly prior to using myPM Merge if you intend to use MS Word Document Templates. | ||
| I10 | Are administrator rights required to install myPM Merge? | ^ |
| Maybe. Depending on the MS Windows version, Administrator Rights may be required to install myPM Merge. If installation of myPM Merge fails, log in to MS Windows using an Adminstrator account and try again. | ||
| I11 | Can multiple versions of myPM Merge be installed on the same computer at the same time? | ^ |
| No. It is not possible to install multiple versions of myPM Merge on the same computer at the same time. Doing so may result in unpredictable behaviour, and as such is not recommended. The latest version of myPM Merge is available for download at the Midori Media web site: www.midorimedia.com. Registered Users are informed automatically via email when a new version of myPM Merge is released. Any existing versions of myPM Merge should be uninstalled prior to installing the latest version. | ||
| I12 | Can myPM Merge be installed on multiple computers at the same time? | ^ |
| myPM Merge Single User Licence - No. myPM Merge may only be installed on one computer at any one time. myPM Merge Site Licence - Yes. myPM Merge may be installed on any computer owned by the individual or company that purchased myPM Merge. |
||
| I13 | Can myPM Merge be transferred from one computer to another? | ^ |
| myPM Merge Single User Licence - Yes. myPM Merge may be transferred from one computer to another computer providing it is first uninstalled on the original computer. myPM Merge Site Licence - Yes. myPM Merge may be installed on any computer owned by the individual or company that purchased myPM Merge. |
||
| I14 | How can myPM Merge be uninstalled? | ^ |
| myPM Merge should be uninstalled using the myPM Merge Installation Wizard. The myPM Merge Installation Wizard may be started by clicking on the Uninstall myPM Merge option located in the myPM Merge Start Menu folder, or by double clicking on the UNINS000.EXE file, located in the myPM Merge folder. Alternatively, myPM Merge may be uninstalled via the Control Panel Add / Remove Programs Applet. | ||
| ID | Process FAQ | |
| P1 | Why does myPM Merge only display the first ten records in the Merge Preview dialogue? | ^ |
| If myPM Merge is not registered, only the first ten records in the Data Source are processed. To remove this limitation, purchase and register myPM Merge. |
||
| P2 | Why does myPM Merge display the Configuration Error dialogue? | ^ |
| Prior to processing the selected Merge Definition, myPM Merge validates the configuration data. If any errors are found, they are displayed in the Configuration Error Dialogue. These errors must be corrected before the Merge Definition may be processed. | ||
| P3 | Why are the number of valid records less than the total records in the Merge Preview dialogue? | ^ |
| myPM Merge validates the records contained in the Data Source. If a Data Source record is blank, or contains a blank Primary Key Value, it is ignored by myPM Merge. If the Merge Filter is enabled, only those Data Source records that meet the defined criteria are processed. | ||
| P4 | Why does myPM Merge fail to display some Data Source records in the Merge Preview dialogue? | ^ |
| myPM Merge ignores Data Source records that contain no data or contain a blank Primary Key Field value. Ensure the appropriate field is selected as the Primary Key Field. Ensure each Data Source record contains a non blank value in the Primary Key Field. If the Merge Filter is enabled, only those Data Source records that meet the defined criteria are processed. Ensure the Merge Filter has been correctly configured, or disable it if it is not required. | ||
| P5 | Why does myPM Merge fail to find any valid data? | ^ |
| myPM Merge validates the Data Source prior to generating merged files. myPM Merge will generate this error if the Data Source is empty (ie. does not contain any data), or the Merge Filter is enabled and no Data Source records meet the defined filter criteria. | ||
| P6 | Can myPM Merge be configured to print only one page of a merged document? | ^ |
| No. myPM Merge prints the entire merged document. | ||
| P7 | Can myPM Merge be configured to print multiple worksheets in the merged workbook? | ^ |
| No. myPM Merge only prints the Worksheet specified in the Merge Destn Tab. | ||
| ID | Registration FAQ | |
| R1 | Why haven't I received my Registration Details yet? | ^ |
| After you purchase myPM Merge, Midori Media manually processes your purchase and verifies your details. Midori Media then generates your Registration Details and emails them to you. This process normally occurs on the same day you purchase myPM Merge, however occasionally it may take a bit longer. If you have not received your Registration Details please contact Midori Media (Email: sales@midorimedia.com). |
||
| R2 | Why do I need to register myPM Merge? | ^ |
| Until myPM Merge is registered, it operates under the Midori Media Evaluation Licence. Under this licence, only the first ten (10) records in the Data Source (MS Access Database, MS Excel Workbook) are processed by myPM Merge. The Evaluation Licence allows you to evaluate myPM Merge prior to purchase. Registering myPM Merge upgrades the Evaluation Licence to a Single User Licence or Site Licence, as appropriated. Once myPM Merge is registered, the ten record limit is removed. | ||
| R3 | Why can't I register myPM Merge? | ^ |
| 1. Ensure the version of myPM Merge you are attempting to register matches the registration details provided by Midori Media. If you are attempting to register a different version of myPM Merge, contact Midori Media to obtain the correct registration details for your version. 2. Ensure you have entered the registration details EXACTLY as provided by Midori Media. All registration details are case sensitive. (ie. UPPERCASE and lowercase letters are NOT THE SAME.) 3. Ensure you have selected the correct licence (ie. Single User Licence, Site Licence). 4. Administrator rights may be required to register myPM Merge. Log in to MS Windows using an Administrator Account, and attempt to register myPM Merge. |
||
| R4 | Do I need to re-register myPM Merge after installing a new version? | ^ |
| Yes. The myPM Merge registration details are version specific. Please contact Midori Media if you have not received registration details for the updated version of myPM Merge. | ||
| R5 | Do I need to register myPM Merge on each computer on which it is installed? | ^ |
| Yes. myPM Merge must be registered on each computer on which it is installed. | ||
| R6 | Why is the register menu not visible on the myPM Merge main user interface? | ^ |
| Once myPM Merge has been successfully registered, the Register Menu is no longer displayed. To re-register myPM Merge, it must be uninstalled and re-installed. |
||