Перейти к содержимому


Фотография
- - - - -

Add csv data


Лучший Ответ zarzon56640 , 12 August 2014 - 06:27

Good the problem is resolved, I used excel to create the fields, and it should be just a little careful during conversion to CSV file. It must be absolutely do not allow a semicolon trainer and well all replace by commas. Thank you for your help, now I can add new values by tranche of 10,000.

Cordially,

SC 

http:hortus-botanique.fr

Перейти к сообщению


  • Закрытая тема Тема закрыта
Сообщений в теме: 7

#1 zarzon56640

zarzon56640

Отправлено 04 August 2014 - 19:02

I must add data into an application using the name as the key-reference. Is there a guide or a tutorial to proceed to this import CSV? I have tried with basic documentation but without success. I cannot export these CSV data to do make a model since this database is too large (130,000 entered)


  • 0

#2 Kess

Kess

Отправлено 05 August 2014 - 06:38

Hello,

 

There is an article about import on our website, did you read it?

 

Also, you can easily export just a couple of items - just change the export filter to "Not published only" and unpublish some items before the import:

hrj_200x0.png


  • 0

#3 zarzon56640

zarzon56640

Отправлено 05 August 2014 - 12:01

Yes, I read that when i exported a model and the imported back, it works perfectly but if I changed this model or if I delete one or several line of the CSV template, it is no longer recognized


  • 0

#4 zarzon56640

zarzon56640

Отправлено 05 August 2014 - 12:10

For the export in unpublishes, mode, it works, now the goal is to update this table after the creation of new fields by using the name as the key-reference


  • 0

#5 Kess

Kess

Отправлено 06 August 2014 - 04:15

So, do you have any problems with that? You can use a name as a key during import configuration:

 

ufl_200x0.png

 

And don't forget to make a backup of your website first.


  • 0

#6 zarzon56640

zarzon56640

Отправлено 06 August 2014 - 06:20

The problem is not there no problem to import the csv template exported and reimported, the data are well integrated but if i modified this file by changing a text value for example, the model is no longer taken into account, the idea did not atant to create fields but well proceeds with updates to the fields for additions. Have you a mod-the of csv file to test a creation and this changed file to perform an update?

Cordially


  • 0

#7 Kess

Kess

Отправлено 07 August 2014 - 12:23

What editor do you use to edit these files? I believe your editor incorrectly saves them. Try to change some values using simplest editor possible, like Notepad, for example.


  • 0

#8 zarzon56640

zarzon56640

Отправлено 12 August 2014 - 06:27   Лучший Ответ

Good the problem is resolved, I used excel to create the fields, and it should be just a little careful during conversion to CSV file. It must be absolutely do not allow a semicolon trainer and well all replace by commas. Thank you for your help, now I can add new values by tranche of 10,000.

Cordially,

SC 

http:hortus-botanique.fr


Сообщение отредактировал zarzon56640: 12 August 2014 - 06:28

  • 0




Click to return to top of page in style!