I want to automatic insert data from my website with my csv data file, and when i code my own function to insert my Leads, but i got a "Form 'Leads' does not exist in this application" Error :/
void Untitled_Function4(){
//get contents of the remote CSV file
//create a list and add each row of the csv file into a new list item
line_list = csv.toList("\n");
//empty Products table if today's csv has data.
if (line_list.size() > 0)
{
delete from Leads[ Added_Time < zoho.currenttime ];
}
//start importing
for each index i in line_list
{
//skip first row (csv header)
if (i > 0)
{
//get a list item at index
line = line_list.get(i);
//break the line into fields
data_row = line.toList(",");
//TODO : check columns numbers
//extract data values
order_id = data_row.get(0).trim();
order_total = data_row.get(1).trim();
refund_total = (data_row.get(2).trim());
payment_gateway = (data_row.get(3).trim());
shipping_method = (data_row.get(4).trim());
shipping_cost = (data_row.get(5).trim());
order_status = (data_row.get(6).trim());
order_date = (data_row.get(7).trim());
billing_phone = (data_row.get(8).trim());
billing_email = (data_row.get(9).trim());
shipping_first_name = (data_row.get(10).trim());
shipping_last_name = (data_row.get(11).trim());
shipping_address1 = (data_row.get(12).trim());
shipping_address2 = (data_row.get(13).trim());
shipping_city = (data_row.get(14).trim());
shipping_zip_code = (data_row.get(15).trim());
shipping_state = (data_row.get(16).trim());
marketplace_commission = (data_row.get(17).trim());
billing_cpf = (data_row.get(18).trim());
sub_order = (data_row.get(19).trim());
boleto_expire = (data_row.get(20).trim());
boleto_link = (data_row.get(21).trim());
boleto_online = (data_row.get(22).trim());
parcalamento = (data_row.get(23).trim());
product_ID1 = (data_row.get(24).trim());
product_name1 = (data_row.get(25).trim());
product_qt1 = (data_row.get(26).trim());
product_total_sale1 = (data_row.get(27).trim());
product_ID2 = (data_row.get(28).trim());
product_name2 = (data_row.get(29).trim());
product_qt2 = (data_row.get(30).trim());
product_total_sale2 = (data_row.get(31).trim());
product_ID3 = (data_row.get(32).trim());
product_name3 = (data_row.get(33).trim());
product_qt3 = (data_row.get(34).trim());
product_total_sale3 = (data_row.get(35).trim());
product_ID4 = (data_row.get(36).trim());
product_name4 = (data_row.get(37).trim());
product_qt4 = (data_row.get(38).trim());
product_total_sale4 = (data_row.get(39).trim());
product_ID5 = (data_row.get(40).trim());
product_name5 = (data_row.get(41).trim());
product_qt5 = (data_row.get(42).trim());
product_total_sale5 = (data_row.get(43).trim());
product_ID6 = (data_row.get(44).trim());
product_name6 = (data_row.get(45).trim());
product_qt6 = (data_row.get(46).trim());
product_total_sale6 = (data_row.get(47).trim());
product_ID7 = (data_row.get(48).trim());
product_name7 = (data_row.get(49).trim());
product_qt7 = (data_row.get(50).trim());
product_total_sale7 = (data_row.get(51).trim());
product_ID8 = (data_row.get(52).trim());
product_name8 = (data_row.get(53).trim());
product_qt8 = (data_row.get(54).trim());
product_total_sale8 = (data_row.get(55).trim());
product_ID9 = (data_row.get(56).trim());
product_name9 = (data_row.get(57).trim());
product_qt9 = (data_row.get(58).trim());
product_total_sale9 = (data_row.get(59).trim());
product_ID10 = (data_row.get(60).trim());
product_name10 = (data_row.get(61).trim());
product_qt10 = (data_row.get(62).trim());
product_total_sale10 = (data_row.get(63).trim());
product_ID11 = (data_row.get(64).trim());
product_name11 = (data_row.get(65).trim());
product_qt11 = (data_row.get(66).trim());
product_total_sale11 = (data_row.get(67).trim());
product_ID12 = (data_row.get(68).trim());
product_name12 = (data_row.get(69).trim());
product_qt12 = (data_row.get(70).trim());
product_total_sale12 = (data_row.get(71).trim());
product_ID13 = (data_row.get(72).trim());
product_name13 = (data_row.get(73).trim());
product_qt13 = (data_row.get(74).trim());
product_total_sale13 = (data_row.get(75).trim());
product_ID14 = (data_row.get(76).trim());
product_name14 = (data_row.get(77).trim());
product_qt14 = (data_row.get(78).trim());
product_total_sale14 = (data_row.get(79).trim());
product_ID15 = (data_row.get(80).trim());
product_name15 = (data_row.get(81).trim());
product_qt15 = (data_row.get(82).trim());
product_total_sale15 = (data_row.get(83).trim());
//add a new record into Products
if(sub_order < 1){
result = insert into Leads
[
Lead_ID = order_id
Order_Total = order_total
Refund_Total = refund_total
Payment_Type = payment_gateway
Shipping_Method = shipping_method
Shipping_Cost = shipping_cost
Order_Status = order_status
Order_Date = order_date
Phone = billing_phone
Email = billing_email
First_Name = shipping_first_name
Last_Name = shipping_last_name
Street = shipping_address1
Street_Complement = shipping_address2
City = shipping_city
Zip_Code = shipping_zip_code
State = shipping_state
Commission = marketplace_commission
CPF = billing_cpf
Boleto_Expire = boleto_expire
Boleto_Link = boleto_link
Boleto_Code = boleto_online
Parcelamento = parcalamento
Product_ID1 = product_ID1
Product_Name1 = product_name1
Product_Qt1 = product_qt1
Product_Total_Sale1 = product_total_sale1
Product_ID2 = product_ID2
Product_Name2 = product_name2
Product_Qt2 = product_qt2
Product_Total_Sale2 = product_total_sale2
Product_ID3 = product_ID3
Product_Name3 = product_name3
Product_Qt3 = product_qt3
Product_Total_Sale3 = product_total_sale3
Product_ID4 = product_ID4
Product_Name4 = product_name4
Product_Qt4 = product_qt4
Product_Total_Sale4 = product_total_sale4
Product_ID5 = product_ID5
Product_Name5 = product_name5
Product_Qt5 = product_qt5
Product_Total_Sale5 = product_total_sale5
Product_ID6 = product_ID6
Product_Name6 = product_name6
Product_Qt6 = product_qt6
Product_Total_Sale6 = product_total_sale6
Product_ID7 = product_ID7
Product_Name7 = product_name7
Product_Qt7 = product_qt7
Product_Total_Sale7 = product_total_sale7
Product_ID8 = product_ID8
Product_Name8 = product_name8
Product_Qt8 = product_qt8
Product_Total_Sale8 = product_total_sale8
Product_ID9 = product_ID9
Product_Name9 = product_name9
Product_Qt9 = product_qt9
Product_Total_Sale9 = product_total_sale9
Product_ID10 = product_ID10
Product_Name10 = product_name10
Product_Qt10 = product_qt10
Product_Total_Sale10 = product_total_sale10
Product_ID11 = product_ID11
Product_Name11 = product_name11
Product_Qt11 = product_qt11
Product_Total_Sale11 = product_total_sale11
Product_ID12 = product_ID12
Product_Name12 = product_name12
Product_Qt12 = product_qt12
Product_Total_Sale12 = product_total_sale12
Product_ID13 = product_ID13
Product_Name13 = product_name13
Product_Qt13 = product_qt13
Product_Total_Sale13 = product_total_sale13
Product_ID14 = product_ID14
Product_Name14 = product_name14
Product_Qt14 = product_qt14
Product_Total_Sale14 = product_total_sale14
Product_ID15 = product_ID15
Product_Name15 = product_name15
Product_Qt15 = product_qt15
Product_Total_Sale15 = product_total_sale15
];
}
}
}
}