How to handle customer data: Difference between revisions

From Flashbay Wiki
Jump to navigationJump to search
Matt (talk | contribs)
Matt (talk | contribs)
No edit summary
Line 121: Line 121:




[[File:Show hidden.png]]
[[File:Showhidden.png]]


You only need to do this once to enable it on your computer but it is worth checking every so often that someone else has not disabled this feature.
You only need to do this once to enable it on your computer but it is worth checking every so often that someone else has not disabled this feature.

Revision as of 10:48, 16 November 2012


Customer data is extremely important and valuable so it is crucial that we handle it properly to ensure that we do not corrupt or compromise it in any way. Following the procedures in this document will help to ensure that any orders which include DP or DPUS go as smoothly as possible.

30 days for data rule

We allow customers 30 calendar days from order confirmation to supply us with data for DP or DPUS. Please make customers aware of this timeframe when they are ordering so they do not end up with a surprise.

After 30 days has passed and no data is provided, we will carry out the following:

i) credit terms customer (not overdue) - ship order without data and issue credit note for data

ii) credit terms customer (overdue) - inform customer 30 days deadline has passed and we intend to ship order without data and issue credit note for DP. If customer does not agree, order will be cancelled.

iii) advance payment customers who have paid - ship order without data and issue credit note for data

iv) advance payment customers who haven't paid - inform customer 30 days deadline has passed and we intend to ship order without data and issue credit note for DP. If customer does not agree, order will be cancelled.

You can review how many days each sales order has left before the 30 days deadline for receipt of data is reached in Zimbra -> My Sales Admin -> Orders Waiting for Data -> Days waiting for data.

How to receive customer data

There is a page on our website that explains to customers how they can send us data and you should be very familiar with this. The English translation can be found at:

http://www.flashbay.com/data

(You can choose your own language in the language selector to see the specific translation that your customers will see and also to find out the address of the page should you wish to refer them to it directly).

The most popular ways to receive data from customers are (in order of preference):

a) upload to our website

b) download from customer

c) FTP from customer server

d) email

e) cd / dvd / flash drive through the mail

Each of these has its own considerations but the main thing to remember is that with a, b, c, d (and preferably e) the customer must zip the data into a single file. The internal folder structure of this file must exactly represent the folder structure of the finished flash drive. In the case of e the data need not be zipped but the folder structure of the cd / dvd / flash drive must also exactly represent the folder structure of the finished flash drive.

In all cases we aim to avoid moving / renaming / editing customer data. Doing this can easily lead to errors for which you will be held responsible. Also, do not pass on such requests to IT or factory staff unless it is absolutely critical. The customer is ultimately responsible for providing the correct data - trying to modify customer data under the pressure of a deadline and often with poor communication is extremely risky and will often lead to mistakes.


Why a single zip file?

When files are copied and transferred there is always the possibility that they become damaged, corrupted or go missing completely. If this happens it might not be easy to see just by looking at the data and you would need to check every single file to make sure that all the data was ok (some customers send data containing many thousands of files). If a zip file is damaged or corrupted though it simply won’t unzip which means that you can quickly test whether the data is ok. Additionally, files cannot vanish from inside zip files so if you are given a zip file and it unzips properly you can be sure that the same data is inside as when the customer zipped it up.


Different methods of receiving data

a) Upload to our website

This is the most straight forward way for customers to send us data. Provided the zip file that they wish to send us is under 2GB they can use the data upload page on our website to send us their data. When it is successfully received you will be sent an email notification and will be able to download the data to your PC for checking, renaming and sending to the factory.

b) Download from customer

If the customer has access to a web server or some sort of publicly accessible online storage space then they can send you a link to download their zip file from the web. This is a very quick way for us to get the data.

c) FTP from customer server

If the customer has their own web server they may give you login details to download the data that you require for the order. When you login to their FTP server ensure that you follow their instructions carefully to locate the correct data for the order. If it turns out that the data is stored as files and folders on the FTP server and not a single .zip file then please do not download the data. Instead, instruct the customer to create the required zip file and place that on their FTP server instead.

d) Email

