Styjun

Gambler's Fallacy Dice

How to convince boss to spend notice period on documentation instead of new projects

Do seaplanes need to get clearance for takeoff?

How can I prevent Bash expansion from passing files starting with "-" as argument?

How could the B-29 bomber back up under its own power?

Germany rejected my entry to Schengen countries

Is being an extrovert a necessary condition to be a manager?

Was murdering a slave illegal in American slavery, and if so, what punishments were given for it?

Story about encounter with hostile aliens

pwaS eht tirsf dna tasl setterl fo hace dorw

How to choose the correct exposure for flower photography?

Warped chessboard

400–430 degrees Celsius heated bath

Salesforce bug enabled "Modify All"

Why use nominative in Coniugatio periphrastica passiva?

How to use Screen Sharing if I don't know the remote Mac's IP address

How would a physicist explain this starship engine?

Is my company merging branches wrong?

Does a windmilling propeller create more drag than a stopped propeller in an engine out scenario?

Good examples of "two is easy, three is hard" in computational sciences

Managing heat dissipation in a magic wand

How to become an Editorial board member?

What's is the easiest way to purchase a stock and hold it

Can ROS workspace safely exist in an external HDD?

How to convert below tkinter code into multi threading?

Freezing/Hanging tkinter Gui in waiting for the thread to completeHow do I protect Python code?How to use threading in Python?How do I convert datetime to date (in Python)?How to convert list to stringHow to pass arguments to a Button command in Tkinter?Tkinter and multi-threadingTkinter freezing with multi threadingPython 3 Multi-Threading with TkinterPython multi-threading with tkinterMulti threading in Tkinter GUI, threads in different classes

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

1

I have method in my tkinter application. This method is used to export data into CSV from another application. The loop for export the data is very heavy. It takes days of time to complete.

I just came across the multi threading concept. Its kind of difficult to understand, I spent an entire day on this but couldn't achieve anything. Below is the code I use in my loop. Can this be handled by multiple threads without freezing my tkinter UI?

I have a Label that shows the number of records(cells) exported, in the tkinter window.

def export_cubeData(self):
 exportPath = self.entry_exportPath.get()

 for b in itertools.product(*(k.values())):
 self.update()
 if (self.flag == 0):
 list1 = list()
 for pair in zip(dims, b):
 list1.extend(pair)
 list1.append(self.box_value.get())
 mdx1 = mdx.format(*temp, *list1)
 try:
 data = tm1.cubes.cells.execute_mdx(mdx1)
 data1 = Utils.build_pandas_dataframe_from_cellset(data)
 final_df = final_df.append(data1)
 cellCount = tm1.cubes.cells.execute_mdx_cellcount(mdx1)
 finalcellCount = finalcellCount + cellCount
 self.noOfRecordsProcessed['text'] = finalcellCount
 except:
 pass
 else:
 tm.showinfo("Export Interrupted", "Data export has been cancelled")
 return
 final_df.to_csv(exportPath)
 print(time.time() - start)
 tm.showinfo("info", "Data export has been completed")
 self.noOfRecordsProcessed['text'] = '0'

python python-3.x tkinter

share|improve this question

asked Mar 23 at 19:29

user1404user1404

446

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The technique used in this answer to a question titled "Freezing/Hanging tkinter Gui in waiting for the thread to complete" may be helpful.
  
  – martineau
  Mar 23 at 21:12
  
  

  
  
  
  

add a comment | 

1

I have method in my tkinter application. This method is used to export data into CSV from another application. The loop for export the data is very heavy. It takes days of time to complete.

I just came across the multi threading concept. Its kind of difficult to understand, I spent an entire day on this but couldn't achieve anything. Below is the code I use in my loop. Can this be handled by multiple threads without freezing my tkinter UI?

I have a Label that shows the number of records(cells) exported, in the tkinter window.

def export_cubeData(self):
 exportPath = self.entry_exportPath.get()

 for b in itertools.product(*(k.values())):
 self.update()
 if (self.flag == 0):
 list1 = list()
 for pair in zip(dims, b):
 list1.extend(pair)
 list1.append(self.box_value.get())
 mdx1 = mdx.format(*temp, *list1)
 try:
 data = tm1.cubes.cells.execute_mdx(mdx1)
 data1 = Utils.build_pandas_dataframe_from_cellset(data)
 final_df = final_df.append(data1)
 cellCount = tm1.cubes.cells.execute_mdx_cellcount(mdx1)
 finalcellCount = finalcellCount + cellCount
 self.noOfRecordsProcessed['text'] = finalcellCount
 except:
 pass
 else:
 tm.showinfo("Export Interrupted", "Data export has been cancelled")
 return
 final_df.to_csv(exportPath)
 print(time.time() - start)
 tm.showinfo("info", "Data export has been completed")
 self.noOfRecordsProcessed['text'] = '0'

python python-3.x tkinter

share|improve this question

asked Mar 23 at 19:29

user1404user1404

446

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  The technique used in this answer to a question titled "Freezing/Hanging tkinter Gui in waiting for the thread to complete" may be helpful.
  
  – martineau
  Mar 23 at 21:12
  
  

  
  
  
  

add a comment | 

I have method in my tkinter application. This method is used to export data into CSV from another application. The loop for export the data is very heavy. It takes days of time to complete.

I just came across the multi threading concept. Its kind of difficult to understand, I spent an entire day on this but couldn't achieve anything. Below is the code I use in my loop. Can this be handled by multiple threads without freezing my tkinter UI?

I have a Label that shows the number of records(cells) exported, in the tkinter window.

def export_cubeData(self):
 exportPath = self.entry_exportPath.get()

 for b in itertools.product(*(k.values())):
 self.update()
 if (self.flag == 0):
 list1 = list()
 for pair in zip(dims, b):
 list1.extend(pair)
 list1.append(self.box_value.get())
 mdx1 = mdx.format(*temp, *list1)
 try:
 data = tm1.cubes.cells.execute_mdx(mdx1)
 data1 = Utils.build_pandas_dataframe_from_cellset(data)
 final_df = final_df.append(data1)
 cellCount = tm1.cubes.cells.execute_mdx_cellcount(mdx1)
 finalcellCount = finalcellCount + cellCount
 self.noOfRecordsProcessed['text'] = finalcellCount
 except:
 pass
 else:
 tm.showinfo("Export Interrupted", "Data export has been cancelled")
 return
 final_df.to_csv(exportPath)
 print(time.time() - start)
 tm.showinfo("info", "Data export has been completed")
 self.noOfRecordsProcessed['text'] = '0'

python python-3.x tkinter

share|improve this question

asked Mar 23 at 19:29

user1404user1404

446

def export_cubeData(self):
 exportPath = self.entry_exportPath.get()

 for b in itertools.product(*(k.values())):
 self.update()
 if (self.flag == 0):
 list1 = list()
 for pair in zip(dims, b):
 list1.extend(pair)
 list1.append(self.box_value.get())
 mdx1 = mdx.format(*temp, *list1)
 try:
 data = tm1.cubes.cells.execute_mdx(mdx1)
 data1 = Utils.build_pandas_dataframe_from_cellset(data)
 final_df = final_df.append(data1)
 cellCount = tm1.cubes.cells.execute_mdx_cellcount(mdx1)
 finalcellCount = finalcellCount + cellCount
 self.noOfRecordsProcessed['text'] = finalcellCount
 except:
 pass
 else:
 tm.showinfo("Export Interrupted", "Data export has been cancelled")
 return
 final_df.to_csv(exportPath)
 print(time.time() - start)
 tm.showinfo("info", "Data export has been completed")
 self.noOfRecordsProcessed['text'] = '0'

share|improve this question

asked Mar 23 at 19:29

user1404user1404

446

share|improve this question

asked Mar 23 at 19:29

user1404user1404

446

asked Mar 23 at 19:29

user1404user1404

446

asked Mar 23 at 19:29

user1404user1404

446