Thanks but I'm looking for more flexible way where I can manage the export and import process using objects or query (although I prefer objects) in a class method or routine as I'm exporting data from one class from Server 1 to a different class in server 2 (class name has changed), so using my class method or routine to export only the data i need into a cvs file then import it to server 2 class 2 in a specific way using  an import routine, so using the Wizard may not be suitable in this case ? well, if the export wizard can give me a csv file that would be good, but I using ensemble 2014?

Thanks

Thank you very much, that actually answered my question, thanks Eduard 

Thanks but that wouldn't help in my case 

Basically, I'm looking to export the data of a certain class with record ID, and Full_Description fields from eg. RMI.myclass into a spreadsheet than import it to another class, either by using a sql query or maybe better using objects (eg. S rec=##class(RMI.myclass).%OpenId(id)) and loop through the records and save to a .csv files?

Thanks

i'm not trying to read the properties or the dictionary of %GlobalCharacterStream datatype, i'm trying to read a field defined as %GlobalCharacterStream?

thanks

sorry but if i use from %Dictionary.propertydefinition, what abouit the claas itself where the field belongs ?

because the field i'm trying to ready is in a class with many other fields ?

thanks

Thanks Marc

Thanks Michael

Nope

I haven't specified any path, the process does it automatically  and doesn't allow changing it.

when i done it in 2014 with the same steps it worked and then batch created, then ran batch and database created but still when mounting it, it's mounted as 2k not 8 !!?

anyway, what I've done now is just the old traditional way by exporting all globals from the old 2k, created a fresh new database (8k), then imported the globals in it, but I'm suspecting that GBLOCKCOPY in 2008 having some issues!?

Thanks John

HI John,

I had to run is in 2014 because when I run it in 2008 on Mounted or Unmounted database it gives me following error 

 
Convert 2KB c:\test civicview version 8\data\production\CACHE.DAT => 8KB c:\test civicview version 8\data\production\CACHE.DAT
 
Confirm auto creation of batch VB2? No => Yes
 
Creating directory c:\test civicview version 8\data\production\pre-gbcopy\
ERROR: rename failed with error code 1
Unable to rename c:\test civicview version 8\data\production\pre-gbcopy\CACHE.DAT to c:\test civicview version 8\data\production\CACHE.NEW
Unable to add c:\test civicview version 8\data\production\CACHE.DAT to the batch
 
Batch Name: VB2  0 of 0 Processes running, 0 per directory
 # Source DB=>Destination DB/NS                  Last Update Done/ToDo/Err State
-- ----------------------------                  ----------- ------------- -----
 
Auto creation of batch VB2 complete

Thanks

Hi Guys,

I think the easy way with is to just create an empty Cache.dat then copy all Globals from the old cache to the fresh new one.

I know that can be done by using GBLOCKCOPY  but done know the correct steps?because I tried GBLOCKCOPY , option 1 then option 1 it tells me "No database or database is dismounted in Directory" although there is a dismounted Cache.dat?

Thanks

Hi Guys,

Yes the problem was that the old Cache.dat is a 2k, but I've ran ^GBLOCKCOPY, created and the batch and a new Cache.dat is created but still when mounting the new Cache.dat still come up as 2K block size and not able to mount, I'm sure that should be an 8K !!?

I'll try again and see.

Thanks

Thanks

Ok thanks

Hi Guys,

I've Purged all queries using System Management portal and also by running D $SYSTEM.SQL.Purge(), then recompiled all classes with $System.OBJ.CompileAll("c-k-l"), but our Clients are still getting those errors when running Crystals, where I had to open the affected classes in Studio compile them and get the crystals running again. any suggestions please?

Thanks 

Hi Eduard,

The problem is that sometimes we could get these two different errors for the same report (See attached Screens) and they go away by recompiling their related classes from Studio.

I've tried purging cached SQL and see how we go.

Thanks Eduard

Yes, I think that's what it is.

Cheers

this might be a dump question, but how can  i check that?

 i've checked C & D drives ans SYSTEM has a full access, but don't know to check  \\BACKUPSVR

THANKS  

Thanks Robert, Really appreciate it.

Cheers