This is the simplest way but only really suitable if the zip file that the customer creates is less than 5MB in size. Files larger than this can cause problems with both the customers email systems and also our own. You may also find that the customer’s IT department do not let them email files above a certain size and so their message will arrive but the attachment will be missing. We have no control over such events, our email system will never remove attachments from either incoming or outgoing messages.

e) cd / dvd / flash drive through the mail

In cases when the data is very large, above 2GB for example, or the deadline is sufficiently long the customer may prefer to send the data on a disk through the post. The data does not need to be placed in a zip file when it is on a cd / dvd / flash drive but you must inform the customer that they should produce the disk in such a way that it has the same folder structure as the finished flash drive will have. Remember - data supplied on cd / dvd / flash drive need not be zipped up but the customer must take extra care that the data is correct in these cases as sending it again can be very time consuming and we do not wish to have them send files by email / download / ftp to correct their mistakes. As a salesperson you need to take extra care when handling files supplied by flash drive as you could easily make a mistake and change or delete important customer data. Always copy the data from the flash drive onto your PC and keep the original data safe in case you need to refer to it in future or you make a mistake with your copy of the data and need to start again. Take particular care with cds / dvds / flash drives that contain Mac data - refer to the Mac data section for information.


How to check customer data

Unzipping the data

Once you have the customer data you must check that it actually works. The first step is to unzip the files. You can do this as follows (You can skip this step if the files are supplied unzipped on a cd / dvd / flash drive ):

1. Save / move the customer data zip file to your desktop

2. Right click on the zip file

3. Select '7-Zip' > 'Extract to "{name of zip file}\"' from the menu that appears

4. The program will unzip the file and a new folder will be created on your desktop with the same name as the zip file but without the .zip extension

Example: You have a customer data file called 'data_for_flashbay.zip' on your desktop You follow the above procedure You now have a customer data file called 'data_for_flashbay.zip' and a folder called 'data_for_flashbay' on your desktop You can look inside the 'data_for_flashbay' folder to see the customer data

It is usually best to store the unzipped folder on the Desktop, you will be deleting it once you have checked the data so there is no need to worry about filling up your desktop.

Always use this procedure when viewing the contents of zip files, do not simply double click on the zip file as this will show you a preview but the files behave differently to when they are properly unzipped using the procedure above.


Viewing the data

Once you have unzipped the data you will need to check that it is complete and working. You can do this easily by opening up the folder and quickly looking at and trying to run the files. Before you do this though you must be certain that you are viewing all the files by making sure that your computer is displaying hidden and system files. You can do this as follows:

1. Choose 'Computer' from the start menu or open any folder

2. Click on the 'Organize' menu

3. Select 'Folder and search options'

4. Select the 'View' tab

5. In 'Advanced settings' make sure that under the 'Hidden files and folders' section you have selected 'Show hidden files, folders and drives'.

6. Click 'Apply' and / or 'OK'


You only need to do this once to enable it on your computer but it is worth checking every so often that someone else has not disabled this feature.

Now you will be able to see all the data sent by the customer, including any hidden and system files that they may have sent. This is useful as some customers like to make their autorun files hidden so that end users do not see them when they look at the contents of the drive.


Running the data

It is essential that you try running some of the customer data to make sure that it works. You will usually be aware of the type of data that they have supplied to you and its purpose so this information can help you to decide how best to run the data during your test - you must use common sense and judgement.

For example, if the customer has sent you 3 PDF files to be preloaded then you should check that you can open all three files. If they send you 300 then you should try 10 or 15 at random. You don’t need to read the information that they contain, you just need to check that they open.

If the customer sends a flash movie then make sure that it plays and if they send you a web page then make sure that you can open it and that it appears to be correct, click around and try some of the links to be sure that they work.

The purpose of running the data is just to be sure that any obvious errors are spotted at an early stage before the data is sent to the factory. As the salesperson you are well placed to assess whether the data works as you will be familiar with what the customer is looking to achieve.


Autorun functions

Due to changes in the way that the latest operating systems work there are important differences between what can be achieved with autorun files depending on whether the customer wants DP or DPUS:

- Autorun on DPUS drives supports the changing of drive icons, volume labels and the automatic running of applications and content (depending on the operating system).

- Autorun on DP drives only supports the changing of drive icons and volume labels - applications and content cannot be run automatically.

