CSV Question Import PAIN!!!!!

 



"Are you saying Angela should export the original Excel to XML and then use the find/replace to edit all of the font sizes?"



I refer to a little-known trick that is applicable only in a few select cases. This may be one such case.


 


If you import all your questions into Lectora first, then you can click on File | Export | XML. Open up your XML in your favorite text editor (such as UltraEdit or FAR). I will usually open it in Word, because the find and replace is robust enough for that, but there are text editors that are even more robust. 


 


Do a search for "font". You'll eventually find your questions. Usually, when multiple items have been added the same way, the surrounding tags will be similar to one another, which means you can use those for the basis of your search. You could also just search for "10" and replace them with a larger font when you identify that 10 as belonging to the font size of a question (do NOT do a global replace for 10). How quickly you do this depends on how comfortable you are navigating through an XML file. If you've never done this before, you might end up picking through the search results slowly. When you recognize a pattern, then you can do a more sweeping search and replace which affects only those instances of "10" that modifies the font of the questions. 


 


Kevin

Discussions have been disabled for this post