crom

I'm trying to get accurate (with ms resolution) creation date of a file using python.

The way to get accurate creation date on Window is to use wmic. So I've prepared a simple shell command to read the creation date:

I have a below query which I run gives me the single count for previous week which is Week 44. Current week is 45 as of now.

I have a below query which I run gives me the single count for previous week which is Week 43. Current week is 44 as of now.

Is there any way to speed up the fuzzy string match using fuzzywuzzy in pandas.

I have a dataframe as extra_names which has names that I want to run fuzzy matches for with another dataframe as names_df.

I am currently updating a database that I created for work to classify transactions into a transaction type. This requires me to use an iif() statement that has become too complex to run. Before we get too far along, I want to apologize for the lengthy description, but I want to make sure I provide enough information.

Transactions (RefID's) can be one of the following:

• 3PL
• 4PL
• Air Freight
• Customs Only

One of the complexities of this task involves the fact that a Charge Code ("CC"), similar to an item number or service name, can be 3PL or 4PL depending on the circumstances of the transaction. For example, if the CC of Ocean_Freight exists on a RefID that also has a CC of PO_Management, the transaction is a 3PL transaction. However, if the CC of PO_Management exists without Ocean_Freight on the RefID, this would be a 4PL Transaction.

I have the following CC's which can be used to define a transaction:

3PL Only

• Ocean_Freight
  • this CC will define the transaction unless there is a CC from the "3PL or 4PL Depending on Situation" section below
• Drayage Management
  • this CC will define the transaction unless there is a CC from the "3PL or 4PL Depending on Situation" section below

Air Freight Only

• Air_Freight

3PL or 4PL Depending on Situation

• PO_Management
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without the aforementioned CC's

• CROM Fee

  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, or PO_Management

• EDI

  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, or PO_Management
• Booking Management Fee
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, PO_Management, or EDI
• Forwarding Fee
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, PO_Management, EDI, or Booking Management Fee
• Handling Charge
  • 3PL when CC exists on a RefID with Ocean_Freight or Drayage Management
  • 4PL when CC exists on a RefID without Ocean_Freight, Drayage Management, PO_Management, EDI, Booking Management Fee, or Forwarding Fee

Customs Only

As a note - each of the preceding CC's can be considered what I classify as a Transaction Defining Charge Code (TDCC), in the absence of one of these CC's and the presence of the Customs Entry CC, the transaction is defined as a "Customs Only" transaction.

https://imgur.com/e57buni

I previously accomplished this within Access using a nested iif() statement, but in some cases I was pulling duplicate records because I wasn't isolating each of the CC's. For example, if PO_Management and Handling Charge existed on the same transaction, both would get ascribed a value of "4PL", when in reality, I only want one to define the transaction. This is what sent me down this path of repairing the code.

The query that drives most of this is called "Step 2)" and it does a sum(iif(criteria here),1,0) based on whether or not a CC exists on a RefID. It provides a value of >0 if a CC exists on a RefID which allows me to reference this query to determine how I should define a RefID.

To further refine my original methodology, I made another query called "Steps." Within this query is where I apply the logic from above within the CC descriptions section above.

I have tried using a nested iif() statement and also tried using the Switch() function, but both get to the same point, "The expression you entered is too complex." I have done some research and I believe the answer is a Private Function using VBA, but I have had no luck understanding how to create the functions. Does anyone have a better way of attacking this problem? Please find a sample of my latest attempt at a switch() function which kicks out the error below:

I have made a script with multiple select options, when you select an option new options will be visible. see fiddle!!

EX: if i select "Canapele" and then i select "Canapea Dana" other options will appear. but if i select from first row (where i selected "Canapele") "Mobila" the options from "Canapea Dana" should be hidden.

i insert a button with "Reset" function but the other options still visible.

Any ideea how can i fix it?

See fiddle here =>

https://jsfiddle.net/9d8qja4w/4/

HTML

i have a large unordered list that needs to be displayed in 2 columns. i tried to make it with floats but i loose to mutch space because of the different heights of the items

then i tried the pure css masonry layout

Html

I try to import data from specific MS-Excel data cells (A2, B2, C2) into a MS-Access Table. It does work with the following Code:

I am using ORACLE APEX 5.0.1

I am passing an url string to an APEX application where I have encoded all special caracters, if there is one or more %3A (colon) in the url APEX seemes to truncate the value I am passing. This affects only the last variable I am passing and only the remaining part after the last %3A, but if I place a %3A at the very end of the url it works in APEX. I have asked about this in other forums and it seems to be a relative unknown issue in APEX, haven't got any relevant answer that explains the issue.

This example pass values to tre fields