Thursday, December 7, 2017

How to create WFA datasources with Python, c# or any other language

A colleague of mine had an issue with one of his datasources.  The issue wasn't the point, it was how he had created the datasource that was inspiring.  He actually created his CSV files outside of WFA and then in his datasource just copied them in.

$qtree_export_policy = "D:\WFA_Datasources\Qtree_Export_Policy.csv"
Get-WFALogger -message("Grabbing the file - " + $qtree_export_policy)
Copy-Item $qtree_export_policy .\

This made me think...

Nothing prevents you from collecting data any way you want, outside of WFA, using Python, C#, Ruby, ...   Create nice CSV files in a specific folder somewhere.
And then use a generic datasource (in perl or powershell, and you could still use my template) that simply imports those CSV files and converts them to the more complex WFA csv-file-type.

Just a thought... 

1 comment :

  1. Use the below method and start using Python in WFA for Data Sources, Commands.