Csv Import and show blanks and delete error

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?

– 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

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.

sorry for the delay
DB Ver is 3.1.1

https://www.iga.co.il/temp/1.jpg
https://www.iga.co.il/temp/2.jpg
https://www.iga.co.il/temp/3.jpg
https://www.iga.co.il/temp/4.jpg
https://www.iga.co.il/temp/5.jpg
https://www.iga.co.il/temp/6.jpg
https://www.iga.co.il/temp/7.jpg

as you can see in pic 7
all the fields are blacks

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?

please post your email

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

https://businessdirectoryplugin.com/contact/

https://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

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: https://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?

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

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)

i try that
and i updated the test file

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

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

i update the settings
https://www.iga.co.il/temp/1.jpg
https://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%

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.