LSVA.com

[amueller]

I recently received a doc level load file (csv = "begdoc","enddoc") but need to convert it to page-level import file but with retention of doc breaks. Does anyone know of a tool that converts doc level file to page level file? Help is greatly appreciated.

[Larry Lieb]

I am a bit confused by your question - if you have begin doc and end doc, then you already have a "page" level index.

Document level indexes only have Document ID number and no begin or end bates number.

We use LAW software to manipulate data and would be happy to help you out or at least point you in the right direction.

Depending upon your location I can recommend a good local shop too.

[amueller]

I need to convert the concordance.dat file to an opticon.log file so I can import images into Opticon. unfortunately Opp. Counsel only gave me single page tiffs and a beg doc end doc concordance.dat file. Since the opticon file needs to be on a page level and doc breaks need to be indicated with a Y.

[JoeUtsler]

I need to convert the concordance.dat file to an opticon.log file so I can import images into Opticon. unfortunately Opp. Counsel only gave me single page tiffs and a beg doc end doc concordance.dat file. Since the opticon file needs to be on a page level and doc breaks need to be indicated with a Y.

You could try doing a Register-Scan in Opticon, and then using the docbreaks tool in the imagebase manager to set the document breaks based on the database. This assumes a 1-to-1 match between the database and the images, but it sounds like that is what you've gotten. Basically what will happen is that Opticon will look at your database, and create docbreaks on matching imagekeys.

The only downside of Register-Scan is that it doesn't create a Produciton ID entry (it uses the tiff file name), which can make your imagebase messy if you load images from a loadfile later on. That's something that we'll probably change, but in the meantime, if you are concerned, you can export a log file (either before or after you do the imagebreaks) and load that into a Concordance database. It's pretty easy to copy the text from the path field into the Prod ID field (using ftp://dataflight.com/cpl/appendonefield ... icolon.cpl), and then strip out the path and file extension using global search and replace. You then export that and re-create your Opticon DIR using Register-Load. Not particularly pretty, but it doesn't take long, and it'll give you a clean opticon imagebase. That is how I did it at The Lawfirm, so I'm sure that someone has a CPL or just a more elegant way of doing it. If so, speak up!

[amueller]

Great, thanks for the answer, just the only problem is, I need all this to create a summation .dii file with doc breaks.

[JoeUtsler]

Great, thanks for the answer, just the only problem is, I need all this to create a summation .dii file with doc breaks.

Well, sadly that's outside of my expertise. I'm confused though. If you need a .dii file, why do you need to load into Opticon at all? I am assuming you don't use Opticon as your Summation image viewer, right? The .dat file is (as Larry said in the IPRO forum), simply a delimited file, so you can fiddle with it in Excel or Access. Concordance allows you to select any delimiters you wish, and you may need to open the .dat file in a standard text editor to replace them with standard comma-quote delimiters, but beyond that it's just a text file.

[amueller]

Yes, maybe I did not put it into the right words. I have plenty of tools to create a summation .dii file, but all those tools need an image and document break reference file that is on a page level, not a doc level. unfortunately the only reference file I have is a csv with the 1st field being the begin doc nr and the 2nd field being the end doc nr. I was looking for a tool that can take that csv (which is like a concordance load file) and convert that to an opticon file. Then I can easily take that opticon file and create a summation .dii file from it. So in other words, I am seeing a tool or script that can make an opticon or ipro lfp (or any other page level format) out of a document level csv.

[Shan]

You are checking for a tool that could create an opticon loadfile (page level) from an document level .csv file.

I had similar situation before, but I could get the utility that could perform the task. I took the image reference number to excel and manipulated an .opt file with help of few excel formulas (vlookup).

[Shan]

You are checking for a tool that could create an opticon loadfile (page level) from an document level .csv file.

I had similar situation before, but I could get the utility that could perform the task. I took the image reference number to excel and manipulated an .opt file with help of few excel formulas (vlookup).

[Shan]

You are checking for a tool that could create an opticon loadfile (page level) from an document level .csv file.

I had similar situation before, but I could get the utility that could perform the task. I took the image reference number to excel and manipulated an .opt file with help of few excel formulas (vlookup).