Had an issue during testing today, when people have to use different handset that has a different arrangement of probe sensors. Each of these sensors may be arranged in a different way so the export CSV file will be different.
There goes gateway mapping to certain cells to columns in the import table because I don't know what cell is related to it. So Ive created a way to dynamically create an import table no matter what the export file header is. This only works if the CSV contains the header names in a data row. Fortunately the CSV files exported row 6 has the header names though being in different orders and sometimes not existing. Gateway starting at row 6 property solves that. Next creating a temporary table with the column names from that row. Then renaming the columns in the import file to match. Once that is done append the data from the temporary table to the properly formatted table. Simple god that wrecked my brain only had 2 hours to work it out. Posting the code on my next post, it's near 200 lines so please understand this can be modified to be improved but I had limited time, I can already see improvements. -- For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php --- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/CABnhDATw_nruCX-UUijo8t14AgzrLRyCO3_Cd4tmFg6p6QYpsg%40mail.gmail.com.
