Calgaty Loader

Question

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 · Answer

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.

Agnaldo_Souza · Answer

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 · Answer

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

calgary stack.yxmc