topic Re: Model builder iterations problem (Txt files to .lyr files) in ModelBuilder Questions

Model builder iterations problem (Txt files to .lyr files)

SprumontFrancois — Wed, 12 Nov 2014 12:07:36 GMT

Hello everybody,

I have a folder with multiple text files containing X Y data. I would like to transform each of these txt files into a .lyr file.

I thought I could work with Model Builder but I think I have problem using "Files iterator".

For each txt file, I would like to obtain one .lyr file but by running the below model I obtain a single file (and not several one).

Could you please help me ?

Re: Model builder iterations problem (Txt files to .lyr files)

RaymondHuang1 — Wed, 12 Nov 2014 14:40:14 GMT

Looking at your model, your make xy event tool will only run once. Your make xy event tool should take in the output of the iterator as an input(solid arrow) instead of a precondition (dotted arrow) like what it is now. Can you try to change this and let me know if it works for you?

Re: Model builder iterations problem (Txt files to .lyr files)

SprumontFrancois — Wed, 12 Nov 2014 16:02:06 GMT

Hello,

Thank you for your reply.

I don't know why but when I try to connect the green box "File.txt" and the tool "make xy event layer" it is always a dashed line (precondition) and not a solid one.

perhaps I have to fix something with the name of the Input / output...I don't know what's going wrong

Re: Model builder iterations problem (Txt files to .lyr files)

RaymondHuang1 — Wed, 12 Nov 2014 16:16:14 GMT

Attach a screenshot of your textfile content format please?

Re: Model builder iterations problem (Txt files to .lyr files)

ChrisDonohue__GISP — Wed, 12 Nov 2014 18:35:11 GMT

The naming may become an issue if the resulting layers are being placed in a File Geodatabase.

Additional rules

Names must begin with a letter, not a number http://resources.arcgis.com/en/help/main/10.1/index.html#//002200000002000000

Chris Donohue, GISP

Re: Model builder iterations problem (Txt files to .lyr files)

SprumontFrancois — Thu, 13 Nov 2014 08:11:43 GMT

More precision on the data ? Ok !

The text files I want to transform in .lyr files (or shapefiles...) are composed of 3 columns: X,Y and time.

Here is an overview:

Y,X,TIME

51.21646,5.08759,1900-01-01 10:37:27

51.21643,5.08798,1900-01-01 10:37:32

51.21653,5.0882,1900-01-01 10:37:37

51.2166,5.08844,1900-01-01 10:37:42

51.21664,5.0886,1900-01-01 10:37:47

51.21664,5.0886,1900-01-01 10:37:52

What I don't understand is that when I develop a model for one single text file, it works. Thus, I think my issue is related to the "File iterator tool".

Re: Model builder iterations problem (Txt files to .lyr files)

RaymondHuang1 — Fri, 14 Nov 2014 21:30:41 GMT

I tried to quickly create a similar model and it works on my side.

Can you share your toolbox containing your model please?

Re: Model builder iterations problem (Txt files to .lyr files)

SprumontFrancois — Mon, 17 Nov 2014 11:33:57 GMT

Ok, no problem.

In the attached file, the toolbox related to the picture I posted previously.

Let me be clearer: In a folder called Folder1, I have multiple text files structured like this:

Y,X,TIME

51.21646,5.08759,1900-01-01 10:37:27

51.21643,5.08798,1900-01-01 10:37:32

51.21653,5.0882,1900-01-01 10:37:37

51.2166,5.08844,1900-01-01 10:37:42

I would like to use model builder to automate the process of "Make XY event layer" and "save to layer file".

I thought I could use the file iterator tool to run the model on all the text files in folder 1.

Thanks for your help ! I appreciate a lot...

Re: Model builder iterations problem (Txt files to .lyr files)

Pieter_Geertvan_den_Beukel — Tue, 18 Nov 2014 10:00:14 GMT

The Iterate Files tool has an output format (file) that can not be connected to the Make XY Event Layer tool. Use the Iterate Tables tool instead.

See NewModel in attached toolbox.

Re: Model builder iterations problem (Txt files to .lyr files)

SprumontFrancois — Tue, 18 Nov 2014 11:43:16 GMT

Great, Thank you !

I thought I had to use the "File iterator"...I don't know why I never tried this "Table iterator"...

Thank you for your help !