Liveware Publishing Support Forum

We are exporting to Excel spreadsheets with the same name which will overwrite the previous version, which is what we want. Suddenly the spreadsheets are not getting overwritten but rather the new data is being appened. ____We are running on Server 2008, R&R ver 12.5, Via a Citrix connection to a Foxpro application.____Thank you,____Jeffrey Hunt

Here is more information.__We are running a FoxPro application using R&R as our report generator. The FoxPro application is accessed by hitting our Citrix farm and running the FoxPro application. The effect of appending only occurs when we save the file down to our C: drive. If we save the file to the network drive it correctly overwrites the previous copy of the file.____The FoxPro application is a very old legacy application as are many of the reports. We have been running this system on an older Server 2003 Citrix server for years without this problem showing up. Several weeks ago we migrated to a newer Citrix server, the OS on the server is Server 2008 R2. After the move we noticed the Appending instead of Overwriting.

[updated:LAST EDITED ON Nov-01-14 AT 01:15 AM (EST)]We^re not aware of this behavior with worksheet exports. Are you running the program interactively or via ActiveX or other runtime automation? Does R&R prompt to overwrite the file?____Is there some setting within Citrix? Do the new records appear exactly in the next available row?

Our users are logging into our Citrix farm and then launching our old FoxPro custom program we wrote and have maintained over the last 20 years. Our users are selecting Export when given the choice of "Screen", "Print", or "Export". After this they must select some printer and then the Export Type selection comes up, it lists:__ActiveX Viewer File__Excel Chart__Excel Pivot Table__HTML__Result Set (.dbf)__Rich Text Format (RTF)__Text__Text Data File__Word Merge File__Worksheet__Xbase__We select Xbase and then click the Edit button which brings up the File Name and Select Band prompt. The File Name field can be blank or pre-filled in via the report design at design time. The Select Bank lists:__Title__Summary__Record__1GH-xxx__1GF-xxx__2GH-xxx...etc__We are selecting Record.__Whenever our users hand type in a path and file name of an existing file the new data is appended to the bottom of the previous file. And very cleverly not repeating the header information. We are not prompted to overwrite, it just simply appends to the bottom of the previous file. Also, this only happens when we are running on our newer Citrix farm, for years these same reports were working correctly on the old Citrix farm. By the way, we were not asked to overwrite on the old Citrix farm either, the system just did so on its own.____Hope that helps,____Jeffrey.