I don't have a lot of experience working with Server and based on client feedback they would like a temporary table created, with just the pertinent fields showing to make the importing of information from Excel docs (a standard practice) easier for entry level staff. It's a valid request I can see with just a limited number of fields showing the mapping would be much easier.
The solution runs on FM Cloud Server on AWS using Server 17.
Once the data is in a temp table I would like to move it to the main processing table where many automated functions occur to scrub the data...that involve many more fields.
I am having trouble getting the import function to work on PSoS. I think this would greatly speed up the process! Some of the tables will have 500-600 records, which is not too bad, but some will have 35,000 which is about a 3-4 import process to server. Then close to the same to import it another table.
Once the data is scrubbed, then it goes into a MASTERdb table, so it gets moved again. Locally, it all worked with no timing issues, but going to server has made these processes quite slow.