Hi,
Customer gets a bank statement import from their bank in a txt file. Everything I see in Epicor points to it only being able to import from a CSV file. I’m trying to ask Epicor the question and they won’t give me an answer but keep telling me to read the KB. Does anyone know if its possible to import from a txt?
Trying to make Epicor do something off label is often harder than manipulating the data yourself and giving Epicor what it wants. My go-to for hacking up text files is the regex-based find and replace in Notepad++, or Unix command line tools like sed and awk. You can get a bash shell with basic tools on Windows by installing Git For Windows and selecting the Git Bash option.
Thanks for your help. Ironically, the test data they provide when training customers is in a text file format, yet they tell me it can only be imported with the csv.