A localization producer has a master spreadsheet of 20,000+ UI keys and values in 35 languages that she needs to import into a database. The problem is, the database takes only CSV files containing no more than 100 keys. She therefore needs to slice the master spreadsheet into 200+ small files each containing 100 keys or less. To do this manually she will need to repeat the following operations 200+ times: create a new spreadsheet file, copy a different block of 100 keys from the master spreadsheet, paste it into the new spreadsheet, and export the content of the new file to a CRV file. This repetitive operation won’t be smooth because of its large volume of memory use. She estimates that it will take her 4 hours or longer to complete.
Use a WorkWaltz custom automation tool to chop the master spreadsheet into 200+ small files, each containing 100 different keys, and export each of them into a CSV file, in a total of less than 10 minutes.
One Reply to “File Slicing/Conversion”
Very nice post. I just stumbled upon your weblog and wished to say that I’ve really enjoyed browsing your blog posts. After all I will be subscribing to your rss feed and I hope you write again very soon!