estoque | Este projeto faz parte das aulas : Laravel de começo ao fim

I'm creating a Database from excel files scraped from the web, the problem is that the source lacks a pattern, the name of the columns vary a lot and sometimes it exceeds the 64 characters limitation from MySQL. My solution by now is running the script and replace each word I find to a reduced version. The problem is that there is too much data and the replace library is getting huge.

Here's an example of one table being created after replaces:

hope you all having a great day. I need some help with this query. Just to explain the situation, I have to send e-mails containing the data found in this select, but I have to group by customers (TBLOTE.CEMPRES) so it would build a single e-mail for each customer found. Example, if the query finds 3+ row for customer ´John Inc.´ and 1 row for ´Jack Corp.´, it should send 2 e-mails, one containing the 3+ rows about John Inc, and the other one containing the 1 row found for Jack Corp. I hope I could be clear enough on my explanation.

I need some help with this procedure. I need to include in a single e-mail the whole result of the select on the first Cursor (C1). The way the procedure is working now, it sends an e-mail for each row found. The result is, if the cursor finds 100 rows, 100 e-mails will be sent, and I don't want that to happen, I need the 100 rows in a single e-mail, following the "V_MENSAGEM" structure.

I am trying to do a simple WebScrapper to monitor Nike's site here in Brazil. Basically i want to track products that have stock right now, to check when new products are added.

My problem is that when i navigate to the site https://www.nike.com.br/snkrs#estoque I see different products compared to what I see using python requests method.

Here is the code I am using:

I've been trying to modify an item related value using a store's API and although it returns success, the raw object is not bring the values correctly and I can't find out why.

The Script Editor logs show: Raw data: {"tipo":3,"quantidade":10} ...which is correct.

The response I get is: "code":"010","message":"success","responseCode":200,

The destination log shows: {"erp_id":"","peso":"","gtin":"","ativo":"","tipo":"","quantidade":"", ...where tipo and quantidade are empty - thus, incorrect.

Here's the piece of code I'm working on:

It seems to be fairly simple but I'm struggling...
I have this simple code to select entire row from a black range of cells, which is totally random, base on the current data.
Because the cells F5 F7 F9 F13 are empty, it selects the entire row.
So, I wish to change the value from column 1 [A] and 8 [H] to "Estoque", coloured in light blue.
And I'm stuck on that. Any help, please?

I'm having trouble with Django queryset. First of all, what I want to do is to receive from the customer which discount coupons (dc for short) he/she used and then compare with the ones already in the system. And I did manage to do it with 1

my view:

I'm new to Django and need some help here, I want to make a page where sellers can sell your items with coupons code and customers can get these coupons. A little mix with JS and I hid the coupon, you have to "purchase" the item, so you can have it. I have 3 tables, "Produto" (Product), "Pedido" (Order) and "Cliente" (Client) and when the custumer try to "purchase" the item, it's only appearing his/her name ! Can someone help me please ?

My view.py

I'm new to DAX. Looking for your expertise. Looked all over the web but couldn't find a proper solution.

I have a matrix that shows several factories and it's inventories, the rows being factory and SKU. I've created a measure that's the difference between two other measures. The overall idea is: I have a inventory quantity and an orders volume. I defined a "balance" measure that's inventory - sales. That is, what is still left for sale.

Normally it works fine, but when I have a negative value in balance, things get messed up. The subtotal in the factory row sums all the numbers, including negatives, giving me a balance subtotal that is smaller than it's supposed to be. I can't count the negatives. So I've tried to solve this by defining the measure as