I don't have an answer to your actual question. However, I did want to acknowledge one discrepancy in your screenshot you referenced, which was:
Notice that you circled the TIME column on the left which is what you are asking bout being blank/empty, but then circled the Creation TIME on the right. Know that the Time COLUMN on the left corresponds to the "Assigned" time on the right, which is BLANK as well. Here's an example from my system:
Notice that the 12:34 pm is for the Assigned time, NOT the Creation time, which is 10:22 in my example.
Again, not an ANSWER to your question, but I thought I would point out this discrepancy, in case it helps any.
Thanks John, good spot. Will confess that's confusing. A web import "just happens" to create the history record. So how or perhaps who is assigning it?
What is creating the Other activity entry? Is it from an automated process? If so you'll need to check the AP and whichever step is creating it to ensure the item was assigned a time in it's options.
Showing assigned in the time column is correct, you don't want creation time shown there because what happens when you created something two years prior and it's coming up in a couple days? The tabs would show it as happening on the two years prior date not in the future.
Thanks for the reply Ian. The [ENQ].... records are all created by the web import. Not by an AP. Is there a way of setting the time on a WI?
hmm, I can't even verify that because the webimport builder system is down. I just don't remember the webimport system creating an Other entry, I know it links the email.
You could use an SQL trigger to copy the time value from Creation into Assigned during the items creation.
The Guide is still accurate. I think, although I can't remember for sure, that I stated that in some versions of GoldMine ( earlier ones ) that things like the CreateOn Date was not entered via a WebImport, and that the developer must code this in to their script. Here is a section of my Code that does just that:
WebImport.TextBody = WebImport.TextBody & "uWebImp=Y" & vbCRLF
WebImport.TextBody = WebImport.TextBody & "MergeCodes=ME" & vbCRLF
WebImport.TextBody = WebImport.TextBody & "CreateOn="& Date() & vbCRLF
WebImport.TextBody = WebImport.TextBody & "udRun=" & Date() & vbCRLF
WebImport.TextBody = WebImport.TextBody & "ucRunTime=06:00" & vbCRLF
I believe the History is created from the following web import setting
SaveThis=[ENQ] Blog Visit
In my version of GoldMine the time is also missing
that is correct the reference comes from the SaveThis field.
@ DJ Hunt I will update our web-import process and test this to see if we start getting the time stamp and update this thread with the result.
The createon date is updated in the DB via the web-import automatically if I try to override the createon value with a custom time-stamp it gets ignored.
It looks like within the GM application the 'ONTIME' value is used in the 'Time' column from the DB.
This field is null for web-imports. Is it possible to set this value in the web-import email?
ondate ontime createon createat type 2016-08-04 00:00:00.000 2016-08-04 00:00:00.000 10:08 web import 2016-08-04 00:00:00.000 2016-08-04 00:00:00.000 10:10 web import 2016-08-04 00:00:00.000 2016-08-04 00:00:00.000 10:10 web import 2016-08-04 00:00:00.000 2016-08-04 00:00:00.000 10:10 web import 2016-08-04 00:00:00.000 2016-08-04 00:00:00.000 10:11 web import 2016-08-04 00:00:00.000 09:35 2016-08-04 00:00:00.000 09:26 LO
As John pointed out earlier, do you know why we would not have an 'assigned' time associated with the web-imports, this is not something we have explicitly changed so I'm at a loss as to why GM would not be creating this.
is your screenshot of a web-import? I ask because there is a 2 hour gap between creation and assigned which strikes me as odd, wouldn't the web-import be assigned to a user immediately upon GM processing the email?
I believe there is currently no way to fix this issue, it is a "known issue" with the GoldMine Web Import functionality. The development team would need to correct this on their end. On a side note, the SaveThis function simply saves the Web Import email body to the history tab. If you are trying to create a History entry it might be more advisable to actually trigger an Automated Process (OnDupAttachTrack= or OnNewAttachTrack=) and have that create the History Entry that you want.
No, Daniel, my screenshot is NOT off a web-import. I was strictly acknowledging the discrepancy about which time field on the right relates to the time column on the left.
Thanks Jerome, we are not looking to create a history record from the web-import itself as we have AP's that will do that if needed, what we were hoping to achieve was having the web-imports in sequence with the other history records for a given day.