Page 1 of 2

OpenGD77CSV error importing and appending CSV's

Posted: Wed Jul 20, 2022 12:10 pm
by PD9SW
Hi all,

Formerly I succeeded in exporting and importing csv's using OpenGD77CSV v3.1.
Now I'am not. What goes wrong?
I updated OpenGD77 CPS to OpenGD77CPSInstaller_E2022.06.22.01
as well as upgraded OpenGD77CSV from v3.1 to v3.2.

What I am doing to test it is the following.
1. Importing a existing codeplug: succeeded: 1023 contacts, 459 channels and 9 zones.
2. Exporting 4 csv's: succeeded
3. Importing as well as appending the same untouched (and just exported) csv's: unsuccesfully !

So, what goes wrong here?

Details on error:
Zie het einde van dit bericht voor meer informatie over het aanroepen
van JIT-foutopsporing (Just In Time) in plaats van dit dialoogvenster.

************** Tekst van uitzondering **************
System.IO.IOException: Het bestand is al geopend.
bij Microsoft.VisualBasic.FileSystem.FileOpen(Int32 FileNumber, String FileName, OpenMode Mode, OpenAccess Access, OpenShare Share, Int32 RecordLength)
bij GD77_CSV.Form1.CheckDelimiter(String fname)
bij GD77_CSV.Form1.OpenContactsCSV()
bij GD77_CSV.Form1.Button6_Click(Object sender, EventArgs e)
bij System.Windows.Forms.Control.OnClick(EventArgs e)
bij System.Windows.Forms.Button.OnClick(EventArgs e)
bij System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
bij System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
bij System.Windows.Forms.Control.WndProc(Message& m)
bij System.Windows.Forms.ButtonBase.WndProc(Message& m)
bij System.Windows.Forms.Button.WndProc(Message& m)
bij System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
bij System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
bij System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Geladen assembly's **************
mscorlib
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4515.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/Windows/Microsoft.NET/Framework/v4.0.30319/mscorlib.dll
----------------------------------------
GD77-CSV
Assembly-versie: 1.0.0.0
Win32-versie: 1.0.0.0
CodeBase: file:///B:/Steven/Hobby/Scanner%20Radioamateur/Apparatuur/Radioddity/GD-77%20%20TYT%20MD-760/OpenGD77/Codeplugs/OpenGD77CSV/OpenGD77-CSV%20v3.2%200722.exe
----------------------------------------
Microsoft.VisualBasic
Assembly-versie: 10.0.0.0
Win32-versie: 14.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic/v4.0_10.0.0.0__b03f5f7f11d50a3a/Microsoft.VisualBasic.dll
----------------------------------------
System
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4488.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System/v4.0_4.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
System.Core
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4515.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Core/v4.0_4.0.0.0__b77a5c561934e089/System.Core.dll
----------------------------------------
System.Windows.Forms
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4515.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms/v4.0_4.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
System.Drawing
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4390.0 built by: NET48REL1LAST_C
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Drawing/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System.Configuration
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4190.0 built by: NET48REL1LAST_B
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Configuration/v4.0_4.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Xml
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Xml/v4.0_4.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
System.Runtime.Remoting
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Runtime.Remoting/v4.0_4.0.0.0__b77a5c561934e089/System.Runtime.Remoting.dll
----------------------------------------
mscorlib.resources
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/mscorlib.resources/v4.0_4.0.0.0_nl_b77a5c561934e089/mscorlib.resources.dll
----------------------------------------
Microsoft.VisualBasic.resources
Assembly-versie: 10.0.0.0
Win32-versie: 14.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/Microsoft.VisualBasic.resources/v4.0_10.0.0.0_nl_b03f5f7f11d50a3a/Microsoft.VisualBasic.resources.dll
----------------------------------------
System.Windows.Forms.resources
Assembly-versie: 4.0.0.0
Win32-versie: 4.8.4084.0 built by: NET48REL1
CodeBase: file:///C:/WINDOWS/Microsoft.Net/assembly/GAC_MSIL/System.Windows.Forms.resources/v4.0_4.0.0.0_nl_b77a5c561934e089/System.Windows.Forms.resources.dll
----------------------------------------

