| |
 
|
| |
support > knowledge base > knowledge base article
|
|
KB0003 - Error importing a MasterCook recipe
|
|
|
|
The information in this articles applies to: |
| |
| • |
Bartender's Companion (all versions) |
| • |
MasterCook 6 (mx2) recipe export files |
|
|
 |
|
Symptoms |
| |
When you attempt to import a MasterCook recipe file an error occurs. The error might include the following error message:
|
| |
| |
Class: nfc_n_cst_error |
| |
Message: Error creating a recipe.SQLErrText: SQLSTATE = S1000 [Microsoft][ODBC Microsoft Access Driver] Field 't_recipe.recipename' cannot be a zero-length string. |
|
|
Cause |
| |
This problem only occurs when a recipe name contains quotes (e.g. "Green" Pork Loin).
The MasterCook 6 MX2 file format uses XML (Extensible Markup Language) to encode the recipe information, but sometimes MasterCook breaks some of the XML rules, in this case the rule regarding quotes in the document content areas. You can't put quotation marks in the content area of an XML document because quotation marks are used as delimiters to denote the start and end of XML attribute content. For example, in the MasterCook file a recipe name line might read as follows:
|
| |
| |
<RcpE name=""Green" Pork Loin" author="n/a"> |
|
| |
Bartender's Companion will read this line as follows:
|
| |
| |
name="" (not valid in Bartender's Companion and causes an error) |
| |
Green" Pork Loin" (text that the parser thinks is garbage so it discards it" |
| |
author="n/a" |
|
| |
This line should read as follows:
|
| |
| |
<RcpE name=""Green" Pork Loin" author="n/a"> |
|
| |
In the above line the quotes have been encoded as " in order to differentiate them from the XML delimiter quotes.
|
|
Resolution |
| |
Open the offending file using a text editor (such as Notepad) and search for recipe names that contain quotes. Replace the quotes in the recipe name with " as shown above.
|
|
Status |
| |
This issue has been resolved. |
| |
If this article does not solve your problem or if you cannot find a resolution to your problem, please let us know. Please post your question or the details of your problem on the Bartender's Companion Support Forum.
|
|
Steps to Reproduce the Problem |
| |
| 1. |
Open Bartender's Companion. |
| 2. |
Select Import from the File menu. |
| 3. |
Click MasterCook 6 (mx2), then click Next. |
| 4. |
Click the Import File ellipsis button (...) and select a MasterCook 6 file that contains a recipe with quotes in the recipe name. |
| 5. |
Type the cookbook's name in the New Cookbook box, then click Next. |
|
