This article will describe how to import a Foundation Library into a Component Library Factory Workbook.
Before continuing with the steps below, be sure to make a backup of your database. If you are unsure about the steps or feel you need help, please contact our Tech Support team.
User discretion is advised
To make a Foundation Library imported into a database with a Component Library (or the reverse) work you will need to “Merge” the Factory Workbooks. When doing this the Foundation Library factory MUST be used as the Foundation library uses more of the data stored in the factory workbook.
Follow the steps below to complete this “merger”:
First, you must save both of the Factory workbooks to your local PC.
Open the databases using the CE Viewer program Here;
Locate and open the table named “Factory”
Locate the column called “workbook”
Right-Click the Byte Array in the column and then select “Save file to disk”
Give the file a name like “Factory Foundation” or “Factory Component” so that you know what it is while working in it
Next you need to open the 2 Factory files and compare the tables...
Open the Factory files;
Copy all the data from Column B to Column V in the Component Factory to the Foundation Factory;
Re-define the columns if needed. (Example: Column L and M need to be defined);
Copy all other look up tables the user may have added/customized from the Component to the Foundation Factory;
Copy any added Tabs from the Component to the Foundation Factory.
Next you will save the file and import it...
Save and close the Foundation Factory
Rename the Foundation Factory to just “Factory”
Open the databases using the CE Viewer program Here;
Locate and open the table named “Factory”;
Locate the column called “workbook”;
Right-Click the Byte Array in the column and then select “Import File from Disk”;
Close out of the CE Viewer and test.
If you are experiencing issues importing your library data, be sure to review this article: Common Issues Associated with Importing Libraries