Knowledge of the access databas

[thedoc01]

Anyone know where the data held within the (product) fragments is stored in the access database please?

Thanks

[completerookie]

I think they are in DesignObjects

[NormanRouxel]

Fragments on Brochure pages are held in the BrochureFragments table.

You're probably asking about Fragments on Section (product) pages. These are held in the Product table. They are the entries with nProductType set to 2.

[completerookie]

forgot about those

[thedoc01]

You're probably asking about Fragments on Section (product) pages. These are held in the Product table. They are the entries with nProductType set to 2.

Thanks - but still confused then.
what does the coding where "nProductType set to 2" (or 1 or 0??) mean?
And, where is the actual contents of the fragments?

Thanks.

[NormanRouxel]

Thanks - but still confused then.
what does the coding where "nProductType set to 2" (or 1 or 0??) mean?
And, where is the actual contents of the fragments?

Thanks.

1) From Help / Variable Reference Guide / ProductType: Type of product (0 = Product, 1 = Duplicate, 2 = Fragment). Help is always a good place to look.


2) I'm surprised that you had to ask this. Look at all the fields in the table. You'll see some with "Fragment" in their names. Duh!

[thedoc01]

1) From Help / Variable Reference Guide / ProductType: Type of product (0 = Product, 1 = Duplicate, 2 = Fragment). Help is always a good place to look.


2) I'm surprised that you had to ask this. Look at all the fields in the table. You'll see some with "Fragment" in their names. Duh!

So, in the access database:

1. The table brochurepages means - brochure pages
2. The table brochurefragments means - brochure fragments
3. The table products means - product pages AND product fragments
4. The way to differentiate products from fragments is that there is a field called "ProductType" where "0" means it is a product whereas "2" means its a fragment.

Well, I quite agree - bloody obvious isn't it !!!! Duh !

[thedoc01]

When looking in the product table within the database - I can see no reference to which layout is used for each product.
Anyone know where this particular attribute is set please?
Or am I having another duh moment?

Thanks.

[leehack]

Databases don't usually hold the name in that situation, they'd hold an id or a number as it's more efficient to write a number than a name of something, there would then be another table which identified which layout was attached to each number. Product no.1 uses layout no. 2 and layout no.2 is called "blah blah" in a layout definition table. So i suspect the design objects table would hold the layout name, contents and id of the layout.

[Duncan Rounding]

The database gets quite complex and is not just a simple reference in one field in one table looked up in another table.

Please explain what you are trying to achieve rather than open questions about the database.

[thedoc01]

The database gets quite complex and is not just a simple reference in one field in one table looked up in another table.

Please explain what you are trying to achieve rather than open questions about the database.

Thanks.
I have a product list of over 350 products and I am looking to universally change the product layout from version A to version B.

[Duncan Rounding]

Backup your database.
Export the catalog, open in Excel, specify the name of product layout you want in the relevant column and import the update back in.

[thedoc01]

I am obviously missing something here.
I can see no column on the product database that references any 'layout' therefore I cannot see how to change from layout A to layout B.

[NormanRouxel]

I am obviously missing something here.
I can see no column on the product database that references any 'layout' therefore I cannot see how to change from layout A to layout B.

It's much more complex than that. Product Layout is set via a Selector which is a type of Variable.

Try this to help you work things out:- Set the Product Layout to a non default value, then look in the UserDefinedProperties table where sContentId will match the Product ID and sValue will link to the DesignObjects table.

Obviously a product can have several variables, so you may need to do more detective work to work out what the other fields in UserDefinedProperties do.

[NormanRouxel]

I have a product list of over 350 products and I am looking to universally change the product layout from version A to version B.

Design / Library / Layouts / Products. Copy the contents of the product layout you want into the product layout you wish to replace. Easy, duh!