If you select New Form, Tap Forms will create a new form for you using the field names from the first row of the CSV file. You can either enter a name for a new form to be created, or if you already have a form that you’d like to import your CSV file into, select it from the list of available forms. Just make sure your time format is set to be the same format as what is contained within your CSV file. Time formats follow the same principal as date formats. For example, when Bento exports its Date & Time values it uses this format: yyyy-MM-dd’T‘HH:mm:ss Time Format You can use these if your date has a combined date & time value within it that has the date and time separated by the letter T. There are a couple Date & Time formats in the popup menu also. As long as it follows one of the formats displayed in the list of date formats in Tap Forms. So if you have a date in your file like “Dec 10, 2013” then you need to convert that to be “” or some other variation on a numeric date format. Tap Forms only understands date formats that are numeric based. Is it month, day, year, or day, month, year? In order for Tap Forms to understand the date values in your file, you must tell it what format your date columns use. When you have a file that has dates in it, Tap Forms needs to be told how to interpret the date values. Tap Forms does then automatically when you export records. Mostly you never have to worry about this sort of thing because programs like Excel and Numbers should automatically put double quotes around any data that contains a column delimiter within it. Because there is a comma in the value, the entire value must be surrounded with double quotes. If you have a delimiter within your data then you must put double-quotes around the value. Column delimiters help tell Tap Forms how to distinguish one field’s value from the next. Tap Forms supports the following set of column delimiters: comma, semi-colon, tab, and pipe. On the Mac you may need to use Mac OS Roman file encoding. However, if you’re importing from a Windows PC that exported a CSV file using Excel, you most likely want to use Windows Latin 1. UTF-8 is the most sensible file encoding to use because it can encode characters from any language on Earth. For example, the character A is number 65, B is 66, and so on when using the ASCII file encoding format. File encodings tell a computer what characters to display on screen when it encounters different numbers in a text file. But to a computer, the file contains just a bunch of numbers all strung together. When you open a text file we just see characters, words and sentences. *File encoding is just a way of describing to a computer which characters the data in the file represents. Another issue that you might notice is strange garbage characters appearing instead of properly accented characters. This will most likely manifest itself in Tap Forms importing fewer rows than are actually in the file. If you don’t set it correctly, Tap Forms won’t be able to understand all the characters in the file you’re trying to import. It’s very important to set the file encoding setting correct for the file you’re trying to import. The first thing to do is click the Choose file button and then select a file you wish to import. Tap Forms uses the names of the fields in the first row to match up with the fields created in your form. *You should also make sure your field names are unique in the header row. The benefit of an XLSX file is you don’t have to worry about things like column delimiters, line endings, or file encodings. Tap Forms will not import any formatting information from an Excel worksheet file. Make sure your data is structured as regular rows and columns. Tap Forms will also only import the first sheet of data from the XLSX file. Importing XLSX files requires only that you have the first row in your Excel file be the names of the fields you would like to be in your form. Otherwise Tap Forms will create a new field for every value in the first row which does not match a field name in the form you’re importing into. If you choose an existing form to import your records into, you must make sure that the first row values match the field names exactly as you have them named in your form. *When you import a CSV file, Tap Forms uses the first row of your file as the field names to create when you choose the New Form option. Just make sure whatever column delimiter you use in the file, you set Tap Forms to use the same column delimiter. These file types are all pretty much the same but contain slightly different column delimiters. tsv (tab separated values) file extension. You can import both CSV text files and Excel XLSX worksheet files.īefore you can import a CSV file to Tap Forms you must export it from another app to a text file. Tap Forms provides a wide variety of options for importing data from other applications.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |