2. PHPRunner General questions
  3. [SOLVED]  Import amounts in Phprunner 8
This topic is locked
[SOLVED]

 Import amounts in Phprunner 8

 		9/12/2014 4:00:24 AM
PHPRunner General questions
loveuppal author

Hi
When I import through copy/paste text function in phprunner 8, the currency amounts are truncated after commas. For eg if the amount is 100,000 then upon import only 100 will get imported to the field. How can I resolve this?
D
 		DUKE 9/12/2014

If there is a comma separating the thousands, try removing that....



Hi
When I import through copy/paste text function in phprunner 8, the currency amounts are truncated after commas. For eg if the amount is 100,000 then upon import only 100 will get imported to the field. How can I resolve this?
loveuppal author 9/12/2014

Thanks Duke but thats the problem. I can not copy/paste selectively. Ifs there any script which I can run on Editor page (before import) which can check convert the amounts to integer.



If there is a comma separating the thousands, try removing that....
Sergey Kornilov admin 9/12/2014

Try to choose another delimiter after pasting your data. Import page supports all types of delimiter, not just commas.
loveuppal author 9/15/2014

Thanks I'll try but for the time being I made those fields as char and then converted them with string function in sql.



Try to choose another delimiter after pasting your data. Import page supports all types of delimiter, not just commas.