What are the Slack Archives?
It’s a history of our time together in the Slack Community! There’s a ton of knowledge in here, so feel free to search through the archives for a possible answer to your question.
Because this space is not active, you won’t be able to create a new post or comment here. If you have a question or want to start a discussion about something, head over to our categories and pick one to post in! You can always refer back to a post from Slack Archives if needed; just copy the link to use it as a reference..
Hi Team, I am facing issues with storing large amount of data in csv file as it crosses the limit of
Hi Team,
I am facing issues with storing large amount of data in csv file as it crosses the limit of content in single cell. Any suggestion how i can store that data.
Comments
-
Where does the limit comes from? To my knowledge there is no limit for CSV columns.
If you tried to open the CSV via Excel and got a limit error, that can be the case as Excel only is able to display ~32.000 characters per cell.
If that's the case, try to open your CSV in a simple text editor.If the limit is on PHP side, search for
fgetcsv
where the second parameter is set to any non Null/0 value and remove set it to Null/0 to remove those limits,0 -
The csv file itself shouldn't have any limits. Sounds more like the limit is coming from the application you're using to create those files or the target database column.
0 -
It’s also possible to create an import reader for different file formats. Maybe an XML stream would be better for huge data files, or have separate files per cell if they are that big.
0
Categories
- All Categories
- 42 Getting Started & Guidelines
- 7 Getting Started in the Community
- 8 Additional Resources
- 7 Community Ideas and Feedback
- 75 Spryker News
- 924 Developer Corner
- 783 Spryker Development
- 88 Spryker Dev Environment
- 362 Spryker Releases
- 3 Oryx frontend framework
- 35 Propel ORM
- 68 Community Projects
- 3 Community Ideation Board
- 30 Hackathon
- 3 PHP Bridge
- 6 Gacela Project
- 25 Job Opportunities
- 3.2K 📜 Slack Archives
- 116 Academy
- 5 Business Users
- 370 Docker
- 551 Slack General
- 2K Help
- 75 Knowledge Sharing
- 6 Random Stuff
- 4 Code Testing
- 32 Product & Business Questions
- 70 Spryker Safari Questions
- 50 Random