It aint working, is there a trick in excel to create the csv? or tabdelimited, I am creating it in usual way.

In the first row I have these fields

url category title article joined

am I missing something?

CommentFileSizeAuthor
#2 drupaltest.txt85.31 KBdietman

Comments

dietman’s picture

dietman commented

i tried tab delimited and csv comma delimited

the file is 2mb and it is not working

It always says

Select file field is required. Upload a file first if there are no files uploaded yet.

dietman’s picture

dietman commented
StatusFileSize
new drupaltest.txt85.31 KB

I am ataching few lines of my tab delimited txt file

THis file is not 2mb so it gets uploaded but I get an error url is missing or something like that

I tried to upload this small file and mapped the fields correctly and I still get error

URL field is required.

the first field is Url, and I mapped it, so why I get this error?

dman’s picture

dman commented

I don't know what the "usual way" you are using to create that file is, but if you look at it, you'll see that 6 of your pages, including the first, have a value of "2,01E+16" as the URL.

Do you not see any problem with that?

If you are reporting an error, it would be best to actually check what the error says, not just say "or something like that". Help others to help you.

dietman’s picture

dietman commented

Thank you for your answer

the url is this
20050105063841943
It is a stange code from Geeklog and it should be accepted by drupal

2,01E+16 is just a shortname, but when you click on it in excel, it shows 20050105063841943

is there a way to prevent the numbers to be in shortened?

dman’s picture

dman commented
Category: feature » support
Priority: Critical » Normal

You only now mention that your source is coming from Excel. There are many ways a CSV could be produced, if you leave out important details, debugging is really boring.
So - your export from Excel to that file failed to produce the desired result. There's your problem.

FWIW, using a pure (huge) integer as an URL is probably really ugly. It may also be what is confusing the importer later.
The problem is still with the data that you are feeding the node_import. There may be a feature request in refining how it supports numeric-only URLs ... but it's probably not desirable

dietman’s picture

dietman commented

Is there a notehr way to prepare excel file
I mean I am using microsoft excel

I go to save and save as tab delimited or save as csv comma delimited

dman’s picture

dman commented

did you try changing the url column from "general" to "string"?

dietman’s picture

dietman commented

aND WHY i CANT IMPORT THE CSV FILE, SIZE IS 2 MB?

nothing happens after import, is there a size limit?

dman’s picture

dman commented

Drupal file upload size limit

dietman’s picture

dietman commented

Well now it works, thank you

But I still get

URL field is required.

even though i map the url field to url appropriate field before import.

I changed all the urls from numbers to words and also removed all spaces, only _ or - is allowed in url