CSV Upload - Revision history

Anw: Text replacement - "1000px" to "900px"

2020-03-04T11:29:08Z

Text replacement - "1000px" to "900px"

Anw: Minor correction

2019-01-23T14:28:53Z

Minor correction

← Older revision		Revision as of 16:28, 23 January 2019
Line 447:		Line 447:
	<noinclude>		<noinclude>
	== Example Files ==		== Example Files ==
			The following list links to the example files used in this user guide.
	* [[file:example1.csv]]		* [[file:example1.csv]]
	* [[file:example2.csv]]		* [[file:example2.csv]]

Anw: Minor formatting changes

2019-01-23T13:57:05Z

Minor formatting changes

← Older revision		Revision as of 15:57, 23 January 2019
Line 445:		Line 445:
	The value 'Order Provided' will cause the jobs to be added in the sequence they are included in the file.		The value 'Order Provided' will cause the jobs to be added in the sequence they are included in the file.

			<noinclude>
	== Example Files ==		== Example Files ==
	* [[file:example1.csv]]		* [[file:example1.csv]]
Line 455:		Line 456:
	* [[file:example8.csv]]		* [[file:example8.csv]]
	* [[file:example9.csv]]		* [[file:example9.csv]]
			</noinclude>

Anw: Updating CSV Upload Example images

2019-01-23T13:48:51Z

Updating CSV Upload Example images

Show changes

Anw: Minor formatting changes

2019-01-23T12:16:34Z

Minor formatting changes

← Older revision		Revision as of 14:16, 23 January 2019
Line 238:		Line 238:
	<code>		<code>
	,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD1,PRODDESC1,LONGDESC1,1,TEST,TEST,,		,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD1,PRODDESC1,LONGDESC1,1,TEST,TEST,,
			</code>

			<code>
	,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD2,PRODDESC2,LONGDESC2,2,TEST,TEST,,		,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD2,PRODDESC2,LONGDESC2,2,TEST,TEST,,
	</code>		</code>
Line 308:		Line 310:
	<code>		<code>
	,,,,User1,JOBCODE7,CR7,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C7,,,,,TEST,TEST,,		,,,,User1,JOBCODE7,CR7,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C7,,,,,TEST,TEST,,
			</code>

			<code>
	,,,,User2,JOBCODE8,CR8,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C8,,,,,TEST,TEST,,		,,,,User2,JOBCODE8,CR8,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C8,,,,,TEST,TEST,,
	</code>		</code>
Line 367:		Line 371:
	<code>		<code>
	,,,,User1,JOBCODE9,CR9,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C9,,,,,TEST,TEST,Load1,		,,,,User1,JOBCODE9,CR9,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C9,,,,,TEST,TEST,Load1,
			</code>

			<code>
	,,,,User1,JOBCODE10,CR10,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C10,,,,,TEST,TEST,Load1,		,,,,User1,JOBCODE10,CR10,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C10,,,,,TEST,TEST,Load1,
			</code>

			<code>
	,,,,User1,JOBCODE11,CR11,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C11,,,,,TEST,TEST,Load1,		,,,,User1,JOBCODE11,CR11,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C11,,,,,TEST,TEST,Load1,
	</code>		</code>

Anw: Minor formatting changes

2019-01-23T12:14:28Z

Minor formatting changes

@@ Line 193: / Line 193: @@
 An extra line can be included at the front of the file to include Header Text for each column. This makes it much easier to create records within Excel or another spreadsheet tool. For this example (example3.csv) we will create a new upload file with a header row and two new job codes:
-<code>EPL_LOAD_START_PLANNED_DATE,EPL_LOAD_START_PLANNED_TIME,EPL_LOAD_END_PLANNED_DATE,
+<code>EPL_LOAD_START_PLANNED_DATE, EPL_LOAD_START_PLANNED_TIME, EPL_LOAD_END_PLANNED_DATE, EPL_LOAD_END_PLANNED_TIME,  EPL_USER_ID, EPL_JOB_CODE, EPL_CUST_REF, EPL_JOB_TYPE, EPL_JOB_INSTRUCTION, EPL_START_PLANNED_DATE, EPL_START_PLANNED_TIME,  EPL_END_PLANNED_DATE, EPL_END_PLANNED_TIME, EPL_CUSTOMER_NAME, EPL_ADDRESS_1, EPL_ADDRESS_2, EPL_ADDRESS_3, EPL_ADDRESS_4, EPL_ADDRESS_5, EPL_POSTCODE, EPL_CONTACT, EPL_TELEPHONE, EPL_EMAIL, EPL_CONTAINER_ID, EPL_PRODUCT, EPL_DESCRIPTION,  EPL_DESCRIPTION_LONG, EPL_PLANNED_QTY, EPL_SITE_ID, EPL_JOB_GROUP, EPL_LOAD_ID, EPL_CUST_CODE
 </code>

