A few people have asked me how to import their CSV files into Tap Forms. Here's a quick guide to get you going in the right direction.
Before you transfer your file to Tap Forms, make sure your CSV file has the following properties:
- Has a .csv file extension (lowercase .csv in version 1.6).
- Encoding matches encoding of set in the Import & Export Settings screen.
- Includes a header row defining the field names and types (optional) you would like to have in your form.
- If you're importing dates, your import data format should be set correctly in the Import & Export Settings screen.
You can build a header row such as this (including a couple of sample records):
Movie Name<text>,Release Date<date>,Is Great Movie<check_mark>
The Dark Knight,07/18/2008,Y
The English Patient,11/22/1996,N
Valid Field Types are:
- text
- number
- date
- time
- check_mark
- contact
- web_site
- note
- phone (should be all digits without formatting)
The field type in the header row of your CSV file must match exactly one of the field types above. If the field type doesn't match or is unspecified, text will be used instead.
If you define your header row on your PC to be the field names that you'd like to see in Tap Forms and also give them a field type, then Tap Forms will do most of the work for you. The only thing you need to do on the iPhone itself is create a new form, give it a name and pick an icon.
On the Edit Form screen you'll see an action menu icon (a little arrow in the top-right corner). Tap that and then you'll see "Import Records". Selecting your .csv file will then bring you to the Import screen. You'll see how many rows there are (less the first header row), the file size, and a big green Import button. Tap that and Tap Forms will auto-create the fields for you and import the records.
OK, this is “how to set up my CSV file for import”. How about more clear instructions on how to actually invoke the import? When I start the process, the file will be on my Mac, how do I get it to my iPod Touch? TapForms can’t simply browse for it on my Mac.
I’m an old Palm user and have been using a DB program on that platform, import is very important for me as I don’t want to re-key all my data.
Much thanks, Al
There are instructions on the Files tab for how to get your file into Tap Forms from your PC or Mac. I simply added this bit of information to help people understand how to actually format their CSV file and also where to go to initiate the import (e.g. tap the Import Records button from the Edit Form screen’s action menu). You can also tap the Import Records button from the list view’s action menu.
Thanks!
Brendan
My problem is that from a Mac, when launching from Finder’s Go > Connect to Server, it creates a volume on my desktop in which I can see the Exports and Imports folders, but the volume is read-only. Do I need to sudo in and set permissions here, as Get Info does nothing for me? I also tried via CuteFTP for the Mac, but no combination of anonymous logins got me connected. (using IP address and port 8021).
I figured instructions would be available once TapForms is installed. That doesn’t help one make an evaluation of the software prior to purchase. You have to agree that documentation and support availability are large criteria toward purchasing decisions. I’m glad to see a prompt response to my question, speaks volumes concerning support.
I’m anxious to see your response to Eve McGivern’s issue.
Tkx, Al
I agree that my documentation skills are a little lacking. I will have more time in the near future to put together a comprehensive user guide.
To answer Eve’s Finder question. The OS X Finder for some odd reason only mounts FTP servers as read-only. I generally use a cool free program called CyberDuck. You can download it from http://cyberduck.ch
Then I simply click the Open Connection icon, put in the IP address and port number into the appropriate fields, check anonymous and then connect. Works like a charm every time.
I’ll add this bit of info to the main article.
Thanks,
Brendan
I noticed that the list of fields you included in this post included the audio and photo fields. Does this imply that there is a actually a way to import these formats? I assume that you just cut and paste these out of habit, but I thought I’d ask “just in case”.
Thanks,
Daniel
I just updated the posting to remove audio and photo from the field types. Yes, you’re right Daniel, you can’t import photos or audio from a CSV file. Typo!
Thanks,
Brendan
Although now that I think of it, you could leave audio and photo in their and Tap Forms will at least generate the fields and set the types for you given the column names in the CSV file.
I thought the documentation, though brief, was clear, although the need for a username and password was skipped. Other than that it worked perfectly on some fairly large files.
Hello,
I must say, i do love this app! Every time i reach for a bit of paper i think, wait i can just do it on here!
I have no idea how to use this .csv , i know it is some kind of database file or some sort.. i can export the MYSQL databases on my web-server to CSV. Could someone email me a demo CSV with a sample form or something in it so i can just see how it works and how i need to actually make the .csv file :)
Thanks so much!
(t.arnfeld@magic3.co.uk)
Hi
I have created my .csv file and sent it to my imports folder using my FTP program. No problems there. When I open my form and go to import this file it starts but then drops out of the program. hen I go back into the program I find that only a small number of the records have imported. Tried this a few times and each time different number of records are imported before the program crashes. The .CSV file I am importing has over 15,000 records but only getting around 350 imported? Any help would be appreciated on this :-)
Thank You
Ian
hi i have got the .csv file over to the tap forms import folder then made form named movie collection press box in corner then import then .csv file is not showing up to import to form where am i going wrong can you help please thanks.
Hi,
I just downloaded the App and imported my DVD Collection database with no problems at all. Really a great application, great UI especially, thanks a lot! (I can’t wait for the encryption feature, which will make it even more useful… :) )
In order to import my DVD list, I had to replace all Commas by something else before writing to csv. I have to admit I use Commas quite frequently, so it would be awesomesome if the were some way to mask them for the import or use a different separator if needed.
Thanks for the great programming again,
Marcus
Tap Forms 1.7 will let you choose a column delimiter. It will support commas, semi-colons, colons, pipes, and tabs. I think those are the most common delimiters anyway.
Thanks,
Brendan
Sounds great, looking forward for the next version. If you need help with German localization I’d love to help out, though I’m probably not of much use as I don’t own a Mac. ;)
Thanks,
Marcus
The German translation has been done and will also be available in 1.7. Along with German, Tap Forms will now have English, French, German, Dutch, Spanish, French, Italian, Simplified Chinese, and Traditional Chinese. Swedish and Polish are in the works.
Hi,
I have the same problem like Ian. When importing the csv it just imports rd.ab. 5% and the ends the app. With evry new try it stops at the same point. File has 918 entries, same format as anothe file which worked. When trying to edit the entries the app stops as well. Any recommendations on this?
Thanks,
rossi
Hello Flo,
If you send your file to support@tapforms.com I can look to see if there’s anything obviously wrong with it. You could also try looking for any rows that don’t have the same number of columns as the header field. For example, if your header row had 5 columns, then every row should also have 5 columns (4 commas actually). If you have any fields that might have a comma within it, make sure they are quoted. Like this “Friday, May 22, 2009”.
Also, Tap Forms doesn’t deal well with files as big as Ian’s unfortunately. You could try making your files smaller and importing them a segment at a time.
hello
i personally love the applications; kudos on the build so far
i use the customizable forms alot because i do alot of insurance it’s nice to have clients data on the go.
i primary bought the app for the audio recording it’s hands down the best so far and plus it.
and i appreciate that fact that it will keep recording when the iphone darkens…..so awesome.
but the only issue i have is….how do you import the audio files?
i have over 25 audio recording of meeting …(one hour each conversation)
any suggestion to transfer into the computer
To export an audio file from Tap Forms, you will need to do a backup with SyncDocs (http://syncdocs.sourceforge.net). Once you’ve done a backup, there will be a folder on your Mac or PC in the TapForms backup folder called Audio Recordings (and one for Photos). Then you can copy the files to wherever you want them to be. Tap the Tools tab in Tap Forms and then tap Backup & Restore. There’s a help button [?] in the top-right corner that tells you how to use SyncDocs.
It’s taken me a while to work this computer to application thing out (as I have little experience with this sort of stuff) but with your help I’ve finally managed to create my files.
Just wondering though, on the pc, can I have separate lines within the one text field?
And, in the app, because I have a lot of text in the one field, can I view the field contents without the keyboard coming up?
Many thanks,
Kerrie.
Yes, you can have separate lines within a single field for your import. The important thing to note is you need to make sure your column is surrounded by quotes.
For example:
My first column,”The second column has text that is
contained on multiple lines”,My third column,”And last, but not least,
the fifth column”
Also note the fifth column has commas in it. If you use a comma delimiter, you must put double quotes around it so Tap Forms can treat it as a single column with data that just so happens to have commas inside it.
I have fixed the Notes field so you will be able to see the entire note without the keyboard popping up until you tap inside the note to edit it.
Thanks,
Brendan
Hello Brendan,
Of all things, your Import settings do not support dd/mm/yy date format, the most popular date format in US. Please add this.
Great app!
oops .. I meant mm/dd/yy.
Oops! Yes, you’re right.
I have just added that for the next update.
Sorry about that.
Brendan
Hi, Brendan! Love TapForms so far, but I have an urgent request: I have a database with a number of long (several paragraphs’ worth of text) fields. The app truncates them after four lines. Please, please, please can you enable either 1) unlimited-length text fields (can be scrollable or show all the text on a secondary screen), or 2) the ability to set a field’s length?
Thanks very much!
:) Nicole
Oops–I meant that the app truncates them upon import (the original file was tab-delimited).
:) Nicole
Never mind! I see that feature is part of the “Notes” field type functionality. I’ve changed all of those field types to Note.
:) Nicole
Tried to import csv file but only 19 of 72 records imported. 20th record had a “£” in text, removed and imported OK.
I am trying to split up my database into smaller subsets.
I have exported the database, used TextEdit to change some values and delete some rows.
When I import the data into a new, cloned database, the second field (of the type date-time) gets hosed and, in all rows, replaced with “December 31, 1969 16:00”
The date format for both importing and exporting is mm/dd/yyyy and on the iPod the import and export files look correct.
Is there something tricky about using the date-time field?
Dennis
Any thoughts
I really love this app, and I’m just not discovering the import feature. So I’ve started creating a new test database using TextEditor (Mac) and everything looks right. Then once the form is imported, the first field name has an “N” in front of it. My text file is this:
Manufacturer,Model,Form,Available
Eaton,ATS Bypass Isolation Switch,Closed Transition,Y
Schneider Electric,ATS-NW,Open Transition,N
I then save that with UTF-8 encoding with a .csv extension. Once that’s converted to a form inside TapForms, the field name is displayed as “NManufacturer”. Now, encoding with UTF-16 solves this problem, so I checked and made sure that the File Encoding under Import Settings is set to automatic. Is this a bug I’ve stumbled on?
Thanks for all your help!
Hi
would be a good idea to have link on your website to the instructions in the coments about import and exporting with out going through the comments as it explains it well but could not find that at first search it would have saved me heaps of time
great app thanks
I noticed that HanDBase allowed the use of MS Internet Explorer to perform FTP upload and download. I tried it with TapForms, and it works. No need for a separate program. Due to your great support, I will now purchase the full program.
On Snow Leopard, and possibly Leopard I’d imagine, I select Go/Connect to server in the finder, enter the http 8080 address for WebDav and use a username and password – works OK, though I’ve had a couple of occasions when it hangs and sometimes the iPhone app crashes too (this is just on file transfer, not import).
On the import itself, no luck yet :(
I’m trying to import a database of poems, so I have several text fields for title, author etc. and one for date, then a field called “text” at the end, which is of “note” type. Some of the values are pretty long, of course, so I was doing a test import with just three poems. The CSV is 102 lines altogether. The import appears to work (it thinks there are 4 records, probably my trailing newline?). However, on opening the form I find no records! If I customize the form there are no fields in it either. If I add a text field called “Title” to match the CSV file I then see four records, but all of them are blank titles.
I assumed that the import should create a new form each time with all the field names and types I specified. Am I right? What’s wrong?
P.S. I have tried both pipes and commas for separators, and I have placed commas around the fields as in the example above. Also, this may be relevant – my date format is “yyyy-mm-dd”.
Oops, I’ve typed too much. I do that :)
Oops. When I said “commas around the fields”, of course I meant “quotes” !
Well that was great! Brendan emailed me within minutes of my post – thanks Brendan!
It turns out my problem was the character encoding hadn’t been set. In case anyone else has this problem, here’s a summary:
I created the CSV in Windows XP, copied it to iMac, then downloaded to iPhone. In this instance, importing with character encoding set to “Auto” didn’t work. When I changed to “Windows Latin 1” it was fine.
I managed to import some csv files okay, but the largest failed to get as far as the forms list, but it was visible in the form list. When I tried to delete it, the app hung and since then I have not been able to open Tap Forms at all. Can I reinstall the app and start over. It is a great app, so I really want it back please.
Apopa! My earlier posting didn’t show a plus sign I put in. It should have read… ‘failed to get as far as the forms (ie main) list, but it was visible in the plus (ie new) forms list’…
I am using Tapforms to store the photography tips I read about and to make entering this info easier I am using Excel.
A couple of tips:
1. If you perform an export from TapForms first, this will create a CSV file that you can then edit on your PC or Mac with all of the field names and types in place.
2. Make sure you turn on “Export Record ID” in the import/export settings. If you do not have this on, when you next import your csv file into TapForms you will end up with duplicate records. When editing the csv file on your PC or Mac, leave this field blank for new records and TapForms will import it as a new record.
This is a truely excellent app Brendan – Can’t wait for the desktop app to go with it :)
I can’t seem to import more than 2 records in my CSV file, what am I doing wrong? My CSV reads like this:
Title,Year,Price,Size,Medium,Copies Available?,Framed?,Notes
Adoration,2009,200,8×8 unframed, 16×16 framed,Ink Painting on canvas,,Yes,
After Dinner,2009,50,Approx 8×8,Ink Illustration on Paper,No,,
Balance,2010,200,8×8 unframed, 16×16 framed,Ink Painting on canvas,,Yes,At Baden Hound
Blue Heeler,2010,200,8×8,Ink Painting on canvas,,Yes,At Baden Hound
My import settings are File Encoding=Automatic, Date Format=default, Column Delimiter=Comma
I have tried everything except the Japanese File Encoding, and get either zero or 2 rows of 10. In the initial import screen, it sees 10 rows, but stops importing at 2. If I View instead of Import, I see all 10 records.
Eventually I would like to import hundreds of records, this is just my test. Any advice?
Hello Sue,
Your header row has 7 commas in it, but not all your data rows have 7 commas. Some have 8. That’s probably the problem. They have to match.
Thanks,
Brendan
I am making a DB of airports with fields including text, numbers and photos. I can export the DB and modify it on Excel on my Mac. I then export the modified file to csv.
However when I import the modified version the text and numbers import correctly, but the photo fields are now empty in all the records and I have to reselect which photo goes with each field.
Any solutions as inputting on the Mac is a lot faster than the iphone.
Hello Glenn,
You should remove the photos column from the CSV file before you import them back into Tap Forms. The photos will not be removed then.
Thanks,
Brendan
So do I need to leave a blank column in my desktop csv file where the photo field would be or do I just need to delete it completely and have less columns (fields) in the desktop v iphone file?
Thanks for the quick reply. I really like how your app keep the photos at good resolution which can be zoomed and are still readable.
I have just tried this with a sample database. I used export settings of Export Record ID both ON and OFF. When I exported the form/DB I could modify it with Excel and create another record. The original form had a picture in it and the photo ID seems to be in the CSV (lots of alpha numeric & .jpg under the photo field). However when I import the CSV, both the original and the new record appear (which is good) but the photo field of the original record no longer has the photo I had put there.
I tried with deleting the photo column in the CSV before I imported it and also just deleting the data in that field prior to import to Tap Forms but in both cases the photo in the original record gets lost.
Hi Glenn,
I’ll look into this issue. But if there’s no photo column, and there exists a record ID, then I’m not sure why it’s removing the photo. But hey, it’s possible. I’ll look into it to see what the problem is.
Thanks,
Brendan
Hi
OK, I count myself as very computer literate coming from the Acorn platform then to Mac’s – but I am stumped.
I am trying to get my Filemaker database into TapForms, I have a .csv file in the correct format waiting, but I cannot connect. I have the IMPORT screen ion my iPhone4 with an http:// address at the bottom. Putin gthat into Speed Download or CyberDuck gives ‘connection failed’
How do I get the file onto the iPhone – PLEASE HELP me
I have read all the comments above but nothing helps IAF – At the moment my paid for App looks like a dead duck.
Cheers
Colin
Hello Colin,
Have you tried visiting the website address displayed on the Files tab using Safari?
There you will see a web page which allows you to upload files. Alternatively if you need to use FTP, then you need to switch Tap Forms to use the FTP server. This you do on the Tools tab. Also alternatively you can signup for a free Dropbox account and transfer files to Tap Forms that way.
Thanks,
Brendan
Thanks for the prompt reply
Firstly – there is no web page detailed on the Files tab, when you click the question mark it gives you details on how to connect using CyberDuck (Ia am) or via DropBox. I have tried all these to no avail. I just get the message – ftp://anonymous@192.168.1.70:8021 failed, connection refused.
This is great
To all you struggling with the use of TapForms – the support is EXCELLENT !
Just ask.
Thanks Brendan
Thanks Colin,
And just to let others know, Colin’s issue was with Cyberduck automatically filling in port 21. Changing that to port 8021 as is required by Tap Forms fixed the problem for him.
Thanks!
Brendan
Hi all
I have just had the import stop importing at 30 records out of 3235 – I firstly got rid of all the double quotes that Filemaker puts into the .csv export and made sure the first line contained the field names separated by a comma! The solution was to change import settings to ‘automatic’ and try Mac Roman for the encoding (if you use a MAC :-)) and that seemed to work for me.
Just discovered a cool feature that is not clear from use. You can drag the order that the fields are displayed in (in customise setting) , mine was showing the Title first which was kind of useless- I just dragged Surname to the top and now it is easy to see my contacts.
I guess when the manual come out all will be clear :-)
Hi
I’m having a problem importing a column of type date_time from CSV into a form. I have exported my form to csv, and tried to import a line in exactly the format, with the same header column except form_record_id (I also tried it with, and left it blank). For some reason even though the date_time format I am using is mm/dd/yyyy hh:mm it imports into the database as 1 January 1970 01:00 every time. I’m not sure why as it is in exactly the same format as the exported csv, and the import/export format settings are the same. Any ideas?
Thanks, Ian.
Hello Ian,
Yes, that’s a problem. Unfortunately I haven’t added the ability to import date/time or time fields. Only importing date fields is supported at this moment. That’s something I need to add.
Sorry for that.
Brendan