Jump to content
Sign in to follow this  
AdamS

Customising Primary Date

Recommended Posts

I'm running some load file testing attempting to duplicate load files created with other software and I have a question.

Essentially what I'd like to do is have the ability to duplicate the Primary Date column, but have the date format display in a couple of different ways.

My thought was to create a custom field, then duplicate the fields which are listed in the Preferences section for Primary Date, however there is not enough information in the Preferences section for me to duplicate the Primary Date field.

Is there a file somewhere that shows precisely which fields within Raw Data (or elsewhere) that are being parsed for the Primary Date field?

Share this post


Link to post
Share on other sites

Expanding on the above query. I'm attempting to have an all encompassing field like the Primary Date, but them manipulating the way the data displays so instead of the full date and time it will just display the UTC offset, say 1000 or AEST for Sydney.

In my testing I tried creating a custom field which looked for the email sent record ( PR_CLIENT_SUBMIT_TIME ) field in RAW DATA and also in the Headers field, then changed the date/time format using z(Z) or just z or Z and a few other variations.

After re-indexing I cannot get this field to populate with any data at all.

I have tried about 10 different date/time formats and even reverted back to the default. I have tried being specific to emails only or 'ANY' in the setup options.

I have all the other custom fields setup and working correctly (email importance, sensitivity, read receipt request etc), this is the only one that is causing me problems.

Any advice appreciated.

Share this post


Link to post
Share on other sites

Hi Adam!

You should note that Primary Dates are calculated based on values stored in Intella columns. Different file formats are populating it differently: sometimes from RAW DATA, sometimes from item properties directly, etc. Therefore I wouldn't go this road because it would be hard to achieve 1:1 consistency.

However, I think that the solution to your problem is rather simple. I would create a CSV export (or a load file) containing two columns:

  1. Item ID
  2. Primary Date

Primary date will be populated using full date format (date + time + time zone). Then I'd use some text processing tool (Excel, advanced text editors, etc.) to remove date + time from the 2nd column.

Now you'll need to create a new Custom Column of type "TEXT".

image.png

The final step would be to add a new source as a Load File Overlay with following settings:

image.png

As you can see the column which you modified (PRIMARY DATE) will be mapped to new custom column you created (TZ ONLY). Item ID is used to match items.

After the overlay is imported, you will see:

image.png

 

Is that what you need? I hope it helps a bit.

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...