*

bickja

  • ***
  • 48 posts
Contact Number Filed?
« on: May 17, 2017, 08:29:20 PM »
Hi frosticek,
Additional Phone filed how labeled in database i want its name? where it stored in database?
actuality some time i am uploading bulk listing via ad importer. everything is fine but i cant import phone number so i am using name filed for contact no then again editing all listing, taking phone number from name filed and adding in additional phone filed.
So i am looking if i can make it simple and avoid additional step to edit listing again.
« Last Edit: May 17, 2017, 08:32:12 PM by bickja »

*

MB Themes

Re: Contact Number Filed?
« Reply #1 on: May 17, 2017, 10:10:47 PM »
@bickja
It is in _item_veronika table.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

bickja

  • ***
  • 48 posts
Re: Contact Number Filed?
« Reply #2 on: May 18, 2017, 08:32:51 AM »
@frosticek
Thanks for your reply please help me little more.
I found the lable for phone as "s_phone" i tried to import listing but still contact no gone some where else.
Kindly tell me what lable i need to use for phone number so it can directly import to phone filed.
Quote
<listing>
      <title lang="en_US">LAND ROVER LR2 HSE V6 2011 - FULL SERVICE HISTORY AED59000</title>
      <content lang="en_US">LAND ROVER LR2
2011 MODEL
3.2L V6 HSE

GCC GULF SPECS CAR
EXPAT OWNER

WARRANTY UNTIL MARCH 2018
FULL LAND ROVER SERVICE HISTORY
BLACK WITH LEATHER INTERIOR
KEYLESS ENTRY + START
SATELLITE NAVIGATION
BLUETOOTH TELEPHONE
ELECTRIC SUNROOF
81000 KMS
TWO KEYS

ONLY 59000 AED

BUY THIS CAR WITH COMPLETE PROTECTION

This car is sold by the owner but managed and verified through Expat Wheels and Sell it For Me by Dubizzle.

You have complete peace of mind that once a provisional deal has been agreed the car will go through a full 240 point all mechanical and electrical inspection before you proceed to purchase and hand over any money.

You have the Expat Wheels team to help you through the whole process including RTA assistance. The Expat Wheels team remains neutral between the buyer and seller so everyone is protected at all times.

Plus, the buyer pays no fee for this great service!

Call the team now on 054xxxxx to arrange a time to view this car.

Viewing times are 9am until 6pm – Seven days a week.
(This is subject to the availability of the car)</content>
      <category lang="en_US">Cars</category>
      <contactemail>[email protected]</contactemail>
      <contactname>054xxxxx</contactname>
      <s_phone>0544xxxxx</s_phone>
      <price>59000</price>
      <currency>AED</currency>
      <countryId>ae</countryId>
      <country>United Arab Emirates</country>
      <region>Dubai</region>
      <city>Dubai</city>
      <datetime>2017-05-18 10:00:09</datetime>
   </listing>
« Last Edit: May 18, 2017, 08:38:57 AM by bickja »

*

MB Themes

Re: Contact Number Filed?
« Reply #3 on: May 18, 2017, 08:42:49 AM »
@bickja
Phone for listings is stored in table _item_veronika. It has foreign key to table _item.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots

*

bickja

  • ***
  • 48 posts
Re: Contact Number Filed?
« Reply #4 on: May 18, 2017, 08:48:20 AM »
@bickja
Phone for listings is stored in table _item_veronika. It has foreign key to table _item.
Thanks for quick response.. please just give me a label like other element. I am not getting what to label for phone so that data go directly to phone filed. Please help

*

MB Themes

Re: Contact Number Filed?
« Reply #5 on: May 18, 2017, 09:59:43 AM »
@bickja
Sorry, I have no idea what are you talking about. I told you what table to look in, I hope you can identify that s_phone column is for phone numbers.
  To get fast support, we need following details: Detail description, URL to reproduce problem, Screenshots