In basic terms autorun only works well for drives ordered with DPUS as the drive has a partition which is formatted as a CDROM. Autorun never works on Macs. For more information see http://www.flashbay.com/services/usb-autorun.html

If your customer wants some of their data to autorun then you need to specify this in the "Job Notes" field on the "Job Details" tab of the sales order in Netsuite and the Operations team will either create the required autorun file or check that the customer supplied autorun file is correct.

Special note - If you are storing data on the network never put autorun.inf files on the root of a network drive (such as the S: or P: drive) as this file will run every time someone opens the drive to view the files.


Sending data to the factory

Once you are sure that the data works and is complete you should prepare it for upload to the factory FTP server. Do not re-zip the files that you have been checking. Instead, simply rename the original zip file that contains the data for the order. The standard naming format is:

SalesOrderNumber CustomerNumber CustomerName.zip

For example:

S1234 C0079 Bilko.zip

If you have multiple data sets to be used with different proofs you can include the proof reference in the file name:

SalesOrderNumber CustomerNumber CustomerName ProofReference.zip

For example:

S1234 C0079 Bilko PR1234.zip

S1234 C0079 Bilko PR5678.zip

In all other non-standard cases, for example orders for the same product but with multiple data sets to be preloaded on different units, you may vary the end of the zip file name but must explain the variation in the "Job Notes" field on the "Job Details" tab of the sales order in Netsuite:

For example:

Zip file names: S1234 C0079 Bilko Data1.zip and S1234 C0079 Bilko Data2.zip

Job Notes entry: Data1 = 400 units, Data2 = 500 units

By only renaming the file you can be certain that you are not changing its contents in any way.

You should then upload the renamed zip file to the factory FTP server using FileZilla (which is pre-installed on your computer). Should the stored login details be lost they are:

Host name: ftp://data.flashbay.com (click the link to launch in download mode)

Username: data

Password: chickensoup69

To access the factory FTP server in Read/Write mode you should use FileZilla (there is a shortcut to this on your desktop and you will have been shown how to use it during your initial training). You cannot upload files using Firefox as it connects to the server in read only mode.

You should then email Operations to inform them that the customer data is available on the server. Additionally, if there is any special action that needs to be taken with the data or with the order generally then you must contact the factory and inform them of this directly as well as making sure that you include clear instructions in the "Job Notes" field on the "Job Details" tab of the sales order in Netsuite. An example of this would be when the customer wants the finished drives to have a specific volume label.

Special note - if customer data is above 1GB in size you should contact itsupport@flashbay.com for assistance in uploading the data to the server to ensure that it can be properly downloaded by the factory. Additionally, you should understand that the larger the customer data is, the longer it will take to be preloaded on to the flash drives and you should factor this into the amount of time that you allow to receive the data from the customer.


Mac data

Mac files can be difficult to work with so it is important that you always check with your customer whether the data contains any Mac specific files. PDFs, images, documents and web pages will usually work on Macs with no problem but care needs to be taken with applications and flash movies in particular.

If your data contains Mac files these must be checked separately on a Mac by an IT or factory staff member. Always make the factory aware when your customer data contains Mac files. Similarly, always make IT staff aware that your customer data contains Mac files if they are assisting you with handling the data.

It is crucial that you do not unzip and re-zip data that contains Mac files as this will damage them in such a way that they will not run anymore. It is highly preferable that you receive Mac data in a zip file created by the customer. The next best alternative is to receive Mac data on a CD (arranged exactly how the customer wants it on the flash drive). It should then be zipped from the CD with the assistance of an IT staff member.

In case your customer would like to have their data locked and functionable on Mac OS please proceed and advise your customer on the following:

i) If data upload on locked partition is bigger than 2.2GB, files won't work correctly on Mac OS.

- Our DPUS flash drives contain a virtual CD partition, we can't format this as a virtual DVD partition.

- Mac systems only support a maximum of 2.1~2.2GB on the DPU virtual CD partition.

- Formatted to "Removable Partition + CD Partition".

ii) If data upload on locked partition is smaller than 2.2GB, then there will be no problem to process with the standard formatting.


Questions and assistance requests

If you have any questions regarding customer data or need assistance testing or uploading customer data then please email itsupport@flashbay.com