************** JIT-foutopsporing **************
Als u JIT-foutopsporing wilt inschakelen, moet in het configuratiebestand voor deze
toepassing of computer (machine.config) de waarde
jitDebugging in het gedeelte system.windows.forms zijn ingesteld.
De toepassing moet ook zijn gecompileerd terwijl foutopsporing
was ingeschakeld.

Bijvoorbeeld:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

Wanneer JIT-foutopsporing is ingeschakeld, worden onverwerkte uitzonderingen
naar het JIT-foutopsporingsprogramma gestuurd dat op de computer is geregistreerd
en worden niet door dit dialoogvenster verwerkt.




Any more info needed, let me know!
Thanks in advance!

Greetings,
Steef

Re: OpenGD77CSV error importing and appending CSV's

Posted: Wed Jul 20, 2022 2:02 pm
by OE1MWW
just tried on my Windows 10 x64 and the sequence

- export and import into a new codeplug works perfect with the OpenGD77CSV v3.2.

Did you check before or after export the 'Use comma for Decimals' in the OpenGD77CSV v3.2 ?

Depending on your system settings, this should be according to your 'national' settings.
The German language Windows is using a ';' as delimiter for fields. Therefore the
setting 'Use comma for Decimals' (in my case) must be left open.

73's de OE1MWW
Wolfgang

Re: OpenGD77CSV error importing and appending CSV's

Posted: Thu Jul 21, 2022 3:10 am
by VK3KYY
@steef

You have not followed site requirments by posting first to the new users forum, and you have not told us your callsign, or used it as your username etc

Re: OpenGD77CSV error importing and appending CSV's

Posted: Thu Jul 21, 2022 11:40 am
by PD9SW
Thnx MWW will try, did use comma separated because worked fine before.
Open for more ideas.
Update:
I tried to only append channels.csv (with comma separated btw) and that seems to work fine. So the problem must be somewhere in the other three csv's?


[ Offtopic:
@KYY: Wasn't aware of still being a new user, since i registered over 7 months ago.
It's PD9SW.
Do have a problem with the site keep saying i have to accept cookies, but there is nowhere to accept. ]

Re: OpenGD77CSV error importing and appending CSV's

Posted: Thu Jul 21, 2022 2:16 pm
by OE1MWW
Steef wrote:
Thu Jul 21, 2022 11:40 am
Do have a problem with the site keep saying i have to accept cookies, but there is nowhere to accept. ]
in the center/middle of the very first page you have to click on the text

73's de OE1MWW
Wolfgang

Re: OpenGD77CSV error importing and appending CSV's

Posted: Thu Jul 21, 2022 7:48 pm
by PD9SW
OFFTOPIC:
OE1MWW wrote:
Thu Jul 21, 2022 2:16 pm
Steef wrote:
Thu Jul 21, 2022 11:40 am
Do have a problem with the site keep saying i have to accept cookies, but there is nowhere to accept. ]
in the center/middle of the very first page you have to click on the text
73's de OE1MWW
Wolfgang
Sorry, it's not there... Of course I would have seen it.
Maybe this thread is not the best place to talk about this
I would have posted a screenshot, but file too large too difficult. Any other place we could discuss this? PM?

Re: OpenGD77CSV error importing and appending CSV's

Posted: Thu Jul 21, 2022 8:14 pm
by IZ2EIB
Steef wrote:
Wed Jul 20, 2022 12:10 pm
Hi all,

Formerly I succeeded in exporting and importing csv's using OpenGD77CSV v3.1.
Now I'am not. What goes wrong?
I updated OpenGD77 CPS to OpenGD77CPSInstaller_E2022.06.22.01
as well as upgraded OpenGD77CSV from v3.1 to v3.2.

What I am doing to test it is the following.
1. Importing a existing codeplug: succeeded: 1023 contacts, 459 channels and 9 zones.
2. Exporting 4 csv's: succeeded
3. Importing as well as appending the same untouched (and just exported) csv's: unsuccesfully !

So, what goes wrong here?

Details on error:
Zie het einde van dit bericht voor meer informatie over het aanroepen
van JIT-foutopsporing (Just In Time) in plaats van dit dialoogvenster.

