Importing Records not importing Time fields.

[Peredo Door]

I have the following form that is a component of a set of forms that helps me keep track of my anime library:

Each video file is associated to a record here. If an anime series is 12 eps long, I will have 12 records for it.

To quickly add each episode record, I wrote a script that writes a tab-separated CSV. This is a sample of a CSV it has generated:

Ep Number	Storage	Fansub	Source	Resolution	Size (MB)	Sub	Dub	Hardsubs	Duration	Comments
1		OCZ	BD	1080p	667	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
2		OCZ	BD	1080p	668	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
3		OCZ	BD	1080p	705	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
4		OCZ	BD	1080p	695	English	English,Japanese	0	00:23:29	Imported with eps_generator.sh by Andy Ibanez
5		OCZ	BD	1080p	789	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
6		OCZ	BD	1080p	631	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
7		OCZ	BD	1080p	733	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
8		OCZ	BD	1080p	656	English	English,Japanese	0	00:23:27	Imported with eps_generator.sh by 
9		OCZ	BD	1080p	927	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
10		OCZ	BD	1080p	937	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by 
11		OCZ	BD	1080p	771	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by
12		OCZ	BD	1080p	791	English	English,Japanese	0	00:23:28	Imported with eps_generator.sh by

Then I try to import it:

Like you can see, all the fields in the “Assign field types” get properly selected. The one gotcha is that I have to manually choose “Time” for “Duration”. But when the records are imported, it has all the information BUT the duration – it is blank.

Am I doing something wrong here?

I exported the records I had added manually and they export the time in the same format I am trying to import it. So I’m not sure if it’s a bug or if I am doing something wrong.

[Brendan]

The Time field stores an actual time, not a duration. So that’s the problem here.

What you need to do is write your script so that the duration is generated in seconds. Then import that into a Number field in Tap Forms and then set the Number Format to one of the duration formats, such as HH:MM:SS, etc.

[Peredo Door]

That did the trick. Thanks.

[Peredo Door]

Additional question, how should I do it if my form is a linked form and I want to associate it to a parent on import time?

[Author]

Posts