I was working with the import functionality today to bring a small Excel list into IQ, and have a couple of minor changes to suggest:
- Import Location - When starting the import process, I first selected the item in my grid where I wanted the items imported. I noticed that IQ always imported below the item I selected. Most other applications I've ever worked with import into the selection point, not below it. Suggestion: modify import behavior to import at the item currently selected.
- Header row and row count - On import step 1, I pasted in 15 excel items, and selected the "First row contains field names" option and clicked Next. On step 2, it properly showed the first row of my data as the field name, but then left a blank extra entry at the bottom (see item #15 in the screenshot). A little testing revealed that indicating the first row is a field name should result in the number of rows to import being one less than the selection area, but it is not.
- Destination field vs. Current Field - Another change that I think helps would be to change the name of the header of the destination field for the import. The header is labelled "current field", which is a bit confusing.....Current field currently selected in my InfoQube? Current field where? Changing the title to "Destination Field" would make it clearer that I am being asked to select what the destination field for the import is:
- Final Import Preview - When previewing the final import, The count again shows 15 records to import, whereas in reality there are only 14 since the header row does not import. Perhaps addressing change #2 above would also fix this?
- Import verification screen also shows 15 records instead of 14:
- Combined Effect - Not imported where I selected, and extra row at the bottom due to header row designation in import wizard.
- I haven't used the Mantis bug report system here before. Should this all be one item or two? Can anyone verify the same results I found?
Thanks, and keep up the great work PPL! InfoQube gets better all the time!
PIMfan
Comments