WS Publishing & WS Approval 6.10 will hit the systems on the following dates (TEST / PROD)
|FMCG||September 12, 2018 / September 26, 2018|
|Retailer Portals||September 12, 2018 / September 26, 2018|
|GS1 Austria||September 26, 2018 / September 26, 2018|
|GS1 Belgium||September 12, 2018 / September 26, 2018|
|GS1 Netherlands||September 12, 2018 / September 26, 2018|
|Generic Publishing||September 12, 2018 / September 26, 2018|
|GS1 Australia||September 13, 2018 / September 27, 2018|
Excel Upload Support for Digital Assets
This release brings Excel support for your digital assets to WS Publishing. Download all of the digital asset information belonging to your trade items, modify contained data and re-upload it to the system.
Download of digital assets
The download dialogue for Excel, which can be reached from the item hit list will now offer a new checkbox which allows to include all digital assets which have been linked to the data you’ve selected in the hit list.
By checking this box and triggering the download you’ll find two new sheets within the Excel file, one sheet containing all linked digital assets and their metadata at a glance and another sheet which contains the relations to your items.
Please be aware, that these option is only available, if the digital asset module is accessible for your company.
Managing digital asset data
Digital Asset metadata can be edited and managed exactly like trade item attributes. Instead of a GTIN, GLN and a target market you will have a column containing the URL to your digital asset combined with an information provider. Once an URL has been uploaded in combination with a specific GLN this information provider cannot changed anymore.
Use the remaining columns to edit and update your digital asset’s metadata. It can be used exactly the way you work in an excel sheet to update trade item data, including repetitions and language dependent attributes.
You can also link your digital assets with items which are contained in the excel (or not, but at least available in WS Publishing). Simply browse to the Sheet Digital Asset Links and define your digital asset links. The mechanism works very similar to the mechanism of linking items to each other inside a hierarchy.
The sheet also offers the view from the items to the digital assets, that means you define your items you want to link assets to by providing a GTIN, a GLN and a target market. In addition to that you add columns Related Media Item (each with an index in squared brackets) and provide the URL for each asset you want to link.
Uploading your data back to the system
To upload the items back to the system simply use the upload functionality as available in the item hit list as you’ve done it before. The system automatically detects if any digital asset data is included and will process it correctly.
You can upload any combination of excel sheets: Trade items only, trade items and media objects, also combined with links, or just media items or even only the digital asset links sheet if you only want to combine digital assets with items. Content will be automatically detected and processed.
A pre-check mechanism will inform you about potential problems related to your digital asset sheets and missing mandatory data upfront to the upload processing. If you encounter these messages, correct your sheet by following the messages and upload again.
Limitation of functionality
Please be aware that the functionality is limited to suppliers which have activated the digital assets module. If you don’t have access to the functionality but are interested in, just visit our information web site about 1WS Digital Asset Management.
Upload of URLs is in general limited to digital assets which have been provided to the 1Worldsync Digital Asset Cloud, an import of external URLs will not work.
Optimizations to Excel Upload
We’ve made several adjustments and improvements regarding our Excel Upload Interface in scope of pre-checks, usability and performance.
Increased pre-checks upfront your upload
There is a new pre-check in place which prevents you from uploading item data with an invalid trade item status (allowed values are ADD, DEL, COR, CHN).
There are also new precheck messages in advance of uploading excel sheets containing digital asset data, like checks for a Referenced File Type Code or if the information provider matches the digital asset identified by the URL.
New layout of excel upload report
The format of the excel upload has changed. Not only that it now also provides information about any uploaded digital assets (see above), but also the layout has dramatically been changed. The optimizations should easify the extraction of useful information regarding the uploaded items and assets.
Increased upload time when releasing items
Upload time when releasing items by checking the appropriate box in the UI has been significantly (~35-40%) be improved.
This has been achieved by optimizing the validation behaviour. While a pure storage of the items only needs a basic set of validation rules, we will trigger the more advanced validation functionality necessary to send an item out only if the items will be released.
Optimizations to upload dialogue
The excel upload dialogue opens up in a bigger size, and offers much more space for the precheck messages.
The precheck message area only is visible after triggering an upload and is now scrollable. Precheck messages are now fully visible.
The whole dialogue can also be resized as needed by the user.
Enhancements to digital asset management
As in most of our releases this year the continuous optimization of the digital asset management is also part in release 6.10. Although these are more or less small improvements, they will simplify the life of our users and provide more convenience when working with digital assets.
Digital Assets can now be linked and unlinked within the digital asset editor
Prior to this release the user always had to go the detour via the item editor to link an asset to a trade item (or even to unlink it).
With the new release a digital asset can be linked to any trade item directly from the digital asset editor. Even an unlink is possible from the digital asset editor, when unlinking a trade item
Digital Assets can now be validated from within the digital asset editor
Digital assets have always been validated automatically when saving them in the digital asset editor. It was not possible to explicitly trigger a validation like it is possible for trade item data in the item editor.
With this release the digital asset editor benefits from a new button in the toolbar which allows to trigger a validation of the digital asset metadata at any time.
Click on image opens image in browser instead of downloading it
Clicking on an image within the digital asset editor resulted in a download of the asset to the users computer. We’ve changed that behavior, so that the image now will open in a separate tab in the browser of the user.
Some minor but important changes to the software are documented here. We’ve increased the limit for hit list operations and removed the possibility for downloading empty excel templates.
All hit list operations are now able for up to 100 items
Hit list operations available in the toolbar of the hit list were often limited to a specific maximum of selected trade items. With the new release, all actions in the toolbar are available for a maximum of at least 100 selected items.
No more support for Excel Templates
The provided feature Excel Template has generated more confusion and trouble than value for our users. Creating new trade items from scratch using an empty excel template is hard to manage and users regularly experience a lot of problems with that.
Therefore we’ve decided to discontinue the support of empty excel templates. The focus of using excel is most commonly to use it as mass-update-functionality for existing trade item data, but new items of course can be created by downloading existing data and modify the GTINs / GLNs.