You are viewing limited content. For full access, please sign in.

Question

Question

Exporting a lot of documents to Box

asked on October 4, 2016

We have an upcoming project to move ~600,000 Laserfiche documents into Box (box.com). Has anyone done this - mass-transferred documents and metadata to Box? Any suggestions or tips to make this process as efficient as possible? 

Thanks,

Geoff

0 0

Answer

SELECTED ANSWER
replied on October 7, 2016

Just a final follow-up...

I ended up using the SDK to write an app to do the export. As we were working through the requirements I started getting requests like this:

"Can we update the document name to include some of the metadata?"

"Can we reformat the multi-value field metadata during the export?"

"Can we store the reformatted metadata in a DB so we can use it during the Box import?" 

That sort of export functionality is only possible if you have full control over the process, so the SDK/custom app route was the answer for us.

1 0

Replies

replied on October 4, 2016

I've recently completed a large data export project and there a couple of methods to go about this. The easiest solution is to export as a briefcase . It will all depend on how you are going to go about reassociating the metadata with each file in Box. 

0 0
replied on October 4, 2016

Thanks for the briefcase idea. Having a problem getting 7-Zip to open the tar file within the .gz with a renamed briefcase file exported using LF Client 10.1.1.254. Does that method still work?

0 0
replied on October 4, 2016

I wasn't able to get 7z to work either. Winzip worked for me

0 0
replied on October 4, 2016

Thanks, I'll give that a try.

0 0
replied on October 4, 2016

OK, got the briefcase to open. One of the requirements for the document move is to have all docs end up as searchable PDFs in Box. I notice when I export TIFFs using the briefcase, they stay TIFFs, vs exporting using the client Export functionality, which automatically turns the TIFFs into searchable PDFs. Obviously I don't get metadata using the Export button, so it looks like neither method gives me exactly what I need. Would the SDK allow me to export all docs as searchable PDFs with metadata (in whatever form I choose to write it) to match the doc?

0 0
replied on October 4, 2016

In that case, export the files as PDFS. Then have the columns as metadata in the client and export as 'list contents'. This will give you a csv file containing the metadata for each file. 

0 0
replied on October 4, 2016

OK, thanks. I'll take a look at processing the export that way.

0 0
SELECTED ANSWER
replied on October 7, 2016

Just a final follow-up...

I ended up using the SDK to write an app to do the export. As we were working through the requirements I started getting requests like this:

"Can we update the document name to include some of the metadata?"

"Can we reformat the multi-value field metadata during the export?"

"Can we store the reformatted metadata in a DB so we can use it during the Box import?" 

That sort of export functionality is only possible if you have full control over the process, so the SDK/custom app route was the answer for us.

1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.