Anw: Minor formatting changes

2019-01-23T12:12:18Z

Minor formatting changes

← Older revision		Revision as of 14:12, 23 January 2019
Line 193:		Line 193:
	An extra line can be included at the front of the file to include Header Text for each column. This makes it much easier to create records within Excel or another spreadsheet tool. For this example (example3.csv) we will create a new upload file with a header row and two new job codes:		An extra line can be included at the front of the file to include Header Text for each column. This makes it much easier to create records within Excel or another spreadsheet tool. For this example (example3.csv) we will create a new upload file with a header row and two new job codes:

	<code>EPL_LOAD_START_PLANNED_DATE,EPL_LOAD_START_PLANNED_TIME,EPL_LOAD_END_PLANNED_DATE,~~EPL_LOAD_END_PLANNED_TIME,~~		<code>EPL_LOAD_START_PLANNED_DATE,EPL_LOAD_START_PLANNED_TIME,EPL_LOAD_END_PLANNED_DATE,
	EPL_USER_ID,EPL_JOB_CODE,EPL_CUST_REF,EPL_JOB_TYPE,EPL_JOB_INSTRUCTION,EPL_START_PLANNED_DATE,EPL_START_PLANNED_TIME, EPL_END_PLANNED_DATE,EPL_END_PLANNED_TIME,EPL_CUSTOMER_NAME,EPL_ADDRESS_1,EPL_ADDRESS_2,EPL_ADDRESS_3,EPL_ADDRESS_4, EPL_ADDRESS_5,EPL_POSTCODE,EPL_CONTACT,EPL_TELEPHONE,EPL_EMAIL,EPL_CONTAINER_ID,EPL_PRODUCT,EPL_DESCRIPTION, EPL_DESCRIPTION_LONG,EPL_PLANNED_QTY,EPL_SITE_ID, EPL_JOB_GROUP,EPL_LOAD_ID, EPL_CUST_CODE

			EPL_LOAD_END_PLANNED_TIME,EPL_USER_ID,EPL_JOB_CODE,EPL_CUST_REF,EPL_JOB_TYPE,

			EPL_JOB_INSTRUCTION,EPL_START_PLANNED_DATE,EPL_START_PLANNED_TIME,

			EPL_END_PLANNED_DATE,EPL_END_PLANNED_TIME,EPL_CUSTOMER_NAME,EPL_ADDRESS_1,EPL_ADDRESS_2,

			EPL_ADDRESS_3,EPL_ADDRESS_4, PL_ADDRESS_5,EPL_POSTCODE,EPL_CONTACT,EPL_TELEPHONE,EPL_EMAIL,

			EPL_CONTAINER_ID,EPL_PRODUCT,EPL_DESCRIPTION, EPL_DESCRIPTION_LONG,EPL_PLANNED_QTY,

			EPL_SITE_ID, EPL_JOB_GROUP,EPL_LOAD_ID, EPL_CUST_CODE
			</code>

			<code>
	,,,,,JOBCODE3,CR3,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C3,,,,,TEST,TEST,,		,,,,,JOBCODE3,CR3,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C3,,,,,TEST,TEST,,
			</code>

			<code>
	,,,,,JOBCODE4,CR4,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C4,,,,,TEST,TEST,,		,,,,,JOBCODE4,CR4,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C4,,,,,TEST,TEST,,
	</code>		</code>

Anw: Formatted examples properly; added examples files

2019-01-23T12:08:26Z

Formatted examples properly; added examples files

← Older revision		Revision as of 14:08, 23 January 2019
Line 193:		Line 193:
	An extra line can be included at the front of the file to include Header Text for each column. This makes it much easier to create records within Excel or another spreadsheet tool. For this example (example3.csv) we will create a new upload file with a header row and two new job codes:		An extra line can be included at the front of the file to include Header Text for each column. This makes it much easier to create records within Excel or another spreadsheet tool. For this example (example3.csv) we will create a new upload file with a header row and two new job codes:

	<code>EPL_LOAD_START_PLANNED_DATE,EPL_LOAD_START_PLANNED_TIME,EPL_LOAD_END_PLANNED_DATE,EPL_LOAD_END_PLANNED_TIME, EPL_USER_ID,EPL_JOB_CODE,EPL_CUST_REF,EPL_JOB_TYPE,EPL_JOB_INSTRUCTION,EPL_START_PLANNED_DATE,EPL_START_PLANNED_TIME, EPL_END_PLANNED_DATE,EPL_END_PLANNED_TIME,EPL_CUSTOMER_NAME,EPL_ADDRESS_1,EPL_ADDRESS_2,EPL_ADDRESS_3,EPL_ADDRESS_4, EPL_ADDRESS_5,EPL_POSTCODE,EPL_CONTACT,EPL_TELEPHONE,EPL_EMAIL,EPL_CONTAINER_ID,EPL_PRODUCT,EPL_DESCRIPTION, EPL_DESCRIPTION_LONG,EPL_PLANNED_QTY,EPL_SITE_ID, EPL_JOB_GROUP,EPL_LOAD_ID, EPL_CUST_CODE		<code>EPL_LOAD_START_PLANNED_DATE,EPL_LOAD_START_PLANNED_TIME,EPL_LOAD_END_PLANNED_DATE,EPL_LOAD_END_PLANNED_TIME,
			EPL_USER_ID,EPL_JOB_CODE,EPL_CUST_REF,EPL_JOB_TYPE,EPL_JOB_INSTRUCTION,EPL_START_PLANNED_DATE,EPL_START_PLANNED_TIME, EPL_END_PLANNED_DATE,EPL_END_PLANNED_TIME,EPL_CUSTOMER_NAME,EPL_ADDRESS_1,EPL_ADDRESS_2,EPL_ADDRESS_3,EPL_ADDRESS_4, EPL_ADDRESS_5,EPL_POSTCODE,EPL_CONTACT,EPL_TELEPHONE,EPL_EMAIL,EPL_CONTAINER_ID,EPL_PRODUCT,EPL_DESCRIPTION, EPL_DESCRIPTION_LONG,EPL_PLANNED_QTY,EPL_SITE_ID, EPL_JOB_GROUP,EPL_LOAD_ID, EPL_CUST_CODE

	,,,,,JOBCODE3,CR3,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C3,,,,,TEST,TEST,,		,,,,,JOBCODE3,CR3,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C3,,,,,TEST,TEST,,

	,,,,,JOBCODE4,CR4,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C4,,,,,TEST,TEST,,		,,,,,JOBCODE4,CR4,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C4,,,,,TEST,TEST,,
	</code>		</code>
Line 232:		Line 235:
	<code>		<code>
	,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD1,PRODDESC1,LONGDESC1,1,TEST,TEST,,		,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD1,PRODDESC1,LONGDESC1,1,TEST,TEST,,

	,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD2,PRODDESC2,LONGDESC2,2,TEST,TEST,,		,,,,,JOBCODE5,CR5,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C5_1,PROD2,PRODDESC2,LONGDESC2,2,TEST,TEST,,
	</code>		</code>
Line 301:		Line 305:
	<code>		<code>
	,,,,User1,JOBCODE7,CR7,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C7,,,,,TEST,TEST,,		,,,,User1,JOBCODE7,CR7,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C7,,,,,TEST,TEST,,

	,,,,User2,JOBCODE8,CR8,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C8,,,,,TEST,TEST,,		,,,,User2,JOBCODE8,CR8,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C8,,,,,TEST,TEST,,
	</code>		</code>
Line 359:		Line 364:
	<code>		<code>
	,,,,User1,JOBCODE9,CR9,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C9,,,,,TEST,TEST,Load1,		,,,,User1,JOBCODE9,CR9,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C9,,,,,TEST,TEST,Load1,

	,,,,User1,JOBCODE10,CR10,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C10,,,,,TEST,TEST,Load1,		,,,,User1,JOBCODE10,CR10,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C10,,,,,TEST,TEST,Load1,

	,,,,User1,JOBCODE11,CR11,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C11,,,,,TEST,TEST,Load1,		,,,,User1,JOBCODE11,CR11,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C11,,,,,TEST,TEST,Load1,
	</code>		</code>
Line 426:		Line 433:

	The value 'Order Provided' will cause the jobs to be added in the sequence they are included in the file.		The value 'Order Provided' will cause the jobs to be added in the sequence they are included in the file.

			== Example Files ==
			* [[file:example1.csv]]
			* [[file:example2.csv]]
			* [[file:example3.csv]]
			* [[file:example4.csv]]
			* [[file:example5.csv]]
			* [[file:example6.csv]]
			* [[file:example7.csv]]
			* [[file:example8.csv]]
			* [[file:example9.csv]]

Anw: Updating CSV Upload Example images

2019-01-23T11:28:29Z

Updating CSV Upload Example images

← Older revision		Revision as of 13:28, 23 January 2019
Line 104:		Line 104:
	The import screen lists the following options:		The import screen lists the following options:

	[[File:EPOD-~~Upload1~~.PNG\|border]]		[[File:EPOD-CSV-UploadExample2.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure
Line 120:		Line 120:
	The upload screen will list the result of the CSV upload, showing the upload information in the additional 'Validation' and 'Reason for Failure' columns:		The upload screen will list the result of the CSV upload, showing the upload information in the additional 'Validation' and 'Reason for Failure' columns:

	[[File:EPOD-~~Upload2~~.PNG\|border]]		[[File:EPOD-CSV-UploadExample2Results.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure
Line 130:		Line 130:
	The details of the Job created can be checked by entering the job details screen and searching for the Job Code.		The details of the Job created can be checked by entering the job details screen and searching for the Job Code.

	[[File:EPOD-~~Job1~~.PNG\|border]]		[[File:EPOD-CSV-JobExample2.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure
Line 136:		Line 136:
	\|Text=Job Details - Uploaded job, load number defaulted.}}		\|Text=Job Details - Uploaded job, load number defaulted.}}

	{{Note}} ~~If a~~ 'Load Id' was not specified in the upload file, the system ~~will generate~~ a load number.		{{Note}} A 'Load Id' was not specified in the upload file. In this case, the system has generated a load number 'YTE-0010844O'.


Line 142:		Line 142:
	It is possible to setup an inbound polling process that will automatically upload files from a certain folder. In the "Export Config" screen within C-ePOD, a record should be defined as follows:		It is possible to setup an inbound polling process that will automatically upload files from a certain folder. In the "Export Config" screen within C-ePOD, a record should be defined as follows:

	[[File:EPOD-~~AutoExport4~~.PNG\|border]]		[[File:EPOD-CSV-XFConfig1.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure
Line 163:		Line 163:
	Enter the 'Export Audit' screen and search for records created on the current date:		Enter the 'Export Audit' screen and search for records created on the current date:

	[[File:EPOD-~~ExportAudit1~~.PNG\|border]]		[[File:EPOD-CSV-XFAuditExample1.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure
Line 173:		Line 173:
	In order to fix this error, the Customer should be manually created within the C-ePOD system. Enter the Customer Maintenance screen and create a new record for 'J Bloggs':		In order to fix this error, the Customer should be manually created within the C-ePOD system. Enter the Customer Maintenance screen and create a new record for 'J Bloggs':

	[[File:EPOD-~~Customers4~~.PNG\|border]]		[[File:EPOD-CSV-CustomerExample1.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure
Line 181:		Line 181:
	The previous example1.csv file can now be re-uploaded. In order to do this, the file should be moved from the error folder (e.g. C:\Inbound\errors\) back into the upload folder. Once the file has re-processed, check the 'Export Audit' screen again:		The previous example1.csv file can now be re-uploaded. In order to do this, the file should be moved from the error folder (e.g. C:\Inbound\errors\) back into the upload folder. Once the file has re-processed, check the 'Export Audit' screen again:

	[[File:EPOD-~~ExportAudit1~~.PNG\|border]]		[[File:EPOD-CSV-XFAuditExample2.PNG\|border]]
	{{Xref		{{Xref
	\|Type=Figure		\|Type=Figure

Anw: Formatting changes

2019-01-22T09:20:39Z

Formatting changes

← Older revision		Revision as of 11:20, 22 January 2019
Line 335:		Line 335:
	<code>		<code>
	,,,,User2,JOBCODE8,CR8v2,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C8,,,,,TEST,TEST,,		,,,,User2,JOBCODE8,CR8v2,D,,10072014,901,10072014,901,J Smith,1 High Street,Wimbledon,,,London,W12 8TZ,Mr J Smith,01234,jsmith@gmail.com,C8,,,,,TEST,TEST,,
	<code>		</code>
	{{Xref\|Type=Example\|		{{Xref\|Type=Example\|
	Num={{ #vardefineecho: Example \| {{ #expr: {{ #var: Example }} + 1 }} }}		Num={{ #vardefineecho: Example \| {{ #expr: {{ #var: Example }} + 1 }} }}
Line 351:		Line 351:
	\|Num={{ #vardefineecho: Figure\| {{ #expr: {{ #var: Figure}} + 1 }} }}		\|Num={{ #vardefineecho: Figure\| {{ #expr: {{ #var: Figure}} + 1 }} }}
	\|Text=Job Details - Updated Information.}}		\|Text=Job Details - Updated Information.}}


	=== Moving Jobs to a new load ===		=== Moving Jobs to a new load ===