Calgaty Loader

[Agnaldo_Souza]

Estou construindo um fluxo de conversao de arquivos csv para calgary.

Consegui criar uma macro para ler os arquivos, pois tem estruturas diferentes, um com 2 colunas outros com 10 e assim por diante, alem dos nomes dos campos.

Mas nao encontrei nada referente a utilizar o calgary dinamico.

Alguem ja construiu algo parecido.

[BrandonB]

Are you looking to create a macro that dynamically reads in calgary files based on a file path? If this is what you are looking to do, you can create a macro that reads a calgary file path in as a control parameter like this:

 

And then in your workflow you can use a directory tool to look at a folder of files and pass in the full path:

 

Does this help?

[BrandonB]

I have attached the macro here if that is what you are looking for

[Agnaldo_Souza]

Hi Brandon

Tks for ur help!

But it´s the Calgary Input.

My problem is the Calgary Loader.

Input n/Files csv. only fullpath for input, and FullpathCalgary to create the Calgary Database 

The Filename input wotk

The Filename output work

But, the Select all Fields and index not wor, because, metadada from files are differ,

and i not find way to resolve this problem

[BrandonB]

Yes, the issue is because your fields are changing. I was able to get it to work with different files that have the same schema with no issue. I think that the only way to dynamically create calgary files with specific columns being indexed would be using the action tool to "Update Raw XML with Formula" that actually generates the field information and whether to include the data and/or index.