WordPress.org

Ready to get started?Download WordPress

Forums

Business Directory Plugin
[resolved] Csv Import and show blanks and delete error (20 posts)

  1. fisherofer
    Member
    Posted 11 months ago #

    i try to use this data for test CSV IMPORT

    4x4 לוגיסטיקה בע""מ",03-9309563,03-9304668,פתח תקוה,סימטת התבור   5,,49691,mshulman9@gmail.com,
    "4x4 סופר צמיג  בע""מ",08-6755724,08-6750164,אשקלון,המסגר,1,78583,,
    "4x4צמיגי החוף גפני בע""מ",03-9529393,03-9529395,ראשון לציון,שפירא,12,75284,gafni@tires.co.il,
    "u.m.i מרכז שירות חיפה בע""מ",04-8417418,04-8414473,חיפה,ההסתדרות,40,32960,kahanmotors@umi4u.co.il,
    v.i.p servis,02-6761804,,ירושלים,בית היוצר,5,93420,vip.servis2010@gmail.com,
    א. אברהם,03-6821460,03-6833221,תל אביב - יפו,הנגרים   13,,66080,,
    "א. אהרון בע""מ",03-6050562,03-6050562,ראשון לציון,הרצל,2,75287,,
    "א. בר פחחות וצבע בע""מ",08-9222677,08-9222577,רמלה,"האצ""ל",21,72426,,
    "א. הנעות שווק וסחר בע""מ",04-9585555,04-9585558,כרמיאל,רח' החרושת 48,"ת""ד 264",20100,inbal@hanaot.co.il,
    "א. לייבמן שרותי רכב בע""מ",03-9311850,03-9304376,פתח תקוה,מרכוס   34,,49565,,
    "א. סרור בע""מ",04-8400418,04-8400418,חיפה,"25135 ת""ד  ",,31250,,
    "א. שחר נתניה בע""מ",09-8617474,09-8870841,נתניה,השיש 3,"ת""ד 13042",42379,shachar@fiatnet.co.il,
    "א.א מרכז רכב דרום בע""מ",08-6276070,08-6276020,באר שבע,דרך חברון 8,"ת""ד 342",84102,,
    א.א. גוטפריד אלכסנדר,03-5518504,03-5518575,בת ים,הפלדה   4,,59606,sasha_nadya@list.ru,
    א.א. חשמל ומיזוג אויר,03-9302705,,פתח תקוה,הירקונים   37,,49271,,
    "א.א. לוי אפרים בע""מ",08-9460336,08-9460337,רחובות,גבריאלוב   39,,76341,aa-levy@zahav.net.il,
    א.א. מוסך אלי עברי,03-9617717,03-9523360,ראשון לציון,"האצ""ל   11",,75706,elie.evrie@gmail.com,
    א.א. מוסך עתיד,08-8562423 - טלפון חסום,08-8562423,אשדוד,העמל 40,"ת""ד 12029",77606,,
    א.א. ניר פחחות וצבע,08-9105454,08-9105656,באר שבע,ת.ד. 2204 רח' שורק ע.שרה,,84100,,
    "א.א. קאר סנטר מוטורס בע""מ",08-8527777,08-8566894,אשדוד,התאנה 1,"ת""ד 12128 א""ת הקלה",77104,carcenter@umi4u.co.il,
    "א.א. קרמן פרונט בע""מ",03-5793243,03-5792422,בני ברק,הירקון,69,51206,frontk@netvision.net,
    
    my fields are
    business_name,phone,fax,city,st,street_number,postal_code,email,web-site,username (set to XXX)
    
    or by c&p from wordpress
    
    Order	Label / Association	Type	Validator
    Order	Label / Association	Type	Validator
    ↑ | ↓	Business_Name (as title)
    	Textarea		OptionalIn ExcerptIn Listing
    ↑ | ↓	Phone (as meta)
    	Textfield		OptionalIn ExcerptIn Listing
    ↑ | ↓	Fax (as meta)
    	Textfield		OptionalIn ExcerptIn Listing
    ↑ | ↓	City (as meta)
    	Textfield		OptionalIn ExcerptIn Listing
    ↑ | ↓	St (as meta)
    	Textfield		OptionalIn ExcerptIn Listing
    ↑ | ↓	Street_Number (as meta)
    	Textfield		OptionalIn ExcerptIn Listing
    ↑ | ↓	Postal_Code (as meta)
    	Textfield		OptionalIn ExcerptIn Listing
    ↑ | ↓	EMAIL (as meta)
    	Textfield	email	OptionalIn ExcerptIn Listing
    ↑ | ↓	Web-Site (as meta)
    Edit | Delete
    	URL Field	url	OptionalIn ExcerptIn Listing


    [Please use the code buttons - not quotation marks]

    when i finish the test with no error i try to import
    but most of my data is blank and i cant delete it

    http://wordpress.org/extend/plugins/business-directory-plugin/

  2. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    Hi fisherofer,

    Let's start with some questions:
    - What version of BD are you running?
    - What are your CSV import settings for this data?
    - Did you start with the CSV sample file as shown under Directory Admin->CSV Import?
    - What happens with "Test Import"? Do you see any error messages?
    - Can you make this error happen with a single-line CSV file?

  3. fisherofer
    Member
    Posted 11 months ago #

    - What version of BD are you running? latest

    - What are your CSV import settings for this data? csv comma delimited

    - Did you start with the CSV sample file as shown under Directory Admin->CSV Import? yesy

    - What happens with "Test Import"? Do you see any error messages?
    no

    - Can you make this error happen with a single-line CSV file?
    i will try but i dont think it will make the change

  4. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    Hi fisherofer,

    I really need some more information.

    - What specific version of BD are you running? Is it 3.1.1?
    - The CSV import settings--can I see a screenshot of what your import screen looks like at the time of import?
    - Does Test Import succeed? Are there messages of ANY kind?
    - The single-line CSV file is important--without that, we will have a tough time reproducing this.

    It will also help if you can post a screenshot of your Manage Form Fields screen under Directory Admin, so I can compare the fields there with what your CSV import file has.

  5. fisherofer
    Member
    Posted 11 months ago #

  6. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    I still need a link to the single-line CSV file that reproduces this problem--that's the most critical piece here. Can you please post a link to it?

  7. fisherofer
    Member
    Posted 11 months ago #

    please post your email

  8. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    Drop me a line via the contact form here and I'll reply to it. Posting my email publicly only attracts spam. :)

    http://businessdirectoryplugin.com/contact/

  9. fisherofer
    Member
    Posted 11 months ago #

    http://iga.co.il/temp/12344.csv
    its a small file of my main

    please try and thanks
    +
    how can add category only for free trail

  10. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    OK, looking at the file, I see that you're missing business-genre field data. That field is required, so you need to include that. I see that you have empty long description field as well. I'm not sure how you were able to mark that field as optional. There are 3 fields that should always be required: Title, Category, and Description. That's a WP requirement, so we may have a bug there.

    For the categories, you can have BD create these categories for you or use the existing ones. There is an option on the CSV importer to select this. The documentation describes it here: http://businessdirectoryplugin.com/docs/#admin-import I see that you set yours to generate errors on import. Since you provided a blank category name in the sample file, I would expect that to fail. If you put in a valid category, and have that category previously created under Directory->Directory Categories, does the import work on that sample file?

  11. fisherofer
    Member
    Posted 11 months ago #

    please try to import the files
    the names are not imported at 100% most of the name cut in the start

  12. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    As I mentioned above, the import file is not correct, so importing it will indeed fail. Can you please try my suggestion above for the second paragraph?

    We are looking into whether there is a bug with required fields here as well, but I need you to test the second part, since your file and settings are not consistent (you are missing data in the file and asking for it to be created on import, even though the field is technically not required, which I believe is a bug--categories should always be required, per WordPress custom post type requirements)

  13. fisherofer
    Member
    Posted 11 months ago #

    i try that
    and i updated the test file

    the names are cut when the data get the first " " space
    please try

  14. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    OK, so we've tried it--both with the sample and copy/pasting the source data above. There are several issues here that are odd.

    1) If you look at the screenshots, that setup doesn't match either the CSV file you provided or the example lines from the beginning of the post. Even within the set of screenshots you can see different fields and names being used so at the end I have no idea which CSV file & field set is having issues.

    We use the PHP CSV parsing library, so our testing indicates that the charset isn't an issue, nor is the embedded quotes (like "a,b", c). We depend on PHP's behavior to break up your file appropriately.

    What version of PHP are you running this on? We tested with 5.3.15 and had success.

    2) We tried to import your data--both with the sample and with the pasted data above. We were able to do it, no problem, once we properly configured the field names to match the columns, and once we set the category/title/description data to required. These are WP requirements.

    If you change your fields to required, does the data import now?

    3) When you say the names were cut, which column are you referring to? Can you please post a complete setup of your last test, including:
    - Link to the sample file you tried
    - Screenshot of the field configuration at the time of import
    - Screenshot of the CSV import screen, showing your settings
    - Screenshot of any errors you get on the output
    - Screenshot of a listing that did not import correctly

  15. fisherofer
    Member
    Posted 11 months ago #

    i update the settings
    http://www.iga.co.il/temp/1.jpg
    http://www.iga.co.il/temp/7.jpg

    but please test the import for the names and the rest of the fields you can update them as you wish

    the bit Q is why the CSV import is missmech to the real names in the file
    for the genre i will auto fill when the test will be 100%

  16. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    So those warning I see about Line 2 of your file tells me that Line 1 may be a blank line. Those warnings are the column names that I would expect to see.

    Do you have a blank line for Line 1 of your CSV file? If so, delete it and try again.

    I still need some of the screenshots above and answers to my questions to proceed further with your issue. Please provide those and we can keep working on this. You only gave me 2 screenshots (field config and errors), but I need all of them.

  17. fisherofer
    Member
    Posted 11 months ago #

  18. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    Can you please answer my question here?

    Do you have a blank line for Line 1 of your CSV file? If so, delete it and try again.

  19. fisherofer
    Member
    Posted 11 months ago #

    as i know it
    i have a blank line in the end of the csv file
    i cant delete the last black line
    it will destroy my file and the import will fail include the test

    i use excel to create the csv from my Microsoft crm server
    and then try to upload to the WP

    i send you a short file of my data
    http://iga.co.il/temp/12344.csv

    sorry for the delay
    and thanks for the support

  20. businessdirectoryplugin
    Member
    Plugin Author

    Posted 11 months ago #

    I think at this point I would need admin credentials to understand the issue. Can you please send them to http://businessdirectoryplugin.com/contact/ and include a link to this thread?

    Your settings, screenshots all look OK to me, so something else is going on.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.