Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation since 10/03/2016 in all areas

  1. From time to time we get requests on assisting with moving an authorization server. There are many reasons why someone might want to do this, but if you forget to do some small steps, it will result in having to call Ipro Support to clear everything for you before you can reauthorize. This also affects moving serial numbers for Classic products between machines as well. So to help make things easier the next time you need to move your authorization, here is how to do it without needing to call in. Online Authorizations On the ORIGINAL authorization machine, open the Ipro Auth Manager. Note for eScan-IT and Copy+ this can be accessed manually by going to the install location Click on Authorization Management > Remote Management > Deactivate Install the Ipro Auth Manager on your NEW authorization machine and input your ClientID and Serial number from the other machine. If it is already installed, click on Authorization Management > Remote Management > Activate Ensure your get a Valid status in your Auth Manager [ATTACH=CONFIG]n2686[/ATTACH] Offline Authorizations Install the Ipro Auth Manager on your NEW authorization machine and input your ClientID and Serial number from the other machine. Open the Ipro Auth Manager on the NEW machine Click on Authorization Management > DAT Management > Export Save the DAT file somewhere on your computer Email CSR@Iprotech.com with that DAT file and request for it to be authorized. You should receive a new DAT file from them Go back to the Ipro Auth Manager and click Authorization Management > DAT Management > Import Select the new DAT file you received from CSR@iprotech.com Ensure you see the Valid status in your Auth Manager [ATTACH=CONFIG]n2685[/ATTACH] For dongle users, the only thing to remember is to move the dongle from the old machine to the new machine. If you for whatever reason can no longer access the Ipro Auth Manager from the ORIGINAL machine and you are using an online authorization, please contact Ipro Technical Support to have us clear your account manually on our end so you can reauthorize on the new machine.
    2 points
  2. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  3. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  4. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  5. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  6. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  7. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  8. even if an inline image is not a company logo, it still appears in the email and the email can be imaged with the inline image in place. I find that we end up marking all inline images as logos anyhow. they are not really relevant most of the time and when they are, it's an exception to the rule
    2 points
  9. Just to add further on Tyson's reply, you need to check your settings at 2 levels, while processing & export. A lot of times PDF files contain huge drawings, when they are processed with "As Is" settings for color and page size, they turn out to be huge jpeg files in terms of resolution and size. This could significantly increase your size of export. In past I had received a processing request from a client to process everything in TRUE COLOR. The data was just a single small PST of 1.98 GB. I tried to convince the client it would not be advisable to do everything in color, but in vain. The resultant deliverable was 28.89 GB.
    2 points
  10. Just to add further on Tyson's reply, you need to check your settings at 2 levels, while processing & export. A lot of times PDF files contain huge drawings, when they are processed with "As Is" settings for color and page size, they turn out to be huge jpeg files in terms of resolution and size. This could significantly increase your size of export. In past I had received a processing request from a client to process everything in TRUE COLOR. The data was just a single small PST of 1.98 GB. I tried to convince the client it would not be advisable to do everything in color, but in vain. The resultant deliverable was 28.89 GB.
    2 points
  11. Janeane, Please use the following instructions and let me know if you need any additional help 1. From Case Management navigate to Database Records and then click "Build Search" 2. Select your saved search from the drop down in the top right 3. Run the search and then right click in the results and select "Delete Document(s) in Search" 4. Select "Delete Documents and Pages/Images" and then click Start 5. Once this has been complete navigate back to the Desktop module and verify the documents have been removed
    2 points
  12. If, when you log into Eclipse SE, you get the error: [ERR]"Error deleting layout files: Attempting to deserialize an empty stream."[/ERR] You should do the following: Close Eclipse SE. Open Windows Explorer. Go to C:\Users\Your Username Goes Here\AppData\Local\Ipro_Tech,_LLC Rename the EclipseDesktop.exe_Url_[###] folders to .OLD. Go to C:\Users\Your Username Goes Here\AppData\Local\IProEclipse Rename the UserSettings folder to .OLD. Re-launch Eclipse SE. The error should no longer appear.
    2 points
  13. When ingesting a Unicode PST into Eclipse SE, you can potentially get errors stating that it's "Unable to extract file from attachment #:". You'll then see a filename with special characters that shouldn't be there. This is due to the fact that there are Unicode characters in the subject line of the email. The 32-bit version of Stellent doesn't support those characters in the filename/subject line. When you see this error, it also means that you're case will be missing those parent items. There are two ways to fix this: Option 1: Purchase the Streaming Ingestion license for the 2016.3.2 version of Eclipse SE, and ingest the PST that way Option 2: Convert the Unicode PST to ANSI 1. Launch Microsoft Outlook 2. On the Home screen, click on New Items > More Items > Outlook Data File 3. Provide the new ANSI PST with a name, then click the drop-down menu for 'Save as type' and set this to Outlook 97-2002 Data File. Click OK. You have now created an ANSI PST file 4. Now, you need to load the Unicode PST into Outlook. Click on File > Open > Open Outlook Data File 5. Point to the Unicode PST and click Open 6. On the far left panel of Outlook, you will now see at least two different PSTs. One for your ANSI PST, and the other for the Unicode PST that you just opened 7. Go to File > Open > Import 8. Set the action to Export to a File, and click Next 9. You want to set this file type to Outlook Data File, and click Next 10. You are now presented with another window that says "Select the folder to export from:". You will be selecting either the entire Unicode PST, OR you will be selecting individual folders from that Unicode PST. **Please note that Microsoft has a limit on the maximum file size for ANSI PSTs. This limit is set to 1.93 GB. If your Unicode PST is larger than that, then you'll need to create ANSI PSTs for each root folder within the PST, and convert the folders accordingly from the Unicode to the ANSI PST** 11. On this next screen, you'll be browsing to the ANSI PST that you created, and also set the radio button to Allow Duplicate Items to be Created. Click Finish. 12. You'll then be presented with a warning message that basically says you are exporting data to a file that doesn't support Unicode. Just click OK 13. Once the export completes, navigate to the directory that you saved/created your ANSI PST in. This PST can now be ingested into Eclipse SE, under the Ingest Natives screen, without getting those errors
    2 points
  14. Experiencing an issue with loading Eclipse web? Here are a couple troubleshooting steps that can be checked: Ensure the browser is Internet Explorer version 7.x - 11 32-bit Add the Eclipse website address to the the Trusted Sites zone by going to Internet Options > Security > Trusted Sites > Sites. Then, add the website address, and click 'Add'. Next, please reload the website. Ensure that the 'Enable Protected Mode' box is not selected for the Trusted Sites zones within the Internet Options of Internet Explorer. Ensure that the security level for Trusted Sites zone is set to Medium defaults. Try clearing the Application Cache. This can be done by closing Internet Explorer completely, then opening Command Prompt as an Administrator, and pasting the following command and hitting enter: rundll32 %windir%\system32\dfshim.dll CleanOnlineAppCache Then, restart Internet Explorer and try accessing the Eclipse website. Ensure .NET Framework 4.5 or above is installed. This can be checked when opening the Control Panel > Programs and Features. The installation must say .NET Framework 4.5 or above. If states client or profile in the entry name, please install .NET Framework 4.5. The download can be found at Microsoft's website: https://www.microsoft.com/en-us/down....aspx?id=30653 The minimum screen resolution should be set to 1280x1024 or greater. Check to see if a proxy is enabled by going to Internet Options > Connections > LAN Settings. Ensure that 'Automatically detect settings' is enabled. If it is not, and a Proxy Server is being used, then please adjust the proxy server accordingly to allow connections to the Eclipse website. If anyone has any other steps they want to add, please feel free to reply to this post, as there are many different situations that could apply.
    1 point
  15. If you are ever in the situation where you need to pause a job for some reason, then you should know the possible impact this could create with deduplication. In general, pausing a job will not impact anything with the job, but this can change depending on other jobs that are running or will be run. Here is an example of something that can happen: We start a job called Job A. Then we pause Job A and start another job (Job B) in the same custodian. We are de-duplicating at the custodian level. Let's say Job A has processed 10 files before it was paused, one of those files was found in Job B > Job B will list the item as a duplicate of the item in Job A. Let's let Job B finish and unpause Job A and let it finish The last item in Job A was a duplicate of an item in Job B > Job A will deduplicate it out, keeping the item from Job B In this case both jobs have an item that was deduplicated from the other. Whichever job discovers the item first will be the reference, and all other jobs will mark their items as duplicates, even if one job finishes before the other or if a job is paused. Let's go over another scenario: Let's start Job A and let it get though the same 10 documents again, then pause it Now we will start Job B and let it finish. One of Job B's items is a duplicate of one of the items in Job A that is done with processing, and gets deduplicated Now we delete Job A. What happens to the item in Job B? It still is marked as a duplicate, and will still be deduplicated. Now we are in a problem where an item is getting marked as a duplicate despite the original job being deleted. Normally if we delete Job A before starting Job B, this wouldn't cause a problem, but because the jobs were active at the same time, the jobs are now "linked" by their duplicate items, and deleting one job means potentially re-running the other.
    1 point
  16. If users are utilizing review passes and batches, but don't want to manually click the reviewed 'tag' after viewing their documents, there is a simple way to change the status automatically. 1. Make sure that you have at least one required tag group, a popular one is Responsiveness/Relevant tags This is done in the tag palette tab in Case management, and modify tag palette. 2. Create a Coding form. Also in Case management, the Coding Forms tab will be selected. Create a new coding form. Select the fields, and tags that the reviewers will need access to, and make sure that the required tag group is in the list. Under the Rules tab, 'Add' a new rule, give it a name, (something like Review status will work) Change the syntax to look like this: If Tag_Group 'YOUR REQUIRED TAG GROUP' is TAGGED then 'YOUR REQUIRED TAG GROUP' must be TAGGED 2. Setup your review pass to allow the status to change automatically. This can be done from the 'Create/Manage Review Batches' menu in SE admin. Once a review pass is created, under the 'Review Pass Details' tab, select the option to use the review status Coding form, and to 'Automatically set documents to Reviewed if coding rules are met' 3. Create the batches of your desired document set 4. If a user logs into a batch, and has the 'reviewed status' coding form selected, when they tag any tag within the required group, the document review status will change to Reviewed.
    1 point
  17. Happy Friday iPro Community!!! If you didn't already know, we've been publishing a good amount of updated training videos on the MyIpro Website. These short, individual clips walk through common scenarios for both end-user and admin roles. I've provided links below for your convenience. Eclipse: https://myipro.iprotech.com/ExternalLink/ResourceCenter/EclipseVideos Eclipse SE: https://myipro.iprotech.com/ExternalLink/ResourceCenter/EclipseSEVideos ADD: https://myipro.iprotech.com/ExternalLink/ResourceCenter/ADDVideos Enjoy!
    1 point
  18. For a Streaming Discovery job, the way to filter out Thumbs.DB file from being export would be to uncheck the "Compound Document" option located under the "Unknown" Category on the Filter Options tab. The Thumbs.DB file will still be listed in the discovery report but it will be excluded from the export.
    1 point
  19. I've received a call here or there where a user got a new machine and installed Eclipse SE and the buttons were missing text, or there were other strange display issues. One such call came from @Lori Bregenzer and she helped me figure out a way to work around this: 1. Right-click on the desktop. Choose "Display Settings", or go to Control Panel -> appearance and Personalization -> Display 2. Locate the Change the size of all items section. 3. Change the size to Smaller - 100% 4. Restart the PC to apply the changes universally.
    1 point
  20. In JobStatuses, there is a 'status' value indicating the current state of a job. These enumerations are as follows: 1 = Unstarted 2 = Pending 3 = InProgress 4 = Paused 5 = Complete 6 = CompleteWithErrors 7 = Deleted The status value of 6 applies to discovery jobs ONLY (jobtype = 4). Even though we will see data extract, processing and export jobs complete with errors, this status is determined by eCapture using a built-in procedure to identify any items during these job types that resulted in error (these will appear in JobStatuses as Status = 5 even though they report as "Completed with Errors" in the Controller UI). Manually applying a status of 6 for any one of these jobtypes can result in unexpected behavior across the configuration environment such as errors thrown in the controller and Queue Manager for unrelated/inactive jobs, or intermittent halting of worker processes.
    1 point
  21. Hello, If you are opening the Ipro Authorization Manager (whether with eScan-IT or another software) and you receive the error: Unable to connect to service! Please ensure the Ipro Authorization Service is running. The error indicates the manager cannot connect to the Ipro Authorization Service. Most of the time, this is usually caused by the service not being started. Additionally, check to make sure the IP Address within the Ipro Authorization Manager matches the configured IP address for the Ipro Authorization Service. -Cody
    1 point
  22. I've come across this question quite often. "I'm searching for a specific keyword, and the hits contain records that do not have that keyword in extracted text. Why is this happening?" The short answer is that when doing a Keyword search, DTsearch will search through all indexed fields and not just extracted text. However, there is a way to only search through the extracted text field. Using the following: //TEXT contains (term) Search extracted text for the specified term or phrase. Example: //TEXT contains (limited resources) • //TEXT contains (term1 or term2) Search extracted text for either of the specified terms or phrases. Example: //TEXT contains (solar or wind) • //TEXT contains (term1 and term2) Search extracted text for both of the specified terms or phrases. This is a great way to ensure that your search results are more accurate.
    1 point
  23. I've come across this question quite often. "I'm searching for a specific keyword, and the hits contain records that do not have that keyword in extracted text. Why is this happening?" The short answer is that when doing a Keyword search, DTsearch will search through all indexed fields and not just extracted text. However, there is a way to only search through the extracted text field. Using the following: //TEXT contains (term) Search extracted text for the specified term or phrase. Example: //TEXT contains (limited resources) • //TEXT contains (term1 or term2) Search extracted text for either of the specified terms or phrases. Example: //TEXT contains (solar or wind) • //TEXT contains (term1 and term2) Search extracted text for both of the specified terms or phrases. This is a great way to ensure that your search results are more accurate.
    1 point
  24. Hey Wade, The thing about XMLs is that many applications use a form of XML and modify it to create their own file type and extension. When eCapture/Stellent tries to identify it, it sees it for what it truly is and it this case it is identifying it to be an XML file. In looking up what an ESX file is, it seems to be some sort of an insurance claims software which doesn't surprise me that it could be a modified XML.
    1 point
  25. Hey Wade, The thing about XMLs is that many applications use a form of XML and modify it to create their own file type and extension. When eCapture/Stellent tries to identify it, it sees it for what it truly is and it this case it is identifying it to be an XML file. In looking up what an ESX file is, it seems to be some sort of an insurance claims software which doesn't surprise me that it could be a modified XML.
    1 point
  26. Hey Wade, The thing about XMLs is that many applications use a form of XML and modify it to create their own file type and extension. When eCapture/Stellent tries to identify it, it sees it for what it truly is and it this case it is identifying it to be an XML file. In looking up what an ESX file is, it seems to be some sort of an insurance claims software which doesn't surprise me that it could be a modified XML.
    1 point
  27. Hey Wade, The thing about XMLs is that many applications use a form of XML and modify it to create their own file type and extension. When eCapture/Stellent tries to identify it, it sees it for what it truly is and it this case it is identifying it to be an XML file. In looking up what an ESX file is, it seems to be some sort of an insurance claims software which doesn't surprise me that it could be a modified XML.
    1 point
  28. Hey Wade, The thing about XMLs is that many applications use a form of XML and modify it to create their own file type and extension. When eCapture/Stellent tries to identify it, it sees it for what it truly is and it this case it is identifying it to be an XML file. In looking up what an ESX file is, it seems to be some sort of an insurance claims software which doesn't surprise me that it could be a modified XML.
    1 point
  29. When will we have the ability in the GUI to bulk update the Review status of documents when a reviewer mass tags documents
    1 point
  30. When will we have the ability in the GUI to bulk update the Review status of documents when a reviewer mass tags documents
    1 point
  31. When will we have the ability in the GUI to bulk update the Review status of documents when a reviewer mass tags documents
    1 point
  32. When will we have the ability to export Saved searches when exporting a case template?
    1 point
  33. When will we have the ability to export Saved searches when exporting a case template?
    1 point
  34. When will we have the ability to export Saved searches when exporting a case template?
    1 point
  35. one more thing, make sure you change the field name for "DOCID" to avoid confusion during export.
    1 point
  36. And to piggyback on the responses so far, an exported load file and processed data from Clearwell can be imported via the "Import Wizard" of eCapture in order to maintain custodial and metadata information. These fields can become external fields which helps maintain the key fields from Clearwell.
    1 point
  37. A Tag group will turn to red text whenever tags that created under it have been used. The red text indicates that it cannot be changed (other than renaming) while it's tags are in use. In order to make changes other than renaming you would either have to clear all documents of that tag first, or create a new tag containing the edited information, run a search on the original tag, tag those results with the new tag, and then remove the original tag. This would allow that tag to be edited/deleted.
    1 point
  38. A Tag group will turn to red text whenever tags that created under it have been used. The red text indicates that it cannot be changed (other than renaming) while it's tags are in use. In order to make changes other than renaming you would either have to clear all documents of that tag first, or create a new tag containing the edited information, run a search on the original tag, tag those results with the new tag, and then remove the original tag. This would allow that tag to be edited/deleted.
    1 point
  39. This is an Internet Explorer permission error that can be corrected using the following steps Add the Eclipse website to trusted sites [ATTACH=CONFIG]n1590[/ATTACH][ATTACH=CONFIG]n1592[/ATTACH] Set a custom level for trusted sites (custom level button shown above) to enable Loose XAML, XAML browser applications, and XPS documents. [ATTACH=CONFIG]n1591[/ATTACH] From here the "This application type has been disabled" error should be resolved. If a different Eclipse website (or the same website from a different version of Eclipse) has been accessed from the same computer you will need to run "rundll32 %windir%\system32\dfshim.dll CleanOnlineAppCache" in a command prompt before connecting to the website.
    1 point
  40. This is an Internet Explorer permission error that can be corrected using the following steps Add the Eclipse website to trusted sites [ATTACH=CONFIG]n1590[/ATTACH][ATTACH=CONFIG]n1592[/ATTACH] Set a custom level for trusted sites (custom level button shown above) to enable Loose XAML, XAML browser applications, and XPS documents. [ATTACH=CONFIG]n1591[/ATTACH] From here the "This application type has been disabled" error should be resolved. If a different Eclipse website (or the same website from a different version of Eclipse) has been accessed from the same computer you will need to run "rundll32 %windir%\system32\dfshim.dll CleanOnlineAppCache" in a command prompt before connecting to the website.
    1 point
  41. Hi Michael, With Eclipse SE, there is a function that I believe will do what you are asking for. You would basically draw the redaction on a page. Once drawn, you would right-click on the redaction itself, and go to the Annotation Options section, then select 'Apply to Range'. A new box will pop up with the image keys listed. You can select the beginning image key, and the ending image key to be applied to.
    1 point
  42. Tom, Data extraction is different from Processing in that Processing performs imaging on documents where Data Extraction does not. There is less overhead to run Data Extraction which will result in quicker job completion times. Use Data Extraction when document imaging is not required.
    1 point
  43. Tom, Data extraction is different from Processing in that Processing performs imaging on documents where Data Extraction does not. There is less overhead to run Data Extraction which will result in quicker job completion times. Use Data Extraction when document imaging is not required.
    1 point
  44. Tom, Data extraction is different from Processing in that Processing performs imaging on documents where Data Extraction does not. There is less overhead to run Data Extraction which will result in quicker job completion times. Use Data Extraction when document imaging is not required.
    1 point
  45. Tom, I understand Clearwell is an eDiscovery platform similar to eCapture. If you point eCapture to the exported native directory from a Clearwell export it will discover and extract document families in the native folder as it would any other source directory. If you need to import the corpus into eCapture as processed data, then an .LFP (image load file *if document images exist) and .DAT (data load file) file will be required to import the corpus using the eCapture Import Wizard. Family relationships can be determined from the LFP file if images exist for the corpus, or can be read from the BEGATTACH field in the data load file if no images are being imported with the corpus. The BEGATTACH value will be the Item's parent BEGDOC number. All items in a family will have the same BEGATTACH value in the data load file. eCapture supports Concordance, Summation, IPRO, Ringtail, CSV, and Custom Delimited export formats upon output from eCapture. I understand that Clearwell may rebuild mail stores upon export and may not point to loose MSG / EML natives on disk after after export, but rather, point to the PST. If this can be avoided in the Clearwell export it will make the import into eCapture much easier. You can find a document outlining some commonly encountered metadatafields at the link below: https://myipro.iprotech.com/ResourceCenter/#/eCapture/Supplemental%20Documents
    1 point
  46. Tom, I understand Clearwell is an eDiscovery platform similar to eCapture. If you point eCapture to the exported native directory from a Clearwell export it will discover and extract document families in the native folder as it would any other source directory. If you need to import the corpus into eCapture as processed data, then an .LFP (image load file *if document images exist) and .DAT (data load file) file will be required to import the corpus using the eCapture Import Wizard. Family relationships can be determined from the LFP file if images exist for the corpus, or can be read from the BEGATTACH field in the data load file if no images are being imported with the corpus. The BEGATTACH value will be the Item's parent BEGDOC number. All items in a family will have the same BEGATTACH value in the data load file. eCapture supports Concordance, Summation, IPRO, Ringtail, CSV, and Custom Delimited export formats upon output from eCapture. I understand that Clearwell may rebuild mail stores upon export and may not point to loose MSG / EML natives on disk after after export, but rather, point to the PST. If this can be avoided in the Clearwell export it will make the import into eCapture much easier. You can find a document outlining some commonly encountered metadatafields at the link below: https://myipro.iprotech.com/ResourceCenter/#/eCapture/Supplemental%20Documents
    1 point
  47. vkoelsch, Step 1: Export out a csv of just the begdoc of the documents that are being deleted [ATTACH=CONFIG]n1436[/ATTACH] Step 2: Open in Excel and add a new column "ExtractedText" and save [ATTACH=CONFIG]n1437[/ATTACH] Step 3: Import the csv into the case using an overlay on begdoc and map extractedtext to the extractedtext system field in the Case As for the system speeds for ingestion, can you attempt an ingestion of a local file and test against the speed of an ingestion from the server location to see if this is where the slow down is occurring? Thank you, Levi Roble Technical Support Engineer 2
    1 point
  48. vkoelsch, Step 1: Export out a csv of just the begdoc of the documents that are being deleted Step 2: Open in Excel and add a new column "ExtractedText" and save Step 3: Import the csv into the case using an overlay on begdoc and map extractedtext to the extractedtext system field in the Case As for the system speeds for ingestion, can you attempt an ingestion of a local file and test against the speed of an ingestion from the server location to see if this is where the slow down is occurring? Thank you, Levi Roble Technical Support Engineer 2
    1 point
  49. Hello Lukeyluke, Thank you for posting in the Community. Since Eclipse does not have straight deduplication functionality, the method you are using which is calculating the originals based on data in Excel, would be the best. In this logic, it sounds like we are selecting only unique values for MD5Hash, and assuming that the first BegDoc that appears with the MD5Hash value is the original. If this is becoming cumbersome in Excel and is taking awhile, there is an alternate solution using SQL Server that we can: 1. Group by MD5Hash value 2. Take the first DocId that appears with that MD5Hash value 3. Tag the document as original. In this instance, you could then run a search on the 'Original' tag, whether it be equal to or not equal to. To do this, follow the steps below. In the Eclipse case, create a tag that will be used to tag the Original documents. Access SQL Server Management Studio, and find the name of the Eclipse database. The database name can be found by creating a new query on the Nucleus/ADD database, and running the following query: SELECT Name, DatabaseName FROM Enterprise.CaseProductEnvironment WHERE ProductId = 3 [*]Once you have the database name, find it in the Object Explorer, right click the database, and click 'Create New Query'. [*]Next, we will need to determine the unique ID number that is assigned to the Document Tag that we created in step 1. The TagID can be found by running the following query: SELECT TagId, TagName FROM dbo.Tags [*]When you have located the TagId, you can then create a new query window and run the following query: DECLARE @EclipseDatabaseName nvarchar(max) DECLARE @TagId nvarchar(max) DECLARE @SQL nvarchar(max) SET @EclipseDatabaseName = 'DBNAMEHERE' -- Eclipse Database name here SET @TagId = IDHERE -- TagId here SET @SQL = 'USE ' + @EclipseDatabaseName + ' IF OBJECT_ID(''TEMPDB..#InsertTags'') IS NOT NULL DROP TABLE #InsertTags SELECT min(DocId) as DocId, ' + @TagId + ' AS TagID INTO #InsertTags FROM vDocumentFields GROUP BY MD5HASH INSERT INTO dbo.DocumentTags SELECT * FROM #InsertTags WHERE DocId NOT IN (SELECT DocId FROM dbo.DocumentTags WHERE TagID = ' + @TagId + ') DROP TABLE #InsertTags' exec (@SQL) Please Note: You will need to replace the information between the single quotes SET @EclipseDatabaseName = 'DBNAMEHERE' to the Eclipse Case database name that we retrieved in step 2. Additionally, this will also need to be done for SET @TagId = IDHERE. Please replace the IDHERE with the correct TagId. [*]The query will have tagged the documents that have a DocId of the lowest value, grouped by MD5Hash value. Please let me know if the logic you are using on your Excel calculations differ, and we can adjust the query.
    1 point
  50. Lori, This may be a good discussion with our Product Management team. We will present the feature to them and get you the feedback.
    1 point
×
×
  • Create New...