CSV File Read – Alpha 0.2


This slideshow requires JavaScript.

Just a quick update that I plan to try and get some more functionaltuy added to the the CSV File Reader utility, with another update this week with a designed XML file that describes the type expected in each column and an application which can create a XML settings file.

Links:

C# – CSV File Reader

May 5, 2015 1 comment

 

CSV is a comma separated values file, which allows data to be saved in a table structured format. CSVs look like a garden-variety spreadsheet but with a .csv extension (Traditionally they take the form of a text file containing information separated by commas, hence the name).

 

At work, when taking on a new client and integrating them into our Distribution systems, we mostly write import routines to take in data and process it into our back office file system. We mainly receive these as flat CSV files – because these are easy to work with. Lets face it, the better way would be to expose some public API endpoints and provide these to clients to push data in a temporary data store (then for us to post-process it into our back office). We don’t. In an ideal world we would, but we live in a world of ideals which involve providing lots of different flat files and writing some custom code each and every time, mainly because we don’t have the time to write a more modular and reusable application….until now.

I will explore in my own time, how best to create a CSV Reader system using C# and how to process a file and validate it. Because there is no defacto standard, I have chosen to work with RFC4180 for the default behaviour.  I have just started this and the 1st version was pushed to github on Monday and can be found here:

 

http://garfbradaz.github.io/bradaz.utils/

 

Snip

 

 

 

 

 

I’m not going to explain all the code now as I would like to try a video tutorial at explaining each individual class, but the gist of it is in Bradaz.Utils.IO namespace includes:

 

  1. CSVRow – Represents a CSV File Row and tracks things like the row number and the original data. Also stores a collection of CSV Columns (CSVColumn).
  2. CSVColumn – Represents a CSV File Column and tracks thinks like the column and row number and the original data.
  3. CSVFile – This represents a CSV File itself with a collection of rows and a CSV File Reader (CSVReader) of buffered data.image
    The project itself contains some example code on how to load a test file, validate it (simple validation currently) and display the contents. Currently I only load into a string to view it:

http://pastebin.com/embed_iframe.php?i=Sj9A4MM2

 

I next want to enchance the Parser based on a XML configuration file that will allow a user to specify things like how many columns should be in the file and what types to expect in those columns and convert to a usable object, no more strings! (Things like dates and integers). More to come!

8WG – New Site on its way.

April 21, 2015 Leave a comment

I have been wanting to build my 1st MVC site for a while and always wanted to take the 8weekgame concept further and build it out into its own site. Well now I’m – I have completed the functional analysis and design and now in the process of mocking the HTML pages using a snazzy tool called CoffeeCup. I have decided to get the front end pages done first before moving onto designing and building the backend database (the model part of MVC).

The first protoype page is now up and will grow as the weeks come on. I have decided to use the CSS framework Metro UI CSS to rapidly develop the pages using Microsoft’s Modern UI design language. This is changing with the advent of Windows 10 and there is a new version (3.0) of the Metro UI Framework coming. Please note I will remain on version 2.0 until later on after golive and way up the pro’s and con’s in upgrading. The Mock can be found here:

http://8wgdev.coffeecup.com/

I mentioned Phase 1 earlier. I’m splitting 2015 into two Phases and using Trello to help me organise this in a simple Scrumboard approach of Todo/Doing/Done. Again this can be found here:

https://trello.com/b/GyBHSXfI/8wg

I will of course keep this blog upto date on my progress.

Categories: Uncategorized Tags:

Grovelands posted a job you might be interested in

February 26, 2015 Leave a comment


Grovelands

Dynamics AX 2012 Senior Developer
Brighton, United Kingdom, GB – Information Technology and Services

My client, a leading player in the payments space has an immediate requirement for Microsoft Dynamics AX 2012 Senior Developer / Technical Lead.

The client we are working with is a market leader in their industry, they have been around for nearly 30 years and have offices across the EMEA, South America and in Singapore.

This is a great opportunity to be part of a great organisation that invests heavily in its staff, they are looking to grow a team of Microsoft AX Developers around this role and you will be directly involved in this growth strategy.

 

£70k plus package + relocation

Posted February 24, 2015 at 02:53PM from LinkedIn http://ift.tt/1A74OSm
via IFTTT

Categories: autoifttt Tags: ,

Legal & General posted a job you might be interested in

February 26, 2015 Leave a comment


Legal & General

Lead Agile Development QA
Brighton, United Kingdom, GB – Insurance, Financial Services, Investment Management

Legal & General have embarked on a major Digital transformation program. To ensure the success of the program, an outstanding Agile delivery team is being created. A key member of this team will be the Lead Agile QA.

Purpose

The Lead Agile QA’s role is primarily to drive delivery of appropriate QC and QA processes where needed in the lifecycle of an agile team’s delivery lifecycle.  It is also to act as a coach and mentor to one or more agile delivery teams, particularly emphasising agile QA and QC practices. They are deeply experienced agile practitioners combining technical excellence and business pragmatism who will help the team to reliably deliver simple bespoke software solutions to sometimes complex business problems. They are a key agent for developing the effectiveness of the team, facilitating and driving continuous improvement.

