Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33  Location: Arcata, California Thanks: 2 times
|
I understood that problems with the Data Importer command line were going to be fixed in the latest release. But the suggested command line for customers is still incorrect--it leaves out the import type. And after including the import type, I still receive the following error in the log file:
08/12/2020 @ 10:37:48PM : Initializing import
08/12/2020 @ 10:37:48PM :
08/12/2020 @ 10:37:48PM : Opening Database
08/12/2020 @ 10:37:48PM : Object reference not set to an instance of an object.
This is my command line:
importconsole.exe "holly" customers "T:\CPcustomersTest.csv" "T:\CPcustomers.log" Abbreviation Abbreviation username password
Note: the import works properly when run interactively.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/28/2018(UTC) Posts: 65 Location: Pennsylvani mostly Was thanked: 9 time(s) in 9 post(s)
|
The problem you had run into before what that the command line generated in the UI by "Show Command Line" was missing "customers" so that's not it. So this is trickier. I'd start by looking at the file: importconsole.exe.config in the CenterPoint installation folder. The third-to-last line in the example I've included specifies the CenterPoint vertical. If it is"Ag" as I suspect, then the the command line will look for Ag databases and give this error. You can either remove that line or change the vertical to Business. Code:
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<startup useLegacyV2RuntimeActivationPolicy="true">
<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.7.2" />
</startup>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<probing privatePath="ReflectedDlls" />
</assemblyBinding>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
<bindingRedirect oldVersion="0.0.0.0-9.0.0.0" newVersion="9.0.0.0" />
</dependentAssembly>
</assemblyBinding>
</runtime>
<appSettings>
<add key="ApplicationName" value="CenterPoint" />
<add key="VerticalName" value="Business" />
</appSettings>
</configuration>
Also, I am looking at adding payment information to the invoice import. Do you ever put negative payments on your credit invoices (invoices with negative amounts due?)_I was just noticing that we don't allow that inside CenterPoint. Edited by user Thursday, August 13, 2020 3:00:51 PM(UTC)
| Reason: Not specified
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33 Location: Arcata, California Thanks: 2 times
|
Yes, it said "Ag". I tried changing it to "Business" with Notepad++, but it says the file is protected when I try to save it. What is the best way to modify this?
I believe we do import negative payments when we issue a credit memo for a credit card payment. This probably hasn't come up in the two weeks since we went live. What do you suggest?
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33 Location: Arcata, California Thanks: 2 times
|
I managed to save the file with the change from Ag to Business and the import worked! Thank you.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 2/28/2018(UTC) Posts: 65 Location: Pennsylvani mostly Was thanked: 9 time(s) in 9 post(s)
|
Originally Posted by: ward@hollyyashi.com  Yes, it said "Ag". I tried changing it to "Business" with Notepad++, but it says the file is protected when I try to save it. What is the best way to modify this?
I believe we do import negative payments when we issue a credit memo for a credit card payment. This probably hasn't come up in the two weeks since we went live. What do you suggest? I am checking on this with people who know the transaction side of things better. We are trying to put together a change to allow payment fields on an invoice, but when testing this I found that the "Amount Received" button was disabled when the invoice amount was less than zero. That said, if you do not try to associate payments with negative invoices, that would be good to know because it'll speed up this change quite a bit.
|
|
|
|
|
|
Rank: Advanced Member
Groups: Registered
Joined: 8/30/2019(UTC) Posts: 33 Location: Arcata, California Thanks: 2 times
|
We have been importing both invoices and credit memos. And we've also been importing both positive and negative receipts and then matching these to the invoices and credit memos. It all seems to be working just fine.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
Important Information:
The Red Wing Software Developer Forum uses cookies. By continuing to browse this site, you are agreeing to our use of cookies.
More Details
Close
