Log In

Your email is not your username

Register

If you were a member of the old Bodybuilding.com forums and would like to reuse your previous username, you can request it below. We use your email only for registration and do not store it. For more information, please see our Privacy Policy.

Confirm your email

A registration code was sent to your email. Enter it here.

Welcome

You have successfully setup your account.

Sign in

Quick Navigation Bottom Misc
Forum » IT brahs need help will rep
  1. Results 1 to 6 of 6
  2. Page 1 of 1

Thread: IT brahs need help will rep

post 1656255383 02-15-2022, 04:28 PM
-
#1
  1. Vbrah
  2. Not Banned
  1. Vbrah
  2. Not Banned
  3. Join Date: Jul 2011
  4. Location: California, United States
  5. Posts: 8,770
  6. Rep Power: 29731

IT brahs need help will rep

So I have a client that has an list in Excel with about 500k rows. In each row is an invoice number. They need to copy and paste that invoice number into their database and search the invoice, then print out the invoice in PDF, then name the invoice with the invoice number, client name and client address (all found in the PDF on the same lines), then save the named invoice into a folder. Can something like this be automated? And if so how would I go about in looking for someone that could automate this and how much would something like this cost?
Make Misc Great Again

Not in any crew crew
post 1656255863 02-15-2022, 04:35 PM
-
#2
  1. Vbrah
  2. Not Banned
  1. Vbrah
  2. Not Banned
  3. Join Date: Jul 2011
  4. Location: California, United States
  5. Posts: 8,770
  6. Rep Power: 29731
Cmon misc
Make Misc Great Again

Not in any crew crew
post 1656255923 02-15-2022, 04:36 PM
-
#3
  1. AlexxVann
  2. Registered User
  1. AlexxVann
  2. Registered User
  3. Join Date: Jan 2013
  4. Posts: 10,033
  5. Rep Power: 42064
Are they using a software database?

Excel is pretty good using you can usually merge specific cells into specific parts of a form. Which would automate it.
post 1656256103 02-15-2022, 04:38 PM
-
#4
  1. Vbrah
  2. Not Banned
  1. Vbrah
  2. Not Banned
  3. Join Date: Jul 2011
  4. Location: California, United States
  5. Posts: 8,770
  6. Rep Power: 29731
Originally Posted By AlexxVann⏩
Are they using a software database?

Excel is pretty good using you can usually merge specific cells into specific parts of a form. Which would automate it.
Yes they’re using some sort of weird no name database but they’re looking to switch and the software provider is being difficult which is why they want to back up all of their invoices
Make Misc Great Again

Not in any crew crew
post 1656256133 02-15-2022, 04:40 PM
-
#5
  1. Dogkrack
  2. Banned
  1. Dogkrack
  2. Banned
  3. Join Date: Jun 2019
  4. Posts: 14,820
  5. Rep Power: 0
more than you can afford pal.

just load the xls into a database and do it that way. fuk OLE
post 1656256293 02-15-2022, 04:42 PM
-
#6
  1. sooby
  2. WOATbrah of peace :)
  1. sooby
  2. WOATbrah of peace :)
  3. Join Date: Feb 2015
  4. Location: Toronto, Ontario, Canada
  5. Posts: 43,319
  6. Rep Power: 219409
you could probably use Power BI/Power Query or some sort of related database system to organize the info in a way that you like. Will probably take a few videos and some practice for you to learn tho.
positivity brah crew
dont take my posts too srs crew srs
JFL @ everything crew
lol @ tradies srs crew
BIG LOL @ sky tradies srs crew (RealAesthetic)
indian crew
living in clown world crew so screw it crew
anti-degen crew
Quick Navigation Top Misc
Bookmarks
Digg.com
Digg
del.icio.us
del.icio.us
Stumbleupon.com
StumbleUpon
Google.com
Google
Facebook.com
Facebook
Posting Permissions
  1. You may not post new threads
  2. You may not post replies
  3. You may not post attachments
  4. You may not edit your posts