Basically thats not even needed , writing a macro to fetch the latest data from XML into a Excel workbook - if an XML Map exists in that document. You then can simply "refresh" the data and the XML

Hi Keith, This would work if you have only few places like this in your application otherwise it would be too much work to maintain the templates. I have export programs all over in my

Lado, Kind of late to the conversation… What about having a separate formatted spreadsheet (the way you want it) that has a macro that reads the DataviewToXML output file as an input file,

Hi Lado, How would you do that with SQL ? With SQL you can generate .CSV, that however does not allow you to specify data types and formatting options. It would however be easy to create a generic

Hi All We're finally going to start upgrading some of our uniPaas customers to Magic xpa. What is the best xpa release to upgrade to, i.e. the most up to date, without being on the 'bleeding

Thank you Andreas. may be I'll try to do with SQL and see if it works.

Hi search for another folder in the user\local\temp....from memory its called mgriacache - delete this , this is the app cache - magic will pull it all down again if its somehow corrupt From:

LDAP has my preference, but that isn't applied in our application. So, no issue. I decided to move the old user file to the new environment anf have our consultant enter the new secret names.

Well you can use http://kb.magicsoftware.com/articles/bl_Reference/UserAdd-xpa-3x to add the users from userdump utility to your new security file(s). They will get a new password and you'll need to

Normally I would use the old user file, but in the new release of our application a few new secret names were added.

Hi Tim, Do you mean the one found in the %userprofile%\AppData\Local\Apps\2.0? If that's the case then Yes I cleared that and I reinstalled the client already. Best Regards, Darren

Have u cleared the RIACache on users machine ?

Hello Everyone, Can somebody help me why a certain user is experiencing an error upon starting of our RIA application. But it works well on other users. please advise. Error message contains "Data

The fifth column of DataviewToXML() is the name of the schema file (.xsd) which Magic will create when this parameter is not empty. This is not a XSLT file, which would be a XSL Template file ,

Lado, Maybe some XSLT expert will take pity on you and at least confirm or deny the possibility ... It's almost midnight in Europe right now. Give them eight hours or so ...

Thank you Steve, but I do not either possess any knowledge of xml. I do not know how to create the schema file. Lado

Lado, This is purely a guess, but it seems to me that you could specify the necessary formatting in an XSLT file, and pass the name of this file in the DataviewToXML() function's fifth

Hi Group, When I export data through DataviewToXML and open the .xls file in excel, the date columns shows in text format. Is there any way it can default to date format like red color

Only if the format changes (like from v8 to eDeveloper). Then there's a usrupdate.exe which converts from old to new security file format and that would keep all information, including passwords, Why

Just use the existing usr.eng, seems to work for me Wes