************** Tekst van uitzondering **************
System.IO.IOException: Het bestand is al geopend.
bij Microsoft.VisualBasic.FileSystem.FileOpen(Int32 FileNumber, String FileName, OpenMode Mode, OpenAccess Access, OpenShare Share, Int32 RecordLength)
bij GD77_CSV.Form1.CheckDelimiter(String fname)
bij GD77_CSV.Form1.OpenContactsCSV()
bij GD77_CSV.Form1.Button6_Click(Object sender, EventArgs e)
...
It seems to me to have already been discussed.
Perhaps it may be that the matter is related to this:
https://opengd77.com/viewtopic.php?f=11&t=1331#p11785

73 best regards de Fabio IZ2EIB

Re: OpenGD77CSV error importing and appending CSV's

Posted: Fri Jul 22, 2022 3:59 am
by VK3KYY
PD9SW wrote:
Thu Jul 21, 2022 11:40 am
[ Offtopic:
@KYY: Wasn't aware of still being a new user, since i registered over 7 months ago.
It's PD9SW.
Do have a problem with the site keep saying i have to accept cookies, but there is nowhere to accept. ]
I have changed your username to PD9SW

if you are having problems with cookies, it may because you are not accessing the site via HTTPS.

Try going to

https://opengd77.com

and accept the cookies and then try always to access the form via HTTPS

Re: OpenGD77CSV error importing and appending CSV's

Posted: Sat Jul 23, 2022 9:53 pm
by PD9SW
IZ2EIB wrote:
Thu Jul 21, 2022 8:14 pm
Steef wrote:
Wed Jul 20, 2022 12:10 pm
Hi all,

Formerly I succeeded in exporting and importing csv's using OpenGD77CSV v3.1.
Now I'am not. What goes wrong?
I updated OpenGD77 CPS to OpenGD77CPSInstaller_E2022.06.22.01
as well as upgraded OpenGD77CSV from v3.1 to v3.2.

What I am doing to test it is the following.
1. Importing a existing codeplug: succeeded: 1023 contacts, 459 channels and 9 zones.
2. Exporting 4 csv's: succeeded
3. Importing as well as appending the same untouched (and just exported) csv's: unsuccesfully !

So, what goes wrong here?

Details on error:
Zie het einde van dit bericht voor meer informatie over het aanroepen
van JIT-foutopsporing (Just In Time) in plaats van dit dialoogvenster.

************** Tekst van uitzondering **************
System.IO.IOException: Het bestand is al geopend.
bij Microsoft.VisualBasic.FileSystem.FileOpen(Int32 FileNumber, String FileName, OpenMode Mode, OpenAccess Access, OpenShare Share, Int32 RecordLength)
bij GD77_CSV.Form1.CheckDelimiter(String fname)
bij GD77_CSV.Form1.OpenContactsCSV()
bij GD77_CSV.Form1.Button6_Click(Object sender, EventArgs e)
...
It seems to me to have already been discussed.
Perhaps it may be that the matter is related to this:
https://opengd77.com/viewtopic.php?f=11&t=1331#p11785

73 best regards de Fabio IZ2EIB
I didnt find that thread. Will try that Fabio thanks so much.

Re: OpenGD77CSV error importing and appending CSV's

Posted: Sat Jul 23, 2022 9:57 pm
by PD9SW
VK3KYY wrote:
Fri Jul 22, 2022 3:59 am
PD9SW wrote:
Thu Jul 21, 2022 11:40 am
[ Offtopic:
@KYY: Wasn't aware of still being a new user, since i registered over 7 months ago.
It's PD9SW.
Do have a problem with the site keep saying i have to accept cookies, but there is nowhere to accept. ]
I have changed your username to PD9SW

if you are having problems with cookies, it may because you are not accessing the site via HTTPS.

Try going to

https://opengd77.com

and accept the cookies and then try always to access the form via HTTPS
Thanks Roger. Probably I juat typed opengd77, never put the full https://….. by hand. I would not expect http to be accessable, just as it causes troubles. Would that be an idea to automate the redirection?
I was wondering btw why my login keeps failing. Now i see why hi
73
Steef