|
|
|
Support for the Blue Alligator applications
You are not logged in.
Pages: 1
Topic closed
I manually extract our data to an excel spreadsheet from our database. Before copying it to the Products CSV template I format the barcode column as a "number" column without any decimal places. The file is then saved as a CSV file and uploaded to the cloud. The first product had "-" as the description and this then knocked out the rest of the information in the CSV file. I then opened the Products CSV file and then the barcode column becomes unformatted. I then save this file and upload it and there are no data issues after. I understand that there are issues when the data isn't automatically synced to the cloud regarding this, but I thought I had gone through the correct procedure to avoid this problem. Can this be explained.
Offline
Hi WB
Just a quick reply to part of your post from another user. You get "-" as products (or customers) in your data if you have blank rows in your Excel file, normally at the end of the file.
Deleting blanks rows/resetting Excel's last row/column before saving as csv should eliminate these on the next upload.
Offline
Thanks Simon. Ill try that next time.
Offline
Instead of copying your exported data into the Products CSV template, we'd recommend that you copy it into a "master" product XLS spreadsheet (with the headings copied from the template). This means that you'll be able to keep the formatting of each column, having only set it up once. Whenever you wish to upload a new product file, copy your new extracted data into your "master" product XLS spreadsheet, save a copy of it as a .CSV file and upload that (i.e. You'll never need to load up the Products CSV into excel, as you'll be maintaining your data within the "master" product XLS spreadsheet).
WB wrote:
I understand that there are issues when the data isn't automatically synced to the cloud regarding this, but I thought I had gone through the correct procedure to avoid this problem.
There aren't any issues regarding the manual uploading of files as opposed to the files being automatically uploaded.
Offline
My mistake my products template is a XLS spreadsheet, but I hadn't formatted the barcode column. Ill try that and see what happens.
What Simon mentioned could that also be a factor as I haven't tested it yet?
Offline
Im still having this issue. On my last attempt the first product code is blank and has a description of "-". If I then open the products CSV file the barcodes are messed up. If I them upload the product CSV again all of the data is correct.
What is happening?
Offline
We can see that you uploaded a new products file which doesn't contain any blank products just a couple of minutes after your last post. Has this resolved your issue?
If you open your products CSV file in a spreadsheet application (such as Excel), the barcodes may not be loaded in correctly as CSV files do not retain any formatting information, therefore the spreadsheet application will display them as huge numbers.
Offline
As I described I load my file as per previous posts and your description and I get the error described in my last post. If I then open the CSV file again it changes the barcodes. I then load this one and there are no issues. I have no blank spaces in the barcode column, but I do in the column I use for the extended description as we don't have an extended description for all products. Is this the possible problem?
Offline
Having blanks in some of the columns is not the problem.
Once you have saved your products file as a CSV, open it in a word processing application (such as Notepad) rather than loading it into a spreadsheet application. You will probably find some blank lines at the bottom of the file which are causing the problems you are describing.
You should never need to open your products CSV file in a spreadsheet application. If you do, your barcodes may be affected as mentioned in our previous post.
Offline
Hi
I am wanting to know how I can add bar codes to my products on sales presenter
Do you need actual images of the barcode or just the numbers
I will be using the little opn 2006 scanner withe sales presenter
Thanks
Offline
You can simply add another column to your products CSV file for the barcode value (number), upload this file and update your field mappings to map this column to the product barcode field (we recommend that new columns are added to the end of each line so that your existing field mappings aren't disrupted).
After processing the file and downloading to your iPad you should be able to use the OPN 2006 scanner during order entry by selecting the "rapid entry" option at the bottom of the screen.
Offline
Topic closed
Pages: 1
| Apple, the Apple logo, iPod, iPod touch, iPad and iTunes are trademarks of Apple Inc., registered in the U.S. and other countries. iPhone is a trademark of Apple Inc. App Store is a service mark of Apple Inc. |