Import Only Existing Fields
I know that I can manually toggle to not import specific fields, but that is a lot of work. Does anyone know of a way to only import data for existing fields without all of the manual manipulation?...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendHere is a great technique i have implemented for a client. They have several CSV files to be imported daily and we want to dumb this down to be a clerical but error free function or perhaps even done by an Admin who is only half awake first thing in the morning.
Create a scratchpad table with the exact field names as the CSV file.
The user will have a button on an special Admin record to import to scratchpad.
Then there will be button to import from the scratchpad to the real table. That allows you to control the field mapping and which fields get imported.
Then there will be a button to clear the scratch pad, and of course you give some though to the buttons so that you only show the correct buttons according to if there is data in the scratchpad.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Create a scratchpad table with the exact field names as the CSV file.
The user will have a button on an special Admin record to import to scratchpad.
Then there will be button to import from the scratchpad to the real table. That allows you to control the field mapping and which fields get imported.
Then there will be a button to clear the scratch pad, and of course you give some though to the buttons so that you only show the correct buttons according to if there is data in the scratchpad.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------