Difference between revisions of "User talk:Tagaziel"

From Pillars of Eternity Wiki
Jump to: navigation, search
Line 6: Line 6:
 
Otherwise I may have to write another script. Or... shudder... do it all manually. Darn it. This whole "minor task" became a freakin' mammoth. Why does this always happen? :D [[User:Pangaearocks|Pangaearocks]] ([[User talk:Pangaearocks|talk]]) 17:30, 31 March 2020 (UTC)
 
Otherwise I may have to write another script. Or... shudder... do it all manually. Darn it. This whole "minor task" became a freakin' mammoth. Why does this always happen? :D [[User:Pangaearocks|Pangaearocks]] ([[User talk:Pangaearocks|talk]]) 17:30, 31 March 2020 (UTC)
 
:CSVLoader is a useful beast, but... And that's a big BUT... It requires mastery of regular expressions to use. I based on the [https://en.wikipedia.org/wiki/Wikipedia:CSVLoader/Find_and_replace tutorial here] and it took me more than a few tries to get it right. The good news is, it can be used to update values, you just need to figure out what to input. It's the reason why I shifted towards formatting values through the infobox and using just data input straight from the files. [[User:Tagaziel|Tagaziel]] ([[User talk:Tagaziel|talk]]) 07:18, 1 April 2020 (UTC)
 
:CSVLoader is a useful beast, but... And that's a big BUT... It requires mastery of regular expressions to use. I based on the [https://en.wikipedia.org/wiki/Wikipedia:CSVLoader/Find_and_replace tutorial here] and it took me more than a few tries to get it right. The good news is, it can be used to update values, you just need to figure out what to input. It's the reason why I shifted towards formatting values through the infobox and using just data input straight from the files. [[User:Tagaziel|Tagaziel]] ([[User talk:Tagaziel|talk]]) 07:18, 1 April 2020 (UTC)
  +
::Have read that walkthrough as well, and think I got a test going that showed it worked to use both normal find and replace + advanced. Normal for replacing stuff from CSV file (##whatever## after regex find), and then the advanced to work more directly with the infobox. But it's messy and ripe for mistakes. It would be easier if all the "rows" were present (even without a value), but often I would have to add a row, which quickly gets messy. Ideally I could use a #if, but that doesn't work of course.
  +
  +
::Am scratching my head because I have a 12 MB (!) XML file that is game data, that has been exported to CSV (had to write a script because none of the automated conversion sites could handle it). But actually getting that into the infoboxes, replacing/creating fields when needed, is quite tricky. There is so much data and things that can go wrong. I'll keep plugging away at it, but it wasn't as easy as I hoped.
  +
  +
::With that last sentence, do you mean raw values in the infobox, like "12", and then add "shock damage" or whatever via the infobox template? [[User:Pangaearocks|Pangaearocks]] ([[User talk:Pangaearocks|talk]]) 11:24, 1 April 2020 (UTC)

Revision as of 11:24, 1 April 2020

CSVLoader

Empty? What gives? :P

Recall you were a CSVLoader expert. I'm scratching my head trying to update heaps of data from game XML files (on the Witcher wiki). It becomes tricky since I'm working with existing infoboxes, which may or may not contain the "whatever = " that I can search for. Therefore Advanced Find and Replace in AWB may be useful (I've never used it before). However, I seem to recall reading somewhere that CSVLoader didn't work with advanced search and replace, only the normal F&R. Have you tried this? Does it work with advanced as well? I was thinking that the "If" tab there could come in handy. Then I could search for each field, and if it doesn't exist insert it, and replace if it exists.

Otherwise I may have to write another script. Or... shudder... do it all manually. Darn it. This whole "minor task" became a freakin' mammoth. Why does this always happen? :D Pangaearocks (talk) 17:30, 31 March 2020 (UTC)

CSVLoader is a useful beast, but... And that's a big BUT... It requires mastery of regular expressions to use. I based on the tutorial here and it took me more than a few tries to get it right. The good news is, it can be used to update values, you just need to figure out what to input. It's the reason why I shifted towards formatting values through the infobox and using just data input straight from the files. Tagaziel (talk) 07:18, 1 April 2020 (UTC)
Have read that walkthrough as well, and think I got a test going that showed it worked to use both normal find and replace + advanced. Normal for replacing stuff from CSV file (##whatever## after regex find), and then the advanced to work more directly with the infobox. But it's messy and ripe for mistakes. It would be easier if all the "rows" were present (even without a value), but often I would have to add a row, which quickly gets messy. Ideally I could use a #if, but that doesn't work of course.
Am scratching my head because I have a 12 MB (!) XML file that is game data, that has been exported to CSV (had to write a script because none of the automated conversion sites could handle it). But actually getting that into the infoboxes, replacing/creating fields when needed, is quite tricky. There is so much data and things that can go wrong. I'll keep plugging away at it, but it wasn't as easy as I hoped.
With that last sentence, do you mean raw values in the infobox, like "12", and then add "shock damage" or whatever via the infobox template? Pangaearocks (talk) 11:24, 1 April 2020 (UTC)