I am unable to process the importconsole.exe from a windows service to process automatically without user intervention. I am receiving the following error in the log file:

"Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application."

There does not seem to be any documentation available for disabling modal dialogs.

Is this possible? And if not, is the expectation that a human will interactively process every single transaction with the import console manually?

I am able to run it from the command line. There are no UI displays at all. I do see some issues with the data in the file I am still trying to figure out as well, but it at least processes from the command line but not when executed from within the service. I even tried enabling the option for the service to interact with desktop and that did not make any difference. I am trying a few more options today as well as trying to figure out why it is complaining about duplicate columns that aren't actually duplicates.

Below is what I am getting today. The Company, ApAccount and DetailSalesItem are currently set with a default value. They are empty in the CSV file but the columns exist only once in the CSV file. I have added asterisks to cover private data.



04/30/2024 @ 08:20:47AM : Initializing import
04/30/2024 @ 08:20:47AM :
04/30/2024 @ 08:20:47AM : Opening Database
04/30/2024 @ 08:20:49AM :
04/30/2024 @ 08:20:49AM : Reading import file to data table
04/30/2024 @ 08:20:49AM :
04/30/2024 @ 08:20:49AM : Preprocessing data table
04/30/2024 @ 08:20:49AM :
04/30/2024 @ 08:20:49AM : Processing import file
04/30/2024 @ 08:20:49AM : Column 'Company' is mapped more than once.
04/30/2024 @ 08:20:49AM : Column 'ApAccount' is mapped more than once.
04/30/2024 @ 08:20:49AM : Column 'DetailSalesItem' is mapped more than once.
04/30/2024 @ 08:20:49AM : Row: 2, Company: Field can't be empty
04/30/2024 @ 08:20:49AM : Row: 2, ApAccount: Field can't be empty
04/30/2024 @ 08:20:49AM : Row: 2, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:49AM : Row: 2, ProfitCenter: No 'ProfitCostCenters' items found that match '265' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 2, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 3, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 3, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 3, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 3, ProfitCenter: No 'ProfitCostCenters' items found that match '284' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 3, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 4, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 4, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 4, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 4, ProfitCenter: No 'ProfitCostCenters' items found that match '216' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 4, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 5, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 5, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 5, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 5, ProfitCenter: No 'ProfitCostCenters' items found that match '241' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 5, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 6, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 6, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 6, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 6, ProfitCenter: No 'ProfitCostCenters' items found that match '285' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 6, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 7, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 7, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 7, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 7, ProfitCenter: No 'ProfitCostCenters' items found that match '239' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 7, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 8, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 8, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 8, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 8, ProfitCenter: No 'ProfitCostCenters' items found that match '249' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 8, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 9, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 9, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 9, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 9, ProfitCenter: No 'ProfitCostCenters' items found that match '279' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 9, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 10, Company: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 10, ApAccount: Field can't be empty
04/30/2024 @ 08:20:50AM : Row: 10, Sequence: No 'Sequences' items found that match '0' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 10, ProfitCenter: No 'ProfitCostCenters' items found that match '244' in column 'Name'
04/30/2024 @ 08:20:50AM : Row: 10, AssociatedAccount: No 'Accounts' items found that match '5108000' in column 'Name'

Configuration Used:

<Configuration>
<AutomaticMappingField>Name</AutomaticMappingField>
<AutomaticMappingFieldForAccounts>Name</AutomaticMappingFieldForAccounts>
<DatabaseName>************</DatabaseName>
<FileContainsHeaderRow>True</FileContainsHeaderRow>
<ImportAction>Add</ImportAction>
<ImportFileName>*****_00000239.csv</ImportFileName>
<LogFile>*****_00000239.log</LogFile>
<Name>******</Name>
<Mappings>
<Mapping>
<DestinationKey>Company</DestinationKey>
<SourceKey></SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue>*******</DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>Vendor</DestinationKey>
<SourceKey>1</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>ApAccount</DestinationKey>
<SourceKey></SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue>A/P - Vendors</DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>TransDate</DestinationKey>
<SourceKey>3</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>TransNumber</DestinationKey>
<SourceKey>4</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>InvoiceRef</DestinationKey>
<SourceKey>12</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>DetailSalesItem</DestinationKey>
<SourceKey></SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue>Misc. Sales Item -- NO TAX</DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>Amount</DestinationKey>
<SourceKey>18</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>ProfitCenter</DestinationKey>
<SourceKey>20</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>AssociatedAccount</DestinationKey>
<SourceKey>25</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>Project</DestinationKey>
<SourceKey>26</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
<Mapping>
<DestinationKey>Notation</DestinationKey>
<SourceKey>27</SourceKey>
<LookupSource></LookupSource>
<DateFormat></DateFormat>
<DefaultValue></DefaultValue>
</Mapping>
</Mappings>
</Configuration>

FileContainsHeaderRow = True means that the import will not only skip the first row but also look at the column name in the first row to see if it matches an import field. So if you've set a default value for Company but also have a column in the first row with the text "Company", the import will automatically map that column to Company data. I'd suggest, eliminating the header row and setting FileContainsHeaderRow to False.

I have some suggestions on some of the other errors:

No 'Sequences' items found that match '0' in column 'Name' -> This is probably because Sequence in CenterPoint indicates a specific numbering sequence for documents. For example, an "AP Invoice Number" sequence would tell CenterPoint to take the next sequence for AP Invoice and assign it to the document you are creating as a transaction/document number. Like you, I'd see Sequence and assume it's the number that orders the detail lines, but it's not. You probably don't need to set this.

ProfitCenter: No 'ProfitCostCenters' items found that match '249' in column 'Name'. AutomaticMappingField = Name means that the import is going to try to match the text 249 up to the name of a Profit Center in CenterPoint. I'm guessing that changing the Automatic Mapping Field to Abbreviation will fix this.

Associated Account is a more advanced feature. I don't think you need to assign that at all. If you do need to set it, the text looks like an account number (an expense account possibly) so you'd have to change AutomaticMappingFieldForAccounts from Name to AccountNumber.

You do need an AP account, but I think that they can probably set a default value for that. The same rule about the AutomaticMappingFieldForAccounts applies - if the incoming value is something like "2108000=", then the AutomaticMappFieldForAccounts should probably be set to AccountNumber as it's not a Name and probably not an abbreviation.

Edited by user Tuesday, April 30, 2024 4:08:13 PM(UTC)  | Reason: Not specified