Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Swi
  • Order by date
  1. Swi

    API - multipart/form-data

    Thanks strongm. Appreciate it. I did get it working but with something I had paid for a few years back. https://www.example-code.com/vb6/rest_form_data_upload.asp Thanks. Swi
  2. Swi

    API - multipart/form-data

    I found this online but still no luck. BAsically it return a 200 success but if I check the responsetext it is not a response but the whole webpage of the API. Any ideas? Sub UploadFile() Dim url As String Dim filePath As String Dim fileContent As String Dim boundary As...
  3. Swi

    API - multipart/form-data

    Hi, I have the following curl but I've never posted a CSV file to a REST API this way. I am stuck on the part shown below. Any ideas? curl --request POST "https:/xxxxxxxx.com/api/reports/upload" --header "Authorization: Bearer {YOUR_AUTH_KEY}" --header "Content-Type...
  4. Swi

    Rotate every 6th page in a PDF

    Hi, I do have the full version of Acrobat but has anyone ever rotated the nth page in a PDF document programatically? Thanks. Swi
  5. Swi

    12 Month Rolling Average

    Thank you for your help. Swi
  6. Swi

    12 Month Rolling Average

    Hi, It would be based on the previous 12 months but this inventory has only been received since November of last year. I mentioned 3 in this case which I could see would cause confusion. Thanks for your patience. Swi
  7. Swi

    12 Month Rolling Average

    Yes, I understand your frustration however a sick child took the priority. I apologize for the wait. This is the end result. Part Number Total Usage Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Average Monthly Usage TEST1 1831 0 0 0 0 0 0 0 0 0 0 497 1334 916 This is the data...
  8. Swi

    12 Month Rolling Average

    Apologies, I did leave out the SKU part. You are correct. This would need to be done by SKU. Let me post back tomorrow when I am near a laptop as opposed to my phone. Thanks. Swi
  9. Swi

    12 Month Rolling Average

    Correct, I would want the average usage across 12 month prior to the current date. Meaning. 11/3/23 - 10 11/20/23 - 20 12/1/23 - 10 12/15/23 - 40 1/15/24 - 50 So 11/23 = 30 total 12/23 = 50 total 1/24 = 50 total I would want the average of these three months (in the real scenario I would look...
  10. Swi

    PDF Interrogation

    Hi, Does anyone know of any code base that would allow me to interrogate a PDFs size, spot colors, etc... after a user uploads a file? Thanks. Swi
  11. Swi

    12 Month Rolling Average

    Hi Andrzejeck, Is this calculating the average by day? Thanks. Swi
  12. Swi

    12 Month Rolling Average

    I have a Access database that has a shipment_date, SKU and plannedQty field. I would like to do a 12 month rolling average of how much is being used of each SKU. What is the best way to accomplish this? thanks. Swi
  13. Swi

    REST API - Shopify

    BTW, strongm had most if not all of this code previously in the post. Basically my version filters the results down a bit and has a bit of error handling. Just wanted to give credit where credit was due. Thanks. Swi
  14. Swi

    REST API - Shopify

    Here you go. This pulls all orders in a JSON format that you will then need to parse. This will pull all orders for the current day that have a status of open, unfulfilled and are paid. I hope this helps. Thanks. ' Build API call based on criteria and the current date APICall =...
  15. Swi

    REST API - Shopify

    Sorry, just saw this. When I am near a PC I will paste the code here probably tomorrow. Thanks. Swi
  16. Swi

    FedEx REST API

    I got this squared away. Thanks. Swi
  17. Swi

    FedEx REST API

    Has anyone used VB6 and FedEx's REST API to look up a package by the tracking number? If so,can you provide an example? Swi
  18. Swi

    Read Excel Sharepoint File

    Hi, Does anyone have any experience reading an Excel file on Sharepoint? Thanks. Swi
  19. Swi

    Jet Sql Statement - Select Distinct Multiple Columns

    Hi, Correct, my OrderID is NOT unique. Is there a more optimized way to do the query I posted or would you think this is a good approach? Thanks. Swi

Part and Inventory Search

Back
Top