Export 100+ Records to Excel
We’re using FM Pro 11 to improve our process of maintaining product data for an online catalog. We have 100+ data points that we track over four different product groups. We need to export the data to Excel for verification, then convert to CSV for upload. I need all of the data points on one worksheet in a specific order to upload correctly to our catalog, though all the data points are not used for all products. Since FM Pro has an export limit, I’ve split my data (for export) into two tables. I’m trying to write a script to export data from two tables onto one worksheet, having the second table’s data fill in where the first table left off (one row per record). Can someone point me in the right direction? I’m relatively new to FM Pro and have been struggling with this for a couple of days now. Thanks in advance for your help!!!