Quick fix if your import fails after the Euwt links section.
Import the file again but select Options first. In the Options menu uncheck the Thresholds and Weights box. It will import fine. FYI- We use this fix only on contracts that we don't use Thresholds and Weights on or as a quick fix before we can get a clean .wsa file in. All data will be imported fine.
Tuesday, March 29, 2011
Editing XML files over 512mb : gVim
My wInsight team has to constantly remove old PLUGs from XML files in order to get them to import properly. Usually we import the file, when it fails from a PLUG we note the PLUG number,open the XML in notepad, Ctrl-F to find the PLUG, delete the plug from element to /element, save as another name and then import that file. Usually it runs fine or runs into another PLUG. We do the same for the next PLUG. If it fails for something other than a PLUG after the PLUG have been removed we then import the ORIGINAL xml file and it goes through great. Recently we ran into a different problem. An .xml file over 512mb, specifically 1.12gb.
I tried editing in Notepad, MS XML Editor, IE, MS Word, and installed and tried Notepad++. Notepad supposedly had a 2gb threshold. Not so, s'pose it was wishful thinking or done on a top of the line 'puter. Luckily I found a program that can handle the large .xml files and is free: gVim. You can download it here:
ftp://ftp.vim.org/pub/vim/pc/gvim73_46.zip Easy interface and very simple, which means fast. I found it HERE.
I also tried XML Marker which seemed to work in the beginning but had problems 'parsing' the file and saving it. Cream, which is similar to gVim looked extremely promising but took longer to load. The stripped down gVim worked great.
I tried editing in Notepad, MS XML Editor, IE, MS Word, and installed and tried Notepad++. Notepad supposedly had a 2gb threshold. Not so, s'pose it was wishful thinking or done on a top of the line 'puter. Luckily I found a program that can handle the large .xml files and is free: gVim. You can download it here:
ftp://ftp.vim.org/pub/vim/pc/gvim73_46.zip Easy interface and very simple, which means fast. I found it HERE.
I also tried XML Marker which seemed to work in the beginning but had problems 'parsing' the file and saving it. Cream, which is similar to gVim looked extremely promising but took longer to load. The stripped down gVim worked great.
Subscribe to:
Posts (Atom)