upload CSV problem with element label

[mahmoodee]

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

 

[troester]

Use element names (not labels) as CSV headings (and set the default Heading format= "Element short name" in the CSV options)

 

[mahmoodee]

thank you
I cannot change CSV headings , it must be
Customer , Customer Name, PO Number,Bline Date,Invoice Amt,Pay/Adv/Other,000 - 030,031 - 060,> 060
so the system will not accept the elements names to be > 060 or space like Customer Name
the problem only in the list field "> 060"

 

[mahmoodee]

I do that and now show this message
Sorry the following fields in the CSV File are not found in this table:Customer, Customer_Name, PO_Number, Inv_Doc_No, Bline_Date, Invoice_Amt, Pay/Adv/Other, 000_-_030, 031_-_060, >_060,
please help me

 

[troester]

set the default Heading format= "Element short name" in the CSV options

 

[mahmoodee]

I set Heading format= "Element short name" in the CSV options
but show this message
Sorry the following fields in the CSV File are not found in this table:Customer, Customer_Name, PO_Number, Inv_Doc_No, Bline_Date, Invoice_Amt, Pay/Adv/Other, 000_-_030, 031_-_060, >_060,

 

[mahmoodee]

I think If I set Heading format= "Element short name" in the CSV options , I must change the elements name to be like
>_060 ,Customer_Name,.....
Is that true ?
beacause now with Heading format= "Element short name" it show
Sorry the following fields in the CSV File are not found in this table:Customer, Customer_Name, PO_Number, Inv_Doc_No, Bline_Date, Invoice_Amt, Pay/Adv/Other, 000_-_030, 031_-_060, >_060,

 

[troester]

Use element names (not labels) as CSV headings

You can use setting "element short names" + CSV element names
or
"element labels" + CSV element labels (but > is html encoded, so in CSV it must be > )

 

[mahmoodee]

I do that and get message
Sorry the following fields in the CSV File are not found in this table:Customer, Customer_Name, PO_Number, Inv_Doc_No, Bline_Date, Invoice_Amt, Pay/Adv/Other, 000_-_030, 031_-_060, >_060,

 

[troester]

You said your element names are c_xxx. Put them into your CSV file (first row).

 

[mahmoodee]

this app for my customer , so I cannot explain to him every time to change his csv heading names
I want to able to upload the csv with these headings
Customer , Customer Name, PO Number,Bline Date,Invoice Amt,Pay/Adv/Other,000 - 030,031 - 060,> 060
I was able to do that but there was problem only in last element > 060
any suggestion?

 

[troester]

As it is you can't use a >.

 

[mahmoodee]

thank you , I was think I can use ">" because I use it in element label not in name.
when I set element label "> 060",
why it work when the element name is "060" and not work when element name is "c_60" ?