Vision Global

Customizations:

Imports:
Vision Global has two imports they will request, they will send you files for both imports.
Data Dump import and Ticket Sales import.

Ticket Sales Import:
The ticket sales import will require you to save the files to the .33 server in "c$\temp" folder you will rename the files to "TicketSales_JAN 23" and "eventDetail_JAN 23" OR the specified month for example "eventDetail_FEB 23" --MAKE SURE THE MONTH IS 3 CHARACTERS AND NOT LONGER--
Proceed to the .35, pull files you saved from .33 to .35
Once you have pulled the files from .35 head to C:\Inetpub\wwwroot\Prodigix Services\Ticket Import\Upload, and place both files in at the same time.
The files will be moved and processed at the same time, you will then run the script's below to make sure the data was imported correct on the SQL server, 173. VisionGLobal_Live, once you have ran the scripts the import will be successful.
    Script: TicketSalesScript

Data Dump Import:
The Data dump import will be completed on .33 and .173 by saving the files to both servers.
Once the files are saved rename them to Distributors.csv and Orders.csv.
Once saved you will open the file distributors.csv, the third row is missing the last date column and you will need to add a date to process the file successfully. You can use any date but it is recommended to use the date of the distributor above it.
Once you have updated the date you will need to find any Distributor ID that was converted to Scientific Notation and remove the line.(Search for a e+, there will be emails with this but you only need to find the distributor ID column.)
Place in files\import\commission\distributors, the paths are a little different between both the .33 and .173 server.
You will then run the Distributor script first and the Order Script second on .33 and .173 using Power Shell ISE, once you have run the scripts then have completed the Data Dump Import.
    Script: DataDumpScript