Franchises · Production

Vertex geocode

As part of a project at work last year I had to convert ADP Taxware tax exempt certificates to Vertex tax exempt certificates. I searched the web and didn’t find any information on how to go about doing this. I have to believe that somebody has tackled this situation before and applied a much more elegant solution. But sometimes you just need to get something done regardless of how “pretty” the solution is.

I considered a few different approaches for tackling the problem. I’m not 100% happy with the final solution but it got the job done.

Defining a Starting Point and Ending Point

Taxware provides a reporting feature with their STEP application but this report is not CSV, tab-delimited or fixed-width format. It is not really usable as an export. First, because the format is not easy to work with and second because it doesn’t contain all of the information for the certificates. However, our Finance folks said the reports had enough information to use for the exemptions. So the issue that remained was how to get the Taxware report into a format that I could work with.

Vertex Q Series provides a useful Import/Export tool that allows fixed-width data files to be imported straight into the data repository (in this case SQL Server).

In a nutshell then, the objective was to take the Taxware exemption certificate report and convert it into a Vertex import file.

Possible Approaches

The first thing I thought of was writing a C# console application to handle the whole conversion. This is a bad habit of mine. I’m sure you’ve heard the phrase about “he who has a hammer treats everything like a nail”. I spent much of my career as a programmer so this is always the thing that first occurs to me for better or worse.

I also thought about PowerShell but I find PowerShell difficult to work with. I always find it doing things I don’t expect it to do. This isn’t because PowerShell is bad. It’s just because I bring too much baggage from other languages to the table and haven’t had enough time to work through it. Time was critical on this project so PowerShell was out.

I also considered using SSIS. SSIS is great for doing things that Microsoft has already thought of and designed components for. I’ve found though that when I need to do something that falls outside that sweet spot, things can get complex quickly. At that point, I was still new to SSIS and didn’t want to build my own components so SSIS was out too.

After looking through the Vertex documentation on the import file I realized I would have to pull in some customer data from our PeopleSoft Financials system and would also need to write some functionality to pull off Vertex Geocode tables to get my data ready for import. This type of thing is easily done with straight T-SQL using scripts.

The file to be imported into Vertex would need to be fixed-width format. That is easily done through SSIS.

You might also like
Android No-Permissions Reverse Shell
Android No-Permissions Reverse Shell
How to create a simple Google Map app in Android
How to create a simple Google Map app in Android
Barcamp Bangalore 13: Reverse Engineering an Android app
Barcamp Bangalore 13: Reverse Engineering an Android app ...

Doyle Park...just up the street from my

by bikeriderdude

Office on Sonoma Avenue (towards Farmer's Lane).
Be great if you can bring a kid. We'll talk before then, but I'm pretty sure I can get my whole family to come.

7 Game of Thrones Apps That Will Get You Through the Much-awaited Winter  — Gizmodo India
.. or Winterfell, you get a dialog box, which asks you to buy more maps. Unfortunately, you can't dismiss the dialogue box, leading to the obstruction of the cartography. ..

Flagstaff's rocky lava field became a little piece of the moon  — azcentral
If American know-how could put a man on the moon, the man should bring back rocks to study. The government agreed, and in 1963, the .. Volcanoes were chosen because of the moon's volcanic history, the test site for its impact craters.

Germany gpsticker2
Mobile Application (Germany)
  • Map download manager
  • Import/export routes as Google Earth KML- and GPX-files.
  • Route calculation
  • Display of GPS data integrated into the map view
  • Search for hotels, restaurants and other pois
  • Reverse geocoder
  • Charts for elevation and velocity
  • Search for addresses
  • Display weather conditions
  • Route replay

Missing in Alaska without a trace  — Anchorage Daily News
The official version of events, according to a still active missing person's bulletin from the Alaska State Troopers is that Griffis went into the wild "to test out a survival 'cocoon' that he had invented.

Popular Q&A

avatar
What is internal table in sap abap?

In terms of database an internal table is a virtual table where you are filling the data from the original table to that in order to over come the load resistance from n number of users who depends on the original table.

The life span of the internal table will expire as soon as you come out of the calling program in which you defined.

Related Posts