Home Cloud Account Management Support Forums Downloads About Us  

Blue Alligator Support Forums

Support for the Blue Alligator applications

You are not logged in.

#1 2013-01-07 11:17:27

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Price column

unable to create post on this forum whyyyyyyyyyyyy

Offline

 

#2 2013-01-07 11:20:03

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Re: Price column

Hi,
i export csv file from my company software to my cloud,but i have problem because sales presenter whant price with . and euro money have price same this E9,00 and not 9.00 how to solve this problem?
also other problem sales presenter not know this letter on csv file
And also strange import caracter on csv file pls see image:
http://www.bacapps.co.uk/forum/uploads/thumbs/351_image.png

Tks

Last edited by mascimax (2013-01-07 11:24:27)

Offline

 

#3 2013-01-07 11:32:48

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Re: Price column

also other problem sales presenter not know this letter on csv file letter with dot on up (not permission on forum to write this letter ,notpossible for us show you)

Offline

 

#4 2013-01-07 14:04:14

admin
Administrator
Registered: 2008-02-09

Re: Price column

mascimax wrote:

i export csv file from my company software to my cloud,but i have problem because sales presenter whant price with . and euro money have price same this E9,00 and not 9.00 how to solve this problem?

There is no way round this at the moment. SP expects the separator to be a decimal point. We will add this requirement to our development wish list.

mascimax wrote:

also other problem sales presenter not know this letter on csv file

CSV files uploaded to the cloud can contain standard ASCII characters, extended symbols (such as cents, pound sign, yen, euro) and certain accented letters. All other extended ASCII characters will be automatically stripped out of the CSV data as it is being processed on the cloud.

Can you send an email to the forum admin (using the email address you sent an email to yesterday) with details of the letters you're having trouble with and we'll investigate this.

mascimax wrote:

And also strange import caracter on csv file pls see image:...

This happens when you have a carriage-return/line feed character embedded within your data (the usual culprit being the extended description). These characters end the current record in your CSV file and all the remaining data for that record gets treated as the next record.

By opening the CSV file in a text editor, such as Notepad, and scanning down the records you can easily spot the rogue descriptions and make any necessary corrections.

Offline

 

#5 2013-01-07 14:54:05

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Re: Price column

admin wrote:

mascimax wrote:

i export csv file from my company software to my cloud,but i have problem because sales presenter whant price with . and euro money have price same this E9,00 and not 9.00 how to solve this problem?

There is no way round this at the moment. SP expects the separator to be a decimal point. We will add this requirement to our development wish list.

what you mean? now the product price of E.6,50 i see on sb 6500.00 any solution to see 6.50?

mascimax wrote:

also other problem sales presenter not know this letter on csv file

CSV files uploaded to the cloud can contain standard ASCII characters, extended symbols (such as cents, pound sign, yen, euro) and certain accented letters. All other extended ASCII characters will be automatically stripped out of the CSV data as it is being processed on the cloud.

Can you send an email to the forum admin (using the email address you sent an email to yesterday) with details of the letters you're having trouble with and we'll investigate this.

********what is email address of forum admin???

mascimax wrote:

And also strange import caracter on csv file pls see image:...

This happens when you have a carriage-return/line feed character embedded within your data (the usual culprit being the extended description). These characters end the current record in your CSV file and all the remaining data for that record gets treated as the next record.

By opening the CSV file in a text editor, such as Notepad, and scanning down the records you can easily spot the rogue descriptions and make any necessary corrections.

*****what do you mean every catalog update i need to make some manually correction on csv file??? this not are possible i update catalog every day other solution
********what is email address of forum admin???

Last edited by mascimax (2013-01-07 14:54:33)

Offline

 

#6 2013-01-07 16:38:14

admin
Administrator
Registered: 2008-02-09

Re: Price column

mascimax wrote:

what you mean? now the product price of E.6,50 i see on sb 6500.00 any solution to see 6.50?

The only way to see the prices in SP as 6.50 would be to store them as 6.50 (not 6,50) in your CSV file.

mascimax wrote:

********what is email address of forum admin???

We have now received your email regarding accented characters and will investigate since SP should cope with the characters you've mentioned.

mascimax wrote:

*****what do you mean every catalog update i need to make some manually correction on csv file??? this not are possible i update catalog every day other solution

We are not suggesting that you need to manually correct your CSV file every time you generate it from your system. Opening up your product CSV file in a text editor such as Notepad should help highlight the issues with the data that are causing it to appear the way it does in SP. This will help when changing/correcting the data in your system.

Offline

 

#7 2013-01-07 16:57:54

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Re: Price column

We are not suggesting that you need to manually correct your CSV file every time you generate it from your system. Opening up your product CSV file in a text editor such as Notepad should help highlight the issues with the data that are causing it to appear the way it does in SP. This will help when changing/correcting the data in your system.

I Have 2 problem,
first from our software not are possible to change csv export data and format
second on my product csv file i not find any error i open this with notepad and seems ok
Pls check my product.csv on cloud and check if you find a error.

Tks

Offline

 

#8 2013-01-07 17:46:33

admin
Administrator
Registered: 2008-02-09

Re: Price column

I can see from the data in your cloud account you have 185 live products and 298 that have been deleted (the deleted ones include the strange products that you had on the image you provided earlier in this topic). I'm therefore assuming that you've corrected the issue that you had with your CSV extract.

Offline

 

#9 2013-01-07 17:49:03

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Re: Price column

yes i delete unsful column why file mapping import also not mapping column?
I have problem in my file with 1 unimportant column is possible to esclude this column from import?

Offline

 

#10 2013-01-07 18:05:49

admin
Administrator
Registered: 2008-02-09

Re: Price column

You can exclude a column from the import by removing its field mapping on the field mappings screen.

Offline

 

#11 2013-01-07 18:09:13

mascimax
Junior member
From: Italy
Registered: 2013-01-06

Re: Price column

admin wrote:

You can exclude a column from the import by removing its field mapping on the field mappings screen.

Yes
i not select this field on Mapped From but cloud import this file at same, if you check my cloud see this

Offline

 

#12 2013-01-08 10:10:46

admin
Administrator
Registered: 2008-02-09

Re: Price column

admin wrote:

mascimax wrote:

also other problem sales presenter not know this letter on csv file

CSV files uploaded to the cloud can contain standard ASCII characters, extended symbols (such as cents, pound sign, yen, euro) and certain accented letters. All other extended ASCII characters will be automatically stripped out of the CSV data as it is being processed on the cloud.

Can you send an email to the forum admin (using the email address you sent an email to yesterday) with details of the letters you're having trouble with and we'll investigate this.

We have investigated this and cannot find any issue with the accented letters you detailed in your email - we uploaded them to one of our test cloud accounts and they display correctly in Sales Presenter.

Offline

 

#13 2013-01-08 10:20:03

admin
Administrator
Registered: 2008-02-09

Re: Price column

mascimax wrote:

admin wrote:

You can exclude a column from the import by removing its field mapping on the field mappings screen.

Yes
i not select this field on Mapped From but cloud import this file at same, if you check my cloud see this

Sorry, it's difficult to understand exactly what the issue is here. When mapping fields you will see all the columns from your CSV file so that you can decide whether or not you wish to map them. Any columns that you do not map to fields will not appear in the database on Sales Presenter.

Offline

 

Board footer

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.
© Copyright 2009 - Blue Alligator Company Limited. All rights reserved.