# Published Dates and Issue Configs

## Published Dates

Navigate to **Setup -> Product Setup -> Published Dates**. Select a print publication or issue-based digital product from the product drop-down. Also select if you wish to select the dates in order entry by a dropdown list of dates (common for magazines) or by a calendar (common for a daily publication)

Click on each calendar date which applies to this publication.

You can also use the “Auto Select Issues” for a faster choice of dates, especially if this is a daily or weekly publication. Choose the start and end dates, as well as the specific days of the week. When finished, click “Apply” and save the details by clicking on the “Save” button. ![](https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-0a9da970ebb7a1ee7fbb2f4663dc03ca5dbc090b%2Fimage%20\(647\).png?alt=media)

Note also that some dates are greyed out and not available for selection if you attached a holiday calendar to them in the Product Details node.

Once you have booked orders to a date, the date will also be grayed out and you won't be able to deselect it. If you create an issue, book orders for it, and decide to move the issue to another date, use the procedure to [**Change Issue Date/Period**](https://docs.navigaglobal.com/naviga-ad/2024.6/naviga-ad-modules/advertising/campaigns/managing-campaigns/change-issue-date-period).

## Issue Configuration

This node allows you to setup each issue for the product.

Choose the product from the drop-down menu and choose the start date for viewing the config for the publication or e-newsletter. You can make changes in bulk to the issues by using the drop-down field of “Bulk Update Options”. This allows you to enter the financial period, issue description, closing date, comparison issues and budgets for each issue to be standardized and filled in mass. Save the settings after all the bulk changes. Note that any times such as close time is the server time zone and not your time zone as a user.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-19c351247696be66325aa510f3842f1b6608c82e%2Fimage%20(1015).png?alt=media" alt=""><figcaption></figcaption></figure>

If you have set up your product already, the issue close date and the material due date will be filled in automatically when you create the Published Dates in the previous step. If you did not already set up your default deadline before creating issues, you can still add them manually or in bulk here.

The comparison issue is optional, but is helpful if you would like to see comparison information on the Publication analysis report. Financial period is required before saving this config.

## Issue Import

This node allows you to import issues in bulk for a publication or an issue-based digital product.

To do so, navigate to the menu **Setup -> Product Setup -> Issue Import node.**

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-0ba8a4216931535fb926c2aeab33a4a4188e66fc%2Fimage%20(482).png?alt=media" alt=""><figcaption></figcaption></figure>

Click the button “Download Template” which opens a spreadsheet template on your desktop with various fields to fill out.

Alternatively, if the goal is to update an existing set of issues, instead of downloading a blank template, navigate to the Issue Export below the Issue Import and Export existing issues to modify and re-import.

### Issue Import Template <a href="#toc9433602" id="toc9433602"></a>

The fields are:

| **Field Name**            | **Example of Data** | **Source of Data and Restrictions**                                                                                       | **Mandatory/ Optional** |
| ------------------------- | ------------------- | ------------------------------------------------------------------------------------------------------------------------- | ----------------------- |
| **Product ID**            | VisitMont           | Must match the product ID in Naviga Ad                                                                                    | Mandatory               |
| **Issue Description**     | March Issue         | The description is free form alphanumeric text                                                                            | Optional                |
| **Issue Date**            | 03/02/2019          | MM/DD/YYYY is the date when the issue is being published                                                                  | Mandatory               |
| **Close Date**            | 03/01/2019          | MM/DD/YYYY is the date when no changes can be made to the issue                                                           | Mandatory               |
| **Financial Period**      | 2019-03             | YYYY-MM is the financial period which must match the one in Naviga Ad and to which this issue is tied.                    | Mandatory               |
| **Budget Pages**          | 30                  | Numeric free form entry of the number of pages in the budget.                                                             | Optional                |
| **Budget Revenue**        | 3000                | Numeric free form of the budget revenue for this issue.                                                                   | Optional                |
| **Comparison Issue Date** | 01/31/2019          | MM/DD/YYYY issue to the prior year issue for comparison in reports.                                                       | Optional                |
| External ID               | 123                 | Alphanumeric ID Unique to this issue. Used as needed for API integrations                                                 | Optional                |
| Close Time                | 16:00 or 4:00 PM    | Text field on the import. Enter in military time or be sure to include PM for afternoon times. 4:00 will come in as 4 AM. | Optional                |
| Material Due Date         | 03/01/2019          | MM/DD/YYYY is the date when materials are due                                                                             | Optional                |
| Digital Edition URL       | <https://abc.com>   | URL for the e-edition                                                                                                     | Optional                |

{% hint style="info" %}
NOTE on the Close Time - Do not re-use a template that you had from prior releases, or copy and paste these values in from a prior test. The cell formatting is important here so be careful not to paste in formatting from another source.

if the format is "Custom" it will cause problems. Please ensure that the format is "General" or "Text" and NOT Custom.
{% endhint %}

### Import Issues <a href="#toc9433603" id="toc9433603"></a>

Fill in one rows per issue in the template and save to your desktop.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-a352c6bee99095e929c001187377e3b6c173c22d%2Fimage%20(1205).png?alt=media" alt=""><figcaption></figcaption></figure>

On the import page, click on the button “Select” and browse for the template saved on your desktop.

If updating existing issues, set the Overwrite Existing to Yes

On the Import page in Naviga Ad, click the button “Test Import File”. This step is important in clearing out all errors in the import before the import takes place.

![](https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-cf47f1239e1283cace7ae98c6c366108f3facccf%2F4%20\(51\).png?alt=media)

Click the OK and read the error messages which the system provides so you can return to the template and make the necessary changes. Re-save the template to the desktop; remove the existing uploaded file by clicking on the import page on the x remove button. Reload the correct template and test it again. Repeat the uploading and testing process till all the errors are gone and the system gives a success message.

![](https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-089e0f8a99d251607c91692ec33665d87f46031a%2F5%20\(65\).png?alt=media)

Click on the “Import File” button on the import page. Click OK and the system imports the issues.

Click on the node “Issue Configuration” and choose the product from the drop-down menu. Note that the new issues with all the details have been imported to the product and are now ready for use in campaign entry.

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-45bf97110a29be7ffb908146f9877d4297fcdf78%2Fimage%20(1605).png?alt=media" alt=""><figcaption></figcaption></figure>

## Export Issues

To Export Existing Issue configuration data, navigate to Issue Export in Product Setup

<figure><img src="https://4211026745-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FbpQetEHnD9yA7QkbIXqU%2Fuploads%2Fgit-blob-3d5986738a05e8435ef96d3f0dd3a0618b672063%2Fimage%20(371).png?alt=media" alt=""><figcaption></figcaption></figure>

To Export the configuration,

1. Select to export a single product, or a Product Group
2. Select the Product or Product Group to export
3. Select the Date Range to Export
4. Click the export button
5. This will download an excel spreadsheet to your downloads folder which can be opened and modified as needed.
6. The downloaded spreadsheet will be in the format needed to then upload via the [**Issue Import**](#issue-import) process. If exporting with the intention of updating issue configuration details (for example budget data that might come later), be sure to select "Overwrite Existing" in the Issue Import process.
