Search Results
|
Post |
Author |
Forum |
Replies |
Views |
Posted
[asc]
|
|
|
Thread: Is it possible to extract 1 or 2 bits of data from MS project files?
Post: RE: Is it possible to extract 1 or 2 bits of data ...
The following works and returns the information i am looking for
import win32com.client
from datetime import datetime
from dateutil.relativedelta import relativedelta, SA
def get_saturday_of_curre... |
|
cubangt |
General Coding Help |
8 |
1,144 |
Feb-15-2024, 10:43 PM |
|
|
Thread: Is it possible to extract 1 or 2 bits of data from MS project files?
Post: RE: Is it possible to extract 1 or 2 bits of data ...
Disregard the above, that is correct, i added the full path and it started looping thru tasks.. but would thru an error occasionally with each task, so the loop would return a task, error, then next t... |
|
cubangt |
General Coding Help |
8 |
1,144 |
Feb-15-2024, 09:46 PM |
|
|
Thread: Is it possible to extract 1 or 2 bits of data from MS project files?
Post: RE: Is it possible to extract 1 or 2 bits of data ...
So are you saying that instead of this:
project_file_path = 'GreenwoodIN.mpp'Do this?
project_file_path = 'c:/GreenwoodIN.mpp' |
|
cubangt |
General Coding Help |
8 |
1,144 |
Feb-15-2024, 09:40 PM |
|
|
Thread: Is it possible to extract 1 or 2 bits of data from MS project files?
Post: RE: Is it possible to extract 1 or 2 bits of data ...
So i tried this example to open and return tasks, but get an error that it cannot open the file, the file and script are in the same directory for this test.
import win32com.client
def list_task_att... |
|
cubangt |
General Coding Help |
8 |
1,144 |
Feb-15-2024, 09:22 PM |
|
|
Thread: Script getting reindexing only valid error
Post: RE: Script getting reindexing only valid error
Disregard the above error.. it was an oversight on my end, the script is looking for a specific file name to process, and because i only renamed the orginal file and left it in the folder, when it wou... |
|
cubangt |
General Coding Help |
1 |
1,089 |
Dec-07-2023, 04:06 PM |
|
|
Thread: Script getting reindexing only valid error
Post: Script getting reindexing only valid error
So this script has been running perfecting fine for well over a month if not longer, script has not been modified or changed in anyway. The script does read from a text file to build a dataframe using... |
|
cubangt |
General Coding Help |
1 |
1,089 |
Dec-07-2023, 02:23 PM |
|
|
Thread: Logic suggestions for comparing 2 csv's
Post: RE: Logic suggestions for comparing 2 csv's
The field is free form and up to the support analyst to enter the key information when they take the calls from the stores, so thats the reason why its not very clean.. and the only column where we wo... |
|
cubangt |
General Coding Help |
7 |
1,236 |
Nov-09-2023, 09:54 PM |
|
|
Thread: Logic suggestions for comparing 2 csv's
Post: RE: Logic suggestions for comparing 2 csv's
OK here is my best sample data i can provide to help illustrate better what im trying to accomplish..
My current script pings a long list of IP addresses for our stores.. the results from those ping... |
|
cubangt |
General Coding Help |
7 |
1,236 |
Nov-09-2023, 09:14 PM |
|
|
Thread: Logic suggestions for comparing 2 csv's
Post: RE: Logic suggestions for comparing 2 csv's
Not making a file, just need to filter the ping results against our ticket system data and return ticket counts and ticket numbers by store.. No additional file is needed or being created, just need t... |
|
cubangt |
General Coding Help |
7 |
1,236 |
Nov-08-2023, 08:20 PM |
|
|
Thread: Logic suggestions for comparing 2 csv's
Post: Logic suggestions for comparing 2 csv's
So im not looking for functional code, i want to keep learning and just need suggestions or pointers on what to look at in order to accomplish the following:
I have a CSV file with (IP, Store, Regist... |
|
cubangt |
General Coding Help |
7 |
1,236 |
Nov-08-2023, 02:41 PM |
|
|
Thread: Updating sharepoint excel file odd results
Post: Updating sharepoint excel file odd results
So we display a excel file on our tv's in the office that has a embedded image on the sheet. I have a python script that updates that image daily. When this was implemented earlier this year, it worke... |
|
cubangt |
General Coding Help |
1 |
919 |
Nov-01-2023, 06:53 PM |
|
|
Thread: how to save to multiple locations during save
Post: how to save to multiple locations during save
I have a script with currently outputs a csv for a report.. But now multiple departments want access to the raw data.
I currently have this to_csv line in my script, but would like to be able to save... |
|
cubangt |
General Coding Help |
1 |
595 |
Oct-23-2023, 09:24 PM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: RE: Filter data into new dataframe as main datafra...
Here is my test script updated and working as expected. Just need to replace the "statusResults" dataframe with the dynamically generated one in the main script, but i feel good about this working in ... |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-23-2023, 12:43 AM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: RE: Filter data into new dataframe as main datafra...
Disregard my above question, i was overthinking it and figured out it will work as provided. thank you again..
Trying to incorporate into my script now, to see what i can complete this weekend. |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-22-2023, 09:23 PM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: RE: Filter data into new dataframe as main datafra...
I want to better understand the example you provided.. without providing more examples.. Why am i not able to get the calculations of the registers that are up? What portion of the logic should i focu... |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-22-2023, 08:53 PM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: RE: Filter data into new dataframe as main datafra...
Id like a dataframe with this information
Output:Store Down Up Grand Total Percentage
7 1 7 8 13%
9 1 10 11 9%
10 0 11 11 0%
12 2 11 13 15% |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-22-2023, 05:48 AM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: RE: Filter data into new dataframe as main datafra...
What im trying to accomplish is to get a few calculation values returned to me.
I need to get a count of registers down by store and if the "%" is greater than "x%" then save that off into a new df
... |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-22-2023, 04:25 AM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: RE: Filter data into new dataframe as main datafra...
These are just the tests i have been playing around with to get familiar with the methods of getting the data and calculations.
This is not in a script, just the things i have been trying so i can tr... |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-22-2023, 04:08 AM |
|
|
Thread: Filter data into new dataframe as main dataframe is being populated
Post: Filter data into new dataframe as main dataframe i...
Is this possible, i am populating a dataframe with a few fields and thousands of rows that will be saved into a CSV. For a separate reason, i need certain records to be inserted into a different dataf... |
|
cubangt |
General Coding Help |
8 |
1,058 |
Oct-21-2023, 11:31 PM |
|
|
Thread: Need to return 2 values from 1 DF that equals another DF
Post: RE: Need to return 2 values from 1 DF that equals ...
Figured it out and seems to be working..
import os
import sys
import time
from datetime import datetime
import subprocess
from concurrent.futures import ThreadPoolExecutor
import pandas as pd
import ... |
|
cubangt |
General Coding Help |
5 |
678 |
Oct-21-2023, 06:06 AM |