Principle Accountabilities

  • Provide expertise in all aspects of functional and non-functional testing from development testing through to user and operational acceptance, including performance, availability, security, usability and accessibility, with an emphasis on automation
  • Facilitate and participate in project planning, daily stand-up meetings, reviews, retrospectives, sprint and release planning and demos
  • Work with the teams to help them adopt the Agile process that works best for the team. Track down causes of defects and seek ways to reduce their impact
  • Encourage core principles of collaboration, prioritization, team accountability, and visibility. Update tracking systems to provide transparency. Radiate information.
  • Identify and remove impediments, prevent distractions that interfere with the ability of the team to deliver the sprint goal
  • Facilitate discussion and conflict resolution. Empower the teams to self-organise
  • Improve the productivity of the teams in any way possible. Recommend improvements and assist in changes to practices.
  • Liaise effectively and manage relationships with the management team, Product Owners and other stakeholders around QA issues. Lead QA escalations.
  • Risk and issue identification and management in conjunction with the wider project team. Dependency Management

No salary provided

Posted November 10, 2014 at 11:23AM from LinkedIn http://ift.tt/1GBhKWI
via IFTTT

Categories: autoifttt Tags: ,

Leeds Beckett University posted a job you might be interested in

February 26, 2015 Leave a comment


Leeds Beckett University

Head of School. School of Social, Psychological and Communication Sciences
Leeds, United Kingdom, GB – Higher Education
At Leeds Beckett University we are committed to the delivery of an ambitious, transformative strategic plan that will ensure we remain at the forefront of innovation in higher education.

Our School of Social, Psychological and Communication Sciences is a leading provider of undergraduate and postgraduate education, research and consultancy. Following significant and successful growth, the school in the largest in the faculty with circa 1,800 students, 90 FTE academic staff and an annual income of GBP 17m. The recent establishment of a new Centre for Applied Social Research and significant investment in new estate have created an outstanding teaching, learning and research environment.

We are seeking to appoint an exceptional individual to help shape the next stage of the development of the School. Candidates will demonstrate a strong track record in academic leadership, the delivery of a high quality student experience, strategic vision, and significant experience in a discipline area relevant to the School. Applicants who also meet our criteria for professorial appointment will be eligible to be considered for the title of professor.

Further details about the Faculty and School can be found here:
http://ift.tt/1AWf2uu

Further details about our research expertise and our Centre for Applied Social Research can be found here:
http://ift.tt/1vJnBmh

Interviews will be held on 30 April 2015

No salary provided

Posted February 19, 2015 at 11:23AM from LinkedIn http://ift.tt/1AWf0mm
via IFTTT

Categories: autoifttt Tags: ,

Carlsberg Group posted a job you might be interested in

February 26, 2015 Leave a comment


Carlsberg Group

SAP EDI & Interface Specialist
Northampton, United Kingdom, GB – Food & Beverages, Food & Beverages

SAP EDI & Interface Specialist

 

Northampton with regular travel

 

Competitive salary + generous benefits package

 

If you want to be seen as something of a subject matter expert, here’s your chance.

 

Do you have the client/customer facing EDI experience it takes to join one of the UK’s largest beer and beverage companies? Are you thirsty for the opportunity to play your part in the smooth running of a world-class brewery business? Congratulations, you’re in the right place.

You probably know us best for Carlsberg and Carlsberg Export. But, there’s more to us than meets the eye. From Tetley’s to Tuborg, San Miguel to Somersby Cider – we produce lots of leading brands. We also brew over 1 billion pints of beer each year and, last year, we made a £20m investment in a new bottling line at our landmark Northampton brewery. We’re the Premier League’s official beer too, not to mention our partnership with the UK’s best festivals – Glastonbury and Download to name just a couple.

Right now, we’re looking for an experienced SAP certified individual to ensure the effectiveness of our UK EDI solution and local system interfaces to our C_One system. A great chance to become the specialist responsible for the exchange of EDI messages within the local market, we’ll rely on you to provide first level support to the business. You’ll also make sure all data is exchanged accurately, on time and in line with business requirements. Assessing, advising and managing changes to existing EDI and interface solutions will be important too, as will planning and implementing a programme of continuous improvement. Acting as the single point of contact for all EDI/interface change requests; monitoring and managing system performance and taking part in cross-country knowledge sharing activities – all are elements of this business critical role.

Educated to degree level or equivalent, you have proven experience of using SAP Sales & Distribution and Material Management modules and a track record in SAP IDOC/EDI configuration. Knowledge of CRM and other SAP modules e.g. Finance and Warehouse Management would also be handy, while proficiency using EDI TRADACOM, EDIFACT and XML is essential. Strong communication and presentation skills are vital too, together with a high degree of customer focus and good communication & presentation skills. Adept at integrating SAP with third party systems, any exposure to large SAP implementations/ projects in your career to date, possibly within an FMG setting, would also be a plus.

On top of the culture and career development opportunities that make working with us so rewarding, we’ll also give you a product allowance and flexible benefits, including private medical insurance, a defined contribution pension scheme and generous holidays. So, what are you waiting for? The brewing challenges you crave with a world leader could be yours for the taking.

No salary provided

Posted February 03, 2015 at 09:30AM from LinkedIn http://ift.tt/1CV5wYt
via IFTTT

Categories: autoifttt Tags: ,
Follow

Get every new post delivered to your Inbox.

Join 324 other followers

%d bloggers like this: