Improvements to Data Import

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • Acknowledged
  • (Edited)
Could it be made possible to save the field mapping specification for a data import? In other systems i've used it is possible to keep a record of all data imports including the date, the import file name, the field mapping employed and the result of the import. With QB it is infuriating to have to re-create the data import scheme EVERY single time! 

In addition, i'm sure this must be a bug. On changing the orientation of the data import, QB then loses all of the previously mapped fields. 

Data import is an area of QB that is severely lacking in functionality.
Photo of Kevin

Kevin

  • 260 Points 250 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Evan Martinez

Evan Martinez, Community Manager

  • 8,724 Points 5k badge 2x thumb
Hi Kevin,

Thank you very much for your feedback and enhancement suggestions for our data import and the field mapping. Currently there isn't a function to set a catalog of your previous data imports and track the time, file name, and field mapping employed. Each time that data is imported Quick Base attempts to map your existing fields to the fields in the CSV by trying to find similar matches but does often require double checking and input for fields it cannot match. One small tweak that can help is to make the field names in the CSV and the field names in Quick Base match as much as possible to help sync up the fields when starting an import. 

I have added your feedback into our internal tracking as an enhancement and feedback on importing but I also suggest posting your feedback on our User Voice page. It is our user feedback platform which can most easily be accessed from the My Apps page in Quick Base by clicking on the orange Feedback tab or at http://quickbase.uservoice.com if you have used User Voice before. Out developers use it to help track product feedback and get an idea of the number of users who are excited about a request. A number of the forums users have posted User Voice requests and often it is helpful to put a link to your user voice request here in your Community post to help guide interested Community members to it so they can also put in a vote for the change. Thank you very much for your time today Kevin.