[sims] Aspects: Marks Integer to Decimal

[tben2505]

Hi guys

 

I have just set up LOADS of aspects, then templates full of formulas etc - which feature many aspects as integers.

 

I've just been told they need to be decimal (despite my confirming this before I started!!!!!!)

 

Is there ANY way to do this quickly rather than having to start all over again? I know you can't change an integer aspect to a decimal once it's created which is a real shame - guessing there's no patch to alter that??

 

Cheers all,

 

T

[Esteban_Child_of_the_Sun]

Download XMLNotepad 2007 from the Microsoft website

Export all the Integer type aspect from SIMS (Routines | Data out | Assessment | Export)

Open the XML file exported in XML Notepad 2007

use the replace function and tick the XPath tick box

in the find field type

/AspectFileV7/AspectNode/Aspect/Type[./text()=I]/text()

in the Replace with field type

D

click replace all

Save the file with a new name (in case you need to revert any of them)

import new file into SIMS.

(Note going from decimal to integer doesn't work as data recorded to 2 decimal places is in the wrong format whereas integer to decimal is just adding detail)

[tben2505]

Thanks for this - can I confirm that the find and replace is

 

/AspectFileV7/AspectNode/Aspect/Type[./text()=I]/text()

 

to

 

D

 

Or is it

 

/AspectFileV7/AspectNode/Aspect/Type[./text()=I]/text()

 

to

 

/AspectFileV7/AspectNode/Aspect/Type[./text()=D']/text()

 

?

[Esteban_Child_of_the_Sun]

The first one.

[tben2505]

Also struggling to export - when I go to Export all the Integer type aspect from SIMS (Routines | Data out | Assessment | Export) - it's asking for me to specify an XML file - how can I export to a file already present? I don't get it...

 

Cheers,

 

Tom

[Esteban_Child_of_the_Sun]

I should clarify, only export the integer type aspects you want to change not all of them

When it asks you to specify an XML file, it just wants you to enter a file name to save it as, Capita's wording isn't always intuitive.

[tben2505]

Gotchya!

 

Yep I gathered that - wouldn't want to change 'em all!

 

Will do a test with 1 first!

 

Cheers mate - hope this works - will literally save me DAYS!

 

T

[tben2505]

OK so I've done a test exporting just ONE aspect.

 

When I go to find and replace, it says "the specified text was not found"

 

 

I also notice if I open with NOTEPAD, there is a line: I - could this be replaced to D instead perhaps?

 

Cheers

 

T

[tben2505]

I've found in NOTEPAD replacing I to D seems to work!

 

Tested on 5 aspects...

[tben2505]

Done it with all aspects and it works!

 

Cheers mate!!!

T

[Esteban_Child_of_the_Sun]

OK so I've done a test exporting just ONE aspect.

 

When I go to find and replace, it says "the specified text was not found"

 

[ATTACH=CONFIG]46008[/ATTACH]

 

I also notice if I open with NOTEPAD, there is a line: I - could this be replaced to D instead perhaps?

 

Cheers

 

T

 

The reason it didn't work is you missed putting the tick in 'Use Xpath'

 

Glad you got there, but a warning for th future, notepad can change unexpected things with a basic find/replace especially if there are gradesets involved.