Advanced Retail (UK) Ltd
Company Wiki

–Recover Datalogic Use doc to create insert

https://docs.google.com/spreadsheets/d/1dHBXm5M6bCS19xZWftrrixADAjxFQeCN3OflrN7fDdE/edit#gid=0 – Create table

CREATE TABLE #Data (barcode varchar(30), quantity int, product int)

– Then run insert script

–then get branch

select * from branch where branch_name like '%wadebridge%'

–Get Device ID

select * from [nimbus_ma].[dbo].[mobile_bucket_session] where branch_no = 23

order by session_date_time desc

–Finally

select * from #data

EXEC [traxs_Utility_#Data_BarcodeToProduct]
DECLARE @device_id int = 32
DECLARE @branch_no smallint = 23
DECLARE @success bit, @error_message varchar(1000)
DECLARE @guid uniqueidentifier = NEWID()
DECLARE @rows MobileBucketRow
INSERT INTO @rows (date_time, product, barcode, quantity, location, whs_location)
SELECT 
GETDATE(), product, barcode, quantity, '', NULL
FROM
#data
EXEC [dbo].[nimbus_Mobile_Bucket_Insert] @guid = @guid, @device_id = @device_id, @branch_no = @branch_no,
@user_no = 1, @description = '', @store_area_id = NULL, @download_use = 1, @rows = @rows, @success = @success
OUTPUT, @error_message = @error_message OUTPUT
print @success
print @error_message