not using the , in a csv file

A place for users and developers of the Xataface to discuss and receive support.

not using the , in a csv file

Postby PolderBoy » Sat Apr 04, 2009 1:27 am

Hello All,

I am importing a csv file which has a ; as a dilimiter

I need to change the Xataface code so that the ; is used instead of ,

Where I live the comma is used in a currency (0,00) So that is a problem when importing a currency.

Can I change this somewhere?

Thanks in advance.

PolderBoy
PolderBoy
 
Posts: 72
Joined: Fri Apr 03, 2009 12:53 am

Postby shannah » Sun Apr 12, 2009 10:30 am

Since you need to write your own import filter to import records, you have programmatic control over how you import the records. The fgetcsv function allows you to specify the delimiter as the third parameter. Just set this to ';'.

http://ca.php.net/manual/en/function.fgetcsv.php

-Steve
shannah
 
Posts: 4457
Joined: Wed Dec 31, 1969 5:00 pm


Return to Xataface Users

Who is online

Users browsing this forum: No registered users and 17 guests

cron
Powered by Dataface
© 2005-2007 Steve Hannah All rights reserved