Page 1 of 1

Reference in the Application files

Posted: Mon Jun 14, 2010 9:48 am
by Crystal
Hi,

I recently did a complete data-copy from my Test to DEV server. After the data copy, all the Application files point to the Test server and so I am not able to see any data in my Excel files. Is there some way to change all the Application files to point to my DEV server?

I was told restoring the }Applications folder from the DEV backup would resolve this but the guide says the }Applications folder would have just the place-holder files for refrenced/uploaded files. I am not sure how to do this.
Very much appreciate your help.

Thanks,
Crystal

Re: Reference in the Application files

Posted: Tue Jun 15, 2010 11:07 am
by David Usherwood
The simplest way is to open the workbooks and to a global search and replace for xxx_test: to xxx_dev:
On the face of it that would involve republishing them to the server. Since the workbooks are stored in the }Externals folder I think it could work to open them directly there. You could even write a VBA macro to process all of them in one pass.

Re: Reference in the Application files

Posted: Tue Jun 29, 2010 6:25 am
by Crystal
Thanks Dave :)
We finally resorted to global search and replace!