I have a large DB that needs to be exported to several excel files using equations. E.g extract all records where Comp_code == ABC to file XX_ABC, extract all records where Comp_code == XYZ to file XX_XYZ. I am a newbie in IDEAScripting trying to automate this so that I don't have to repeat the same steps manually. When I run the script provided below to try it for one comp-code, i get a file limit error that says the data I am trying to export is larger that the max number of records, I believe that I am getting that error because IDEA is not capturing the equation in my extraction because when I do it manually using the same equation, it works; that error message comes up because the script is trying to extract the entire data, I got the error message when I tried to export the whole DB.
What is wrong with my script? The script I am using is a macro that I recorded when I extracted manually.
Last seen: 1 month 2 weeks ago
Joined: 02/26/2021 - 09:31