mahmoodee
Member
Hello,
I need to upload CSV with 2000 rows and with the following headings :
Customer , Customer Name, PO Number,Bline Date,Invoice Amt,Pay/Adv/Other,000 - 030,031 - 060,> 060
example of row
AD5 PTRFAC , PETROFAC ENGINEERING AND CONSTRCTIO , 2014260261 , 91000608 , 31/05/2015 , 3,651.50 , 0 , 0 ,0 , 3,651.50
I create a customer list with elements labels like CSV Heading
Labels: Customer , Customer Name, PO Number,Bline Date,Invoice Amt,Pay/Adv/Other,000 - 030,031 - 060,> 060
Names: c_custome, c_customer_name,........................................................................................,c_060
My probem is when I upload CSV it shows this message:
Sorry the following fields in the CSV File are not found in this table:> 060
the problem in the last field "> 060" , if I set the lable > 060 and name c_60 or any another name it show this message
Sorry the following fields in the CSV File are not found in this table:> 060
if I set the lable > 060 and name 060 it work fine and CSV upload success.
I donot want the name to be 060 because If I want to select query this column (select "060" from customers) the result will be 60.
and I want the lable to be "> 060"
Why the system does not recognize the name "c_60" and accept the name"060"
any help please to solve this problem
thank you
I need to upload CSV with 2000 rows and with the following headings :
Customer , Customer Name, PO Number,Bline Date,Invoice Amt,Pay/Adv/Other,000 - 030,031 - 060,> 060
example of row
AD5 PTRFAC , PETROFAC ENGINEERING AND CONSTRCTIO , 2014260261 , 91000608 , 31/05/2015 , 3,651.50 , 0 , 0 ,0 , 3,651.50
I create a customer list with elements labels like CSV Heading
Labels: Customer , Customer Name, PO Number,Bline Date,Invoice Amt,Pay/Adv/Other,000 - 030,031 - 060,> 060
Names: c_custome, c_customer_name,........................................................................................,c_060
My probem is when I upload CSV it shows this message:
Sorry the following fields in the CSV File are not found in this table:> 060
the problem in the last field "> 060" , if I set the lable > 060 and name c_60 or any another name it show this message
Sorry the following fields in the CSV File are not found in this table:> 060
if I set the lable > 060 and name 060 it work fine and CSV upload success.
I donot want the name to be 060 because If I want to select query this column (select "060" from customers) the result will be 60.
and I want the lable to be "> 060"
Why the system does not recognize the name "c_60" and accept the name"060"
any help please to solve this problem
thank you