Bugette - Importing Sections and Products may break brochure links.
Tested with 6.1.3 (but I'm sure this affects later versions).
Scenario:
I regularly do a Hierarchical Import / Replace of just the Sections and Products, leaving the Brochure pages to be maintained in Actinic. I've noticed that if I add/remove Sections in our Import file then links to these sections via brochure fragments Link / Section sometimes point to the wrong section.
Why it happens:
The Brochure fragments use a numeric value in sLinkedItemID to point to linked Sections via Catalog section table's nSectionID.
If you Import / Replace Sections and Products while leaving the Brochure pages in place then any new sections in the import file will increase all subsequent Catalog section table's nSectionID.
Likewise delating a section from the import file will decrease subsequent nSectionID's.
However the BrochureFragments table sLinkedItemID remains unaltered.
Pages are generated with no errors but the sLinkedItemID now points to the wrong section.
Possible fix:
In the database use the catalog section table sPageName value as BrochureFragments table sLinkedItemID rather than nSectionID.
The nLinkedItemType value will differentiate these entries between URL type links and Section type links.
An extra step will be needed at Site generation / Preview time to resolve these text ID's against the Section Id's.
A warning could be made at generation time or import consolidation if links are unresolved.
Workaround:
Use URL type links instead and enter the URL of your section pages. This is fine for Catalog but won't work properly for Business users as it won't maintain logged in customers.
Note:
There may be a similar issue for Product type links if using autogenerated product references.
Norman
Tested with 6.1.3 (but I'm sure this affects later versions).
Scenario:
I regularly do a Hierarchical Import / Replace of just the Sections and Products, leaving the Brochure pages to be maintained in Actinic. I've noticed that if I add/remove Sections in our Import file then links to these sections via brochure fragments Link / Section sometimes point to the wrong section.
Why it happens:
The Brochure fragments use a numeric value in sLinkedItemID to point to linked Sections via Catalog section table's nSectionID.
If you Import / Replace Sections and Products while leaving the Brochure pages in place then any new sections in the import file will increase all subsequent Catalog section table's nSectionID.
Likewise delating a section from the import file will decrease subsequent nSectionID's.
However the BrochureFragments table sLinkedItemID remains unaltered.
Pages are generated with no errors but the sLinkedItemID now points to the wrong section.
Possible fix:
In the database use the catalog section table sPageName value as BrochureFragments table sLinkedItemID rather than nSectionID.
The nLinkedItemType value will differentiate these entries between URL type links and Section type links.
An extra step will be needed at Site generation / Preview time to resolve these text ID's against the Section Id's.
A warning could be made at generation time or import consolidation if links are unresolved.
Workaround:
Use URL type links instead and enter the URL of your section pages. This is fine for Catalog but won't work properly for Business users as it won't maintain logged in customers.
Note:
There may be a similar issue for Product type links if using autogenerated product references.
Norman
Comment