Hand2Note 4 Beta Discussion: free keys for 2+2 members.
06-09-2023
, 06:33 PM
To do this, first set the necessary date filter:
Then in the Hands tab, right-click and export your hands using this feature:
07-23-2023
, 10:27 PM
I also tried importing from the postgresql db directly and in that case I see the progress bar, but it never imports any hands and runs indefinitely. I'm also unable to click the "Stop" button:
Here's a log snippet in case thats helpful:
Code:
{"@t":"2023-07-24T02:20:44.8094020Z","@mt":"Hand2Note version: 4.0.0"}
{"@t":"2023-07-24T02:20:44.8587830Z","@mt":"Enviroment: {\"Model\":\"x86_64\",\"Manufacturer\":\"Apple\",\"Name\":\"iPad\",\"VersionString\":\"16.5\",\"Version\":\"16.5\",\"Platform\":{},\"Idiom\":{},\"DeviceType\":1}"}
{"@t":"2023-07-24T02:21:14.6521430Z","@mt":"Import from database started."}
{"@t":"2023-07-24T02:21:14.6579570Z","@mt":"DISPATCH ImportProgressUpdatedEvent"}
{"@t":"2023-07-24T02:21:14.6653190Z","@mt":"START BUILDING statistics"}
{"@t":"2023-07-24T02:21:14.6654450Z","@mt":"No hands to build in the database"}
{"@t":"2023-07-24T02:21:14.6739680Z","@mt":"DISPATCH ImportProgressUpdatedEvent"}
{"@t":"2023-07-24T02:21:14.7372180Z","@mt":"In UnobservedTaskException Handler:\n System.Threading.Tasks.Task`1[System.ValueTuple`2[System.Int32,System.Int32]] - System.AggregateException: TaskExceptionHolder_UnhandledException (AggregateException_ctor_DefaultMessage (42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21))\n ---> System.AggregateException: AggregateException_ctor_DefaultMessage (42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21)\n ---> Npgsql.PostgresException (0x80004005): 42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21\n at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\n at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\n at Npgsql.NpgsqlDataReader.NextResult()\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)\n at Hand2NoteCore.Importing.ImportFromDatabaseDialogHelper.GetPt4HandHistories(NpgsqlConnectionStringBuilder connectionString, String databaseRequest)+MoveNext()\n at Hand2NoteCore.Common.Collections.<SplitBy>d__89`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]].MoveNext()\n at System.Linq.Parallel.PartitionedDataSource`1.ContiguousChunkLazyEnumerator[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].MoveNext(List`1& currentElement, Int32& currentKey)\n at System.Linq.Parallel.ForAllOperator`1.ForAllEnumerator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].MoveNext(List`1& currentElement, Int32& currentKey)\n at System.Linq.Parallel.ForAllSpoolingTask`2[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].SpoolingWork()\n at System.Linq.Parallel.SpoolingTaskBase.Work()\n at System.Linq.Parallel.QueryTask.BaseWork(Object unused)\n at System.Linq.Parallel.QueryTask.<>c.<.cctor>b__10_0(Object o)\n at System.Threading.Tasks.Task.InnerInvoke()\n at System.Threading.Tasks.Task.<>c.<.cctor>b__273_0(Object obj)\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n--- End of stack trace from previous location ---\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\n Exception data:\n Severity: ERROR\n SqlState: 42P01\n MessageText: relation \"public.cash_hand_histories\" does not exist\n Position: 21\n File: parse_relation.c\n Line: 1363\n Routine: parserOpenTable\n Exception_EndOfInnerExceptionStack\n at System.Linq.Parallel.QueryTaskGroupState.QueryEnd(Boolean userInitiatedDispose)\n at System.Linq.Parallel.SpoolingTask.SpoolForAll[List`1,Int32](QueryTaskGroupState groupState, PartitionedStream`2 partitions, TaskScheduler taskScheduler)\n at System.Linq.Parallel.DefaultMergeHelper`2[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].System.Linq.Parallel.IMergeHelper<TInputOutput>.Execute()\n at System.Linq.Parallel.MergeExecutor`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Execute()\n at System.Linq.Parallel.MergeExecutor`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Execute[Int32](PartitionedStream`2 partitions, Boolean ignoreOutput, ParallelMergeOptions options, TaskScheduler taskScheduler, Boolean isOrdered, CancellationState cancellationState, Int32 queryId)\n at System.Linq.Parallel.PartitionedStreamMerger`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Receive[Int32](PartitionedStream`2 partitionedStream)\n at System.Linq.Parallel.ForAllOperator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].WrapPartitionedStream[Int32](PartitionedStream`2 inputStream, IPartitionedStreamRecipient`1 recipient, Boolean preferStriping, QuerySettings settings)\n at System.Linq.Parallel.UnaryQueryOperator`2.UnaryQueryOperatorResults.ChildResultsRecipient[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Receive[Int32](PartitionedStream`2 inputStream)\n at System.Linq.Parallel.ScanQueryOperator`1.ScanEnumerableQueryOperatorResults[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].GivePartitionedStream(IPartitionedStreamRecipient`1 recipient)\n at System.Linq.Parallel.UnaryQueryOperator`2.UnaryQueryOperatorResults[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].GivePartitionedStream(IPartitionedStreamRecipient`1 recipient)\n at System.Linq.Parallel.QueryOperator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].GetOpenedEnumerator(Nullable`1 mergeOptions, Boolean suppressOrder, Boolean forEffect, QuerySettings querySettings)\n at System.Linq.Parallel.ForAllOperator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].RunSynchronously()\n at System.Linq.ParallelEnumerable.ForAll[List`1](ParallelQuery`1 source, Action`1 action)\n at Hand2NoteCore.Importing.ImportFromDatabaseDialogHelper.ImportFromDatabase(ImportOperation importOperation, DatabaseData databaseData)\n at Hand2NoteCore.Importing.ImportFromDatabaseDialogHelper.<>c__DisplayClass14_1.<ImportDataFromOtherTrackerDatabaseWithDialog>b__1(ImportOperation importOperation)\n at Hand2NoteCore.Importing.ImportHelper.Import(Import import, Action`1 importAction)\n at Hand2NoteCore.AppHelper.<>c__DisplayClass69_0.<ImportHands>b__1()\n at System.Threading.Tasks.Task`1[[System.ValueTuple`2[[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].InnerInvoke()\n at System.Threading.Tasks.Task.<>c.<.cctor>b__273_0(Object obj)\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n--- End of stack trace from previous location ---\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\n Exception_EndOfInnerExceptionStack","@l":"Error"}
{"@t":"2023-07-24T02:21:14.7382030Z","@mt":"AggregateException_ctor_DefaultMessage (42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21)","@l":"Error"}
{"@t":"2023-07-24T02:21:14.7384860Z","@mt":"System.Linq.Parallel","@l":"Error"}
{"@t":"2023-07-24T02:21:14.7418360Z","@mt":"{}","@l":"Error"}