Posts

Showing posts with the label C#

Testing PDF forms with merge code fields - let's just build a tool

Image
My team has been tasked with a lot of PDF forms that needs to be designed and coded for merge fields. These fields are coming from a very large list with exact names of merged code fields and sample values to go with them. Once they are built, team needs to test form naming of the fields and formatting of values in them. A ton of really boring hours of manual typing and populating values in each field so we test for consistency and formatting before we upload them to the destination web app that uses these. Time for a little automation to help the team. Needed to build a little app that takes Folder containing PDF forms with merge code fields List of Merge Code filed names and sample values As input. Click a button and get these PDF forms populated with applicable sample values and flatten them. Here are the results: Windows Forms app Loop through the directory to find and process all pdf forms Loop through form fields in each PDF.  Log ...

Small businesses, big problems, easy solutions.

Image
I recently helped a local non-profit  Al-Salam Foundation with their fundraising efforts .  Al-Salam is a small organization led and managed by a small group of folks. These folks are business owners, physicians and professional in other areas. Running AL-Slam is a part time thing for them with little time to spend and spare. Their focus has been growing the organization in Carmel community through civic engagements. They've had little time to research and implement right techs and tools to enhance and compliment their efforts. Such is the the situation in most small non-profits; especially religious institutions. Two immediate needs jumped out:  1.      Ability to accept credit cards from small donors. o     Onetime donation with ability to receive receipts o     Recurring donations that just works o     Ability to charge credit cards; POS style. 2.      Abi...

Parameterized OleDb Command for Oracle to execute in C#

Recently, when writing into an oracle database from C# using  OleDbConnection I kept running into some of the gibberish errors that Oracle keeps throwing. My Insert Query looks something like this,  "INSERT INTO TableA (Col1, Col2, Col3) Values ?, ?, ?;" Just in case anybody is wondering, the adding Question marks is the way to parameterize oracle queries for C#/VB. First strange error I kept getting was  ORA-00947 not enough values. I kept counting my columns and values and just did not seem incorrect. Of course then I noticed my all important parenthesis that are missing. so, my query is now changed to " INSERT INTO TableA (Col1, Col2, Col3) Values (?, ?, ?);" Onto adding the OleDbParameters with Values to the Parameter Collection and Voila, my codes start working. So much for these errors Oracle throws that makes very little sense.