I have an Excel Spreadsheet containing 3 Customer records. Two have a Currency Code of GBP and one has EUR. I'm trying to create a configuration package to only import the two that have a currency code of GBP and bypass the EUR one. So I went in to Edit - Config. Pagkage Filters and selected Field ID: 22 Field Name: Currency Code and I've tried various values in the Field Filter column:GBP,=GBP,='GBP'"GBP"="GBP"
... None of these work. All 3 records are being imported when I only want two. What am I doing wrong?
Are you trying to filter on the import of the spreadsheet to the configuration package? If so, the Filter on the Configuration Package is NOT applied when importing, only exporting. Your best bet is to only include the records you want to import in the spreadsheet.