z5llToXML

Tools for converting ZipInfo.com z5ll.txt and zcugoem.txt files to Salesforce Commerce
Cloud* (SFCC) Geolocation XML format files. (*formerly known as Demandware)

Dependencies

• (for OSX) XCode & Command Line Utilites
• Bundler gem

Usage

To setup dependencies you must run the following command:

$ bundle install

To convert a file from ZipInfo.com’s CSV format into an importable SFCC Geolocation
XML file is as simple as running the following command:

$ ./z5llToXML.rb /path/to/z5ll.txt

You can also convert multiple files at once:

$ ./z5llToXML.rb /path/to/z5ll.txt /path/to/another/z5ll.txt

Some files contain multiple country postal codes. If your file contains multiple codes
such as the zcugoem.txt file that contains both US & CA postal codes. Simply use the
-c or --country flag to specify the country codes that are in the file(s). Currently
z5llToXML supports only US & CA.

$ ./z5llToXML.rb -c US,CA /path/to/zcugoem.txt

If You Have Trouble Executing

If you’re having issues running this script in your native environment, I
recommend using (rvm)[https://rvm.io/] with Ruby version 2.1.2 which this
script was written against. Here’s an example of the commands to run once
you’ve installed rvm.

$ rvm install ruby-2.1.2
$ rvm use ruby-2.1.2
$ gem install bundler
$ bundle install
$ ruby ./z5llToXML.rb /path/to/z5ll.txt

This should resolve any issues you’re having with mismatched Ruby, gems, or
problems requiring specific gems.

Roadmap

1. Currently the script can use several megabytes of RAM and ideally will be converted to
   perform progressive writes to the output file rather than storing the entire XML document
   in system memory. One way it currently attempts to deal with this issue is to (in bad form)
   trigger garbage collection after every 1000 rows processed. This helps keep the program from
   eating up too much RAM and causing severe slowdowns.

Update: This was resolved in 1.1a when we switched to libxml-ruby rather than using
REXML for XML writing.