Question

export stamps

Updated December 21, 2017

asked on July 14, 2015

Hello,

I am finalizing a migration from Oracle to MSSQL. We chose to export all of the document out of the Oracle repository and import them into the newly created MSSQL repository. Upon completion, we started to verify that everything came over correctly and noticed that the private stamps that were created by the end users did not come over. I thought they may have been set in the user list attributes. We can log into the old Oracle repository and see/use these stamps. My question is, how can we export these stamps from the oracle db and import into SQL or, will these have to be recreated all over.

0 0

Replies

replied on July 14, 2015 • Show version history

Hi Calvin,

To clarify, do you mean that private stamp annotations that were on the documents themselves didn't come over, or the user's individual stamp lists? If it's the later, that shows that your data got migrated, but not user settings. User settings is stored in the repository attributes and would not be included if you just exported documents out and re-imported them. You can manually export the attributes from the old repository through the administration console, and then import it in to the new repository.

0 0

replied on July 14, 2015

Hi Justin,

Thanks for your response. That is what I was thinking but I wanted to ask as well. I will be trying that tomorrow. Thanks again for your input.

0 0

replied on July 15, 2015

Hi Justin, I tried this and it did not work. Would it matter that the actual repository name has changed as well? I ask because I see references to the old name in the exported attributes. I see the recent stamps listed but once we log in to the client, they are not available.

0 0

replied on July 15, 2015

That could impact it - a lot of these attributes are updated versions of when they used to be stored in the registry and handle multiple repositories. You could try doing a string replace on the xml containing the exported attributes and see if that helps.

0 0

replied on November 14, 2017 • Show version history

Hello Calvin,

Did you use any specific tool from Laserfiche to migrate documents from an Oracle repository to MSSQL Repository? i have a similar project that i am working on and need to check about that.

0 0

replied on December 21, 2017

Hi Pamela,

Sorry for the delay. What we were able to do was export all the documents as volumes and attach the to the newly created repository. Luckily, they had the foresight to create departmental volumes which made it a lot easier.

0 0

You are not allowed to follow up in this post.

Question

Question

export stamps

Replies

Sign in to reply to this post.