Lukket

Import from Ordermentum to Excel (Pablo)

Macro: ORDERMENTUM_IMPORT

Purpose: To open a file exported from the ordering website and populate the the excel order spreadsheet with quantities matched to the product codes for matching customers.

Pre-processing: Prior to populating the spreadsheet, a number of checks should be performed on the exported data. Any negative results of the checks should be communicated back to the user via a dialog box.

Check 1: Check for Consistent delivery dates - All delivery dates should be for the same date and that date should be the date that is named in the worksheet title. If a negative result is found, the import operation should cease. The dialog box is to have the working "One or more delivery dates in the exported file do not match this worksheet. Please check the exported data."

Check 2: Check for duplicates. If there are two instances of the same customer with the exact same order, the operation should be paused. The dialog box should bring this occurrence to the attention of the user with two options Continue or Cancel.

Passing the above two checks, the import process can begin.

If a filter is applied to the worksheet of interest (or Master worksheet) the filters should be removed.

Consideration should be given to speed of the process. As with previous macros, it may be more expedient to separate the worksheet into its own workbook before populating.

Process Checks:

Whilst processing the data during the populating stage, the following checks should be carried out -

Check 1: The "State" field should be checked (column D). If the state says "Cancelled", the data should not be imported. Any customers with Cancelled orders should be shown in the dialog box at the end of the import.

Check 2: New Items - If an item exists in the import data that is not in the spreadsheet, the item code and description should be added to the appropriate section of the worksheet. The populated cell for that item should be highlighted in red. The item should also be added to the Master worksheet. It is important that the totaling formulas a tops of the columns are not broken with the addition of new rows. Consideration should be give to the case where the item code has a supplier prefix that is not yet present in the worksheet or master. This has caused a fail in the past. One way to handle would be to not import the item and show the details of item and customer in the dialog box at the end of the process.

Check 3: New Customers - If a customer in the import data is not yet defined in CUST and Shortname worksheets, it should simply be added to a new column and highlighted in red. Details should show in the dialog box at the end of the process.

Successful Import: At the end of the import, if nothing else to show in the dialog box, it should show the message "Import Completed Successfully".

Amendment1: New customer - The new columns should be placed at the end prior to the BLANK column. The cell should not be highlighted in red but rather the same blue as the other column headers so it can be cleared and repopulated without accidentally doubling the data

Amendment 2: When importing data into a cell, if the cell already contains data it should be cleared of it. However, if a data file contains two orders for the same item placed by the same customer e.g. a customer orders 1 loaf of bread and then realises they need 2 more so the place another order.. the populated cell should contain the sum of those items from the file.

Evner: Databehandling, Excel, PHP, Software Arkitektur, Visual Basic

Se mere: ordermentum api, ordermentum review, excel 2000 macro web, convert excel 2000 macro excel 2007 macro, excel project macro, import mpp data excel using macro, import msproject excel macro, macro import word excel, macro import project excel, import word excel macro, import multiple csv files excel folder macro, macro import data excel, excel 2007 macro convert csv xml data import, import excel quickbooks macro, macro import quickbooks excel, import cvs excel macro, macro import csv excel table

Om arbejdsgiveren:
( 2 bedømmelser ) ERMINGTON, Australia

Projekt ID: #17214501

22 freelancere byder i gennemsnit $50 på dette job

schoudhary1553

Hello, I can help with you in your project Import from Ordermentum to Excel (Pablo). I have more than 5 years of experience in Data Processing, Excel, PHP, Software Architecture, Visual Basic. We have worked on seve Flere

$250 AUD på 1 dag
(273 bedømmelser)
7.6
katilinas

Hello, I'm ready to work on "import from ordermentum to excel (pablo)" project. I have 5 years experience in Visual Basic, Excel. 28 AUD - proposed project budget, including coding and clean modern UI design. Messag Flere

$28 AUD på 1 dag
(118 bedømmelser)
6.4
$133 AUD på 1 dag
(25 bedømmelser)
5.3
sourabhg98

Hello! This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at [login to view URL] (username - sourabhg98) with over 400 questions answered and 1100 rep Flere

$30 AUD på 1 dag
(50 bedømmelser)
4.7
$30 AUD in 3 dage
(24 bedømmelser)
4.9
rgarcia3934

hello, Can you show sample files? exported file, populated file, any other revelant file I like to know the data structure, involved workbooks and its worksheets and columns. thanks, Ronald

$100 AUD in 7 dage
(14 bedømmelser)
4.4
cranius

Greetings, You project caught my attention because I have several experience in data importing and management using Excel. As reference, check this demonstration of a recent project where a client wanted to import Flere

$24 AUD in 2 dage
(2 bedømmelser)
3.0
$25 AUD på 1 dag
(2 bedømmelser)
2.2
mzubirshahid

best of luck..................................................................................................................................................

$35 AUD in 2 dage
(0 bedømmelser)
0.0
ranek088

Respected Sir/Madam, I can do it very efficiently and taking care of it's purity prior to Web and Data scraping task. I work on projects as career more than a job. It's an opportunity for us to positively impact real Flere

$12 AUD in 2 dage
(0 bedømmelser)
0.0
mohammed96tarek

hello sir my name is mohamed i have experience in microsoft excel so you you will get your work quickly You will not pay anything without being satisfied from my work

$25 AUD på 1 dag
(0 bedømmelser)
0.0
$100 AUD på 1 dag
(0 bedømmelser)
0.0
$25 AUD på 1 dag
(0 bedømmelser)
0.0
Madushi911130

I would like to go with your project and pls let me know if you are interested with my bid.

$35 AUD in 2 dage
(0 bedømmelser)
0.0
$30 AUD in 5 dage
(0 bedømmelser)
0.0
$25 AUD in 3 dage
(0 bedømmelser)
0.0
$25 AUD in 2 dage
(0 bedømmelser)
0.0
dipam222

I am deep

$25 AUD på 1 dag
(0 bedømmelser)
0.0
$20 AUD in 2 dage
(0 bedømmelser)
0.0
qadrisaad03

opening receiving total CT SDK CT RYK defect store total sdk sale ryk sale sdk ryk us 1250 27 80 107 133750 us 1250 40 43 83 103750 0 0 40 43 us 1250 US 1350 127 252 379 511650 US 1350 87 89 50 226 3051 Flere

$20 AUD på 1 dag
(0 bedømmelser)
0.0