Difference between revisions of "Troubleshooting Create from Excel"
From All n One's bxp software Wixi
Philip Lacey (talk | contribs) (Created page with "= Overview = When creating a form in bxp from an Excel spreadsheet it is possible to bump into a few challenges. There are some limitations to the process which are known...") |
(No difference)
|
Revision as of 14:25, 13 February 2018
1 Overview
When creating a form in bxp from an Excel spreadsheet it is possible to bump into a few challenges.
There are some limitations to the process which are known and here they are with their corrections.
| Issue | Solution |
|---|---|
| * Make sure the data is not formulas | Export to Notepad and drop back in (see below) |
| * Fractions and high precision values will cause the field mapping name not to work on creation | Wipe the data from the columns, create the form, wipe just the data loaded, reimport the full data |
| * There is a field length limit of 64 characters | Shorten the column names |
| * Column names cannot contain the full stop character (Microsoft reserved character) | Remove the character or replace with a minus character |
| * Column names cannot contain the [ or ] character (Microsoft reserved character) | Remove the [ Character and replace the ] character with space minus space |
| * Duplicate column names must be removed / managed before creation | Make the column names unique |
| * Percentage data, e.g.100%, will be loaded as a decimal, i.e. 100% = 1 and 56.25% = 0.5625 | If you want the value, drop the data into notepad, remove the % symbol and reload |
| * If you have a data sample ensure there is 21 or greater examples as if <20 different values, the question gets turned into a drop down list | Make sure you have enough of a sample data size with varying values where you do not want a drop down list otherwise there is a lot of form tidying. |
